Many SQL clauses executing

2005-04-04 Thread Nicolay Vasiliev
Hello there! I tried to execute many SQL-clauses ; separated by DBI::do() method but got an error message about SQL syntax mistake. If I execute the same SQL from MySQL shell or some MySQL GUI all works fine. Is DBI::do() method able to perform many SQL clauses at all? If no what method or

PerlMagick working trouble

2005-02-23 Thread Nicolay Vasiliev
Hello, there! I use PerlMagick (PM) in my work. So, I try to check is the downloaded graphical file correct. I thought using some of PM methods (Ping ie) could help me but no. I tried to run the script in shell and I get the message 'html2ps not found...'. If the file is correct all is OK. eval

Undef value trouble

2005-02-18 Thread Nicolay Vasiliev
Hello there! As we know and as Larry Wall said in a Camel-book 0 in scalar variable is equal to undef. I have in my database PID columns with unique values. When I try to perform this column data by while my $pid = $sth-fetchrow_array() I lost one record because it has the 0 value. How could I

Having trouble using strict

2005-02-08 Thread Nicolay Vasiliev
Hello there! I got a trouble (I think). I'd like to store some variables in a separated file ie vars.pl to have a possibility of using them in different scripts by 'require vars.pl'. So if I use some script using the variable $var1 = somevalue storing in 'vars.pl' and I call this variable with

Re: Having trouble using strict

2005-02-08 Thread Nicolay Vasiliev
Oh, I got the main direction, thank you very much! John Moon wrote: Subject: Having trouble using strict Hello there! I got a trouble (I think). I'd like to store some variables in a separated file ie vars.pl to have a possibility of using them in different scripts by 'require vars.pl'. So if I

Resetting of the dataset

2004-12-16 Thread Nicolay Vasiliev
Hello there! I have some dataset got by the executing of some query. For example: my $sth = $dbh-prepare('select * from sometable'); $sth-execute(); Going through this dataset by $sth-fetchrow_array() I need to go back inside this proccess. Sorry, but I have no idea how can I do this. How can I