As part of our cleanup effort, I am modifying our shopping cart program but have run into a little snag.
We store an image in our access db and reference it on our html file.
This is the current working one line syntax:
strHTML = strHTML & "<img src=" & q& "images/small/" & rs("cimageurl") &q& " align=" & q& "left"& q & ">" & vbcrlf
Of course is used for adding single quotes
q = chr(34)
Now I am creating a search page that will allow users to search by either product name or category name.
obviously it would make sense like the user requested to have the picture of the item show on the same page is the item description and price.
So far, I have been trying to duplicate the about reference to image but with no luck.
The image asks as though the path reference is wrong.
I see the shape of the image but not the image itself.
Below is the code I have been playing with.
The code in red is the culprit.
sql="SELECT cname, cDescription, cPrice,cimageurl " &
"FROM Products " &
"WHERE catalogID=" & Product_Id
Set RS = DataConnection.Execute(sql)
Title = RS("cname")
Description = RS("cDescription")
cimage = RS("cImageurl")
Price = RS("cPrice")
[CODE = red]<img src="images/" & <%=cimage%> & " align=""left"">[/CODE]<P>