Perl DBI upload a csv file to Access database

2012-06-27 Thread Yu-Shan Wang
I try to upload a csv file to access database using perl DBI. But keep failing. The* number* and *type* of the field in csv file are not fixed. Might be integer or character. ( I was able to make it if they are fixed) ---start of code #connect t

Re: perl DBI:OCDB execute failed. Too few parameters.

2012-06-21 Thread Yu-Shan Wang
Hi. I found the problem! (Took me an hour. > _<) Instead of *my $condition = ' FIELD1=A '; *I should write *my $condition = " FIELD1= ' A ' "; * Thanks, Tiffany

perl DBI:OCDB execute failed. Too few parameters.

2012-06-21 Thread Yu-Shan Wang
Hi, I need help with Perl DBI. I try to fetch the table from Microsoft access database. I want to return the whole table under the condition "FIELD1=A". The following is my code. my $db= "C:\\Users\\yushanwa\\Desktop\\DATABASE.accdb"; my $DSN = "DRIVER={Microsoft Access Driver (*.

How to create a user manual window

2012-06-12 Thread Yu-Shan Wang
I am trying to create a “Help” document using Perl. I have a GUI and made a dropdown menu with “Help” option. I am hoping to create a new window and have a something like a dirtree so that user can select the topic. Once it is selected, the window will display the guidance. (Just like the Help bu

Re: spreadsheet::xlsx and the horror of it all

2012-05-30 Thread Yu-Shan Wang
an awesome module, but sometimes its easier to > convert the file to CSV using excel and then its just text and its a lot > easier to manipulate. > > - Jose from Mexico > > On Wed, May 30, 2012 at 3:53 PM, Yu-Shan Wang wrote: > >> Hi >> >> Can I ask a quick

Re: spreadsheet::xlsx and the horror of it all

2012-05-30 Thread Yu-Shan Wang
Hi Can I ask a quick question? My perl version is 5.8.3 I couldn't find Spreadsheet::XLSX from ppm3 I search online. It seems that my version is too old to support this module. Is it correct? If so, is there other ways to parse *xlsm* file using perl v5.8.3 Thank you very much -Tiffany On Mon,

Binary file conversion

2010-01-20 Thread Shan
== I need by below use Convert::Binary:C; $c = Convert::Binary::C->new; binmode(S); my $c = Convert::Binary::C->new->parse(< 3,*ver => "asd",};# it gives error $binary = $c->pack('R', $data); print S $binary;

Re: PERL binary conversion

2010-01-20 Thread Shan
Thank u for your quick reply. How to install following module.or How to install following module in my system.I'm working in WINDOWS NT. Convert::Binary::C;Thanks and Regards,Shan BTW, it's perl or Perl, but never PERL. I am guessing your new to this list because your making a

PERL binary conversion

2010-01-18 Thread Shan
Hi All, How to install following module.or How to install following module in my system.I'm working in WINDOWS NT. Convert::Binary::C;Thanks and Regards,Shan -- DISCLAIMER: This message and any attachments are solely for the intended recipient and may contain confidential or privi

PERL pack help

2010-01-07 Thread Shan
Hi All, Help me to pack the string to pointer. Ex. $d="sdfgg"; $pack=pack("P",$d); What above code represents? Thanks and Regards, Shan -- DISCLAIMER: This message and any attachments are solely for the intended recipient and may contain confidential or privileged informa

Using Mail::Sender

2002-11-23 Thread Tin-Shan Chau
Using the following program, I managed to send a message with an attachment to multiple recipients using option 2, but not with options 1 and 3: >> use Mail::Sender; $address1 = '[EMAIL PROTECTED]'; $address2 = '[EMAIL PROTECTED]'; #$recipients

Trouble with Term::Readkey

2002-11-18 Thread Tin-Shan Chau
I was trying to use the Term::ReadKey module as follows: use Term::ReadKey; ReadMode ('noecho'); $password = ReadLine(0); but got the following: Can't locate Configure.pm in @INC (@INC contains: n:

Use of Search::Dict

2002-11-16 Thread Tin-Shan Chau
Can anyone point me to an example of how to use the above module? The ActiveState documentation is, to say the least, cryptic. I looked at "The PERL Cookbook", "PERL Programming", and also tried using PERLDOC, but did not come up with anything. Some of my questions are: 1. How should the inpu

Re: Sending mail under Windows 95/2000

2002-11-13 Thread Tin-Shan Chau
nson" <[EMAIL PROTECTED]> To: "'Kipp, James'" <[EMAIL PROTECTED]>; "'Tin-Shan Chau'" <[EMAIL PROTECTED]>; "'Help on PERL'" <[EMAIL PROTECTED]> Sent: Monday, November 11, 2002 12:26 PM Subject: RE: Sending mail unde

Sending mail under Windows 95/2000

2002-11-11 Thread Tin-Shan Chau
I have been trying to get the sample program in the ActiveState documentation to work, but without much success. Here is the code: >>> use Net::SMTP; $smtp = Net::SMTP->new('shaw.ca'); # connect to an SMTP server $smtp->mai

Testing for hidden or system files

2002-10-26 Thread Tin-Shan Chau
Does anyone know how to test for a hidden or system file under Windows 95/2000? Thanks in advance for your help.

Help with 'use'

2002-10-13 Thread Tin-Shan Chau
I have a module as follows: >>> package Test; require Exporter; our @ISA = qw(Exporter); our @EXPORT = qw(print_name print_test); sub print_test() { print "test\n"; } sub print_name() { my $file = shift; print "$file\n"; }

Problem with UNPACK

2002-07-28 Thread Tin-Shan Chau
I have run into the following problem with UNPACK: If I concatenate the packed values of a list to a string, when I use the unpack operation to put the values back into an array, the last element is missing. I can only get around the problem by specifying the exact number of elements to unpac

Problem with UNPACK

2002-07-25 Thread Tin-Shan Chau
I have run into the following problem: If I concatenate the packed values of a list to a string, when I use the unpack operation to put the values back into an array, the last element is missing. I can only get around the problem by specifying the exact number of elements to unpack. And if I

Problem with UNPACK

2002-07-25 Thread Tin-Shan Chau
I have run into the following problem: If I concatenate the packed values of a list to a string, when I use the unpack operation to put the values back into an array, the last element is missing. I can only get around the problem by specifying the exact number of elements to unpack. And if I