>So, are you trying to pass a company name through a URL? Seems to me that
would be problematic.
Yes, that's what I'm trying and I was hoping there is a easy fix.
Thank you for your help! I think I will stop here for now.
On Wednesday, January 20, 2021 at 3:52:04 PM UTC-6 Jim S wrote:
> So, are you trying to pass a company name through a URL? Seems to me that
> would be problematic.
>
> If that is what you're doing maybe you need to look at urllib
> unquote_plus. I use that in some cases to build valid URLs where the text
> can be unpredictable.
>
> Is there anything else you could pass other than a name to uniquely
> identify the company in your url?
>
> Or, maybe I'm not following what you're trying to do here.
>
> -Jim
>
>
> On Wed, Jan 20, 2021 at 3:36 PM Omi Chiba <ochi...@gmail.com> wrote:
>
>> ok, so this is four parameters I'm passing..
>>
>> J2831
>>
>> AL04
>>
>> 36105
>>
>> HYUNDAI MOTOR MANUFACTURI
>>
>> then list.xxx or XML(list.xxx) actually shows the same result. It
>> replaced blank with "_"... that's why I failed to get the data from the
>> database because the original value doesn't have "_". I also tried the with
>> "&" in the company name and it failed to display the page because of "&"
>>
>> J2831
>>
>> AL04
>>
>> 36105
>>
>> HYUNDAI_MOTOR_MANUFACTURI
>>
>>
>>
>> On Wednesday, January 20, 2021 at 2:35:56 PM UTC-6 Jim S wrote:
>>
>>> So, if you would do a for look around 'lists' and print out the field
>>> values, what would that look like? Also, is there a difference if you also
>>> print it out with the XML function wrapped around it?
>>>
>>> On Wed, Jan 20, 2021 at 2:03 PM Omi Chiba <ochi...@gmail.com> wrote:
>>>
>>>> here's the controller for enduser_index view. It's like I have this
>>>> index view to list and lick "View" button to pass the variable and go to
>>>> enduser_view page.
>>>>
>>>> def enduser_index():
>>>> response.title = 'List'
>>>> response.subtitle = 'End User Code'
>>>>
>>>> form=SQLFORM.factory(Field('search'))
>>>> form.custom.widget.search['_class'] = 'input-medium search-query'
>>>> form.custom.submit['_value'] = 'Search'
>>>> form.custom.submit['_class'] = 'btn'
>>>>
>>>> if form.accepts(request):
>>>> key=form.vars.search.upper() + "%"
>>>> query = (db.EDXUSF00.USDIID.like(key)) |
>>>> (db.EDXUSF00.USDICD.like(key)) | (db.EDXUSF00.USTSKJ.like(key))
>>>> else:
>>>> query = db.EDXUSF00.USDIID!=""
>>>>
>>>> # Paging plugin
>>>> paginate_selector = PaginateSelector(anchor='main')
>>>> paginator = Paginator(paginate=paginate_selector.paginate,
>>>> extra_vars={'v':1}, anchor='main',
>>>> renderstyle=True)
>>>> paginator.records = db(query).count()
>>>> paginate_info = PaginateInfo(paginator.page, paginator.paginate,
>>>> paginator.records)
>>>> # End Paging plugin...
>>>>
>>>>
>>>> lists=db(query).select(db.EDXUSF00.USDIID,db.EDXUSF00.USDICD,db.EDXUSF00.USYUB5,db.EDXUSF00.USTSKJ,db.EDXUSF00.USUSCD,orderby=[db.EDXUSF00.USDIID,db.EDXUSF00.USDICD,db.EDXUSF00.USYUB5,db.EDXUSF00.USTSKJ],limitby=paginator.limitby())
>>>> return
>>>> dict(form=form,lists=lists,paginator=paginator,paginate_selector=paginate_selector,
>>>>
>>>> paginate_info=paginate_info)
>>>>
>>>>
>>>>
>>>> On Wednesday, January 20, 2021 at 2:01:07 PM UTC-6 Jim S wrote:
>>>>
>>>>> I thought you were trying to get it working in this html tag:
>>>>>
>>>>> <td class="row_buttons"><a
>>>>> href="{{=URL('customer_view',args=[list.TKDIID,list.TKDICD])}}"
>>>>> class="btn"><i class="icon-search"></i> View<
>>>>>
>>>>> I don't see the 'list' variable in the controller...
>>>>>
>>>>> Where is that coming from?
>>>>>
>>>>> -Jim
>>>>>
>>>>> On Wed, Jan 20, 2021 at 1:49 PM Omi Chiba <ochi...@gmail.com> wrote:
>>>>>
>>>>>> I'm not sure how to check...
>>>>>>
>>>>>> This is my controller for view page
>>>>>>
>>>>>> def enduser_view():
>>>>>> response.title = 'View'
>>>>>> response.subtitle = 'End User Code'
>>>>>>
>>>>>> request.args(0) or redirect (URL('enduser_index'))
>>>>>> record = db.EDXUSF00(db.EDXUSF00.USDIID==request.args(0) and
>>>>>> db.EDXUSF00.USDICD==request.args(1) and
>>>>>> db.EDXUSF00.USYUB5==request.args(2)
>>>>>> and db.EDXUSF00.USTSKJ==request.args(3))
>>>>>>
>>>>>> if record != None:
>>>>>> form = SQLFORM(db.EDXUSF00,record, readonly=True)
>>>>>> else:
>>>>>> redirect(URL('enduser_index'))
>>>>>>
>>>>>> return dict(form=form)
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Wednesday, January 20, 2021 at 11:47:17 AM UTC-6 Jim S wrote:
>>>>>>
>>>>>>> I don't think it will help to change the controller side.
>>>>>>>
>>>>>>> In the controller can you print out the values and also print out
>>>>>>> the XML(value) and see what the difference is?
>>>>>>>
>>>>>>> -Jim
>>>>>>>
>>>>>>> On Wed, Jan 20, 2021 at 10:36 AM Omi Chiba <ochi...@gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> I added XML. It doesn't show the error but cannot get the value and
>>>>>>>> shows the records... should we changed the controller side too?
>>>>>>>>
>>>>>>>> View
>>>>>>>> <td class="row_buttons"><a
>>>>>>>> href="{{=URL('enduser_view',args=[XML(list.USDIID),XML(list.USDICD),XML(list.USYUB5),XML(list.USTSKJ)])}}"
>>>>>>>>
>>>>>>>> class="btn"><i class="icon-search"></i> View</a>
>>>>>>>>
>>>>>>>> Controller
>>>>>>>> record = db.EDXUSF00(db.EDXUSF00.USDIID==request.args(0) and
>>>>>>>> db.EDXUSF00.USDICD==request.args(1) and
>>>>>>>> db.EDXUSF00.USYUB5==request.args(2)
>>>>>>>> and db.EDXUSF00.USTSKJ==request.args(3))
>>>>>>>>
>>>>>>>> On Monday, January 18, 2021 at 4:16:04 PM UTC-6 Omi Chiba wrote:
>>>>>>>>
>>>>>>>>> JIm,
>>>>>>>>>
>>>>>>>>> Thank you for your reply! I will test it later this week and let
>>>>>>>>> you guys know.
>>>>>>>>>
>>>>>>>>> On Monday, January 18, 2021 at 12:58:43 PM UTC-6 Jim S wrote:
>>>>>>>>>
>>>>>>>>>> Can you wrap it in an XML function?
>>>>>>>>>>
>>>>>>>>>> <td class="row_buttons"><a href="{{=URL('customer_view',args=
>>>>>>>>>> [XML(list.TKDIID),XML(list.TKDICD)])}}" class="btn"><i
>>>>>>>>>> class="icon-search"></i> View</a>
>>>>>>>>>>
>>>>>>>>>> On Wednesday, January 13, 2021 at 4:03:54 PM UTC-6 Omi Chiba
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> In another word, how I can encode and decode the value including
>>>>>>>>>>> special characters such as "&".
>>>>>>>>>>>
>>>>>>>>>>> https://help.marklogic.com/Knowledgebase/Article/View/using-url-encoding-to-handle-special-characters-in-a-document-uri
>>>>>>>>>>>
>>>>>>>>>>> On Wednesday, January 13, 2021 at 8:24:22 AM UTC-6 Omi Chiba
>>>>>>>>>>> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Hi, the following works fine when there is no symbol such as
>>>>>>>>>>>> "&" in the field value. How can we pass and receive the parameters
>>>>>>>>>>>> which
>>>>>>>>>>>> contains "&"..etc.?
>>>>>>>>>>>>
>>>>>>>>>>>> View - customer_index
>>>>>>>>>>>>
>>>>>>>>>>>> <td class="row_buttons"><a
>>>>>>>>>>>> href="{{=URL('customer_view',args=
>>>>>>>>>>>> [list.TKDIID,list.TKDICD])}}" class="btn"><i
>>>>>>>>>>>> class="icon-search"></i> View</a>
>>>>>>>>>>>>
>>>>>>>>>>>> Controller - default.py
>>>>>>>>>>>>
>>>>>>>>>>>> def customer_index():
>>>>>>>>>>>> response.title = 'List'
>>>>>>>>>>>> response.subtitle = 'Customer Code'
>>>>>>>>>>>>
>>>>>>>>>>>> form=SQLFORM.factory(Field('search'))
>>>>>>>>>>>> form.custom.widget.search['_class'] = 'input-medium
>>>>>>>>>>>> search-query'
>>>>>>>>>>>> form.custom.submit['_value'] = 'Search'
>>>>>>>>>>>> form.custom.submit['_class'] = 'btn'
>>>>>>>>>>>>
>>>>>>>>>>>> if form.accepts(request):
>>>>>>>>>>>> key=form.vars.search.upper() + "%"
>>>>>>>>>>>> query = (db.EDXTKF00.TKDIID.like(key)) |
>>>>>>>>>>>> (db.EDXTKF00.TKDICD.like(key))
>>>>>>>>>>>> else:
>>>>>>>>>>>> query = db.EDXTKF00.TKDIID!=""
>>>>>>>>>>>>
>>>>>>>>>>>> # Paging plugin
>>>>>>>>>>>> paginate_selector = PaginateSelector(anchor='main')
>>>>>>>>>>>> paginator = Paginator(paginate=paginate_selector.paginate,
>>>>>>>>>>>> extra_vars={'v':1}, anchor='main',
>>>>>>>>>>>> renderstyle=True)
>>>>>>>>>>>> paginator.records = db(query).count()
>>>>>>>>>>>> paginate_info = PaginateInfo(paginator.page,
>>>>>>>>>>>> paginator.paginate, paginator.records)
>>>>>>>>>>>> # End Paging plugin...
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> lists=db(query).select(db.EDXTKF00.TKDIID,db.EDXTKF00.TKDICD,db.EDXTKF00.TKTKSC,db.EDXTKF00.TKTKCD,db.EDXTKF00.TKDMCD,orderby=[db.EDXTKF00.TKDIID,db.EDXTKF00.TKDICD],limitby=paginator.limitby())
>>>>>>>>>>>> return
>>>>>>>>>>>> dict(form=form,lists=lists,paginator=paginator,paginate_selector=paginate_selector,
>>>>>>>>>>>>
>>>>>>>>>>>> paginate_info=paginate_info)
>>>>>>>>>>>>
>>>>>>>>>>>> def customer_view():
>>>>>>>>>>>> response.title = 'View'
>>>>>>>>>>>> response.subtitle = 'Customer Code'
>>>>>>>>>>>>
>>>>>>>>>>>> request.args(0) or redirect (URL('customer_index'))
>>>>>>>>>>>> record = db.EDXTKF00(db.EDXTKF00.TKDIID==request.args(0)
>>>>>>>>>>>> and db.EDXTKF00.TKDICD==request.args(1))
>>>>>>>>>>>>
>>>>>>>>>>>> if record != None:
>>>>>>>>>>>> form = SQLFORM(db.EDXTKF00,record, readonly=True)
>>>>>>>>>>>> else:
>>>>>>>>>>>> redirect(URL('customer_index'))
>>>>>>>>>>>>
>>>>>>>>>>>> return dict(form=form)
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>> Resources:
>>>>>>>> - http://web2py.com
>>>>>>>> - http://web2py.com/book (Documentation)
>>>>>>>> - http://github.com/web2py/web2py (Source code)
>>>>>>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>>>>>>> ---
>>>>>>>> You received this message because you are subscribed to a topic in
>>>>>>>> the Google Groups "web2py-users" group.
>>>>>>>> To unsubscribe from this topic, visit
>>>>>>>> https://groups.google.com/d/topic/web2py/O1Mv_tbFbcw/unsubscribe.
>>>>>>>> To unsubscribe from this group and all its topics, send an email to
>>>>>>>> web2py+un...@googlegroups.com.
>>>>>>>> To view this discussion on the web visit
>>>>>>>> https://groups.google.com/d/msgid/web2py/93e8a999-e0be-4e33-bc91-43e5451edee7n%40googlegroups.com
>>>>>>>>
>>>>>>>> <https://groups.google.com/d/msgid/web2py/93e8a999-e0be-4e33-bc91-43e5451edee7n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>>>>>> .
>>>>>>>>
>>>>>>> --
>>>>>> Resources:
>>>>>> - http://web2py.com
>>>>>> - http://web2py.com/book (Documentation)
>>>>>> - http://github.com/web2py/web2py (Source code)
>>>>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>>>>> ---
>>>>>> You received this message because you are subscribed to a topic in
>>>>>> the Google Groups "web2py-users" group.
>>>>>> To unsubscribe from this topic, visit
>>>>>> https://groups.google.com/d/topic/web2py/O1Mv_tbFbcw/unsubscribe.
>>>>>> To unsubscribe from this group and all its topics, send an email to
>>>>>> web2py+un...@googlegroups.com.
>>>>>>
>>>>> To view this discussion on the web visit
>>>>>> https://groups.google.com/d/msgid/web2py/0679fc45-f9b0-4296-9724-deecf8a2014en%40googlegroups.com
>>>>>>
>>>>>> <https://groups.google.com/d/msgid/web2py/0679fc45-f9b0-4296-9724-deecf8a2014en%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>>>> .
>>>>>>
>>>>> --
>>>> Resources:
>>>> - http://web2py.com
>>>> - http://web2py.com/book (Documentation)
>>>> - http://github.com/web2py/web2py (Source code)
>>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>>> ---
>>>> You received this message because you are subscribed to a topic in the
>>>> Google Groups "web2py-users" group.
>>>> To unsubscribe from this topic, visit
>>>> https://groups.google.com/d/topic/web2py/O1Mv_tbFbcw/unsubscribe.
>>>> To unsubscribe from this group and all its topics, send an email to
>>>> web2py+un...@googlegroups.com.
>>>>
>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/web2py/15f47f16-02da-446f-ab8f-879bfe017ef2n%40googlegroups.com
>>>>
>>>> <https://groups.google.com/d/msgid/web2py/15f47f16-02da-446f-ab8f-879bfe017ef2n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/web2py/O1Mv_tbFbcw/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> web2py+un...@googlegroups.com.
>>
> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/web2py/3dba37c5-c60f-4aaa-9c61-db28862c5859n%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/web2py/3dba37c5-c60f-4aaa-9c61-db28862c5859n%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/de49818a-131f-4259-a1c3-ffb0df797535n%40googlegroups.com.
