Verity search error

[Guest]

i have set up a verity collection and indexed it but now i get this error when i run the query page

any ideas what i need to do?

Error Executing Database Query.
Communication link failure: Unknown command

The error occurred in EnquiryResultsInner.cfm: line 25

23 : </CFIF>
24 : ORDER BY EqSurname
25 : LIMIT #start_record#, #records_per_page#
26 : </cfquery>

[Guest]

I presume you are using MySQL, since LIMIT is not a valid construct in "conventional" SQL. Could you post the actual SQL SELECT as parsed by ColdFusion?

[Guest]

Hi, yes i am using mysql.

not sure what you mean by the atcual SQL SELECT as parsed by ColdFusion?

[Guest]

I'd like to see what LIMIT #start_record#, #records_per_page# evaluates to.

[Guest]

ok thats all the code in the first post, i am not sure what else to show?

if you mean what the actual page shows when requested, all i get is the error above in post 1

[Guest]

What is the value of start_record immediately before the <CFQUERY> that is failing?

[Guest]

What is the value of start_record immediately before the <CFQUERY> that is failing?

[Guest]

ok the value is 0

but i am not sure what that means, i havnt used verity before?

can you help

just to let you know what i need to do,

i have a results page which show 1 surname with all that persons information, on the same page there is a search by surname text box, when this is submited i need to move to the first recoed that matches the text box, so then i can still use the next and previous buttons to navigate through.

so really what i need to do is get all the records order them by surname then give each of them a id number

so Abbot = 1, Adcock= 2 etc

then i should be able to use the next and previous to go through them?

i am just not sure how i can do this?

hope you can usnderstand what i am trying to do.

many thanks