<cfquery datasource="..." name="...">
insert into (column_name)
values ( <cfif value_name is "">
null
<cfelse>
'value_name')
</cfquery>
----- Original Message -----
From: "David Clay" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 12:33 PM
Subject: NULLs
> I would like to insert a NULL value into a SQL 7 table if a field is not
filled in.
>
> How do I go about doing this? Is this a wise thing to do? Why doesn't
SQL 7 automatically do that?
>
> Any help would be greatly appreciated. Thank you fro your time.
>
> Dave Clay
> Internet Facilitator
> Trus Joist, A Weyerhaeuser Business
> 5995 Greenwood Plaza Blvd, Suite 100
> Greenwood Village, CO 80111
> 303.770.8506
> 303.770.8506
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
