I've set up my own small ad management system, which uses a db. Is there a way to display a specific record on a page, without using an SQL statement in the recordset? By default Ultradev shows the first record (in my case a banner), but what do I need to do to display e.g. the third record (c.q. banner)? I know it works with the following SQL:

SELECT * FROM rsAdmanagement
WHERE ID = 2
etc. etc.

but this is not exactly what I want. Are there any other ways?
Thanks for your replies!

Rein

My suggestion - go with the flow.
Use a sql statement with a where clause that will bring up the record you need.

If you are having trouble with the just reply with the column names and data.


Steven Levy,

Thanks for your reply, but what do I need to do when I want to display more than one banner on a page? When I use an SQL statement with a WHERE clause, I have only the possibility of displaying one banner, or is there another way to use the WHERE statement?
Again, thanks for your help.

Rein