On 1/29/01, Russel Madere penned:
>Try this:
>
>
> Phone = NULL,
>
> Phone = '#ListGetAt(Phone,x)#',
>
>
>This will UPDATE with a NULL value on MS SQL.
One thing you have to be careful about, I found out the hard way, is,
if you do a search later on:
WHERE Phone = '', it won't retur
How about:
>
> Phone = NULL,
>
> Phone = '#ListGetAt(Phone,x)#',
>
At 01:56 PM 1/29/01 -0500, you wrote:
>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.
>
>
> Phone = ' ',
>
On 1/29/01, Russel Madere penned:
>Try this:
>
>
> Phone = NULL,
>
> Phone = '#ListGetAt(Phone,x)#',
>
>
>This will UPDATE with a NULL value on MS SQL.
One thing you have to be careful about, I found out the hard way, is,
if you do a search later on:
WHERE Phone = '', it won't retur
On 1/29/01, Bosky, Dave penned:
>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.
>
>
> Phone = ' ',
>
> Phone = '#ListGetAt(Phone,x)#',
>
Do you have the cell set to allow null values?
--
nsert 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.
Phone = ' ',
Phone = '#Li
January 29, 2001 1: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.
>
>
>
instead of ' ', try just do NULL (not quotes)
it should work
-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
http://www.TurboSquid.com
Some days you eat the bear; some days the bear eats you.
> -Original Message-
> From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 29, 2001 12:57
> To: CF-Talk
> Subje
Try this:
--
Clint Tredway
www.factorxsoftware.com
--
~~
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/
U
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.
Phone = ' ',
Phone = '#ListGetAt(Phone,x)#',
Thanks,
Dave
~~
Structure your ColdFusi
10 matches
Mail list logo