February 28, 200322 yr I'm trying to create a webpage which lists records from my database that start with the letter A. I'm doing this with an InlineAction, but nothing shows up that is inserted between the InlineAction tags. The following is the code: [FMP-InlineAction: -db=fos.fp5, -lay=allfields, -op="bw", field_name="A", -find] [FMP-Record][FMP-Field: field_name]<br> [/FMP-Record][FMP-CurrentError] [/FMP-InlineAction] I get nothing appearing - not even the error code. I'm sure this is something tiny I've missed in the code, but I've been staring at it and getting nowhere. This is my first application using CDML so I'm just a newbie and don't have much info to go on. For backgound - the fos.fp5 database has access privileges set, but is open under an administrator password when I'm doing this. (NB: Does this mean that the web user will access it at the administrator level - I couldn't really find out how the two systems interfaced from the published documentation and there doesn't seem to be a way to set a web access option in the access privileges settings) Any helpm would be most appreciated Thanks! NZMatt
February 28, 200322 yr Try this: [FMP-InlineAction: -db=fos.fp5, -lay=allfields, -op=bw, field_name=A, -find] Good Luck. Garry
March 4, 200322 yr Author Still no joy. Nothing I place between the InlineAction tabs shows in the browser. I'm running FMPro 5.5 and have checked this on Netscape 7.01 and Internet Explorer 5.2 all runnning on OS X 10.2. I am linking to the page containing the inline action using the following: <a href="FMPro?-DB=fos.fp5&-Format=fieldlist.htm&-lay=allfields&-SortField=field_name&-Findall"> Still searching for an answer....please help Matt
March 4, 200322 yr Since your layout is "allfields", it goes without saying that the fields you are trying to access are on the layout. So you might try temporarily placing on fieldlist.htm <p>[FMP-Field: field_name] A display of data here will confirm that fieldlist.htm is in touch with fos.fp5. Next observation is &-SortField... seems unnecessary in your link. Also, you might try the -View tag in lieu of the -Findall. I hope this leads you to stumble into the right answer for your situation.
March 5, 200322 yr The other thing to look for are html comments. These will mask any cdml tags from Web Companion. All the best. Garry
March 6, 200322 yr Author Hi Still not having any luck. When I try the -View tag as suggested by Unable, I don't get any information showing from my records, although the first [FMP-CurrentError] tag returns "0". With -Findall I get the list I would expect from the tags outside the Inlineaction tags, but still nothing that is between the InlineAction tags shows, not the record information nor the current error tag. This is the case whether or not the requests before the Inlineaction tags are included. I've copied the format file in it's entirety below. Is there something stupid I'm forgetting here? Again, any suggestions would be most appreciated Thanks Matt <html> <head> <title>Fields of Study</title> </head> <BODY BGCOLOR = #FFFFFF text="#000000" link="#cc0000" alink="#FF0000" vlink="#003366"> <P>[FMP-Record][FMP-Field: field_name]<BR>[/FMP-Record] [FMP-CurrentError] <BR> <BR> <BR> [FMP-InlineAction: -db=fos.fp5, -lay=fields, field_id=01, -findall] [FMP-Record][FMP-Field: field_name]<br> [/FMP-Record][FMP-CurrentError] [/FMP-InlineAction]</P> <BR> <BR> <BR> [FMP-InlineAction: -db=fos.fp5, -lay=allfields, -op=bw, field_name=A, -find] [FMP-Record][FMP-Field: field_name]<br> [/FMP-Record][FMP-CurrentError] [/FMP-InlineAction] <br><br> </body> </html>
March 7, 200322 yr Take small bites little cricket. Get this to work first. Then add. <html> <head> <title>Fields of Study</title> </head> <BODY BGCOLOR = #FFFFFF text="#000000" link="#cc0000" alink="#FF0000" vlink="#003366"> <P>[FMP-Record][FMP-Field: field_name]<BR>[/FMP-Record] [FMP-CurrentError] <BR> <BR> <BR> <BR> [FMP-InlineAction: -db=fos.fp5, -lay=allfields, -op=bw, field_name=A, -find] [FMP-Record][FMP-Field: field_name]<br> [/FMP-Record][FMP-CurrentError] [/FMP-InlineAction] <br><br> </body> </html>
March 8, 200322 yr You also might try to change your link to: <a href="FMPro?-DB=fos.fp5&-Format=fieldlist.htm&-lay=allfields&-Findall"> Try this as fieldlist.htm: <html> <head> <title>Fields of Study</title> </head> <BODY BGCOLOR = #FFFFFF text="#000000" link="#cc0000" alink="#FF0000" vlink="#003366"> <P>[FMP-Record][FMP-Field: field_name]<BR>[/FMP-Record] [FMP-CurrentError] <BR> <BR> <BR> <BR> [FMP-InlineAction: -db=fos.fp5, -lay=allfields, -SortField=field_name -Sort=Ascend -op=bw, field_name=A, -find] [FMP-Record][FMP-Field: field_name]<br> [/FMP-Record][FMP-CurrentError] [/FMP-InlineAction] <br><br> </body> </html>
March 8, 200322 yr Sorry, I left out a couple of commas. [FMP-InlineAction: -db=fos.fp5, -lay=allfields, -SortField=field_name, -Sort=Ascend, -op=bw, field_name=A, -find]
March 11, 200322 yr Have a look at the posts uder the topic "inline action failing with access privileges" Its seems that access privileges have an effect on inline actions. Stephen
March 27, 200322 yr Author Hi All Thanks heaps for the feedback - it was helpful. In the end I did find that the problem was related to access privileges. Allowing nopassword to Export fixed the problem. I had thought I had posted this response earlier - my apologies for not doing so. I will post the page once I get it up and running. Occassionally (ie. when I'm using working with it) it'll be accessible at 132.236.110.172, but I only work here 15 hours a week and the hours vary. Again, thanks Matt
Create an account or sign in to comment