or use cfqueryparam with attribute null as true.
HTH
On 8/17/06, Ian Skinner <[EMAIL PROTECTED]> wrote:
>
> Personally, I put NULL into the table, or do not update the field if it is
> unnecessary in my code.
>
> <cfquery datasource="oracleDSN">
> UPDATE aTable
> SET This = 'that',
> Foo = 101,
> BAR = NULL
> </cfquery>
>
> OR
>
> <cfquery datasource="oracleDSN">
> INSERT INTO aTable
> (This,Foo,Bar)
> VALUES
> ('That', 101, NULL)
> </cfquery>
>
> I suspect if you showed us your code we could point out where you are
> telling the database to insert empty or whitespace strings into the table.
>
>
>
>
> --------------
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
>
> ---------
> | 1 | |
> --------- Binary Soduko
> | | |
> ---------
>
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
>
> Confidentiality Notice: This message including any
> attachments is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the
> intended recipient, please contact the sender and
> delete any copies of this message.
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250248
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
