Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
oman
Starting Member
2 Posts |
 Posted - 2008-06-09 : 12:29:08
|
| Hi everyone, ok so heres my problem. I'm currently writting some scrips to query an simple inventory database. heres what i'm trying to do.I have a .asp webpage that has a query on it that can dispaly everything in the inventory... old and new in a big html table. The idea is to not actualy delete anything because i would still like to have a record of it's existance but at the same time i dont want it to clutter my "current" inventory i guess it would call it.I added another column named deleted which is set to the Yes/No and TRUE/FALSE data types, i also put in a check box at the end of every row on the webpage, the idea here is that if a box is checked it will record that row's id via address bar/Get method and then when i hit submit it will run the update query for those rows checked i changed my inventory query so that if an item's deleted column is checked to TRUE then it will not be displayed, so showing only the non deleted items. UPDATE Licenses SET Licenses.deleted = TRUEWHERE Licenses.LicensesID=33; thats what i'm using to change it case by case basis, but what i would like to do is somthing like UPDATE Licenses SET Licenses.deleted = TRUEWHERE Licenses.LicensesID=33,34,67....so on LicensesID is just a auto incrememted field jsut to give a unique value to a license's row..does anyone know any tricks to accomplish what i'm trying to do? So far I havn't really found any satisfactory examples online. and i dont really want to completly change the structure of everything unless someone suggust somthing that is clearly a better way of doing thingsthanks,O |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
oman
Starting Member
2 Posts |
Posted - 2008-06-10 : 09:33:35
|
| Thanks alot I knew it was just somthing small like that that i was missing. Much appreciated |
 |
|
|
|
|
|
|
|
Multiple Row update