No... its a varchar2(30).
but it does also happen on a char field if i use the key field on that
table 'person_no' char(10) and do the same test i get the same results...
-Original Message-
From: Michael A. Chase [mailto:[EMAIL PROTECTED]]
Sent: 14 February 2001 15:21
To:
try using single quotes around your variable in your sql statement
$sql="select forename from people where surname = '?'";
- Original Message -
From: "Pete Coales" [EMAIL PROTECTED]
To: "Michael A. Chase" [EMAIL PROTECTED]
Cc: "DBI Mailing List" [EMAIL PROTECTED]
Sent: Friday,
Lee Jonas wrote:
I am an experienced Windows C++ developer and I know how to use debuggers
generally. I *am* new to UNIX, Perl, DBI and PerlXS though. The main
question I face is how can I debug DBD Perl XS C/C++ modules? What are the
special steps I have to take to get a DBD module
Mark: No. That would compare surname to a literal '?', not to the value
he's supplying to the placeholder.
Pete: Try turning on tracing just before the execute() to see what's really
being passed:
DBI-trace(2, "file.name" );
$ret=$cursor-execute(@bind_array);
I hope @bind_array has only
i've found a work round
i basically do this in a loop thru the bind array list...
$cursor-bind_param($i+1, $bind_array[$i], { ora_type=96 } ) ;
seems to work for both char and varchar2 fields
cheers anyway!!
-Original Message-
From: Michael A. Chase [mailto:[EMAIL
Thanks for the follow-up. That's normally only needed if there are trailing
spaces in the database column. Hence my question about CHAR columns since
they are nearly always space padded.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish
Hi all:
Is time connect to Oracle depending of number of users connected?.
Excuse me my English :-]
=
my $cuenta = "dbi:Oracle:$connect_string";
$open_connect = time;
eval {$dbh =
i guessed that as well but was confused as to why it was happening on the
varchars too!!
-Original Message-
From: Michael A. Chase [mailto:[EMAIL PROTECTED]]
Sent: 16 February 2001 09:33
To: [EMAIL PROTECTED]
Cc: DBI Mailing List
Subject: Re: problems with bind params
Thanks for
I am very new to Perl Programming. I need to use Perl
to talk to SQL Server Database. I have not yet
installed Perl on my machine.
Now, how do I go about doing these things?
ie, installing Perl and as well as talking to
SQLServer.
Please guide me on the above with step by step
- Forwarded message from Santhosh Kumar [EMAIL PROTECTED] -
Date: Thu, 15 Feb 2001 19:33:00 -0800 (PST)
From: Santhosh Kumar [EMAIL PROTECTED]
Subject: DBI Programming with Perl
To: [EMAIL PROTECTED]
Hi Tim,
I am very new to Perl Programming. I need to use Perl
to talk to SQL Server
I was doing some tests last night and I wanted to compare the databases
on two servers. First I wanted to ensure that the databases were
defined on both systems and to only transfer those that were not on the
second server from the first server.
Using the following:
$drh =
i
have a bind_variable containing '0' (zero). When i bind it it gets
inserted in the database as a space!!!
How come? And how the hell do stop it from doing
it...???
perl 5 on Suse Linux accessing oracle
7.
Pete Coales
senior developer
ramesys
On Fri, Feb 16, 2001 at 04:08:56PM -, Pete Coales wrote:
i have a bind_variable containing '0' (zero). When i bind it it gets
inserted in the database as a space!!!
Maybe you have atrigger on the table that replaces all zeroes with
spaces?
How come? And how the hell do stop it from
ah!
bug in my program thousand apologies!
-Original Message-
From: Pete Coales [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 4:09 PM
To: dbi mailing list
Subject: bind params again :)
i have a bind_variable containing '0' (zero). When i bind it it gets
On Fri, Feb 16, 2001 at 06:11:01PM +0100, Honza Pazdziora wrote:
On Fri, Feb 16, 2001 at 04:08:56PM -, Pete Coales wrote:
How come? And how the hell do stop it from doing it...???
Instead of shouting, posting in HTML and including JPEGs, why not show
a minimum code that demonstrates
Date sent: Fri, 16 Feb 2001 10:42:30 -0600
From: Mike Ford [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject:DBD::MySQL _ListDBs function for 3.23
Mike,
I was doing some tests last night and I wanted to compare the databases
on
Hello all,
I have joined the list today and I hope I will be able to share some
experience with everyone.
We have a problem here we can't seem to put our finger on:
We are accessing a
1 #!/usr/bin/perl -w
2
3 package SURVEY;
4
5 use DBI;
6 use CONSTANTS;
I guess four times is a charm. ;}b Tim is very busy, so he'd have forward
it here anyway.
What error message are you seeing?
The glob (*.xst) may be failing because you don't have csh or tcsh
installed. The annoying dependency of perl's glob() on csh is finally
removed in Perl 5.6, but if
Thank you Tim Michael !!
This makes sense -- in attempting to 'harden' this box, I've _removed_
unnescessary shells, games, suid programs, sgid scripts, etc.
Incidentally, this includes csh.
"Michael A. Chase" wrote:
I guess four times is a charm. ;}b Tim is very busy, so he'd
You probably should build your own perl using version 5.6. It removes the
dependency on csh for Perl glob()s.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an
Sorry if this is a faq...I'm receiving an error only when inserting
a relatively large amount of data (55Kb) into a TEXT field on a
postgresql 7.1b4 db. It works fine when I pump the sql statement
into a text file and run, e.g., a "psql load_me.sql". It also
works if I truncate the file into
The current post_initialize() uses the external command 'find' to search the
perl library tree for old versions of DBI and DBD drivers. This won't work
on most Win32 machines and probably won't work in some other platforms
either.
It also uses *.xst to identify some of the files used to build
Alan Pesola wrote:
How can I get the data type of each column(text, single,date etc...)
Not familiar with hashes!!
Get familiar with them...
This command $sth-{TYPE}; will supposedly return an array reference
for each column but how do I read it correctly?? I keep getting
Array(hexvalue)
I share the same problem, and my research on the subject has lead me to the
following:
SQL Server stored procedures can return data in one of two ways - result
sets and output (or input-output) parameters.
Also, SQL Server stemmed from Sybase. Due to this legacy, communications to
SQL Server
Tim,
I apologize in advance for sending this directly to you. I've tried to post it 3
times
to [EMAIL PROTECTED], but for whatever reason it doesn't seem to make it.
This does seem to work BTW ... but I'm a little suspicious of it still. Is it
ok?
[EMAIL PROTECTED]
For whatever reason perl
On Fri, Feb 16, 2001 at 02:55:28PM -0500, Sean Cooper wrote:
Tim,
I apologize in advance for sending this directly to you. I've tried to post it 3
times
to [EMAIL PROTECTED], but for whatever reason it doesn't seem to make it.
I've seen it.
This does seem to work BTW ... but I'm a little
26 matches
Mail list logo