Thanks Massimo for shining light on the situation. After your reply i went
ahead and tried b = int(a) and received an error. TypeError: int() argument
must be a string or a number, not \'list\'\n'
So after that I started fresh with a new database since the previous
database had imported data. I only inserted two records via appadmin ran
through everything again and im still getting the same issue with the ids
turning into a list. The database is MySQL hosted via PA and im running
web2py 2.8.2. Table definition is below as well. When I just view
a=request.args(0) by itself its not concatenating the ids into a list its
displaying the id as expected onclick. I test it with sqlite as well and
same issue.
db.define_table('Company',
Field('Name', 'text', requires=IS_NOT_EMPTY()),
Field('Address', 'text'),
Field('Address2', 'text',),
Field('City', 'text'),
Field('State', 'text'),
Field('Zip', 'integer'),
Field('Email', 'text'),
Field('Website', 'text'),
Field('CouncilMember', 'boolean', default=False),
Field('Contact', 'text'),
Field('Phone', 'text'),
Field('Fax', 'text'),
auth.signature)
On Friday, May 16, 2014 10:09:04 PM UTC-5, Massimo Di Pierro wrote:
>
> I do not think the issue with your code. The issue with corrupted data in
> database. You seem to have an integer that contains list data. Perhaps one
> of your fields was a "list:integer" or "list:reference" type and then you
> changed it to "integer" or "reference" type. You ended up with corrupted
> data in there. A "normal" database like postgresql would have warned you of
> something like this and prevent such migration. I assume you are using
> sqlite which does allow inconsistent data types. Try delete (or move) your
> database and see if you can reproduce the problem.
>
> On Friday, 16 May 2014 16:27:20 UTC-5, LaDarrius Stewart wrote:
>>
>> I deleted previous post stating it was working it's not im tired...
>>
>> On Friday, May 16, 2014 3:28:49 PM UTC-5, LaDarrius Stewart wrote:
>>>
>>> Omitted quite a bit Anthony but I feel I included the valuable
>>> information. Considering minus the record value of the SQLFORM the
>>> functionality works as intended.
>>>
>>
--
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].
For more options, visit https://groups.google.com/d/optout.
