Is there a CDML length limit on field names / relationships etc??rus 
Author Message
 Is there a CDML length limit on field names / relationships etc??rus

Dear All,

A very frustrating time is being had...

OK, I have inherited a database with some really long
names for relationships / fields / portals, and am having
trouble getting things to display...

For testing purposes, I have created two fields to
show on a layout... They are called:

Ct_Position by School ID::FirstName
Ct_Position by Careers Adviser Tag for School_Contact ID::FirstName

They actually point to the same database, but
with different criteria (and are the basis for some equally
long portal names).

Now, if I use:
[FMP-field: Ct_Position by School ID::FirstName]
[FMP-field: Ct_Position by Careers Adviser Tag for School_Contact
ID::FirstName]
on a web page, one will give me results, and the other
one won't even though both of them have data on the
layout in FileMaker.

People wanting to see this in action:
http://www.***.com/ %...

Obviously, the underlying code is in school_detail.html

Any ideas? This is paining me somewhat...

Webko



Mon, 10 Nov 2003 10:23:46 GMT
 Is there a CDML length limit on field names / relationships etc??rus

There is a 60 character length limit on field names. "Ct_Position by School
ID::FirstName", however, evaluates to only 35 characters (using Length() ).

But "Ct_Position by Careers Adviser Tag for School_Contact ID::FirstName"
evals to 67. Does that help? It looks as though the relationship name is
evaluated, which makes some sense.

John


Quote:
> Dear All,

> A very frustrating time is being had...

> OK, I have inherited a database with some really long
> names for relationships / fields / portals, and am having
> trouble getting things to display...

> For testing purposes, I have created two fields to
> show on a layout... They are called:

> Ct_Position by School ID::FirstName
> Ct_Position by Careers Adviser Tag for School_Contact ID::FirstName

> They actually point to the same database, but
> with different criteria (and are the basis for some equally
> long portal names).

> Now, if I use:
> [FMP-field: Ct_Position by School ID::FirstName]
> [FMP-field: Ct_Position by Careers Adviser Tag for School_Contact
> ID::FirstName]
> on a web page, one will give me results, and the other
> one won't even though both of them have data on the
> layout in FileMaker.

> People wanting to see this in action:

http://webko.ucc.usyd.edu.au/schools/FMPro?-db=Schools.fp5&-lay=Data%...
&-format=school_detail.html&-RecID=32861&-find

- Show quoted text -

Quote:

> Obviously, the underlying code is in school_detail.html

> Any ideas? This is paining me somewhat...

> Webko



Mon, 10 Nov 2003 10:49:27 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Is there a limit to match field length in relationships

2. CDML: displaying relationship fields

3. CDML is there a limit of fields?

4. limit on length of table name???

5. index and sequence name length limit?

6. Is there limit for host name length?

7. Length Limit on Trigger Names

8. Column name length limit

9. Limits, many long fields, etc

10. Upper limit on table field entries, etc.

11. DTS Fixed field length limited to 4096

12. limit field length in BCP


 
Powered by phpBB® Forum Software