Thread

Hello.

I try to to find a way to fetch the variables (like payment_gross, txn_id etc.) from the “paypal_details” field in exp_simple_commerce_purchases.

When I run a Query like this:

{exp:query sql="SELECT paypal_details FROM exp_simple_commerce_purchases WHERE member_id = '1' "}

{paypal_details}

{/exp:query}

I get all variables together, but is there any way to select which variables that will be shown?

Thanks a lot!

I want to do the same thing… recording a custom field into os0 and on0 on the paypal url string. Would be nice to have a way to access the data in the serialized array in the payment_details field.

bumping… still haven’t figured this out… anyone?

thanks