.asp custom SQL Querry problems

[Twinblues]

I have a custom Querry in Frontpage with a .asp page

SELECT *
FROM Products
WHERE miles LIKE '::years::%'
AND
plan LIKE ':lan::%'
AND
type LIKE '::Type::%'
AND
CurrentWarranty LIKE '::CurrentWarranty::'
AND
AWD LIKE '::AWD::%'

I have 4 drop down input boxes on the first page that gives the data for the
database to put the correct information on the results page.
http://www.eservicecontracts.com/336.asp

I keep getting an error now that I have upgraded my office program to Office
2003 sp2. (I am using Frontpage 2003 sp2)

This is the error I get now from my .asp page when you input the data.

Database Results Wizard Error
Your page contains a query with user input parameters that could not be
resolved.
This could happen if your DatabaseRegionStart webbot has an empty or missing
s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.

I have tried article 817029 and the work arounds are not working. I also
have tried 907307.

The web site is http://www.eservicecontracts.com

problem pages are

http://www.eservicecontracts.com/336Results.asp
http://www.eservicecontracts.com/770Results.asp
http://www.eservicecontracts.com/7100Results.asp

If you could give me some help on how to rewrite my SQL Statement to make
this work I would be grateful

Thank you
James Hubers

 

[Mike at Kitcot]

Twinblues,

I guess you have answered your own question in your response to my posting
"Custom Query in FP2003 DRW". Thanks again. But I guess we still don't know
what is actually wrong with the FP2003 versions of the .inc files, do we ?

Mike

 

[Twinblues]

It sure looks like a bug from Microsoft. Their "workarounds" do not seem to
work but going back to the old version does. As you noticed no one from the
microsoft group has responded to the posts. I have installed FP2000 again
on my laptop to do work on web sites that I have custom SQL statements on and
I have FP2003 on my main computer. I am glad I had 2 computers to work with