June 11, 200421 yr I have created two databases and a relationship between them called REVIEW. I also have a HTML doc set up to display some records from the Master file and then all of the related records from the related file. However, this is not working. I've tried stripping out all of the code to a bare minimum to see if I can even get it to work but when I look at the source of the "rendered" html doc, I see nothing. Here's my code below. Can you see anything wrong with it? InlineAction tag - - - - - - - - - - - - - - - - - - - - - - - - - - - - - <script language="JavaScript"> // Obtain RECORD information and save into parallel arrays. // var username; var mockupID = new Array(); var thumbnailFP = new Array(); var reviews = new Array(); var cnt = -1; [FMP-Record] cnt++; username = "[FMP-CurrentToken: 0, HTML]"; mockupID[cnt] = "[FMP-Field: mockUpID]"; thumbnailFP[cnt] = "http://127.0.0.1:591/[FMP-Image: mockUpThumbImg]"; [FMP-InlineAction: -db=CoverArt_MockUpReviews.fp5, -lay=ReviewInfo, bookCode={field:bookCode}, -find ] [FMP-Record] var testStr = "[FMP-Field: reviewID] - [FMP-Field: reviewDate] - [FMP-Field: bookCode]"; testStr += " - [FMP-Field: reviewer] - [FMP-Field: review] - [FMP-Field: rating]"; alert( "testStr [" + testStr + "]" ); [/FMP-Record] [/FMP-InlineAction] [/FMP-Record] document.writeln( ' <form>n' ); document.writeln( ' <table cellpadding="3" cellspacing="0" border="0" align="center">n' ); document.writeln( ' <tr>' ); for( var idx = 0; idx <= cnt; idx++ ) { document.writeln( ' <td><a href="http://127.0.0.1:591/FMPro', '?-db=CoverArt_Mockups.fp5&-format=cover_art/view_cover_mockup.html&mockUpID=', mockupID[idx], '&-Token.0=', username, '&-find="><img src="', thumbnailFP[idx], '" border="0"><br><input type="button" name="review_', mockupID[idx], '" value="Review this Mock-Up"></a></td>n' ); } document.writeln( ' </tr>' ); document.writeln( ' </table>' ); document.writeln( ' </form>' ); </script> ___________________________________________________________________ Portal tag - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - <script language="JavaScript"> // Obtain RECORD information and save into parallel arrays. // var username; var mockupID = new Array(); var thumbnailFP = new Array(); var reviews = new Array(); var cnt = -1; [FMP-Record] cnt++; username = "[FMP-CurrentToken: 0, HTML]"; mockupID[cnt] = "[FMP-Field: mockUpID]"; thumbnailFP[cnt] = "http://127.0.0.1:591/[FMP-Image: mockUpThumbImg]"; [FMP-Portal: REVIEW] var testStr = "[FMP-Field: REVIEW::reviewID] - [FMP-Field: REVIEW::reviewDate] - [FMP-Field: REVIEW::bookCode]"; testStr += " - [FMP-Field: REVIEW::reviewer] - [FMP-Field: REVIEW::review] - [FMP-Field: REVIEW::rating]"; alert( "testStr [" + testStr + "]" ); [/FMP-Portal] [/FMP-Record] document.writeln( ' <form>n' ); document.writeln( ' <table cellpadding="3" cellspacing="0" border="0" align="center">n' ); document.writeln( ' <tr>' ); for( var idx = 0; idx <= cnt; idx++ ) { document.writeln( ' <td><a href="http://127.0.0.1:591/FMPro', '?-db=CoverArt_Mockups.fp5&-format=cover_art/view_cover_mockup.html&mockUpID=', mockupID[idx], '&-Token.0=', username, '&-find="><img src="', thumbnailFP[idx], '" border="0"><br><input type="button" name="review_', mockupID[idx], '" value="Review this Mock-Up"></a></td>n' ); } document.writeln( ' </tr>' ); document.writeln( ' </table>' ); document.writeln( ' </form>' ); </script> ___________________________________________________________________ In both cases the source code for the "rendered" html doc is as follows: <script language="JavaScript"> // Obtain RECORD information and save into parallel arrays. // var username; var mockupID = new Array(); var thumbnailFP = new Array(); var reviews = new Array(); var cnt = -1; cnt++; username = "jason.barker"; mockupID[cnt] = "1"; thumbnailFP[cnt] = "http://127.0.0.1:591/FMPro?-db=coverart%5fmockups.fp5&key=1&-img"; cnt++; username = "jason.barker"; mockupID[cnt] = "2"; thumbnailFP[cnt] = "http://127.0.0.1:591/FMPro?-db=coverart%5fmockups.fp5&key=4&-img"; cnt++; username = "jason.barker"; mockupID[cnt] = "3"; thumbnailFP[cnt] = "http://127.0.0.1:591/FMPro?-db=coverart%5fmockups.fp5&key=6&-img"; document.writeln( ' <form>n' ); document.writeln( ' <table cellpadding="3" cellspacing="0" border="0" align="center">n' ); document.writeln( ' <tr>' ); for( var idx = 0; idx <= cnt; idx++ ) { document.writeln( ' <td><a href="http://127.0.0.1:591/FMPro', '?-db=CoverArt_Mockups.fp5&-format=cover_art/view_cover_mockup.html&mockUpID=', mockupID[idx], '&-Token.0=', username, '&-find="><img src="', thumbnailFP[idx], '" border="0"><br><input type="button" name="review_', mockupID[idx], '" value="Review this Mock-Up"></a></td>n' ); } document.writeln( ' </tr>' ); document.writeln( ' </table>' ); document.writeln( ' </form>' ); </script> _____________________________________________________________ Any advice or help would be greatly appreciated. Thanks! Jason
June 11, 200421 yr Is the Portal on the named Layout? In the [FMP-InlineAction] hardcode this "bookCode={field:bookCode}," with a known value for testing. Good Luck. Garry
June 11, 200421 yr Author Thanks Gary, I feel a little stupid...I did not include the layout name (-lay=<layout_name>) in the URL. I tried it for the InlineAction code and it still didn't work. However, when I tried it with the code for the Portal tag, it worked like a champ!!! Also, I tried to hard-code a value in for the "bookCode" field but that still didn't work either. Thanks for your help!
June 11, 200421 yr Author P.S. It was your comment about whether the Portal was actually placed in the NAMED LAYOUT that tipped me off to look to see if I had even included the name of the layout in the URL. THANKS!
Create an account or sign in to comment