ReWrite Query 1

[coldfused]

<cfquery name="getprograms" datasource="#dsn#">
Select * From programs Where w_specs LIKE '%#TheCenter#%'
OR wb_specs LIKE '%#TheCenter#%' 
OR s_specs LIKE '%#TheCenter#%'
OR sb_specs LIKE '%#TheCenter#%'
OR sum_specs LIKE '%#TheCenter#%'
OR sumb_specs LIKE '%#TheCenter#%'
OR f_specs LIKE '%#TheCenter#%'
OR fb_specs LIKE '%#TheCenter#%'

</cfquery>

Is there a cleaner way to write that query and eliminate all of the OR's?

Thanks.

----------------------------------------
Online Marketing - de·ci·phered
Always Learning...

 

[r937]

not really all that much cleaner...

 WHERE  w_specs 
||'~'|| wb_specs 
||'~'|| s_specs 
||'~'|| sb_specs 
||'~'|| sum_specs 
||'~'|| sumb_specs 
||'~'|| f_specs 
||'~'|| fb_specs LIKE '%#TheCenter#%'

r937.com | rudy.ca

 

[coldfused]

Thanks Rudy.

----------------------------------------
Online Marketing - de·ci·phered
Always Learning...

 

[imstillatwork]

coldfused, just FYI - I'm sure you know already...

http://www.tek-tips.com/viewthread.cfm?qid=1346835&page=1

Keep an eye on those variables in SQL if they are coming from user input!

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!