Newbie help

[silverbeetle]

hi all.
i'm a cold fusion user but would like to get into a bit of asp. i've had a surf around but can't find a simple example of a form inserting a value into a database. could anyone help me out with a nice clean example so i can see how it's done in asp?

thanks in advance, chris ------------------

http://www.thegrandsilentsystem.com

 

[TechnicalAnalysis]

Here it's
<%
Dim oConn, sConnString
Set oConn = Server.CreateObject(&quot;ADODB.Connection&quot
sConnString = &quot;DRIVER={Microsoft Access Driver (*.mdb)};&quot; & _
&quot;DBQ=&quot; & Server.MapPath(&quot;yourdatabasehere&quot & &quot;;&quot;
oConn.Open(sConnString)


SQLprocess=&quot;INSERT INTO aTable (field1, field2, field3) &quot;
SQLprocess=SQLprocess & &quot;VALUES ('&quot; & fname & &quot;', '&quot;
SQLprocess=SQLprocess & mname & &quot;', '&quot; & lname & &quot;')&quot;
Set objRSprocess=Server.CreateObject(&quot;ADODB.Recordset&quot
objRSprocess.Open SQLprocess,oConn,,adLockOptimistic,adCmdText

objRSprocess.close
Set objRSprocess=nothing
oConn.close
Set oConn=nothing
%>

Regards

http://www.technical.analysis.dingojunction.com