Hi all,
I try to build my own ASP site. I have many tables in DB one of them is the
main table. This table contains all information about other tables. I write
some code to minimize reading from DB everey time. So I wrote a function to
return the result of query to the page invoked it similar to this:
in COMMON.ASP
Sub GetTables(Tables)
Set Tables = Server.CreateObject("ADODB.RecordSet")
Tables.Open "SELECT * FROM MT",Conn,1
End Sub
At the first line of each page I wrote this code:
Call GetTables(Tables)
Then I used Tables as a record set. Some time I pass "Tables", i.e. a
record set, as a parameter to another function in COMMON.ASP to retrieve
some information. My questions are:
1)- Is that a good way to use or not?
2)- Are there any problems to use that way especially is security?
3)- Is there any way to pass "Tables" to another page to reduce reading from
DB every time when pages are hit?
4)- Any more knowledgeable help will appreciated.
Thanks in advance.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [email protected]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
