Paul Boutros wrote:
>
> > First time using Access.
> >
> > I've used my usual insert using placeholders and got an error about a
> > count mismatch. Does Access not support placeholders?
>
> It definitely does support place-holders, at least in the versions I've
> used. Can you post more info?
> First time using Access.
>
> I've used my usual insert using placeholders and got an error about a
> count mismatch. Does Access not support placeholders?
It definitely does support place-holders, at least in the versions I've
used. Can you post more info?
> Anything I should know about A
First time using Access.
I've used my usual insert using placeholders and got an error about a
count mismatch. Does Access not support placeholders?
Anything I should know about Access and DBI?
Also (a little off topic) how do I create an AutoNumber field?
Are there any advantages/disa
Hello all,
Hope this is easy to replicate.
After connect, my code:
my $sth = $dbh->prepare( "select fname, lname, addr, city, state from
person");
# my $sth = $dbh->prepare( "select fname, lname from person");
$sth->execute;
$sth->bind_columns( \$f, \$l, \$a, \$c, \$s );
# $sth->bind_columns( \$f,
On Thu, 19 Dec 2002, Jeff Urlwin wrote:
> I don't see a "fetch" in the below code ... My recommended spot would be
> below
Thanks Jeff. Your message made it into the dbi folder and Michael Chase's
to my inbox. I saw his first.
This was the problem.
Best,
Rod
--
"Open Source Software - Som
On Thu, 19 Dec 2002, Michael A Chase wrote:
> Note that bind_columns() does not fetch the rows, it just defines where the
> columns will be stored when a row is fetched.
Bingo!!!
The example in the Cheetah book assumes a return of more than one row. I
wasn't so I didn't use that part of the co
On Thu, 19 Dec 2002 13:37:28 -0800 (PST) "Roderick A. Anderson" <[EMAIL PROTECTED]>
wrote:
> Here it is with all the cruft from trying to sort it out. I haven't
> included the connect stuff or the rest of the script since I know it
> works.
> my $sth = $dbh->prepare($domain_qry);
>
>
A known bug in DBD::Informix. It's easy to fix. Upgrade to DBI-1.32 and
your DBD-Informix should then compile.
Christopher S. Cosby
SciCare Software Services
770.236.1128
> -Original Message-
> From: [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 19, 2002 11:31 AM
> To: [EMAIL
>
>
> On Thu, 19 Dec 2002, Michael A Chase wrote:
>
> > The devil is often in the details. A snippet from the
> actual script
> > that demonstrates the problem would make it much easier for
> us to help
> > figure it out.
>
> Yeah I was trying to hold the bandwidth down but have just upped
On Thu, 19 Dec 2002, Michael A Chase wrote:
> The devil is often in the details. A snippet from the actual script that
> demonstrates the problem would make it much easier for us to help figure it
> out.
Yeah I was trying to hold the bandwidth down but have just upped it
instead.
Here it is wi
Hello,
I have been happily using DBD::Proxy for some time now. But now
I would like to expand my horizons and use something like
DBIx::Procedure::Oracle. Is this possible?
Thanks,
Ted Gilchrist
Have you tried this?
$sth = $dbh->prepare("exec $database..storedProcedure $parm");
On Thu 2002/12/19 10:12:11 PST, "Zhao, Charles" <[EMAIL PROTECTED]> writes
:
> $database is the name of the database, as it is not included in the =
> data
> source name. On my $server there are dozens of databas
On Thu, 19 Dec 2002 11:19:10 -0800 (PST) "Roderick A. Anderson" <[EMAIL PROTECTED]>
wrote:
> I'm having a problem with bind_columns or possibly my understanding
> of the returned values. Using the syntax in the Cheetah book and at CPAN
> I get empty scalars when all my testing indicates there
I'm having a problem with bind_columns or possibly my understanding
of the returned values. Using the syntax in the Cheetah book and at CPAN
I get empty scalars when all my testing indicates there should be a
values.
PostgreSQL 7.2.1 (from RPM), Perl 5.6.1 (RPM), DBI 1.30 (tarball),
DBD-Pg-1.0
$database is the name of the database, as it is not included in the data
source name. On my $server there are dozens of databases so here I
specify the one where the stored procedure exists.
However, when I do
$DBH = DBI->connect("dbi:Sybase:$server", $user, $password);
$sth = $DBH->prepare("$dat
On Thu, Dec 19, 2002 at 03:23:34PM +, Dominic Mitchell wrote:
> Tim Bunce wrote:
> >Maybe drivers could use something like
> >
> > $sth->bind_col( 1, \$foo, { CharSet => ... } );
> >
> >to indicate that a column is UTF8.
>
> It's a little bit simpler than that, because the charsets other t
Dear sir/madam,
I encountered some problem on installing DBD on SCO.
My server environment as follow:
---
OS: SCO_SV mis 3.2 5.0.6 i386
C Compiler:
Reading specs from
/usr/local/lib/gcc-lib/i486-pc-sco3.2v5.0/2.95/specs
gcc version 2.95 19990728 (re
Tim Bunce wrote:
Maybe drivers could use something like
$sth->bind_col( 1, \$foo, { CharSet => ... } );
to indicate that a column is UTF8.
It's a little bit simpler than that, because the charsets other than
UTF-8 will "just work". UTF-8 is the only one that perl has a special
flag for int
I don't know what your $database variable holds. The syntax that I use is this:
$update_cursor = $dbh->prepare("begin sp_Del_MDSAA11_STUSRAPTKN(
\'$id\' ,\'$co\', \'$st\' ,
\'$sc\' ,\'$ap\', \'$tk\' ,
\'$ad\' ,
:output , :out_msg); end;");
I've got 7 input variables here and 2 output
On Thu, 19 Dec 2002 13:09:05, Jacqui Caren wrote:
> If this set of requirements matches yours (many WDBI apps require these)
> then the only ODBC driver that comes close if openODBC (a commercial
Ooops! s/openODBC/openRDA ODBC/
Jacqui
Jacqui Caren, Ingram Group Ltd. [EMAIL PROTECTED]
ph: +44
On Thu, Dec 19, 2002 at 01:30:50PM -, Dominic Mitchell wrote:
> Tim Bunce wrote:
> > High bit doesn't always mean uft8 - may be latin1 etc etc.
>
> I realise this. Also, this utf8 flag toggling should only occur when the
> field is a text field and not any other kind of datatype. I'm assumin
On Thursday, December 19, 2002, at 06:33 AM, David M. Lloyd wrote:
On 19 Dec 2002, chad kellerman wrote:
I sure it has got to be something so simply that I am just over
looking. It just seems that what I am doing now is just too much work
to grab a variable:
$sth = $dbh->prepare( q{
SEL
* chad kellerman <[EMAIL PROTECTED]> [2002-12-19 09:27]:
> Hi guys,
Hi, chad.
> I am starting to work a lot with perl DBI and mysql a lot lately.
> One of the bigger issues that I am having is that whenever I do a select
> statement to grab variable froma db.. is seems that they are always
> re
Try this while statement:
while ( ($dailypath, $hostname) = $sth->fetchrow_array () ) {
#Do Your Stuff Here
}
Hope this helps.
Iman Mayes
-Original Message-
From: chad kellerman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 9:29 AM
To: [EMAIL PROTECTED]
Su
On 19 Dec 2002, chad kellerman wrote:
> I sure it has got to be something so simply that I am just over
> looking. It just seems that what I am doing now is just too much work
> to grab a variable:
>
> $sth = $dbh->prepare( q{
> SELECT dailypath, hostname FROM tblProcess
>
Hi guys,
I am starting to work a lot with perl DBI and mysql a lot lately.
One of the bigger issues that I am having is that whenever I do a select
statement to grab variable froma db.. is seems that they are always
returned as arrays.
It there a way I can issue a select statment an h
Tim Bunce wrote:
> High bit doesn't always mean uft8 - may be latin1 etc etc.
I realise this. Also, this utf8 flag toggling should only occur when the
field is a text field and not any other kind of datatype. I'm assuming
that large objects would not be affected by this, but can you store binary
On Wed, Dec 18, 2002 at 06:09:33PM +, Dominic Mitchell wrote:
> David Wheeler wrote:
> >On Wednesday, December 18, 2002, at 01:27 AM, Dominic Mitchell wrote:
> >>% psql -l
> >>List of databases
> >> Name| Owner | Encoding
> >>---+--+---
> >> dom |
On Thu, 19 Dec 2002 12:21:52 +, Tim Bunce wrote:
> - Forwarded message from Abhishek_Gupta <[EMAIL PROTECTED]> -
>
> Delivered-To: [EMAIL PROTECTED]
> From: Abhishek_Gupta <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: Enquiry
> Date: Thu, 19 Dec 2002 13:03:
- Forwarded message from Abhishek_Gupta <[EMAIL PROTECTED]> -
Delivered-To: [EMAIL PROTECTED]
From: Abhishek_Gupta <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Enquiry
Date: Thu, 19 Dec 2002 13:03:44 +0530
Hi,
I was searching thru the net and saw an article in a
on 2002-12-18 11:56:08-06, Michael A Chase <[EMAIL PROTECTED]> wrote:
>On Wed, 18 Dec 2002 11:08:14 -0600 "Zhou, Bixia" <[EMAIL PROTECTED]> wrote:
>
>> We are currently using: perl, v5.8.0 built for MSWin32-x86-multi-thread
>> The test code as following:
>> my $process = 1;
>> while ($process
On Wed, 18 Dec 2002 10:28:56 -0800 (PST), Michael A Chase wrote:
> On Wed, 18 Dec 2002 12:16:11 -0600 "Zhou, Bixia" <[EMAIL PROTECTED]> wrote:
>
> > I moved declare $dbh out of loop as you suggested, but memory usage didn't
> > stop to grow.
>
> There may be a leak somewhere, but someone else wi
Hi,
I have the following trivial piece of code:
use DBI ;
use DBD::Oracle ;
use strict;
my $db = "..." ;
my $usr = "..." ;
my $pwd = "..." ;
my $mode = 2 ;
my $dbh = DBI->connect ("dbi:Oracle:".$db, $usr, $pwd, {ora_session_mode
=> $mode}) ;
...
Hi,
I have the following trivial piece of code:
use DBI ;
use DBD::Oracle ;
use strict;
my $db = "..." ;
my $usr = "..." ;
my $pwd = "..." ;
my $mode = 2 ;
my $dbh = DBI->connect ("dbi:Oracle:".$db, $usr, $pwd, {ora_session_mode
=> $mode}) ;
...
David Wheeler wrote:
On Wednesday, December 18, 2002, at 01:27 AM, Dominic Mitchell wrote:
% psql -l
List of databases
Name| Owner | Encoding
---+--+---
dom | dom | UNICODE
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(
Hello again,
Has anyone managed to build DBD-Oracle on the latest version of Oracle (9i
Release 2 i.e. 9.2.0 - not 9.0.1) on Solaris or indeed any platform. I
posted a problem with CLOB tests previously - but have to yet to find a
solution.
Thanks,
Ben.
> No, it shouldn't -- but I can't see the crash message -- what does the
> dialog box say?.
No dialog box at all... without trace set, I just get a "perl.exe has
created an error", and with trace set, the service dies silently (it's a
service created with PerlSvc)...
The program worked well befo
37 matches
Mail list logo