Updating one field in all records (Full Version)

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

Message

---

rickyzicky -> 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 -> 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 -> 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 -> 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 -> RE: Updating one field in all records (5/2/2002 1:17:23) Thanks again

---

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.0625