|
| |
|
|
hzarabet
Posts: 1536
From: New Milford CT USA
Status: offline
 |
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
Posts: 26597
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
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
Posts: 1536
From: New Milford CT USA
Status: offline
|
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
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
