Ok... another problem..
I have a good boolean code where the user selects one boolean and each +& is
whatever boolean they select... but I'd like to have it set so that the user
can just use &+ for AND, &/ for OR and &* for NOT and the below code seems
to output the proper string but it won't use the code...it only works if i
have none of the boolean codes in it..
Any clue?
Tony Hicks
<cfset
searctext2='%#ReplaceNoCase("#ReplaceNoCase("#ReplaceNoCase(searctext," +&
","%' and Textdata like '%","all")#"," +* ","%' not Textdata like
'%","ALL")#"," +/ ","%' or Textdata like '%","ALL")#%'> <CFQUERY
name='caselist' datasource='thebible' cachedafter='6/01/00'>
Select
BookTitle, chapter, verse, textdata
From
KJV
Where 0=0
<CFIF bookTitle NEQ "">
AND Book='#ReplaceNoCase(bookTitle,",","' OR Book='","ALL")#'
</CFIF>
<CFIF chapter NEQ "">
AND Chapter='#chapter#'
</CFIF>
<CFIF verse NEQ "">
AND verse='#verse#'
</CFIF>
<CFIF searctext NEQ "">
<CFIF boolean is not 'null'>
AND Textdata like '#Replace('#Replace(searctext2,"% ","%","ALL")#',"
%","%","ALL")#'
<CFELSE>
AND Textdata like '%#searctext#%'
</CFIF>
</CFIF>
Order by #sort#
</CFQUERY>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
