Search results for query: *

Hello, I have a simple question. I run a perl script on a windows server which use blat to send an email with an attachement. But blat doesn't support to have a blank in the filename. My fiename is here: my $emaillink="./mail/$start_time.$_[0].msg"; The variable is for example equal to ...

Hello, I have a perl script that connect to a mysql database. Sometimes a query does not return any row. In the case if there is no rows, how can I print a message like "no row prensent" ? (how can I insert a if condition that check the rows returned in the while loop ?) Thanks...

Hello, I have a problem with Add_Delta_Days function of the Date::Calc module. The problem id the month returned doesn't have a 0 before the mon the number if it under 10: my $dateinputscript = 16032006 my $date = $dateinputscript; my $day = $date ; $day =~ s/(\d\d)(\d\d)\d\d(\d\d)/$1/; my...

Hello, I have a script that receive a date in parameter like these 02032006 (ddmmyyyy). my dateparmam = $_[0] How to convert this date in 060302 (yymmdd) ? Thanks

Hello, I found on the forum a lot of question about the find command to exclude some folders... but I could not resolve my problem: I start a script from / This script should delete all files older than XX in a particular folder recursively. There only one folder and all it subfolder which...

Hello, I'm currently writing my first script in ksh and I'm trying to use awk to manipulate some lines. I'm writing this script to extract Logical Volume informations on a AIX server to generate the creation script. All the steps are Ok without one. What I do : lsvg $vggroup | grep -iE...

Hello, I'm just going to DB2 and I'm looking for a similar tool like MS SQL Profiler. I would like on some databases in the same instance, trace every update,delete statement from the user X. Loging the trace in a table or a file ... It's quite esy on MS SQL and on Oracle, but I don't find...

Hello, I use the DBI module to connect to a mysql database. First I run a count on a table and I like, if the result of these is query is not 0, to run a delete on this table. I do this, but I have an error: Use of uninitialized value in numeric ne (!=) at mysql_epur_function.pl line 116 ...

Hello, I have a basic question regarding an insert. This is what I actually do on DTS package on ms sql 2000: " insert into logtable (Rows_before) (select count(no_empl) from assures) " I want to change to add a new "static" value like this but it doesn't works, any have an idea ??? "...

Hello, I've installed for my father company a Windows 2003 Server on a IBM Xseries server. This server is Domain Controler, DNS, File, Backup and print server. The problem is that I loosed the password of the only Domain administrator which is the administrator account. Others users of the...

Hello, Is there any way to attach a file to sendmail ?? What we use to do is to cat a file and then send it as the body but how to attach a file to the message ??? Many thanks (echo "SUBJECT :Error in DB $db (`basename $0`) from `date +'%d-%m-%y'` \n" cat $CURRLOGFILEechange)|...

Hello, I have a perl script that check some data in a mysql database. After that I run the mysql dump like that: exec( "$dumper -v -$dbexp > $dumpfile" ) or die "Backup Failed ... exiting"; How can I check the return code of this command ? Something like in unix scripts ? Thnaks for your help ?

Hello, Does somebody have a perl script to dump some or all databases on a local server (win32) ? I've done with msdos bat, but not so easy and flexible.. Thanks

Hello, This is my first script in perl. I need some help to create a logfile of some lines executed. FOr this I do: #!C:/Perl/bin/perl.exe -w #********************************************************* # Fonction: Nettoyage de logs * #...

Hello, This is my first script in Perl. I have to clear a folder on Windows 2003 server for files (logfiles) older than 14 days. The remove could be based on the system timestamp of the file of on the filename because the filename like: DailyMpgateway.log.2005-09-15 For that I do this little...

Hello, I have a script in ksh which will check the difference within two or more files in a different directory. How can I add at the beginig of this function or maybe earlier, the possibility to check if they are multiple files in the same directory and if yes, make a diff between those files...

Hi, I create a trigger for an builtin application. The problem is that the application is maintaining cache from the frontend and the database. So after my trigger is completed I have to run a windows command line to clear the cache. Does anyone how to run a command line in t-sql script on...

Hello, I have a problem on my Windows 2003 STD server with MS SQL 2000 SP3 called "servicedesk". I could not connect to any database by using isql.exe. When I run isql, the dox box don't give me any error messages. But if use isql from another server to connect to this server, it works fine...

Hello, I'have problem to write a sql query on my MSSQL Database. I have a field which contain date and time values in the unix format (seconds since 1/1/1970). I can convert the values without problem but I have a problem using GETDATE in the where clause. I like to add a where clause to...

Hello, I'have problem to write a sql query on my MSSQL Database. I have a field which contain date and time values in the unix format (seconds since 1/1/1970). I can convert the values without problem but I have a problem using GETDATE in the where clause. I like to add a where clause to...