Shouldn't this
Code:
 

$sql = "SELECT workst.wSid FROM workst WHERE workst.pcName = '@wksta'"

be this ?
Code:
 

$sql = "SELECT workst.wSid FROM workst WHERE workst.pcName = "+@wksta

Or does it need to be quoted ?

Code:
 

$sql = "SELECT workst.wSid FROM workst WHERE workst.pcName = "+CHR(34)+@wksta+CHR(34)



Edited by Stanley (2005-02-23 10:48 PM)
_________________________
Taxation WITH representation isn't so hot, either!