Your code would insert a blank space. Sounds like you need something like
this:
<CFIF trim(ListGetAt(Phone,x)) contains "n/a">
Phone = null,
<CFELSE>
Phone = '#ListGetAt(Phone,x)#',
</CFIF>
-----Original Message-----
From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 12:57 PM
To: CF-Talk
Subject: Insert NULL Values in SQLSERVER.
I was trying to insert a blank or null value into the table,
if the current list item contains 'n/a'. Not having much
success this afternoon.
<CFIF trim(ListGetAt(Phone,x)) contains "n/a">
Phone = ' ',
<CFELSE>
Phone = '#ListGetAt(Phone,x)#',
</CFIF>
Thanks,
Dave
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists