ErrorDisplaying linked data through Lasso

[Partha]

Hi,

I've got a set of pages in CDML that I suddenly had to convert to LDML. Thanks to this forum, I've got a lot of my problems sorted out.

Now I've got hit by one that's really strange.

I've got a results pages (showing results of a search) that displays data from the file being searched, as well as a related file. This works just fine in the CDML page, but on the Lasso page it gives an error as shown below, though there is no mention of not using related fields in the Lasso 3.6 manual !?!

________

Message:

[scratchmalogicalwax]

there is no problem using related fields with lasso!

for your tag.......

[FMP-FIELD:Link_Brands::ProdCat_Nickname_LU]

i would write this.........

[Field: 'Link_Brands::ProdCat_Nickname_LU']

the same but without the FMP- also i tend to put single speach marks around my tag values in this case the relationship name and the field name.....

also if you are using a portal in your solution the opening tag is [Portal: 'Link_Brands']

where 'Link_Brands' is the name of your relationship (the portal closing tag is [/Portal]

Hope this helps.......

PS expected end of tag errors are quite common and are usually caused by typos......in this case though i think it would have been an unsupported tag in the CDML tags mod .......

( [FMP-FIELD:Link_Brands::ProdCat_Nickname_LU] ).........

I don't use CDML tags mod so I don't know exactly which tags are supported and which aren't John will probably be able to advise better......

[ August 03, 2001: Message edited by: scratchmalogicalwax ]

[Partha]

Thanks. As must be obvious from my responses right now, I'm rather desperate to get the solution to work right now.

Will try it out & revert back.

Rgds, Partha

[John May - Point In Space]

I believe the [fmp-field] tag is CDML, while [field] is LDML (Lasso).

Not sure if [fmp-field]'s usage differs from [field] though (I too use Lasso normally).

- John

[Partha]

No Go.

Used the Field tag of Lasso instead of the FMP-Field of CDML, and I still get the Syntax error.

I've checked & double checked the error, and have thrice copied the field name with the reference from my working CDML pages and deleted the FMP- from the tag, but the same error occurs.

The moment I tried the Results page without a linked field - it worked just fine.

problem is I need to show the related data!?!

I'd like to mention that my databases are on an NT2000 server, and my pages & Lasso on a Mac server, with FMP Remote in between (if that makes any difference)

[John May - Point In Space]

Be sure you're using the format:

[field: 'RelationshipName::FieldName']

- John

[scratchmalogicalwax]

also are you nesting this tag in another? one thing to get used to in Lasso is that you must use ( ) brackets in [ ] brackets

eg

[Var_Set: 'test'=(Field: 'relationshipname::Fieldname')]

the expected end of tag error can be caused by / originate in a tag before the one where the error occurs (if you catch me drift!)if you cut and paste more of the code we may be able to see where the problem lies a little easier.......

again I would recommend looking at the FM Link applet as this will help you port all your CDML on the offending page over to LDML, I think this may solve your problem as it clearly is a syntax issue (from what you have said)

[Partha]

<td valign=top width=404 height=93>

<p>  <font size="-1" face="Helvetica">[PORTAL: Link_Agency]

</font>

<table cellpadding=2 width="100%">

<tr>

<td valign=top colspan=2

width=431 height=39>

<p><a href="action.lasso?-Database=COMPANY&-lay=web&-Format=company_detail.htm&ID_Main_N=[Field: Link_Agency::ID_Company_Agency_LBr]&-Max=1&-Search"><font size="-1">[Field: Link_Agency::AgencyName_Calc_LBr]</font></a></p>

</td>

<td valign=top width=157 height=39>

<p><font size="-1">[Field: Link_Agency::agency_city]</font><font size="-1" face="Helvetica">

</font></p>

</td>

</tr>

</table>

[/PORTAL]

<p></p>

</td>

_____________________

Have pasted a code from one of the pages with related data that are giving me errors.

Also, this is on a rented trial server, so I only have access to Lasso security for my files, and can't check anything else.

Which is why I'd kept pure CDML files with the database so that I can check my code.

Just a passing thought, but could it be that the long relationship and the VERY long field names are causing an error ?

[Partha]

Shoot! Shoot! SHOOT!!

Thanks scratchmalogicalwax & John.

I did make the most idiotic error in syntax. For some reason I presumed that the ' used with the field names was only as an example, and used filed names in the CDML format without enclosing them in single quotes.

I can't excuse my self for this. Maybe it was because I'd been up a few nights (and days in a row), or maybe because I'm having to juggle more than 1 ball in the air at the same time, but I'm not usually this foolish (or so I hope!)

Please forgive me for wasting your time on something so simple without having even looked properly, and thanks a lot for the help - I probably wouldn't have caught on to this error if it hadn't been for the code you'd used as an example.

yours ashamedly, Partha

[John May - Point In Space]

Hey, just glad to hear you got it working!

- John

[scratchmalogicalwax]

[Partha]

Hi,

Thought I'd mention this for anyone else who has to go through this madness of switching from CML to Lasso.

Lasso's CDML conversion works great for all regular fields. However, the minute you have a related field you refer to, then unless you use Lasso tagging of [Field:] instead of the FMPro one, the -9951 keeps occurring.

Rgds, Partha