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 client
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
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 =
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
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 =
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
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 wondering
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 Oracle.
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 \r\n stuff
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');
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
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,
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
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.
14 matches
Mail list logo