Hi,
I realize you have solved this issue just wanted to mention...
if a different format syntax had been used like
Format="num:,\,,2,.,,,-," (yields 5.00 out of 5)
instead of
Format="num:US-accounting" (yields $ 5.00 out of 5)
Then there wouldn't have to deal with stripping any characters
Ben Johansen - http://www.pcforge.com
Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm
Latest downloads & List Archives @ http://www.witango.ws
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Campbell, Steve V.
Sent: Wednesday, June 05, 2002 7:49 AM
To: Multiple recipients of list witango-talk
Subject: RE: Re: Re: Witango-Talk: Error In Syntax
Hi Scott
It was what Lee suggested. My database was expecting an integer and I
was giving it text. I have figured it out and your code to omit the
space I used and that took care of that problem.
Thanks
Steve
-----Original Message-----
From: Scott Cadillac [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 9:39 AM
To: Multiple recipients of list witango-talk
Subject: Re: Re: Witango-Talk: Error In Syntax
Hi Steve,
Your error may have more to do with the database you're inserting too.
What
datatype is the field?
To remove a space (or any character) from a string, you can do this:
<@OMIT STR="$ 25.00" CHARS=" ">
Let us know if that solves the problem. Cheers...
Scott Cadillac
http://xml-extra.net
[EMAIL PROTECTED]
VP, Research and Development
Plus International Corp.
604-460-1843
[EMAIL PROTECTED]
http://www.plusinternational.com
Vancouver, BC, Canada
Does your company have an Enterprise Information Portal? Check out Salsa
at
www.plusinternational.com/flash/salsa.htm
----- Original Message -----
From: "Campbell, Steve V." <[EMAIL PROTECTED]>
To: "Multiple recipients of list witango-talk"
<[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 5:18 AM
Subject: RE: Re: Witango-Talk: Error In Syntax
I am doing a simple insert into a database and I keep getting a syntax
error on the insertion point.
The error I get is :
Syntax error in query expression '$ 25.00'.
If you notice, there is a space before the 2 and after the $. I have no
idea how to get that space out of there, but, I think if I could figure
out how to get that out, then I wouldn't' have the error.
My code looks like this:
<INPUT NAME="bid_inc" TYPE=TEXT SIZE=10 MAXLENGTH=30 VALUE="<@ARG
Auctions.bid_inc Format=num:US-accounting>">
Thanks
Steve
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
