Couldn't find the function val() in the Access SQL reference - what is it
doing converting a string to a number?
you're doing something like ??
UPDATE yourtable
SET
iNumber = val('#url.number#')
WHERE
id = #url.id#
do (CF side)
UPDATE
yourtable
SET
iNumber = #val(url.number)#
WHERE
id = #val(url.id)#
or better
UPDATE
yourtable
SET
iNumber = <cfqueryparam value="#url.number#" cfsqltype="CF_SQL_INTEGER">
WHERE
ID = <cfqueryparam value="#url.id#" cfsqltype="CF_SQL_INTEGER">
or even ( SQL side, a bit like val() )
UPDATE
yourtable
SET
iNumber = convert( integer, '#url.number#')
WHERE
ID = convert( integer, '#url.id#')
"Jake" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
>
> Hi All,
>
> This should be an easy one, unfortunatly in oversea's in Central America
> without my books!
>
> A client is updating there database from Access to SQL2000 and apparently
> the val() function dose not work on SQL200.
>
> Is this true? and if to is there an alternative funtion to validate
> numbers in URL variables.
>
> Thanks in advance
>
> Jake
>
>
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
