Jump to content

This topic is 7981 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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

Posted

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.

Posted

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>

Posted

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>

Posted

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>

Posted

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]

  • 3 weeks later...
Posted

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

This topic is 7981 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.