Script stop working on 8.6.1

classic Classic list List threaded Threaded
15 messages Options
Reply | Threaded
Open this post in threaded view
|

Script stop working on 8.6.1

Roy William Gabrielsen
Dear list

This script worked on Mac OS X with Lasso 8.5.6
Stop working on CentOS with Lasso 8.6.1

Where to look ?

Thanx!

Roy G

<?LassoScript
//
//  The only required variable is called "maxpages" and refers to the
//  maximum number of clickable page links displayed on the results page.
//[

        var: 'maxpages'=12;
        inline:
                 -Database='Landskonkurransen2013',
                 -Layout='poeng',
                 -KeyField='Internal record ID',
                 'Gruppe'='3',
                 'p'='p',
                 -ReturnField='navn',
                 -ReturnField='gruppe',
                 -SkipRecords=(SkipRecords_Value),
                 -MaxRecords='1',
                 -SortField='poeng',
                 -SortOrder='Descending',
                 -Search;
       
//]
//  We start by analysing the given SkipRecords value to establish how many page
//  links should be displayed, and from which page we start numbering in case the
//  user jumped to the next set of pages.
//[

                var: 'skip'=((Integer:(SkipRecords_Value)) + (Integer:(MaxRecords_Value)));
                var:'pages'=(Math_Ceil: ((decimal:(found_count)) / (decimal: (MaxRecords_Value))));
                If:$pages>=$maxpages; var:'pages'=$maxpages; /If; var:'page_calc'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * $maxpages) + 1); If:(math_mod:$skip, ((MaxRecords_Value) * $maxpages))==0; If:$skip==((MaxRecords_Value) * $maxpages); var:'page_no'=1; var:'skip2'=0; else; var:'page_no'=($page_calc - $maxpages); var:'skip2'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * ((MaxRecords_Value) * $maxpages)) - ((MaxRecords_Value) * $maxpages)); /If; Else; var:'page_no'=$page_calc; var:'skip2'=((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * ((MaxRecords_Value) * $maxpages)); /If; '

                                                                                                                        <p>\n';
                                                                                                                               

//]
// The first possible hyperlink will lead the user to the very first record from
// anywhere in the found set.
//[

                If: (Shown_First)>=(MaxRecords_Value);
                        '<A HREF="bryllup.lasso?-SkipRecords=0"><span class="text">F&oslash;rste</span></A>&nbsp;&nbsp;';
                else;
                        '<span class="silver">F&oslash;rste</span>&nbsp;&nbsp;';
                /if;
       
//]
// The second hyperlink, if applicable, is there to jump to the previous set of
// results pages
//[

                If: $skip2>0;
                        '<A HREF="bryllup.lasso?-SkipRecords=' + ((($page_no - 1) * (maxrecords_value)) - (maxrecords_value)) + '"><span class="text">Bakover</span></a>&nbsp;&nbsp;';
                Else;
                        '<span class="silver">Bakover</span>&nbsp;&nbsp;';
                /If;
       
//]
// The third hyperlink, if applicable, simply brings the user to the previous
// results page
//[

                If: ($skip>(MaxRecords_Value));
                        '<A HREF="bryllup.lasso?-SkipRecords=' + ($skip - ((MaxRecords_Value) * 2)) + '"><span class="text">Forrige</span></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
                Else;
                        '<span class="silver">Forrige</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
                /If;
                       
//]
// Finally getting to the all important hyperlinks to individual pages.
// This part of the routine uses the maxpages variable to define the
// maximum number of page links to be displayed, which means that the user
// may have clicked to the next or previous set of pages (see second
// hyperlink description above). If the maximum is set to 10 with a
// Maxrecords value of 10 and a found set of 200 records, the 'pages' and
// &quot;page_no&quot; variables take care of the correct page numbering, e.g 11-20
// for the second 'set'.
//[

                loop: $pages;
                        If:(((skiprecords_value) / (maxrecords_value)) + 1)==$page_no;
                                '<span class="text"><b><u>' + $page_no + '</u></b></span>';
                        else;
                                '<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span class="text">' + $page_no + '</span></a>';
                        /If;
                        '&nbsp;&nbsp;';
                        var:'page_no'=($page_no + 1),
                                'skip2'=($skip2 + (MaxRecords_Value));
                        If: $skip2 >= (found_count);
                                Loop_Abort;
                        /If;
                /loop;
       
//]
// The equivalent of the third hyperlink, pointing to the next results page.
//[

                If: (found_count>$skip);
                        '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip + '"><span class="text">Neste</span></a>';
                Else;
                        '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="silver">Neste</span>';
                /If;
       
//]
// The equivalent of the second hyperlink, jumping to the next set of pages.
//[

                If: $skip2<(found_count);
                        '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span class="text">Forover</span></a>';
                Else;
                        '&nbsp;&nbsp;<span class="silver">Forover</span>';
                /If;
                       
//]
// The last hyperlink requires some additional calculations, courtesy of
// Michael Collins, to bring the user to the page displaying the very last
// record.
//[

                If: ((Found_Count) % (MaxRecords_Value))==0;
                        Var:'Skip'=((Found_Count) - (MaxRecords_Value));
                else;
                        Var:'Skip'=((MaxRecords_Value) * (Math_Floor:(decimal:(Found_Count)) / (decimal:(MaxRecords_Value))));
                /If;
                If:(($Skip) <= (Found_Count))&&((Shown_Last)!=(Found_Count));
                        '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $Skip + '"><span class="text">Siste</span></A>';
                else;
                        '<span class="silver">&nbsp;&nbsp;Siste</span>';
                /if;
                               
       
        /inline;
?>

#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Script stop working on 8.6.1

Roy William Gabrielsen
Actual page is here:
http://foto.fotografiens-hus.no/landskonkurransen/2013/bryllup.lasso

Første  Bakover  Forrige          Neste  Forover  Siste
Links are dead..  

Roy G

1. juli 2013 kl. 18:16 skrev Roy William Gabrielsen <[hidden email]>:

> Dear list
>
> This script worked on Mac OS X with Lasso 8.5.6
> Stop working on CentOS with Lasso 8.6.1
>
> Where to look ?
>
> Thanx!
>
> Roy G
>
> <?LassoScript
> //
> //  The only required variable is called "maxpages" and refers to the
> //  maximum number of clickable page links displayed on the results page.
> //[
>
> var: 'maxpages'=12;
> inline:
> -Database='Landskonkurransen2013',
> -Layout='poeng',
> -KeyField='Internal record ID',
> 'Gruppe'='3',
> 'p'='p',
> -ReturnField='navn',
> -ReturnField='gruppe',
> -SkipRecords=(SkipRecords_Value),
> -MaxRecords='1',
> -SortField='poeng',
> -SortOrder='Descending',
> -Search;
>
> //]
> //  We start by analysing the given SkipRecords value to establish how many page
> //  links should be displayed, and from which page we start numbering in case the
> //  user jumped to the next set of pages.
> //[
>
> var: 'skip'=((Integer:(SkipRecords_Value)) + (Integer:(MaxRecords_Value)));
> var:'pages'=(Math_Ceil: ((decimal:(found_count)) / (decimal: (MaxRecords_Value))));
> If:$pages>=$maxpages; var:'pages'=$maxpages; /If; var:'page_calc'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * $maxpages) + 1); If:(math_mod:$skip, ((MaxRecords_Value) * $maxpages))==0; If:$skip==((MaxRecords_Value) * $maxpages); var:'page_no'=1; var:'skip2'=0; else; var:'page_no'=($page_calc - $maxpages); var:'skip2'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * ((MaxRecords_Value) * $maxpages)) - ((MaxRecords_Value) * $maxpages)); /If; Else; var:'page_no'=$page_calc; var:'skip2'=((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * ((MaxRecords_Value) * $maxpages)); /If; '
>
> <p>\n';
>
>
> //]
> // The first possible hyperlink will lead the user to the very first record from
> // anywhere in the found set.
> //[
>
> If: (Shown_First)>=(MaxRecords_Value);
> '<A HREF="bryllup.lasso?-SkipRecords=0"><span class="text">F&oslash;rste</span></A>&nbsp;&nbsp;';
> else;
> '<span class="silver">F&oslash;rste</span>&nbsp;&nbsp;';
> /if;
>
> //]
> // The second hyperlink, if applicable, is there to jump to the previous set of
> // results pages
> //[
>
> If: $skip2>0;
> '<A HREF="bryllup.lasso?-SkipRecords=' + ((($page_no - 1) * (maxrecords_value)) - (maxrecords_value)) + '"><span class="text">Bakover</span></a>&nbsp;&nbsp;';
> Else;
> '<span class="silver">Bakover</span>&nbsp;&nbsp;';
> /If;
>
> //]
> // The third hyperlink, if applicable, simply brings the user to the previous
> // results page
> //[
>
> If: ($skip>(MaxRecords_Value));
> '<A HREF="bryllup.lasso?-SkipRecords=' + ($skip - ((MaxRecords_Value) * 2)) + '"><span class="text">Forrige</span></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
> Else;
> '<span class="silver">Forrige</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
> /If;
>
> //]
> // Finally getting to the all important hyperlinks to individual pages.
> // This part of the routine uses the maxpages variable to define the
> // maximum number of page links to be displayed, which means that the user
> // may have clicked to the next or previous set of pages (see second
> // hyperlink description above). If the maximum is set to 10 with a
> // Maxrecords value of 10 and a found set of 200 records, the 'pages' and
> // &quot;page_no&quot; variables take care of the correct page numbering, e.g 11-20
> // for the second 'set'.
> //[
>
> loop: $pages;
> If:(((skiprecords_value) / (maxrecords_value)) + 1)==$page_no;
> '<span class="text"><b><u>' + $page_no + '</u></b></span>';
> else;
> '<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span class="text">' + $page_no + '</span></a>';
> /If;
> '&nbsp;&nbsp;';
> var:'page_no'=($page_no + 1),
> 'skip2'=($skip2 + (MaxRecords_Value));
> If: $skip2 >= (found_count);
> Loop_Abort;
> /If;
> /loop;
>
> //]
> // The equivalent of the third hyperlink, pointing to the next results page.
> //[
>
> If: (found_count>$skip);
> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip + '"><span class="text">Neste</span></a>';
> Else;
> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="silver">Neste</span>';
> /If;
>
> //]
> // The equivalent of the second hyperlink, jumping to the next set of pages.
> //[
>
> If: $skip2<(found_count);
> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span class="text">Forover</span></a>';
> Else;
> '&nbsp;&nbsp;<span class="silver">Forover</span>';
> /If;
>
> //]
> // The last hyperlink requires some additional calculations, courtesy of
> // Michael Collins, to bring the user to the page displaying the very last
> // record.
> //[
>
> If: ((Found_Count) % (MaxRecords_Value))==0;
> Var:'Skip'=((Found_Count) - (MaxRecords_Value));
> else;
> Var:'Skip'=((MaxRecords_Value) * (Math_Floor:(decimal:(Found_Count)) / (decimal:(MaxRecords_Value))));
> /If;
> If:(($Skip) <= (Found_Count))&&((Shown_Last)!=(Found_Count));
> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $Skip + '"><span class="text">Siste</span></A>';
> else;
> '<span class="silver">&nbsp;&nbsp;Siste</span>';
> /if;
>
>
> /inline;
> ?>
>
> #############################################################
>
> Attend the Lasso Developer Conference 2013!
> Sept 12-14, 2013 in Niagara Falls, Canada
> http://www.lassosoft.com/LDC-niagara-falls-2013
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Script stop working on 8.6.1

stevepiercy
In reply to this post by Roy William Gabrielsen
Comment out blocks of code until the error no longer appears.  
Once isolated, insert code to debug the error, e.g.,
error_currenterror, action_statement.

This is most likely a configuration issue on the new box.  
Compare SiteAdmin settings for connectors, hosts, databases,
tables, users, and groups.

--steve


On 7/1/13 at 6:16 PM, [hidden email] (Roy William
Gabrielsen) pronounced:

>Dear list
>
>This script worked on Mac OS X with Lasso 8.5.6
>Stop working on CentOS with Lasso 8.6.1
>
>Where to look ?
>
>Thanx!
>
>Roy G
>
><?LassoScript //
>//  The only required variable is called "maxpages" and refers to the
>//  maximum number of clickable page links displayed on the results page.
>//[
>
>var: 'maxpages'=12;
>inline:
>-Database='Landskonkurransen2013', -Layout='poeng',
>-KeyField='Internal record ID',
>'Gruppe'='3',
>'p'='p', -ReturnField='navn', -ReturnField='gruppe',
>-SkipRecords=(SkipRecords_Value), -MaxRecords='1',
>-SortField='poeng', -SortOrder='Descending', -Search;
>
>//]   //  We start by analysing the given SkipRecords value to
>establish how many page
>//  links should be displayed, and from which page we start numbering in case the
>//  user jumped to the next set of pages.
>//[
>
>var: 'skip'=((Integer:(SkipRecords_Value)) + (Integer:(MaxRecords_Value)));
>var:'pages'=(Math_Ceil: ((decimal:(found_count)) / (decimal: (MaxRecords_Value))));
>If:$pages>=$maxpages; var:'pages'=$maxpages; /If;
>var:'page_calc'=(((Math_Floor:($skip /
>(decimal:((MaxRecords_Value) * $maxpages)))) * $maxpages) + 1);
>If:(math_mod:$skip, ((MaxRecords_Value) * $maxpages))==0;
>If:$skip==((MaxRecords_Value) * $maxpages); var:'page_no'=1;
>var:'skip2'=0; else; var:'page_no'=($page_calc - $maxpages);
>var:'skip2'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value)
>* $maxpages)))) * ((MaxRecords_Value) * $maxpages)) -
>((MaxRecords_Value) * $maxpages)); /If; Else;
>var:'page_no'=$page_calc; var:'skip2'=((Math_Floor:($skip /
>(decimal:((MaxRecords_Value) * $maxpages)))) *
>((MaxRecords_Value) * $maxpages)); /If; '
>
><p>\n';
>
>//] // The first possible hyperlink will lead the user to the
>very first record from // anywhere in the found set. //[
>
>If: (Shown_First)>=(MaxRecords_Value);
>'<A HREF="bryllup.lasso?-SkipRecords=0"><span class="text">F&oslash;rste</span></A>&nbsp;&nbsp;';
>else;
>'<span class="silver">F&oslash;rste</span>&nbsp;&nbsp;';
>/if;
>
>//] // The second hyperlink, if applicable, is there to jump to
>the previous set of // results pages //[
>
>If: $skip2>0;
>'<A HREF="bryllup.lasso?-SkipRecords=' + ((($page_no - 1) *
>(maxrecords_value)) - (maxrecords_value)) + '"><span class="text">Bakover</span></a>&nbsp;&nbsp;';
>Else;
>'<span class="silver">Bakover</span>&nbsp;&nbsp;';
>/If;
>
>//] // The third hyperlink, if applicable, simply brings the
>user to the previous // results page //[
>
>If: ($skip>(MaxRecords_Value));
>'<A HREF="bryllup.lasso?-SkipRecords=' + ($skip -
>((MaxRecords_Value) * 2)) + '"><span class="text">Forrige</span></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>Else;
>'<span class="silver">Forrige</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>/If;
>
>//] // Finally getting to the all important hyperlinks to
>individual pages. // This part of the routine uses the maxpages
>variable to define the // maximum number of page links to be
>displayed, which means that the user // may have clicked to the
>next or previous set of pages (see second // hyperlink
>description above). If the maximum is set to 10 with a //
>Maxrecords value of 10 and a found set of 200 records, the
>'pages' and // &quot;page_no&quot; variables take care of the
>correct page numbering, e.g 11-20 // for the second 'set'. //[
>
>loop: $pages;
>If:(((skiprecords_value) / (maxrecords_value)) + 1)==$page_no;
>'<span class="text"><b><u>' + $page_no + '</u></b></span>';
>else;
>'<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span
>class="text">' + $page_no + '</span></a>';
>/If;
>'&nbsp;&nbsp;';
>var:'page_no'=($page_no + 1), 'skip2'=($skip2 + (MaxRecords_Value));
>If: $skip2 >= (found_count);
>Loop_Abort;
>/If;
>/loop;
>
>//] // The equivalent of the third hyperlink, pointing to the
>next results page. //[
>
>If: (found_count>$skip);
>'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A
>HREF="bryllup.lasso?-SkipRecords=' + $skip + '"><span class="text">Neste</span></a>';
>Else;
>'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="silver">Neste</span>';
>/If;
>
>//] // The equivalent of the second hyperlink, jumping to the
>next set of pages. //[
>
>If: $skip2<(found_count);
>'&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 +
>'"><span class="text">Forover</span></a>';
>Else;
>'&nbsp;&nbsp;<span class="silver">Forover</span>';
>/If;
>
>//] // The last hyperlink requires some additional
>calculations, courtesy of // Michael Collins, to bring the user
>to the page displaying the very last // record. //[
>
>If: ((Found_Count) % (MaxRecords_Value))==0;
>Var:'Skip'=((Found_Count) - (MaxRecords_Value));
>else;
>Var:'Skip'=((MaxRecords_Value) *
>(Math_Floor:(decimal:(Found_Count)) / (decimal:(MaxRecords_Value))));
>/If;
>If:(($Skip) <= (Found_Count))&&((Shown_Last)!=(Found_Count));
>'&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $Skip +
>'"><span class="text">Siste</span></A>';
>else;
>'<span class="silver">&nbsp;&nbsp;Siste</span>';
>/if;
>
>
>/inline;
>?>
>
>#############################################################
>
>Attend the Lasso Developer Conference 2013!
>Sept 12-14, 2013 in Niagara Falls, Canada
>http://www.lassosoft.com/LDC-niagara-falls-2013
>
>#############################################################
>This message is sent to you because you are subscribed to
>the mailing list Lasso
>[hidden email]
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
Steve Piercy               Web Site Builder              
Soquel, CA
<[hidden email]>                  <http://www.StevePiercy.com/>


