Search Results

Search found 130 results on 6 pages for 'dbi'.

Page 3/6 | < Previous Page | 1 2 3 4 5 6 | Next Page >

Why can't Perl's DBD::DB2 find dbivport.h during installation?

- by Liju Mathew

We are using a Perl utility to dump data from DB2 database. We installed DBI package and it is asking for DBD package also. We dont have root access and when we try to install DBD package we are getting the following error: ERROR BUILDING DB2.pm [lijumathew@intblade03 DBD-DB2-1.78]$ make make[1]: Entering directory…

Read the article
Executing procedural queries in perl

- by KalpaG

I have a query like this set @valid_total:=0; set @invalid_total:=0; select week as weekno, measured_week,project_id as project, role_category_id as role_category, valid_count,valid_tickets, (@valid_total := @valid_total + valid_count) as valid_total, invalid_count,invalid_tickets, (@invalid_total :=…

Read the article
How to install DBD::mysql on OS X Server 10.6?

- by Zoran Simic

Trying to install DBD::mysql on OS X Server 10.6 (mac mini server). But I'm missing the mysql headers apparently. Since mysql is already part of OS X Server 10.6, I would like to NOT install anything else (no fink or darwin ports installs), just whatever's needed to get DBD::mysql installed and working.…

Read the article
How to install DBD::mysql on OS X server?

- by Zoran Simic

Trying to install DBD::mysql on OS X Server 10.6 (mac mini server). But I'm missing the mysql headers apparently. Since mysql is already part of OS X Server 10.6, I would like to NOT install anything else (no fink or darwin ports installs), just whatever's needed to get DBD::mysql installed and working.…

Read the article
Connect to MySQL in Ruby using NetBeans

- by Varun

I've downloaded the "dbd-mysql-0.4.4.zip" and linked it to my project. While I try to run a demo code from NetBeans the very first line require "dbi" gives me an error. Is there a different way to do it? I also tried jruby setup.rb config --with=dbi,dbd_mysql from the command prompt and it gave me…

Read the article
Pushing to an array not working as expected

- by Ross Attrill

When I execute the code below, my array 'tasks' ends up with the same last row from the dbi call repeated for each row in the database. require 'dbi' require 'PP' dbh = DBI.connect('DBI:ODBC:Driver={SQL Server Native Client 10.0};Server=localhost,1433;Database=db;Uid=db;Pwd=mypass', 'db', 'mypass') …

Read the article
An Explanation of Daily Business Intelligence

Joe Thomas, Director of Product Marketing for DBI, speaks with Fred about what DBI is, who it is designed for and why this solution is so attractive to customers.

Read the article
Bugzilla Install question - I'm stuck

- by Nabeel

I run Bugzilla's checksetup.pl (migrating an older version), and it always returns: Reading ./localconfig... Checking for DBD-mysql (v4.00) ok: found v4.005 Had to create DBD::mysql::dr::imp_data_size unexpectedly at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm line…

Read the article
Working around MySQL error "Deadlock found when trying to get lock; try restarting transaction"

- by Anon Guy

Hi all: I have a MySQL table with about 5,000,000 rows that are being constantly updated in small ways by parallel Perl processes connecting via DBI. The table has about 10 columns and several indexes. One fairly common operation gives rise to the following error sometimes: DBD::mysql::st…

Read the article
how to include .pl (PERL) file in PHP

- by dexter

i have two pages one in php(index.php) and another one in Perl(dbcon.pl). basically i want my php file to show only the UI and all the data operations would be done in Perl file. i have tried in index.pl <?php include("dbcon.pl");?> <html> <br/>PHP</br>…

Read the article
How to connect from ruby to MS Sql Server

- by apetrov

Hi Crowd! I'm trying to connect to the sql server 2005 database from *NIX machine: I have the following configuration: Linux 64bit ruby -v ruby 1.8.6 (2007-09-24 patchlevel 111) [x86_64-linux] important gems: dbd-odbc (0.2.4) dbi (0.4.1) active record sql server…

Read the article
Bugzilla Install question - I'm stuck

- by Nabeel

I run Bugzilla's checksetup.pl (migrating an older version), and it always returns: Reading ./localconfig... Checking for DBD-mysql (v4.00) ok: found v4.005 Had to create DBD::mysql::dr::imp_data_size unexpectedly at…

Read the article
SQL wont work? It doesn't come up with errors either

- by Stefan

Hey there, I have php function which checks to see if variables are set and then adds them onto my sql query. However I am don't seem to be getting any results back!? $where_array = array(); if (array_key_exists("location",…

Read the article
Perl: catch error without die

- by Pmarcoen

I'm playing around with error handling and got a little problem. I connect with a database using the DBI module. I do my own error handling by using a subroutine that I call upon an error. I can catch my own dies and handle…

Read the article
Perl Math::Business::EMA help

- by Dustin

Script pulls data from mysql: $DBI::result = $db->prepare(qq{ SELECT close FROM $table WHERE day <= '$DATE' ORDER BY day DESC LIMIT $EMA }); $DBI::result->execute(); while($row =…

Read the article
update a column in input file by taking value from Database in perl.

- by Rahul Singh

input file: 1,a,USA,, 2,b,UK,, 3,c,USA,, i want to update the 4th column in the input file from taking values from one of the table. my code looks like this: my $customer_dbh = DBI-connect("DBI:Oracle:$INST",…

Read the article
Is there any way to print the actual query that mysqli->execute() makes?

- by 0plus1

I have a complex query that gets executed like this: if ($stmt = $dbi->prepare($pt_query)) { $stmt->bind_param('ssssssssi',…

Read the article
How do I call Informix stored procedures from Perl?

- by superjtc

How do I call informix stored procedures from Perl? I use DBD::ODBC to connect to informix database, but I don't know how to call procedures.…

Read the article
Why does my Perl CGI script complain about "Can't locate CGI/Simple.pm"?

- by dexter

For more information see this Example use strict; use warnings; use CGI::Simple; use DBI; my $cgi = CGI::Simple->new; my $dsn = sprintf(…

Read the article
Perl - CodeGolf - Nested loops & SQL inserts

- by CheeseConQueso

I had to make a really small and simple script that would fill a table with string values according to these criteria: 2 characters long…

Read the article
Parsing large txt files in ruby taking a lot of time?

- by hershey92

below is the code to download a txt file from internet approx 9000 lines and populate the database, I have tried a lot but it takes a lot…

Read the article
Need help on awk/sed/ perl pattern with regex / grep

- by Jayakumar K

Sample file output from grep file1:my $dbh = DBI->connect("dbi:mysql:$database_name", $DB_USER, $DB_PASSWD) file2:($dbc,$rc) =…

Read the article
Efficiency of Java "Double Brace Initialization"?

- by Jim Ferrans

In Hidden Features of Java the top answer mentions Double Brace Initialization, with a very enticing syntax: Set<String>…

Read the article
DBD::Advantage and 64-bit Perl - Always 6060

- by WarheadsSE

I realize that I am attempting to go beyond the "supported" behavior of the manf's released drivers for perl, after all they…

Read the article
perl dancer: passing database info to template

- by Bubnoff

Following Dancer tutorial here: http://search.cpan.org/dist/Dancer/lib/Dancer/Tutorial.pod I'm using my own sqlite3…

Read the article

< Previous Page | 1 2 3 4 5 6 | Next Page >