Search DaniWeb - 12dbi

Re: use DBI and Use DBD 12 Years Ago by techieguy31 DBI is database access library, DBDs are drivers used by DBI to access particular database. DBI connect - Bad Handshake - Frustration beyond belief 12 Years Ago by nonshatter All, I have been trying to debug this problem all weekend but I haven't been able to get any closer to the solution... I have just upgraded Mysql to 5.1 from 4.1 on a Red Hat 4 box. Everything is fine. I can connect to the database using the shell, I can connect to the database using a Perl script using DBI (also from the shell), However I … DBI quote function, MySQL and UNC shares 16 Years Ago by roswell1329 I'm having a devil of a time trying to insert a Windows UNC share into my MySQL database. The DBI quote function doesn't seem to be behaving as I would expect. Here's a little example: [code=perl] #!/usr/bin/perl -w use DBI; my $unc = '\\somebox.somehost.com\someshare'; my $dsn = "DBI:mysql:cmdb;localhost"; my $dbh = DBI->… DBI->connect using 'old-style' syntax is deprecated 3 Years Ago by litha Hi Please help I'm getting this error on a perl script DBI->connect using 'old-style' syntax is deprecated and will be an error in future versions at /home/dbadmin/perl/adm_audit_mhs line 43 $dbh = DBI->connect('xe', 'ops$dbadmin', 'm00nwalk', 'Oracle') or die $DBI::errstr; (this is line 43) Thank you in advance Re: DBI->connect using 'old-style' syntax is deprecated 3 Years Ago by pritaeas Long time since I've done any perl, but according to [the docs](https://metacpan.org/pod/DBI#connect) you don't need the fourth parameter. Fixed that, and the warning message should be gone. Perl (DBI) and Leopard 16 Years Ago by dogma I have been trying to get a working setup for web development under leopard for the last 5 days. Apart from MySQL issues the big problem seems to be the DBI module is particularly unhappy. The error I'm recieving is: Can't load '/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI/DBI.bundle' for module DBI: dlopen(/Library/Perl/5.8.8/… Problem with perl DBI ODBC driver (bug or misconfig ?) String data right truncation 14 Years Ago by magix Hello, I'm trying to simply do a SELECT from an ODBC source. It works perfectly in PHP but not in perl ! Therefore there is no problem at source or at ODBC level, it seems to reside at perl/DBI level... What I do : [CODE] use DBI; $dbh = DBI->connect('dbi:ODBC:' . $dsnname, $dbuser, $dbpwd) or... $sth = $dbh->prepare($sql) or … problems with ruby dbi 14 Years Ago by thegoatboy Hello Hopefully someone can help me. I am trying to update fields in a mysql database using ruby with dbi, but no matter what I try, i just cannot update the row. I am able to search it, but never update. I search for the right string, then open a file, search for that string and then update the mysql row. but the update part will not work. … Re: Problem with perl DBI ODBC driver (bug or misconfig ?) String data right truncation 14 Years Ago by magix Solution on : [url]http://groups.google.ch/group/perl.dbi.users/browse_thread/thread/c885cb9d0c0fc780[/url] Re: Perl DBI insert into MySql 13 Years Ago by d5e5 After creating and populating the @printarray, connecting to MySQL, selecting a database etc. the following snippet seems to work OK. The trick is to prepare your query with placeholders and letting DBI worry about what characters need escaping.[CODE] $sth=$dbh->prepare ("INSERT INTO test (id, html_string) … Perl DBI insert into MySql 13 Years Ago by rmh000 I'm trying to insert into MySql, using DBI/Perl... What I'm doing is storing all my Print statements into an array, then dumping them out to print, and inserting into a MySql table in a foreach loop... Print resolves ok, but the MySql inserts are being split into fields at the breaks... Example : here's a couple "push" statements, … use DBI and Use DBD 12 Years Ago by jam2010 Hi All, Can anyone answer below question. when to use use DBI; and when to use use DBD? Thanks in advance Re: use DBI and Use DBD 12 Years Ago by wickedxter DBD::mysql is a driver that allows you to work with a mysql server and DBI module depends on that driver module... Re: PHP Programer / New to PERL need DBI MySQL Help 15 Years Ago by chrisranjana Here are some [URL="http://www.saturn5.com/~jwb/dbi-examples.html"]perl dbi examples[/URL] how to javascript inside my perl progam. 14 Years Ago by santhanalakshmi Hi, This is my perl program.......... [CODE]#!c:/perl/bin/perl use CGI qw(:all); $pfaccode=param('faccode'); $pprogramme=param('programme'); $pdeptcode=param('deptcode'); $pbrancode=param('brancode'); $psemester=param('semester'); $pkook = cookie(-name=>'logtime'); print "Content-type: text/html\n\n"; print &… Help Postioning Sidebar on screen. OPEN ME! 15 Years Ago by Confused@JS I need help positioning my sidebar on my browser. Every time I scroll down the sidebar follows down the screen causing me to lose half the info on the sidebar and only showing what fits in the screen. It has became a really pain in the @ss and I would appreciate any help passed my way or any helpful suggestions. Thanks [CODE]var awmav=navigator… How to make view HTML frameset in browser and facing a problem to display Frameset ? 13 Years Ago by jacksantho Hi, I have installed ActivePerl-5_6_1_631 and Web server Apach_1.3.22. I am using HTML Frameset in PERL/CGI. Facing problem in displaying HTML Frameset. Please check my coding.. [B][I]Sample.cgi [/I][/B][CODE]#!c:/perl/bin/perl use CGI qw(:all); $login=uc(param('uid')); $passwd=param('pwd'); $kid = time; $cookie = cookie(-name… Having a problem trying to install CGI::Session on Mac OS X 18 Years Ago by Dani I am using Mac OS X with the built in configuration of Apache. I am taking a web dev class where we're writing perl scripts ... so far I've been able to get my CGI scripts to run via mod_perl. Now, I'm trying to install CGI::Session via CPAN and it's not working and getting me very frustrated. I don't have much experience at all with the mac … map and extract common numbers between two columns 12 Years Ago by haojam Sir / Madam, I would like to map and extract common numbers between 5 column (i.e.Start) and 6th column (End) for refFlat table with 2nd column (Start) and 3rd column (End) for mirna table. Could you please modify the script attach here. I would be glad for your support. With regards, Rocky Seoul, Korea This is a simple script to … My SQL Help :( 16 Years Ago by abz007 Hi, I keep on getting the following error message: Software error: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-50,50' at line 1 at arp3-data.pl line 48. My host is a novice who couldn't really help. Here is the … Problem with ORDER BY LIMIT in MySQL 4.1.22 14 Years Ago by trilbies Hello. I am new and hope to find an answer to my query. I run a classified database and have been doing so for quite a few years, I recently upgraded the Plesk CP on my server and suddenly a problem appeared with the way the DB is returning the queries. I am currently running Perl 5 with MySQL 4.1.22 My old code was like this (trimmed code… Perl DB stuck 12 Years Ago by uvray90 Hello guys.. I am new to Perl and now reached till database concepts in Perl. I am using Wamp server in my computer. Is it possible to connect to the MySQL running in it :-/ ? But the Perl code is giving error while trying to connect to the SQL in it. The code i tried is below. The connection credentials are the same i use in my PhP in which it … Re: Assign Query Result to Variable 13 Years Ago by d5e5 An example of a query that returns only one row consisting of one column:[CODE]#!/usr/bin/perl use strict; use warnings; use 5.010; use warnings; use strict; use DBI; my $pwd = 'dogfood'; my ($dbh, $sth); $dbh=DBI->connect('dbi:mysql:daniweb','david',$pwd) || die "Error opening database: $DBI::errstr\n"; #The … Re: How to call mysql stored procedure in perl? 13 Years Ago by archana amith [QUOTE=d5e5;1454093]I don't see a connect statement in your script. The following works for me.[CODE]#!/usr/bin/perl use strict; use warnings; use 5.012; use DBI; my ($dbh, $sql, $sth, $msg); $dbh=DBI->connect('dbi:mysql:daniweb','david','dogfood') || die "Error opening database: $DBI::errstr\n"; my $… Re: map and extract common numbers between two columns 12 Years Ago by haojam Sir/ Madam, I would like to compare columns in tables in mysql database. From dbsnp table start and end columns with mirna table start and end. These are genomic positions in chromosome. I would like to extract common START and END positions by reading row by row. I have written a script attach here . Could you please modify this error. [CODE]… Re: map and extract common numbers between two columns 12 Years Ago by haojam Hello, I would like to map and extract common numbers between 5 column (i.e.Start) and 6th column (End) for refFlat table with 2nd column (Start) and 3rd column (End) for mirna table. I can run this script but I could not map Start and End columns in pre-mirna AND refFlat text files and extract the common with the Start and End columns. [CODE]… Re: map and extract common numbers between two columns 12 Years Ago by d5e5 Try moving the statement that executes $sth2 into the outer loop, something like the following (not tested):[CODE]#!/usr/bin/perl use strict; use warnings; use DBI; my $user = 'root'; my $password = '1004'; # connect to the database my $dbh = DBI->connect("dbi:mysql:mirvar", $user, $password) || die "Failed connect DB… Re: map and extract common numbers between two columns 12 Years Ago by haojam Dear Sir, I ran this perl script but there was a error while running it. The output comes like -- [haojamrocky@melon hg18]$ perl test2.pl Global symbol "$chr" requires explicit package name at test2.pl line 32. Global symbol "$m_start" requires explicit package name at test2.pl line 32. Global symbol "$m_end" … Re: map and extract common numbers between two columns 12 Years Ago by haojam Hello, I would like to map columns chr, start, end for dbSNP with chr, start, end for mirna and extract common lines with same chr, start, end positions. I have written a perl script where I found an error while running. could you please check it out and send me. I would be glad for your help. Regards, Rocky [CODE]#!/usr/bin/perl -w use … Bricolage - PHP5 & Mod Perl 18 Years Ago by ! ! [url="http://www.justatheory.com/bricolage/1.9.0.html"]http://www.justatheory.com/bricolage/1.9.0.html[/url] And finally—yes, you heard right—Bricolage now supports PHP 5 templating in addition to the existing Perl-based templating architectures ([url="http://www.masonhq.com/"][color=#0000ff]Mason[/color][/url], [url="…