Re: Witango-Talk: Null in MySQL

]> wrote: > Robert, Jesse and Robert, > > Thanks for the help. > > Steve > > -Original Message- > From: Ben Johansen [mailto:[EMAIL PROTECTED] > Sent: Monday, April 07, 2008 4:05 PM > To: witango-talk@witango.com > Subject: Re: Witango-Talk: Null in MySQL

RE: Witango-Talk: Null in MySQL

Robert, Jesse and Robert, Thanks for the help. Steve -Original Message- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Monday, April 07, 2008 4:05 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Null in MySQL nope your not missing anything, the setting you have for

Re: Witango-Talk: Null in MySQL

tring when updating or inserting in order for Witango to set it to a NULL. Unless I am missing something. Thanks Steve -Original Message- From: Jesse Parker [mailto:[EMAIL PROTECTED] Sent: Monday, April 07, 2008 3:21 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Null in

RE: Witango-Talk: Null in MySQL

Steve -Original Message- From: Jesse Parker [mailto:[EMAIL PROTECTED] Sent: Monday, April 07, 2008 3:21 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Null in MySQL You might want to check the column definition. A quick test suggests that a default value of NULL works as

RE: Witango-Talk: Null in MySQL

foo><@sq> To insert a “NULL” in a field in MySQL? Seems like a lot of extra work, but I will do it if I need to. Thanks Steve From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Monday, April 07, 2008 2:25 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Null in MySQL Thi

Re: Witango-Talk: Null in MySQL

IL PROTECTED] Sent: Monday, April 07, 2008 2:25 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Null in MySQL This works in a NON Quoted field. You will have to experiment. I have done it before but don't have time to look up old code at the moment. -- Robert Garcia

RE: Witango-Talk: Null in MySQL

t;NULL" in a field in MySQL? Seems like a lot of extra work, but I will do it if I need to. Thanks Steve _ From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Monday, April 07, 2008 2:25 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Null in MySQL This w

Re: Witango-Talk: Null in MySQL

I am missing something. Steve From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Monday, April 07, 2008 1:59 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Null in MySQL I believe you can check to NOT INCLUDE if empty. If you put an empty arg in there, witango will write an empty strin

Re: Witango-Talk: Null in MySQL

also see it in the “Select Rows Matching These Criteria” part of the UPDATE action. I only see “Quote Value” in the WRITE and UPDATE action. Maybe I am missing something. Steve From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Monday, April 07, 2008 1:59 PM To: witango-talk@witango.com Sub

RE: Witango-Talk: Null in MySQL

uot; in the WRITE and UPDATE action. Maybe I am missing something. Steve _ From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Monday, April 07, 2008 1:59 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Null in MySQL I believe you can check to NOT INCLUDE if empt

Re: Witango-Talk: Null in MySQL

I believe you can check to NOT INCLUDE if empty. If you put an empty arg in there, witango will write an empty string "". if the field is NOT included, it will be null. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95

Witango-Talk: Null in MySQL

Hi, I am completing work adjusting an app that was originally written to work with R:Base to now work with MySQL as well. Whenever I write or update a record in R:Base, all empty text fields are written with a NULL. It appears that this is not happening in MySQL, I can set a MySQL text field to