On 02/18/2005 02:33 PM, Douglas Greenwalt said:
What DBD version of Oracle is the most current and where do I get it?
Currently put on DBI/5.8.3/DBD-Oracle.ppd from esoftmatic.com.
If you're running ActivePerl in MSWin and not ready to buuild it
yourself, esoftmatic.com is the best source.
http:/
This is a good question. Perhaps a tiny bit off topic for the mailing list but
I'll take a stab at giving you my 2 cents worth, anyway.
Yes, I've done this kind of thing before but only with two or three drivers and
in a different language and using a different data access model (that is, not
Hi,
As described in the subject, I'm getting an ORA-00600 error. It is
intermittent (happening about 50%) of the time and is not
dependent on having a long datatype in the table I'm selecting from. The actual
error is:
DBD::Oracle::st execute failed: ORA-00600: internal error code,
arg
Hi Jon,
Instead of asking "where should I put the SQL?", you might ask "should I
write the raw final SQL?"?
If you have 50 queries, and 10 platforms, you probably don't want to to
maintain 500 text strings in your program. Ideally you want to write 50
queries in some generic format, and get the be
It's nice that everyone is so helpful with the CGI problem, but this isn't a CGI
list. DBI comments below.
Quoting "MCMULLIN, NANCY" <[EMAIL PROTECTED]>:
> ($pnotes) = $dbh->selectrow_array("SELECT notes FROM table WHERE t1 =
> '$pt'");
http://search.cpan.org/~timb/DBI/DBI.pm#Placeholders_and_B
Hmmm... Seems that $dbh->quote( $abc ) is doing something unintended.
$abc = "abcxy123other \r\n stuff \r\n 789";
$sql = "insert into tblStuff (clob) values (".$dbh->quote($abc).") ";
memo field looks like: "abcxy123other [][] stuff [][] 789"
However:
$abc = "abcxy123other
Hi Nancy,
Shouldn't your prepare statement be:
my $sth = WHERE t1 = '$pt'") or die ...
Instead of
my $sth = WHERE t = '$pt'") or die ...
HTH,
K.C
On Fri, 18 Feb 2005 09:21:27 -0700, MCMULLIN, NANCY
<[EMAIL PROTECTED]> wrote:
> I'm attempting an edit screen in Perl with Orac
Hi alec,
I use quote();
$abc = "abc'xyz'123'other\nstuff\r789";
$sql = "insert into tblStuff (clob) values ('".$dbh->quote($abc),"') ";
...seems to also work on cr/lf chars too- dunno how tho.
HTH
K.C
On Fri, 18 Feb 2005 14:31:37 -0500, Alec Brecher
<[EMAIL PROTECTED]> wrote:
> I am w
What DBD version of Oracle
is the most current and where do I get it? Currently put on
DBI/5.8.3/DBD-Oracle.ppd from esoftmatic.com.
Thanks,
Doug Greenwalt
_
Douglas J. Greenwalt5
Lynwood RoadCortlandt Manor, NY 10567Phone: (914) 739-1898Email: [EMAIL PROTEC
I am wondering if someone could help with insertion of line breaks into an
Access Memo (clob) field.
Is there a DBD::ADO option which allows \r\n to be seen in Access as line
break?
Currently "foo\r\nbar" looks like "foo[][]bar", where [] is a sqare box.
Thank you.
Alec Brecher
E Research Resou
Nancy,
You might try something like below. Since getting the results to the
client and updating are separate requests.
If(param('SAVE CHANGES')) {
&updateNotes();
} else {
&displayNotes();
}
Sub displayNotes() {
>my $pt = param('t1'); # value retrieved from page before
>...
>my $dbh = DBI-
In your cgi program that the form is calling, did you capture the notes value?
You cannot simply set "my $notes = $pnotes" because the value is the old one as
you said.
Have you try this?
$q = new cgi;
$notes = $q->param("notes");
-Original Message-
From: MCMULLIN, NANCY [mailto:[EMAIL
I'm attempting an edit screen in Perl with Oracle. I'm unable to figure
out how to keep the changed values so I can write to the DB. Can
anyone help? Here's part of my code:
===
my $pt = param('t1'); # value retrieved from page before
...
my $dbh = DBI->connect("DBI:Orac
My DBI perl application needs to support many database servers and
versions, but will only use one database server per installation. IE:
one customer may be using MySQL v3.xx, while another has PgSQL v7.4,
while another has Oracle... etc. My application needs to work for them
all, with minima
On Thu, Feb 17, 2005 at 02:18:02PM -0600, Raynsford, Kathy W CIV J564KR wrote:
>Hello
>I'm having problems with the test phase of installing DBD:: oracle
Please read http://www.catb.org/~esr/faqs/smart-questions.html
>Included is a script from by session.
>I am using Oracle clien
15 matches
Mail list logo
