|
-
Aug 31st, 2005, 05:29 AM
#1
Thread Starter
Fanatic Member
ignore this thread, moderator please delete
I HAD A COMMA MISSING
i get this error
There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
i believe there is a better way to write this insert, if anyone knows please let me know. i think there is equal number of argumants also, error confuses me.
Dim sqlInsertuser As New SqlCommand("INSERT INTO tb_user(c_orig_addr,c_user_fname,c_user_sname,c_username_login,c_user_password,c_user_house,c_user_s treet,c_user_town,c_user_postcode,c_user_tel_alt,c_user_email) VALUES('" & txt_mobile.Text & "','" & txt_fname.Text & "''" & txt_sname.Text & "','" & txt_username.Text & "','" & txt_password.Text & "','" & txt_house.Text & "','" & txt_street.Text & "','" & txt_town.Text & "','" & txt_post.Text & "','" & txt_tel.Text & "','" & txt_email.Text & "');", oSQLConn)
'sqlInsertuser.Connection.Open()
sqlInsertuser.ExecuteNonQuery()
oSQLConn.Close()
Last edited by d2005; Aug 31st, 2005 at 08:02 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|