I wanted to use...
<cfquery name="findsyn" datasource="cf examples1">
select stock, title, url, company, subcatalog, synopsis
from movies
where synopsis = 'X'
</cfquery>
but synopsis was a text field. I had to resort to
<cfquery name="findsyn" datasource="cf examples1">
select stock, title, url, company, subcatalog, synopsis
from movies
where synopsis is not null
</cfquery>
<cfif trim(synopsis) is "x">
bla bla bla
</cfif>
It was slower, but it worked.
I do not know if this would be the best query, but It may work.
<CFQUERY Name="knowledge" DataSource="ccmast">
select id, entered_date, synopsis, knowledge
from nxsknow
where knowledge is not null
order by entered_date desc
</CFQUERY>
<cfif knowledge = "#search_string#">
bla bla bla
</cfif>
jacob
At 01:23 PM 7/12/00 -0400, you wrote:
>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.
