Thanks. Good thing I asked then because my understanding was wrong. SO you'd use that to force a NULL into a column that already had a value perhaps.
Cheers Mike Kear On Thu, Sep 25, 2008 at 3:25 PM, Mark Mandel <[EMAIL PROTECTED]> wrote: > > If you set NULL="true", it will ALWAYS send null to the DB. > > Mark > > On Thu, Sep 25, 2008 at 2:23 PM, Mike Kear <[EMAIL PROTECTED]> wrote: >> >> 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 >> >> > >> > > > > -- > E: [EMAIL PROTECTED] > W: www.compoundtheory.com > > > > -- 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 -~----------~----~----~----~------~----~------~--~---
