Recent content by Spanjis

looks like it only shows the current month, is there a way to change this?

tried with q actlog, but it shows only this month.

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!

Thanks guys, worked like a charm :)

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!

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

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

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`...