#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Script stop working on 8.6.1

Roy William Gabrielsen
Database is moved from FMSA 11 to FMS 12

Is this changed from 8.5 to 8.6 - or from MFSA11 to FMS12?

-KeyField='Internal record ID',

Could not find it here..
http://mail2.roygabrielsen.com/Reference.LassoApp?124

Some works, but not all
http://foto.fotografiens-hus.no/landskonkurransen/2013/aapen.lasso?-SkipRecords=29


1. juli 2013 kl. 23:56 skrev Steve Piercy - Web Site Builder <[hidden email]>:

> Comment out blocks of code until the error no longer appears.  Once isolated, insert code to debug the error, e.g., error_currenterror, action_statement.
>
> This is most likely a configuration issue on the new box.  Compare SiteAdmin settings for connectors, hosts, databases, tables, users, and groups.
>
> --steve
>
>
> On 7/1/13 at 6:16 PM, [hidden email] (Roy William Gabrielsen) pronounced:
>
>> Dear list
>>
>> This script worked on Mac OS X with Lasso 8.5.6
>> Stop working on CentOS with Lasso 8.6.1
>>
>> Where to look ?
>>
>> Thanx!
>>
>> Roy G
>>
>> <?LassoScript //
>> //  The only required variable is called "maxpages" and refers to the
>> //  maximum number of clickable page links displayed on the results page.
>> //[
>>
>> var: 'maxpages'=12;
>> inline:
>> -Database='Landskonkurransen2013', -Layout='poeng', -KeyField='Internal record ID',
>> 'Gruppe'='3',
>> 'p'='p', -ReturnField='navn', -ReturnField='gruppe', -SkipRecords=(SkipRecords_Value), -MaxRecords='1', -SortField='poeng', -SortOrder='Descending', -Search;
>>
>> //]   //  We start by analysing the given SkipRecords value to establish how many page
>> //  links should be displayed, and from which page we start numbering in case the
>> //  user jumped to the next set of pages.
>> //[
>>
>> var: 'skip'=((Integer:(SkipRecords_Value)) + (Integer:(MaxRecords_Value)));
>> var:'pages'=(Math_Ceil: ((decimal:(found_count)) / (decimal: (MaxRecords_Value))));
>> If:$pages>=$maxpages; var:'pages'=$maxpages; /If; var:'page_calc'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * $maxpages) + 1); If:(math_mod:$skip, ((MaxRecords_Value) * $maxpages))==0; If:$skip==((MaxRecords_Value) * $maxpages); var:'page_no'=1; var:'skip2'=0; else; var:'page_no'=($page_calc - $maxpages); var:'skip2'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * ((MaxRecords_Value) * $maxpages)) - ((MaxRecords_Value) * $maxpages)); /If; Else; var:'page_no'=$page_calc; var:'skip2'=((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * ((MaxRecords_Value) * $maxpages)); /If; '
>>
>> <p>\n';
>>
>> //] // The first possible hyperlink will lead the user to the very first record from // anywhere in the found set. //[
>>
>> If: (Shown_First)>=(MaxRecords_Value);
>> '<A HREF="bryllup.lasso?-SkipRecords=0"><span class="text">F&oslash;rste</span></A>&nbsp;&nbsp;';
>> else;
>> '<span class="silver">F&oslash;rste</span>&nbsp;&nbsp;';
>> /if;
>>
>> //] // The second hyperlink, if applicable, is there to jump to the previous set of // results pages //[
>>
>> If: $skip2>0;
>> '<A HREF="bryllup.lasso?-SkipRecords=' + ((($page_no - 1) * (maxrecords_value)) - (maxrecords_value)) + '"><span class="text">Bakover</span></a>&nbsp;&nbsp;';
>> Else;
>> '<span class="silver">Bakover</span>&nbsp;&nbsp;';
>> /If;
>>
>> //] // The third hyperlink, if applicable, simply brings the user to the previous // results page //[
>>
>> If: ($skip>(MaxRecords_Value));
>> '<A HREF="bryllup.lasso?-SkipRecords=' + ($skip - ((MaxRecords_Value) * 2)) + '"><span class="text">Forrige</span></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>> Else;
>> '<span class="silver">Forrige</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>> /If;
>>
>> //] // Finally getting to the all important hyperlinks to individual pages. // This part of the routine uses the maxpages variable to define the // maximum number of page links to be displayed, which means that the user // may have clicked to the next or previous set of pages (see second // hyperlink description above). If the maximum is set to 10 with a // Maxrecords value of 10 and a found set of 200 records, the 'pages' and // &quot;page_no&quot; variables take care of the correct page numbering, e.g 11-20 // for the second 'set'. //[
>>
>> loop: $pages;
>> If:(((skiprecords_value) / (maxrecords_value)) + 1)==$page_no;
>> '<span class="text"><b><u>' + $page_no + '</u></b></span>';
>> else;
>> '<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span class="text">' + $page_no + '</span></a>';
>> /If;
>> '&nbsp;&nbsp;';
>> var:'page_no'=($page_no + 1), 'skip2'=($skip2 + (MaxRecords_Value));
>> If: $skip2 >= (found_count);
>> Loop_Abort;
>> /If;
>> /loop;
>>
>> //] // The equivalent of the third hyperlink, pointing to the next results page. //[
>>
>> If: (found_count>$skip);
>> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip + '"><span class="text">Neste</span></a>';
>> Else;
>> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="silver">Neste</span>';
>> /If;
>>
>> //] // The equivalent of the second hyperlink, jumping to the next set of pages. //[
>>
>> If: $skip2<(found_count);
>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span class="text">Forover</span></a>';
>> Else;
>> '&nbsp;&nbsp;<span class="silver">Forover</span>';
>> /If;
>>
>> //] // The last hyperlink requires some additional calculations, courtesy of // Michael Collins, to bring the user to the page displaying the very last // record. //[
>>
>> If: ((Found_Count) % (MaxRecords_Value))==0;
>> Var:'Skip'=((Found_Count) - (MaxRecords_Value));
>> else;
>> Var:'Skip'=((MaxRecords_Value) * (Math_Floor:(decimal:(Found_Count)) / (decimal:(MaxRecords_Value))));
>> /If;
>> If:(($Skip) <= (Found_Count))&&((Shown_Last)!=(Found_Count));
>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $Skip + '"><span class="text">Siste</span></A>';
>> else;
>> '<span class="silver">&nbsp;&nbsp;Siste</span>';
>> /if;
>>
>>
>> /inline;
>> ?>
>>
>> #############################################################
>>
>> Attend the Lasso Developer Conference 2013!
>> Sept 12-14, 2013 in Niagara Falls, Canada
>> http://www.lassosoft.com/LDC-niagara-falls-2013
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso
>> [hidden email]
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy               Web Site Builder               Soquel, CA
> <[hidden email]>                  <http://www.StevePiercy.com/>
>
>
> #############################################################
>
> Attend the Lasso Developer Conference 2013!
> Sept 12-14, 2013 in Niagara Falls, Canada
> http://www.lassosoft.com/LDC-niagara-falls-2013
>
> #############################################################
> This message is sent to you because you are subscribed to
> the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Script stop working on 8.6.1

stevepiercy
Unless I missed the memo, Lasso 8 does not provide support of
FMSA 12 through the Lasso Connector for FileMaker SA.  I don't
know whether Lasso 8 works with FMSA 12 over the Lasso Connector
for ODBC.

When did you migrate from FMSA 11 to 12?  If recently, then you
may have introduced a new problem unrelated to your code.

--steve


On 8/12/13 at 2:05 AM, [hidden email] (Roy William
Gabrielsen) pronounced:

>Database is moved from FMSA 11 to FMS 12
>
>Is this changed from 8.5 to 8.6 - or from MFSA11 to FMS12?
>
>-KeyField='Internal record ID',
>
>Could not find it here..
>http://mail2.roygabrielsen.com/Reference.LassoApp?124
>
>Some works, but not all
>http://foto.fotografiens-hus.no/landskonkurransen/2013/aapen.lasso?-SkipRecords=29
>
>
>1. juli 2013 kl. 23:56 skrev Steve Piercy - Web Site Builder <[hidden email]>:
>
>>Comment out blocks of code until the error no longer appears.  Once isolated,
>insert code to debug the error, e.g., error_currenterror, action_statement.
>>
>>This is most likely a configuration issue on the new box.  Compare SiteAdmin
>settings for connectors, hosts, databases, tables, users, and groups.
>>
>>--steve
>>
>>
>>On 7/1/13 at 6:16 PM, [hidden email] (Roy William Gabrielsen) pronounced:
>>
>>> Dear list
>>>   This script worked on Mac OS X with Lasso 8.5.6
>>> Stop working on CentOS with Lasso 8.6.1
>>>   Where to look ?
>>>   Thanx!
>>>   Roy G
>>>   <?LassoScript //
>>> //  The only required variable is called "maxpages" and refers to the
>>> //  maximum number of clickable page links displayed on the results page.
>>> //[
>>>   var: 'maxpages'=12;
>>> inline:
>>> -Database='Landskonkurransen2013', -Layout='poeng', -KeyField='Internal record
>ID',
>>> 'Gruppe'='3',
>>> 'p'='p', -ReturnField='navn', -ReturnField='gruppe',
>-SkipRecords=(SkipRecords_Value), -MaxRecords='1',
>-SortField='poeng', -SortOrder='Descending', -Search;
>>>   //]   //  We start by analysing the given SkipRecords
>>>value to establish how
>many page
>>> //  links should be displayed, and from which page we start numbering in case
>the
>>> //  user jumped to the next set of pages.
>>> //[
>>>   var: 'skip'=((Integer:(SkipRecords_Value)) + (Integer:(MaxRecords_Value)));
>>> var:'pages'=(Math_Ceil: ((decimal:(found_count)) / (decimal:
>(MaxRecords_Value))));
>>> If:$pages>=$maxpages; var:'pages'=$maxpages; /If;
>var:'page_calc'=(((Math_Floor:($skip /
>(decimal:((MaxRecords_Value) * $maxpages)))) * $maxpages) + 1);
>If:(math_mod:$skip, ((MaxRecords_Value) * $maxpages))==0;
>If:$skip==((MaxRecords_Value) * $maxpages); var:'page_no'=1;
>var:'skip2'=0; else; var:'page_no'=($page_calc - $maxpages);
>var:'skip2'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value)
>* $maxpages)))) * ((MaxRecords_Value) * $maxpages)) -
>((MaxRecords_Value) * $maxpages)); /If; Else;
>var:'page_no'=$page_calc; var:'skip2'=((Math_Floor:($skip /
>(decimal:((MaxRecords_Value) * $maxpages)))) *
>((MaxRecords_Value) * $maxpages)); /If; '
>>>   <p>\n';
>>>   //] // The first possible hyperlink will lead the user to
>>>the very first record
>from // anywhere in the found set. //[
>>>   If: (Shown_First)>=(MaxRecords_Value);
>>> '<A HREF="bryllup.lasso?-SkipRecords=0"><span
>class="text">F&oslash;rste</span></A>&nbsp;&nbsp;';
>>> else;
>>> '<span class="silver">F&oslash;rste</span>&nbsp;&nbsp;';
>>> /if;
>>>   //] // The second hyperlink, if applicable, is there to
>>>jump to the previous set
>of // results pages //[
>>>   If: $skip2>0;
>>> '<A HREF="bryllup.lasso?-SkipRecords=' + ((($page_no - 1) * (maxrecords_value))
>- (maxrecords_value)) + '"><span class="text">Bakover</span></a>&nbsp;&nbsp;';
>>> Else;
>>> '<span class="silver">Bakover</span>&nbsp;&nbsp;';
>>> /If;
>>>   //] // The third hyperlink, if applicable, simply brings
>>>the user to the
>previous // results page //[
>>>   If: ($skip>(MaxRecords_Value));
>>> '<A HREF="bryllup.lasso?-SkipRecords=' + ($skip - ((MaxRecords_Value) * 2)) +
>'"><span class="text">Forrige</span></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>>> Else;
>>> '<span class="silver">Forrige</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>>> /If;
>>>   //] // Finally getting to the all important hyperlinks to
>>>individual pages. //
>This part of the routine uses the maxpages variable to define
>the // maximum number of page links to be displayed, which
>means that the user // may have clicked to the next or previous
>set of pages (see second // hyperlink description above). If
>the maximum is set to 10 with a // Maxrecords value of 10 and a
>found set of 200 records, the 'pages' and //
>&quot;page_no&quot; variables take care of the correct page
>numbering, e.g 11-20 // for the second 'set'. //[
>>>   loop: $pages;
>>> If:(((skiprecords_value) / (maxrecords_value)) + 1)==$page_no;
>>> '<span class="text"><b><u>' + $page_no + '</u></b></span>';
>>> else;
>>> '<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span class="text">' +
>$page_no + '</span></a>';
>>> /If;
>>> '&nbsp;&nbsp;';
>>> var:'page_no'=($page_no + 1), 'skip2'=($skip2 + (MaxRecords_Value));
>>> If: $skip2 >= (found_count);
>>> Loop_Abort;
>>> /If;
>>> /loop;
>>>   //] // The equivalent of the third hyperlink, pointing to
>>>the next results page.
>//[
>>>   If: (found_count>$skip);
>>> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip +
>'"><span class="text">Neste</span></a>';
>>> Else;
>>> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="silver">Neste</span>';
>>> /If;
>>>   //] // The equivalent of the second hyperlink, jumping to
>>>the next set of pages.
>//[
>>>   If: $skip2<(found_count);
>>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span
>class="text">Forover</span></a>';
>>> Else;
>>> '&nbsp;&nbsp;<span class="silver">Forover</span>';
>>> /If;
>>>   //] // The last hyperlink requires some additional
>>>calculations, courtesy of //
>Michael Collins, to bring the user to the page displaying the
>very last // record. //[
>>>   If: ((Found_Count) % (MaxRecords_Value))==0;
>>> Var:'Skip'=((Found_Count) - (MaxRecords_Value));
>>> else;
>>> Var:'Skip'=((MaxRecords_Value) * (Math_Floor:(decimal:(Found_Count)) /
>(decimal:(MaxRecords_Value))));
>>> /If;
>>> If:(($Skip) <= (Found_Count))&&((Shown_Last)!=(Found_Count));
>>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $Skip + '"><span
>class="text">Siste</span></A>';
>>> else;
>>> '<span class="silver">&nbsp;&nbsp;Siste</span>';
>>> /if;
>>>    /inline;
>>> ?>
>>>   #############################################################
>>>   Attend the Lasso Developer Conference 2013!
>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>> http://www.lassosoft.com/LDC-niagara-falls-2013
>>>   #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso
>>> [hidden email]
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>
>>-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>Steve Piercy               Web Site Builder               Soquel, CA
>><[hidden email]>                  <http://www.StevePiercy.com/>
>>
>>
>>#############################################################
>>
>>Attend the Lasso Developer Conference 2013!
>>Sept 12-14, 2013 in Niagara Falls, Canada
>>http://www.lassosoft.com/LDC-niagara-falls-2013
>>
>>#############################################################
>>This message is sent to you because you are subscribed to
>>the mailing list Lasso
>>[hidden email]
>>To unsubscribe, E-mail to: <[hidden email]>
>>Send administrative queries to  <[hidden email]>
>
>
>#############################################################
>
>Attend the Lasso Developer Conference 2013!
>Sept 12-14, 2013 in Niagara Falls, Canada
>http://www.lassosoft.com/LDC-niagara-falls-2013
>
>#############################################################
>This message is sent to you because you are subscribed to
>the mailing list Lasso
>[hidden email]
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
Steve Piercy               Web Site Builder              
Soquel, CA
<[hidden email]>                  <http://www.StevePiercy.com/>


#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Script stop working on 8.6.1

Rachel Guthrie
Yep, you missed the memo
http://www.lassosoft.com/News-Compatibility-of-Lasso-and-FMSA12


Rachel Guthrie

On 2013-08-11, at 9:25 PM, Steve Piercy - Web Site Builder <[hidden email]> wrote:

> Unless I missed the memo, Lasso 8 does not provide support of FMSA 12 through the Lasso Connector for FileMaker SA.  I don't know whether Lasso 8 works with FMSA 12 over the Lasso Connector for ODBC.
>
> When did you migrate from FMSA 11 to 12?  If recently, then you may have introduced a new problem unrelated to your code.
>
> --steve
>
>
> On 8/12/13 at 2:05 AM, [hidden email] (Roy William Gabrielsen) pronounced:
>
>> Database is moved from FMSA 11 to FMS 12
>>
>> Is this changed from 8.5 to 8.6 - or from MFSA11 to FMS12?
>>
>> -KeyField='Internal record ID',
>>
>> Could not find it here..
>> http://mail2.roygabrielsen.com/Reference.LassoApp?124
>>
>> Some works, but not all
>> http://foto.fotografiens-hus.no/landskonkurransen/2013/aapen.lasso?-SkipRecords=29
>>
>>
>> 1. juli 2013 kl. 23:56 skrev Steve Piercy - Web Site Builder <[hidden email]>:
>>
>>> Comment out blocks of code until the error no longer appears.  Once isolated,
>> insert code to debug the error, e.g., error_currenterror, action_statement.
>>>
>>> This is most likely a configuration issue on the new box.  Compare SiteAdmin
>> settings for connectors, hosts, databases, tables, users, and groups.
>>>
>>> --steve
>>>
>>>
>>> On 7/1/13 at 6:16 PM, [hidden email] (Roy William Gabrielsen) pronounced:
>>>
>>>> Dear list
>>>>  This script worked on Mac OS X with Lasso 8.5.6
>>>> Stop working on CentOS with Lasso 8.6.1
>>>>  Where to look ?
>>>>  Thanx!
>>>>  Roy G
>>>>  <?LassoScript //
>>>> //  The only required variable is called "maxpages" and refers to the
>>>> //  maximum number of clickable page links displayed on the results page.
>>>> //[
>>>>  var: 'maxpages'=12;
>>>> inline:
>>>> -Database='Landskonkurransen2013', -Layout='poeng', -KeyField='Internal record
>> ID',
>>>> 'Gruppe'='3',
>>>> 'p'='p', -ReturnField='navn', -ReturnField='gruppe',
>> -SkipRecords=(SkipRecords_Value), -MaxRecords='1', -SortField='poeng', -SortOrder='Descending', -Search;
>>>>  //]   //  We start by analysing the given SkipRecords value to establish how
>> many page
>>>> //  links should be displayed, and from which page we start numbering in case
>> the
>>>> //  user jumped to the next set of pages.
>>>> //[
>>>>  var: 'skip'=((Integer:(SkipRecords_Value)) + (Integer:(MaxRecords_Value)));
>>>> var:'pages'=(Math_Ceil: ((decimal:(found_count)) / (decimal:
>> (MaxRecords_Value))));
>>>> If:$pages>=$maxpages; var:'pages'=$maxpages; /If;
>> var:'page_calc'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * $maxpages) + 1); If:(math_mod:$skip, ((MaxRecords_Value) * $maxpages))==0; If:$skip==((MaxRecords_Value) * $maxpages); var:'page_no'=1; var:'skip2'=0; else; var:'page_no'=($page_calc - $maxpages); var:'skip2'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * ((MaxRecords_Value) * $maxpages)) - ((MaxRecords_Value) * $maxpages)); /If; Else; var:'page_no'=$page_calc; var:'skip2'=((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * ((MaxRecords_Value) * $maxpages)); /If; '
>>>>  <p>\n';
>>>>  //] // The first possible hyperlink will lead the user to the very first record
>> from // anywhere in the found set. //[
>>>>  If: (Shown_First)>=(MaxRecords_Value);
>>>> '<A HREF="bryllup.lasso?-SkipRecords=0"><span
>> class="text">F&oslash;rste</span></A>&nbsp;&nbsp;';
>>>> else;
>>>> '<span class="silver">F&oslash;rste</span>&nbsp;&nbsp;';
>>>> /if;
>>>>  //] // The second hyperlink, if applicable, is there to jump to the previous set
>> of // results pages //[
>>>>  If: $skip2>0;
>>>> '<A HREF="bryllup.lasso?-SkipRecords=' + ((($page_no - 1) * (maxrecords_value))
>> - (maxrecords_value)) + '"><span class="text">Bakover</span></a>&nbsp;&nbsp;';
>>>> Else;
>>>> '<span class="silver">Bakover</span>&nbsp;&nbsp;';
>>>> /If;
>>>>  //] // The third hyperlink, if applicable, simply brings the user to the
>> previous // results page //[
>>>>  If: ($skip>(MaxRecords_Value));
>>>> '<A HREF="bryllup.lasso?-SkipRecords=' + ($skip - ((MaxRecords_Value) * 2)) +
>> '"><span class="text">Forrige</span></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>>>> Else;
>>>> '<span class="silver">Forrige</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>>>> /If;
>>>>  //] // Finally getting to the all important hyperlinks to individual pages. //
>> This part of the routine uses the maxpages variable to define the // maximum number of page links to be displayed, which means that the user // may have clicked to the next or previous set of pages (see second // hyperlink description above). If the maximum is set to 10 with a // Maxrecords value of 10 and a found set of 200 records, the 'pages' and // &quot;page_no&quot; variables take care of the correct page numbering, e.g 11-20 // for the second 'set'. //[
>>>>  loop: $pages;
>>>> If:(((skiprecords_value) / (maxrecords_value)) + 1)==$page_no;
>>>> '<span class="text"><b><u>' + $page_no + '</u></b></span>';
>>>> else;
>>>> '<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span class="text">' +
>> $page_no + '</span></a>';
>>>> /If;
>>>> '&nbsp;&nbsp;';
>>>> var:'page_no'=($page_no + 1), 'skip2'=($skip2 + (MaxRecords_Value));
>>>> If: $skip2 >= (found_count);
>>>> Loop_Abort;
>>>> /If;
>>>> /loop;
>>>>  //] // The equivalent of the third hyperlink, pointing to the next results page.
>> //[
>>>>  If: (found_count>$skip);
>>>> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip +
>> '"><span class="text">Neste</span></a>';
>>>> Else;
>>>> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="silver">Neste</span>';
>>>> /If;
>>>>  //] // The equivalent of the second hyperlink, jumping to the next set of pages.
>> //[
>>>>  If: $skip2<(found_count);
>>>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span
>> class="text">Forover</span></a>';
>>>> Else;
>>>> '&nbsp;&nbsp;<span class="silver">Forover</span>';
>>>> /If;
>>>>  //] // The last hyperlink requires some additional calculations, courtesy of //
>> Michael Collins, to bring the user to the page displaying the very last // record. //[
>>>>  If: ((Found_Count) % (MaxRecords_Value))==0;
>>>> Var:'Skip'=((Found_Count) - (MaxRecords_Value));
>>>> else;
>>>> Var:'Skip'=((MaxRecords_Value) * (Math_Floor:(decimal:(Found_Count)) /
>> (decimal:(MaxRecords_Value))));
>>>> /If;
>>>> If:(($Skip) <= (Found_Count))&&((Shown_Last)!=(Found_Count));
>>>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $Skip + '"><span
>> class="text">Siste</span></A>';
>>>> else;
>>>> '<span class="silver">&nbsp;&nbsp;Siste</span>';
>>>> /if;
>>>>   /inline;
>>>> ?>
>>>>  #############################################################
>>>>  Attend the Lasso Developer Conference 2013!
>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>> http://www.lassosoft.com/LDC-niagara-falls-2013
>>>>  #############################################################
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list Lasso
>>>> [hidden email]
>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>> Send administrative queries to  <[hidden email]>
>>>
>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>> Steve Piercy               Web Site Builder               Soquel, CA
>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>
>>>
>>> #############################################################
>>>
>>> Attend the Lasso Developer Conference 2013!
>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>> http://www.lassosoft.com/LDC-niagara-falls-2013
>>>
>>> #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso
>>> [hidden email]
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>
>>
>> #############################################################
>>
>> Attend the Lasso Developer Conference 2013!
>> Sept 12-14, 2013 in Niagara Falls, Canada
>> http://www.lassosoft.com/LDC-niagara-falls-2013
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso
>> [hidden email]
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy               Web Site Builder               Soquel, CA
> <[hidden email]>                  <http://www.StevePiercy.com/>
>
>
> #############################################################
>
> Attend the Lasso Developer Conference 2013!
> Sept 12-14, 2013 in Niagara Falls, Canada
> http://www.lassosoft.com/LDC-niagara-falls-2013
>
> #############################################################
> This message is sent to you because you are subscribed to
> the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Script stop working on 8.6.1

Roy William Gabrielsen
In reply to this post by stevepiercy
Steve

I migrate several sites about 6 weeks ago, and they all works (with MySQL) - except from this - and other FMP related - where this specific gallery script not working properly.
I have not FMSA 12 but FMS 12. Thats the reason..? Much working, but not all.
Only solution is to upgrade FMSA 12 ? - or convert to MySQL.. I go for the last one.

Roy

12. aug. 2013 kl. 02:25 skrev Steve Piercy - Web Site Builder <[hidden email]>:

> Unless I missed the memo, Lasso 8 does not provide support of FMSA 12 through the Lasso Connector for FileMaker SA.  I don't know whether Lasso 8 works with FMSA 12 over the Lasso Connector for ODBC.
>
> When did you migrate from FMSA 11 to 12?  If recently, then you may have introduced a new problem unrelated to your code.
>
> --steve
>
>
> On 8/12/13 at 2:05 AM, [hidden email] (Roy William Gabrielsen) pronounced:
>
>> Database is moved from FMSA 11 to FMS 12
>>
>> Is this changed from 8.5 to 8.6 - or from MFSA11 to FMS12?
>>
>> -KeyField='Internal record ID',
>>
>> Could not find it here..
>> http://mail2.roygabrielsen.com/Reference.LassoApp?124
>>
>> Some works, but not all
>> http://foto.fotografiens-hus.no/landskonkurransen/2013/aapen.lasso?-SkipRecords=29
>>
>>
>> 1. juli 2013 kl. 23:56 skrev Steve Piercy - Web Site Builder <[hidden email]>:
>>
>>> Comment out blocks of code until the error no longer appears.  Once isolated,
>> insert code to debug the error, e.g., error_currenterror, action_statement.
>>>
>>> This is most likely a configuration issue on the new box.  Compare SiteAdmin
>> settings for connectors, hosts, databases, tables, users, and groups.
>>>
>>> --steve
>>>
>>>
>>> On 7/1/13 at 6:16 PM, [hidden email] (Roy William Gabrielsen) pronounced:
>>>
>>>> Dear list
>>>>  This script worked on Mac OS X with Lasso 8.5.6
>>>> Stop working on CentOS with Lasso 8.6.1
>>>>  Where to look ?
>>>>  Thanx!
>>>>  Roy G
>>>>  <?LassoScript //
>>>> //  The only required variable is called "maxpages" and refers to the
>>>> //  maximum number of clickable page links displayed on the results page.
>>>> //[
>>>>  var: 'maxpages'=12;
>>>> inline:
>>>> -Database='Landskonkurransen2013', -Layout='poeng', -KeyField='Internal record
>> ID',
>>>> 'Gruppe'='3',
>>>> 'p'='p', -ReturnField='navn', -ReturnField='gruppe',
>> -SkipRecords=(SkipRecords_Value), -MaxRecords='1', -SortField='poeng', -SortOrder='Descending', -Search;
>>>>  //]   //  We start by analysing the given SkipRecords value to establish how
>> many page
>>>> //  links should be displayed, and from which page we start numbering in case
>> the
>>>> //  user jumped to the next set of pages.
>>>> //[
>>>>  var: 'skip'=((Integer:(SkipRecords_Value)) + (Integer:(MaxRecords_Value)));
>>>> var:'pages'=(Math_Ceil: ((decimal:(found_count)) / (decimal:
>> (MaxRecords_Value))));
>>>> If:$pages>=$maxpages; var:'pages'=$maxpages; /If;
>> var:'page_calc'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * $maxpages) + 1); If:(math_mod:$skip, ((MaxRecords_Value) * $maxpages))==0; If:$skip==((MaxRecords_Value) * $maxpages); var:'page_no'=1; var:'skip2'=0; else; var:'page_no'=($page_calc - $maxpages); var:'skip2'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * ((MaxRecords_Value) * $maxpages)) - ((MaxRecords_Value) * $maxpages)); /If; Else; var:'page_no'=$page_calc; var:'skip2'=((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * ((MaxRecords_Value) * $maxpages)); /If; '
>>>>  <p>\n';
>>>>  //] // The first possible hyperlink will lead the user to the very first record
>> from // anywhere in the found set. //[
>>>>  If: (Shown_First)>=(MaxRecords_Value);
>>>> '<A HREF="bryllup.lasso?-SkipRecords=0"><span
>> class="text">F&oslash;rste</span></A>&nbsp;&nbsp;';
>>>> else;
>>>> '<span class="silver">F&oslash;rste</span>&nbsp;&nbsp;';
>>>> /if;
>>>>  //] // The second hyperlink, if applicable, is there to jump to the previous set
>> of // results pages //[
>>>>  If: $skip2>0;
>>>> '<A HREF="bryllup.lasso?-SkipRecords=' + ((($page_no - 1) * (maxrecords_value))
>> - (maxrecords_value)) + '"><span class="text">Bakover</span></a>&nbsp;&nbsp;';
>>>> Else;
>>>> '<span class="silver">Bakover</span>&nbsp;&nbsp;';
>>>> /If;
>>>>  //] // The third hyperlink, if applicable, simply brings the user to the
>> previous // results page //[
>>>>  If: ($skip>(MaxRecords_Value));
>>>> '<A HREF="bryllup.lasso?-SkipRecords=' + ($skip - ((MaxRecords_Value) * 2)) +
>> '"><span class="text">Forrige</span></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>>>> Else;
>>>> '<span class="silver">Forrige</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>>>> /If;
>>>>  //] // Finally getting to the all important hyperlinks to individual pages. //
>> This part of the routine uses the maxpages variable to define the // maximum number of page links to be displayed, which means that the user // may have clicked to the next or previous set of pages (see second // hyperlink description above). If the maximum is set to 10 with a // Maxrecords value of 10 and a found set of 200 records, the 'pages' and // &quot;page_no&quot; variables take care of the correct page numbering, e.g 11-20 // for the second 'set'. //[
>>>>  loop: $pages;
>>>> If:(((skiprecords_value) / (maxrecords_value)) + 1)==$page_no;
>>>> '<span class="text"><b><u>' + $page_no + '</u></b></span>';
>>>> else;
>>>> '<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span class="text">' +
>> $page_no + '</span></a>';
>>>> /If;
>>>> '&nbsp;&nbsp;';
>>>> var:'page_no'=($page_no + 1), 'skip2'=($skip2 + (MaxRecords_Value));
>>>> If: $skip2 >= (found_count);
>>>> Loop_Abort;
>>>> /If;
>>>> /loop;
>>>>  //] // The equivalent of the third hyperlink, pointing to the next results page.
>> //[
>>>>  If: (found_count>$skip);
>>>> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip +
>> '"><span class="text">Neste</span></a>';
>>>> Else;
>>>> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="silver">Neste</span>';
>>>> /If;
>>>>  //] // The equivalent of the second hyperlink, jumping to the next set of pages.
>> //[
>>>>  If: $skip2<(found_count);
>>>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span
>> class="text">Forover</span></a>';
>>>> Else;
>>>> '&nbsp;&nbsp;<span class="silver">Forover</span>';
>>>> /If;
>>>>  //] // The last hyperlink requires some additional calculations, courtesy of //
>> Michael Collins, to bring the user to the page displaying the very last // record. //[
>>>>  If: ((Found_Count) % (MaxRecords_Value))==0;
>>>> Var:'Skip'=((Found_Count) - (MaxRecords_Value));
>>>> else;
>>>> Var:'Skip'=((MaxRecords_Value) * (Math_Floor:(decimal:(Found_Count)) /
>> (decimal:(MaxRecords_Value))));
>>>> /If;
>>>> If:(($Skip) <= (Found_Count))&&((Shown_Last)!=(Found_Count));
>>>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $Skip + '"><span
>> class="text">Siste</span></A>';
>>>> else;
>>>> '<span class="silver">&nbsp;&nbsp;Siste</span>';
>>>> /if;
>>>>   /inline;
>>>> ?>
>>>>  #############################################################
>>>>  Attend the Lasso Developer Conference 2013!
>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>> http://www.lassosoft.com/LDC-niagara-falls-2013
>>>>  #############################################################
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list Lasso
>>>> [hidden email]
>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>> Send administrative queries to  <[hidden email]>
>>>
>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>> Steve Piercy               Web Site Builder               Soquel, CA
>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>
>>>
>>> #############################################################
>>>
>>> Attend the Lasso Developer Conference 2013!
>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>> http://www.lassosoft.com/LDC-niagara-falls-2013
>>>
>>> #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso
>>> [hidden email]
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>
>>
>> #############################################################
>>
>> Attend the Lasso Developer Conference 2013!
>> Sept 12-14, 2013 in Niagara Falls, Canada
>> http://www.lassosoft.com/LDC-niagara-falls-2013
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso
>> [hidden email]
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy               Web Site Builder               Soquel, CA
> <[hidden email]>                  <http://www.StevePiercy.com/>
>
>
> #############################################################
>
> Attend the Lasso Developer Conference 2013!
> Sept 12-14, 2013 in Niagara Falls, Canada
> http://www.lassosoft.com/LDC-niagara-falls-2013
>
> #############################################################
> This message is sent to you because you are subscribed to
> the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Script stop working on 8.6.1

stevepiercy
In reply to this post by Rachel Guthrie
OK, thanks.

I suggest updating the documentation and marketing on
lassosoft.com accordingly as FMS/A 12 is omitted from being supported.
http://www.lassosoft.com/Connecting-Lasso-and-FileMaker
http://www.lassosoft.com/FileMaker-Quick-Start
http://www.lassosoft.com/Connecting-Lasso-and-FileMaker-via-ODBC
and possibly more.  lassoguide.com, too.

--steve


On 8/11/13 at 10:58 PM, [hidden email] (Rachel Guthrie) pronounced:

>Yep, you missed the memo
>http://www.lassosoft.com/News-Compatibility-of-Lasso-and-FMSA12
>
>
>Rachel Guthrie
>
>On 2013-08-11, at 9:25 PM, Steve Piercy - Web Site Builder <[hidden email]> wrote:
>
>>Unless I missed the memo, Lasso 8 does not provide support of FMSA 12 through the Lasso Connector
>for FileMaker SA.  I don't know whether Lasso 8 works with FMSA 12 over the Lasso Connector for ODBC.
>>
>>When did you migrate from FMSA 11 to 12?  If recently, then you may have introduced a new problem
>unrelated to your code.
>>
>>--steve
>>
>>
>>On 8/12/13 at 2:05 AM, [hidden email] (Roy William Gabrielsen) pronounced:
>>
>>> Database is moved from FMSA 11 to FMS 12
>>>   Is this changed from 8.5 to 8.6 - or from MFSA11 to FMS12?
>>>   -KeyField='Internal record ID',
>>>   Could not find it here..
>>> http://mail2.roygabrielsen.com/Reference.LassoApp?124
>>>   Some works, but not all
>>> http://foto.fotografiens-hus.no/landskonkurransen/2013/aapen.lasso?-SkipRecords=29
>>>    1. juli 2013 kl. 23:56 skrev Steve Piercy - Web Site
>>>Builder <[hidden email]>:
>>>
>>>> Comment out blocks of code until the error no longer appears.  Once isolated,
>>> insert code to debug the error, e.g., error_currenterror, action_statement.
>>>>   This is most likely a configuration issue on the new
>>>>box.  Compare SiteAdmin
>>> settings for connectors, hosts, databases, tables, users, and groups.
>>>>   --steve
>>>>    On 7/1/13 at 6:16 PM, [hidden email] (Roy William
>>>>Gabrielsen) pronounced:
>>>>
>>>>> Dear list
>>>>>  This script worked on Mac OS X with Lasso 8.5.6
>>>>> Stop working on CentOS with Lasso 8.6.1
>>>>>  Where to look ?
>>>>>  Thanx!
>>>>>  Roy G
>>>>>  <?LassoScript //
>>>>> //  The only required variable is called "maxpages" and refers to the
>>>>> //  maximum number of clickable page links displayed on the results page.
>>>>> //[
>>>>>  var: 'maxpages'=12;
>>>>> inline:
>>>>> -Database='Landskonkurransen2013', -Layout='poeng', -KeyField='Internal record
>>> ID',
>>>>> 'Gruppe'='3',
>>>>> 'p'='p', -ReturnField='navn', -ReturnField='gruppe',
>>> -SkipRecords=(SkipRecords_Value), -MaxRecords='1', -SortField='poeng', -SortOrder='Descending',
>-Search;
>>>>>  //]   //  We start by analysing the given SkipRecords value to establish how
>>> many page
>>>>> //  links should be displayed, and from which page we start numbering in case
>>> the
>>>>> //  user jumped to the next set of pages.
>>>>> //[
>>>>>  var: 'skip'=((Integer:(SkipRecords_Value)) + (Integer:(MaxRecords_Value)));
>>>>> var:'pages'=(Math_Ceil: ((decimal:(found_count)) / (decimal:
>>> (MaxRecords_Value))));
>>>>> If:$pages>=$maxpages; var:'pages'=$maxpages; /If;
>>> var:'page_calc'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value) * $maxpages)))) * $maxpages) +
>1); If:(math_mod:$skip, ((MaxRecords_Value) * $maxpages))==0;
>If:$skip==((MaxRecords_Value) * $maxpages); var:'page_no'=1;
>var:'skip2'=0; else; var:'page_no'=($page_calc - $maxpages);
>var:'skip2'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value)
>* $maxpages)))) * ((MaxRecords_Value) * $maxpages)) -
>((MaxRecords_Value) * $maxpages)); /If; Else;
>var:'page_no'=$page_calc; var:'skip2'=((Math_Floor:($skip /
>(decimal:((MaxRecords_Value) * $maxpages)))) *
>((MaxRecords_Value) * $maxpages)); /If; '
>>>>>  <p>\n';
>>>>>  //] // The first possible hyperlink will lead the user to the very first record
>>> from // anywhere in the found set. //[
>>>>>  If: (Shown_First)>=(MaxRecords_Value);
>>>>> '<A HREF="bryllup.lasso?-SkipRecords=0"><span
>>> class="text">F&oslash;rste</span></A>&nbsp;&nbsp;';
>>>>> else;
>>>>> '<span class="silver">F&oslash;rste</span>&nbsp;&nbsp;';
>>>>> /if;
>>>>>  //] // The second hyperlink, if applicable, is there to jump to the previous set
>>> of // results pages //[
>>>>>  If: $skip2>0;
>>>>> '<A HREF="bryllup.lasso?-SkipRecords=' + ((($page_no - 1) * (maxrecords_value))
>>> - (maxrecords_value)) + '"><span class="text">Bakover</span></a>&nbsp;&nbsp;';
>>>>> Else;
>>>>> '<span class="silver">Bakover</span>&nbsp;&nbsp;';
>>>>> /If;
>>>>>  //] // The third hyperlink, if applicable, simply brings the user to the
>>> previous // results page //[
>>>>>  If: ($skip>(MaxRecords_Value));
>>>>> '<A HREF="bryllup.lasso?-SkipRecords=' + ($skip - ((MaxRecords_Value) * 2)) +
>>> '"><span class="text">Forrige</span></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>>>>> Else;
>>>>> '<span class="silver">Forrige</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>>>>> /If;
>>>>>  //] // Finally getting to the all important hyperlinks to individual pages. //
>>> This part of the routine uses the maxpages variable to define the // maximum number of page links
>to be displayed, which means that the user // may have clicked
>to the next or previous set of pages (see second // hyperlink
>description above). If the maximum is set to 10 with a //
>Maxrecords value of 10 and a found set of 200 records, the
>'pages' and // &quot;page_no&quot; variables take care of the
>correct page numbering, e.g 11-20 // for the second 'set'. //[
>>>>>  loop: $pages;
>>>>> If:(((skiprecords_value) / (maxrecords_value)) + 1)==$page_no;
>>>>> '<span class="text"><b><u>' + $page_no + '</u></b></span>';
>>>>> else;
>>>>> '<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span class="text">' +
>>> $page_no + '</span></a>';
>>>>> /If;
>>>>> '&nbsp;&nbsp;';
>>>>> var:'page_no'=($page_no + 1), 'skip2'=($skip2 + (MaxRecords_Value));
>>>>> If: $skip2 >= (found_count);
>>>>> Loop_Abort;
>>>>> /If;
>>>>> /loop;
>>>>>  //] // The equivalent of the third hyperlink, pointing to the next results page.
>>> //[
>>>>>  If: (found_count>$skip);
>>>>> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip +
>>> '"><span class="text">Neste</span></a>';
>>>>> Else;
>>>>> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="silver">Neste</span>';
>>>>> /If;
>>>>>  //] // The equivalent of the second hyperlink, jumping to the next set of pages.
>>> //[
>>>>>  If: $skip2<(found_count);
>>>>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span
>>> class="text">Forover</span></a>';
>>>>> Else;
>>>>> '&nbsp;&nbsp;<span class="silver">Forover</span>';
>>>>> /If;
>>>>>  //] // The last hyperlink requires some additional calculations, courtesy of //
>>> Michael Collins, to bring the user to the page displaying the very last // record. //[
>>>>>  If: ((Found_Count) % (MaxRecords_Value))==0;
>>>>> Var:'Skip'=((Found_Count) - (MaxRecords_Value));
>>>>> else;
>>>>> Var:'Skip'=((MaxRecords_Value) * (Math_Floor:(decimal:(Found_Count)) /
>>> (decimal:(MaxRecords_Value))));
>>>>> /If;
>>>>> If:(($Skip) <= (Found_Count))&&((Shown_Last)!=(Found_Count));
>>>>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $Skip + '"><span
>>> class="text">Siste</span></A>';
>>>>> else;
>>>>> '<span class="silver">&nbsp;&nbsp;Siste</span>';
>>>>> /if;
>>>>>   /inline;
>>>>> ?>
>>>>>  #############################################################
>>>>>  Attend the Lasso Developer Conference 2013!
>>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>>> http://www.lassosoft.com/LDC-niagara-falls-2013
>>>>>  #############################################################
>>>>> This message is sent to you because you are subscribed to
>>>>> the mailing list Lasso
>>>>> [hidden email]
>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>> Send administrative queries to  <[hidden email]>
>>>>   -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>>-- -- -- --
>>>> Steve Piercy               Web Site Builder               Soquel, CA
>>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>>    #############################################################
>>>>   Attend the Lasso Developer Conference 2013!
>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>> http://www.lassosoft.com/LDC-niagara-falls-2013
>>>>   #############################################################
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list Lasso
>>>> [hidden email]
>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>> Send administrative queries to  <[hidden email]>
>>>    #############################################################
>>>   Attend the Lasso Developer Conference 2013!
>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>> http://www.lassosoft.com/LDC-niagara-falls-2013
>>>   #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso
>>> [hidden email]
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>
>>-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>Steve Piercy               Web Site Builder               Soquel, CA
>><[hidden email]>                  <http://www.StevePiercy.com/>
>>
>>
>>#############################################################
>>
>>Attend the Lasso Developer Conference 2013!
>>Sept 12-14, 2013 in Niagara Falls, Canada
>>http://www.lassosoft.com/LDC-niagara-falls-2013
>>
>>#############################################################
>>This message is sent to you because you are subscribed to
>>the mailing list Lasso
>>[hidden email]
>>To unsubscribe, E-mail to: <[hidden email]>
>>Send administrative queries to  <[hidden email]>
>
>
>#############################################################
>
>Attend the Lasso Developer Conference 2013!
>Sept 12-14, 2013 in Niagara Falls, Canada
>http://www.lassosoft.com/LDC-niagara-falls-2013
>
>#############################################################
>This message is sent to you because you are subscribed to
>the mailing list Lasso
>[hidden email]
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
Steve Piercy               Web Site Builder              
Soquel, CA
<[hidden email]>                  <http://www.StevePiercy.com/>


