If SESSIONID is alphanumeric then the integration scripts will fail.
Example:
$sessionquery = 'SELECT x FROM y WHERE id={SESSIONID}';
needs to change to
$sessionquery = 'SELECT x FROM y WHERE id="{SESSIONID}"';
This should probably be the case for any variable not explicitly defined as a numeric variable. (ie, anything that could be alphanumeric should be double-quoted). Thanks, Nigel
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on Doc change for {SESSIONID}
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
If SESSIONID is alphanumeric then the integration scripts will fail.
Example:
$sessionquery = 'SELECT x FROM y WHERE id={SESSIONID}';
needs to change to
$sessionquery = 'SELECT x FROM y WHERE id="{SESSIONID}"';
This should probably be the case for any variable not explicitly defined as a numeric variable. (ie, anything that could be alphanumeric should be double-quoted).
Thanks,
Nigel