Bullets

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

Bullets

Patrick Larkin-2
I have an app where teachers enter free form text in a lasso page and it gets submitted to a Filemaker Pro 6 database.  

Last year, when we used Lasso 6, certain teachers were copying and pasting bullet points into the text box and Filemaker Pro accepted them (and Lasso passed them).  This year, with Lasso 8.1, the bullets no longer get passed into Filemaker.  They show up as boxes and print out as blanks.  

Anyone have any idea?



Patrick Larkin
Developer/Administrator of Special Systems / Webmaster
Bethlehem Area School District





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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

Trevor Borgmeier
find every setting in lasso site admin (and possibly filemaker) related
to your database/tables and make sure they are set to utf-8...
then in your lasso files make sure they are saved UTF-8 w/ BOM

-Trevor



on 11/9/10 3:17 PM Patrick Larkin wrote:

> I have an app where teachers enter free form text in a lasso page and it gets submitted to a Filemaker Pro 6 database.
>
> Last year, when we used Lasso 6, certain teachers were copying and pasting bullet points into the text box and Filemaker Pro accepted them (and Lasso passed them).  This year, with Lasso 8.1, the bullets no longer get passed into Filemaker.  They show up as boxes and print out as blanks.
>
> Anyone have any idea?
>
>
>
> Patrick Larkin
> Developer/Administrator of Special Systems / Webmaster
> Bethlehem Area School District
>
>
>
>
>
> #############################################################
> This message is sent to you because you are subscribed to
>    the mailing list<[hidden email]>.
> To unsubscribe, E-mail to:<[hidden email]>
> To switch to the DIGEST mode, E-mail to<[hidden email]>
> To switch to the INDEX mode, E-mail to<[hidden email]>
> Send administrative queries to<[hidden email]>
>
>

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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

stevepiercy
In reply to this post by Patrick Larkin-2
On 11/9/10 at 4:17 PM, [hidden email] (Patrick Larkin) pronounced:

>I have an app where teachers enter free form text in a lasso
>page and it gets submitted to a Filemaker Pro 6 database.
>Last year, when we used Lasso 6, certain teachers were copying
>and pasting bullet points into the text box and Filemaker Pro
>accepted them (and Lasso passed them).  This year, with Lasso
>8.1, the bullets no longer get passed into Filemaker.  They
>show up as boxes and print out as blanks.

It's a character set issue.  Search Nabble for "character set".
http://old.nabble.com/Lasso---Talk-f739.html

--steve

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


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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

Patrick Larkin-2
Does this mean it's a setting in Lasso?  

Patrick

On Nov 9, 2010, at 4:34 PM, Steve Piercy - Web Site Builder <[hidden email]> wrote:

> On 11/9/10 at 4:17 PM, [hidden email] (Patrick Larkin) pronounced:
>
>> I have an app where teachers enter free form text in a lasso page and it gets submitted to a Filemaker Pro 6 database.
>> Last year, when we used Lasso 6, certain teachers were copying and pasting bullet points into the text box and Filemaker Pro accepted them (and Lasso passed them).  This year, with Lasso 8.1, the bullets no longer get passed into Filemaker.  They show up as boxes and print out as blanks.
>
> It's a character set issue.  Search Nabble for "character set".
> http://old.nabble.com/Lasso---Talk-f739.html
>
> --steve
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy               Web Site Builder               Soquel, CA
> <[hidden email]>                  <http://www.StevePiercy.com/>
>
>
> #############################################################
> This message is sent to you because you are subscribed to
> the mailing list <[hidden email]>.
> To unsubscribe, E-mail to: <[hidden email]>
> To switch to the DIGEST mode, E-mail to <[hidden email]>
> To switch to the INDEX mode, E-mail to <[hidden email]>
> Send administrative queries to  <[hidden email]>
>
>

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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

stevepiercy
That is one piece.

Other pieces may be settings in the database, the character set
defined in the headers, and the character sets supported by browsers.

Tests can isolate the issue.

* Type a literal bullet (option-8 on a Mac) in a blank Lasso
file saved as UTF-8 with BOM.  Load it.
* Use LiveHTTPHeaders to see the content-type's charset:
http://livehttpheaders.mozdev.org/

On my pages, I always see this:
Content-Type: text/html; charset=UTF-8

* If that looks OK, then you know the setting is between Lasso
and FileMaker, specifically the FM connector or FM db itself.

--steve


On 11/9/10 at 5:11 PM, [hidden email] (Patrick Larkin) pronounced:

>Does this mean it's a setting in Lasso?
>Patrick
>
>On Nov 9, 2010, at 4:34 PM, Steve Piercy - Web Site Builder <[hidden email]> wrote:
>
>>On 11/9/10 at 4:17 PM, [hidden email] (Patrick Larkin) pronounced:
>>
>>> I have an app where teachers enter free form text in a lasso page and it gets
>submitted to a Filemaker Pro 6 database.
>>> Last year, when we used Lasso 6, certain teachers were copying and pasting bullet
>points into the text box and Filemaker Pro accepted them (and
>Lasso passed them).  This year, with Lasso 8.1, the bullets no
>longer get passed into Filemaker.  They show up as boxes and
>print out as blanks.
>>
>>It's a character set issue.  Search Nabble for "character set".
>>http://old.nabble.com/Lasso---Talk-f739.html
>>
>>--steve
>>
>>-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>Steve Piercy               Web Site Builder               Soquel, CA
>><[hidden email]>                  <http://www.StevePiercy.com/>
>>
>>
>>#############################################################
>>This message is sent to you because you are subscribed to
>>the mailing list <[hidden email]>.
>>To unsubscribe, E-mail to: <[hidden email]>
>>To switch to the DIGEST mode, E-mail to <[hidden email]>
>>To switch to the INDEX mode, E-mail to <[hidden email]>
>>Send administrative queries to  <[hidden email]>
>>
>>
>
>#############################################################
>This message is sent to you because you are subscribed to
>the mailing list <[hidden email]>.
>To unsubscribe, E-mail to: <[hidden email]>
>To switch to the DIGEST mode, E-mail to <[hidden email]>
>To switch to the INDEX mode, E-mail to <[hidden email]>
>Send administrative queries to  <[hidden email]>
>

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


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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

