Jump to content

[FP3] How to list FileMaker data page by page with LDML?


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

Recommended Posts

  • Newbies

My server uses Lasso 3.6.6.2 on a FileMaker 3.0 database (Mac OS).

I want to display many data on Web pages, about 10 items on each page. But my link buttons don't function. Are 'shown_prevgroup' and 'shown_nextgroup' LDML commands incorrect or is there any error in Lasso parameters?

===============================================================

Here's the code of the 'search' page (search_parc_s_dev.lasso):

===============================================================

<form Name="SearchForm" action="/search/action.lasso?-database=8k986iloc.fmp3&-layout=details&-response=searchparcresult_dev.lasso&-maxrecords=10&-AnyError=errany_fr.lasso&-Token.zu8i7kc=[Token_Value:'zu8i7kc',EncodeNone]&-Token.rgh87p=[Token_Value:'rgh87p',EncodeNone]&-show" METHOD="post">

<input type="hidden" name="-database" VALUE="8k986iloc.fmp3">

<input type="hidden" name="-layout" VALUE="details">

<input type="hidden" name="-NoResultsError" VALUE="searcherror.lasso">

<input type="hidden" name="-anyerror" VALUE="searcherror.lasso">

<input type="hidden" name="-response" VALUE="searchparcresult_dev.lasso">

<input type="hidden" name="-Timeout" VALUE="60">

<input type="hidden" name="-MaxRecords" VALUE="10">

<input type="hidden" name="-Token.zu8i7kc" VALUE="[Token_Value:'zu8i7kc',EncodeNone]">

<input type="hidden" name="-Token.rgh87p" VALUE="[Token_Value:'rgh87p',EncodeNone]">

<table border="1" width="60%">

<tr>

<td><span class="textbold">Localit&eacute;:</span></td>

<td>

[inline: database='8k986iloc.fmp3', layout='details', MaxRecords="10",

Token.crit_locality=(Token_Value:'crit_locality',EncodeNone),

Token.camefrom=(Token_Value:'camefrom',EncodeNone), -findall]

<SELECT name="-token.crit_locality" SIZE="1" language="JavaScript" onchange="javascript:selectloc()">

[string_Replace: Find=(String_Concatenate: '<option value="', (Token_Value:'crit_locality',raw),'">',raw), Replace=(String_Concatenate: '<option value="', (Token_Value:'crit_locality',raw),'" selected>',raw), (field: "g_menu_loc_P",raw),raw]

</SELECT>

[/inline]

</td>

<td rowspan="3" align="left" valign="center"><img src="/images/logos/logo_parc_big.gif" border="0"></td>

</tr>

<tr>

<td><span class="textbold">ZIP Code:</span></td>

<td><input type="text" SIZE="6" name="-token.npa" VALUE="[token_value:'npa']" maxlength="4">&nbsp;<span class="text">(ex: 1004)</span></td>

</tr>

<tr>

<td><span class="textbold">Name of the street:</span></td>

<td><input type="text" SIZE="14" name="-token.address" VALUE="[token_value:'address']" maxlength="12">&nbsp;<span class="text">(ex: beaulieu)</span></td>

</tr>

</table>

<br><br>

<input type="hidden" name="-Token.type_local" value="P">

<input type="hidden" name="-Token.skip" value="0">

<input type="image" name="-nothing" src="../images/buttons/but_rechercher.jpg" width="80" height="18" border="0" alt="Save" value="submit">

</form>

======================================

Here's the code of the 'results' page:

======================================

[inline: database='8k986iloc.fmp3', layout='details',

'type_local'="P",

'localite'=(variable:'crit_locality_used',EncodeNone),

'npa'=(Token_Value:'npa',EncodeNone),

'address'=(Token_Value:'address',EncodeNone),

Token.crit_locality=(Token_Value:'crit_locality',EncodeNone),

Token.npa=(Token_Value:'npa',EncodeNone),

Token.address=(Token_Value:'address',EncodeNone),

SortField=(Variable:'sortby2'),

SortOrder=(Variable:'sortop2'),

search]

[records]

[field:'parc_res_disp', raw]

[/records]

[shown_prevgroup][<<Previous Page][/shown_prevgroup]

[shown_nextgroup][Next Page>>][/shown_nextgroup]

[/inline]

[include: /includes/copyright_inc_fr.lasso]

FileMaker Version: 3

Platform: Mac OS 9

Link to comment
Share on other sites

show_prevgroup do not work with inline

create navigation link you will need to use this code

[inline: database='8k986iloc.fmp3', layout='details',

'type_local'="P",

'localite'=(variable:'crit_locality_used',EncodeNone),

'npa'=(Token_Value:'npa',EncodeNone),

'address'=(Token_Value:'address',EncodeNone),

Token.crit_locality=(Token_Value:'crit_locality',EncodeNone),

Token.npa=(Token_Value:'npa',EncodeNone),

Token.address=(Token_Value:'address',EncodeNone),

SortField=(Variable:'sortby2'),

SortOrder=(Variable:'sortop2'),

skiprecords=(form_param:'skip'),

search]

[if: (Shown_First)!='1']

<a href="your_file.lasso?skip=[math_sub:(shown_first),(maxrecords_value),1]& ather tokens">Previous</a>

[/if]

[if: (shown_last)!=(found_count)]

<a href="your_file.lasso?skip=[shown_last]& other tokens">Next</a>[/if]

Link to comment
Share on other sites

This topic is 6500 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
 Share

×
×
  • Create New...

Important Information

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