#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Script stop working on 8.6.1

stevepiercy
In reply to this post by Roy William Gabrielsen
As Rachel corrected me, Lasso 8.6 works with FMS 12.

Since you say you migrated about 6 weeks ago, I will assume that
the LassoScript you originally pasted on July 1 stopped working
when you migrated from FMS 11 to FMS 12.  Whether you have FMSA
or FMS does not matter from Lasso's perspective.

Therefore the most likely candidate is something in the
migration from FMS 11 to 12.  There are about a half-dozen
things that can go wrong, and various techniques to troubleshoot.

In addition to my two previous suggestions, you can do the following:

* Open the db in question via FMP and check that all
relationships are valid and not broken.
* Run through the FMS 9 Quick Start Guide (its version is still
pretty valid and there is another one, too, but catered more
toward Lasso 9).
http://www.lassosoft.com/_downloads/public/Documentation_and_Guides/Lasso_Professional_8.5/FileMaker%20Server%209%20Quick%20Start.pdf
* Review the documentation from FileMaker regarding database
upgrades.  There are over a dozen detailed steps for that alone.

Once you try those various things, report back the results, and
we might be able to help narrow it down.  At this point there's
not enough information to do much else.

I don't recommend migrating to MySQL from FMS 12 if the only
reason is that you don't know why your Lasso code no longer
works after migration from FMS 11 to FMS 12.  It's most likely
something very simple.  Moreover, migrations from FM to MySQL
are rarely quick and easy things.  Nonetheless, if you don't
need the nice GUI of FMP and you do need higher performance in a
database, then MySQL would be a good option.

