Steve Harris schrieb:
> With beta1 I'm getting an error with the quickstart project against
> Oracle, which doesn't happen against sqllite.
>
> When accessing the root index page I get an error page caused by the
> following auth-related query:
>
> SELECT at_user_password, at_user_user_id, at_user_user_name,
> at_user_email_address, at_user_display_name, at_user_created \nFROM
> (SELECT at_user.password AS at_user_password, at_user.user_id AS
> at_user_user_id, at_user.user_name AS at_user_user_name,
> at_user.email_address AS at_user_email_address, at_user.display_name
> AS at_user_display_name, at_user.created AS at_user_created,
> ROW_NUMBER() OVER (ORDER BY at_user.rowid) AS ora_rn \nFROM at_user
> \nWHERE at_user.user_name = :user_name_1) \nWHERE ora_rn>0 AND
> ora_rn<=2' {'user_name_1': 250}
>
> Notice the numeric value being passed for user_name_1, which causes
> Oracle to balk.
>
> This was a pure quickstart project, with only the connection url
> changed in development.ini, plus the following modifications to
> auth.py to support Oracle:
> - removed the onupdate="CASCADE" args which would cause an error
> since Oracle doesn't support cascade updates
> - added Sequence() declarations in the pk's so primary key values
> can be autogenerated
>
> Where did the 250 value come from for the user_name?
Which TG version, which SQLAlchemy version?
Diez
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears Trunk" 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/turbogears-trunk?hl=en
-~----------~----~----~----~------~----~------~--~---
