>Some of the code I have in my asp is below. The line that causes the error is this: myrecordset("categoryname") = Request("categoryname")
>
>Could you send some sample code if you have one handy? Thank you.
>
>
>Dim myConnection
>Dim myRecordset
>Dim myVariable
>
>Set myconnection = CreateObject("ADODB.connection")
>myconnection.Open application("connection1_connectionstring"), _
> Application("connection1_runtimeusername"), _
> Application("connection1_runtimepassword")
>
>Set myrecordset = CreateObject("ADODB.recordset")
>myvariable = "SELECT * FROM categories WHERE categoryid =" & Request("categoryid")
>myRecordset.Open myvariable, myconnection, adOpenStatic, adLockOptimistic
>
>myrecordset("categoryid") = Request("categoryid")
>myrecordset("categoryname") = Request("categoryname")
>myrecordset.update
>
>response.write "Thank you.
"
>response.write "The updated record has been posted!"
>
>myrecordset.Close
>set myRecordset = nothing
>myConnection.Close
>set myconnection = nothing
>
>
Don't you have to put Request.Form("myFormControlName")?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only