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?

make sure the fields are on the referenced layout.

Try it without the 'category_id=8' and use a -findall

This will eliminate any possible problems with the values for that field. Otherwise, maybe build the page from the beginning, even without the [FMP-Record] tags, and just build-up line-by-line.

All the best.

Garry

dspires said : 'make sure the fields are on the referenced layout.'

This type of problem has had me going circles and pulling my hair out on occasions. Can be a real 'gotcha'.

Garry

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?

Something maybe odd about your data. Try a different encoding e.g. [FMP-Field: company_name, RAW]

Good luck.

Garry

p.s. you may have to email a sample of your database.

Change -find to -findall.

SIMPLIFY ...

Keith

[ June 08, 2001: Message edited by: Keith M. Davie ]

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.

Current Action: find

Again, I recommend that you try -findall.

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:

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.

Oh, I've tried -FINDALL but it didn't return any information, the only difference was that webcompanion found all the records in the database but didn't transfer any content.

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!

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

Another trick with web security.

In WC version 5.0.3 you can create records through InLine -new without WS db set!

Not when you upgrade to WC 5.0.4 (?) and definitely not in 5.0.6.