frontpage 2000

[thenigerian]

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

[bruce]

Please post URL to your page and error message.

[b]quote:Originally posted by thenigerian

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
</blockquote id="quote"></font id="quote">

[bruce]

Are you using Frontpage database wizard and you customized the query?

The query you are using is invalid. Open the custom query and post it here. I may be able to help you clean it up.


[b]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">

[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

[steurm]

[b]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

[thenigerian]

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 = ::Phoneno:: AND PSP = '::PSP::' 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

[bruce]

In your query, it shows that phoneno & houseno is of integer data type. When you leave these file blank, the query will fail.

You application actually will work if you put some number in both these fields.

To solve it, i suggest you either

1) Change the data type to chars.

or

2) check to make sure user fill out these fields (and the input must also be valid).


[b]quote:Originally posted by thenigerian

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 = ::Phoneno:: AND PSP = '::PSP::' 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
</blockquote id="quote"></font id="quote">

[thenigerian]

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

Goodluck Okonko

[bruce]

What do you mean by retrieving files?

You mean result from the query?

[b]quote:Originally posted by thenigerian

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

Goodluck Okonko
</blockquote id="quote"></font id="quote">

[thenigerian]

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

[bruce]

Sounds like your form is messed up now.

I suggest you redo your form

[b]quote:Originally posted by thenigerian

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
</blockquote id="quote"></font id="quote">

[thenigerian]

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