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]

Reply via email to