Classic ASP Muppet

[Sone]

complete n00b with asp, i have got a html form and with the action of an asp page whcih has got an insert statement. But how do i access the values? the post data is coming accross correctly

Very simple bit of the code below

<%
set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "dsn=orac;uid=cdavis;pwd=;"
'insert personal details into staff table
SQL = "INSERT INTO Staff(STAFF_ID,STAFF_FIRST_NAME) VALUES ([What goes here], [and here])"
objConn.Execute SQL
%>

 

[toString]

Something like:

SQL = "INSERT INTO Staff(STAFF_ID,STAFF_FIRST_NAME) VALUES ( ' " & Request("FirstName") & " ',' " & Request("FirstName") & " ' )"

 

[Sone]

got it working, thanks very much KingAdora