This topic is locked

Image display directory

2/27/2005 6:16:59 AM
ASPRunnerPro General questions
author

When I chose to display an image using the formatting portion of asprunner the out creates a directory problem.
Current directory of website for image location and asp files.
https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1167&image=1&table=forumtopics this is the image directory.
http:///testshop/test/product_list.asp this is the directory of all my asp files.
The databse is in:

http://****/testshop/includes/.mdb
So asprunner finds the database fine and all functions work correctly when the scripts are called except the display of the images. The url to display the image should be:
https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1167&image=2&table=forumtopics
instead asprunner whats to call them:
https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1167&image=3&table=forumtopics
So my question is how do I get asprunner to look in the correct location for the images. When I don't choose anything in the formatting view as, the display is:

includes/images/.jpg. Which would be correct if it did not put in the test directory first.
I know I can manually change each pages code to point to the correct directory but this is the whole purpose of testing asprunner to see what it can and cannot do before I purchase it. And to answer a very simple suggestion before it is asked, no I do not want to move the image folder. I need it where it is at.
Thank you

Sergey Kornilov admin 2/28/2005

Todd,
try to use the following SQL query in ASPRunnerPro to achieve this:

select [ProductID],

[Code],

[Name],

[ProdDescription],

[Price],

[Cost], More... [Net],

[ImageURL1],

[ImageURL2],

'images/' + [ImageURL1] as NewImageURL1,

'images/' + [ImageURL2] as NewImageURL2,


[DateAvailable],

[StockQTY],

[CatID],

[SubCatID],

[Status],

[SortOrder],

[ShipCost],

[ShipCostMulti],

[Taxable]

From [Products]