Encoding Problem

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

Encoding Problem

Randy Zumwalde
Hi List,

I have upgraded our servers/software to Mac Mini Apple Servers with
Lasso 8.6 and FileMaker Server 11
We were using WebStar/Lasso 8.5/Filemaker Server Advanced 8

For some reason my product category links which are pulled via a
Filemaker value list are translating the space as %20.
So my product category Business Accessories is being sent as
Business%20Accessories and therefore Filemaker cant find the products.
Single word categories work just fine.

My link is set up like this:
[String_Concatenate: (var:
'Root_Path'),'category_listing.lasso?-Session=',(var:'Site_Session_Name'),':',(Session_ID:
-Name=(var:'Site_Session_Name'))]&cat=[Value_ListItem: -encodeURL]

This all worked flawless for years and now I can't figure out why it's
not working.

Thanks,
Randy Zumwalde
#############################################################
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: Encoding Problem

Brad Lindsay-2
On Oct 23, 2012, at 10:49 AM, Randy Zumwalde <[hidden email]> wrote:

> I have upgraded our servers/software to Mac Mini Apple Servers with Lasso 8.6 and FileMaker Server 11
> We were using WebStar/Lasso 8.5/Filemaker Server Advanced 8
>
> For some reason my product category links which are pulled via a Filemaker value list are translating the space as %20.
> So my product category Business Accessories is being sent as Business%20Accessories and therefore Filemaker cant find the products. Single word categories work just fine.
>
> My link is set up like this:
> [String_Concatenate: (var: 'Root_Path'),'category_listing.lasso?-Session=',(var:'Site_Session_Name'),':',(Session_ID: -Name=(var:'Site_Session_Name'))]&cat=[Value_ListItem: -encodeURL]
>
> This all worked flawless for years and now I can't figure out why it's not working.

I don't use Filemaker, so I'm not exactly sure from your description what is going on. However, %20 is the URL encoding for a space. The link code you posted does mention URL encoding ([Value_ListItem: -encodeURL]), and any link you go to in a modern browser would automatically translate those spaces to %20 as well. If the problem is with something you are passing to Filemaker, you may need to call decode_url on that code? Of course, this may all just be ramblings of someone not familiar with Filemaker.

Brad
#############################################################
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: Encoding Problem

Tami Williams

Try this and see what happens:

[String_Concatenate: (var: 'Root_Path'),'category_listing.lasso?-Session=',(var:'Site_Session_Name'),':',(Session_ID: -Name=(var:'Site_Session_Name'))]&cat=[Value_ListItem]



On Oct 23, 2012, at 12:12 PM, Brad Lindsay wrote:

> On Oct 23, 2012, at 10:49 AM, Randy Zumwalde <[hidden email]> wrote:
>> I have upgraded our servers/software to Mac Mini Apple Servers with Lasso 8.6 and FileMaker Server 11
>> We were using WebStar/Lasso 8.5/Filemaker Server Advanced 8
>>
>> For some reason my product category links which are pulled via a Filemaker value list are translating the space as %20.
>> So my product category Business Accessories is being sent as Business%20Accessories and therefore Filemaker cant find the products. Single word categories work just fine.
>>
>> My link is set up like this:
>> [String_Concatenate: (var: 'Root_Path'),'category_listing.lasso?-Session=',(var:'Site_Session_Name'),':',(Session_ID: -Name=(var:'Site_Session_Name'))]&cat=[Value_ListItem: -encodeURL]
>>
>> This all worked flawless for years and now I can't figure out why it's not working.
>
> I don't use Filemaker, so I'm not exactly sure from your description what is going on. However, %20 is the URL encoding for a space. The link code you posted does mention URL encoding ([Value_ListItem: -encodeURL]), and any link you go to in a modern browser would automatically translate those spaces to %20 as well. If the problem is with something you are passing to Filemaker, you may need to call decode_url on that code? Of course, this may all just be ramblings of someone not familiar with Filemaker.
>
> Brad
> #############################################################
> 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]>

#############################################################
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: Encoding Problem

Randy Zumwalde
In reply to this post by Brad Lindsay-2
The link calls category_listing.lasso which contains the inline to
search the database

