Hello:
I have a SQL DB with a Product table.
The columns in the table are desc., price, etc....I know very little ASP but have been using sample ASP code and plugging it in to make my pages work. I have everything running ok but I can't find a example of how to return the picture in that product row. I can get every other value fine because the values are in the respective cells but I don't understand how to properly code my asp productresults.asp to return the image related to the product. I have a value,.... for example car.jpg in my product_picture cell but obviously don't want the value "car.jpg" returned but rather I want the picture of car.jpg returned.
Again I have very little experience with ASP any help of a site that may explain this or any other help is appreciated. I hope I explained myself properly.
Here is what I have so far (my productresults asp page):
****The strPictureFileName is what I can't get working. All other variables are returning values ok.
<!--#include virtual="/lib/all_include.asp"-->
<%
lngProductID = Request.QueryString("productID"
Sub showProduct
Response.Write listProduct(lngProductID)
End Sub
Function listProduct(lngProductID)
If lngProductID = "" Then Exit Function
Dim lngParentID,strName
Set myDB = New database
Set objRS = Server.CreateObject("Adodb.Recordset"
With myDB.dbCommand("sp_GetProductByID"
.Parameters(1) = lngProductID
.Execute
strPartNumber = .Parameters(2)
strName = .Parameters(3)
strDescription = .Parameters(4)
curPrice = .Parameters(5)
strPictureFileName = .Parameters(6)
End With
strOut = "" &_
"<table border='1' cellpadding='0' cellspacing='0'>" &_
" <tr>" &_
" <td rowspan='2'><table border=0>" & strDescription & "</table></td>" &_
" <td>Model Number:</td><td>" & strPartNumber & "</td>" & _
" </tr>" &_
" <tr>" &_
" <td>Price:</td><td>" & curPrice & "</td>" &_
" </tr>" &_
"</table>"
Set myDB = Nothing
Set objRs = Nothing
listProduct = strOut
End Function
%>
I have a SQL DB with a Product table.
The columns in the table are desc., price, etc....I know very little ASP but have been using sample ASP code and plugging it in to make my pages work. I have everything running ok but I can't find a example of how to return the picture in that product row. I can get every other value fine because the values are in the respective cells but I don't understand how to properly code my asp productresults.asp to return the image related to the product. I have a value,.... for example car.jpg in my product_picture cell but obviously don't want the value "car.jpg" returned but rather I want the picture of car.jpg returned.
Again I have very little experience with ASP any help of a site that may explain this or any other help is appreciated. I hope I explained myself properly.
Here is what I have so far (my productresults asp page):
****The strPictureFileName is what I can't get working. All other variables are returning values ok.
<!--#include virtual="/lib/all_include.asp"-->
<%
lngProductID = Request.QueryString("productID"
Sub showProduct
Response.Write listProduct(lngProductID)
End Sub
Function listProduct(lngProductID)
If lngProductID = "" Then Exit Function
Dim lngParentID,strName
Set myDB = New database
Set objRS = Server.CreateObject("Adodb.Recordset"
With myDB.dbCommand("sp_GetProductByID"
.Parameters(1) = lngProductID
.Execute
strPartNumber = .Parameters(2)
strName = .Parameters(3)
strDescription = .Parameters(4)
curPrice = .Parameters(5)
strPictureFileName = .Parameters(6)
End With
strOut = "" &_
"<table border='1' cellpadding='0' cellspacing='0'>" &_
" <tr>" &_
" <td rowspan='2'><table border=0>" & strDescription & "</table></td>" &_
" <td>Model Number:</td><td>" & strPartNumber & "</td>" & _
" </tr>" &_
" <tr>" &_
" <td>Price:</td><td>" & curPrice & "</td>" &_
" </tr>" &_
"</table>"
Set myDB = Nothing
Set objRs = Nothing
listProduct = strOut
End Function
%>
