Re: still having a problem with insert

[stas]

Steven, you may need to surrround some of your insert values with single quotes as it seems judging from variable names that they are strings.
  ----- Original Message -----
  From: Steven Sharko
  To: CF-Talk
  Sent: Wednesday, February 25, 2004 9:37 AM
  Subject: still having a problem with insert

  Error Executing Database Query.

  [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
  Access Driver] Syntax error in INSERT INTO statement.

  The error occurred in D:\websites\serviceorders.cfm: line 127

  125 : insert into clntnote (thisdate,subject,note,type,compid)
  126 : values
  (#form.thisdate#,#form.subject#,#form.note#,#form.type#,#form.compid#)
  127 : </cfquery>
  128 :           </CFIF>
  129 :           <CFIF ParameterExists(sta) eq 'true'>

  SQL    insert into clntnote (thisdate,subject,note,type,compid) values ({ts
  &apos;2004-02-25 09:36:45&apos;},Service Ticket 3172 - ,<br>Submitted by ,t,)

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---