Just a newbie here, but it looks like your value is a string and your
database is expecting a number.
Try converting the value to a number first
Syntax
<@KEEP STR=string CHARS=char [ENCODING=encoding]>
Description
Returns the string specified in STR stripped of all characters except
those specified in CHARS. The operation of this meta tag is case
sensitive. To retain both upper and lower case variations of a character
include both characters in the CHARS.
Each of the attributes to <@KEEP> may include both literal values and
meta tags that return values.
Examples
<@KEEP STR="The quick fox" CHARS="aeiou">
This example evaluates to "euio".
<@KEEP STR="$200.00" CHARS="0123456789.">
This example evaluates to "200.00".
<@KEEP STR="This is the HTML" CHARS="TH">
This example evaluates to "THT".
<@KEEP STR="<COLUMN NAME=Invoice.totalcost>" CHARS="0123456789.">
This example returns the value in the total cost column, stripped of
any non-numeric characters.
Regards,
Len Wright
Plus International Corp
www.plusinternational.com
Direct: 604-415-2384
Fax:604-415-0830
>>> [EMAIL PROTECTED] 06/05/02 05:18AM >>>
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
