ASP Database - File Paths to Images

Rocky76 · #1 (**permalink**) 10-29-07, 05:54

--------------------------------------------------------------------------------

gvee · #2 (**permalink**) 10-29-07, 10:18

Can you provide us with the current ASP code for displaying the picture?

Rocky76 · #3 (**permalink**) 10-30-07, 05:29

-------------------------------------

gvee · #4 (**permalink**) 10-30-07, 06:54

Run this for me

Code:

Do While Not rs.EOF
	Response.Write rs("main-img")
	rs.MoveNext
Loop

I think the div is what is causing your issue, this should just prove that you're returning the correct data for each record.

You can then move on to

Code:

Do While Not rs.EOF
	Response.Write "<img src='" & rs("main-img") & "' /><br />"
	rs.MoveNext
Loop

Rocky76 · #5 (**permalink**) 10-30-07, 11:33

-----------------------------

gvee · #6 (**permalink**) 10-30-07, 14:42

Interesting...
So waht you're saying is that you've changed some field values in your Access database that are not being reflected in the records being retrieved by your ASP page..?

Open your access database and run a compact and repair (under the tools menu somewhere). Then try again.

Another thing to note is that you are not closing your recordset object!!!

After you're done with the recordset add this code

Code:

rs.Close
Set rs = Nothing

Another thing to note is to never use the asteriks (*) in your SQL statements!
It may take longer to write out each column header, but it will be well worth it for more reasons than I'm willing to go into right now.

Code:

rs.Open "SELECT * FROM tblcar", conn

Internet Services

Web Development

Digital Marketing

Consumer Tech