Michael Traher
Systems Manager
ICLP (London)
Tel: UK +44 (0) 20 8256 9072
Fax: UK +44 (0) 20 8681 0234
This e-mail may contain privileged and confidential information and/or
copyright material and is intended for the use of the addressee only. If
you receive this e-mail by mistake please advise the sender immediately
by using the reply facility in your e-mail software and delete this
e-mail from your computer system. You may not deliver, copy or disclose
its contents to anyone else. Any unauthorised use may be unlawful. Any
views expressed in this e-mail are those of the individual sender and
may not necessarily reflect the views of ICLP.
-----Original Message-----
From: Sam Fisher [mailto:[EMAIL PROTECTED]
Sent: 26 September 2003 15:04
To: CF-Talk
Subject: Re: convert string of numbers to numeric?
Yes, I set the default value="0".
Thanks,
-S
----- Original Message -----
From: Robertson-Ravo, Neil (RX)
To: CF-Talk
Sent: Friday, September 26, 2003 8:44 AM
Subject: RE: convert string of numbers to numeric?
Is form.var1 a valid string? i.e. is it empty? if it is the its not a
valid
string!
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: 26 September 2003 13:40
To: CF-Talk
Subject: RE: convert string of numbers to numeric?
can you send the whole bit of code? its got to work, there is a way!!!
:) tony
-----Original Message-----
From: Sam Fisher [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 5:21 PM
To: CF-Talk
Subject: Re: convert string of numbers to numeric?
Thanks, Tony. Unfortunately it did not work. The error I continue to
get
is:
The value """" cannot be converted to a number.
I have also tried:
<cfset var1= Val(form.var1 * 1)>
with no success. Any thoughts?
--S
----- Original Message -----
From: "Tony Weeg" <[EMAIL PROTECTED]&g! t;
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 25, 2003 3:33 PM
Subject: RE: convert string of numbers to numeric?
> simply stripping out the .'s maybe?
> or is there something Im not getting?
>
> tony
>
> <cfset newNumber = replace(form.var1,'.',all)>
>
> would do I presume?
>
> -----Original Message-----
> From: Sam Fisher [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 25, 2003 3:30 PM
> To: CF-Talk
> Subject: convert string of numbers to numeric?
>
> Hi Everyone,
>
> I have a problem. I am trying to convert a string of numbers to a
> real
data
> type, unfortunately without success. I read a CF-Talk board
> discussion about it, but was unable to get it to work. Can anyone
> help me. I
created
> an input field:>
> <cfinput type="text" name="v! ar1" ; validate="float"
value="#query.var1#"
> range="0.00,7.00" required="No" size="4" maxlength="4">
>
> Now I need to convert var1 to a number before sending it through the
INSERT
> (SQL) query on my action page. What am I missing?
>
> Thanks
>
> --S
>
>
>
________________________________
_____
[ Todays Threads
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
