[ic] log_transaction question
DB
DB at M-and-D.com
Thu Oct 7 16:52:12 UTC 2010
> Sorry, I really haven't been following this close, but I see the following
> in my log_transaction:
>
>
> [if value mv_payment_mode eq purchase_order]
> set credit_limit: [seti credit_limit][data
> table=userdb
> col=credit_limit
> key="[data session username]"
> value="-[scratch total_cost]"
> increment=1
> ][/seti]
> [/if]
>
> We implement the purchase order option in IC along with credit limits - what
> are you trying to do?
>
> Steve
I'm still fighting with this seemingly simple issue. My goal is to set
the database field transactions.paid to a value of 1 anytime an order is
placed by purchase order.
Ive tried both
paid: [if value mv_payment eq 'purchase_order']1[/if]
and
paid: [if value mv_payment_mode eq purchase_order]1[/if]
as suggested by others but still no luck.
Now that I think about it, I'd like to have this field set to 1 for any
payment method other than credit card. Would this have any hope of working:
paid: [if value mv_payment !=~ /credit.*card/i]1[/if]
More information about the interchange-users
mailing list