PDA

Click to See Complete Forum and Search --> : just dumb


micksterbooty
Feb 7th, 2001, 08:30 AM
anyone help me with this INSERT function a comma appears before the entry in the database field i cant figure out why???

strstate = Request.Form("state")
strSQL = "INSERT INTO surfboardtable (state)"
strSQL = strSQL & "VALUES ('" & strstate & "')"
Set RSboard = OBJdbConnection.Execute(strSQL)

thanks
beginner

micksterbooty
Feb 7th, 2001, 09:13 PM
worked it out thanks