[Inline: -Search, -Database=(Var:'Site_Base'), -Username='randal',
-Password='xxxxx', -Table='products', 'category'=(Action_Param:'cat'),
-SkipRecords=(Action_Param:'skip'), -MaxRecords='5']

When the inline receives the action_param 'cat' and places the value
into the inline search field 'category', the category field ends up
containing the value Business%20Accessories instead of Business
Accessories so no records are found.

Randy

On 10/23/12 12:12 PM, Brad Lindsay wrote:

> On Oct 23, 2012, at 10:49 AM, Randy Zumwalde <[hidden email]> wrote:
>> I have upgraded our servers/software to Mac Mini Apple Servers with Lasso 8.6 and FileMaker Server 11
>> We were using WebStar/Lasso 8.5/Filemaker Server Advanced 8
>>
>> For some reason my product category links which are pulled via a Filemaker value list are translating the space as %20.
>> So my product category Business Accessories is being sent as Business%20Accessories and therefore Filemaker cant find the products. Single word categories work just fine.
>>
>> My link is set up like this:
>> [String_Concatenate: (var: 'Root_Path'),'category_listing.lasso?-Session=',(var:'Site_Session_Name'),':',(Session_ID: -Name=(var:'Site_Session_Name'))]&cat=[Value_ListItem: -encodeURL]
>>
>> This all worked flawless for years and now I can't figure out why it's not working.
> I don't use Filemaker, so I'm not exactly sure from your description what is going on. However, %20 is the URL encoding for a space. The link code you posted does mention URL encoding ([Value_ListItem: -encodeURL]), and any link you go to in a modern browser would automatically translate those spaces to %20 as well. If the problem is with something you are passing to Filemaker, you may need to call decode_url on that code? Of course, this may all just be ramblings of someone not familiar with Filemaker.
>
> Brad
> #############################################################
> 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]>
>

--
#############################################################
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: Encoding Problem

Randy Zumwalde
In reply to this post by Tami Williams
I get the same result Tami.
This has worked fine for years I don't know why it quit after switching
servers. Here's a link if you want to check it out
http://secure1.ehowe.com/VibrantLiving/store/home.lasso

On 10/23/12 12:57 PM, Tami Williams wrote:

> Try this and see what happens:
>
> [String_Concatenate: (var: 'Root_Path'),'category_listing.lasso?-Session=',(var:'Site_Session_Name'),':',(Session_ID: -Name=(var:'Site_Session_Name'))]&cat=[Value_ListItem]
>
>
>
> On Oct 23, 2012, at 12:12 PM, Brad Lindsay wrote:
>
>> On Oct 23, 2012, at 10:49 AM, Randy Zumwalde <[hidden email]> wrote:
>>> I have upgraded our servers/software to Mac Mini Apple Servers with Lasso 8.6 and FileMaker Server 11
>>> We were using WebStar/Lasso 8.5/Filemaker Server Advanced 8
>>>
>>> For some reason my product category links which are pulled via a Filemaker value list are translating the space as %20.
>>> So my product category Business Accessories is being sent as Business%20Accessories and therefore Filemaker cant find the products. Single word categories work just fine.
>>>
>>> My link is set up like this:
>>> [String_Concatenate: (var: 'Root_Path'),'category_listing.lasso?-Session=',(var:'Site_Session_Name'),':',(Session_ID: -Name=(var:'Site_Session_Name'))]&cat=[Value_ListItem: -encodeURL]
>>>
>>> This all worked flawless for years and now I can't figure out why it's not working.
>> I don't use Filemaker, so I'm not exactly sure from your description what is going on. However, %20 is the URL encoding for a space. The link code you posted does mention URL encoding ([Value_ListItem: -encodeURL]), and any link you go to in a modern browser would automatically translate those spaces to %20 as well. If the problem is with something you are passing to Filemaker, you may need to call decode_url on that code? Of course, this may all just be ramblings of someone not familiar with Filemaker.
>>
>> Brad
>> #############################################################
>> 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]>
> #############################################################
> 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]>
>

--
#############################################################
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: Encoding Problem

Carl Ketterling
Randy,