Patrick Larkin-2
In reply to this post by Trevor Borgmeier
Ok.  Same database and code from last year.  Just the version of Lasso changed.

Not sure of the last thing you mentioned.  I suppose I can check that in BBEdit.  Thanks.

Patrick

On Nov 9, 2010, at 4:23 PM, Trevor Borgmeier <[hidden email]> wrote:

> find every setting in lasso site admin (and possibly filemaker) related to your database/tables and make sure they are set to utf-8...
> then in your lasso files make sure they are saved UTF-8 w/ BOM
>
> -Trevor
>
>
>
> on 11/9/10 3:17 PM Patrick Larkin wrote:
>> I have an app where teachers enter free form text in a lasso page and it gets submitted to a Filemaker Pro 6 database.
>>
>> Last year, when we used Lasso 6, certain teachers were copying and pasting bullet points into the text box and Filemaker Pro accepted them (and Lasso passed them).  This year, with Lasso 8.1, the bullets no longer get passed into Filemaker.  They show up as boxes and print out as blanks.
>>
>> Anyone have any idea?
>>
>>
>>
>> Patrick Larkin
>> Developer/Administrator of Special Systems / Webmaster
>> Bethlehem Area School District
>>
>>
>>
>>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>>   the mailing list<[hidden email]>.
>> To unsubscribe, E-mail to:<[hidden email]>
>> To switch to the DIGEST mode, E-mail to<[hidden email]>
>> To switch to the INDEX mode, E-mail to<[hidden email]>
>> Send administrative queries to<[hidden email]>
>>
>>
>
> #############################################################
> This message is sent to you because you are subscribed to
> the mailing list <[hidden email]>.
> To unsubscribe, E-mail to: <[hidden email]>
> To switch to the DIGEST mode, E-mail to <[hidden email]>
> To switch to the INDEX mode, E-mail to <[hidden email]>
> Send administrative queries to  <[hidden email]>
>
>

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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

Patrick Larkin-2
In reply to this post by Trevor Borgmeier
I see a bunch of settings under "Table Batch Change."  Not sure what this will do and the application is live with lots of people logged in.  



Patrick Larkin
Developer/Administrator of Special Systems / Webmaster
Bethlehem Area School District




On Nov 9, 2010, at 4:23 PM, Trevor Borgmeier wrote:

> find every setting in lasso site admin (and possibly filemaker) related to your database/tables and make sure they are set to utf-8...
> then in your lasso files make sure they are saved UTF-8 w/ BOM
>
> -Trevor
>
>
>
> on 11/9/10 3:17 PM Patrick Larkin wrote:
>> I have an app where teachers enter free form text in a lasso page and it gets submitted to a Filemaker Pro 6 database.
>>
>> Last year, when we used Lasso 6, certain teachers were copying and pasting bullet points into the text box and Filemaker Pro accepted them (and Lasso passed them).  This year, with Lasso 8.1, the bullets no longer get passed into Filemaker.  They show up as boxes and print out as blanks.
>>
>> Anyone have any idea?
>>
>>
>>
>> Patrick Larkin
>> Developer/Administrator of Special Systems / Webmaster
>> Bethlehem Area School District
>>
>>
>>
>>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>>   the mailing list<[hidden email]>.
>> To unsubscribe, E-mail to:<[hidden email]>
>> To switch to the DIGEST mode, E-mail to<[hidden email]>
>> To switch to the INDEX mode, E-mail to<[hidden email]>
>> Send administrative queries to<[hidden email]>
>>
>>
>
> #############################################################
> This message is sent to you because you are subscribed to
> the mailing list <[hidden email]>.
> To unsubscribe, E-mail to: <[hidden email]>
> To switch to the DIGEST mode, E-mail to <[hidden email]>
> To switch to the INDEX mode, E-mail to <[hidden email]>
> Send administrative queries to  <[hidden email]>
>
>


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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

stevepiercy
Did you try my tests first to isolate the issue?
http://old.nabble.com/Bullets-to30175246.html

Info on "Table Batch Change" is in the Setup Guide.

     Table Batch Change

     The table batch change option allows the encoding of every table
     on the current host[1] to be changed at once. Select a new encoding
     from the pop-up menu or select Other… and type a custom encoding
     choice. After clicking perform every table on the current host
     will be set to the specified encoding.

     Note: New tables which are added to databases on the host will
     not be set to the selected encoding . It may be necessary to
     adjust the encoding of each new table after they are added
or to
     use the batch change option after new tables are added.

[1] host as in from Lasso's perspective.  It does not change the
database or table, only the way Lasso interprets the
transmission of data.  Use UTF-8 for highest fidelity.

Also the UTF-8 with BOM issue has no effect data coming from
databases.  It pertains only to literal text in your Lasso
files.  It is still good to use the test I described earlier to
determine whether the browser can display the special character
without involving a database (it very likely will, but I like
being thorough).

This thread may be informative and clarify things:
http://old.nabble.com/OT%3A-MySQL-Character-Set-Conversion-to29384750.html#a29391704

--steve


On 11/10/10 at 8:48 AM, [hidden email] (Patrick Larkin) pronounced:

