Search results for query: *

I think there's a better way to track this... look for user link9.. seems to know alot about this. Regards gsc1ugs "Cant see wood for tree's...!"

If columns exist.... you could just do a query on that column and if exists then if not rs.EOF then get it else dont do anything end if just a quicky Regards gsc1ugs "Cant see wood for tree's...!"

Put all the names into a session variable and log time... you could have a multi-dimensional array to hold both of these information. Regards gsc1ugs "Cant see wood for tree's...!"

FYI Smart pointers C++ stuff Regards gsc1ugs "Cant see wood for tree's...!"

Is there smart pointers or similar with asp cause they know when the db is free and close automatically Regards gsc1ugs "Cant see wood for tree's...!"

Sorry your correct SQL = "SELECT * FROM users WHERE username=" & "'" & Request.QueryString("username") & "'" If you feel the thread as been useful then you click the Click here to mark this post as a helpful or expert post! Tara :-0 Regards gsc1ugs...

It worked fine with me... try the above code Regards gsc1ugs "Cant see wood for tree's...!"

I'll look again... thought this was different thread Regards gsc1ugs "Cant see wood for tree's...!"

This is wrong StrSQL = "SELECT * FROM users WHERE username=" & "'" & Request.QueryString("username") & "'" Should be StrSQL = "SELECT * FROM users WHERE username=" & '" & Request.QueryString("username") & "' Is the...

May be some setting in your browser.. this is just a stab though. Regards gsc1ugs "Cant see wood for tree's...!"

Yeh... a new session should start there and end Regards gsc1ugs "Cant see wood for tree's...!"

Look at the permissions set for the db. Regards gsc1ugs "Cant see wood for tree's...!"

Wrap somthing like this on each...connection On Error Resume Next //do create stuff here if Err<>0 then strErr = strErr & &quot;<br>Error is <b>&quot; & Err.description & &quot; Else // go for it. End if Regards gsc1ugs &quot;Cant see wood for tree's...!&quot;

I got this just the other day when inputing wrong data types in text fields. Regards gsc1ugs &quot;Cant see wood for tree's...!&quot;

Try Session.Abandon... Regards gsc1ugs &quot;Cant see wood for tree's...!&quot;

Yes.. close the db in question. Regards gsc1ugs &quot;Cant see wood for tree's...!&quot;

Is the check strSQL = &quot;SELECT username, password FROM users WHERE username = '&quot; & Request.Form(&quot;yourusername&quot;) & &quot;' AND passwrod = '&quot; &Request.Form(&quot;yourpasswrod&quot;)&&quot;'&quot; Set rstChkAgain = objConn.Execute(strSQL) if not rstChkAgain.EOF then...

Is the check strSQL = &quot;SELECT username, password FROM users WHERE username = '&quot; & Request.Form(&quot;yourusername&quot;) & &quot;' AND passwrod = '&quot; &Request.Form(&quot;yourpasswrod&quot;)&&quot;'&quot; Set rstChkAgain = objConn.Execute(strSQL) if not rstChkAgain.EOF then...

If not is database if not rstChkAgain.EOF then Response.write &quot;results &quot;&rstChkAgain(&quot;username&quot;) else Response.write &quot;Nothing found&quot; End if Regards gsc1ugs &quot;Cant see wood for tree's...!&quot;

Hi... just managed get it going.... dont know what your connection is but here's the code i used <% DIM objConn Set objConn = Server.CreateObject(&quot;ADODB.Connection&quot;) Application(&quot;DBConnect&quot;)=whateveryoursis&quot; objConn.Open(Application(&quot;DBConnect&quot;)) strSQL...