First questions first...
Do you have a Sybase client installed ?
If so, make sure that your SYBASE env. variable points at the Sybase root
directory, and make sure that you have sourced the SYBASE.sh file that is
found in that directory.
Once that is done you should have it a lot easier.
Just three points:
* Pasting values into the SQL command requires careful quoting.
Parameters do this automatically.
* Failing to quote correctly allows SQL injection, a common exploit for
www tools, but this is also possible with command line and GUI tools.
With parameters, the DBD::whatever
hi, i'm trying to debug a problem with a DBD module, it seems the make
test fails, and I cannot see enough useful error information to
determine the problem. Does anyone know what is usually done in a case
like this? I am less familiar with the debugging process in perl.
Thanks,
On Wed, May 09, 2007 at 04:17:04PM -0700, Justin Zygmont wrote:
hi, i'm trying to debug a problem with a DBD module, it seems the make
test fails, and I cannot see enough useful error information to
determine the problem. Does anyone know what is usually done in a case
like this? I am
Thanks for your comments. May be i guess before calling execute i should
check if the query has bind variables and whether they are passed otherwise i
should error out.
Jonathan Leffler [EMAIL PROTECTED] wrote:
On 5/9/07, ramesh thangamani [EMAIL PROTECTED] wrote:
Can you please
Hi,
While trying to compile DBI-1.55 and getting the following results
I am on Solaris 9 (SPARC) and I have tried using gcc 3.4.6 and also 3.3.2
# perl Makefile.PL
**
Perl versions below 5.6.1 are no longer supported by
I tried your suggestion, but still getting the same result. When i tried
printing $rc in my old code i get '0E0' which means success.
John Scoles [EMAIL PROTECTED] wrote: well this is your problem
my $rc = $sth-execute(@bind) or die Can't execute statement: $DBI::errstr;
You are
On your execution without a bound value, are you actually looking for rows
where the empno column is null? If so, try this:
instead of
my @bind1 = ();
try:
my @bind1 = (undef);
Otherwise, what exactly are you looking for?
Actually, even that may not get you the null rows now that I think
On Thu, May 10, 2007 at 02:53:39PM +1000, Shane Neubauer wrote:
Hi,
While trying to compile DBI-1.55 and getting the following results
I am on Solaris 9 (SPARC) and I have tried using gcc 3.4.6 and also 3.3.2
# perl Makefile.PL
On 2007-05-10 07:50:16 -0400, Jeffrey Seger wrote:
On your execution without a bound value, are you actually looking for rows
where the empno column is null? If so, try this:
instead of
my @bind1 = ();
try:
my @bind1 = (undef);
Otherwise, what exactly are you looking for?
As I
You're right. It's the the other way around from what I said. However,
when I tested this yesterday it seemed I was getting an error on the
create command also. But I re-examined the results more carefully today
and the create worked OK; it was just the insert that failed. However
they were
CAMPBELL, BRIAN D (BRIAN) wrote:
You're right. It's the the other way around from what I said. However,
when I tested this yesterday it seemed I was getting an error on the
create command also. But I re-examined the results more carefully today
and the create worked OK; it was just the insert
What I am expecting is getting error message saying enough bind variables are
not passed. Is there a way to force checking bind variables or i need to check
myself?
Jeffrey Seger [EMAIL PROTECTED] wrote: On your execution without a bound
value, are you actually looking for rows where the empno
On Thu, May 10, 2007 at 02:50:10PM +0200, Peter J. Holzer wrote:
On 2007-05-10 07:50:16 -0400, Jeffrey Seger wrote:
On your execution without a bound value, are you actually looking for rows
where the empno column is null? If so, try this:
instead of
my @bind1 = ();
try:
my @bind1
Hi list,
Anybody has a document / link explanining how to setup DBI and DBD::Oracle
with Oracle 10g on Windows XP?
Regards
Xavier
Hi,
You can install ActivePerl (I have made it with 5.6, but I think it will
work with 5.8 too)- works perfect.
After that over ppm upgrade to the latest DBI.
After that - http://search.cpan.org/src/PYTHIAN/DBD-Oracle-1.19/ - take a
look in README.win32.txt document.
I have made it yesterday on
I just did the same yesterday for XP using the readme README.win32.txt so
you should have no problems if you follow it.
Tzekov, Ianko [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
You can install ActivePerl (I have made it with 5.6, but I think it will
work with 5.8 too)-
Martin, Autocommit off doesn't help local temps persist after the
execute.
Andon said that batching all the commands in the same execute is not an
option for him, so the only working alternative so far is to consider
global temps (##foo). They do persist after an execute and throughout
an entire
You should run this with DBI-trace() turned on to see what DBD::ODBC
actually does. The temp tables should only be dropped when the connection
is closed.
Michael
Extranet
[EMAIL PROTECTED] - 11.05.2007 00:19
To: martin.evans, dbi-users
cc:
Subject:RE: temporary table
19 matches
Mail list logo
