I'm afraid that either I'm a bit dense today or the CF8 docs are a bit vague on this .. but is my understanding correct? Can someone please tell me if the following statement is correct or not? :
IN a CFQUERYPARAM, if you put NULL="yes", it will send a NULL value to the database if you have no value Or in other words, i have a cfquery that includes the following: InvoiceNo = <cfqueryparam value="#invoiceno#" NULL="yes" cfsqltype="cf_sql_integer"/> If the current value of #invoiceno# is "", (i.e. no value) the cfqueryparam will send to the database the following; Invoiceno = NULL Is my understanding correct? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
