E
USE_LOCALE_CTYPE USE_LOCALE_NUMERIC USE_LOCALE_TIME
USE_PERLIO USE_PERL_ATOF
Locally applied patches:
Devel::PatchPerl 1.42
Built under linux
Compiled at Nov 3 2016 12:25:49
%ENV:
PERLBREW_BASHRC_VERSION="0.75"
PERLBREW
And tnsnames.ora under each ORACLE_HOME works good using sqlplus or other
tools, yes?
From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]
Sent: Monday, August 08, 2016 9:37 AM
To: Howard, Chris; Nelson, Erick; mohammed.must...@wipro.com; dbi-users@perl.org
Subject: RE: ORA
ORACLE_HOME not defined correctly?
(I would test by printing out all ENV from within script)
-Original Message-
From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]
Sent: Monday, August 08, 2016 5:38 AM
To: Nelson, Erick; mohammed.must...@wipro.com; dbi-users@perl.
Insert "in" values in a table.
Run the query with a sub-select or join against the table.
-Original Message-
From: Paul DuBois [mailto:p...@snake.net]
Sent: Tuesday, April 05, 2016 11:37 AM
To: Vaughan, Mark
Cc: Bruce Ferrell; dbi-users@perl.org
Subject: Re: suppress quoting in prepared
cat scriptname | od -bc | more
-Original Message-
From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu]
Sent: Wednesday, June 03, 2015 11:13 AM
To: William Bulley
Cc: dbi-users@perl.org
Subject: Re: help with odd DBI perpare/execute errors
> On Jun 3, 2015, at 9:44 AM, William B
le special character
of some sort embedded in your query string.
But I could be all wet.
Does it exhibit the same failure if you swap the selects
around the 'UNION' ?
-Original Message-
From: William Bulley [mailto:w...@umich.edu]
Sent: Wednesday, June 03, 2015 10:44 AM
Thanks!
And what does $query contain?
-Original Message-
From: William Bulley [mailto:w...@umich.edu]
Sent: Wednesday, June 03, 2015 9:14 AM
To: Howard, Chris
Cc: Martin J. Evans; dbi-users@perl.org
Subject: Re: help with odd DBI perpare/execute errors
According to "Howard,
Can you post a copy of your prepare statement?
-Original Message-
From: William Bulley [mailto:w...@umich.edu]
Sent: Wednesday, June 03, 2015 7:57 AM
To: Martin J. Evans
Cc: dbi-users@perl.org
Subject: Re: help with odd DBI perpare/execute errors
According to "Martin J. Evans" on Wed,
On Sun, Apr 06, 2014 at 07:59:32PM +0200, Vincent Veyron wrote:
>
> cat /etc/default/locale
> #Primary
> LANG=fr_FR@euro
> LANGUAGE=fr_FR:fr
>
> #Backup
> LANG=fr_FR@euro
# dpkg-reconfigure locales
And choose the right one, pick a UTF one this time. :)
--
"If you're not careful, the newspaper
On Oct 11, 2012, at 8:15 AM, Tim Bunce wrote:
> On Wed, Oct 10, 2012 at 06:32:54PM -0700, Chris Buxton wrote:
>> On Oct 10, 2012, at 1:21 PM, Jack Craig wrote:
>>
>>> Hi DBI-Users,
>>>
>>> I have a simple Perl program to open a file, db, serially read
threads, each
> reading a segment of the file and asynchronously writing to db using the
> same dbh,
> is that ok?
No. Each thread needs its own dbh. Your DBD may not support this.
Chris Buxton
BlueCat Networks
: Howard, Chris [mailto:howa...@prpa.org]
Sent: Friday, February 24, 2012 1:14 PM
To: 'dbi-users@perl.org'
Subject: time of prepare ?
I have a DBD::Oracle script which needs some help.
I have other DBD::Oracle scripts working ok, so I think
my installation is fine.
This particular script a
ent.
My question is: is there some forward-in-time
action going on which causes the prepare to happen
before my role is properly set? And if so, how
do I defeat that feature?
Chris
kind DBI users,
In order to get some security features that my users
are asking for, it looks like I will need to
implement "trusted mode" on our HP-UX servers.
Will that have any impact on Perl/DBI scripts that
run correctly in our current, "untrusted mode" environment?
We are using Oracle Wal
Found!
I needed to define $ENV{'HOME'} in my script prior to the
DBI connect so that the .sqlnet.ora file could be located
Thanks!
> -Original Message-
> From: Howard, Chris [mailto:howa...@prpa.org]
> Sent: Thursday, November 11, 2010 10:15 AM
> To: dbi-us
etter way to do this?
2) any idea what needs adjustment?
Thanks!
Chris Howard
If it always stops at the same place, it makes me think
of a resource problem, something like a quota?
I don't remember of there are select quotas.
Does it do the same if run as sysdba or some other
well-endowed database user?
> -Original Message-
> From: Dan [mailto:dkele...@gmail.com
d for: libclntsh.sl.10.1, [errno 2: No such file or
directory]
/usr/lib/dld.sl: Can't open shared library: libclntsh.sl.10.1
/usr/lib/dld.sl: No such file or directory
21-APR-2010
As you can see, it complains a lot but actually does perform.
I haven't tried your SHLIB_PATH ideas yet.. will
I wasn't too clear.
The scripts give error message complaints, but they
actually do work.
Chris
> -Original Message-
> From: Howard, Chris [mailto:howa...@prpa.org]
> Sent: Wednesday, April 21, 2010 12:39 PM
> To: John Scoles
> Cc: John Scoles; dbi-users@pe
age-
> From: John Scoles [mailto:sco...@pythian.com]
> Sent: Tuesday, April 20, 2010 8:38 AM
> To: Howard, Chris
> Cc: John Scoles; dbi-users@perl.org
> Subject: Re: Problems with external password store.
>
> >
> > Yes you can find out with ORA_OCI
> >
> >
>
As I suspected the one that doesn't work with wallet
is using Oracle 8.1.7.0 client.
I have some preparatory work to do before I can change that,
but I suspect it is the problem.
Chris
> -Original Message-
> From: John Scoles [mailto:sco...@pythian.com]
> Sent: Tuesday,
nal Message-
> From: John Scoles [mailto:byter...@hotmail.com]
> Sent: Tuesday, April 20, 2010 6:51 AM
> To: Howard, Chris; dbi-users@perl.org
> Subject: RE: Problems with external password store.
>
> If you are trying to connect to both at the same time using two
> different
Yes.
> -Original Message-
> From: Michael Broadwater [mailto:mbroad...@yahoo.com]
> Sent: Monday, April 19, 2010 11:43 AM
> To: Howard, Chris; dbi-users@perl.org
> Subject: Re: Problems with external password store.
>
> Does the perl script work without using t
TNS_ADMIN is not set in either case.
that's an alternative to the local $HOME/.sqlnet.ora file?
> -Original Message-
> From: Michael Broadwater [mailto:mbroad...@yahoo.com]
> Sent: Monday, April 19, 2010 10:57 AM
> To: Howard, Chris; dbi-users@perl.org
> Subjec
or forward progress otherwise?
Chris Howard
On Wed, Feb 10, 2010 at 10:40:21 + , Tim Bunce wrote:
> On Tue, Feb 09, 2010 at 01:57:40PM -0500, Chris Nehren wrote:
> > Hey, all.
> >
> > We've got a situation where we need to get the placeholders used for
> > statements when doing profiling. I've RTFM&#
be sufficient for the latter.
Aha. Thank you for the detailed response. I'll see if I can't make this
do what I need.
--
Thanks and best regards,
Chris Nehren
Hey, all.
We've got a situation where we need to get the placeholders used for
statements when doing profiling. I've RTFM'd and RTFS'd and not found
any leads. What do I need to poke to get this information?
--
Thanks and best regards,
Chris Nehren
I will be out of the office starting 04/22/2009 and will not return until
04/27/2009.
I can be reached via cell in case of emergencies. Please contact the
following folks while I am out:
NASCO Issues/Projects - Paul Billak, Dave Heilemann, Arif Wasi
Macy's Issues - Jason Harshbarger, Paul Bill
This still does not help. ORACLE_SID and LD_RUN_PATHwas already there.
I added SHLIB_PATH and still no luck.
---
Chris Koester
-Original Message-
From: Kong, Alan [mailto:ko...@coned.com]
Sent: Friday, January 09, 2009 1:56 PM
To: Koester, Chris; dbi-users@perl.org
";
$ENV{"LD_LIBRARY_PATH"}="/xst/xstlocal/bin/oracleInstantClient/instantclient_10_2:
If I have the script from the command line with all the env variables set
correctly the script runs. It basically does not recognize the variables in
the scripts.
Thanks in advance.
Chris
---
Chris Koester
this parameter to forcing it to be compiled in 32bit)
Sqlplus works just fine, so the listener and database is working
correctly.
Chris
---
Chris Koester
DBI 1.607-nothread default trace level set to 0x300/7 (pid 23194) at
commit.pl line 12
-> DBI->c
I recompiled DBI 1.607, DBD Oracle 1.22, and perl 5.8.8. I am still
getting the error. I have attached the DBI trace.
The listener is working correctly. I can even sqlplus from the same
server with the same TNSNAME.
Chris
---
Chris Koester
From: Martin Gainty
.
Thanks in advance for any help or suggestion.
Chris Koester
.com/group/perl.dbi.users/browse_thread/thread/3be1e4033e86919a/f5a10cb8d823ffdc
Reverting back to DBD::Oracle 1.20 solved it for me.
Cheers,
Chris,.
signature.asc
Description: OpenPGP digital signature
my code
barfs later on.
I've attached a simple patch against DBD::Oracle 1.22.
Cheers,
Chris,
+++ Oracle.pm 2008-09-22 11:56:56.0 +0100
--- Oracle.pm.orig 2008-09-22 11:55:53.0 +0100
@@ -3549,9 +3549,7 @@
my $chunk_size = 1034; # Arbitrary chunk size, for e
Chris Underhill wrote:
I'm experiencing a similar problem to that reported last month by Jan
Carlsson - see for example:
http://www.nntp.perl.org/group/perl.dbi.users/2008/08/msg33156.html
[Snip]
I'm also able to reproduce this on an old 32-bit i386 RHEL3 box,
upgraded to perl
with ORA-24347 errors.
To reproduce, run in the below. I've attached the output from
ora_verbose=6 on connecting to the 9.2.0.8 database server.
Cheers,
Chris,
--
DROP TABLE foo;
CREATE TABLE foo (account NUMBER,
quantity NUMBER,
product NUMBER);
ven more errors
- Would love to do 64 bit Perl, but gcc seemed to puke -- not
important for now
Thank you in advance to anyone who can point me in the right
direction.
Chris
Operand must be a modifiable lvalue.
"DB2.xs", line 175.13: 1506-025 (S) Operand must be a modifiable lvalue.
make: 1254-004 The error code from the last command is 1.
Has anyone experienced this issue before or know what the fix is? Any
suggestions are greatly appreciated.
Thanks,
Same problem on another Fedora Core 5 machine.
Same problem with the multi-language version of Oracle XE.
Same problem with DBD::Oracle 1.18a and 1.17.
Could someone please give me a hint?
On Wed, 2007-02-21 at 07:57 -0700, Chris Howard wrote:
> Having problems with the install of DBD::Ora
On Wed, 2007-02-21 at 07:57 -0700, Chris Howard wrote:
> Having problems with the install of DBD::Oracle 1.19 on
> a Fedora Core 5 machine.
sqlplus works fine
I really don't know where to go next.
I've got a project that is being held up while
I'm trying to get this to work
Having problems with the install of DBD::Oracle 1.19 on
a Fedora Core 5 machine.
DBI 1.53 installed and the tests ran ok
I'm using the Oracle XE from the Oracle download
oracle-xe-10.2.0.1-1.0.i386.rpm
The error message from 'make test':
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Comm
Doing some digging around, I discover that each Oracle connection consumes
4megs of RAM when "doing nothing".
that would add up to 8gigs for 2000 connections... and since I've only got
8gigs in total, this is about 4 times more than I can spare.
It would seem that I will definitely need some ki
so I've no idea if I
should be putting 200, 2000, 2, or even if I should be changing
these at all...
Kind Regards,
Chris Drake
Friday, November 17, 2006, 2:39:29 AM, Garrett, Philip wrote:
GPMC> Chris Drake wrote:
>> I'm expanding, and adding extra web servers to handle my
requests to request a shared (instead of dedicated) connection maybe ?
Thanks all
- Chris.
How about trying to create a brand new database using UTF8 *instead* of
AL32UTF8 ?
I'm no expert, and I'm not doing the same thing you are, but I solved *my*
UTF8 problems
thusly:-
US7ASCII
UTF8
""Garrett, Philip (MAN-Corporate)"" <[EMAIL PROTECTED]> wrote in
message news:[E
Read up on how to connect in the first place - you can pass
a switch that tells it to return errors to you, instead of killing
your whole script.
Look here:-
http://search.cpan.org/~pythian/DBD-Oracle-1.19/Oracle.pm#plsql_errstr
and search for "RaiseError"
"Robert Hicks" <[EMAIL PROTECTED]> wrote
equests
to request a shared (instead of dedicated) connection maybe ?
Thanks all
- Chris.
his for Instant
Client), then that might help.
Otherwise you could just download and install the full Oracle install
(following the instructions at the website above), and skip the parts
about setting up and running the database and listener. Inelegant,
but known to work.
-Chris
omeone on a PHP list figured out this workaround and it also appears to work
for DBD-mysql with Mysql 5.0.22.
We're going to open an issue with Mysql about this...
Chris Krusch
ITServices
The University of British Columbia
TEM' in
your perl script?
Or are you logging in as a user which might not have permission to
see the table?
-Chris
--
"Technically, you would only need one time traveler convention" -
Dorothy Gambrell, "Cat and Girl"
Have you downloaded perl source from CPAN as Alexander suggested?
Have you unpacked the perl source, and read the appropriate README and
README.solaris?
Have you read the INSTALL instructions?
Have you ran Configure from the top level of the perl source dist as
instructed?
-Original Message--
Hello, R . Rajasekar
perl -e 'use DBI;'
I would ask what platform you are using that does not have perl installed?
Most unix platforms will already have a default installation of perl and
DBI. If you are installing on windows, you will likely use ActiveState; it
has been a while since I installe
I/DBD::Oracle can't help you
here because it is not
going to know anything about the sqlplus connection, just the DBI
handle.
So it really is off-topic for this list.
-Chris
On May 22, 2006, at 6:07 PM, Drozdowski, Catharine wrote:
How can I find the server pid for a sqlplus session w
ch 15, 2006 6:29 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] DBD::SQLite SQLite Ver 3.2.7
In order to get this to work, modify DBD::SQLite dbdimp.c so that the 3rd
parameter of each call to sqlite3_prepare() is -1 instead of 0.
Steve
Chris Werner wrote:
> Hello,
>
> The curr
On Feb 6, 2006, at 12:33 PM, Jonathan Leffler wrote:
On 2/6/06, Terence J. Young, D.C. <[EMAIL PROTECTED]> wrote:
I am have trouble loading DBI, and DBD modules on Tiger. I
upgraded to
tiger from 10.3.9.
perl -V indicates that perl was complied from gcc 3.3xxx. Is there a
problem trying t
this is also off-topic.
Good luck,
-Chris
On Nov 9, 2005, at 4:21 PM, Vergara, Michael ((TEM)) wrote:
Hello Everyone:
Thanks to all who have responded to my question about logging.
That got me to the problematic SQL. This SQL,
on just one instance, hangs and does not complete. I have
I agree, a bit off topic, but for my log files I use the following code:
my $TempSelect = select( LOGF );
$| = 1;
select( $TempSelect );
Chris Sarnowski <[EMAIL PROTECTED]>
11/09/2005 03:48 PM
To
dbi-users@perl.org
cc
Subject
Re: L
On Nov 9, 2005, at 3:40 PM, Ian Harisay wrote:
I would look to using Log::Log4perl for all your logging needs.
But for
what you are doing try setting $| = 1 (autoflush).
and on Nov 9, 2005, at 3:38 PM, Chris Sarnowski wrote:
This is a perl issue, not a DBI issue, but try
autoflush
On Nov 9, 2005, at 3:24 PM, Vergara, Michael ((TEM)) wrote:
Hello Everyone:
I have a Perl script that connects to multiple Oracle databases. I
have the script write some status information to
a log file. There is one particular database that hangs in
processing, and I don't know why. Th
$facility,
$priority, $message, $sha1);
}
Then you don't need to worry about embedded quotes and so on.
Plus your DBA will like you better if you use bind variables.
As for your original question, I'd bet Ted Behling has the right answer:
get rid of the trailing semi-colon.
-Chris
On
});
> $sth_info_ins->bind_param(
> ':tdata', $table_data,
> {
> ora_type => ORA_BLOB,
> ora_field => 'table_data'
> });
> $sth_info_ins->execute;
>
> Steve
>
--
Chr
under Oracle 10g when slot_text is LESS
THAN 128 bytes. Anything larger than that bombs out. I find
this suspect.
* Running our application code on a Solaris 8 sparc box using the
Oracle 8i client libraries produces the same error.
* This error is also reprod
Mary,
Your error is occuring on this line:
$sth->execute ($sth)
This line should actually read:
$sth->execute ()
Anything passed into the execute function is assumed to be a bind
variable. Try making that change to your script and run it again.
HTH,
Chris
Mary An
This may have already been answered, since I seem to be getting some
lag time on list posts, but just in case ...
On Sep 19, 2005, at 9:44 AM, Lembo, Mike wrote:
I'm getting errors when I do a make for DBI. Details below.
# perl -v
This is perl, v5.8.5 built for sun4-solaris
Copyright
Please, in the future, keep your questions DBI/DBD related on this list...
HTH,
amonotod
Yes, I don't know why I didn't realize this
Thank you for the information
Chris
On Jul 13, 2005, at 8:21 PM, Drozdowski, Catharine wrote:
Hi All,
I am using Oracle v9.2.0.6, Perl V5.8.4... I can find the version
of the dbi if needed... When I run a simple connection call I have
been using for years against an Oracle DB with the NLS_LANG charset
of WE8MSWIN1284 I
On May 11, 2005, at 10:42 AM, Reidy, Ron wrote:
Read the Oracle docs ... Character functions
Or, from the perl end, check out the module Date::Format. If you are
using a
database that allows formatting of date strings (like Oracle, with
'TO_CHAR')
that is probably the easiest way to go. But if
I'm getting errors trying to make DBI-1.48 I running solaris 9. I can
perl Makefile.PL fine, but
make fails. Any help would be greatly appreciated.
Here is a summary of my config and the error message.
#perl -V
Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
Platform:
both connections) to around 5 minutes -
no real reason why it should be higher. Our client
code will then be able to detect a gracefully
terminated connection and reconnect without a hang.
Thanks for everyones help on this.
Chris
--- "Peter J. Holzer" <[EMAIL PROTECTED]> wrote:
&g
the mysql server can be configured to
keepalive the connection or if my client can ping the
server every so often.
Will post my results anayway.
Chri
--- Tony Adolph <[EMAIL PROTECTED]> wrote:
> Hi Chris,
>
> I've seen this problem before but connecting to an
> Oracle DB. I
Is the lack of response because this is a stupid
question related to an extensively documented problem
or does no one else have experience of this issue?
Anyone?
Thanks, Chris
--- Chris Masters <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> A firewall is terminating my connecti
27;,"execute error: $@");
$result = 0;
}
return $result;
###
Am I using alarms wrongly with perl?
Would it be better to use a select(2) wrapper?
Any other ideas to prevent this hang?
Thanks for any help on this.
Chris
redhat 8.0
perl
I'm not sure what type of database you are using, but you can achieve
this quite easily in MySQL by using "ORDER BY RAND()..." in your query.
Example:
SELECT name, street, date
FROM people
ORDER BY RAND()
LIMIT 10
HTH...
Chris
Ing. Branislav Gerzo wrote:
Hi all,
I have one simple
e and
a little PostgreSQL, but I'm under the impression that indexing
behavior in general is not very standardized, so not a good candidate
for DBI.
-Chris
On Feb 8, 2005, at 4:54 PM, Todd Hepler wrote:
Is there DBD independent way to find the unique constraints for a
table
www.perldoc.com -
www.google.com etc).
People normally charge good money for the advice they are giving you -
please don't take advantage.
Chris
On Wed, 29 Dec 2004 12:07:38 -0600, Ron Wingfield
<[EMAIL PROTECTED]> wrote:
> Hello everyone,
>
> I'm having difficulty solvin
On Tue, 7 Dec 2004, Christopher Hicks wrote:
> I don't care about Oracle or any of the rest. Making this work with PG
> and MySQL will solve 90% of the world's problems. I don't see why it
> couldn't be extended to include whatever parameters where necessary for
> any of the proprietary database
8108 -r--r--r-- 1 root exua 4739 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::Const::GetInfo::ODBC.3
3548118 -r--r--r-- 1 root exua 7395 Nov 25 10:14
/usr/opt/perl5/man/man3/DBI::ProfileDumper::Apache.3
3548128 -r--r--r-- 1 root exua 5001 Nov 25 10:14
kills :-)
I know some of our real software developers here use the COM approach to
Notes via .NET... I should grab some examples from them. Thanks for the
suggestion.
- Chris
"Andy Hassall" <[EMAIL PROTECTED]>
10/07/2004 06:55 PM
To
"'Chris Gehring'"
I'm using the Notes-ODBC interface to Lotus Notes on a Windows Platform
(free from IBM) and using DBD-ODBC to interface from PERL. There are UNIX
alternatives available for a price.
http://www.easysoft.com
Richard J McWaters <[EMAIL PROTECTED]>
10/07/2004 04:47 PM
To
[EMAIL PROTECTED]
cc
atus, $passwordAge, $samAccountName);
The Error message returned is:
DBD::ODBC::st execute failed: [Lotus][ODBC Lotus Notes]Value must match
column data type (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at
passwordAge.pl line 247, line 283.
Any help would be appreciated.
Thanks!
Chris Gehring
Network Operations
703.841.7937
On Oct 1, 2004, at 2:30 PM, Kirti S. Bajwa wrote:
Rudy:
I am doing fresh install of RH9. At the present time, I am by-passing
installing PERL or any additional modules. I plan to buy a book to read
little and then:
1) Uninstall PERL which came with RH 9
2) Re-install latest verion of PERL
3) Instal
e to C from whatever it is
by default (here en_GB.UTF-8), i.e., at the shell prompt (for bash):
export LANG=C
delete the Makefile and try the build process again.
HTH,
Chris.
signature.asc
Description: This is a digitally signed message part
he Solaris platform) is that you must use the
same C compiler that was used to compile your perl installation. This
may mean that you will need to recompile your installation of perl (or
install a new instance of perl).
I've never actually worked with AIX, so can't say anything more
specific.
-Chris
On Sep 23, 2004, at 4:42 AM, Tim Bunce wrote:
On Wed, Sep 22, 2004 at 12:06:27PM -0400, Chris Sarnowski wrote:
On Sep 21, 2004, at 5:05 PM, Tim Bunce wrote:
DBD::Oracle simply asks for the columns as strings and it's Oracle
itself
that performs the number to string conversion. DBD::Oracle
(note: this is a response to a different thread, but I'm changing the
subject,
so have changed the subject line).
On Sep 21, 2004, at 5:05 PM, Tim Bunce wrote:
DBD::Oracle simply asks for the columns as strings and it's Oracle
itself
that performs the number to string conversion. DBD::Oracle giv
Is there a reason you want to use 3000 as a base? If there are no IDs >=
3000, then just start with 3000 and increment. If there are ID values
that exceed 3000, do you want to start AFTER those values, or if you
have 3000, 3001, 3002, 3010 in the table, do you want the next value to be
30
ytical Services
Kaiser Permanente
8-345-2485
(562) 401-2485
Jared Still <[EMAIL PROTECTED]>
09/06/2004 09:27 PM
To: Chris R Marbach/CA/[EMAIL PROTECTED]
cc: DBI List <[EMAIL PROTECTED]>
Subject:Re: Perl/DBI/ORACLE Troubles. Help, please!
to my data out of the table using perl
with DBI on this system so I can use it?
Thanks in advance...
Chris Marbach
$rv = $dbh->do($sql1)" with the same result.
This is PostgreSQL on SuSE 9.1.
Any suggestions to get these records into the table would be
welcome.
-Chris
eval {
$sth->execute() || die $DBI::errstr;
};
if ($@)
{
# error
print ERR $@; # Prints error to the ERR file handle
print DATA join("\,", [EMAIL PROTECTED]); # prints a csv line of the data
array to the DATA file handle
}
else
{
# suc
avior is odd. I (and presumably many people on the list)
have used bind variables for years without trouble. It may be that -w
and 'use strict;' will give you helpful info; these were both required
rules (as much as I could enforce them) back in my days of iron-fisted
DBA.
--Chris
On Aug 13,
your friend in situations where you
want to have a scalable, and as you put it 'robust', application.
You might want to direct some of your questions to the mod_perl list.
Chris Jacobson
Hello...
I've googled a lot, looked in the archives, and am finding not
much: is it possible to change the password of the "sa" user in a MSSQL
database with DBI?
-Chris
DBI:mysql:database=bugs:host=localhost:mysql_socket=/usr/local/data/mysql.so
ck
And it should work.
Good luck
-Chris
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 29, 2004 9:57 AM
Subject: Problems using MySQL with Bugzilla
> H
d the values in order (which is a pain).
I've found all the higher methods (selectall_arrayref, hashref, DO etc) all
work pretty much exactly the same way.
Hope this helps.
-Chris
- Original Message -
From: "v79k" <[EMAIL PROTECTED]>
To: "Chris Faust"
or die "Can't Prepare " . $db->errstr();
$sth->execute() or die "Can't Execute " $sth->errstr();
I'm using FreeTDS and DBD::Sybase so I can't use placeholders with MS-SQL..
Hope this helps.
-Chris
- Original Message -
From: "v79k&q
se -
I go back now to that same bit of code that was updating the MS-SQL server
and it works perfectly (I don't need to double quote the double quotes)!!
Sorry for wasting you time.
-Chris
So what you are saying is Sybase allows a insert/update with single double
quote but MS-SQL doesn't (when using FreeTDS and DBD_Sybase)??
Looks like I'll have do my own quoting or make it a 2 step process -
bummer!!!
Thanks Anyway.
-Chris
- Original Message -
From: "
1 - 100 of 233 matches
Mail list logo
