Hi
I'm Satya. I'm having some problems with DBI... The following is the
problem
1. I wrote a Forking Server that will Create 2 database handlers and
wait for clients to connect
2. Once the client get's connected It will acquire a DB Handlers and
the corresponding flag Is Set ..
3.
My name is Karina Nagahama.
I'm working on Windows NT, Apache, Perl, mod_perl, Oracle8 and DBI.
I'm making a homepage with mod_perl.
DBI with mod_perl is working well.
The 'while' command is working well too.
But I'm having problems with 'redirect' , 'if' and 'if/else' commands.
'redirect' ,
On Tue, 18 Sep 2001 17:43:27 +0900, Karina Nahagama wrote:
The if sentence is written as follow:
if ($Login = 'FALSE'){$Login ='BR Unable to login';}
if ($Login = 'TRUE'){$Login ='BR Welcome BR ';}
The if/then sentence is written as follow:
if ($Login = ' '){
Kevin,
Your error is 'table or view does not exist'.
Did you connect as the same Oracle user in SQL*Plus and perl ?
Mark
Kevin Bass wrote:
Please post your entire statement:
my $sth = $dbh-prepare(qq(SELECT fuser.us_initl, . . .
Thanks
- Original Message -
From: Michael
Hello,
I'm sorry to be slightly off topic but how can u access table of
other user? (mean, the syntax)
I made 'user1' and 'user2'. user1 is the owner of table1.
the 'system' granted 'connect' role to user2, and user1 granted
select on table1 to user2.
When user2 tries 'select * from table1',
Hi,
simply qualify the table name with the owner's schema name, as in
SELECT * FROM user1.table1
That should do the trick. Alternatively, you could set up a synonym for table1 in the
schema of user2, as in
CREATE SYNONYM table1 FOR user1.table1
and after simply use
Thank you very much!
U too, Tommy and Sage. :D
Cheers,
Mikyung/
Sage, Christian wrote:
Hi,
simply qualify the table name with the owner's schema name, as in
SELECT * FROM user1.table1
That should do the trick. Alternatively, you could set up a synonym for table1 in
the
Hi,
I can only speak for Oracle. I don't know about other databases. But since
most databases implement indexes based on B-trees or something similar, I
guess this will hold for most, if not all, of them.
If you update an indexed column, the index entry is deleted and a new one
inserted. This
I noticed that DBD-Oracle trims blanks at the end of a field inserted into a
VARCHAR2-type column, even though ChopBlanks is set to False. Is that expected
behaviour ?
It messes up FreezeThaw. I'am saving a frozen field in the database, but when the last
character is a blank, thaw complaints
If you use $dbh-quote(), then the trailing space will be preserved.
Example:
...
$sth = $dbh-prepare(insert into test1 values ('a ', 'a ', 'a '));
$sth-execute;
$a = b ;
$sth = $dbh-prepare(insert into test1 values (?, ?, ?));
$sth-execute($a, $a, $a);
$a = c ;
$a =
I am receiving the error:
Exception Other: ORA-06502: PL/SQL: numeric or value error
My CGI script in part looks like :
$dbh=MyConnect($instance,$database);
my $security='69';
my $sth=$dbh-prepare(
'BEGIN
My_LOGON(:Security_Level);
END;')
or dienice
Hmmm, and maybe not. You can bind it as SQL_CHAR and it should then
preserve the trailing spaces, though I am not sure how oracle will handle it
on it's side.
Ilya
-Original Message-
From: Sterin, Ilya
To: 'Arjan van Ham '; '[EMAIL PROTECTED] '
Sent: 9/18/01 2:45 PM
Subject: RE:
On Tue, 18 Sep 2001, Sandy Zhang wrote:
our failure report is Class D:
That's debatable if you can't run 'make'.
# perl -V
Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:
Platform:
osname=solaris, osvers=2.8, archname=sun4-solaris
uname='sunos localhost 5.8 sun4u
My name is Karina Nagahama.
I'm working on Windows NT, Apache, Perl, mod_perl, Oracle8 and DBI.
I'm making a homepage with mod_perl.
DBI and mod_perl is working well .
The 'while' and the 'if/else' commands is working well too.
But I'm having problems using REDIRECT.
In order to use REDIRECT I
- Original Message -
From: "Karina Nahagama" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 19, 2001 10:01 AM
Subject: About Redirect
But I'm having problems using REDIRECT.
In order to use REDIRECT I wrote the next sentences:
my $page = new CGI;
Stephen Clouse wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Sep 12, 2001 at 01:23:59AM +0200, Bart Lateur wrote:
OK, probably a stupid question: Why do you want to have comments inside
the SQL statements? It looks useless to me. Most databases even choke on
the innocent
James Maes wrote:
Are the DBD Modules Thread safe, DBD::Informix in particular.
Define thread-safe?
DBI single-threads control.
DBD::Informix is supposed to compile under a Perl compiled with threads
-- let me know if it doesn't.
DBD::Informix makes no attempt to use the threaded ESQL/C
17 matches
Mail list logo