stored procedures...what are you talking about in specifics...i know there are TONS of uses for them...if they're what i think they are, you're talking about database connections and recordsets...which one do you want??
I need to learn how to create them and use them. I have notepad and access to the IIS, but I dont know how to write them. Maybe some simple examples to start with would be great. Like pass it user id and password and find out if they are in the database .
Oh, alright, simple is a good starting point...so is authenticity...that's where i started...here's the form page where the user will enter the id:<BR><BR><form action="check.asp" method=post><BR><input type="text" name="name"><BR><input type="password" name="password"><BR><input type="submit" value="Log In"><BR></form><BR><BR>Alright, so the user submits these values...let's get 'em and check 'em:<BR><BR><%<BR>name=request.form("name ")<BR>password=request.form("password")<BR>set dbcn=server.createobject("adodb.connection")<BR>db cn.open "dsn=mydsn" 'this is assuming you have a dsn<BR>set dbrs=server.createobject("adodb.recordset")<BR>dbr s.activeconnection=dbcn<BR>dbrs.open "select * from mytable where namefield=" & name<BR>mypassword=dbrs.fields("passwordfield")<BR >if mypassword=password then<BR>response.redirect "loggedin.asp"<BR>else<BR>response.redirect "invalid.asp"<BR>end if<BR>dbrs.close<BR>dbcn.close<BR>set dbrs=nothing<BR>set dbcn=nothing<BR>%><BR><BR>There!! A simple, and very efficient way to do authenticity (remember, this code was done by moi, no tutorial does it as simple as this...they always go into extra crap...)...Hope this helps!!!