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] - [EMAIL PROTECTED]
http://bighead.net/ - 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]
Sent: Monday, April 07, 2008 1:59 PM
To: [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] - [EMAIL PROTECTED]
http://bighead.net/ - 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
________________________________________________________________________
TO UNSUBSCRIBE: Go to 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