>I see a bunch of settings under "Table Batch Change."  Not sure
>what this will do and the application is live with lots of
>people logged in.
>
>
>Patrick Larkin
>Developer/Administrator of Special Systems / Webmaster
>Bethlehem Area School District
>
>
>
>
>On Nov 9, 2010, at 4:23 PM, Trevor Borgmeier wrote:
>
>>find every setting in lasso site admin (and possibly filemaker) related to your
>database/tables and make sure they are set to utf-8...
>>then in your lasso files make sure they are saved UTF-8 w/ BOM
>>
>>-Trevor
>>
>>
>>
>>on 11/9/10 3:17 PM Patrick Larkin wrote:
>>> I have an app where teachers enter free form text in a lasso page and it gets
>submitted to a Filemaker Pro 6 database.
>>>   Last year, when we used Lasso 6, certain teachers were
>>>copying and pasting bullet
>points into the text box and Filemaker Pro accepted them (and
>Lasso passed them).  This year, with Lasso 8.1, the bullets no
>longer get passed into Filemaker.  They show up as boxes and
>print out as blanks.
>>>   Anyone have any idea?
>>>     Patrick Larkin
>>> Developer/Administrator of Special Systems / Webmaster
>>> Bethlehem Area School District
>>>       #############################################################
>>> This message is sent to you because you are subscribed to
>>>   the mailing list<[hidden email]>.
>>> To unsubscribe, E-mail to:<[hidden email]>
>>> To switch to the DIGEST mode, E-mail to<[hidden email]>
>>> To switch to the INDEX mode, E-mail to<[hidden email]>
>>> Send administrative queries to<[hidden email]>
>>>  
>>
>>#############################################################
>>This message is sent to you because you are subscribed to
>>the mailing list <[hidden email]>.
>>To unsubscribe, E-mail to: <[hidden email]>
>>To switch to the DIGEST mode, E-mail to <[hidden email]>
>>To switch to the INDEX mode, E-mail to <[hidden email]>
>>Send administrative queries to  <[hidden email]>
>>
>>
>
>
>#############################################################
>This message is sent to you because you are subscribed to
>the mailing list <[hidden email]>.
>To unsubscribe, E-mail to: <[hidden email]>
>To switch to the DIGEST mode, E-mail to <[hidden email]>
>To switch to the INDEX mode, E-mail to <[hidden email]>
>Send administrative queries to  <[hidden email]>
>

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


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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

Bil Corry-3
In reply to this post by Patrick Larkin-2
Patrick Larkin wrote on 11/9/2010 1:17 PM:
> I have an app where teachers enter free form text in a lasso page and it gets submitted to a Filemaker Pro 6 database.  
>
> Last year, when we used Lasso 6, certain teachers were copying and pasting bullet points into the text box and Filemaker Pro accepted them (and Lasso passed them).  This year, with Lasso 8.1, the bullets no longer get passed into Filemaker.  They show up as boxes and print out as blanks.  
>
> Anyone have any idea?

Lasso 6, from what I recall, was incorrectly handling character set data -- it was storing it in a way that only worked for Lasso, all other external tools would see the data incorrectly in the database (including Lasso 8).

Your first step is to get *new* data correctly being stored, then display using Lasso.  After that works, you'll have to export the legacy data from Filemaker, change the encoding to UTF-8, then re-import the data as MacRoman or whatever it was originally stored as.

- Bil

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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

Patrick Larkin-2
In reply to this post by stevepiercy
I've gotten a chance to get back to this issue.

I've gone into Lasso and did the Table Batch Change to UTF-8.  When I dig down into the tables (layouts), I see the encoding is indeed set to UTF-8 however when I submit bullets in a text box, they still appear in filemaker as small boxes and display as spaces on the Lasso page.

I did do the tests you asked about.  I set a lasso page with a single bullet and brought it up using LiveHTTPHeaders and it showed UTF-8.  

This is Lasso 8.1 inserting data into Filemaker 6.  Like I said, it used to work (unintentionally) in Lasso 6 and then when I upgraded, the complaints came rolling in.  


Patrick Larkin
Developer/Administrator of Special Systems / Webmaster
Bethlehem Area School District




On Nov 10, 2010, at 4:40 PM, Steve Piercy - Web Site Builder wrote:

> Did you try my tests first to isolate the issue?
> http://old.nabble.com/Bullets-to30175246.html
>
> Info on "Table Batch Change" is in the Setup Guide.
>
>    Table Batch Change
>
>    The table batch change option allows the encoding of every table
>    on the current host[1] to be changed at once. Select a new encoding
>    from the pop-up menu or select Other… and type a custom encoding
>    choice. After clicking perform every table on the current host
>    will be set to the specified encoding.
>
>    Note: New tables which are added to databases on the host will
>    not be set to the selected encoding . It may be necessary to
>    adjust the encoding of each new table after they are added or to
>    use the batch change option after new tables are added.
>
> [1] host as in from Lasso's perspective.  It does not change the database or table, only the way Lasso interprets the transmission of data.  Use UTF-8 for highest fidelity.
>
> Also the UTF-8 with BOM issue has no effect data coming from databases.  It pertains only to literal text in your Lasso files.  It is still good to use the test I described earlier to determine whether the browser can display the special character without involving a database (it very likely will, but I like being thorough).
>
> This thread may be informative and clarify things:
> http://old.nabble.com/OT%3A-MySQL-Character-Set-Conversion-to29384750.html#a29391704
>
> --steve
>
>
> On 11/10/10 at 8:48 AM, [hidden email] (Patrick Larkin) pronounced:
>
>> I see a bunch of settings under "Table Batch Change."  Not sure what this will do and the application is live with lots of people logged in.
>>
>>
>> Patrick Larkin
>> Developer/Administrator of Special Systems / Webmaster
>> Bethlehem Area School District
>>
>>
>>
>>
>> On Nov 9, 2010, at 4:23 PM, Trevor Borgmeier wrote:
>>
>>> find every setting in lasso site admin (and possibly filemaker) related to your
>> database/tables and make sure they are set to utf-8...
>>> then in your lasso files make sure they are saved UTF-8 w/ BOM
>>>
>>> -Trevor
>>>
>>>
>>>
>>> on 11/9/10 3:17 PM Patrick Larkin wrote:
>>>> I have an app where teachers enter free form text in a lasso page and it gets
>> submitted to a Filemaker Pro 6 database.
>>>>  Last year, when we used Lasso 6, certain teachers were copying and pasting bullet
>> points into the text box and Filemaker Pro accepted them (and Lasso passed them).  This year, with Lasso 8.1, the bullets no longer get passed into Filemaker.  They show up as boxes and print out as blanks.
>>>>  Anyone have any idea?
>>>>    Patrick Larkin
>>>> Developer/Administrator of Special Systems / Webmaster
>>>> Bethlehem Area School District
>>>>      #############################################################
>>>> This message is sent to you because you are subscribed to
>>>>  the mailing list<[hidden email]>.
>>>> To unsubscribe, E-mail to:<[hidden email]>
>>>> To switch to the DIGEST mode, E-mail to<[hidden email]>
>>>> To switch to the INDEX mode, E-mail to<[hidden email]>
>>>> Send administrative queries to<[hidden email]>
>>>>
>>>
>>> #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list <[hidden email]>.
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> To switch to the DIGEST mode, E-mail to <[hidden email]>
>>> To switch to the INDEX mode, E-mail to <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>>
>>>
>>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list <[hidden email]>.
>> To unsubscribe, E-mail to: <[hidden email]>
>> To switch to the DIGEST mode, E-mail to <[hidden email]>
>> To switch to the INDEX mode, E-mail to <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy               Web Site Builder               Soquel, CA
> <[hidden email]>                  <http://www.StevePiercy.com/>
>
>
> #############################################################
> This message is sent to you because you are subscribed to
> the mailing list <[hidden email]>.
> To unsubscribe, E-mail to: <[hidden email]>
> To switch to the DIGEST mode, E-mail to <[hidden email]>
> To switch to the INDEX mode, E-mail to <[hidden email]>
> Send administrative queries to  <[hidden email]>
>
>


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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

