Is something wrong with my UPDATE statement?  If I use qty ='"&request.form

("myRepeater:ctrl" & trim(str(x)) & ":qty")&"' in an INSERT statment, the 

data is inserted into a new row.  But for some reason the UPDATE is not 

working.  If I say qty='3' then it works. 



Of course I have dimmed x as interger and use the x=1 and x +=1 in my for 

each statement.  AS I say, it does work in an INSERT.  Why not in the 

UPDATE? 







myCommand = NEW SQLCommand("Update ORDERS SET qty ='"&request.form

("myRepeater:ctrl" & trim(str(x)) & ":qty")&"' WHERE proddesc='pipe'", 

myConnection)

Hi..

	Not working means, is it giving error or Not updating... Please print to

sql statement and see, how it is builded.







-----Original Message-----

From: Jose Haymaker [mailto:ehaymaker@a...]

Sent: Friday, November 02, 2001 3:07 PM

To: ASP+

Subject: [aspx] Crazy UPDATE Statement





Is something wrong with my UPDATE statement?  If I use qty ='"&request.form

("myRepeater:ctrl" & trim(str(x)) & ":qty")&"' in an INSERT statment, the

data is inserted into a new row.  But for some reason the UPDATE is not

working.  If I say qty='3' then it works.



Of course I have dimmed x as interger and use the x=1 and x +=1 in my for

each statement.  AS I say, it does work in an INSERT.  Why not in the

UPDATE?







myCommand = NEW SQLCommand("Update ORDERS SET qty ='"&request.form

("myRepeater:ctrl" & trim(str(x)) & ":qty")&"' WHERE proddesc='pipe'",

myConnection)

---

VBug Winter Conference 2001



Open Forum:  Dan Appleman will be hosting an open

forum at The .NET Developer's Conference on

29th November 2001.  The session will give

developers the chance to discuss and question

Dan on his experience with the .NET environment.

Dan has been programming Visual Basic since the

alpha version 1.0.  And with over 10 years

Visual Basic experience is well qualified to

help you on your road to being a .NET Guru.



http://www.vbug.co.uk/redirect.asp?url=39&id=17



---

You are currently subscribed to

aspx as: skb@s...


$subst('Email.Unsub')