[ic] 4.8 -> 5.4 Upgrade Query Question
Steve
icdev at mrlock.com
Wed Jan 11 12:41:34 EST 2006
Hello List,
The following code in 4.8 did not return a value, but in 5.4 it returns a 1
[if data session ohost eq 'my_local_ip']
[else]
[tmp tp1][calc][item-field times_viewed]+1[/calc][/tmp]
[query st=db sql="update products set times_viewed = '[scratch tp1]' where
sku = '[item-code]'"]
[/query]]
[/else]
[/if]
The above outputs a 1 - assume to confirm it was a success.
I can surround the query with an IF like below to suppress - is there some
other option?
[if data session ohost eq 'my_local_ip']
[else]
[tmp tp1][calc][item-field times_viewed]+1[/calc][/tmp]
[if [query st=db sql="update products set times_viewed = '[scratch tp1]'
where sku = '[item-code]'"]
[/query]]
[/if]
[/else]
[/if]
Thanks,
Steve
More information about the interchange-users
mailing list