[ic] 4.8 -> 5.4 Upgrade Query Question

["Steve" <suppressed>]

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

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users