<cffunction name="updateNull" ... >
<cfquery name="queryname" datasource="#_getConfig().getDsn()#">
update table
set column = ''
where pk = #getPK()#
</cfquery>
</cffunction>
Your null assignment will be based upon which DB you use.
That was silly of me. Another cup of java for me.
T
On 7/14/06,
Peter Boughton <[EMAIL PROTECTED]> wrote:
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--
<cf_payne />
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
