cfif to select a query
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...
brian williams
Last Activity: Dec 16 '10, 03:00 PM
Joined: Dec 2 '10
Location: Spartanburg,SC
-
Null value issue
I have a problem where the Approved value (SQL) has a 1,0 or NULL value. I can not figure out how to show the null value when returned for the filtered input.
...Code:<cfset vApproved = 0> <cfif isDefined("form.cboApproved")> <cfif form.cboApproved eq ""> <cfset vApproved = 0> <cfelse> <cfset vApproved = #form.cboApproved#> </cfif> -
Problem with db.OpenRecodset(StrTblDate)
Hello there. I could use some help on a VBA issue I am encountering. I have adopted a system that needs to be modified, but I can figure out why this keeps breaking on this one spot and I can't figure out where to go. Everything I try to enter information in from a form, I error out on the same section Set rs1 = db.OpenRecordse t(strtblDate). I could use a direction to find the answer.
Thanks!
...Code:Private Sub txtAccept_Exit(Cancel
No activity results to display
Leave a comment: