Jump to content

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

Recommended Posts

I want to display information from one of my databases. This is how I have done it:

A link:

<a href="FMPro?-DB=links.fp5&-FORMAT=links.html&-LAY=CGI_1&category_id=8&-MAX=all&-FIND">links</a>

which points to a format file (links.html) which looks like this (simplified):

[FMP-Record]

Company name: [FMP-Field: company_name]

Contact: [FMP-Field: contact]

City: [FMP-Field: company_city]

[/FMP-Record]

The only that the browser displays is the headlines (Company name, contact and city), not the content of the fields. Both myself and my colleague have spellchecked and verified all the commands to Webcompanion and we have not been able to find any problems in the code.

All the other format files is working perfect, it's just this one which makes my head ache.

The only possible problem I can imagine is that the content of the field category_id is a related valuelist from another database, but the field is not related.

I can see that webcompanion is able to find all the records I'm looking for, but is not able to show it. What should I do?

crazy.gif" border="0

Link to comment
Share on other sites

Thanks for the replies, but it still wont work. I've redone the layout and have rewritten the format file from scratch, and have modified the link (I have tried Form and Inline as well). Webcompanion still refuses to transfer the information in the fields, but I still get the correct response regarding number of records found, layout used, db used... I can't understand what the problem is, any idea what it could be?

crazy.gif" border="0

Link to comment
Share on other sites

This is what webcompanion spits out:

Company name:

Contact:

City:

CurrentRecordNumber: 1

CurrentRecID: 75

----------------------------------------

Company name:

Contact:

City:

CurrentRecordNumber: 2

CurrentRecID: 77

----------------------------------------

Current database: links.fp5

Current layout: cgi_1

Current action: find

Current found count: 2

Current find: Current error: 0

There is only two records to be found, so that is correct. The correct DB, correct layout and correct action is also used... But no information from a field is displayed. I have tried different encodings on the different fields.

Link to comment
Share on other sites

What does the record portion of your CDML look like un-simplified?

[FMP-Record]

Company name: [FMP-Field: company_name]

Contact: [FMP-Field: contact]

City: [FMP-Field: company_city]

[/FMP-Record]

As you stated, will yield

Company name: Contact: City:

with empty data fields, not

Company name:

Contact:

City:

Link to comment
Share on other sites

dspires: I didn't include the html tags.

I believe there's a major problem in the database: some field or relation which is configured in a non-perfect way. I'll try to recreate the database from scratch if nothing else works. mad.gif" border="0

Link to comment
Share on other sites

We've solved it!!!

I really urge anyone to check the security settings for the databases you produce for the web. Especially when you're a couple of people designing the same solution, my colleague had created a group in the security settings which killed all webcompanion traffic...

Thx for the help guys, you rewl! smile.gif" border="0

[ June 11, 2001: Message edited by: iBib ]

Link to comment
Share on other sites

This topic is 8444 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.