So do I have to turn the "Quote Value" to FALSE for all TEXT fields that I want to be able to insert a NULL for UPDATE or INSERT actions and then use the following?
<@ifempty "<@arg foo">NULL<@else><@sq><@arg foo><@sq></@if> 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: [email protected] 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 President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> - [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> http://bighead.net/ <http://bighead.net/> - http://eventpix.com/ <http://eventpix.com/> On Apr 7, 2008, at 12:21 PM, Robert Garcia wrote: Then do this in the field you are inserting data into: <@ifempty "<@arg foo">NULL<@else><@arg foo></@if> -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> - [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> http://bighead.net/ <http://bighead.net/> - http://eventpix.com/ <http://eventpix.com/> On Apr 7, 2008, at 12:15 PM, Fogelson, Steve wrote: Hi Robert, That would be a great idea, but I only see the "Include Empty" option in the READ action. I don't see it in the WRITE or UPDATE action. I 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] <mailto:[EMAIL PROTECTED]> ] Sent: Monday, April 07, 2008 1:59 PM To: [email protected] <mailto:[email protected]> 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 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 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> - [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> http://bighead.net/ <http://bighead.net/> - http://eventpix.com/ <http://eventpix.com/> On Apr 7, 2008, at 11:48 AM, Fogelson, Steve wrote: 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 <@arg xxxxx> where <@arg xxxxx> is empty, but MySQL doesn't write a NULL to the field. Is this correct? If so, is my only option to write a \N in the field if I am using MySQL? Thanks in advance. Steve Fogelson Internet Commerce Solutions ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf <http://www.witango.com/developer/maillist.taf> ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf <http://www.witango.com/developer/maillist.taf> ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf <http://www.witango.com/developer/maillist.taf> ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf <http://www.witango.com/developer/maillist.taf> ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