stevepiercy
Create 3 test files that have the minimum code required to
function.  For each of these 3 tests, what do you see, each in
the (a) source code and (b) the rendered page?

(1)  Put this in a Lasso file by itself and load it:

['•']

(2)  Next enter a bullet point in a field for a record using the
FMP client directly, then use Lasso to find and display that
record and its field.

     inline(cnxn, criteria to find the bullet, -search);
         records;
             'bullet: ' + field('mybulletfield') + '<br>';

(3)  Next do an inline -add.

     inline(cnxn, ..., 'bullet'='•', -add);
         records;
             'bullet: ' + field('mybulletfield') + '<br>';

FileMaker should do a search for the record just added.

Post back results of the tests.

--steve


On 1/5/11 at 12:05 PM, [hidden email] (Patrick Larkin) pronounced:

>I've gotten a chance to get back to this issue.
>
>I've gone into Lasso and did the Table Batch Change to UTF-8.  
>When I dig down into the tables (layouts), I see the encoding
>is indeed set to UTF-8 however when I submit bullets in a text
>box, they still appear in filemaker as small boxes and display
>as spaces on the Lasso page.
>
>I did do the tests you asked about.  I set a lasso page with a
>single bullet and brought it up using LiveHTTPHeaders and it
>showed UTF-8.
>This is Lasso 8.1 inserting data into Filemaker 6.  Like I
>said, it used to work (unintentionally) in Lasso 6 and then
>when I upgraded, the complaints came rolling in.
>
>Patrick Larkin
>Developer/Administrator of Special Systems / Webmaster
>Bethlehem Area School District
>
>
>
>
>On Nov 10, 2010, at 4:40 PM, Steve Piercy - Web Site Builder wrote:
>
>>Did you try my tests first to isolate the issue?
>>http://old.nabble.com/Bullets-to30175246.html
>>
>>Info on "Table Batch Change" is in the Setup Guide.
>>
>>Table Batch Change
>>
>>The table batch change option allows the encoding of every table
>>on the current host[1] to be changed at once. Select a new encoding
>>from the pop-up menu or select Other… and type a custom encoding
>>choice. After clicking perform every table on the current host
>>will be set to the specified encoding.
>>
>>Note: New tables which are added to databases on the host will
>>not be set to the selected encoding . It may be necessary to
>>adjust the encoding of each new table after they are added or to
>>use the batch change option after new tables are added.
>>
>>[1] host as in from Lasso's perspective.  It does not change the database or table,
>only the way Lasso interprets the transmission of data.  Use
>UTF-8 for highest fidelity.
>>
>>Also the UTF-8 with BOM issue has no effect data coming from databases.  It
>pertains only to literal text in your Lasso files.  It is still
>good to use the test I described earlier to determine whether
>the browser can display the special character without involving
>a database (it very likely will, but I like being thorough).
>>
>>This thread may be informative and clarify things:
>>
>http://old.nabble.com/OT%3A-MySQL-Character-Set-Conversion-to29384750.html#a29391704
>>
>>--steve
>>
>>
>>On 11/10/10 at 8:48 AM, [hidden email] (Patrick Larkin) pronounced:
>>
>>> I see a bunch of settings under "Table Batch Change."  Not sure what this will do
>and the application is live with lots of people logged in.
>>>    Patrick Larkin
>>> Developer/Administrator of Special Systems / Webmaster
>>> Bethlehem Area School District
>>>      On Nov 9, 2010, at 4:23 PM, Trevor Borgmeier wrote:
>>>
>>>> find every setting in lasso site admin (and possibly filemaker) related to your
>>> database/tables and make sure they are set to utf-8...
>>>> then in your lasso files make sure they are saved UTF-8 w/ BOM
>>>>   -Trevor
>>>>     on 11/9/10 3:17 PM Patrick Larkin wrote:
>>>>> I have an app where teachers enter free form text in a lasso page and it gets
>>> submitted to a Filemaker Pro 6 database.
>>>>>  Last year, when we used Lasso 6, certain teachers were copying and pasting
>bullet
>>> points into the text box and Filemaker Pro accepted them (and Lasso passed them).
>This year, with Lasso 8.1, the bullets no longer get passed
>into Filemaker.  They show up as boxes and print out as blanks.
>>>>>  Anyone have any idea?
>>>>>    Patrick Larkin
>>>>> Developer/Administrator of Special Systems / Webmaster
>>>>> Bethlehem Area School District
>>>>>      #############################################################
>>>>> This message is sent to you because you are subscribed to
>>>>>  the mailing list<[hidden email]>.
>>>>> To unsubscribe, E-mail to:<[hidden email]>
>>>>> To switch to the DIGEST mode, E-mail to<[hidden email]>
>>>>> To switch to the INDEX mode, E-mail to<[hidden email]>
>>>>> Send administrative queries to<[hidden email]>
>>>>>
>>>>   #############################################################
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list <[hidden email]>.
>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>> To switch to the DIGEST mode, E-mail to <[hidden email]>
>>>> To switch to the INDEX mode, E-mail to <[hidden email]>
>>>> Send administrative queries to  <[hidden email]>
>>>>  
>>>    #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list <[hidden email]>.
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> To switch to the DIGEST mode, E-mail to <[hidden email]>
>>> To switch to the INDEX mode, E-mail to <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>>
>>
>>-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>Steve Piercy               Web Site Builder               Soquel, CA
>><[hidden email]>                  <http://www.StevePiercy.com/>
>>
>>
>>#############################################################
>>This message is sent to you because you are subscribed to
>>the mailing list <[hidden email]>.
>>To unsubscribe, E-mail to: <[hidden email]>
>>To switch to the DIGEST mode, E-mail to <[hidden email]>
>>To switch to the INDEX mode, E-mail to <[hidden email]>
>>Send administrative queries to  <[hidden email]>
>>
>>
>
>
>#############################################################
>This message is sent to you because you are subscribed to
>the mailing list <[hidden email]>.
>To unsubscribe, E-mail to: <[hidden email]>
>To switch to the DIGEST mode, E-mail to <[hidden email]>
>To switch to the INDEX mode, E-mail to <[hidden email]>
>Send administrative queries to  <[hidden email]>
>

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


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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