You want the URL to be encoded when you click on it, right?  So the
problem, I think, is in the category listing page and how it's processed
there.  How is "Writing%20Instruments Listing" generated?

Carl


In response to this text from Randy Zumwalde ([hidden email])
sent on Tuesday, October 23, 2012 at 1:05 PM (-0400):

>I get the same result Tami.
>This has worked fine for years I don't know why it quit after switching
>servers. Here's a link if you want to check it out
>http://secure1.ehowe.com/VibrantLiving/store/home.lasso
>
>On 10/23/12 12:57 PM, Tami Williams wrote:
>> Try this and see what happens:
>>
>> [String_Concatenate: (var: 'Root_Path'),'category_listing.lasso?-
>Session=',(var:'Site_Session_Name'),':',(Session_ID: -
>Name=(var:'Site_Session_Name'))]&cat=[Value_ListItem]
>>
>>
>>
>> On Oct 23, 2012, at 12:12 PM, Brad Lindsay wrote:
>>
>>> On Oct 23, 2012, at 10:49 AM, Randy Zumwalde <[hidden email]>
wrote:

>>>> I have upgraded our servers/software to Mac Mini Apple Servers with
>Lasso 8.6 and FileMaker Server 11
>>>> We were using WebStar/Lasso 8.5/Filemaker Server Advanced 8
>>>>
>>>> For some reason my product category links which are pulled via a
>Filemaker value list are translating the space as %20.
>>>> So my product category Business Accessories is being sent as Business
>%20Accessories and therefore Filemaker cant find the products. Single
>word categories work just fine.
>>>>
>>>> My link is set up like this:
>>>> [String_Concatenate: (var: 'Root_Path'),'category_listing.lasso?-
>Session=',(var:'Site_Session_Name'),':',(Session_ID: -
>Name=(var:'Site_Session_Name'))]&cat=[Value_ListItem: -encodeURL]
>>>>
>>>> This all worked flawless for years and now I can't figure out why
>it's not working.
>>> I don't use Filemaker, so I'm not exactly sure from your description
>what is going on. However, %20 is the URL encoding for a space. The link
>code you posted does mention URL encoding ([Value_ListItem: -
>encodeURL]), and any link you go to in a modern browser would
>automatically translate those spaces to %20 as well. If the problem is
>with something you are passing to Filemaker, you may need to call
>decode_url on that code? Of course, this may all just be ramblings of
>someone not familiar with Filemaker.
>>>
>>> Brad
>>> #############################################################
>>> 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]>
>> #############################################################
>> 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]>
>>
>
>--
>#############################################################
>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]>


#############################################################
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: Encoding Problem

Randy Zumwalde
Carl,

It is generated from the parameter in the link.
[Action_Param:'cat'] Listing

Randy

On 10/23/12 1:10 PM, Carl Ketterling wrote:

