Miles try adding a % sign to your LIKE statement
WHERE knowledge = '#search_string#%'
----- Original Message -----
From: "miles" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 12, 2000 12:23 PM
Subject: searches failing...help.
> Hi,
>
> Ive got myself a tiny problem...which should be a snap for
> you folks that are more skilled than myself right now...
>
> <CFQUERY Name="knowledge" DataSource="ccmast">
> select id, entered_date, synopsis, knowledge
> from nxsknow
> where knowledge = '#search_string#'
> order by entered_date desc
> </CFQUERY>
>
> this query will fail each and every time with 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.
>
> HOWEVER when I change the WHERE statement to the following...
>
> where knowledge LIKE '#search_string#'
>
> I get no results. It doesn't matter what I enter as a variable.
> I should get something back....shouldn't I ?
>
> The somewhat annoying part about this is if I change the where
> statement to the following
>
> where id = '#search_string#'
>
> and id is equal to some number...this query works...and pulls up a
> single record...or if I change the where statement to
>
> where synopsis = '#search_string#'
>
> and synopsis is equal to "site". It returns nothing....it should
> return something
> because half the entries in this table half the word "site" in the
> field synopsis.
>
> And before you think that there's nothing in the table...there is plenty
> of data. What's up with this query...why is this happening ? Any
> clues ?
>
> Miles.
> --------------------------------------------------------------------------
----
> 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.
>
------------------------------------------------------------------------------
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.
