On the site Adoption.com we have been using a mysql database to set up
families who want to adopt. We have since redesigned our site and the old
code is not working for us. I am trying to design a section of code in ASP
to connect to the database and return a random record. Here is what I have
so far:
set SQL_Con = Server.CreateObject("ADODB.Connection")
set SQL_Rec = Server.CreateObject("ADODB.Recordset")
SQL_Con.OPEN application("conString2")
SQL_Rec.ActiveConnection = SQL_Con
SQL = "Select pp_search.profile_id, pp_search.thumbnail,
pp_package.package_id, pp_package.profile_id from pp_search, pp_package
where pp_package.package_id = 1 and pp_search.profile_id =
pp_package.profile_id"
All I can get is the first record in the page. If I go to the command
prompt I get all matching records but don't know how to randomize what I
display on the page.
Can anyone help? I have been working futilly on this project :)
Alan Halls
Adoption.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php