I absolutely cannot figure out what I am doing wrong. If you're an ASP pro, I would appreciate any help. I am working on a site that has a "dealer search" page where you type in the city or town you are in and the page will access an Access database and produce a list of dealers according to your search criteria that you typed into the input form.
I was asked to take the site out of a frames environment which was easy enough, but loading it into FrontPage 97 and copying the input table precisely from the version that works to the frame-less version, the query no longer worked. I set up the page on the server end and named the database properly just cannot seem to access it without errors:
Here is the page that DOES work properly, but its originally in frames, which I am to remove:
http://www.odorlos.com/find_a_dealer_search.aspThe page above does what its supposed to do, however, even viewing the source of the code and just changing a simple table seems to throw the whole thing off. I've tried FTP'ing the source code, saving it in FrontPage...everything I could think of and its still not working.
Here is a copy of my page...this is a template for the page after I removed the frames. I need the finished page to look exactly like this, but work properly when it comes to the search:
http://www.odorlos.com/dealers/find_a_dealer_search500.aspI went as far as to re-upload the Access 97 database and start fresh using FrontPage Database Region Wizzard. I think my problem is with connectivity somewhere and the SQL code to properly correspond with the database. Also, I don't think the input form is working now as well. This page is a mess and any help would be appreciated.
Here is the database region code I have:
SELECT * FROM "2003partners" WHERE (STATE = '::STATE::' OR COUNTRY = '::COUNTRY::' OR CITY = '::CITY::') ORDER BY ZIP ASC
Provider=Microsoft.Jet.OLE
DB.3.5;Dat
a Source=D:\64.224.167.42\de
alers\a1de
alers.mdb;
User ID=;Password=;
Thanks,
Phil
Start Free Trial