Recent content by evild

thanks, thats what i was looking for exactly! :) i think i need to bruch up on my sql. clearly i am rusty these days. doesn help not doing any sql in months...

i must be going mad today cause i cant even do the simplest of sql! i have a table called z308. This table looks like this: Z308_REC_KEY---------------------- CHAR(22) Z308_VERIFICATION--------------- VARCHAR2(20) Z308_VERIFICATION_TYPE------- CHAR(2) Z308_ID------------------------------...

What should I do at the weekends? No directories are created on saturday and sunday so on Monday I would have to check Fridays file.

anyone?

OK, I no practically nothing about scripting in Bash so I need some help. I want to place a job in the Cron that emails me if the following criteria are met: a file(s) of format z_u_* is found in directory X where X is the directory created the day previously [e.g. today directory would be...

I have another problem now... i have the renames working fine now but i am having problems with the error messages produced by the script. if i run: # Move all *.rpt files in ccc50/print to Today's save directory # Rename all *.rpt files in Todays save directory cd $tm foreach file (`ls...

I have figured out how to do it: by using two ':r' command to strip the filename to the desired effect.

Thanks fo rthe tip but i need futher help with my c shell: I have the following: # Move and Rename all unprocessed *.let.* files # in ccc50/print to Today's save directory # Rename to z_u_*.dayofweek cd $tm foreach file (*.let.*) mv $file...

I need to create a file rename script to run at a particular time. Part of the script must rename all files in the current directory that have *.let.* extension. For example I may have letter1.let.rdr form3.let.bib sqloutput.let.tlc and I want to rename them to: z_letter1.let.mon...

I dont beleive it! You were right. I had three commands between the last statement and the order by statement. These were commented out with a '--' on each line. I had to remove these three line completely before it would work. On the example I posted i removed this lines for readability...

There must be something in excel to cater for this type of distro. What about setting a password on the spreadsheet and setting permission within that. Actual file permissions themselves would be no good I think.

Is it possible to distribute an excel spreadsheet on the web [i.e. so people can download it] and set it such that they cannot edit the spreadsheet in any way. As with downloads, the file permissions would be accessable to whoever downloads it. I do not wish this. I want people to be able to...

I spool the output to a file. The query works and does return an un-ordered list. The error message appears at the bottom of my output file. The entire script is this: set echo off set pause off set heading on set pagesize 10000 set linesize 150...

I keep getting this statement at the end of my results of some sql. The query works fine until it tries to order the results. unknown command beginning "order by r..." - rest of line ignored. Currently I have: /* Column settings */ column clnum format a16 heading "Class...

I do not think it is a problem with the modem/router. I have two devices connected to it. My computer via patch cable and a wireless access point which in turn has a computer connected to this wirlessly. The computer that connects with an acces spoint has no problem downloading at all. My...