Patrick Larkin-2
(1) Page displays •
(2) Page displays bullet: (no bullet)
(3) -add not enabled for this application.  I did an update instead and Lasso page displays:

bullet: (no bullet)

and Filemaker shows a box.



On Jan 5, 2011, at 12:56 PM, Steve Piercy - Web Site Builder wrote:

> Create 3 test files that have the minimum code required to function.  For each of these 3 tests, what do you see, each in the (a) source code and (b) the rendered page?
>
> (1)  Put this in a Lasso file by itself and load it:
>
> ['•']
>
> (2)  Next enter a bullet point in a field for a record using the FMP client directly, then use Lasso to find and display that record and its field.
>
>    inline(cnxn, criteria to find the bullet, -search);
>        records;
>            'bullet: ' + field('mybulletfield') + '<br>';
>
> (3)  Next do an inline -add.
>
>    inline(cnxn, ..., 'bullet'='•', -add);
>        records;
>            'bullet: ' + field('mybulletfield') + '<br>';
>
> FileMaker should do a search for the record just added.
>
> Post back results of the tests.
>
> --steve
>
>
> On 1/5/11 at 12:05 PM, [hidden email] (Patrick Larkin) pronounced:
>
>> I've gotten a chance to get back to this issue.
>>
>> I've gone into Lasso and did the Table Batch Change to UTF-8.  When I dig down into the tables (layouts), I see the encoding is indeed set to UTF-8 however when I submit bullets in a text box, they still appear in filemaker as small boxes and display as spaces on the Lasso page.
>>
>> I did do the tests you asked about.  I set a lasso page with a single bullet and brought it up using LiveHTTPHeaders and it showed UTF-8.
>> This is Lasso 8.1 inserting data into Filemaker 6.  Like I said, it used to work (unintentionally) in Lasso 6 and then when I upgraded, the complaints came rolling in.
>>
>> Patrick Larkin
>> Developer/Administrator of Special Systems / Webmaster
>> Bethlehem Area School District
>>
>>
>>
>>
>> On Nov 10, 2010, at 4:40 PM, Steve Piercy - Web Site Builder wrote:
>>
>>> Did you try my tests first to isolate the issue?
>>> http://old.nabble.com/Bullets-to30175246.html
>>>
>>> Info on "Table Batch Change" is in the Setup Guide.
>>>
>>> Table Batch Change
>>>
>>> The table batch change option allows the encoding of every table
>>> on the current host[1] to be changed at once. Select a new encoding
>>> from the pop-up menu or select Other… and type a custom encoding
>>> choice. After clicking perform every table on the current host
>>> will be set to the specified encoding.
>>>
>>> Note: New tables which are added to databases on the host will
>>> not be set to the selected encoding . It may be necessary to
>>> adjust the encoding of each new table after they are added or to
>>> use the batch change option after new tables are added.
>>>
>>> [1] host as in from Lasso's perspective.  It does not change the database or table,
>> only the way Lasso interprets the transmission of data.  Use UTF-8 for highest fidelity.
>>>
>>> Also the UTF-8 with BOM issue has no effect data coming from databases.  It
>> pertains only to literal text in your Lasso files.  It is still good to use the test I described earlier to determine whether the browser can display the special character without involving a database (it very likely will, but I like being thorough).
>>>
>>> This thread may be informative and clarify things:
>>>
>> http://old.nabble.com/OT%3A-MySQL-Character-Set-Conversion-to29384750.html#a29391704
>>>
>>> --steve
>>>
>>>
>>> On 11/10/10 at 8:48 AM, [hidden email] (Patrick Larkin) pronounced:
>>>
>>>> I see a bunch of settings under "Table Batch Change."  Not sure what this will do
>> and the application is live with lots of people logged in.
>>>>   Patrick Larkin
>>>> Developer/Administrator of Special Systems / Webmaster
>>>> Bethlehem Area School District
>>>>     On Nov 9, 2010, at 4:23 PM, Trevor Borgmeier wrote:
>>>>
>>>>> find every setting in lasso site admin (and possibly filemaker) related to your
>>>> database/tables and make sure they are set to utf-8...
>>>>> then in your lasso files make sure they are saved UTF-8 w/ BOM
>>>>>  -Trevor
>>>>>    on 11/9/10 3:17 PM Patrick Larkin wrote:
>>>>>> I have an app where teachers enter free form text in a lasso page and it gets
>>>> submitted to a Filemaker Pro 6 database.
>>>>>> Last year, when we used Lasso 6, certain teachers were copying and pasting
>> bullet
>>>> points into the text box and Filemaker Pro accepted them (and Lasso passed them).
>> This year, with Lasso 8.1, the bullets no longer get passed into Filemaker.  They show up as boxes and print out as blanks.
>>>>>> Anyone have any idea?
>>>>>>   Patrick Larkin
>>>>>> Developer/Administrator of Special Systems / Webmaster
>>>>>> Bethlehem Area School District
>>>>>>     #############################################################
>>>>>> This message is sent to you because you are subscribed to
>>>>>> the mailing list<[hidden email]>.
>>>>>> To unsubscribe, E-mail to:<[hidden email]>
>>>>>> To switch to the DIGEST mode, E-mail to<[hidden email]>
>>>>>> To switch to the INDEX mode, E-mail to<[hidden email]>
>>>>>> Send administrative queries to<[hidden email]>
>>>>>>
>>>>>  #############################################################
>>>>> This message is sent to you because you are subscribed to
>>>>> the mailing list <[hidden email]>.
>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>> To switch to the DIGEST mode, E-mail to <[hidden email]>
>>>>> To switch to the INDEX mode, E-mail to <[hidden email]>
>>>>> Send administrative queries to  <[hidden email]>
>>>>>
>>>>   #############################################################
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list <[hidden email]>.
>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>> To switch to the DIGEST mode, E-mail to <[hidden email]>
>>>> To switch to the INDEX mode, E-mail to <[hidden email]>
>>>> Send administrative queries to  <[hidden email]>
>>>>
>>>
>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>> Steve Piercy               Web Site Builder               Soquel, CA
>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>
>>>
>>> #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list <[hidden email]>.
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> To switch to the DIGEST mode, E-mail to <[hidden email]>
>>> To switch to the INDEX mode, E-mail to <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>>
>>>
>>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list <[hidden email]>.
>> To unsubscribe, E-mail to: <[hidden email]>
>> To switch to the DIGEST mode, E-mail to <[hidden email]>
>> To switch to the INDEX mode, E-mail to <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy               Web Site Builder               Soquel, CA
> <[hidden email]>                  <http://www.StevePiercy.com/>
>
>
> #############################################################
> This message is sent to you because you are subscribed to
> the mailing list <[hidden email]>.
> To unsubscribe, E-mail to: <[hidden email]>
> To switch to the DIGEST mode, E-mail to <[hidden email]>
> To switch to the INDEX mode, E-mail to <[hidden email]>
> Send administrative queries to  <[hidden email]>
>
>


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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

