What happens if you try the INSERT without the cfqueryparam? I'm not suggesting this is good practise, but it will help isolate the problem.
----- Original Message -----
From: Bryan F. Hogan
To: CF-Talk
Sent: Tuesday, May 18, 2004 2:39 PM
Subject: Re: queryparam problem
Try changing it from cf_sql_tinyint to cf_sql_integer if you haven't
done so already.
If it still happens post a few more lines of code. I have seen errors
like this returned telling you it's one line and in fact it is another.
Phillip B wrote:
> I tried wrapping it with Val() and Trim() and neither helped.
>
> I even tried this <cfqueryparam value="1" cfsqltype="cf_sql_integer">
> and I got the same error.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- queryparam problem Phillip B
- RE: queryparam problem Dave Francis
- Re: queryparam problem Phillip B
- Re: queryparam problem Bryan F. Hogan
- Re: queryparam problem Phillip B
- Re: queryparam problem Bryan F. Hogan
- Re: queryparam problem Dave Francis
- Re: queryparam problem Phillip B
- RE: queryparam problem Barney Boisvert
- Re: queryparam problem Phillip B