Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Visual Interdev 6.0 - Active Server Pages
Message
From
09/03/2000 09:42:03
 
 
To
08/03/2000 21:10:33
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00342867
Message ID:
00343645
Views:
24
>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
Map
View

Click here to load this message in the networking platform