Repeater2 (More data where ClientID supplied = ClientID on the table)(Limit 4 recs)
Label2 = Number of Records
Repeater3 (More data where ClientID supplied = ClientID on the table)(limit 12 recs)
Label3 = Number of Records
Repeater4 (More data where ClientID supplied = ClientID on the table)(limit 25 recs)
end repeater
How would you suggest I handle this to eliminate 4 separate queries hitting the database? This is all expecting that I will use the following queries based upon the situation above:
Repeater1 = "SELECT *, (SELECT COUNT(ID) FROM Table1) As Count1, (SELECT COUNT(ID) FROM Table2) As Count2, (SELECT COUNT(ID) FROM Table3) As Count3, FROM Table4 WHERE ID=ID"
How would you suggest I tap the other repeaters along with the first, if it is possible? Please give me suggestions.. should I use a DataSet or just a DataReader? Anything will help. Thank you.
Last edited by SheSaidImaPregy; Nov 6th, 2007 at 5:38 pm.
Nevermind... as I thought I solved it, my data provider does not allow multiple queries (Odbc). Any suggestions in combining these queries above? The only thing common they share are the User's ID. I am horrible at creating MySQL queries that are joined or unioned with other selects. Thanks.
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Unsolved 
