RE: Val() doesn't work like I need it to

[Olive, Christopher M Mr USACHPPM]

i would recommend doing something like this...


<TD>$<INPUT NAME="fred"></TD>

this way, the user will see the $ sign, and the db will only see the number.
solves both problems. :)

btw, in an email before this,  KC Chapman incorrectly says that
VAL("123boy") resolves to 1.  it resolves to 123.  the "Returns a number
that the beginning of a string can be converted to" in the docs refers to a
*sequence* of numbers at the beginning of the string, not just the first
number.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-----Original Message-----
From: Reuben King [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 08, 2000 2:50 PM
To: [EMAIL PROTECTED]
Subject: RE: Val() doesn't work like I need it to


In 
<[EMAIL PROTECTED]>, 
"Olive, Christopher M Mr USACHPPM" ("Olive, Christopher M Mr USACHPPM") 
in a fit of unbridled passion, wrote:
> why are there dollar signs there in the first place?  the dollar sign
> display should be a separate entity from the actual number.  what are you
> trying to do?

I have a form with a text field that asks for a dollar value.  I need to 
parse that into a real number for insertion into an Oracle NUMBER(10,2) 
column.

Thanks,
-RK
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.