Mark

Very new to this and not sure. I am using MS Access for the database. Does this help any.

Mark

If you open your database access (not Access) page in FrontPage and click on the HTML tab at the bottom you will see a page with code in it.

Scroll down until you come to some red code. One of the lines will start with this:

fp_sQry="SELECT * FROM ... at least it will start with fp_sQry=

What Spooky the Great is asking is for that sentence starting with fp_sQry=

Hope this helps,

Joe

Thanks for the help. The line is below.

fp_sQry="SELECT * FROM jobs WHERE (Title LIKE '%::Title::%' OR Location LIKE '%::Location::%' OR Pay_Rate = '::Pay_Rate::' OR Required_Skills LIKE '%::Required_Skills::%') ORDER BY Title ASC,Location ASC"

Does this help Spooky?

Thanks,
Mark

If you want to do it all on the same form, the DRW may not be for you - you may have to custom SQL it. However, I'm sure there are many here who could probably answer better.

Joe

I took all but one input out of the search and it works now. Joe, you mentioned putting multiple searches on one page, how would I go about doing that? Would I have to have more than one list of results on the page? Can I have the results of a search come up on a different page? The main page with the search has a lot of text and when the page refreshes with the result it starts back at the top of the page. I don't want the visitors to have to scroll down to see the results. Everyone has been a great help and I would appreciate any more assistance you might have.

Thanks,
Mark

http://www.frontpagewebmaster.com/ubb/Forum6/HTML/001626.html

Database Results Error
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x6e0 Thread 0xc58 DBC 0x24e1024 Jet'.

Does anyone know if this is a server problem or something I am doing wrong? The page is http://www.irs-it.com/candidate.asp

Thanks again for any help you can give.

Mark

I don't know what is going on with your error. Your SQL query looks fine to me. I have had many fields being submitted to the DB with no problems. I would guess that you did not have default values designated for your fields.

What this means is for example you have 3 fields; T1, T2 and T3. If you gave each a default value (it is an option using the DRW) of say "qrzx34yutp", when you made a search and T1 was the field you filled out. T2 and T3 would have an unseen value of "qrzx34yutp" being submitted at the same time.

If T1 was a positive search, you would only return those results because T2 and T3 would turn up negative (provided the Database fields that T2 and T3 are searching do not contain "qrzx34yutp").

If T1 is negative for your search you will get No records returned because T2 and T3 should also be negative.

Spooky gave you a great suggestion of splitting your search form apart from the DRW. If he does not have an answer for your database error and your host claims it is not their problem... I would just rebuild the DRW and include default values.

Backup as much as possible.

Joe

Note the error? Microsoft Access Driver]General error Unable to open registry key

Its a server side registry problem associated with the Access driver.