--steve


On 8/12/13 at 5:50 AM, [hidden email] (Roy William
Gabrielsen) pronounced:

>Steve
>
>I migrate several sites about 6 weeks ago, and they all works
>(with MySQL) - except from this - and other FMP related - where
>this specific gallery script not working properly. I have not
>FMSA 12 but FMS 12. Thats the reason..? Much working, but not all.
>Only solution is to upgrade FMSA 12 ? - or convert to MySQL.. I
>go for the last one.
>Roy
>
>12. aug. 2013 kl. 02:25 skrev Steve Piercy - Web Site Builder <[hidden email]>:
>
>>Unless I missed the memo, Lasso 8 does not provide support of FMSA 12 through the
>Lasso Connector for FileMaker SA.  I don't know whether Lasso 8
>works with FMSA 12 over the Lasso Connector for ODBC.
>>
>>When did you migrate from FMSA 11 to 12?  If recently, then you may have
>introduced a new problem unrelated to your code.
>>
>>--steve
>>
>>
>>On 8/12/13 at 2:05 AM, [hidden email] (Roy William Gabrielsen) pronounced:
>>
>>> Database is moved from FMSA 11 to FMS 12
>>>   Is this changed from 8.5 to 8.6 - or from MFSA11 to FMS12?
>>>   -KeyField='Internal record ID',
>>>   Could not find it here..
>>> http://mail2.roygabrielsen.com/Reference.LassoApp?124
>>>   Some works, but not all
>>>
>http://foto.fotografiens-hus.no/landskonkurransen/2013/aapen.lasso?-SkipRecords=29
>>>    1. juli 2013 kl. 23:56 skrev Steve Piercy - Web Site Builder
><[hidden email]>:
>>>
>>>> Comment out blocks of code until the error no longer appears.  Once isolated,
>>> insert code to debug the error, e.g., error_currenterror, action_statement.
>>>>   This is most likely a configuration issue on the new
>>>>box.  Compare SiteAdmin
>>> settings for connectors, hosts, databases, tables, users, and groups.
>>>>   --steve
>>>>    On 7/1/13 at 6:16 PM, [hidden email] (Roy William Gabrielsen)
>pronounced:
>>>>
>>>>> Dear list
>>>>>  This script worked on Mac OS X with Lasso 8.5.6
>>>>> Stop working on CentOS with Lasso 8.6.1
>>>>>  Where to look ?
>>>>>  Thanx!
>>>>>  Roy G
>>>>>  <?LassoScript //
>>>>> //  The only required variable is called "maxpages" and refers to the
>>>>> //  maximum number of clickable page links displayed on the results page.
>>>>> //[
>>>>>  var: 'maxpages'=12;
>>>>> inline:
>>>>> -Database='Landskonkurransen2013', -Layout='poeng', -KeyField='Internal record
>>> ID',
>>>>> 'Gruppe'='3',
>>>>> 'p'='p', -ReturnField='navn', -ReturnField='gruppe',
>>> -SkipRecords=(SkipRecords_Value), -MaxRecords='1', -SortField='poeng',
>-SortOrder='Descending', -Search;
>>>>>  //]   //  We start by analysing the given SkipRecords value to establish how
>>> many page
>>>>> //  links should be displayed, and from which page we start numbering in case
>>> the
>>>>> //  user jumped to the next set of pages.
>>>>> //[
>>>>>  var: 'skip'=((Integer:(SkipRecords_Value)) + (Integer:(MaxRecords_Value)));
>>>>> var:'pages'=(Math_Ceil: ((decimal:(found_count)) / (decimal:
>>> (MaxRecords_Value))));
>>>>> If:$pages>=$maxpages; var:'pages'=$maxpages; /If;
>>> var:'page_calc'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value) *
>$maxpages)))) * $maxpages) + 1); If:(math_mod:$skip,
>((MaxRecords_Value) * $maxpages))==0;
>If:$skip==((MaxRecords_Value) * $maxpages); var:'page_no'=1;
>var:'skip2'=0; else; var:'page_no'=($page_calc - $maxpages);
>var:'skip2'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value)
>* $maxpages)))) * ((MaxRecords_Value) * $maxpages)) -
>((MaxRecords_Value) * $maxpages)); /If; Else;
>var:'page_no'=$page_calc; var:'skip2'=((Math_Floor:($skip /
>(decimal:((MaxRecords_Value) * $maxpages)))) *
>((MaxRecords_Value) * $maxpages)); /If; '
>>>>>  <p>\n';
>>>>>  //] // The first possible hyperlink will lead the user to the very first
>record
>>> from // anywhere in the found set. //[
>>>>>  If: (Shown_First)>=(MaxRecords_Value);
>>>>> '<A HREF="bryllup.lasso?-SkipRecords=0"><span
>>> class="text">F&oslash;rste</span></A>&nbsp;&nbsp;';
>>>>> else;
>>>>> '<span class="silver">F&oslash;rste</span>&nbsp;&nbsp;';
>>>>> /if;
>>>>>  //] // The second hyperlink, if applicable, is there to jump to the previous
>set
>>> of // results pages //[
>>>>>  If: $skip2>0;
>>>>> '<A HREF="bryllup.lasso?-SkipRecords=' + ((($page_no - 1) *
>(maxrecords_value))
>>> - (maxrecords_value)) + '"><span class="text">Bakover</span></a>&nbsp;&nbsp;';
>>>>> Else;
>>>>> '<span class="silver">Bakover</span>&nbsp;&nbsp;';
>>>>> /If;
>>>>>  //] // The third hyperlink, if applicable, simply brings the user to the
>>> previous // results page //[
>>>>>  If: ($skip>(MaxRecords_Value));
>>>>> '<A HREF="bryllup.lasso?-SkipRecords=' + ($skip - ((MaxRecords_Value) * 2)) +
>>> '"><span class="text">Forrige</span></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>>>>> Else;
>>>>> '<span class="silver">Forrige</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>>>>> /If;
>>>>>  //] // Finally getting to the all important hyperlinks to individual pages.
>//
>>> This part of the routine uses the maxpages variable to define the // maximum
>number of page links to be displayed, which means that the user
>// may have clicked to the next or previous set of pages (see
>second // hyperlink description above). If the maximum is set
>to 10 with a // Maxrecords value of 10 and a found set of 200
>records, the 'pages' and // &quot;page_no&quot; variables take
>care of the correct page numbering, e.g 11-20 // for the second
>'set'. //[
>>>>>  loop: $pages;
>>>>> If:(((skiprecords_value) / (maxrecords_value)) + 1)==$page_no;
>>>>> '<span class="text"><b><u>' + $page_no + '</u></b></span>';
>>>>> else;
>>>>> '<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span class="text">' +
>>> $page_no + '</span></a>';
>>>>> /If;
>>>>> '&nbsp;&nbsp;';
>>>>> var:'page_no'=($page_no + 1), 'skip2'=($skip2 + (MaxRecords_Value));
>>>>> If: $skip2 >= (found_count);
>>>>> Loop_Abort;
>>>>> /If;
>>>>> /loop;
>>>>>  //] // The equivalent of the third hyperlink, pointing to the next results
>page.
>>> //[
>>>>>  If: (found_count>$skip);
>>>>> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip +
>>> '"><span class="text">Neste</span></a>';
>>>>> Else;
>>>>> '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="silver">Neste</span>';
>>>>> /If;
>>>>>  //] // The equivalent of the second hyperlink, jumping to the next set of
>pages.
>>> //[
>>>>>  If: $skip2<(found_count);
>>>>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $skip2 + '"><span
>>> class="text">Forover</span></a>';
>>>>> Else;
>>>>> '&nbsp;&nbsp;<span class="silver">Forover</span>';
>>>>> /If;
>>>>>  //] // The last hyperlink requires some additional calculations, courtesy of
>//
>>> Michael Collins, to bring the user to the page displaying the very last //
>record. //[
>>>>>  If: ((Found_Count) % (MaxRecords_Value))==0;
>>>>> Var:'Skip'=((Found_Count) - (MaxRecords_Value));
>>>>> else;
>>>>> Var:'Skip'=((MaxRecords_Value) * (Math_Floor:(decimal:(Found_Count)) /
>>> (decimal:(MaxRecords_Value))));
>>>>> /If;
>>>>> If:(($Skip) <= (Found_Count))&&((Shown_Last)!=(Found_Count));
>>>>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords=' + $Skip + '"><span
>>> class="text">Siste</span></A>';
>>>>> else;
>>>>> '<span class="silver">&nbsp;&nbsp;Siste</span>';
>>>>> /if;
>>>>>   /inline;
>>>>> ?>
>>>>>  #############################################################
>>>>>  Attend the Lasso Developer Conference 2013!
>>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>>> http://www.lassosoft.com/LDC-niagara-falls-2013
>>>>>  #############################################################
>>>>> This message is sent to you because you are subscribed to
>>>>> the mailing list Lasso
>>>>> [hidden email]
>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>> Send administrative queries to  <[hidden email]>
>>>>   -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>>-- -- -- --
>>>> Steve Piercy               Web Site Builder               Soquel, CA
>>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>>    #############################################################
>>>>   Attend the Lasso Developer Conference 2013!
>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>> http://www.lassosoft.com/LDC-niagara-falls-2013
>>>>   #############################################################
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list Lasso
>>>> [hidden email]
>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>> Send administrative queries to  <[hidden email]>
>>>    #############################################################
>>>   Attend the Lasso Developer Conference 2013!
>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>> http://www.lassosoft.com/LDC-niagara-falls-2013
>>>   #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso
>>> [hidden email]
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>
>>-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>Steve Piercy               Web Site Builder               Soquel, CA
>><[hidden email]>                  <http://www.StevePiercy.com/>
>>
>>
>>#############################################################
>>
>>Attend the Lasso Developer Conference 2013!
>>Sept 12-14, 2013 in Niagara Falls, Canada
>>http://www.lassosoft.com/LDC-niagara-falls-2013
>>
>>#############################################################
>>This message is sent to you because you are subscribed to
>>the mailing list Lasso
>>[hidden email]
>>To unsubscribe, E-mail to: <[hidden email]>
>>Send administrative queries to  <[hidden email]>
>
>
>#############################################################
>
>Attend the Lasso Developer Conference 2013!
>Sept 12-14, 2013 in Niagara Falls, Canada
>http://www.lassosoft.com/LDC-niagara-falls-2013
>
>#############################################################
>This message is sent to you because you are subscribed to
>the mailing list Lasso
>[hidden email]
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
Steve Piercy               Web Site Builder              
Soquel, CA
<[hidden email]>                  <http://www.StevePiercy.com/>


