YAPC Europe 2007 Reminder - CFP and CFH Deadlines Approaching

2007-05-08 Thread Michael Kröll
Hi, The deadline to submit Hackathon proposals for this year's YAPC Europe in Vienna is just around the corner. Please do not forget to submit your proposals by Sunday, 13th May 2007. Information on what we're looking for exactly and what we can offer to moderators (e.g. travel/accommodation

Trapping error for $dbh-do()

2007-05-08 Thread Loo, Peter # PHX
Hi, I am trying to execute multi SQL statements within the $dbh-do() and it appears to work fine except it does not give me an error when part of the SQL fails. For example: BEGIN WORK; CREATE TEMP TABLE p_temp AS SELECT col1 , col2 , col3 FROM table1 , table2 WHERE

Bar Code

2007-05-08 Thread ithier.ctr
I want to barcode label from a serial number. I have a property accountability database using SYBASE. I access the database using perl and cgi, and display the results on the Web Page using Apache. The server is a unix platform running solaris 8. At the present time I can print labels, with the

Re: Bar Code

2007-05-08 Thread David Nicol
if you're using a label printer, the label printer will have primitives for that. If you're using a normal high-resolution laser or bubblejet, I would suggest looking into barcode support with the GD graphics library. Also, this issue is off-topic for dbi-users; after finding a bar code

Re: Bar Code

2007-05-08 Thread Jonathan Leffler
On 5/8/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I want to barcode label from a serial number. I have a property accountability database using SYBASE. I access the database using perl and cgi, and display the results on the Web Page using Apache. The server is a unix platform running

Re: Bar Code

2007-05-08 Thread Martin Gainty
Good Afternoon Oscar I just got this suggestion from [EMAIL PROTECTED] GD::Barcode Martin-- This email message and any files transmitted with it contain confidential information intended only for the person(s) to whom this email message is addressed. If you have received this email message in

Re: Trapping error for $dbh-do()

2007-05-08 Thread Alexander Foken
Quoting the DBI man page http://search.cpan.org/~timb/DBI-1.55/DBI.pm#Database_Handle_Methods: do $rows = $dbh-do($statement) or die $dbh-errstr; $rows = $dbh-do($statement, \%attr) or die $dbh-errstr; $rows = $dbh-do($statement, \%attr, @bind_values) or die ... Prepare and

RE: Trapping error for $dbh-do()

2007-05-08 Thread Loo, Peter # PHX
Hi Alexander, Thanks for your kind input. Completely understood except the sentence starting with NEVER, NEVER Will you kindly explain? Thanks again. Peter -Original Message- From: Alexander Foken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 2:11 PM To: Loo, Peter #

Re: Trapping error for $dbh-do()

2007-05-08 Thread Martin Gainty
Hello Basically the reason for substitution variables.. the statement SELECT * from my_table where col1 = 0 and col2 = 1 and col3 -3 where the predicate would be supplied by the substitution variables :0 and :1 and :2 as in my $sth=$dbh-prepare(select * from my_table where col1=:0 and col2=:1