Plain Black, makers of WebGUI

Etcetera > SQLReport

Previous · Next
User	Message
rene	Date: 4/18/2008 2:29 am · Subject: SQLReport · Rating: 0 Hi there, I made a collaboration system (weblog style). I can post messages with text and images. From this weblog i've made a SQL report to show these posts. But i can't get the select images (in sql query) to show these pictures. Somebody please help me with this topic. the query "select ad.title, ad.url, CONCAT(SUBSTRING(ad.synopsis,1,300),'...') AS synopsis from asset a, assetData ad where a.parentId='-9bCVvj2Ubm7QpfZclIFgA' and a.assetId=ad.assetId and ad.status='approved' and ad.isHidden=0 group by ad.title, ad.url order by ad.revisionDate DESC limit 1,3;" My question is what should i use to get the images and witch template var i must use to show the pictures om the webpage. Many Thanks, Rene --- (Edited on 4/18/2008 2:29 am [GMT-0500] by rene) ---
Back to Top	Rate [ \| ]

preaction	Date: 4/18/2008 2:43 am · Subject: Re: SQLReport · Rating: 0 To continue with the way you're doing it, you would have to grab the storageId column from the Post table, and use a macro to grab the file from the storage location using the WebGUI::Storage API. Or, you could make a shortcut to your Collaboration System and override the template to make things look the way you want. Easier than using an SQLReport and no development required. --- (Edited on 4/18/2008 2:43 am [GMT-0500] by preaction) ---
Back to Top	Rate [ \| ]

Etcetera > SQLReport