Bil Corry-3
Change the code that displays the result for (2) and (3) to this:

        'bullet: ' + field('mybulletfield')->integer + '<br>';

And change (1) to this:

        ['•'->integer]

Also, when the page is loaded in your browser, confirm that the browser is rendering it as UTF-8.  In Firefox, it's View > Character Encoding, and UTF-8 should have a bullet next to it.  Let us know if it's UTF-8 or some other character set.

- Bil

Patrick Larkin wrote on 1/5/2011 12:29 PM:

> (1) Page displays •
> (2) Page displays bullet: (no bullet)
> (3) -add not enabled for this application.  I did an update instead and Lasso page displays:
>
> bullet: (no bullet)
>
> and Filemaker shows a box.
>
>
>
> On Jan 5, 2011, at 12:56 PM, Steve Piercy - Web Site Builder wrote:
>
>> Create 3 test files that have the minimum code required to function.  For each of these 3 tests, what do you see, each in the (a) source code and (b) the rendered page?
>>
>> (1)  Put this in a Lasso file by itself and load it:
>>
>> ['•']
>>
>> (2)  Next enter a bullet point in a field for a record using the FMP client directly, then use Lasso to find and display that record and its field.
>>
>>     inline(cnxn, criteria to find the bullet, -search);
>>         records;
>>             'bullet: ' + field('mybulletfield') + '<br>';
>>
>> (3)  Next do an inline -add.
>>
>>     inline(cnxn, ..., 'bullet'='•', -add);
>>         records;
>>             'bullet: ' + field('mybulletfield') + '<br>';
>>
>> FileMaker should do a search for the record just added.
>>
>> Post back results of the tests.


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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

stevepiercy
For (2), the result should be this:

bullet: &#8226;

Although I'm using FMSA 9 and Lasso 8.5.6, it should not make a
difference.  Is the only difference in your setup the following?

OLD: Lasso 6
NEW: Lasso 8.1

If so, I suspect that you have a Lasso Admin setting different
between these two versions.  I grabbed an old PDF of the 8.1
Setup Guide.

First let's have a look at that troublesome table.

Under SiteAdmin > Setup > Data Sources > Tables
Click the link for the table giving you trouble, and check its
encoding.  What does it say?  It should be UTF-8.

Under SiteAdmin > Setup > Data Sources > Hosts
Select the proper connector.
Click the link for the host to view its details on the right.
Do a Table Batch Change to UTF-8

Under SiteAdmin > Setup > Data Sources > Databases
Click the link for the database to view its details on the right.
Do a Table Batch Change to UTF-8

Under SiteAdmin > Setup > Data Sources > Tables
Click the link for the table giving you trouble, and check its encoding.

 From the Setup Guide:

     Table Batch Change

     The table batch change option allows the encoding of every table
     on the current host to be changed at once. Select a new encoding
     from the pop-up menu or select Other… and type a custom encoding
     choice. After clicking perform every table on the current host
     will be set to the specified encoding.

     Note: New tables which are added to databases on the host will
     not be set to the selected encoding. It may be necessary to
     adjust the encoding of each new table after they are added
or to
     use the batch change option after new tables are added.

Finally under SiteAdmin > Site > Lasso Settings > Default Page
Encoding should be set to  UTF-8.  Is it?

--steve


On 1/5/11 at 10:21 PM, [hidden email] (Bil Corry) pronounced:

