Generate SQL statements in ASP/VB

[shanuragu]

Hi

Is it possible to generate SQL statements in ASP/Visual Basic based on some pre decalred values/some conditions.

shara

[rdoekes]

yes you can.

Dim strSQL 'as string
Dim strInputFromForm ' as string
Dim oCnn 'as adodb.connection

stInputFromForm = Request.Form("someField")
strSQL = "INSERT INTO table (someField) VALUES ('" & _
strInputFromForm & "')"

Set oCnn = Server.CreateObject("ADODB.Connection")
oCnn.Open "connectionstring"

oCnn.Execute strSQL
oCnn.Close
Set oCnn = Nothing

Hope this helps

-Rogier Doekes

[shanuragu]

thanks for ur timely help!!:p