#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Script stop working on 8.6.1

Johan Solve
One thing that bit me when migrating from FMS11 to FMS12 is that the date
format returned from FM to Lasso has changed into a format that is not
directly understood by Lasso. Dates are returned as mm-dd-yyyy from FMS12
instead of mm/dd/yyyy previously.
This change of behavior might be locale specific as our FM databases have
Swedish locale.

Looking quickly through your (Roy's) script I see no use of date fields so
this might be unrelated.


2013/8/12 Steve Piercy - Web Site Builder <[hidden email]>

> As Rachel corrected me, Lasso 8.6 works with FMS 12.
>
> Since you say you migrated about 6 weeks ago, I will assume that the
> LassoScript you originally pasted on July 1 stopped working when you
> migrated from FMS 11 to FMS 12.  Whether you have FMSA or FMS does not
> matter from Lasso's perspective.
>
> Therefore the most likely candidate is something in the migration from FMS
> 11 to 12.  There are about a half-dozen things that can go wrong, and
> various techniques to troubleshoot.
>
> In addition to my two previous suggestions, you can do the following:
>
> * Open the db in question via FMP and check that all relationships are
> valid and not broken.
> * Run through the FMS 9 Quick Start Guide (its version is still pretty
> valid and there is another one, too, but catered more toward Lasso 9).
> http://www.lassosoft.com/_**downloads/public/**Documentation_and_Guides/**
> Lasso_Professional_8.5/**FileMaker%20Server%209%**20Quick%20Start.pdf<http://www.lassosoft.com/_downloads/public/Documentation_and_Guides/Lasso_Professional_8.5/FileMaker%20Server%209%20Quick%20Start.pdf>
> * Review the documentation from FileMaker regarding database upgrades.
>  There are over a dozen detailed steps for that alone.
>
> Once you try those various things, report back the results, and we might
> be able to help narrow it down.  At this point there's not enough
> information to do much else.
>
> I don't recommend migrating to MySQL from FMS 12 if the only reason is
> that you don't know why your Lasso code no longer works after migration
> from FMS 11 to FMS 12.  It's most likely something very simple.  Moreover,
> migrations from FM to MySQL are rarely quick and easy things.  Nonetheless,
> if you don't need the nice GUI of FMP and you do need higher performance in
> a database, then MySQL would be a good option.
>
> --steve
>
>
> On 8/12/13 at 5:50 AM, [hidden email] (Roy William Gabrielsen)
> pronounced:
>
>
>  Steve
>>
>> I migrate several sites about 6 weeks ago, and they all works (with
>> MySQL) - except from this - and other FMP related - where this specific
>> gallery script not working properly. I have not FMSA 12 but FMS 12. Thats
>> the reason..? Much working, but not all.
>> Only solution is to upgrade FMSA 12 ? - or convert to MySQL.. I go for
>> the last one.
>> Roy
>>
>> 12. aug. 2013 kl. 02:25 skrev Steve Piercy - Web Site Builder
>> <[hidden email]>:
>>
>>  Unless I missed the memo, Lasso 8 does not provide support of FMSA 12
>>> through the
>>>
>> Lasso Connector for FileMaker SA.  I don't know whether Lasso 8 works
>> with FMSA 12 over the Lasso Connector for ODBC.
>>
>>>
>>> When did you migrate from FMSA 11 to 12?  If recently, then you may have
>>>
>> introduced a new problem unrelated to your code.
>>
>>>
>>> --steve
>>>
>>>
>>> On 8/12/13 at 2:05 AM, [hidden email] (Roy William Gabrielsen)
>>> pronounced:
>>>
>>>  Database is moved from FMSA 11 to FMS 12
>>>>   Is this changed from 8.5 to 8.6 - or from MFSA11 to FMS12?
>>>>   -KeyField='Internal record ID',
>>>>   Could not find it here..
>>>> http://mail2.roygabrielsen.**com/Reference.LassoApp?124<http://mail2.roygabrielsen.com/Reference.LassoApp?124>
>>>>   Some works, but not all
>>>>
>>>>  http://foto.fotografiens-hus.**no/landskonkurransen/2013/**
>> aapen.lasso?-SkipRecords=29<http://foto.fotografiens-hus.no/landskonkurransen/2013/aapen.lasso?-SkipRecords=29>
>>
>>>    1. juli 2013 kl. 23:56 skrev Steve Piercy - Web Site Builder
>>>>
>>> <[hidden email]>:
>>
>>>
>>>>  Comment out blocks of code until the error no longer appears.  Once
>>>>> isolated,
>>>>>
>>>> insert code to debug the error, e.g., error_currenterror,
>>>> action_statement.
>>>>
>>>>>   This is most likely a configuration issue on the new box.  Compare
>>>>> SiteAdmin
>>>>>
>>>> settings for connectors, hosts, databases, tables, users, and groups.
>>>>
>>>>>   --steve
>>>>>    On 7/1/13 at 6:16 PM, [hidden email] (Roy William
>>>>> Gabrielsen)
>>>>>
>>>> pronounced:
>>
>>>
>>>>>  Dear list
>>>>>>  This script worked on Mac OS X with Lasso 8.5.6
>>>>>> Stop working on CentOS with Lasso 8.6.1
>>>>>>  Where to look ?
>>>>>>  Thanx!
>>>>>>  Roy G
>>>>>>  <?LassoScript //
>>>>>> //  The only required variable is called "maxpages" and refers to the
>>>>>> //  maximum number of clickable page links displayed on the results
>>>>>> page.
>>>>>> //[
>>>>>>  var: 'maxpages'=12;
>>>>>> inline:
>>>>>> -Database='**Landskonkurransen2013', -Layout='poeng',
>>>>>> -KeyField='Internal record
>>>>>>
>>>>> ID',
>>>>
>>>>> 'Gruppe'='3',
>>>>>> 'p'='p', -ReturnField='navn', -ReturnField='gruppe',
>>>>>>
>>>>> -SkipRecords=(SkipRecords_**Value), -MaxRecords='1',
>>>> -SortField='poeng',
>>>>
>>> -SortOrder='Descending', -Search;
>>
>>>  //]   //  We start by analysing the given SkipRecords value to
>>>>>> establish how
>>>>>>
>>>>> many page
>>>>
>>>>> //  links should be displayed, and from which page we start numbering
>>>>>> in case
>>>>>>
>>>>> the
>>>>
>>>>> //  user jumped to the next set of pages.
>>>>>> //[
>>>>>>  var: 'skip'=((Integer:(SkipRecords_**Value)) +
>>>>>> (Integer:(MaxRecords_Value)));
>>>>>> var:'pages'=(Math_Ceil: ((decimal:(found_count)) / (decimal:
>>>>>>
>>>>> (MaxRecords_Value))));
>>>>
>>>>> If:$pages>=$maxpages; var:'pages'=$maxpages; /If;
>>>>>>
>>>>> var:'page_calc'=(((Math_Floor:**($skip / (decimal:((MaxRecords_Value)
>>>> *
>>>>
>>> $maxpages)))) * $maxpages) + 1); If:(math_mod:$skip, ((MaxRecords_Value)
>> * $maxpages))==0; If:$skip==((MaxRecords_Value) * $maxpages);
>> var:'page_no'=1; var:'skip2'=0; else; var:'page_no'=($page_calc -
>> $maxpages); var:'skip2'=(((Math_Floor:($**skip /
>> (decimal:((MaxRecords_Value) * $maxpages)))) * ((MaxRecords_Value) *
>> $maxpages)) - ((MaxRecords_Value) * $maxpages)); /If; Else;
>> var:'page_no'=$page_calc; var:'skip2'=((Math_Floor:($**skip /
>> (decimal:((MaxRecords_Value) * $maxpages)))) * ((MaxRecords_Value) *
>> $maxpages)); /If; '
>>
>>>  <p>\n';
>>>>>>  //] // The first possible hyperlink will lead the user to the very
>>>>>> first
>>>>>>
>>>>> record
>>
>>> from // anywhere in the found set. //[
>>>>
>>>>>  If: (Shown_First)>=(MaxRecords_**Value);
>>>>>> '<A HREF="bryllup.lasso?-**SkipRecords=0"><span
>>>>>>
>>>>> class="text">F&oslash;rste</**span></A>&nbsp;&nbsp;';
>>>>
>>>>> else;
>>>>>> '<span class="silver">F&oslash;rste</**span>&nbsp;&nbsp;';
>>>>>> /if;
>>>>>>  //] // The second hyperlink, if applicable, is there to jump to the
>>>>>> previous
>>>>>>
>>>>> set
>>
>>> of // results pages //[
>>>>
>>>>>  If: $skip2>0;
>>>>>> '<A HREF="bryllup.lasso?-**SkipRecords=' + ((($page_no - 1) *
>>>>>>
>>>>> (maxrecords_value))
>>
>>> - (maxrecords_value)) + '"><span class="text">Bakover</span></**
>>>> a>&nbsp;&nbsp;';
>>>>
>>>>> Else;
>>>>>> '<span class="silver">Bakover</span>&**nbsp;&nbsp;';
>>>>>> /If;
>>>>>>  //] // The third hyperlink, if applicable, simply brings the user to
>>>>>> the
>>>>>>
>>>>> previous // results page //[
>>>>
>>>>>  If: ($skip>(MaxRecords_Value));
>>>>>> '<A HREF="bryllup.lasso?-**SkipRecords=' + ($skip -
>>>>>> ((MaxRecords_Value) * 2)) +
>>>>>>
>>>>> '"><span class="text">Forrige</span></**a>&nbsp;&nbsp;&nbsp;&nbsp;&**
>>>> nbsp;';
>>>>
>>>>> Else;
>>>>>> '<span class="silver">Forrige</span>&**nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'
>>>>>> **;
>>>>>> /If;
>>>>>>  //] // Finally getting to the all important hyperlinks to individual
>>>>>> pages.
>>>>>>
>>>>> //
>>
>>> This part of the routine uses the maxpages variable to define the //
>>>> maximum
>>>>
>>> number of page links to be displayed, which means that the user // may
>> have clicked to the next or previous set of pages (see second // hyperlink
>> description above). If the maximum is set to 10 with a // Maxrecords value
>> of 10 and a found set of 200 records, the 'pages' and //
>> &quot;page_no&quot; variables take care of the correct page numbering, e.g
>> 11-20 // for the second 'set'. //[
>>
>>>  loop: $pages;
>>>>>> If:(((skiprecords_value) / (maxrecords_value)) + 1)==$page_no;
>>>>>> '<span class="text"><b><u>' + $page_no + '</u></b></span>';
>>>>>> else;
>>>>>> '<A HREF="bryllup.lasso?-**SkipRecords=' + $skip2 + '"><span
>>>>>> class="text">' +
>>>>>>
>>>>> $page_no + '</span></a>';
>>>>
>>>>> /If;
>>>>>> '&nbsp;&nbsp;';
>>>>>> var:'page_no'=($page_no + 1), 'skip2'=($skip2 + (MaxRecords_Value));
>>>>>> If: $skip2 >= (found_count);
>>>>>> Loop_Abort;
>>>>>> /If;
>>>>>> /loop;
>>>>>>  //] // The equivalent of the third hyperlink, pointing to the next
>>>>>> results
>>>>>>
>>>>> page.
>>
>>> //[
>>>>
>>>>>  If: (found_count>$skip);
>>>>>> '&nbsp;&nbsp;&nbsp;&nbsp;&**nbsp;<A HREF="bryllup.lasso?-**SkipRecords='
>>>>>> + $skip +
>>>>>>
>>>>> '"><span class="text">Neste</span></a>'**;
>>>>
>>>>> Else;
>>>>>> '&nbsp;&nbsp;&nbsp;&nbsp;&**nbsp;<span class="silver">Neste</span>';
>>>>>> /If;
>>>>>>  //] // The equivalent of the second hyperlink, jumping to the next
>>>>>> set of
>>>>>>
>>>>> pages.
>>
>>> //[
>>>>
>>>>>  If: $skip2<(found_count);
>>>>>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-**SkipRecords=' + $skip2 +
>>>>>> '"><span
>>>>>>
>>>>> class="text">Forover</span></**a>';
>>>>
>>>>> Else;
>>>>>> '&nbsp;&nbsp;<span class="silver">Forover</span>'**;
>>>>>> /If;
>>>>>>  //] // The last hyperlink requires some additional calculations,
>>>>>> courtesy of
>>>>>>
>>>>> //
>>
>>> Michael Collins, to bring the user to the page displaying the very last
>>>> //
>>>>
>>> record. //[
>>
>>>  If: ((Found_Count) % (MaxRecords_Value))==0;
>>>>>> Var:'Skip'=((Found_Count) - (MaxRecords_Value));
>>>>>> else;
>>>>>> Var:'Skip'=((MaxRecords_Value) * (Math_Floor:(decimal:(Found_**Count))
>>>>>> /
>>>>>>
>>>>> (decimal:(MaxRecords_Value))))**;
>>>>
>>>>> /If;
>>>>>> If:(($Skip) <= (Found_Count))&&((Shown_Last)!**=(Found_Count));
>>>>>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-**SkipRecords=' + $Skip +
>>>>>> '"><span
>>>>>>
>>>>> class="text">Siste</span></A>'**;
>>>>
>>>>> else;
>>>>>> '<span class="silver">&nbsp;&nbsp;**Siste</span>';
>>>>>> /if;
>>>>>>   /inline;
>>>>>> ?>
>>>>>>  ##############################**##############################**#
>>>>>>  Attend the Lasso Developer Conference 2013!
>>>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>>>> http://www.lassosoft.com/LDC-**niagara-falls-2013<http://www.lassosoft.com/LDC-niagara-falls-2013>
>>>>>>  ##############################**##############################**#
>>>>>> This message is sent to you because you are subscribed to
>>>>>> the mailing list Lasso
>>>>>> [hidden email]
>>>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>>>> >
>>>>>> Send administrative queries to  <Lasso-request@lists.**lassosoft.com<[hidden email]>
>>>>>> >
>>>>>>
>>>>>   -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>>> Steve Piercy               Web Site Builder               Soquel, CA
>>>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>>>    ##############################**##############################**#
>>>>>   Attend the Lasso Developer Conference 2013!
>>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>>> http://www.lassosoft.com/LDC-**niagara-falls-2013<http://www.lassosoft.com/LDC-niagara-falls-2013>
>>>>>   ##############################**##############################**#
>>>>> This message is sent to you because you are subscribed to
>>>>> the mailing list Lasso
>>>>> [hidden email]
>>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>>> >
>>>>> Send administrative queries to  <Lasso-request@lists.**lassosoft.com<[hidden email]>
>>>>> >
>>>>>
>>>>    ##############################**##############################**#
>>>>   Attend the Lasso Developer Conference 2013!
>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>> http://www.lassosoft.com/LDC-**niagara-falls-2013<http://www.lassosoft.com/LDC-niagara-falls-2013>
>>>>   ##############################**##############################**#
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list Lasso
>>>> [hidden email]
>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>> >
>>>> Send administrative queries to  <Lasso-request@lists.**lassosoft.com<[hidden email]>
>>>> >
>>>>
>>>
>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>> Steve Piercy               Web Site Builder               Soquel, CA
>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>
>>>
>>> ##############################**##############################**#
>>>
>>> Attend the Lasso Developer Conference 2013!
>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>> http://www.lassosoft.com/LDC-**niagara-falls-2013<http://www.lassosoft.com/LDC-niagara-falls-2013>
>>>
>>> ##############################**##############################**#
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso
>>> [hidden email]
>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>> >
>>> Send administrative queries to  <Lasso-request@lists.**lassosoft.com<[hidden email]>
>>> >
>>>
>>
>>
>> ##############################**##############################**#
>>
>> Attend the Lasso Developer Conference 2013!
>> Sept 12-14, 2013 in Niagara Falls, Canada
>> http://www.lassosoft.com/LDC-**niagara-falls-2013<http://www.lassosoft.com/LDC-niagara-falls-2013>
>>
>> ##############################**##############################**#
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso
>> [hidden email]
>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>> >
>> Send administrative queries to  <Lasso-request@lists.**lassosoft.com<[hidden email]>
>> >
>>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy               Web Site Builder               Soquel, CA
> <[hidden email]>                  <http://www.StevePiercy.com/>
>
>
> ##############################**##############################**#
>
> Attend the Lasso Developer Conference 2013!
> Sept 12-14, 2013 in Niagara Falls, Canada
> http://www.lassosoft.com/LDC-**niagara-falls-2013<http://www.lassosoft.com/LDC-niagara-falls-2013>
>
> ##############################**##############################**#
> This message is sent to you because you are subscribed to
>  the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
> >
> Send administrative queries to  <Lasso-request@lists.**lassosoft.com<[hidden email]>
> >
>



--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad   Stockholm
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
[hidden email]

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 |  Fax +46 35-136801

#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Script stop working on 8.6.1

Johan Solve
Another thing I just tracked down is that looping an empty FMS12 portal
with [portal]...[/portal] container tag seems to crash Lasso. Adding a
condition to make sure at least the first related record has a value before
looping the portal prevents crashing.

8.6.0.x on CentOS5.


2013/8/12 Johan Solve <[hidden email]>

> One thing that bit me when migrating from FMS11 to FMS12 is that the date
> format returned from FM to Lasso has changed into a format that is not
> directly understood by Lasso. Dates are returned as mm-dd-yyyy from FMS12
> instead of mm/dd/yyyy previously.
> This change of behavior might be locale specific as our FM databases have
> Swedish locale.
>
> Looking quickly through your (Roy's) script I see no use of date fields so
> this might be unrelated.
>
>
> 2013/8/12 Steve Piercy - Web Site Builder <[hidden email]>
>
>> As Rachel corrected me, Lasso 8.6 works with FMS 12.
>>
>> Since you say you migrated about 6 weeks ago, I will assume that the
>> LassoScript you originally pasted on July 1 stopped working when you
>> migrated from FMS 11 to FMS 12.  Whether you have FMSA or FMS does not
>> matter from Lasso's perspective.
>>
>> Therefore the most likely candidate is something in the migration from
>> FMS 11 to 12.  There are about a half-dozen things that can go wrong, and
>> various techniques to troubleshoot.
>>
>> In addition to my two previous suggestions, you can do the following:
>>
>> * Open the db in question via FMP and check that all relationships are
>> valid and not broken.
>> * Run through the FMS 9 Quick Start Guide (its version is still pretty
>> valid and there is another one, too, but catered more toward Lasso 9).
>> http://www.lassosoft.com/_**downloads/public/**Documentation_and_Guides/*
>> *Lasso_Professional_8.5/**FileMaker%20Server%209%**20Quick%20Start.pdf<http://www.lassosoft.com/_downloads/public/Documentation_and_Guides/Lasso_Professional_8.5/FileMaker%20Server%209%20Quick%20Start.pdf>
>> * Review the documentation from FileMaker regarding database upgrades.
>>  There are over a dozen detailed steps for that alone.
>>
>> Once you try those various things, report back the results, and we might
>> be able to help narrow it down.  At this point there's not enough
>> information to do much else.
>>
>> I don't recommend migrating to MySQL from FMS 12 if the only reason is
>> that you don't know why your Lasso code no longer works after migration
>> from FMS 11 to FMS 12.  It's most likely something very simple.  Moreover,
>> migrations from FM to MySQL are rarely quick and easy things.  Nonetheless,
>> if you don't need the nice GUI of FMP and you do need higher performance in
>> a database, then MySQL would be a good option.
>>
>> --steve
>>
>>
>> On 8/12/13 at 5:50 AM, [hidden email] (Roy William Gabrielsen)
>> pronounced:
>>
>>
>>  Steve
>>>
>>> I migrate several sites about 6 weeks ago, and they all works (with
>>> MySQL) - except from this - and other FMP related - where this specific
>>> gallery script not working properly. I have not FMSA 12 but FMS 12. Thats
>>> the reason..? Much working, but not all.
>>> Only solution is to upgrade FMSA 12 ? - or convert to MySQL.. I go for
>>> the last one.
>>> Roy
>>>
>>> 12. aug. 2013 kl. 02:25 skrev Steve Piercy - Web Site Builder
>>> <[hidden email]>:
>>>
>>>  Unless I missed the memo, Lasso 8 does not provide support of FMSA 12
>>>> through the
>>>>
>>> Lasso Connector for FileMaker SA.  I don't know whether Lasso 8 works
>>> with FMSA 12 over the Lasso Connector for ODBC.
>>>
>>>>
>>>> When did you migrate from FMSA 11 to 12?  If recently, then you may have
>>>>
>>> introduced a new problem unrelated to your code.
>>>
>>>>
>>>> --steve
>>>>
>>>>
>>>> On 8/12/13 at 2:05 AM, [hidden email] (Roy William Gabrielsen)
>>>> pronounced:
>>>>
>>>>  Database is moved from FMSA 11 to FMS 12
>>>>>   Is this changed from 8.5 to 8.6 - or from MFSA11 to FMS12?
>>>>>   -KeyField='Internal record ID',
>>>>>   Could not find it here..
>>>>> http://mail2.roygabrielsen.**com/Reference.LassoApp?124<http://mail2.roygabrielsen.com/Reference.LassoApp?124>
>>>>>   Some works, but not all
>>>>>
>>>>>  http://foto.fotografiens-hus.**no/landskonkurransen/2013/**
>>> aapen.lasso?-SkipRecords=29<http://foto.fotografiens-hus.no/landskonkurransen/2013/aapen.lasso?-SkipRecords=29>
>>>
>>>>    1. juli 2013 kl. 23:56 skrev Steve Piercy - Web Site Builder
>>>>>
>>>> <[hidden email]>:
>>>
>>>>
>>>>>  Comment out blocks of code until the error no longer appears.  Once
>>>>>> isolated,
>>>>>>
>>>>> insert code to debug the error, e.g., error_currenterror,
>>>>> action_statement.
>>>>>
>>>>>>   This is most likely a configuration issue on the new box.  Compare
>>>>>> SiteAdmin
>>>>>>
>>>>> settings for connectors, hosts, databases, tables, users, and groups.
>>>>>
>>>>>>   --steve
>>>>>>    On 7/1/13 at 6:16 PM, [hidden email] (Roy William
>>>>>> Gabrielsen)
>>>>>>
>>>>> pronounced:
>>>
>>>>
>>>>>>  Dear list
>>>>>>>  This script worked on Mac OS X with Lasso 8.5.6
>>>>>>> Stop working on CentOS with Lasso 8.6.1
>>>>>>>  Where to look ?
>>>>>>>  Thanx!
>>>>>>>  Roy G
>>>>>>>  <?LassoScript //
>>>>>>> //  The only required variable is called "maxpages" and refers to the
>>>>>>> //  maximum number of clickable page links displayed on the results
>>>>>>> page.
>>>>>>> //[
>>>>>>>  var: 'maxpages'=12;
>>>>>>> inline:
>>>>>>> -Database='**Landskonkurransen2013', -Layout='poeng',
>>>>>>> -KeyField='Internal record
>>>>>>>
>>>>>> ID',
>>>>>
>>>>>> 'Gruppe'='3',
>>>>>>> 'p'='p', -ReturnField='navn', -ReturnField='gruppe',
>>>>>>>
>>>>>> -SkipRecords=(SkipRecords_**Value), -MaxRecords='1',
>>>>> -SortField='poeng',
>>>>>
>>>> -SortOrder='Descending', -Search;
>>>
>>>>   //]   //  We start by analysing the given SkipRecords value to
>>>>>>> establish how
>>>>>>>
>>>>>> many page
>>>>>
>>>>>> //  links should be displayed, and from which page we start numbering
>>>>>>> in case
>>>>>>>
>>>>>> the
>>>>>
>>>>>> //  user jumped to the next set of pages.
>>>>>>> //[
>>>>>>>  var: 'skip'=((Integer:(SkipRecords_**Value)) +
>>>>>>> (Integer:(MaxRecords_Value)));
>>>>>>> var:'pages'=(Math_Ceil: ((decimal:(found_count)) / (decimal:
>>>>>>>
>>>>>> (MaxRecords_Value))));
>>>>>
>>>>>> If:$pages>=$maxpages; var:'pages'=$maxpages; /If;
>>>>>>>
>>>>>> var:'page_calc'=(((Math_Floor:**($skip /
>>>>> (decimal:((MaxRecords_Value) *
>>>>>
>>>> $maxpages)))) * $maxpages) + 1); If:(math_mod:$skip,
>>> ((MaxRecords_Value) * $maxpages))==0; If:$skip==((MaxRecords_Value) *
>>> $maxpages); var:'page_no'=1; var:'skip2'=0; else; var:'page_no'=($page_calc
>>> - $maxpages); var:'skip2'=(((Math_Floor:($**skip /
>>> (decimal:((MaxRecords_Value) * $maxpages)))) * ((MaxRecords_Value) *
>>> $maxpages)) - ((MaxRecords_Value) * $maxpages)); /If; Else;
>>> var:'page_no'=$page_calc; var:'skip2'=((Math_Floor:($**skip /
>>> (decimal:((MaxRecords_Value) * $maxpages)))) * ((MaxRecords_Value) *
>>> $maxpages)); /If; '
>>>
>>>>   <p>\n';
>>>>>>>  //] // The first possible hyperlink will lead the user to the very
>>>>>>> first
>>>>>>>
>>>>>> record
>>>
>>>> from // anywhere in the found set. //[
>>>>>
>>>>>>  If: (Shown_First)>=(MaxRecords_**Value);
>>>>>>> '<A HREF="bryllup.lasso?-**SkipRecords=0"><span
>>>>>>>
>>>>>> class="text">F&oslash;rste</**span></A>&nbsp;&nbsp;';
>>>>>
>>>>>> else;
>>>>>>> '<span class="silver">F&oslash;rste</**span>&nbsp;&nbsp;';
>>>>>>> /if;
>>>>>>>  //] // The second hyperlink, if applicable, is there to jump to the
>>>>>>> previous
>>>>>>>
>>>>>> set
>>>
>>>> of // results pages //[
>>>>>
>>>>>>  If: $skip2>0;
>>>>>>> '<A HREF="bryllup.lasso?-**SkipRecords=' + ((($page_no - 1) *
>>>>>>>
>>>>>> (maxrecords_value))
>>>
>>>> - (maxrecords_value)) + '"><span class="text">Bakover</span></**
>>>>> a>&nbsp;&nbsp;';
>>>>>
>>>>>> Else;
>>>>>>> '<span class="silver">Bakover</span>&**nbsp;&nbsp;';
>>>>>>> /If;
>>>>>>>  //] // The third hyperlink, if applicable, simply brings the user
>>>>>>> to the
>>>>>>>
>>>>>> previous // results page //[
>>>>>
>>>>>>  If: ($skip>(MaxRecords_Value));
>>>>>>> '<A HREF="bryllup.lasso?-**SkipRecords=' + ($skip -
>>>>>>> ((MaxRecords_Value) * 2)) +
>>>>>>>
>>>>>> '"><span class="text">Forrige</span></**a>&nbsp;&nbsp;&nbsp;&nbsp;&**
>>>>> nbsp;';
>>>>>
>>>>>> Else;
>>>>>>> '<span class="silver">Forrige</span>&**
>>>>>>> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'**;
>>>>>>> /If;
>>>>>>>  //] // Finally getting to the all important hyperlinks to
>>>>>>> individual pages.
>>>>>>>
>>>>>> //
>>>
>>>> This part of the routine uses the maxpages variable to define the //
>>>>> maximum
>>>>>
>>>> number of page links to be displayed, which means that the user // may
>>> have clicked to the next or previous set of pages (see second // hyperlink
>>> description above). If the maximum is set to 10 with a // Maxrecords value
>>> of 10 and a found set of 200 records, the 'pages' and //
>>> &quot;page_no&quot; variables take care of the correct page numbering, e.g
>>> 11-20 // for the second 'set'. //[
>>>
>>>>   loop: $pages;
>>>>>>> If:(((skiprecords_value) / (maxrecords_value)) + 1)==$page_no;
>>>>>>> '<span class="text"><b><u>' + $page_no + '</u></b></span>';
>>>>>>> else;
>>>>>>> '<A HREF="bryllup.lasso?-**SkipRecords=' + $skip2 + '"><span
>>>>>>> class="text">' +
>>>>>>>
>>>>>> $page_no + '</span></a>';
>>>>>
>>>>>> /If;
>>>>>>> '&nbsp;&nbsp;';
>>>>>>> var:'page_no'=($page_no + 1), 'skip2'=($skip2 + (MaxRecords_Value));
>>>>>>> If: $skip2 >= (found_count);
>>>>>>> Loop_Abort;
>>>>>>> /If;
>>>>>>> /loop;
>>>>>>>  //] // The equivalent of the third hyperlink, pointing to the next
>>>>>>> results
>>>>>>>
>>>>>> page.
>>>
>>>> //[
>>>>>
>>>>>>  If: (found_count>$skip);
>>>>>>> '&nbsp;&nbsp;&nbsp;&nbsp;&**nbsp;<A HREF="bryllup.lasso?-**SkipRecords='
>>>>>>> + $skip +
>>>>>>>
>>>>>> '"><span class="text">Neste</span></a>'**;
>>>>>
>>>>>> Else;
>>>>>>> '&nbsp;&nbsp;&nbsp;&nbsp;&**nbsp;<span class="silver">Neste</span>';
>>>>>>> /If;
>>>>>>>  //] // The equivalent of the second hyperlink, jumping to the next
>>>>>>> set of
>>>>>>>
>>>>>> pages.
>>>
>>>> //[
>>>>>
>>>>>>  If: $skip2<(found_count);
>>>>>>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-**SkipRecords=' + $skip2 +
>>>>>>> '"><span
>>>>>>>
>>>>>> class="text">Forover</span></**a>';
>>>>>
>>>>>> Else;
>>>>>>> '&nbsp;&nbsp;<span class="silver">Forover</span>'**;
>>>>>>> /If;
>>>>>>>  //] // The last hyperlink requires some additional calculations,
>>>>>>> courtesy of
>>>>>>>
>>>>>> //
>>>
>>>> Michael Collins, to bring the user to the page displaying the very last
>>>>> //
>>>>>
>>>> record. //[
>>>
>>>>   If: ((Found_Count) % (MaxRecords_Value))==0;
>>>>>>> Var:'Skip'=((Found_Count) - (MaxRecords_Value));
>>>>>>> else;
>>>>>>> Var:'Skip'=((MaxRecords_Value) * (Math_Floor:(decimal:(Found_**Count))
>>>>>>> /
>>>>>>>
>>>>>> (decimal:(MaxRecords_Value))))**;
>>>>>
>>>>>> /If;
>>>>>>> If:(($Skip) <= (Found_Count))&&((Shown_Last)!**=(Found_Count));
>>>>>>> '&nbsp;&nbsp;<A HREF="bryllup.lasso?-**SkipRecords=' + $Skip +
>>>>>>> '"><span
>>>>>>>
>>>>>> class="text">Siste</span></A>'**;
>>>>>
>>>>>> else;
>>>>>>> '<span class="silver">&nbsp;&nbsp;**Siste</span>';
>>>>>>> /if;
>>>>>>>   /inline;
>>>>>>> ?>
>>>>>>>  ##############################**##############################**#
>>>>>>>  Attend the Lasso Developer Conference 2013!
>>>>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>>>>> http://www.lassosoft.com/LDC-**niagara-falls-2013<http://www.lassosoft.com/LDC-niagara-falls-2013>
>>>>>>>  ##############################**##############################**#
>>>>>>> This message is sent to you because you are subscribed to
>>>>>>> the mailing list Lasso
>>>>>>> [hidden email]
>>>>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>>>>> >
>>>>>>> Send administrative queries to  <Lasso-request@lists.**lassosoft.com<[hidden email]>
>>>>>>> >
>>>>>>>
>>>>>>   -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>>>> Steve Piercy               Web Site Builder               Soquel, CA
>>>>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>>>>    ##############################**##############################**#
>>>>>>   Attend the Lasso Developer Conference 2013!
>>>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>>>> http://www.lassosoft.com/LDC-**niagara-falls-2013<http://www.lassosoft.com/LDC-niagara-falls-2013>
>>>>>>   ##############################**##############################**#
>>>>>> This message is sent to you because you are subscribed to
>>>>>> the mailing list Lasso
>>>>>> [hidden email]
>>>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>>>> >
>>>>>> Send administrative queries to  <Lasso-request@lists.**lassosoft.com<[hidden email]>
>>>>>> >
>>>>>>
>>>>>    ##############################**##############################**#
>>>>>   Attend the Lasso Developer Conference 2013!
>>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>>> http://www.lassosoft.com/LDC-**niagara-falls-2013<http://www.lassosoft.com/LDC-niagara-falls-2013>
>>>>>   ##############################**##############################**#
>>>>> This message is sent to you because you are subscribed to
>>>>> the mailing list Lasso
>>>>> [hidden email]
>>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>>> >
>>>>> Send administrative queries to  <Lasso-request@lists.**lassosoft.com<[hidden email]>
>>>>> >
>>>>>
>>>>
>>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>> Steve Piercy               Web Site Builder               Soquel, CA
>>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>>
>>>>
>>>> ##############################**##############################**#
>>>>
>>>> Attend the Lasso Developer Conference 2013!
>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>> http://www.lassosoft.com/LDC-**niagara-falls-2013<http://www.lassosoft.com/LDC-niagara-falls-2013>
>>>>
>>>> ##############################**##############################**#
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list Lasso
>>>> [hidden email]
>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>> >
>>>> Send administrative queries to  <Lasso-request@lists.**lassosoft.com<[hidden email]>
>>>> >
>>>>
>>>
>>>
>>> ##############################**##############################**#
>>>
>>> Attend the Lasso Developer Conference 2013!
>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>> http://www.lassosoft.com/LDC-**niagara-falls-2013<http://www.lassosoft.com/LDC-niagara-falls-2013>
>>>
>>> ##############################**##############################**#
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso
>>> [hidden email]
>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>> >
>>> Send administrative queries to  <Lasso-request@lists.**lassosoft.com<[hidden email]>
>>> >
>>>
>>
>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>> Steve Piercy               Web Site Builder               Soquel, CA
>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>
>>
>> ##############################**##############################**#
>>
>> Attend the Lasso Developer Conference 2013!
>> Sept 12-14, 2013 in Niagara Falls, Canada
>> http://www.lassosoft.com/LDC-**niagara-falls-2013<http://www.lassosoft.com/LDC-niagara-falls-2013>
>>
>> ##############################**##############################**#
>> This message is sent to you because you are subscribed to
>>  the mailing list Lasso
>> [hidden email]
>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>> >
>> Send administrative queries to  <Lasso-request@lists.**lassosoft.com<[hidden email]>
>> >
>>
>
>
>
> --
> Mvh
> Johan Sölve
> ____________________________________
> Montania System AB
> Halmstad   Stockholm
> http://www.montania.se
>
> Johan Sölve
> Mobil +46 709-51 55 70
> [hidden email]
>
> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
> Telefon +46 35-136800 |  Fax +46 35-136801
>



--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad   Stockholm
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
[hidden email]

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 |  Fax +46 35-136801

#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Script stop working on 8.6.1

Jonathan Guthrie-3
Hi Johan,

Can you send a report of this to [hidden email] with code used to reproduce (and mitigate) and it'll get in the system.
Thanks
Jono

On 2013-08-12, at 8:55 AM, Johan Solve <[hidden email]> wrote:

> Another thing I just tracked down is that looping an empty FMS12 portal
> with [portal]...[/portal] container tag seems to crash Lasso. Adding a
> condition to make sure at least the first related record has a value before
> looping the portal prevents crashing.
>
> 8.6.0.x on CentOS5.
>
>
>

Jono

----------------------------
Jonathan Guthrie
[hidden email]
@iamjono
LassoSoft Inc.
AIM Chatroom: lassochat
IRC/freenode #lasso


#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Script stop working on 8.6.1

Johan Solve
Done. 8.5.6 on Mac is also affected. Copy below:

FM database has a portal with no related records, i.e. an empty portal.

inline(-database='dbname',
-table='layoutname',
-op='eq', 'id'=42,
-search);
// one record found
records;
portal('relationname');
/portal;
/records;
/inline;

Lasso crashes.



Mitigate the crash with a condition:
inline(-database='dbname',
-table='layoutname',
-op='eq', 'id'=42,
-search);
records;
if(field(relationname::related_id'));
portal('relationname');
/portal;
/if;
/records;
/inline;

Lasso happy.



2013/8/12 Jonathan Guthrie <[hidden email]>

> Hi Johan,
>
> Can you send a report of this to [hidden email] with code used to
> reproduce (and mitigate) and it'll get in the system.
> Thanks
> Jono
>
> On 2013-08-12, at 8:55 AM, Johan Solve <[hidden email]> wrote:
>
> > Another thing I just tracked down is that looping an empty FMS12 portal
> > with [portal]...[/portal] container tag seems to crash Lasso. Adding a
> > condition to make sure at least the first related record has a value
> before
> > looping the portal prevents crashing.
> >
> > 8.6.0.x on CentOS5.
> >
> >
> >
>
> Jono
>
> ----------------------------
> Jonathan Guthrie
> [hidden email]
> @iamjono
> LassoSoft Inc.
> AIM Chatroom: lassochat
> IRC/freenode #lasso
>
>
> #############################################################
>
> Attend the Lasso Developer Conference 2013!
> Sept 12-14, 2013 in Niagara Falls, Canada
> http://www.lassosoft.com/LDC-niagara-falls-2013
>
> #############################################################
> This message is sent to you because you are subscribed to
>   the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>



--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad   Stockholm
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
[hidden email]

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 |  Fax +46 35-136801

#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Script stop working on 8.6.1

Johan Solve
In reply to this post by Roy William Gabrielsen
By the way, -returnfield has no effect with FileMaker. All fields on the
layout are always returned.


2013/7/1 Roy William Gabrielsen <[hidden email]>

> Dear list
>
> This script worked on Mac OS X with Lasso 8.5.6
> Stop working on CentOS with Lasso 8.6.1
>
> Where to look ?
>
> Thanx!
>
> Roy G
>
> <?LassoScript
> //
> //  The only required variable is called "maxpages" and refers to the
> //  maximum number of clickable page links displayed on the results page.
> //[
>
>         var: 'maxpages'=12;
>         inline:
>                  -Database='Landskonkurransen2013',
>                  -Layout='poeng',
>                  -KeyField='Internal record ID',
>                  'Gruppe'='3',
>                  'p'='p',
>                  -ReturnField='navn',
>                  -ReturnField='gruppe',
>                  -SkipRecords=(SkipRecords_Value),
>                  -MaxRecords='1',
>                  -SortField='poeng',
>                  -SortOrder='Descending',
>                  -Search;
>
> //]
> //  We start by analysing the given SkipRecords value to establish how
> many page
> //  links should be displayed, and from which page we start numbering in
> case the
> //  user jumped to the next set of pages.
> //[
>
>                 var: 'skip'=((Integer:(SkipRecords_Value)) +
> (Integer:(MaxRecords_Value)));
>                 var:'pages'=(Math_Ceil: ((decimal:(found_count)) /
> (decimal: (MaxRecords_Value))));
>                 If:$pages>=$maxpages; var:'pages'=$maxpages; /If;
> var:'page_calc'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value) *
> $maxpages)))) * $maxpages) + 1); If:(math_mod:$skip, ((MaxRecords_Value) *
> $maxpages))==0; If:$skip==((MaxRecords_Value) * $maxpages);
> var:'page_no'=1; var:'skip2'=0; else; var:'page_no'=($page_calc -
> $maxpages); var:'skip2'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value)
> * $maxpages)))) * ((MaxRecords_Value) * $maxpages)) - ((MaxRecords_Value) *
> $maxpages)); /If; Else; var:'page_no'=$page_calc;
> var:'skip2'=((Math_Floor:($skip / (decimal:((MaxRecords_Value) *
> $maxpages)))) * ((MaxRecords_Value) * $maxpages)); /If; '
>
>
>                                               <p>\n';
>
>
> //]
> // The first possible hyperlink will lead the user to the very first
> record from
> // anywhere in the found set.
> //[
>
>                 If: (Shown_First)>=(MaxRecords_Value);
>                         '<A HREF="bryllup.lasso?-SkipRecords=0"><span
> class="text">F&oslash;rste</span></A>&nbsp;&nbsp;';
>                 else;
>                         '<span
> class="silver">F&oslash;rste</span>&nbsp;&nbsp;';
>                 /if;
>
> //]
> // The second hyperlink, if applicable, is there to jump to the previous
> set of
> // results pages
> //[
>
>                 If: $skip2>0;
>                         '<A HREF="bryllup.lasso?-SkipRecords=' +
> ((($page_no - 1) * (maxrecords_value)) - (maxrecords_value)) + '"><span
> class="text">Bakover</span></a>&nbsp;&nbsp;';
>                 Else;
>                         '<span class="silver">Bakover</span>&nbsp;&nbsp;';
>                 /If;
>
> //]
> // The third hyperlink, if applicable, simply brings the user to the
> previous
> // results page
> //[
>
>                 If: ($skip>(MaxRecords_Value));
>                         '<A HREF="bryllup.lasso?-SkipRecords=' + ($skip -
> ((MaxRecords_Value) * 2)) + '"><span
> class="text">Forrige</span></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>                 Else;
>                         '<span
> class="silver">Forrige</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>                 /If;
>
> //]
> // Finally getting to the all important hyperlinks to individual pages.
> // This part of the routine uses the maxpages variable to define the
> // maximum number of page links to be displayed, which means that the user
> // may have clicked to the next or previous set of pages (see second
> // hyperlink description above). If the maximum is set to 10 with a
> // Maxrecords value of 10 and a found set of 200 records, the 'pages' and
> // &quot;page_no&quot; variables take care of the correct page numbering,
> e.g 11-20
> // for the second 'set'.
> //[
>
>                 loop: $pages;
>                         If:(((skiprecords_value) / (maxrecords_value)) +
> 1)==$page_no;
>                                 '<span class="text"><b><u>' + $page_no +
> '</u></b></span>';
>                         else;
>                                 '<A HREF="bryllup.lasso?-SkipRecords=' +
> $skip2 + '"><span class="text">' + $page_no + '</span></a>';
>                         /If;
>                         '&nbsp;&nbsp;';
>                         var:'page_no'=($page_no + 1),
>                                 'skip2'=($skip2 + (MaxRecords_Value));
>                         If: $skip2 >= (found_count);
>                                 Loop_Abort;
>                         /If;
>                 /loop;
>
> //]
> // The equivalent of the third hyperlink, pointing to the next results
> page.
> //[
>
>                 If: (found_count>$skip);
>                         '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A
> HREF="bryllup.lasso?-SkipRecords=' + $skip + '"><span
> class="text">Neste</span></a>';
>                 Else;
>                         '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span
> class="silver">Neste</span>';
>                 /If;
>
> //]
> // The equivalent of the second hyperlink, jumping to the next set of
> pages.
> //[
>
>                 If: $skip2<(found_count);
>                         '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords='
> + $skip2 + '"><span class="text">Forover</span></a>';
>                 Else;
>                         '&nbsp;&nbsp;<span class="silver">Forover</span>';
>                 /If;
>
> //]
> // The last hyperlink requires some additional calculations, courtesy of
> // Michael Collins, to bring the user to the page displaying the very last
> // record.
> //[
>
>                 If: ((Found_Count) % (MaxRecords_Value))==0;
>                         Var:'Skip'=((Found_Count) - (MaxRecords_Value));
>                 else;
>                         Var:'Skip'=((MaxRecords_Value) *
> (Math_Floor:(decimal:(Found_Count)) / (decimal:(MaxRecords_Value))));
>                 /If;
>                 If:(($Skip) <=
> (Found_Count))&&((Shown_Last)!=(Found_Count));
>                         '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords='
> + $Skip + '"><span class="text">Siste</span></A>';
>                 else;
>                         '<span class="silver">&nbsp;&nbsp;Siste</span>';
>                 /if;
>
>
>         /inline;
> ?>
>
> #############################################################
>
> Attend the Lasso Developer Conference 2013!
> Sept 12-14, 2013 in Niagara Falls, Canada
> http://www.lassosoft.com/LDC-niagara-falls-2013
>
> #############################################################
> This message is sent to you because you are subscribed to
>   the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>



--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad   Stockholm
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
[hidden email]

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 |  Fax +46 35-136801

#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Script stop working on 8.6.1

Roy William Gabrielsen
Thanx for all input.
I now have a lot to work with..
Will keep you updated.

Johan:
In this solutions, there is no empty portals. Anyway, thank you.

-ReturnField > I may remove fields not in use, to get less server traffic - or make a new Layout with less information.

Web server is a CentOS/Lasso8.6, - FMP server is a Windows Server 2008 SP2.
Rented at Hetzner. High speed servers on high speed network.

Roy

12. aug. 2013 kl. 15:45 skrev Johan Solve <[hidden email]>:

> By the way, -returnfield has no effect with FileMaker. All fields on the
> layout are always returned.
>
>
> 2013/7/1 Roy William Gabrielsen <[hidden email]>
>
>> Dear list
>>
>> This script worked on Mac OS X with Lasso 8.5.6
>> Stop working on CentOS with Lasso 8.6.1
>>
>> Where to look ?
>>
>> Thanx!
>>
>> Roy G
>>
>> <?LassoScript
>> //
>> //  The only required variable is called "maxpages" and refers to the
>> //  maximum number of clickable page links displayed on the results page.
>> //[
>>
>>        var: 'maxpages'=12;
>>        inline:
>>                 -Database='Landskonkurransen2013',
>>                 -Layout='poeng',
>>                 -KeyField='Internal record ID',
>>                 'Gruppe'='3',
>>                 'p'='p',
>>                 -ReturnField='navn',
>>                 -ReturnField='gruppe',
>>                 -SkipRecords=(SkipRecords_Value),
>>                 -MaxRecords='1',
>>                 -SortField='poeng',
>>                 -SortOrder='Descending',
>>                 -Search;
>>
>> //]
>> //  We start by analysing the given SkipRecords value to establish how
>> many page
>> //  links should be displayed, and from which page we start numbering in
>> case the
>> //  user jumped to the next set of pages.
>> //[
>>
>>                var: 'skip'=((Integer:(SkipRecords_Value)) +
>> (Integer:(MaxRecords_Value)));
>>                var:'pages'=(Math_Ceil: ((decimal:(found_count)) /
>> (decimal: (MaxRecords_Value))));
>>                If:$pages>=$maxpages; var:'pages'=$maxpages; /If;
>> var:'page_calc'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value) *
>> $maxpages)))) * $maxpages) + 1); If:(math_mod:$skip, ((MaxRecords_Value) *
>> $maxpages))==0; If:$skip==((MaxRecords_Value) * $maxpages);
>> var:'page_no'=1; var:'skip2'=0; else; var:'page_no'=($page_calc -
>> $maxpages); var:'skip2'=(((Math_Floor:($skip / (decimal:((MaxRecords_Value)
>> * $maxpages)))) * ((MaxRecords_Value) * $maxpages)) - ((MaxRecords_Value) *
>> $maxpages)); /If; Else; var:'page_no'=$page_calc;
>> var:'skip2'=((Math_Floor:($skip / (decimal:((MaxRecords_Value) *
>> $maxpages)))) * ((MaxRecords_Value) * $maxpages)); /If; '
>>
>>
>>                                              <p>\n';
>>
>>
>> //]
>> // The first possible hyperlink will lead the user to the very first
>> record from
>> // anywhere in the found set.
>> //[
>>
>>                If: (Shown_First)>=(MaxRecords_Value);
>>                        '<A HREF="bryllup.lasso?-SkipRecords=0"><span
>> class="text">F&oslash;rste</span></A>&nbsp;&nbsp;';
>>                else;
>>                        '<span
>> class="silver">F&oslash;rste</span>&nbsp;&nbsp;';
>>                /if;
>>
>> //]
>> // The second hyperlink, if applicable, is there to jump to the previous
>> set of
>> // results pages
>> //[
>>
>>                If: $skip2>0;
>>                        '<A HREF="bryllup.lasso?-SkipRecords=' +
>> ((($page_no - 1) * (maxrecords_value)) - (maxrecords_value)) + '"><span
>> class="text">Bakover</span></a>&nbsp;&nbsp;';
>>                Else;
>>                        '<span class="silver">Bakover</span>&nbsp;&nbsp;';
>>                /If;
>>
>> //]
>> // The third hyperlink, if applicable, simply brings the user to the
>> previous
>> // results page
>> //[
>>
>>                If: ($skip>(MaxRecords_Value));
>>                        '<A HREF="bryllup.lasso?-SkipRecords=' + ($skip -
>> ((MaxRecords_Value) * 2)) + '"><span
>> class="text">Forrige</span></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>>                Else;
>>                        '<span
>> class="silver">Forrige</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
>>                /If;
>>
>> //]
>> // Finally getting to the all important hyperlinks to individual pages.
>> // This part of the routine uses the maxpages variable to define the
>> // maximum number of page links to be displayed, which means that the user
>> // may have clicked to the next or previous set of pages (see second
>> // hyperlink description above). If the maximum is set to 10 with a
>> // Maxrecords value of 10 and a found set of 200 records, the 'pages' and
>> // &quot;page_no&quot; variables take care of the correct page numbering,
>> e.g 11-20
>> // for the second 'set'.
>> //[
>>
>>                loop: $pages;
>>                        If:(((skiprecords_value) / (maxrecords_value)) +
>> 1)==$page_no;
>>                                '<span class="text"><b><u>' + $page_no +
>> '</u></b></span>';
>>                        else;
>>                                '<A HREF="bryllup.lasso?-SkipRecords=' +
>> $skip2 + '"><span class="text">' + $page_no + '</span></a>';
>>                        /If;
>>                        '&nbsp;&nbsp;';
>>                        var:'page_no'=($page_no + 1),
>>                                'skip2'=($skip2 + (MaxRecords_Value));
>>                        If: $skip2 >= (found_count);
>>                                Loop_Abort;
>>                        /If;
>>                /loop;
>>
>> //]
>> // The equivalent of the third hyperlink, pointing to the next results
>> page.
>> //[
>>
>>                If: (found_count>$skip);
>>                        '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<A
>> HREF="bryllup.lasso?-SkipRecords=' + $skip + '"><span
>> class="text">Neste</span></a>';
>>                Else;
>>                        '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span
>> class="silver">Neste</span>';
>>                /If;
>>
>> //]
>> // The equivalent of the second hyperlink, jumping to the next set of
>> pages.
>> //[
>>
>>                If: $skip2<(found_count);
>>                        '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords='
>> + $skip2 + '"><span class="text">Forover</span></a>';
>>                Else;
>>                        '&nbsp;&nbsp;<span class="silver">Forover</span>';
>>                /If;
>>
>> //]
>> // The last hyperlink requires some additional calculations, courtesy of
>> // Michael Collins, to bring the user to the page displaying the very last
>> // record.
>> //[
>>
>>                If: ((Found_Count) % (MaxRecords_Value))==0;
>>                        Var:'Skip'=((Found_Count) - (MaxRecords_Value));
>>                else;
>>                        Var:'Skip'=((MaxRecords_Value) *
>> (Math_Floor:(decimal:(Found_Count)) / (decimal:(MaxRecords_Value))));
>>                /If;
>>                If:(($Skip) <=
>> (Found_Count))&&((Shown_Last)!=(Found_Count));
>>                        '&nbsp;&nbsp;<A HREF="bryllup.lasso?-SkipRecords='
>> + $Skip + '"><span class="text">Siste</span></A>';
>>                else;
>>                        '<span class="silver">&nbsp;&nbsp;Siste</span>';
>>                /if;
>>
>>
>>        /inline;
>> ?>
>>
>> #############################################################
>>
>> Attend the Lasso Developer Conference 2013!
>> Sept 12-14, 2013 in Niagara Falls, Canada
>> http://www.lassosoft.com/LDC-niagara-falls-2013
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>>  the mailing list Lasso
>> [hidden email]
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>>
>
>
>
> --
> Mvh
> Johan Sölve
> ____________________________________
> Montania System AB
> Halmstad   Stockholm
> http://www.montania.se
>
> Johan Sölve
> Mobil +46 709-51 55 70
> [hidden email]
>
> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
> Telefon +46 35-136800 |  Fax +46 35-136801
>
> #############################################################
>
> Attend the Lasso Developer Conference 2013!
> Sept 12-14, 2013 in Niagara Falls, Canada
> http://www.lassosoft.com/LDC-niagara-falls-2013
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>