I have 1,803 Test questions in the form of images in a directory. The question to be given to the student is random within ranges. I have tried for days to get the images to display. The examples from the books have not worked. This is what I have last

GifJpg = "Tst" & TXHQstnNo(346) & "R.gif
Response.Write GifJpg%><!-- Line 0120 --><%rsTests.Open "SELECT * FROM TXHQsnts WHERE TXHNo = 657", cnnct, 3,
If rsTests("Wrong") = "Y" then%><TD Width="43%"><Img Src="<%=" & GifJpg & "%>" Width="937" Height="137"

All the Images are labeled Tst a Number than one letter at the end. The number part is what is random.

The example above is Test Question # 657. The Question is # 346. The lettter R means the question was answered in-correctly the first time the question was asked.

Does anyone know why I am having trouble to display the Image

Thank You in Advanc

Bill Barber

Re: Display Image of a Test Question by McKirahan

McKirahan
Mon Feb 09 07:44:11 CST 2004

"Coach Barber" <ftbcoaches@aol.com> wrote in message
news:F09ABBF9-CC43-4467-B3B7-03FDD81FA7A3@microsoft.com...
> I have 1,803 Test questions in the form of images in a directory. The
question to be given to the student is random within ranges. I have tried
for days to get the images to display. The examples from the books have not
worked. This is what I have last.
>
> GifJpg = "Tst" & TXHQstnNo(346) & "R.gif "
> Response.Write GifJpg%><!-- Line 0120 --><%rsTests.Open "SELECT * FROM
TXHQsnts WHERE TXHNo = 657", cnnct, 3, 3
> If rsTests("Wrong") = "Y" then%><TD Width="43%"><Img Src="<%=" & GifJpg &
"%>" Width="937" Height="137">
>
> All the Images are labeled Tst a Number than one letter at the end. The
number part is what is random.
>
> The example above is Test Question # 657. The Question is # 346. The
lettter R means the question was answered in-correctly the first time the
question was asked.
>
> Does anyone know why I am having trouble to display the Image?
>
> Thank You in Advance
>
> Bill Barber


How can you assign a value to "GifJpg" before you've read the table from
which it's based on?