What is wrong with this

[Paul M]

Hi
I keep getting this database error but I can't see anything wrong
can you help
Paul M
here is the sql

SELECT Amount_required, Sponsorship_type, Geographical_location,
Short_description, Project_ID FROM Results WHERE (charity_cause LIKE
'%::charity_cause::%' AND Amount_required < ::Amount_required:: AND
Sponsorship_type LIKE '%::Sponsorship_type::%' AND Geographical_location
LIKE '%::Geographical_location::%')



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.

 

[Paul M]

I have sorted it
I didn't put charity_cause in the select part of the sql
Paul M

 

[Mark Fitzpatrick]

Paul,
For performance, you may want to place the Amount_required part of the
where clause as the first item. Since it's a numeric comparison it will save
some db processing by avoiding the LIKE predicate (which is a more expensive
operation) except on those records that have already passed the numeric test
of Amount_required.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage