Public bug reported:
A statement like the following inserted into an aiki form field of type
"autofield" will successfully insert a value into a table:
sender_email|SystemGOD:sender email:value:(sql((select email from
aiki_users where userid = (!(3)!)||[-[email]-]))sql)
However, if that same logic is applied to an aiki form "autofield" that
is sending data to a 2nd table, the sql fails to evaluate & reports
errors when the form is submitted:
owner_id->ppl_logs|SystemGOD:owner id:value:(sql((select * from
aiki_users where userid = (!(3)!)||[-[owner_id]-]))sql)
** Affects: aikiframework
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Aiki
Framework Admins, which is subscribed to aikiframework.
https://bugs.launchpad.net/bugs/726367
Title:
sql selects don't evaluate in an aiki form field that is submitting a
value into an alternate table
Status in Aiki Framework:
New
Bug description:
A statement like the following inserted into an aiki form field of
type "autofield" will successfully insert a value into a table:
sender_email|SystemGOD:sender email:value:(sql((select email from
aiki_users where userid = (!(3)!)||[-[email]-]))sql)
However, if that same logic is applied to an aiki form "autofield"
that is sending data to a 2nd table, the sql fails to evaluate &
reports errors when the form is submitted:
owner_id->ppl_logs|SystemGOD:owner id:value:(sql((select * from
aiki_users where userid = (!(3)!)||[-[owner_id]-]))sql)
_______________________________________________
Mailing list: https://launchpad.net/~aikiframework.admins
Post to : [email protected]
Unsubscribe : https://launchpad.net/~aikiframework.admins
More help : https://help.launchpad.net/ListHelp
