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
