forgot to mention db & ver of w2p:
MySQL + Version 2.0.9 (2012-09-13 23:51:30) stable
On Wednesday, September 26, 2012 8:09:50 PM UTC-4, Adi wrote:
>
>
> My apology if a description of the problem is not concise enough. I am
> updating record during onvalidaiton process, and this worked until Sep 17.
> Anything is possible, but I don't remember changing any code in this area.
>
> When I run the same SQL statement manually, or from a test procedure,
> everything works fine, but not when it's executed through SQLFORM
> onvalidation process. I tried adding db.commit() and that didn't help,
> either.
>
> Finally, I added following query at the end, and then record got updated:
> row = db(Order.id==session.order_id).select().first()
>
> My problem seems to be solved for now, but not sure what is a real cause
> of the problem, and if something needs correction in executesql?
>
> Simplified code:
>
> def db_encrypt_cc(tbl=None, cc=None, id=None):
> TOKEN='xxxxcd7358801fd5db53d74b03xxxx8b7b97a6c4'
> sql = "UPDATE %s SET CCnr_secure = AES_ENCRYPT('%s', '%s') WHERE
> id=%s" % (tbl, cc, TOKEN, session.order_id)
> # when executed, this statement is correct, but no value gets updated
> in the table: UPDATE order SET CCnr_secure =
> AES_ENCRYPT('4111111111111111', 'xxxxcd7358801fd5db53d74b03xxxx8b7b97a6c4')
> WHERE id=10423
> db.executesql(sql)
> # added code bellow and only then record got updated
> row = db(Order.id==session.order_id).select().first()
> return
>
> def cc_validation(form):
> form.vars.CCnr_secure = db_encrypt_cc("order", form.vars.CCnr)
> return
>
> def checkout_cc():
> form=SQLFORM(Order, record=record, fields=fields, keepvalues=True,showid
> =False,
> formstyle='divs', submit_button=T('Continue'))
>
> if form.process(keepvalues=True, onvalidation=cc_validation).accepted:
> response.flash = T('Payment Information accepted')
>
>
>
>
>
--
