Needed to pass some additional text with a field to anm ASP.NET field.

.SelectCommand="SELECT 'DisplayImage.aspx?FileID='+LTRIM(STR(FileID)) AS ImageSelector, FileStorage.FileID, FileStorage.FileDescription, FileStorage.FileData, Gallery.GalleryID FROM FileStorage INNER JOIN File_Gallery ON FileStorage.FileID = File_Gallery.FileID INNER JOIN Gallery ON File_Gallery.GalleryID = Gallery.GalleryID WHERE (Gallery.GalleryID = 1)"

 The first column, named "ImageSelector", is new and constructs the

Article ID: 83, Created On: 12/15/2011, Modified: 11/1/2013

Feedback (0)