RE: Insert NULL Values in SQLSERVER.

2001-01-29 Thread Duane Boudreau
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

Re: Insert NULL Values in SQLSERVER.

2001-01-29 Thread Joe Sheble aka Wizaerd
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 = ' ', >

RE: Insert NULL Values in SQLSERVER.

2001-01-29 Thread Bud
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

Re: Insert NULL Values in SQLSERVER.

2001-01-29 Thread Bud
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? --

RE: Insert NULL Values in SQLSERVER.

2001-01-29 Thread Rick Lamb
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

RE: Insert NULL Values in SQLSERVER.

2001-01-29 Thread Cruz, Joseph
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. > > >

RE: Insert NULL Values in SQLSERVER.

2001-01-29 Thread Phoeun Pha
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

RE: Insert NULL Values in SQLSERVER.

2001-01-29 Thread Russel Madere
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

Re: Insert NULL Values in SQLSERVER.

2001-01-29 Thread Clint Tredway
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

Insert NULL Values in SQLSERVER.

2001-01-29 Thread Bosky, Dave
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