Tom,
I don't have 5.5. up and running otherwise I would try to reproduce it too.
/John
Tom Storey wrote:
I've been watching the list for some response to this problem, but
have seen nothing. Is no one else having this problem and I'm just
missing something or is this a problem? I've emailed support, but I've
not received anything from them ether.
Tom Storey wrote:
Hi
I'm having the quoting problem right now on 5.5. I've moved some of
my programs that I was running on 5.0 to 5.5. Now all of the updates,
that use text fields in my db, have to be quoted, in criteria box,
before the update will work. I've made a small test .taf to test this
and you can't use a <@var> in criteria box because if you quote it
<@var> shows up not it's value.
Tom
John McGowan wrote:
noSQLEncoding should only affect the behavour of a directDBMS
action. An update action should not be affected.
I've had to use the same method that Trevor mentions below and it
has always worked on 5.0. I've yet to upgrade to 5.5 so I can't
comment on whether or not it works for me, but now I'm worried about
it.
Trevor, please raise this as a bug with Witango if you can easily
reproduce it.
/John
Ben Johansen wrote:
Can you explain why you need the quotes when it is a char field?
Have you tried the noSQLEncoding switch
Around the update action
Ben
------------------------------------------------------------------------
*From:* Trevor Green [mailto:[EMAIL PROTECTED]
*Sent:* Friday, October 15, 2004 6:20 PM
*To:* [EMAIL PROTECTED]
*Subject:* Witango-Talk: problem with quote value and 5.5 server
I have a problem with 5.5 on Mac OSX server and MySql. I have an
update action with a field which is has the Quote value attribute
set to false. I am trying to update the field with the following
expression
<@ifempty <@arg ownership>>null<@else>'1'</@if>
i.e. sql should read /field=null/ or /field=’1’/ depending on the
value of ownership. This worked fine on 5.0 but since upgrading to
5.5 the server insists on quoting even when quote value is set to
false. So, I either get a value of null (i.e. the word null being
stored in the field – which is a char field) or the value ‘1’ (i.e.
quote 1 quote) instead of having an empty field or a field with the
value of 1. Has anyone else experienced this?
Trevor Green
________________________________________________________________________
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.ta
f
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
