Hi,
I wanted to thank everyone for chipping in on this one...
you gave me some good ideas and eventually solved
my problem, first I what I needed was a form precursor to
the '#search_string#' because it was a form...secondly
swapping out the = for a LIKE and a coupla % signs did the
trick in the WHERE statement. So yippee....!!!! THank you.
><CFQUERY Name="knowledge" DataSource="ccmast">
>select id, entered_date, synopsis, knowledge
>from nxsknow
>where knowledge = '#search_string#'
>order by entered_date desc
></CFQUERY>
I dont know where or how the synopsis column crept into this thread
except when I introduced it as alternative to search on....but the column
I really need to search on is the knowlede column. Synopsis is next
to useless....right now it produces a result thanks to the suggestions of
you folks and that is what I need - results. however when this baby goes
live in another month...I need to be able to search the knowledge column
yet each and everytime that I do...no matter what language I put
after the WHERE knowledge ... I get the following error:
>> [microsoft][ODBC SQL Server Driver][SQL Server]TEXT and IMAGE datatypes
>> may not be used in the WHERE or HAVING clause, except with the LIKE
>> predicate and the IS NULL predicate.
This is a SQL 6.5 database. The column is a TEXT column. If that means
anything to anyone. There is no upper limit to the text on this column...
Why am I getting this error ?
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