> Randy,
>
> You want the URL to be encoded when you click on it, right?  So the
> problem, I think, is in the category listing page and how it's processed
> there.  How is "Writing%20Instruments Listing" generated?
>
> Carl
>
>
> In response to this text from Randy Zumwalde ([hidden email])
> sent on Tuesday, October 23, 2012 at 1:05 PM (-0400):
>
>> I get the same result Tami.
>> This has worked fine for years I don't know why it quit after switching
>> servers. Here's a link if you want to check it out
>> http://secure1.ehowe.com/VibrantLiving/store/home.lasso
>>
>> On 10/23/12 12:57 PM, Tami Williams wrote:
>>> Try this and see what happens:
>>>
>>> [String_Concatenate: (var: 'Root_Path'),'category_listing.lasso?-
>> Session=',(var:'Site_Session_Name'),':',(Session_ID: -
>> Name=(var:'Site_Session_Name'))]&cat=[Value_ListItem]
>>>
>>>
>>> On Oct 23, 2012, at 12:12 PM, Brad Lindsay wrote:
>>>
>>>> On Oct 23, 2012, at 10:49 AM, Randy Zumwalde <[hidden email]>
> wrote:
>>>>> I have upgraded our servers/software to Mac Mini Apple Servers with
>> Lasso 8.6 and FileMaker Server 11
>>>>> We were using WebStar/Lasso 8.5/Filemaker Server Advanced 8
>>>>>
>>>>> For some reason my product category links which are pulled via a
>> Filemaker value list are translating the space as %20.
>>>>> So my product category Business Accessories is being sent as Business
>> %20Accessories and therefore Filemaker cant find the products. Single
>> word categories work just fine.
>>>>> My link is set up like this:
>>>>> [String_Concatenate: (var: 'Root_Path'),'category_listing.lasso?-
>> Session=',(var:'Site_Session_Name'),':',(Session_ID: -
>> Name=(var:'Site_Session_Name'))]&cat=[Value_ListItem: -encodeURL]
>>>>> This all worked flawless for years and now I can't figure out why
>> it's not working.
>>>> I don't use Filemaker, so I'm not exactly sure from your description
>> what is going on. However, %20 is the URL encoding for a space. The link
>> code you posted does mention URL encoding ([Value_ListItem: -
>> encodeURL]), and any link you go to in a modern browser would
>> automatically translate those spaces to %20 as well. If the problem is
>> with something you are passing to Filemaker, you may need to call
>> decode_url on that code? Of course, this may all just be ramblings of
>> someone not familiar with Filemaker.
>>>> Brad
>>>> #############################################################
>>>> 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]>
>>> #############################################################
>>> 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]>
>>>
>> --
>> #############################################################
>> 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]>
>
> #############################################################
> 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]>
>

--
#############################################################
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: Encoding Problem

Randy Zumwalde
In reply to this post by Randy Zumwalde
Solved!!

I added this code at the top of the category_listing.lasso page to
decode as Brad suggested.

     [var: 'category' = (decode_URL: (action_param: 'cat'))]

Then in my inline I changed 'category'=(Action_Param:'cat') to
'category'=(var:'category')

Thanks for the help.
I still don't understand why this needs to be done like this switching
from Lasso 8.5 to 8.6

Randy
On 10/23/12 1:01 PM, Randy Zumwalde wrote:

> The link calls category_listing.lasso which contains the inline to
> search the database
>
> [Inline: -Search, -Database=(Var:'Site_Base'), -Username='randal',
> -Password='xxxxx', -Table='products', 'category'=(Action_Param:'cat'),
> -SkipRecords=(Action_Param:'skip'), -MaxRecords='5']
>
> When the inline receives the action_param 'cat' and places the value
> into the inline search field 'category', the category field ends up
> containing the value Business%20Accessories instead of Business
> Accessories so no records are found.
>
> Randy
>
> On 10/23/12 12:12 PM, Brad Lindsay wrote:
>> On Oct 23, 2012, at 10:49 AM, Randy Zumwalde <[hidden email]>
>> wrote:
>>> I have upgraded our servers/software to Mac Mini Apple Servers with
>>> Lasso 8.6 and FileMaker Server 11
>>> We were using WebStar/Lasso 8.5/Filemaker Server Advanced 8
>>>
>>> For some reason my product category links which are pulled via a
>>> Filemaker value list are translating the space as %20.
>>> So my product category Business Accessories is being sent as
>>> Business%20Accessories and therefore Filemaker cant find the
>>> products. Single word categories work just fine.
>>>
>>> My link is set up like this:
>>> [String_Concatenate: (var:
>>> 'Root_Path'),'category_listing.lasso?-Session=',(var:'Site_Session_Name'),':',(Session_ID:
>>> -Name=(var:'Site_Session_Name'))]&cat=[Value_ListItem: -encodeURL]
>>>
>>> This all worked flawless for years and now I can't figure out why
>>> it's not working.
>> I don't use Filemaker, so I'm not exactly sure from your description
>> what is going on. However, %20 is the URL encoding for a space. The
>> link code you posted does mention URL encoding ([Value_ListItem:
>> -encodeURL]), and any link you go to in a modern browser would
>> automatically translate those spaces to %20 as well. If the problem
>> is with something you are passing to Filemaker, you may need to call
>> decode_url on that code? Of course, this may all just be ramblings of
>> someone not familiar with Filemaker.
>>
>> Brad
>> #############################################################
>> 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]>
>>
>

--
#############################################################
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]>