Well, maybe not, but I am an idiot when it comes to perl and cgi.
I will pay you for this. By the way, the Globals listed in Support for attachments DO NOT WORK.
All that I want to do is have a global that will:
SELECT lsql_Links_Files.ID FROM lsql_Links, lsql_Links_Files WHERE lsql_Links_Files.ForeignColKey = lsql_Links.ID and lsql_Links.ID = <%ID%>
Join 2 tables and find return the LINKS_FILES ID for the corresponding link ID WHERE the <%ID%> is the current link. This way I can display the IMAGE that users upload.
Links SQL 2.2. Please don't just link to other posts. I have been all over this forum and the Globals do not work for what I want to do.
Ultimate goal : <img src=".../images/<%thisglobal'sreturnedvalue%>-filename.gif">
Where filename.gif is stored in the links table and the only variable number is that darn foreign key!!!
I want this to be static.
Thanks.
I will pay you for this. By the way, the Globals listed in Support for attachments DO NOT WORK.
All that I want to do is have a global that will:
SELECT lsql_Links_Files.ID FROM lsql_Links, lsql_Links_Files WHERE lsql_Links_Files.ForeignColKey = lsql_Links.ID and lsql_Links.ID = <%ID%>
Join 2 tables and find return the LINKS_FILES ID for the corresponding link ID WHERE the <%ID%> is the current link. This way I can display the IMAGE that users upload.
Links SQL 2.2. Please don't just link to other posts. I have been all over this forum and the Globals do not work for what I want to do.
Ultimate goal : <img src=".../images/<%thisglobal'sreturnedvalue%>-filename.gif">
Where filename.gif is stored in the links table and the only variable number is that darn foreign key!!!
I want this to be static.
Thanks.