RE: RE help

2006-05-05 Thread Hsu, David
Daniel, I was able to utilize the suggestions from the others. I will also take a look at XML::Simple. Thanks, David From: Daniel McBrearty [mailto:[EMAIL PROTECTED] Sent: Thursday, May 04, 2006 4:33 PM To: Hsu, David Cc: perl-win32-users@listserv.activestate.com Subject

RE help

2006-05-04 Thread Hsu, David
Hi, I am trying to parse this string and not able to get the results that I need. Can someone please help. Thanks in advance. -David I am trying this: $string = 'NameFNJohn/FN LNSmith/LN/Name, NameFNSusan/FNLNMiers/LN/Name JobTitlePresident/JobTitle' $string =~

RE: remote ODBC problem

2006-01-10 Thread Hsu, David
I do have the file shared and every included Everyone in the permissions, but still did not connect to the DB. David -Original Message- From: Luke Bakken [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 1:57 PM To: Hsu, David Cc: perl-win32-users@listserv.activestate.com Subject

RE: remote ODBC problem

2006-01-10 Thread Hsu, David
data. at c:\inetpub\wwwroot\test\iqafdbtest.pl line 62. -Original Message- From: Luke Bakken [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 2:23 PM To: Hsu, David Subject: Re: remote ODBC problem Hrm. About the only other suggestion I have is about the way you are mapping

RE: remote ODBC problem

2006-01-09 Thread Hsu, David
Yes. It's no problem if the Access DB is on the server itself and I create an ODBC connection to it. David -Original Message- From: Ken Barker [mailto:[EMAIL PROTECTED] Sent: Friday, January 06, 2006 6:06 PM To: Hsu, David; perl-win32-users@listserv.ActiveState.com Subject: Re

remote ODBC problem

2006-01-06 Thread Hsu, David
Hi all, Has anyone else run into this problem and have found a solution? I am making an ODBC connection to a remote MS Access DB from my web server. When my Perl script runs, it cannot open the data source. I tested the connection using MS Query, and it is fine. Why can't Perl access the

RE: escaping characters

2005-10-12 Thread Hsu, David
the attempts that I have tried and the results. Strangely, by using the \t the 'tag' string showed, but I'm still at a loss on the syntax to just show 'tag'. Thanks -Original Message- From: $Bill Luebkert [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 11, 2005 9:32 PM To: Hsu, David Cc

RE: escaping characters

2005-10-12 Thread Hsu, David
') AND ((Measurements.msmTag)='lt;tag') AND ((Targets.TargetID)=187) AND ((ParameterValues.ParameterID)=31)); -Original Message- From: $Bill Luebkert [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 11, 2005 9:32 PM To: Hsu, David Cc: perl-win32-users@listserv.ActiveState.com Subject: Re: escaping

escaping characters

2005-10-11 Thread Hsu, David
Hi all, I'm having trouble formatting a SQL statement. Here's what I have: $SQL = ... ((Measurements.msmTag)=\'tag\') AND(Targets.TargetID)=187) ...; When I do a screen print I get: ... ((Measurements.msmTag)='') ... If I escape the $SQL = ...

RE: Win32:OLE Excel

2005-08-05 Thread Hsu, David
] Sent: Thursday, August 04, 2005 1:47 PM To: Hsu, David Cc: Perl-Win32-Users@listserv.ActiveState.com; [EMAIL PROTECTED] Subject: RE: Win32:OLE Excel David, I have a script with almost the exact same code and it works correctly. Try removing the parens from your add statement and see

Win32:OLE Excel

2005-08-04 Thread Hsu, David
Hi, Does someone know of another method of naming the Excel sheets? Currently I am using: ... $Worksheet = $Workbook-Worksheets()-Add(); $Worksheet-{Name} = test $i; ... The sheet names are still Sheet1, Sheet2, etc... Thanks, David ___

RE: Win32:OLE Excel

2005-08-04 Thread Hsu, David
Ken, I am using Win32::OLE. Add_worksheet uses the Spreadsheet:WriteExcel module. Thanks, David -Original Message- From: Ken Barker [mailto:[EMAIL PROTECTED] Sent: Thursday, August 04, 2005 12:07 PM To: Hsu, David; Perl-Win32-Users@listserv.ActiveState.com Subject: RE: Win32:OLE Excel

String formatting

2005-04-12 Thread Hsu, David
Hi all, I am working with GD::Graph and I am retrieving some data from a DB and formatting the data into a string that I can use for graphing. my @data = ($data1); My $myGraph = GD::Graph::lines-new(400,300); ... The problem is that my formatted string of data is not in the correct format and

Reg. expression help

2005-02-16 Thread Hsu, David
Hi, Can someone help me with the syntax of deleting the last word of text string. i.e. $string = 'my abc 123' Like to have only 'my abc' Thanks, David ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe:

Recall: Reg. expression help

2005-02-16 Thread Hsu, David
Hsu, David would like to recall the message, Reg. expression help. ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

RE: GD::Graph module install problem

2005-01-31 Thread Hsu, David
Randy, I double checked all my repository links, could not find anything wrong. So I deleted all and added again. Now it's working. Thanks, David -Original Message- From: Randy Kobes [mailto:[EMAIL PROTECTED] Sent: Friday, January 28, 2005 12:38 PM To: Hsu, David Cc: Perl-Win32

GD::Graph module install problem

2005-01-28 Thread Hsu, David
Hi, Can someone let me know if GD::Graph module works with Perl 5.8 on Windows format? I tried to install it from several sites: Activestate http://theoryx5.uwinnipeg.ca/ But I always get a Failed to download... error. I need to line plot some data. Is there another module option that I can use

RE: Re[2]: Deleting a worksheet in Excel

2005-01-25 Thread Hsu, David
workbook? Thanks, David -Original Message- From: [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 3:15 AM To: Hsu, David Cc: Perl-Win32-Users@listserv.ActiveState.com Subject: Re[2]: Deleting a worksheet in Excel David, Monday, January 24, 2005, 8:33:56 PM, : HD Fred, HD

Deleting a worksheet in Excel

2005-01-24 Thread Hsu, David
Title: Message Hi, Can someonelet me know the syntax of deleting a worksheet in an Excel workbook. I am using Win32::OLE. I've tried: $Workbook-Worksheets{9}.Delete; Thanks, David ___ Perl-Win32-Users mailing list

RE: Deleting a worksheet in Excel

2005-01-24 Thread Hsu, David
That was it. Thanks. -Original Message- From: [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 11:25 AM To: Hsu, David Cc: Perl-Win32-Users@listserv.ActiveState.com Subject: Re: Deleting a worksheet in Excel David, Monday, January 24, 2005, 5:39:01 PM, : HD Hi, HD Can

RE: Deleting a worksheet in Excel

2005-01-24 Thread Hsu, David
on, but thought that you might have encountered it. David -Original Message- From: Fred Govier [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 12:37 PM To: Hsu, David Cc: Perl-Win32-Users@listserv.ActiveState.com Subject: Re: Deleting a worksheet in Excel This works for me: my

RE: LWP::Simple could not retrieve issue

2005-01-18 Thread Hsu, David
PROTECTED] Sent: Monday, January 17, 2005 4:22 PM To: Hsu, David Cc: $Bill Luebkert; perl-win32-users@listserv.ActiveState.com Subject: RE: LWP::Simple could not retrieve issue On Mon, 17 Jan 2005, Hsu, David wrote: Bill, I tried your code, but get same problem. I'm behind a corporate firewall

RE: LWP::Simple could not retrieve issue

2005-01-17 Thread Hsu, David
, January 14, 2005 8:51 PM To: Hsu, David Cc: perl-win32-users@listserv.ActiveState.com Subject: Re: LWP::Simple could not retrieve issue Hsu, David wrote: Hi, I am having is the following error when I try to execute the script via a web browser. It seem to parse fine from the command line. Could

LWP::Simple could not retrieve issue

2005-01-14 Thread Hsu, David
Hi, I am having is the following error when I try to execute the script via a web browser. It seem to parse fine from the command line. Could not retrieve http://www.infoworld.com/rss/news.xml at c:\inetpub\wwwroot\rss\rss2html.pl line 38 I tried with several different rss feed sites, all with

Can't use an undefined value as a HASH reference when using Win32 ::OLE

2004-01-26 Thread Hsu, David
Title: Message Hi, I'm getting this error message when I run my application. "Can't use an undefined value as a HASH reference at c:\inetpub\wwwroot\trialmap\cgi-bin\standardQ.pl line 738". The strange part is that it gives me this message the first time when I run it. Then if I run it

RE: Can't use an undefined value as a HASH reference when using W in32 ::OLE

2004-01-26 Thread Hsu, David
Title: Message Bill,Thanks for your feedbacks. I was able to get pass that error message, but this message I am still stuck on:"Can't call method "Cells" on an undefined value at c:\inetpub\wwwroot\trialmap\cgi-bin\standardQ.pl line 728."Any ideas here,Thanks,Daviduse Win32::OLE;my $path =

Win32 unblessed reference error

2003-11-17 Thread Hsu, David
Title: Message Hi, I can't seem to figure out why it is giving me this error Can't call method "Cells" on unblessed reference at c:\inetpub\wwwroot\trialmap\cgi-bin\hmtEvalUP.pl line 1334. $Worksheet1-Cells is not causing any problems. Any help would be appreciated. Thanks, David my

RE: Displaying a status bar

2003-07-08 Thread Hsu, David
- BLS CTR [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 3:01 PM To: 'Hsu, David'; Thomas, Mark - BLS CTR; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Displaying a status bar Hsu, David [mailto:[EMAIL PROTECTED] wrote: Thanks Mark for the status bar. It seems to work well

RE: Displaying a status bar

2003-07-08 Thread Hsu, David
- BLS CTR [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 12:13 PM To: 'Hsu, David'; Thomas, Mark - BLS CTR; [EMAIL PROTECTED] Cc: 'Lee Goddard' Subject: RE: Displaying a status bar Mark, I set buffering to off ($| = 0) just before saving Excel Workook, it seems to do what I want

RE: Displaying a status bar

2003-07-07 Thread Hsu, David
has not appeared. Any ideas? David -Original Message- From: Thomas, Mark - BLS CTR [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 2:23 PM To: 'Hsu, David'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Displaying a status bar Hello, Can someone let me know of a method

Displaying a status bar

2003-06-25 Thread Hsu, David
Hello, Can someone let me know of a method of displaying a status bar on screen(html) in Perl script while it is processing a task. I have tried to print html, but it won't display the image until it has finished processing, and then it displays with the rest of the information. JavaScript is

RE: Displaying a status bar

2003-06-25 Thread Hsu, David
, without displaying any processed data. Any thoughts on this. Thanks, David -Original Message- From: Thomas, Mark - BLS CTR [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 2:23 PM To: 'Hsu, David'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Displaying a status bar Hello