>Change the code that displays the result for (2) and (3) to this:
>
>'bullet: ' + field('mybulletfield')->integer + '<br>';
>
>And change (1) to this:
>
>['•'->integer]
>
>Also, when the page is loaded in your browser, confirm that the
>browser is rendering it as UTF-8.  In Firefox, it's View >
>Character Encoding, and UTF-8 should have a bullet next to it.  
>Let us know if it's UTF-8 or some other character set.
>
>- Bil
>
>Patrick Larkin wrote on 1/5/2011 12:29 PM:
>>(1) Page displays •
>>(2) Page displays bullet: (no bullet)
>>(3) -add not enabled for this application.  I did an update instead and Lasso page
>displays:
>>
>>bullet: (no bullet)
>>
>>and Filemaker shows a box.
>>
>>
>>
>>On Jan 5, 2011, at 12:56 PM, Steve Piercy - Web Site Builder wrote:
>>
>>>Create 3 test files that have the minimum code required to function.  For each of
>these 3 tests, what do you see, each in the (a) source code and
>(b) the rendered page?
>>>
>>>(1)  Put this in a Lasso file by itself and load it:
>>>
>>>['•']
>>>
>>>(2)  Next enter a bullet point in a field for a record using the FMP client
>directly, then use Lasso to find and display that record and its field.
>>>
>>>    inline(cnxn, criteria to find the bullet, -search);
>>>        records;
>>>            'bullet: ' + field('mybulletfield') + '<br>';
>>>
>>>(3)  Next do an inline -add.
>>>
>>>    inline(cnxn, ..., 'bullet'='•', -add);
>>>        records;
>>>            'bullet: ' + field('mybulletfield') + '<br>';
>>>
>>>FileMaker should do a search for the record just added.
>>>
>>>Post back results of the tests.
>
>
>#############################################################
>This message is sent to you because you are subscribed to
>the mailing list <[hidden email]>.
>To unsubscribe, E-mail to: <[hidden email]>
>To switch to the DIGEST mode, E-mail to <[hidden email]>
>To switch to the INDEX mode, E-mail to <[hidden email]>
>Send administrative queries to  <[hidden email]>
>

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


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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

Bil Corry-3
Steve Piercy - Web Site Builder wrote on 1/6/2011 12:06 AM:
> Is the only difference in your setup the following?
>
> OLD: Lasso 6
> NEW: Lasso 8.1
>
> If so, I suspect that you have a Lasso Admin setting different between these two versions.

LP7 introduced full Unicode support which changed how data was passed between the server and database.  Settings aside, that change broke a lot of LP6 solutions that had mismatched charsets being stored in their database.


- Bil

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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

Patrick Larkin-2
In reply to this post by stevepiercy

Patrick Larkin
Developer/Administrator of Special Systems / Webmaster
Bethlehem Area School District




On Jan 6, 2011, at 3:06 AM, Steve Piercy - Web Site Builder wrote:

> For (2), the result should be this:
>
> bullet: &#8226;
>
> Although I'm using FMSA 9 and Lasso 8.5.6, it should not make a difference.  Is the only difference in your setup the following?
>
> OLD: Lasso 6
> NEW: Lasso 8.1

That's it.  

>
> If so, I suspect that you have a Lasso Admin setting different between these two versions.  I grabbed an old PDF of the 8.1 Setup Guide.
>
> First let's have a look at that troublesome table.
>
> Under SiteAdmin > Setup > Data Sources > Tables
> Click the link for the table giving you trouble, and check its encoding.  What does it say?  It should be UTF-8.

Yes, it does.


>
> Under SiteAdmin > Setup > Data Sources > Hosts
> Select the proper connector.
> Click the link for the host to view its details on the right.
> Do a Table Batch Change to UTF-8

Done.


>
> Under SiteAdmin > Setup > Data Sources > Databases
> Click the link for the database to view its details on the right.
> Do a Table Batch Change to UTF-8

Done.

>
> Under SiteAdmin > Setup > Data Sources > Tables
> Click the link for the table giving you trouble, and check its encoding.

UTF-8 (Unicode)

>
> From the Setup Guide:
>
>    Table Batch Change
>
>    The table batch change option allows the encoding of every table
>    on the current host to be changed at once. Select a new encoding
>    from the pop-up menu or select Other… and type a custom encoding
>    choice. After clicking perform every table on the current host
>    will be set to the specified encoding.
>
>    Note: New tables which are added to databases on the host will
>    not be set to the selected encoding. It may be necessary to
>    adjust the encoding of each new table after they are added or to
>    use the batch change option after new tables are added.
>
> Finally under SiteAdmin > Site > Lasso Settings > Default Page Encoding should be set to  UTF-8.  Is it?
>

Yes.

Everything seems right.  



> On 1/5/11 at 10:21 PM, [hidden email] (Bil Corry) pronounced:
>
>> Change the code that displays the result for (2) and (3) to this:
>>
>> 'bullet: ' + field('mybulletfield')->integer + '<br>';
>>
>> And change (1) to this:
>>
>> ['•'->integer]
>>
>> Also, when the page is loaded in your browser, confirm that the browser is rendering it as UTF-8.  In Firefox, it's View > Character Encoding, and UTF-8 should have a bullet next to it.  Let us know if it's UTF-8 or some other character set.
>>
>> - Bil
>>
>> Patrick Larkin wrote on 1/5/2011 12:29 PM:
>>> (1) Page displays •
>>> (2) Page displays bullet: (no bullet)
>>> (3) -add not enabled for this application.  I did an update instead and Lasso page
>> displays:
>>>
>>> bullet: (no bullet)
>>>
>>> and Filemaker shows a box.
>>>
>>>
>>>
>>> On Jan 5, 2011, at 12:56 PM, Steve Piercy - Web Site Builder wrote:
>>>
>>>> Create 3 test files that have the minimum code required to function.  For each of
>> these 3 tests, what do you see, each in the (a) source code and (b) the rendered page?
>>>>
>>>> (1)  Put this in a Lasso file by itself and load it:
>>>>
>>>> ['•']
>>>>
>>>> (2)  Next enter a bullet point in a field for a record using the FMP client
>> directly, then use Lasso to find and display that record and its field.
>>>>
>>>>   inline(cnxn, criteria to find the bullet, -search);
>>>>       records;
>>>>           'bullet: ' + field('mybulletfield') + '<br>';
>>>>
>>>> (3)  Next do an inline -add.
>>>>
>>>>   inline(cnxn, ..., 'bullet'='•', -add);
>>>>       records;
>>>>           'bullet: ' + field('mybulletfield') + '<br>';
>>>>
>>>> FileMaker should do a search for the record just added.
>>>>
>>>> Post back results of the tests.
>>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list <[hidden email]>.
>> To unsubscribe, E-mail to: <[hidden email]>
>> To switch to the DIGEST mode, E-mail to <[hidden email]>
>> To switch to the INDEX mode, E-mail to <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy               Web Site Builder               Soquel, CA
> <[hidden email]>                  <http://www.StevePiercy.com/>
>
>
> #############################################################
> This message is sent to you because you are subscribed to
> the mailing list <[hidden email]>.
> To unsubscribe, E-mail to: <[hidden email]>
> To switch to the DIGEST mode, E-mail to <[hidden email]>
> To switch to the INDEX mode, E-mail to <[hidden email]>
> Send administrative queries to  <[hidden email]>
>
>


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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

