WildCard in an UPDATE Statement (Full Version)

All Forums >> [Web Development] >> ASP and Database

Message

---

hzarabet -> WildCard in an UPDATE Statement (5/20/2002 11:42:19) I have 10 feilds names Player1 through Player10. I would like to updates certain records in each of these fields. How can I get this to work?: fp_sQry="UPDATE SHL_DeLuxe SET Player%='::PlayerNew::' WHERE Player% = '::Player::' " Or can it work? Thanks all http://www.SigningsHotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

---

Spooky -> RE: WildCard in an UPDATE Statement (5/20/2002 22:24:51) No :( Youd really need to place each field in the SQL in the scenario you mention. Is there a rason other than saving time that you need this? §þððk¥ Database / DRW Q & A VP-ASP Shopping cart Spooky Login

---

hzarabet -> RE: WildCard in an UPDATE Statement (5/20/2002 22:31:52) OK...fair enough. The only way I know how to do it is with 10 separate UPDATE statements. Can I set 10 feilds with 1 statement... fp_sQry="UPDATE SHL_DeLuxe SET Player1='::PlayerNew::' WHERE Player% = '::Player::' ",SET Player2='::PlayerNew::' WHERE Player2 = '::Player::' ",SET Player3='::PlayerNew::' WHERE Player3 = '::Player::' ",...etc. http://www.SigningsHotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada Edited by - hzarabet on 05/20/2002 22:32:13

---

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.078125