Paul
Try running the query in ISQL (query Analyser) replacing the variables with
the values. See what gets inserted into the table. If the correct values
get inserted the put some debugging code in your cfm templates to output the
values of the variables before you run the query so you can see exactly what
is being passed in
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
------------------------------------------------------------------
-----Original Message-----
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 06 October 2000 13:39
To: CF-Talk
Subject: RE: SQL Server Decimal
Either way it doesn't work (I've tried both and it's just wierd).
There isn't an error as such. The field just discard everything after the
dot.
Should I be using a scientific format ie 361*10^-2 or something like that?
Paul
PS I even tried <CFQUERYPARAM> and that didn't work either.
> -----Original Message-----
> From: Andy Ewings [mailto:[EMAIL PROTECTED]]
> Sent: 06 October 2000 13:25
> To: CF-Talk
> Subject: RE: SQL Server Decimal
>
>
> Paul
>
> You don't need the quotes around it.......
>
> INSERT INTO <tablename> (<decimalfield1>, <decimalfield2>)
> VALUES (#decimal1#, #decimal2#)
>
> I'm not sure this is the problem that you were getting the other
> day but if
> this doesn't work let us know the error message you get.
>
> ------------------------------------------------------------------
> Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> ------------------------------------------------------------------
>
>
> -----Original Message-----
> From: Paul Johnston [mailto:[EMAIL PROTECTED]]
> Sent: 06 October 2000 13:22
> To: CF-Talk
> Subject: SQL Server Decimal
>
>
> I am having problems putting a decimal into a SQL Server field.
>
> The data type is decimal and I am passing the value in with
> DecimalFormat(#var#) with the commas taken out (so that it is
> just xxxxxx.xx
> and no more).
>
> Exactly what SQL do I need to add in?
>
> INSERT INTO...
>
> ...
> VALUES
> (
> #decimal1#
> , #decimal2#
> )
>
> or
>
> INSERT INTO...
>
> ...
> VALUES
> (
> '#decimal1#'
> , '#decimal2#'
> )
>
> or what?
>
> Paul
>
>
> ------------------------------------------------------------------
> ----------
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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.mail-archive.com/cf-talk@houseoffusion.com/
> 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.mail-archive.com/cf-talk@houseoffusion.com/
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.mail-archive.com/cf-talk@houseoffusion.com/
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.
