is there a way to count records gotten from a sql string and also showing the result ?<BR>sql = "sql * from db where " & selec
select Count(*) TheCount from....<BR><BR>response.write recordset("TheCount")<BR><BR>
SELECT COUNT (*) AS antall FROM db<BR>is my count script. But how can I combine this to also show the records? not just the count number.
then what you have to do it select the records like normal and get the recordcount of the records returned.<BR><BR>Now for that use the recordcount property of the recordset which may or may not work...so for that read the FAQs<BR><BR><BR>