Results 1 to 13 of 13

Thread: Syntax error in INSERT statement?

Threaded View

  1. #1

    Thread Starter
    Member
    Join Date
    Oct 2004
    Posts
    58

    Resolved Syntax error in INSERT statement?

    Whats wrong with the following statement because i am getting Run-time error saying "Syntax error in INSERT statement"

    VB Code:
    1. cn.Execute "Insert Into News (sno,subject,topic,user,date) values (" & count & ",'" & Trim(txtSubject.Text) & "','" & Trim(txtMessage.Text) & "','" & frmLogin.gstrUsername & "','" & strDate & "' )"
    Last edited by gopikrish; Oct 30th, 2004 at 02:31 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width