[ic] Displaying number of rows in a table
Interchange User
interchange-users@icdevgroup.org
Tue Jul 1 08:24:01 2003
Hello,
I would like to access the number of items in a SQL table. I haven't
had much luck getting at the results using SQL, and I'm wondering if
there's a simple way to access mv_return_fields after pointing a
[search] tag at one of the tables, or if it's easier to use the [query]
tag.
I know I'm doing something wrong , but this is what I've been trying:
------------------------------------------------------------------------
-----
[query
sql="select count(*) as requestcount from www_mediarequest"
type=list
list=1
st=db
]
[list]
[sql-param requestcount]
[/list]
[/query]
------------------------------------------------------------------------
-----
IC 4.9.8 nightly
MySQL 4.1 alpha
Thanks,
Peter