I do not think its because of missing single quote but rather a missing
value itself. I have encountered this kind of problem in which an integer
value was blank leading to a statement like (.....,'xyz',,...) This causes a
problem at SQL end. So if you have such empty values coming through, make
them zero or something similar so no null value is passed
Hope this helps
On Thu, Oct 30, 2008 at 6:09 PM, Imstac <[EMAIL PROTECTED]> wrote:
>
> I added an SQL insert statement to a button on my web form and when I
> debug I get the error: "Incorrect syntax near ',' " I've been over
> and over the code and can't figure out the problem. Could someone
> please take a look at my code and let me know if you see anything
> wrong?
>
> Protected Sub Button1_Click(ByVal sender As Object, ByVal e As
> System.EventArgs) Handles Button1.Click
> Dim oConn As New
>
> System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("CMSConnectionString").ConnectionString)
> Dim cmd As New System.Data.SqlClient.SqlCommand()
> cmd.Connection = oConn
> oConn.Open()
> cmd.CommandText = "INSERT into
> Timecard(INEENO,INDTWE,INWKNO,INDYWK, INJBNO, INGLAN, INJCDI, INRGHR,
> INOVHR, INOTHR, INOTTY) values(" & EmplID1.Text & ",'" &
> DatePicker1.TextValue & "'," & DD_week.Text & "," & DD_DayofWeek.Text
> & ",'" & jobno.Text & "','" & GLAcct.Text & "','" & DD_CostCode.Text &
> "'," & RegHrs.Text & ", " & OTHrs.Text & "," & OthHrs.Text & ",'" &
> DD_OthHourType.Text & "')"
> cmd.ExecuteNonQuery()
> oConn.Close()
>
>
> End Sub
