query = "INSERT INTO MembersInfo ("Name,User Name,Password,Confirm Password, Password hint, Address, City, Postal Code, State, Country, [Home No:],[Handphone No:], SMS Alerts, E-mail Address") VALUES (" & "'" & txtName.Text & "'" & "," & "'" & txtUserName.text & "'" & "," & "'" & txtPassword.text & "'" & "," & "'" & txtConfirmPassword.text & "'" & "," & "'" & txtPasswordHint.text & "'" & "," & "'" & txtAddress.text & "'" & "," & "'" & txtCity.text & "'" & "," & "'" & txtPostalCode.text & "'" & "," & "'" & txtState.text & "'" & "," & "'" & txtCountry.text & "'" & "," & "'" & txtHome.text & "'" & "," & "'" & txtHandphone.text & "'" & "," & "'" & txtEmail.text & "'" & ")"
error message: end of statement expected...where?HELP PLEASE
2006-08-02
04:38:35
·
6 answers
·
asked by
braich_gal
3
in
Programming & Design