yes, I could do it that way. However, all dates I try to insert are giving the
error, not just ones I'm using the function #now()# in.
Turns out the issue is my data source in CF. We have been using the ODBC socket
to connect CF to the System DSN which uses the SQL Native driver. When I change
Turns out what is causing the error is the line
EditDate=
the EditDate is a datetime field.
Any ideas?
thanks!
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=
I have tested the query using 0 instead of No for the default form value (see
reply thread) and I am still receiving the Invalid Precision Value error.
In the error, it highlights the last line as the issue (although sometimes that
is deceiving)
I've seen forums that say this error is seen w
sorry,
I guess I meant that, when using CF, I have never had issues with No or False
or 0 being read as the same by the SQL Server
>No it doesn't.
>
>Here is an example on SQL 2005:
>
>declare @test table (
> testVal bit
>)
>
>insert into @test (testval) values (0);
>insert into @test (
SQL will read a NO or FALSE or 0 as the same
>Surely a bit field will need 0 or 1, not a string? Or was that not what you
>meant?
>
>
>
>The default is NO so it always has a value
>
>> What is the value of #FORM.LoanerYN# when you try to insert it in the
>> bit field?
>>
>>
~~
The default is NO so it always has a value
> What is the value of #FORM.LoanerYN# when you try to insert it in the
> bit field?
>
>
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/
I am testing some code on CF9 before we move all our sites from CF8 and have
come upon this issue. The page that runs the query below is returning an
Invalid Precision Value error.
INSERT INTO VRRFs (RequestDateTime, Name, Email, Phone, Department, ENum,
MilesHours, Urgency, VLocation, Rep
Thanks Dave. We are using the JDBC drivers. Turns out the issue was the data
type of the TransactionDate field. I had used a smalldatetime and changed it to
datetime. Now the page displays fine.
Thanks for the help!
nicki
>> 2, H,mH,mþââ¬Å þââ¬Å, ââ¬ÃËââ¬ÅPÃËââ¬Å,
>
I have a simple web page with a few queries and an output tag in the body. The
queries use the same datasource as another page that works fine, but uses
different tables within the source.
My page code is:
---
SELECT TransactionID,
9 matches
Mail list logo