Connector set variable.

[Richard Heesbeen]

Hi All,

I'm having a weird problem, trying to do an executenonquery on the sqlcommand, this is the
query that used to work:

SET @pos=0;UPDATE highscores SET weekpos=( SELECT @pos:=@pos+1) WHERE clubid={0} ORDER BY
weekscore DESC
but now i'm getting the error that @pos must be defined? Does anyone of you know whats
changed or what i'm doing wrong here?

Thnx,

Richard.