Excel table can not delete

2004-10-29 Thread joachim . goerner
Hi all, this: -- use DBI; my $dbh=DBI-connect( DBI:ADO:driver=Microsoft Excel Driver(*.xls);READONLY=FALSE;. CREATE_DB=$Ziel;DBQ=$Ziel;,{RaiseError=1}); $dbh-do(DROP TABLE TAB\$); $dbh-disconnect(); -- makes the table TAB empty !

serial ports

2004-10-29 Thread Hon Shi
Anyone actually communicated with xp/2k serial ports? I see posts that treat the port as a file COM1 and some use a mod named Win32::SerialPort, which ppm can't find. How did you do it? Thanks __ Do you Yahoo!? Read only the mail you want -

Re: serial ports

2004-10-29 Thread $Bill Luebkert
Hon Shi wrote: Anyone actually communicated with xp/2k serial ports? I see posts that treat the port as a file COM1 and some use a mod named Win32::SerialPort, which ppm can't find. Try:http://www.bribes.org/perl/ppm/ -- ,-/- __ _ _ $Bill LuebkertMailto:[EMAIL

RE: FileTimeToDosDateTime

2004-10-29 Thread Ken Cornetet
Here's my code to convert from VT_FILETIME (the goofy 100ns since 1601 format) to epoch time (# seconds since 1/1/70) sub vtfiletime { my $vt = shift; $vt = substr($vt, 0, 11); # strip off anything past seconds $vt -= 11644473600; return $vt; }

[OT] Perl Automated Pasword Reset Systems

2004-10-29 Thread Anderson, Mark (Service Delivery)
Hi, this is a general enquiry rather than a technical question. Have any of you implemented any automated password reset systems using Perl? I am talking about something roughly equivalent to PasswordCourier (www.courion.com) or psynch (www.psynch.com). Kind regards, Mark Anderson The

RE: fork didn't work

2004-10-29 Thread Jutu Subramanian, Srinivasan (Cognizant)
Hai, The following code having, compiled in limit of 64 active threads. I need to modify the following code as not caring about the exit status of dead children with $SIG{CHLD}. However, do check the status of the dead children and log any that exited abnormally and I need to run more than

Date format patterns

2004-10-29 Thread Jim Hill
Hi all My perl script retrieves an application-specific date format string from the registry and I need to produce a date string in that format to search for log entries on a specified date. My script may be used internationally so I need to accommodate all possible date formats. A query on my

Re: Date format patterns

2004-10-29 Thread $Bill Luebkert
Jim Hill wrote: Hi all My perl script retrieves an application-specific date format string from the registry and I need to produce a date string in that format to search for log entries on a specified date. My script may be used internationally so I need to accommodate all possible date

RE: [Perl-unix-users] How can I redirect STDERR to a file?

2004-10-29 Thread Cai, Lixin \(L.\)
I am thinking I did not describe the problem clear, the following is my code -- test.pl ### #!/usr/bin/perl my $ldapsearch = /usr/bin/ldapsearch; my $command = $ldapsearch -x -LLL -h \cds2.ford.com\ -b \ou=People, o=Ford,c=US\ \uid=lcai3\ uid fordUNIXid;

Re: Date format patterns

2004-10-29 Thread Jim Hill
$Bill Luebkert in [EMAIL PROTECTED]: Jim Hill wrote: [my registry] returns dd/mm/ but it might be mm-dd-yy in the USA. Is there a reliable way to convert dd/mm/ strings into %d/%m/%Y strings? First use split, then you have it in a form to do the above. # put in tm

tar.tar

2004-10-29 Thread Hon Shi
10/29/2004 08:16 AM 8,660 Win32-Service-0.05-PPM58.tar.tar from http://www.bribes.org/perl/ppm/ Picked up this file and trying to install but none of my zip programs can unpack this. This is usually no problem. What tool is required to suck the stuff out?

Re: Date format patterns

2004-10-29 Thread $Bill Luebkert
Jim Hill wrote: I see where you're going, I think, but the problem is that I can't predict the date format which other users will retrieve from their registries. A lot of variations can be generated using different separators, eg dd-mm- and dd/mm/, and different orders, eg mm/dd/yy

Re: tar.tar

2004-10-29 Thread $Bill Luebkert
Hon Shi wrote: 10/29/2004 08:16 AM 8,660 Win32-Service-0.05-PPM58.tar.tar Use PPM and add the below link to your repositories. Or at least change the .tar.tar to .tar.gz when your download prompt asks for a save filename - then use Winzip. from http://www.bribes.org/perl/ppm/

Encrypt / Decrypt external file problem?

2004-10-29 Thread barons
I'm not sure why this is not working. I have a small script that I enter the username and password via the command prompt and it writes a dat file with the encrypted data. This works great. In my snippet below I read in the dat file, decript the username and password It does work fine and put it

serial port, very lost,

2004-10-29 Thread Hon Shi
We are trying to flip the bits on a 8 bit io card. It has a serial interface. The demo program sent along with it works fine by the needle heads will not send the source. Not one example! I love examples. This is the last board we purchase from them. Anyways. The spec says you write a

RE: [Perl-unix-users] How can I redirect STDERR to a file?

2004-10-29 Thread Aaron.Tesch
Perlfaq8 has the necessary details. http://aspn.activestate.com/ASPN/docs/ActivePerl/lib/Pod/perlfaq8.html#h ow_can_i_capture_stderr_from_an_external_command Aaron Tesch -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cai, Lixin (L.) Sent: Friday,

Re: Date format patterns

2004-10-29 Thread Jim Hill
$Bill Luebkert in [EMAIL PROTECTED]: Jim Hill wrote: [...] the problem is that I can't predict the date format which other users will retrieve from their registries. If you can't predict the date format, I don't see how you can convert it into a standard format. I've cracked it now,

Re: Date format patterns

2004-10-29 Thread Martin Leese
$Bill Luebkert [EMAIL PROTECTED] wrote: Jim Hill wrote: I see where you're going, I think, but the problem is that I can't predict the date format which other users will retrieve from their registries. A lot of variations can be generated using different separators, eg dd-mm- and dd/mm/,