Imnakedonthefloor
New Member
I am working in asp classic. I am new to asp and it's syntax seems confusing to me.I have this code to update data in a table named jeanmeasure.What is wrong with this query? It gives the following error:now my code is \[code\]Dim m1,m2,m3,m4,m5,m6,m7,m8,m9,m1d,m2d,m3d,m4d,m5d,m6d,m7d,m8d,m9d m1 = Request.QueryString("m1")m2 = Request.QueryString("m2")m3 = Request.QueryString("m3")m4 = Request.QueryString("m4")m5 = Request.QueryString("m5")m6 = Request.QueryString("m6")m7 = Request.QueryString("m7")m8 = Request.QueryString("m8")m9 = Request.QueryString("m9")m1d = Request.QueryString("m1d")m2d = Request.QueryString("m2d")m3d = Request.QueryString("m3d")m4d = Request.QueryString("m4d")m5d = Request.QueryString("m5d")m6d = Request.QueryString("m6d")m7d = Request.QueryString("m7d")m8d = Request.QueryString("m8d")m9d = Request.QueryString("m9d")sql =" UPDATE jeanmeasure SET m1 = "&m1&" , m2 = ,"&m2&", m3 = "&m3&", m4 = "&m4&", m5 = "&m5&",m6 = "&m6&",m7 = "&m7&",m8 = "&m8&",m9 = "&m9&",m1d = "&m1d&", m2d = "&m2d&", m3d = "&m3d&", m4d = "&m4d&",m5d = "&m5d&",m6d = "&m6d&",m7d = "&m7d&", m8d = "&m8d&", m9d = "&m9d&" WHERE id = 1 " Response.Write(sql) dbobj.execute(sql)\[/code\]and the error issyntax erro near '' = 'm1 , m2 = ,m2, m3 = m3, m4 = , m5 = m5,m6 = m6,m7 = m7,m8 = m8,m9 = m9,m1d ' at line 1