I’ve created a dropdown menu to list out all the pages in the site:
@SELECT pagetitle,id FROM site_content WHERE deleted != 1 ORDER BY `pagetitle` ASC
This is successful, but I need the output on the page to generate the relative URL for the page I selected in the pulldown. Right now I get it to spit out the id, but I am using it in a SWF Object call, like this:
[!SWFObject? &mode=`static` &objId=`homepageFlash` &swfFile=`assets/flash/homepageFlash.swf` &flashVersion=`8.0.0` &flashParam=`quality:"high", wmode:"transparent"` &flashVars=`getStartedURL:"[*getStartedDoc*]",badgeURL:"[*badgeDoc*]"` &bgcolor:"0xFFFFFF"`!]
But when I try to do this, it doesn’t work:
&flashVars=`getStartedURL:"[~[*getStartedDoc*]~]",badgeURL:"[~[*badgeDoc*]~]"`
Thanks