ODBC Error 80040e10 - can’t find the prob

Post Reply

Page <12

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
MorningZ Members Profile Find Members Posts Senior Member Joined: 06 May 2002 Location: United States Status: Offline Points: 1793	Post Options Post Reply Quote MorningZ Report Post Thanks(0) Quote Reply Posted: 26 February 2003 at 2:48pm
	i wouldnt suggest breaking out of the string to do "MSG_READ_COUNT", its very obvious by the SQL statement that all it is supposed to do is increment the database column "MSG_READ_COUNT" by 1, so there is no need to dynamically set that value in ASP, the only thing needed to be fed in is the identifier of the message
	Contribute to the working anarchy we fondly call the Internet

Gary Members Profile Find Members Posts Senior Member Joined: 20 March 2002 Location: United Kingdom Status: Offline Points: 326	Post Options Post Reply Quote Gary Report Post Thanks(0) Quote Reply Posted: 27 February 2003 at 4:04am
	It depends whether MSG_READ_COUNT is a column within the db table or an asp variable. I suppose a little more info (ie db table structure) from ladyborg would help sort this one out.

MorningZ Members Profile Find Members Posts Senior Member Joined: 06 May 2002 Location: United States Status: Offline Points: 1793	Post Options Post Reply Quote MorningZ Report Post Thanks(0) Quote Reply Posted: 27 February 2003 at 8:31am
	ummm, i am not trying to cause trouble or nothing, but notice the SQL statement.. cmdMsg.CommandText = "UPDATE MESSAGES SET MSG_READ_COUNT = MSG_READ_COUNT + 1 WHERE MSG_ID = " & varID notice the part in bold.. its a column in the database
	Contribute to the working anarchy we fondly call the Internet

Gary Members Profile Find Members Posts Senior Member Joined: 20 March 2002 Location: United Kingdom Status: Offline Points: 326	Post Options Post Reply Quote Gary Report Post Thanks(0) Quote Reply Posted: 27 February 2003 at 8:34am
	Ok, ok, I give in. Except that maybe, just maybe, she created an asp variable with the same name as the column name. (but I doubt it very much).

ladyborg Members Profile Find Members Posts Newbie Joined: 26 February 2003 Location: United States Status: Offline Points: 6	Post Options Post Reply Quote ladyborg Report Post Thanks(0) Quote Reply Posted: 28 February 2003 at 10:50am
	Nope, there's no variable with same name as column name.

Post Reply	Page <12

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.