Subject | selecting a random record within the db |
---|---|
Author | rebel_rob_98 |
Post date | 2005-06-07T21:58:12Z |
Hello All,
I would like to select a random record from a table and return the
results on a web page. I can do this with ASP however it requires a
couple of trips to the database (which I am hoping to avoid). I was
hoping to accomplish this selection within a view or stored procedure.
However, I can not find any information regarding the availability of
rnd() or random() for firebird.
I am running firebird superserver 1.5.2
Any tips or suggestions would be greatly appreciated.
Thank you for your time.
I would like to select a random record from a table and return the
results on a web page. I can do this with ASP however it requires a
couple of trips to the database (which I am hoping to avoid). I was
hoping to accomplish this selection within a view or stored procedure.
However, I can not find any information regarding the availability of
rnd() or random() for firebird.
I am running firebird superserver 1.5.2
Any tips or suggestions would be greatly appreciated.
Thank you for your time.