[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]

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

Question 2:

How many rows will this construct read at a time?

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

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