how can i show and calculate total records count from tables.

[asad]

Hi, i have some problem in showing data.

I have two tables
First table(containin g Hosting categories)
Second table(Containg catagories data lik
url,keyword,des cription.....et c)

I want to display catgories names from first table and then diffren
catagories
total records from second table, like this
ASP.NETHosting( 10)
Linux Hosting(20)
Windows hosting(13)
:
:
:
etc
How could i do this pls tell me
THANK
-
asa
-----------------------------------------------------------------------
Posted via http://www.codecomments.co
-----------------------------------------------------------------------

[Dan Nash]

Asad,

Psuedo-code version

open table 1
while not table1 eof
"asad" wrote:

Hi, i have some problem in showing data.

I have two tables
First table(containin g Hosting categories)
Second table(Containg catagories data like
url,keyword,des cription.....et c)

I want to display catgories names from first table and then diffrent
catagories
total records from second table, like this
ASP.NETHosting( 10)
Linux Hosting(20)
Windows hosting(13)
:
:
:
etc
How could i do this pls tell me
THANKS

--
asad
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

[Bob Barrows [MVP]]

asad wrote:

Hi, i have some problem in showing data.

I have two tables
First table(containin g Hosting categories)
Second table(Containg catagories data like
url,keyword,des cription.....et c)

I want to display catgories names from first table and then diffrent
catagories
total records from second table, like this
ASP.NETHosting( 10)
Linux Hosting(20)
Windows hosting(13)

etc
How could i do this pls tell me

Without knowing your table structures (fieldnames, datatypes) I can't get
specific, but the answer will involve creating an inner join between the two
tables and the grouping by categories.

You will make it easier for us to help you if you provide a few sample rows
of data from your tables (in tabular format), and then show us the results
you wish to obtain from the sample data you provided.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Dan Nash]

I'll try again...

open table 1
while not table 1 eof
subcount = 0
open subtable with id from table 1
while not subtable eof
subcount = subcount + 1
subtable.movene xt()
wend
close subtable
write table 1 field (subcount)
wend
close table 1
wend

there is actually a getrecords() method I think, but can't say ive ever used
it.

HTH, let me know if u need mroe code

Dan
"asad" wrote:

Hi, i have some problem in showing data.

I have two tables
First table(containin g Hosting categories)
Second table(Containg catagories data like
url,keyword,des cription.....et c)

I want to display catgories names from first table and then diffrent
catagories
total records from second table, like this
ASP.NETHosting( 10)
Linux Hosting(20)
Windows hosting(13)
:
:
:
etc
How could i do this pls tell me
THANKS

--
asad
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

[Bob Barrows [MVP]]

Stop ... please. A recordset loop to do an aggregation? Have you never
heard of a GROUP BY query?

Bob Barrows

Dan Nash wrote:

I'll try again...

open table 1
while not table 1 eof
subcount = 0
open subtable with id from table 1
while not subtable eof
subcount = subcount + 1
subtable.movene xt()
wend
close subtable
write table 1 field (subcount)
wend
close table 1
wend

there is actually a getrecords() method I think, but can't say ive
ever used it.

HTH, let me know if u need mroe code

Dan
"asad" wrote:

Hi, i have some problem in showing data.

I have two tables
First table(containin g Hosting categories)
Second table(Containg catagories data like
url,keyword,des cription.....et c)

I want to display catgories names from first table and then diffrent
catagories
total records from second table, like this
ASP.NETHosting( 10)
Linux Hosting(20)
Windows hosting(13)

etc
How could i do this pls tell me
THANKS

--
asad
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Dan Nash]

Bob,

Cant say I have.. perhaps you'd be kind enough to enlighten me?
"Bob Barrows [MVP]" wrote:

Stop ... please. A recordset loop to do an aggregation? Have you never
heard of a GROUP BY query?

Bob Barrows

Dan Nash wrote:

I'll try again...

open table 1
while not table 1 eof
subcount = 0
open subtable with id from table 1
while not subtable eof
subcount = subcount + 1
subtable.movene xt()
wend
close subtable
write table 1 field (subcount)
wend
close table 1
wend

there is actually a getrecords() method I think, but can't say ive
ever used it.

HTH, let me know if u need mroe code

Dan
"asad" wrote:

Hi, i have some problem in showing data.

I have two tables
First table(containin g Hosting categories)
Second table(Containg catagories data like
url,keyword,des cription.....et c)

I want to display catgories names from first table and then diffrent
catagories
total records from second table, like this
ASP.NETHosting( 10)
Linux Hosting(20)
Windows hosting(13)

etc
How could i do this pls tell me
THANKS

--
asad
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Drew]

See this for examples of GROUP BY

http://www.w3schools.com/sql/sql_groupby.asp

Drew

"Dan Nash" <da*@musoswire. co.uk> wrote in message
news:4D******** *************** ***********@mic rosoft.com...

Bob,

Cant say I have.. perhaps you'd be kind enough to enlighten me?
"Bob Barrows [MVP]" wrote:

Stop ... please. A recordset loop to do an aggregation? Have you never
heard of a GROUP BY query?

Bob Barrows

Dan Nash wrote:

I'll try again...

open table 1
while not table 1 eof
subcount = 0
open subtable with id from table 1
while not subtable eof
subcount = subcount + 1
subtable.movene xt()
wend
close subtable
write table 1 field (subcount)
wend
close table 1
wend

there is actually a getrecords() method I think, but can't say ive
ever used it.

HTH, let me know if u need mroe code

Dan
"asad" wrote:

>
> Hi, i have some problem in showing data.
>
> I have two tables
> First table(containin g Hosting categories)
> Second table(Containg catagories data like
> url,keyword,des cription.....et c)
>
> I want to display catgories names from first table and then diffrent
> catagories
> total records from second table, like this
> ASP.NETHosting( 10)
> Linux Hosting(20)
> Windows hosting(13)
>>
>>
>>
> etc
>
>
> How could i do this pls tell me
> THANKS
>
>
>
> --
> asad

------------------------------------------------------------------------

> Posted via http://www.codecomments.com

------------------------------------------------------------------------

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.