What is wrong with this

P

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.
 
P

Paul M

I have sorted it
I didn't put charity_cause in the select part of the sql
Paul M
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with wildcard 2
Help with SQL please 1
Error Adding Record with INSERT INTO 4
Database Update Issues 2
Database Results Wizard Error 3
Database Results Error 1
Frontpage Database Error 1
Base Article 817029 4

Top