RE: Re-open a ticket that is closed using SQL

2002-03-06 Thread Jamadagni, Rajendra
You should have flag on the ticket saying that ticket is closed, if you want to reopen, a simple update would do the trick. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here i

Re-open a ticket that is closed using SQL

2002-03-06 Thread Nguyen, David M
I am desinging a web base for user to open/update/close tickets using oracle8i. My question is how do I setup to let user re-open a close ticket for updating. I use SQL command "delete" to close ticket so the ticket could not be re-open for updating. Please advise. Thanks, David -- Please see