Problem with SQL Server 2000
-
Hi guys
I am a new guy to the forum and I need your help.
We are hosting a website but the system works fine until we use make a search. But this search works well and only doesn't work when we make a specific search, while all other search keeps working fine.
I have attached the error messages below and I will we very gladful if you would come up with any kind of suggestions.
An unhandled coldfusion application error has occured. Details are as follows :
Time : 10/21/05 15:55:49
Diagnostics : ODBC Error Code = 01000 (General warning)<P>
[Microsoft][ODBC SQL Server Driver][SQL Server]Select candidatemaster.cnd_id, candidatemaster.cnd_update_date
from candidatemaster inner join candidateresume on candidatemaster.cnd_id=candidateresume.cnd_id
inner join countrylist on candidatemaster.ctry_id=countrylist.ctry_id
inner join category ct1 on cat_id1=ct1.cat_id
left join category ct2 on cat_id2=ct2.cat_id
left join category ct3 on cat_id3=ct3.cat_id
WHERE (((CND_CITY Like '%as%') OR (ctry_name Like '%as%') OR (CND_RECENTJOB Like '%as%') OR<P><P><p>The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (254:4) to (254:94).</p>
Browser : Mozilla/4.0 (compatible; MSIE 6.0;
Windows NT 5.0;
NET CLR 1.1.4322)
Thank You
Kumar
-
"WHERE (((CND_CITY Like '%as%') OR (ctry_name Like '%as%') OR (CND_RECENTJOB Like '%as%') OR"
Could it be the extra "OR" on the end of the WHERE clause?
--------------------
Colt 45 - the original point and click interface
-
Yes - it appears that for this particular search, the last option is not selected at all!!!
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply