frontpage 2000

I am not kind of new to the database creation thing but i have follwied the wizards instructions and designed what i needed in terms of a datrabase but when i noiw go back to enter data into the database and then retrieve it using the form that the wizard creats for me i am dumbfounded to see that there is nothing in the database and that i am unable to retrieve any data from the database any way, are there any hidden details that i should know?

Goodluck Okonko

 

this is the message on my search page on my url www.thenigerianphonebook.com



Sex Title FirstName Middlename Lastname Nickname Age Phoneno PSP Handsetmake Model Emailaddress emailprovider Houseno Street Town State
Database Results Error
Description: Syntax error (missing operator) in query expression '(Sex = 'Male' AND Title = 'mr' AND FirstName = 'Goodluck' AND Middlename = 'Musa' AND Lastname = 'Ola' AND Nickname = 'Okon' AND Age = '20' AND Phoneno = 08033798031 AND PSP = 'Mtn' AND Handsetmake = 'Nokia' AND Model = '2100' AND Emailaddress '.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

what is wrong?


Goodluck Okonko

 

quote:Originally posted by thenigerian

this is the message on my search page on my url www.thenigerianphonebook.com



Sex Title FirstName Middlename Lastname Nickname Age Phoneno PSP Handsetmake Model Emailaddress emailprovider Houseno Street Town State
Database Results Error
Description: Syntax error (missing operator) in query expression '(Sex = 'Male' AND Title = 'mr' AND FirstName = 'Goodluck' AND Middlename = 'Musa' AND Lastname = 'Ola' AND Nickname = 'Okon' AND Age = '20' AND Phoneno = 08033798031 AND PSP = 'Mtn' AND Handsetmake = 'Nokia' AND Model = '2100' AND Emailaddress '.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

what is wrong?


Goodluck Okonko
</blockquote id="quote"></font id="quote">
Just a wild guess : Phoneno has text format (since it starts with 0...). In a query, you should quote the text you are looking for. So try '08033798031' instead.

Good luck

--
Steurm
www.steurm.net/steurm

 

This is the query statement:
SELECT * FROM Results WHERE (Sex = '::Sex::' AND Title = '::Title::' AND FirstName = '::FirstName::' AND Middlename = '::Middlename::' AND Lastname = '::Lastname::' AND Nickname = '::Nickname::' AND Age = '::Age::' AND Phoneno = :honeno:: AND PSP = ':SP::' AND Handsetmake = '::Handsetmake::' AND Model = '::Model::' AND Emailaddress = '::Emailaddress::' AND emailprovider = '::emailprovider::' AND Houseno = ::Houseno:: AND Street = '::Street::' AND Town = '::Town::' AND State = '::State::') ORDER BY Sex ASC,Title ASC,FirstName ASC,Middlename ASC,Lastname ASC,Nickname ASC,Age ASC,Phoneno ASC,PSP ASC,Handsetmake ASC,Model ASC,Emailaddress ASC,emailprovider ASC,Houseno ASC,Street ASC,Town ASC,State ASC

Thanks


Goodluck Okonko

 

The error message is now gone but i am stil unable to retrieve files from the database.........what now?

Goodluck Okonko

 

Yes i ean the results from the query, also i deleted two columns from the results table and also from the search form now i have a different kind of error message:
Database Results Error
Description: No value given for one or more required parameters.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

how can i sort this out?


Goodluck Okonko

 

Okay......now i have redone the form and the database, and i am actually getting the data into the results form as should be, but....still i can not retrieve any data from my query even though there is no error message, check it out yourself www.thenigerianphonebook.com []

Goodluck Okonko