><CFQUERY Name="knowledge" DataSource="ccmast">
>select id, entered_date, synopsis, knowledge
>from nxsknow
>where knowledge = '#search_string#'
>order by entered_date desc
></CFQUERY>
There's a couple of possibilities that occour to me offhand...
1.) Case sensitivity - if everything in your DB is uppercase, try using
where knowledge LIKE '#ucase(search_string)#'
2.) Unless you put in wildcards, using 'LIKE' will ONLY match on an EXACT
string; thus:
where knowledge = 'foobar'
would match 'foobar', but NOT 'boofoobar', 'foobarbaz', 'FOOBAR', etc.
If you wildcard with a percent sign, however:
where knowledge = 'foobar%'
Then the query would match 'foobar' AND 'foobarbaz'.
At least, it's a percent sign in Oracle. I seem to recall having seen an
asterisk used elsewhere, but I'm not certain.
HTH...
Brandon Whitaker
[EMAIL PROTECTED]
-------
"It'll get used by the same people using Opera. People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts
"The net interprets censorship as damage and routes around it."
- John Gilmore
------------------------------------------------------------------------------
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.
