Original
Message 1/8
Date: 19-Oct-04 @ 09:32 PM -
search function error
K, i got this while trying to use the 'search in message text' function:
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly.
SQL = "SELECT messages.subject, messages.thread_id, messages.posted AS grandeee FROM messages WHERE 0=0 AND messages.body LIKE '%happy glasses%' and threads.LastPosted > (Now()-30) order by messages.posted desc"
Data Source = "DT_2001"
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (90:1) to (90:49) in the template file C:\httpd\htdocnew\dancetech\aa_dt_new\forums\Results.cfm.
Date/Time: 10/19/04 21:30:03
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Remote Address: 80.110.222.123
HTTP Referer: http://www.dancetech.com/aa_dt_new/forums/Results.cfm