Showing random recordsets

[colinod]

I have a webpage that i want to show 6 random recordsets from the same database each of the records in the database has a unique number between 1 and 156 i can get the asp to return the random numbers and response.write them to the page, the problem i am having is getting it to show that name and picture of each person

here is the code i am using to generate the random selection, only 1 at this time

 
<% 
randomize
random_number1=int(rnd*156)+1
%>
<%
On Error Resume Next
 
Response.Expires=0
Set yaketyConnection=Server.CreateObject("ADODB.Connection")
DatabaseDetails="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("../private/yakety.mdb") & ";"
yaketyConnection.Open DatabaseDetails
yaketyQuery="SELECT * FROM celebs WHERE rndnumber='%"&random_number&"%'"
Set yaketyRecordset=yaketyConnection.execute(yaketyQuery)
%>
 

This is the code i am using to try and write the info to the webpage

 
<DIV id="rnd1" class="rnd1"><img src="Pix/<%=yaketyRecordset("image")%>" width="100" height="100" alt="<%=yaketyRecordset("firstname")%>&nbsp;<%=yaketyRecordset("surname")%>"></DIV>
 

If someone could help it would be appreciated

[jeffstl]

So when you say the picture and name doesnt show are you getting an error? Or is it just a blank page?

Your query syntax be like this

yaketyQuery="SELECT * FROM celebs WHERE rndnumber=" & random_number1 & ""
 

You were missing the 1 at the end of random_number as you have it defined.
You also need to use the =" & var & " syntax for a numeric value. The % sign only used for LIKE statements, and you dont need single quotes for numbers only strings.
Also rndnumber should be an integer in your table design if its not for this syntax.

[colinod]

i am getting an error on page and when i look at the code it is not writing the information contained in the asp code bits the page error says object expected
I dont think the error is anything to do with the code to write the asp objects to the page as it still comes up when they are removed it only dissapears when the connection code at the top of the page is removed i have attached a copy of the file or it can be seen at www.yaketyyakallmouth.com

[colinod]

Have now fixed the error nothing to do with asp is all thats happening now is that the image name variable from the asp code is not showing so the image is missing this can be seen at www.yaketyyakallmouth.com/index2.asp

[DrBunchman]

What do you mean the variable is not showing? Is the value not being passed to the images src property?

Dr B

[colinod]

yesy that right in the produced code is all i get is

<DIV id="rnd1" class="rnd1"><img src="Pix/" width="100" height="100" alt="&nbsp;"></DIV>

[DrBunchman]

Is this field definitely populated in the database?

If you try a simple loop through all the records and response.write this field to the screen does it display properly?

Dr B

[colinod]

i have many other pages collecting the same information from the database all being returned correctly the ather pages ar all done with response.write asp code i am now tring this but i get the div tags that contain the asp coming back empty

<div class="rnd1">
<% Response.write("<a href=""everyone.asp?id=" & yaketyRecordset("idnumber") & "&voicetype=" &voiceid &""" target=""_top""><img src=""pix/" & yaketyRecordset("image") & """ width=""100"" height=""100"" border=""0""></a>" & vbNewline) %>
</div>
 

Returns

<div class="rnd1">
 
</div>
 

[DrBunchman]

So your server code isn't creating any mark-up at all? If you put a simple:

 
<% Response.Write("<p>Hello World!</p>") %>
 

on the page does it display that?

EDIT: Just had a thought: your error trapping may be preventing you from seeing the real problem. If you remove it what happens?