Re: Regular Expression

2005-11-28 Thread Chris Wagner
At 05:40 PM 11/28/2005 -0800, Wong, Danny H. wrote: >$String = 'Integration Test Lead: \ul\b0 \tab\tab\tab Kimberly >Kim\tab\tab\tab\tab\tab\tab \par'; > >How would I extract "Kimberly Kim" from the string using regular >expression. Is there a way using expression to skip "\[characters]" ( >like

RE: OLE problem with Outlook

2005-11-28 Thread Steven Manross
Shouldn't your Win32::OLE->Initialize(Win32::OLE::COINIT_OLEINITIALIZE); Be after the use Win32::OLE qw (.); As well, threading probably doesn't work all that well considering the single-threaded apartment model required for Outlook connections in Perl. But maybe someone can correct me if

RE: SQL problem

2005-11-28 Thread Steven Manross
Your prepare cannot be a multi-statement operation... And should be like so.. if (!($sth1 = $dbh->prepare('exec spsomeproc_or_sqlstatement ?,?,?'))) { print "Failed preparing sql call\n".$dbh->errstr."\n"; return 0; } Or in your example... $MinsUsedInRangeQuery1 = $DBH->prepare(

Regular Expression

2005-11-28 Thread Wong, Danny H.
Hi, I'm trying to figure out how to parse a string with special characters. $String = 'Integration Test Lead: \ul\b0 \tab\tab\tab Kimberly Kim\tab\tab\tab\tab\tab\tab \par'; How would I extract "Kimberly Kim" from the string using regular expression. Is there a way using expression to

XP shutting down perl

2005-11-28 Thread Ed Bachmann
Windows XP is intermittantly shutting down perl with this message, in a big, gray, official-looking Windows message box.: "Perl Command Line Interpreter has encountered a problem and needs to close," It reports that the problem is with 'mysql.dll'. The script is clean, I think. I'm running wi

problem with placeholders in SQL Server

2005-11-28 Thread John Deighan
The following script dies, with the error message "DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification (SQL-22018)(DBD: st_execute/SQLExecute err=-1)". Can anyone tell me why? The database handle is a good database handle. The fields Ex