[thelist] SQL & ASP my favorite combination :-)

Scott Dexter sgd at ti3.com
Wed May 9 10:38:05 CDT 2001


don't use the Command object to run the code, use the Connection object
instead:

objConn.Execute strsql

and fergit the Command object altogether on this one; ya don't need it =)

sgd
--
work: http://www.ti3.com/
non: http://thinksafely.org/

> -----Original Message-----
> From: Elfur Logadóttir [mailto:elfur at lists.evolt.org]
> 
> Dim strName, strEmail, strType, strContent
> strName = Request.form("name")
> strEmail = Request.form("email")
> strType = Request.form("type")
> strContent = Request.form("content")
> 
> strsql = "INSERT INTO tellmemore
>     (name,email,type,content)
>    VALUES
>    ('" & strName & "', '" & strEmail & "', '" & strType & "', 
> '" & strContent &
> "')"
> 




More information about the thelist mailing list