RE: [Reactor for CF] updating a column to NULL

[Gareth Cole]

Sorry, I’m a complete idiot….   I’ve just realized, that a while back, I over-wrote the setter method with my own custom method. I didn’t realize that reactor makes all arguments as strings, regardless of datatype. In my own method, I’d set the type to numeric. Problem fixed now.   Anyway, keep up the good work Doug, reactor is great.   Thanks   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hughes Sent: 14 July 2006 13:57 To: reactor@doughughes.net Subject: RE: [Reactor for CF] updating a column to NULL   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: reactor@doughughes.net 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: reactor@doughughes.net 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 reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --