The plot thickens. It looks like reference fields are stored as type
long internally and hit a repr at line 449 of sql.py in sql_represent
function. That is where it is converting 8 to 8L. I think line 448:
if fieldtype.find('.'): <----returns -1 which evaluates to True
should be
if '.' in fieldtype
On Oct 8, 9:10 am, "mr.freeze" <[email protected]> wrote:
> Python 2.5. I will email the application to you since the controller
> and model are fairly large.
>
> On Oct 8, 12:45 am, mdipierro <[email protected]> wrote:
>
> > and which python version.
>
> > usually>>> a=8L
> > >>> print str(a)
> > 8
> > >>> print repr(a)
>
> > 8L
>
> > but there is no repr in DAL anymore.
> > strange
>
> > On Oct 7, 11:45 pm, "mr.freeze" <[email protected]> wrote:
>
> > > I updated and get this MySQL error on an inner join:
> > > OperationalError: (1054, "Unknown column '8L' in 'where clause'")
>
> > > request.args(0) is 8. If I change request.args(0) to 1, the error
> > > changes to:
> > > OperationalError: (1054, "Unknown column '1L' in 'where clause'")
>
> > > ...and so on. Hope that makes sense. Using sqlite seems to work.
>
> > > On Oct 7, 10:10 pm, mdipierro <[email protected]> wrote:
>
> > > > There is lots of new stuff in trunk, in particular in sql.py.
>
> > > > Chris Clark added Ingres support and Denes added support for legacy
> > > > databases.
>
> > > > While we test the new stuff please check that nothing breaks your
> > > > code.
>
> > > > Massimo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
