Then this is a side effect of using reactor that you need consider. :) It seemed like the best option to me.
Thanks, Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Boughton Sent: Friday, July 14, 2006 9:16 AM To: [email protected] Subject: Re: [Reactor for CF] updating a column to NULL What happens if you *want* to put an empty string into a nullable field? (not something I've ever needed so far, but would be nice to know if/when the occasion arises) -- Peter On 7/14/06, Doug Hughes <[EMAIL PROTECTED]> wrote: > > > > Gareth, > > > > I know I'm the author of Reactor so I should know the answer to things like > this for sure, but I'm only 99% sure this will work: > > > > If you have a column that accepts null values and you provide an empty > string Reactor should translate this to a null value on insert or update. > > > > Doug > > > ________________________________ > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Gareth Cole > Sent: Friday, July 14, 2006 8:44 AM > To: [email protected] > Subject: RE: [Reactor for CF] updating a column to NULL > > > > > Hi Folks, > > > > My apologies for posting this again, but I'm really stuck. > > Reactor has been really great for my current project and saved me loads of > time, but until I figure out a way of doing this, I can't launch the site. > > > > Basically what I want to do is: > > > > myRecord = reactor.createRecord("MyTable"); > > myRecord.setMyPK(1); > > myRecord.load(); > > > > myRecord.setMyCol(null); // where my 'myCol' is an integer database table > that can be null > > myRecord.save(); > > > > The problem is setting the column to null. Not passing an argument throws an > error, likewise does passing an empty string. > > > > I'd really appreciate if someone could show me how to do this with reactor, > or at least point me in the right direction. I'd imagine this is a fairly > common database task, so someone must have tried this before. > > > > Thanks, > > > > Gareth > > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Gareth Cole > Sent: 13 July 2006 18:04 > To: [email protected] > Subject: [Reactor for CF] updating a column to NULL > > > > Hi, > > > > one of my tables has an integer column 'myCol' that can be NULL. > > > > I can set this to an integer, but I'm having trouble setting it to NULL: > > > > setMyCol() throws an error because there's no argument passed > > setMyCol("") throws an error because the argument isn't numeric > > > > How can I do this using reactor? > > > > Thanks > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- > Reactor for ColdFusion Mailing List > [email protected] > Archives at: > http://www.mail-archive.com/reactor%40doughughes.net/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- > Reactor for ColdFusion Mailing List > [email protected] > Archives at: > http://www.mail-archive.com/reactor%40doughughes.net/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- > Reactor for ColdFusion Mailing List > [email protected] > Archives at: > http://www.mail-archive.com/reactor%40doughughes.net/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