Patrick Larkin-2
In reply to this post by Bil Corry-3



On Jan 6, 2011, at 1:21 AM, Bil Corry wrote:

> Change the code that displays the result for (2) and (3) to this:
>
> 'bullet: ' + field('mybulletfield')->integer + '<br>';


(2) output - bullet: 149
(3) output - bullet: 26


>
> And change (1) to this:
>
> ['•'->integer]

(1) output - 8226


>
> Also, when the page is loaded in your browser, confirm that the browser is rendering it as UTF-8.  In Firefox, it's View > Character Encoding, and UTF-8 should have a bullet next to it.  Let us know if it's UTF-8 or some other character set.
>
> - Bil

It is set to UTF-8 character encoding.



>
> Patrick Larkin wrote on 1/5/2011 12:29 PM:
>> (1) Page displays •
>> (2) Page displays bullet: (no bullet)
>> (3) -add not enabled for this application.  I did an update instead and Lasso page displays:
>>
>> bullet: (no bullet)
>>
>> and Filemaker shows a box.
>>
>>
>>
>> On Jan 5, 2011, at 12:56 PM, Steve Piercy - Web Site Builder wrote:
>>
>>> Create 3 test files that have the minimum code required to function.  For each of these 3 tests, what do you see, each in the (a) source code and (b) the rendered page?
>>>
>>> (1)  Put this in a Lasso file by itself and load it:
>>>
>>> ['•']
>>>
>>> (2)  Next enter a bullet point in a field for a record using the FMP client directly, then use Lasso to find and display that record and its field.
>>>
>>>    inline(cnxn, criteria to find the bullet, -search);
>>>        records;
>>>            'bullet: ' + field('mybulletfield') + '<br>';
>>>
>>> (3)  Next do an inline -add.
>>>
>>>    inline(cnxn, ..., 'bullet'='•', -add);
>>>        records;
>>>            'bullet: ' + field('mybulletfield') + '<br>';
>>>
>>> FileMaker should do a search for the record just added.
>>>
>>> Post back results of the tests.
>
>
> #############################################################
> This message is sent to you because you are subscribed to
> the mailing list <[hidden email]>.
> To unsubscribe, E-mail to: <[hidden email]>
> To switch to the DIGEST mode, E-mail to <[hidden email]>
> To switch to the INDEX mode, E-mail to <[hidden email]>
> Send administrative queries to  <[hidden email]>
>
>


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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

Bil Corry-3
Patrick Larkin wrote on 1/6/2011 12:44 PM:
> On Jan 6, 2011, at 1:21 AM, Bil Corry wrote:
>
>> Change the code that displays the result for (2) and (3) to this:
>>
>> 'bullet: ' + field('mybulletfield')->integer + '<br>';
>
>
> (2) output - bullet: 149

That's Windows-1252:

        http://en.wikipedia.org/wiki/Windows-1252


> (3) output - bullet: 26

That's the 1A connector bug.  I thought it only affected MySQL, but given you're seeing it with Filemaker, it appears it affects Filemaker too.  Not sure if it's a bug being fixed for Lasso 8.6, but seeing how you're on 8.1, I think your only option is to base64 encode the data before sending it to Filemaker.


>
>>
>> And change (1) to this:
>>
>> ['•'->integer]
>
> (1) output - 8226

That's UTF-8.



>
>>
>> Also, when the page is loaded in your browser, confirm that the browser is rendering it as UTF-8.  In Firefox, it's View>  Character Encoding, and UTF-8 should have a bullet next to it.  Let us know if it's UTF-8 or some other character set.
>>
>> - Bil
>
> It is set to UTF-8 character encoding.
>

If you force the browser to use Windows-1252, you should see the bullet for (2) (if you remove ->integer).


- Bil

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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

Bil Corry-3
Bil Corry wrote on 1/6/2011 2:17 PM:

> Patrick Larkin wrote on 1/6/2011 12:44 PM:
>> On Jan 6, 2011, at 1:21 AM, Bil Corry wrote:
>>
>>> Change the code that displays the result for (2) and (3) to this:
>>>
>>> 'bullet: ' + field('mybulletfield')->integer + '<br>';
>>
>>
>> (2) output - bullet: 149
>
> That's Windows-1252:

More on this, I'm not sure if Lasso is pulling it as Windows-1252 from Filemaker, or if Lasso believes the outbound page encoding is Windows-1252 (or if Lasso is trying to honor your browsers request for Windows-1252).

But let's make sure Lasso knows we want to serve UTF-8, and see what happens.  Add this to the top of that page:

        content_type('text/html; charset=UTF-8');
        'Lasso wants to serve this page as ' + $__encoding__;

See if the numbers change and see if it says Lasso wants to serve UTF-8 or something else.


- Bil

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

Reply | Threaded
Open this post in threaded view
|

Re: Bullets

Bil Corry-3
Bil Corry wrote on 1/6/2011 2:26 PM:
> But let's make sure Lasso knows we want to serve UTF-8, and see what happens. Add this to the top of that page:
>
> content_type('text/html; charset=UTF-8');
> 'Lasso wants to serve this page as ' + $__encoding__;

Bah!  Should be:

        'Lasso wants to serve this page as ' + $__encoding__;
        content_type('text/html; charset=UTF-8');

The other way will always report UTF-8 since we just set it.


- Bil

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

1234