[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