|
| |
|
|
rickyzicky
Posts: 208
From: roch, ny
Status: offline
 |
Updating one field in all records - 5/1/2002 16:12:04
If I want to make all the "expiration date" filed show the same date in all 300 records, what is the best way.
I know I can update all fields in one record, but I need to do vice versa.
Thanks
|
|
|
|
adamhum
Posts: 28
From: Tucson, Az, USA
Status: offline
|
RE: Updating one field in all records - 5/1/2002 17:59:55
Are you trying ot insert a certain date into every record on your table? Will this be built into a web page or do you just want to update your database table?
Adam
| |
|
|
|
rickyzicky
Posts: 208
From: roch, ny
Status: offline
|
RE: Updating one field in all records - 5/1/2002 18:03:35
At the end of the year we want to change the date in all records for one field. I would like to do this via the website so I don't have to open the databse and do a find/replace thing. I am doing this for someone else otherwise find/replace works for me.
| |
|
|
|
Spooky
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Updating one field in all records - 5/2/2002 1:15:08
You would use an SQL string like so :
"UPDATE table set [date_field] = now()"
ALL date_field's will be modified to todays date. For a one off, I wouldnt do a web page, just modify the database.
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
|
|
rickyzicky
Posts: 208
From: roch, ny
Status: offline
|
RE: Updating one field in all records - 5/2/2002 1:17:23
Thanks again
| |
|
 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 
