Msg#: 4550385 posted 10:13 pm on Mar 13, 2013 (gmt 0)
Hi there Coopster,
Thanks for the reply, only just seen it & you're absolutely right. Works live server is setup differently to my local machine; so I've had to replicate their .conf file onto my local machine so that future developments are exactly as they would be on the live server.
I'm dreading it soon as we're moving to IIS, *hopefully* the IT guy assures me this will be a painless changeover!
Thanks for the link pointers too - they'll be useful to read.
[EDIT] I've changed the way I've done the query, as I wanted a var to return the amount of rows returned with each query; I'm just checking for a NULL now (this is vb.net so it's a bit more flexible with assigning null's *seems-like-it-anyway*) when I try to read a returned value, if it's not set then I just continue exit the while and go to the error handler.