[thelist] ASP/SQL date database question
Scott Dexter
sgd at ti3.com
Fri Jul 7 01:45:35 CDT 2000
> also, sorry again, i dunno how to write the twenty or so asp
> statements
> that you need to feed the sql statement to the database using asp (no
> offence aardvark, scott, and/or all you other asp dudes and
> dudettes) -- in
> cold fusion you'd simply wrap a <cfquery> ... </cfquery>
> around the sql and
> you're done ;o)
>
that takes care of the query itself, but dontchya have to set up the
connection string somewheres?
<%
Set oConn = Server.CreateObject("ADODB.CONNECTION")
oConn.Open "DSN=DBDSN;UID=sqluser;PWD=sqluserpwd"
oConn.Execute "Update tbImportantInfo set updatedate = Null where
userid='bob'"
oConn.Close
Set oConn=Nothing
%>
and that includes the extra two lines for proper garbage collection ;p
who said 20? oh ... MS docs show 20. Well, you can get away with much, much
less if you know you don't need the extra functionality/overhead.
chow
sgd
--
thinksafely.org
More information about the thelist
mailing list