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 <[email protected]> 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
>> [email protected].
>> 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 the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/0679fc45-f9b0-4296-9724-deecf8a2014en%40googlegroups.com.
