Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
When was this scratch tape put in?
looks like it only shows the current month, is there a way to change this?- Spanjis
- Post #4
- Forum: Data Recovery
-
When was this scratch tape put in?
tried with q actlog, but it shows only this month.- Spanjis
- Post #2
- Forum: Data Recovery
-
When was this scratch tape put in?
Is there a way to check when a scratch tape was put in? The database does not register scratch tapes(until they are used), the only way i can see them is when i query libvol. Thanks!- Spanjis
- Thread
- Replies: 5
- Forum: Data Recovery
-
How to find tapes that has been set offline
Thanks guys, worked like a charm :)- Spanjis
- Post #4
- Forum: Data Recovery
-
How to find tapes that has been set offline
I just ran: upd vol * acc=Off lo='off' wherestg=tapecopy whereacc=readw,reado wherest=fill,ful i forgot to copy the volume name, how can i find them again? tried with something like query volume stg=tapecopy access=off location=off, but didnt work. Any tips? Thanks!- Spanjis
- Thread
- Replies: 3
- Forum: Data Recovery
-
Need help with search and replace in MYSQL
Soz, I had convert wrong, it should be this: convert(substring(Hoved, instr(Hoved, 'width') + 7, 3), unsigned) looks like it works know, thanks :D -
Need help with search and replace in MYSQL
thanks for quick reply, doesnt look like it's working, getting this error know: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int , substring(Hoved,instr(Hoved,'width')+7,3))>200' at line 6 -
Need help with search and replace in MYSQL
I want to search through some text and find where width is bigger than 200 and replace it with 300. I'm using MySQL 4.1.11. This is what i got so far. update `Artikkel` set `Hoved` = replace(`Hoved`, regexp 'width="(.*)"', 'width="300"') where convert(int, substring(`Hoved`, instr(`Hoved`...
