I am aware that there are more problems for people using utf8 locales with RH9 perl. But we're getting off topic.
Tim. On Thu, Jan 08, 2004 at 12:41:50PM -0600, [EMAIL PROTECTED] wrote: > > I did say to be fair, I have not tried the perl that comes with RH9. > I just thought I would mention it, since I know somebody that was > having problems the the RH9 perl. Which could be an isolated instance. > > On 08-Jan-2004 Hardy Merrill wrote: > >>>> <[EMAIL PROTECTED]> 01/08/04 01:26PM >>> > > I beg to differ - I've used RH9 with the Perl and DBI that come with > > the distribution and I've never had a problem with it. > > > > Hardy Merrill > > > > This may be totally unrelated, but I had a friend email me about the > > Vendor Perl > > not working correctly on RH9. I encouraged him to compile 5.8.1 or > > 5.8.2, I have > > had nothing but trouble using the /usr/bin/perl that is shipped with > > RedHat. > > > > One > > of the biggest my complaints is that LARGEFILE_SOURCE is not compiled > > in (Although, > > to be fair, I have not checked RH9). On a new server, I always compile > > our own version > > of perl and make sure that the developers use /usr/local/bin/perl in > > there code. Just > > thought I would mention it, since my friend was experencing quirkiness > > with the RH9 compiled > > perl as well. > > > > STH > > > > On 08-Jan-2004 Mike Blezien wrote: > >> Server Info: > >> > >> DBI: 1.39 > >> DBD::mysql: 2.9003 > >> MySQL Version: - 4.0.15-standard > >> Perl ver.: 5.8.0 > >> RedHat/Linux 9.0 > >> > >> thx's > >> -- > >> Mike<mickalo>Blezien > >> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > >> Thunder Rain Internet Publishing > >> Providing Internet Solutions that work! > >> http://www.thunder-rain.com > >> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > >> > >> > >> Keith Jackson wrote: > >>> What version of DBD/DBI are you using and on what platform? The > > exact > >>> same thing happened to me on SunOS (don't remember the exact > > DBD/DBI > >>> version). I upgraded to the lastest DBD/DBI and the problem went > > away. > >>> > >>> > >>> HTH, > >>> > >>> Keith > >>> > >>> On Thu, 2004-01-08 at 11:40, Mike Blezien wrote: > >>> > >>>>Hello all, > >>>> > >>>>this one has been driving me nuts!! Below is a snip of code within a > > eval { } > >>>>for transactions. > >>>> > >>>>Everything gets inserted correctly but for some reason the > > $ary_ref->[$i] values > >>>>are always '0', they should be the `signupid` values from the > > `subscriptions` > >>>>table. > >>>> > >>>>In the 1st INSERT statement the auto_increment values (signupid) are > > created > >>>>correctly(in this code, 2 values, IE. 12,13) but when I go to > > retrieve these two > >>>>values in the SELECT statement, it always returns '0', > > $ary_ref->[$i]. The > >>>>@sitedata array has 2 lines of data(the $totalsubs equals '2' also) > > , and > >>>>everything is inserted correctly from the @insertdata into the > > INSERT statement > >>>>into the `site_subscriptions` table. > >>>> > >>>>No errors are generated within the eval {} and once the transaction > > is commited, > >>>>all goes exactly as it should, but for the life of me,... I can't > > figure out why > >>>>the $ary_ref->[$i] keeps inserting a '0' value?? Any help, ... > > suggestions would > >>>>be appreciated. :) > >>>> > >>>>################################################################################# > >>>>$sql = qq|INSERT INTO subscriptions (signupid,siteid) VALUES > > (NULL,?)|; > >>>> for (1..$totalsubs) { $dbh->do($sql,undef,$siteid); } > >>>> > >>>>my $subsql = qq|SELECT signupid FROM subscriptions WHERE siteid = > > $siteid|; > >>>>my $ary_ref = $dbh->selectall_arrayref($subsql); > >>>>my $sql = qq|INSERT INTO site_subscriptions $sitecols VALUES > > $siteplaceholder|; > >>>> > >>>> for (my $i; $i<@{$ary_ref}; $i++) { > >>>> chomp $sitedata[$i]; > >>>> my @insertdata = split(/\|/,$sitedata[$i]); > >>>> > >>>> # HERE THE $ary_ref->[$i] ALWAYS INSERTS '0' here > >>>> $dbh->do($sql,undef,$ary_ref->[$i],@insertdata); > >>>> } > >>>>################################################################################## > >>> > >> > >> > > > > -- > > ---------------------------------- > > E-Mail: [EMAIL PROTECTED] > > Date: 08-Jan-2004 > > Time: 12:18:16 > > ---------------------------------- > > -- > ---------------------------------- > E-Mail: [EMAIL PROTECTED] > Date: 08-Jan-2004 > Time: 12:35:49 > ----------------------------------
