Welcome to WebmasterWorld Guest from 18.104.22.168
Forum Moderators: ocean10000
So Far so good, but i cant seem to create new records?
There are 3 fields 1 being id that is an "int" and i have set it as table indentity column in the manage indexes.
Have i done all right, what have i done wrontg.
Which in the info on the form, why doesnt it go into my db?
Print out the string you've built and see if you can execute the query directly in SQL Query Analyzer or Access or whatever you're using.
Or, better yet, figure out what the SQL query needs to look like using Query Analyzer or Access, then change the code so that it builds that string for you.
sql=sql & "('" & Request.Form("Fname") & "',"
could potentially get you into trouble.
I'd suggest isolating the request items in variables, checking them for illegal characters and then processing them into your sql command accordingly.
They are much simpler to write & debug, execute faster and more secure.
INSERT INTO Users (Fname,LName)
Then in the ASP:
objConn.Execute ("exec dbo.User_SAVE " & Request.Form("Fname") & " " & Request.Form("Lname") )