cfif to select which query to use.
I need some help getting syntax on an issue. I have a listbox with 3 values, True(1), False(0) and Needs Approval(NULL) but I can't seem to get the NULL to show. The SQL column has this as a bit value so a Case adjustment does not work.
What I need this to do is if the Needs Approval value is selected in the cboApproved box then use the 'qRecordsNull" query to get the results, else use the "qRecords" query.
Below is the code that I have that works for true and false. Any help would be greatly appreciated.
<cfset vApproved = 0>
<cfif isDefined("form.cboApproved")>
<cfif form.cboApproved eq "">
<cfset vApproved = 0>
<cfelse>
<cfset vApproved = #form.cboApproved#>
</cfif>
<cfelse>
<cfset vApproved = 0>
</cfif> [/code]
<td>
<select name="cboApproved" class="smallFont">
<!---<option value="All">All</option>--->
<option value="1"
<cfif isDefined("vApproved")>
<cfif vApproved eq 1>
selected
</cfif>
</cfif>
>True</option>
<option value="0"
<cfif isDefined("vApproved")>
<cfif vApproved eq 0>
selected
</cfif>
</cfif>
>False</option>
<option value= "">Need Approval</option>
</select>
</td>
Basically something that looks like this:
<cfif isDefined("form.cboApproved")>
<cfif #form.cboApproved# eq "Needs Approval">
<cfquery name="qRecordsNull"
<cfelse>
<cfquery name="qRecords"
</cfif>
