search function error - Site bugs & feedback forums

Forums - Site bugs & feedback

Subject: search function error

Viewing all 8 messages - View by pages of 10: 1

Original Message 1/8 19-Oct-04 @ 09:32 PM - search function error

milan

Posts: 5701

Link?: Link

File?: No file

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

[ back to forum ] [quote]

Message 2/8 19-Oct-04 @ 09:32 PM - RE: search function error

milan

Posts: 5701

Link?: Link

File?: No file

(while using IE6 fyi)

[ back to forum ] [quote]

Message 3/8 19-Oct-04 @ 09:40 PM - RE: search function error

nutoniom

Posts: 1345

Link?: Link

File?: No file

while you're at it k, is it possible to get a user definable date range ?

pretty please

[ back to forum ] [quote]

Message 4/8 19-Oct-04 @ 10:02 PM - RE: search function error

Posts: 12353

Link?: Link

File?: No file

sure, i'm still working it - done soon - yes, you mean a daterange where you add start & end date yes?

___________________________________

I had an idea for a script once. It's basically Jaws except when the guys in the boat are going after Jaws, they look around and there's an even bigger Jaws. The guys have to team up with Jaws to get Bigger Jaws.... I call it... Big Jaws!!!

[ back to forum ] [quote]

Message 5/8 19-Oct-04 @ 10:19 PM - RE: search function error

nutoniom

Posts: 1345

Link?: Link

File?: No file

yup, exactly. if it's not too much trouble of course

[ back to forum ] [quote]

Message 6/8 20-Oct-04 @ 06:48 PM - RE: search function error

nutoniom

Posts: 1345

Link?: Link

File?: No file

thanks k ! well done. 'tho you'll have to update the code as years pass, no?

the quote preview is great, many thanks again

[ back to forum ] [quote]

Message 7/8 20-Oct-04 @ 07:38 PM - RE: search function error

Posts: 12353

Link?: Link

File?: No file

quote
the quote preview is great, many thanks again

indeed - bow down before your master!!!!

___________________________________

[ back to forum ] [quote]

Message 8/8 20-Oct-04 @ 09:38 PM - RE: search function error

nutoniom

Posts: 1345

Link?: Link

File?: No file

he he

[ back to forum ] [quote]

Viewing all 8 messages - View by pages of 10: 1

There are 8 total messages for this topic

Reply to Thread

You need to register/login to use the forum.

Click here to Signup or Login !

[you'll be brought right back to this point after signing up]

Back to Forum