[ic] Two sql questions

Kaare Rasmussen kar@webline.dk
Wed, 1 Nov 2000 23:56:59 +0100


Can I get something like this to work:

[query sql=select count(*) from addresstype]
[seti rowsfound]
[sql-param count]
[/seti]
[/query]                                                                      

I want to place the number of rows in the addresstype table in scratch 
rowsfound.

Question 2:

How many rows will this construct read at a time?

     [query more=1 ml=10 list=1 sql="select * from address"]
    [list]
            [sql-code] [sql-param field]<BR>
    [/list]<BR>
    [more-list]
    [more]
    [/more-list]
    [/query]

The question is of course more interesting with thousands or millions of rows.

-- 
Kaare Rasmussen            --Linux, spil,--        Tlf:        3816 2582
Kaki Data                tshirts, merchandize      Fax:        3816 2501
Howitzvej 75               Åben 14.00-18.00        Email: kar@webline.dk
2000 Frederiksberg        Lørdag 11.00-17.00       Web:      www.suse.dk