Mickey Mestel wrote:
>
> all,
>
> > > never mind.. i understand the problem now.
>
> i think the problem is actually quite simple, it's a snapper, not a cod.
>
> :-)
>
> mickm
Snapper, cod, what's the diff? There still something fishy going on!
:-)
--
Matthew O. Pe
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 da
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(hexval
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
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
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 age
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'
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 y
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;
7
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 l
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
>
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 Ma
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 demonst
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
inserte
Hi,
I known this question is similar to another one thousand posted to
this list, and I would like to say that Ive searched the list archives for
hours before send this email.
All the answers that I found are related to Oracle or Sybase, but
not to SqlServer... My probl
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 d
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
pr
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 = DBI->install_driver("
> 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 Serve
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
>
>
> Th
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 = DBI->connect($cuenta,$user,$pas
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 an
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 PROTEC
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
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 run
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
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: [
28 matches
Mail list logo
