View previous topic :: View next topic |
Author |
Message |
Codemaster
![](images/avatars/204816463149b2f5a044be5.jpg)
Joined: 11 Jul 2006 Posts: 189 Location: Metkovic
|
Posted: 05.10.2006 16:44 Post subject: ASP - prebrojavanje zapisa u tablici |
|
|
Ovako:
imam u access bazi tablicu "users" i želim prebrojati zapise u njoj kako bih to mogao postaviti na naslovnicu kao neku statistiku, npr:
Broj registriranih korisnika: 1024
Kako to mogu napraviti?
btw. jako mi je hitno, site mora biti gotov u roku danas ![Smile](images/smiles/icon_smile.gif) |
_________________ Let's play! |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
retro_one
![](images/avatars/37364600940f3f997e07d3.gif)
Joined: 16 Sep 2003 Posts: 880 Location: DUBRAVA.
|
Posted: 05.10.2006 16:57 Post subject: |
|
|
SELECT COUNT(*) as user_count FROM users |
_________________ Just your average eccentric programmer. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Codemaster
![](images/avatars/204816463149b2f5a044be5.jpg)
Joined: 11 Jul 2006 Posts: 189 Location: Metkovic
|
Posted: 05.10.2006 17:00 Post subject: |
|
|
kako ću to ispisati?
Response.Write(šta?) |
_________________ Let's play! |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
retro_one
![](images/avatars/37364600940f3f997e07d3.gif)
Joined: 16 Sep 2003 Posts: 880 Location: DUBRAVA.
|
Posted: 05.10.2006 17:02 Post subject: |
|
|
ne znam ASP, kako ispisujes kad selektiras inace iz tablice?
ovo ti vraca jedan row sa poljem user_count |
_________________ Just your average eccentric programmer. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Codemaster
![](images/avatars/204816463149b2f5a044be5.jpg)
Joined: 11 Jul 2006 Posts: 189 Location: Metkovic
|
Posted: 05.10.2006 17:03 Post subject: |
|
|
ok. kužim. hvala |
_________________ Let's play! |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
wxyzrusmir
![](images/avatars/1639369424315ca61445d5.gif)
Joined: 27 Jun 2005 Posts: 256 Location: Sarajevo
|
Posted: 05.10.2006 20:10 Post subject: |
|
|
zasto ne izbacis samo total records iz recordset-a to ti je najbolje. automatski ce ti prikazati kompletan broj upisanih recorda u tablici to jeste u tvom slucaju koliko usera je registrovano.
ja recimo to koristim na dva sajta za prikaz koliko ima knjiga u online biblioteci. |
_________________ ideas are all that you need | www.ideaisall.com
brainstorming magazine | use the brain to get ideas | www.brainstorming.ba |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
:cosmos:
![](images/avatars/163468793046cbab007a8c0.jpg)
Joined: 12 Sep 2003 Posts: 2098 Location: México
|
Posted: 05.10.2006 20:22 Post subject: |
|
|
to je ok, al mislim da ako ima neku filtraciju, to moze uraditi i bez da stvara novi recordset. a sa totalom ce dobiti sve, ja to zovem suhe id-ove
Code: | SELECT *, (SELECT COUNT(*) FROM gallery WHERE gallery.galID = galleries.galID) as PicCount FROM galleries
ORDER BY ID asc |
ovdje zanemari 'where' iako je mozes iskoristiti ako zatrbas
a ispis imas sljedeci
Code: | <%=(galleries.Fields.Item("PicCount").Value)%> |
galleries je recordset
nadam se da si skuzio |
|
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
retro_one
![](images/avatars/37364600940f3f997e07d3.gif)
Joined: 16 Sep 2003 Posts: 880 Location: DUBRAVA.
|
Posted: 05.10.2006 23:48 Post subject: |
|
|
wxyzrusmir wrote: | zasto ne izbacis samo total records iz recordset-a to ti je najbolje. automatski ce ti prikazati kompletan broj upisanih recorda u tablici to jeste u tvom slucaju koliko usera je registrovano.
ja recimo to koristim na dva sajta za prikaz koliko ima knjiga u online biblioteci. |
ok, a sta se desi ako u tablici imas 100 000 ili 1 000 000 zapisa? Oces selectat sve da bi napravio nesto sto SQL ima rijeseno u startu?
@cosmos: hm, to mu da total uz svaki selectani redak, a to mu ne treba |
_________________ Just your average eccentric programmer. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
sinke
![](images/avatars/1149866524b1196ef1ca38.gif)
Joined: 02 Oct 2005 Posts: 257 Location: Zagreb
|
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
:cosmos:
![](images/avatars/163468793046cbab007a8c0.jpg)
Joined: 12 Sep 2003 Posts: 2098 Location: México
|
Posted: 06.10.2006 08:43 Post subject: |
|
|
mastersinke wrote: |
Za to se u zatvor ide! |
zasto? |
|
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
zvone
![](images/avatars/30905348440ae69327f8ea.gif)
Joined: 09 Sep 2003 Posts: 160 Location: Zg
|
Posted: 06.10.2006 14:39 Post subject: |
|
|
Još jedno rješenje
Code: |
Set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT id FROM Tvoja_tablica"
rs.Open strSQL, strConn 1, 3
intBrojZapisa = rs.RecordCount
Response.Write "Ima " & intBrojZapisa & " korisnika."
|
|
_________________ Odin's descendant |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
retro_one
![](images/avatars/37364600940f3f997e07d3.gif)
Joined: 16 Sep 2003 Posts: 880 Location: DUBRAVA.
|
Posted: 06.10.2006 15:17 Post subject: |
|
|
@zvone: mozes molim te objasniti sto ovo radi? ne znam ASP a zanima me logika iza rjesenja. |
_________________ Just your average eccentric programmer. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Sulien
![](images/avatars/116771498344a191023de11.png)
Joined: 04 Jan 2004 Posts: 2905 Location: Zagreb
|
Posted: 06.10.2006 15:54 Post subject: |
|
|
Ne znam ni ja ASP ali Zvonko je ovdje selectao sve ID-eve iz baze i onda prebrojio retke
BTW super je kako se povela cijela rasprava a jedino točno rješenje je bilo postano već kao prvi odgovor ![Smile](images/smiles/icon_smile.gif)
Last edited by Sulien on 06.10.2006 16:00; edited 1 time in total |
|
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Codemaster
![](images/avatars/204816463149b2f5a044be5.jpg)
Joined: 11 Jul 2006 Posts: 189 Location: Metkovic
|
Posted: 06.10.2006 15:56 Post subject: |
|
|
ma sve su to varijacije na temu, ali na kraju krajeva sa svima njima se dobije željeni rezultat |
_________________ Let's play! |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
retro_one
![](images/avatars/37364600940f3f997e07d3.gif)
Joined: 16 Sep 2003 Posts: 880 Location: DUBRAVA.
|
Posted: 06.10.2006 15:59 Post subject: |
|
|
Sulien wrote: | Ne znam ni ja ASP ali Zvonko je ovdje selectao sve ID-eve iz baze i onda prebrojio retke ![Confused](images/smiles/icon_confused.gif) |
da i mislio sam da to radi, ali mozda ASP ima neku super naredbu koju ja nekuzim ![Shocked](images/smiles/icon_eek.gif) |
_________________ Just your average eccentric programmer. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
retro_one
![](images/avatars/37364600940f3f997e07d3.gif)
Joined: 16 Sep 2003 Posts: 880 Location: DUBRAVA.
|
Posted: 06.10.2006 16:00 Post subject: |
|
|
Codemaster wrote: | ma sve su to varijacije na temu, ali na kraju krajeva sa svima njima se dobije željeni rezultat |
isto je kad u tablici imas 100 ili 1000 zapisa, ali probaj tak prebrojat retke u tablici sa 5 000 000 zapisa (ne pricam napamet, radim sa bazom te velicine)
Last edited by retro_one on 06.10.2006 16:04; edited 1 time in total |
_________________ Just your average eccentric programmer. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Sulien
![](images/avatars/116771498344a191023de11.png)
Joined: 04 Jan 2004 Posts: 2905 Location: Zagreb
|
Posted: 06.10.2006 16:02 Post subject: |
|
|
retro_one wrote: | mozda ASP ima neku super naredbu koju ja nekuzim |
Ne. Nema ![Smile](images/smiles/icon_smile.gif) |
|
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
zvone
![](images/avatars/30905348440ae69327f8ea.gif)
Joined: 09 Sep 2003 Posts: 160 Location: Zg
|
Posted: 06.10.2006 16:16 Post subject: |
|
|
Može i bez SQL upita.
Code: |
Set rsCount = Server.CreateObject("ADODB.Recordset")
rsCount.Open "ime_tablice", strConn, 1, 3
intBrojZapisa = rs.RecordCount
Response.Write "Ima " & intBrojZapisa & " korisnika."
|
|
_________________ Odin's descendant |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Sulien
![](images/avatars/116771498344a191023de11.png)
Joined: 04 Jan 2004 Posts: 2905 Location: Zagreb
|
Posted: 06.10.2006 17:09 Post subject: |
|
|
Mislim da je ovo ipak najbolje rješenje:
Code: | Response.Write "<a href='http://www.php.net'>jači</a>, <a href='http://www.ruby-lang.org/en/'>najjači</a>" |
(hehe) |
|
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
zvone
![](images/avatars/30905348440ae69327f8ea.gif)
Joined: 09 Sep 2003 Posts: 160 Location: Zg
|
Posted: 06.10.2006 17:16 Post subject: |
|
|
Ak ćemo već tako onda ASP.NET jači od svih |
_________________ Odin's descendant |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
carr
![](images/avatars/283352003fb88d21d0d8f.gif)
Joined: 13 Nov 2003 Posts: 1397 Location: Karlovac
|
Posted: 07.10.2006 01:16 Post subject: |
|
|
zvone wrote: | Ak ćemo već tako onda ASP.NET jači od svih |
a nije od mog tate. |
_________________ Bolje biti malo lud, nego malo pametan. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Codemaster
![](images/avatars/204816463149b2f5a044be5.jpg)
Joined: 11 Jul 2006 Posts: 189 Location: Metkovic
|
Posted: 07.10.2006 10:13 Post subject: |
|
|
zvone wrote: | Ak ćemo već tako onda ASP.NET jači od svih |
slažem se, ali nemojmo započinjati još jednu besmislenu raspravu - neka svatko radi u s onim što misli da je bolje ![Smile](images/smiles/icon_smile.gif) |
_________________ Let's play! |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Sulien
![](images/avatars/116771498344a191023de11.png)
Joined: 04 Jan 2004 Posts: 2905 Location: Zagreb
|
Posted: 07.10.2006 12:48 Post subject: |
|
|
Codemaster wrote: | ...neka svatko radi u s onim što misli da je bolje |
...dok ne skuži da su skriptni jezici kao PHP/Ruby najbolji - naravno ![Smile](images/smiles/icon_smile.gif) |
|
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Tristan
![](images/avatars/131157980646129c2623a78.gif)
Joined: 01 Aug 2006 Posts: 614 Location: Under the sky
|
Posted: 07.10.2006 13:00 Post subject: |
|
|
Sulien wrote: | Codemaster wrote: | ...neka svatko radi u s onim što misli da je bolje |
...dok ne skuži da su skriptni jezici kao PHP/Ruby najbolji - naravno ![Smile](images/smiles/icon_smile.gif) |
![Applause](images/smiles/icon_clap.gif) |
_________________ Carpe diem... |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Eric
![](images/avatars/177169473543ff2d4d49414.gif)
Joined: 27 Jun 2005 Posts: 248 Location: Rijeka on rails
|
Posted: 07.10.2006 13:14 Post subject: |
|
|
Sulien wrote: | Codemaster wrote: | ...neka svatko radi u s onim što misli da je bolje |
...dok ne skuži da je skriptni jezik Ruby najbolji - naravno ![Smile](images/smiles/icon_smile.gif) |
Evo samo mali edit... |
_________________ I WRITE BEAUTIFULL CODE, NO MORE, NO LESS.
http://del.icio.us/jardas |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
|