Diplay results form a db query 3

[cschaffer]

This must be possible....I just need a quick example of how to display results from a query to make my results page faster then searching the entire db.....

here is my current code
*
sSQL = "SELECT * FROM Table"
Cm.CommandText = sSQL
Cm.CommandType = 1
Set Rs = Cm.Execute
*

how could I modify this to display a query and not the table????????


Thanks!

CS ***************

http://www.digital6.com

***************

 

[cschaffer]

thanks a lot for your help...if you have time I have always wanted to know how to accomplish the task of outputting some text...oh lets say "please wait!!!..." while the search is performing the search.....

thanks!!



CS


***************

http://www.digital6.com

***************

 

[ToddWW]

Oh really ?? I always wondered about that. My references are silent on the subject but I read a thread recently about someone asking whether or not it was necessary to close a recordset or connection before setting it to nothing. About five replies and everyone had a different spin on it. Nothing solid.. It makes sense to me. I guess I was just trying to save the typing which isn't like me. I'll type, type, type if it will make the engines run more efficiently..

Thanks !!

ToddWW

 

[lobstah]

well, we were having awful memory leaks, so massive research was done, and it seemed the connections cleared much quicker if the objects were closed before set = nothing. and it really is logical if you think about it.