On 11/26/2012 11:56 AM, H.Merijn Brand wrote:
On Mon, 26 Nov 2012 11:49:49 -0500, Scott R. Godin scot...@mhg2.com
wrote:
On 11/25/2012 04:16 AM, Jens Rehsack wrote:
On 25.11.12 10:00, H.Merijn Brand wrote:
On Fri, 23 Nov 2012 17:43:50 -0500, Scott R. Godin scot...@mhg2.com
wrote:
I've run
370501125YPF2594|P1534462|2|0
620354050CRF3119|P4438944|3|1
901228431AUF5822|P5315769|1|0
969358370QPO9757|P1523687|8|0
543692286WTA5861|P5993819|1|0
591327753QVR5452|P1013462|4|0
159204117LXL0308|P5358769|8|1
352853355KYT5615|P2810873|3|1
195099617GNE7056|P1306424|6|0
--
Scott R. Godin, Senior
Vance M. Allen wrote:
Sorry if the cross-posting wasn't appropriate, but I need help with this and
am not sure if it's more appropriate to post under CGI or DBI since it
involves both...I want to be sure that I can get help from the best source.
My question is probably a simple answer, but I
Scott R. Godin wrote:
t/coredubious
Test returned status 0 (wstat 139, 0x8b)
Scalar found where operator expected at (eval 153) line 1, near 'int'
$__val
(Missing operator before $__val?)
after all the subtests completed successfully
t/funcskipped
Jeff Zucker wrote:
t/coredubious
Not one response since Feb 9th? what's going on here?
You mean the Feb. 9th that happend less than two weeks ago? Did you
submit a patch? If not, what is going on is probably that the module's
author a) has a life and/or b) is busy. :-)
*chuckle*
cpan test DBI::Shell
Running test for module DBI::Shell
Running make for T/TL/TLOWERY/DBI-Shell-11.93.tar.gz
Fetching with LWP:
http://cpan.develooper.com/authors/id/T/TL/TLOWERY/DBI-Shell-11.93.tar.gz
Fetching with LWP:
http://cpan.develooper.com/authors/id/T/TL/TLOWERY/CHECKSUMS
Checksum for
Michael A Chase wrote:
On Thu, 6 Nov 2003 14:07:46 -0500 [EMAIL PROTECTED] wrote:
How do I determine what version of the DBD module is installed?
There are several DBD::xyz modules. DBI has a method for finding them:
perl -MDBI -e print join qq(\n), DBI-available_drivers
You can
Tim Bunce wrote:
On Thu, Nov 06, 2003 at 02:07:46PM -0500, [EMAIL PROTECTED] wrote:
How do I determine what version of the DBD module is installed?
With DBI 1.38 you can now do
perl -MDBI -e 'DBI-installed_versions'
and it'll tell you.
Tim.
Sweet! Thanks a lot, Tim, this is nice.
cpan install DBI::Shell
Running install for module DBI::Shell
Running make for T/TL/TLOWERY/DBI-Shell-11.93.tar.gz
Is already unwrapped into directory /root/.cpan/build/DBI-Shell-11.93
CPAN.pm: Going to build T/TL/TLOWERY/DBI-Shell-11.93.tar.gz
Checking if your kit is complete...
Looks good
Tim Bunce wrote:
$ perl col_info.pl
Undefined subroutine DBD::mysql::db::SQL_VARCHAR called at
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/mysql.pm line
337.
which I don't quite understand. I tried adding :sql_types to the DBI
declaration, but no go.
It's a minor bug in
A while back in February, Tim and Ron were discussing DBD::mysql and
column_info..
This is the only thing I could find that *may* relate to my question, so I'm
asking here for further clarification.
It's not clear in the docs (at least not to me) whether I can have
column_info return the
[EMAIL PROTECTED] wrote:
is MYSQL where clause case sensitive?
it looks like it is not
redhat 9
mysql 3.23.56
name='Bob' same as name='bob'
For case-sensitivity, use the BINARY cast operator:
select * from $table WHERE name = BINARY 'Bob';
will only match if it's an exact case
Unknown Sender wrote:
W li?cie z wto, 26-08-2003, godz. 18:33, Jeff Zucker pisze:
Well, I thought so, and that's why AnyData works that way. But CSV
worked with the \015\012 default when I inherited it and there are too
many scripts out there based on that behaviour for me to contemplate
Mkb wrote:
#include socket
int main() { exit(0); };
gcc -o t.o -c t.c
gives
t.c:1:18: socket: No such file or directory. Not
being a C programmer, I'm not sure how I'd get the
compiler to include this header. Any ideas?
The socket.h files are located here:
/usr/conf/sys/socket.h
[EMAIL PROTECTED] wrote:
This looks like your GCC can not parse /usr/include/socket.h
Can you test that?
cat t.c EOF
#include socket
int main() { exit(0); }
EOF
gcc -o t.o -c t.c
posting this just for comparison purposes...
my copy of redhat 8 here doesn't have socket.h in
Ron Stephan wrote:
The way I understand it, it will select all 100,000 and then try and
display them all. Between the server and the browser something is bound
to break or get stupefying slow. Am I wrong? Most of the time people
are going to have filter criteria in the display - maybe it
Ron Savage wrote:
On Sun, 23 Mar 2003 16:37:43 -0500, Scott R. Godin wrote:
Ron Savage wrote:
Hi Scott
Yes, unfortunately there's no default $ENV{TEMP} on unix..
I've been considering using File::Temp, File::MkTemp, or IO::File
instead,
but just haven't gotten around to futzing
Ron Savage wrote:
On Sat, 08 Mar 2003 22:28:09 -0500, Scott R. Godin wrote:
Hi Scott
I've written a very nice module-reporting script that helps me to
stay on
top of installed modules and easily see when they require updates
from CPAN
for bugfixes.
http://www.webdragon.net/mr/
Great
Snowber Khan wrote:
[EMAIL PROTECTED] bugzilla]# perl -MCPAN -e 'force install DBD::mysql'
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Database was generated on Wed, 12 Mar 2003 15:42:32 GMT
Running install for module DBD::mysql
Running make for
Mel Awaisi wrote:
Hi
My error is as the subject says, i have a script that i am trying in it to
locate where a directory with images are.
the part in the script that the error i think is arising from is
my $dir = '/home/me/images/';
my @jpegs = `ls *.jpg`;
foreach (@jpegs) {
Mel Awaisi wrote:
Hi
i am using Red Hat Linux 8 as a server for a project i am working on.
i have installed MySQL automatically with the install of the OS. and then
i installed Apache Server.
i would like to install DBI in order for me to be able to use a script
that i have in perl to
Jeff Zucker wrote:
Tim Bunce wrote:
On Mon, Mar 03, 2003 at 10:07:29AM -0800, Jeff Zucker wrote:
use SQL::Statement;
print $SQL::Statement::VERSION;
Or run this command
perl -MSQL::Statement=
Hmm, what am I missing? That doesn't work for me with SQL::Statement.
It also
Curt Russell Crandall wrote:
In case anyone cares.
It appears the threaded version of Perl 5.8.0 on OSX is incompatible with
DBI. This really bites since you need the threaded version for Apache
2.0.43 and mod_perl 1.99_07. So, on OSX, you are probably better off
using FastCGI or, I
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Jeff Zucker) wrote:
Scott R. Godin wrote:
The weird thing is, the same problem occurs even if I push some other
test in front of the XML test. =:o (tried that last night)
Scott, there are problems between XML::Twig's file locking
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Jeff Zucker) wrote:
Scott R. Godin wrote:
my e-mail below isn't working, and Jeff's mailserver is rejecting mail
from my comcast.net domain (my ISP) *sigh*
Strange. I have some other email addresses but am traveling at the
moment
://www.mysql.com/Downloads/Manual/manual.pdf
also used the excellent Pod::Pdf to convert the pod docs from DBD::mysql
to the lovely output format of Pod::Pdf and didn't regret having THAT
handy either :)
print pack H*, 4a75737420416e6f74686572204d61635065726c204861636b65722c0d;
--
Scott R. Godin
things up.
Jeff I'd welcome some dialog with you on this, via the list. I LOVE
AnyData (particularly useful on MacPerl :) and am frustrated that I
can't also use it on the Linux box at the moment.
print pack H*, 4a75737420416e6f74686572204d61635065726c204861636b65722c0d;
--
Scott R. Godin
:)
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
It is not necessary to cc: me via e-mail unless you mean to speak off-group.
I read these via nntp.perl.org, so as to get the stuff OUT of my mailbox. :-)
a caption that's differently colored than normal for
the error you can do
caption.error { background: white; color: #3366ff; font-size: large ; }
in the stylesheet and then
print caption({-class='error'}, Sorry, I was unable to process your
request. Please try again.. ), \n;
HTH
--
Scott R. Godin
)
{
#... and no worries about which order the columns get returned in
#... since you access them via the $db{ColumnName} method :)
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
up against who is a major PHP
proponent, and who refused to even think about installing mod_perl to
help the script along after he saw this. :/
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
this is not a solution, but it may give someone else with more
knowledge enough to fix the problem. I will keep digging for answers.
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
of the mod_perl and Apache::DBI
stuff compiled in, because he's a php freak and thinks mod_perl is a
resource pig. :\
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Tim Bunce) wrote:
On Fri, Nov 02, 2001 at 02:18:15PM +0100, Bart Lateur wrote:
On Fri, 02 Nov 2001 07:27:49 -0500, Scott R. Godin wrote:
my %db;
$sth-bind_columns( \( @db{ @{ $sth-{NAME} } } ));# magic
while ($sth-fetch
been fetched.
I guess I'm fortunate that DBD::'s CSV, AnyData, and mysql all work this
way.
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
-bind_columns( \($date) );
while ( $sth-fetch() )
{
my($yyymmdd, $hhmmss) = split / /, $date;
my($, $mm, $dd) = split m|/|, $mmdd; # or split /-/, etc.
print Year: $, Month: $mm, Day, $dd\n;
}
$sth-finish if $sth;
$dbh-disconnect();
does that help?
--
Scott R. Godin
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Scott R. Godin) wrote:
Well post the script and we can look. Please eliminate the parts that are
not relevant if you script is big.
it's about 255 lines of code incuding comments.. I'll remove the
comments from the file to shorten
in?
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
In article
[EMAIL PROTECTED],
[EMAIL PROTECTED] (Ilya Sterin) wrote:
As much as I shouldn't say this, but run the script without the -w to get
rid of this message, or define a __WARN__ handler.
Ilya
or use
local $^W;
within the loop
--
Scott R. Godin| e-mail
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Stephen Clouse) wrote:
Having said all that, is this really on topic for dbi-users?
indeed it is, since the script in question is banking heavily upon DBI
and DBD::mysql to do the work.
--
Scott R. Godin| e-mail : [EMAIL
,
-width=300});
create_dbi_table($query);
print end_table,
end_div,
hr,
end_html;
FINISH:
# end of code
If anyone is interested I can provide particulars on the maps table in
the MySQL database as well.
--
Scott R. Godin| e-mail : [EMAIL
)
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
here's a missive fired off by the site admin after he benchmarked two
scripts, one written in php and one written in perl/cgi
First of all.
Dude. you're out of your mind. Im serious.
The WHOLE point about why PHP is faster than Perl is because the
interpreter is compiled into
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Jeff Zucker) wrote:
Scott R. Godin wrote:
unable to set ;csv_eol=\015, but saving the file via bbedit to DOS
instead of Macintosh, the code works?!? what the hell?
AFAIK,
1. If you are on a MAC and have all MAC-formatted files, don't
have to, considering one
single csv_eol=\015 is supposed to solve the problem :)
DBI 1.20
DBD::CSV 0.1027
SQL::Statement 0.1020
Text::CSV_XS 0.22
MacPerl 5.6.1a4
I can post the complete script and a smidge of sample data if you wish
--
Scott R. Godin| e-mail : [EMAIL PROTECTED
45 matches
Mail list logo