Hi,
I am currently trying to get perl and mysql talking together on linux.
I have succeeded in the basics, doing selects, inserts, updates
and deletes when dealing with chars and ints. I have now turned
my attention to blobs, and am having considerable difficulty.
I have managed to get a
Edward J Dawson wrote:
I have managed to get a blob(a jpeg file) from a local file on the
linux box into the database, but I can't seem to get the thing back
out and onto a webpage! I have scanned numerous lists and books,
but seem to be unable to find any real information on dealing with
Can anyone please suggest how to enter date records
to an MS ACCESS db? I am running Perl/DBI/CGI, I can
INSERT any text type of data, but the script won't run
when I attempt to insert date type of data.
IN other words: INSERT $date INTO table1
VALUES($date)
Where $date is equal to 04/01/01 and I
Help! I cannot get DBD::ODBC to work. I am connecting to the
MSSQL 2000 database with:
$db = DBI-connect(dbi:odbc:MSSQLTEST);
MSSQLTEST _is_ the DSN of the database in my odbc.ini file for the
ODBC manager, unixODBC. I know unixODBC is working just fine because I
can connect to the
Date sent: Fri, 27 Apr 2001 15:55:21 +0100 (BST)
From: Maria Quinn [EMAIL PROTECTED]
To: Sterin, Ilya [EMAIL PROTECTED]
Copies to: 'mi email ' [EMAIL PROTECTED],
'[EMAIL PROTECTED] ' [EMAIL PROTECTED]
Subject:
Hi,
Preface: I'm not part of this mailing list, so if you respond, please cc me
on the message. I've tried to search the archives, but could not find a
searchable archive (current archives only go back 3 pages), searched google,
read the FAQ... anyway, I apologize if this question gets asked on
At 10:23 -0500 27/4/01, Jay Strauss wrote:
$ sqlplus / as sysdba
The benefit to this method, as opposed to:
$ sqlplus system/manager
being, I don't have to include my database password in any script. Does
anyone know how to do this in DBI/DBD-Oracle? I see in the doc you can do
it like:
If
You mean you can't startup and shutdown oracle from DBI?
That was the whole plan
Jay
- Original Message -
From: PD Miller [EMAIL PROTECTED]
To: Jay Strauss [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, April 27, 2001 10:56 AM
Subject: Re: connecting / as sysdba when using
Hello all:
I am currently running a program that creates a
comma-seperated-value document that has 5 columns. My question is this:
Using DBD::CSV is it possible for me to sort the file by column A (a date)
then by column B (a time) and then by column C (an NT user ID) in descending
Big Brother tells me that Bodo Eing wrote:
Sorry to answer too quickly, but from your original post it was not
clear to me that I am obviously on the wrong OS to answer your
question. On windows, DBI insists on the correct capitalization of
the DBD.
My bad. I am running linux
Try this, guess I've searched before, guess it was here:
http://www.xray.mpe.mpg.de/mailing-lists/dbi/
I was thinking about doing something similar just the other day,
but hadn't thought about the objects.
Looks like a very interesting project.
]-Original Message-
]From: David H.
I have programs that read in files line by line and split on a seperator. I am
having a problem now because one of my files is an extract from a database that
contains text
boxes where the users can use the Enter key. When doing a read this causes a
problem because it stops at each Enter
I need to insert and then update an entry in a table using 2 stored procs
that I am not authorized to alter. The first stored proc checks to see if
I can insert a row and if so it returns the row:
$cmd = 'exec sp_1 ...';
$sth-prepare($cmd);
$sth-execute();
while (@row =
Sorry, I reread Cheetah and DBD::Sybase perldoc and found the
_date_fmt() method. That should
work for me. Thanks anyway.
On Fri, 27 Apr 2001, Curt Russell Crandall wrote:
I need to insert and then update an entry in a table using 2 stored procs
that I am not authorized to alter. The
I am currently running a program that creates a
comma-seperated-value document that has 5 columns. My question is this:
Using DBD::CSV is it possible for me to sort the file by column A (a date)
then by column B (a time) and then by column C (an NT user ID) in
descending
order? Here is a
Where did you find those docs? They need to be corrected.
All the examples that appear in the fine manual (perldoc DBD::ODBC) show it
in uppercase and the DBI manual states that the case of the driver name does
matter. The 'dbi' in the DSN is supposed to be lowercase, but uppercase has
been
You can also do this on the fly with a convert, for example to find a date
range:
WHERE
convert(varchar(12), date_time, 112) = ?
AND
convert(varchar(12), date_time, 112) = ?
the 112 is the format ( I happen to use ISO) so its mmdd you can use
other formats check out sybase's online manual
Well, I've placed the .profile into the home of the nobody user, my original
post included the script with the setup of all the variables, and still the same
error! Another suggestion?
Warden, Ronald MCF:EX wrote:
This is simply a problem of permissions and environment variables. If you
shell
Does DBD::Oracle support oracle objects? We are in a mixed platform
environment where some components user perl and DBI, others use C and OCI
etc. For the most part we are unified using stored procedures but when it
comes to returning those objects, things just do not seem to work right.
What I
Hi,
I'm using perl to read LONG RAW data from an Oracle
8.1.6 database, my operating system is Solaris 2.6
Whilst trying to read LONG RAW data of about 30Mb from
Oracle 8.1.6, I get a core dump.
The perl script I have written is ok for reading data
into files of about 5MB in size, but fails
A.
With sufficient flattery (see Notebooks of Lazarus Long) Tim or some one
else would probably be glad to add them.
You might also look at Oracle-OCI for more direct access to OCI from Perl.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a
hi all,
i haven't been following the user group, so i apologize if this is an
already hashed topic.
i am running:
solaris 5.7 on sparc,
Summary of my perl5 (revision 5.0 version 6 subversion 0)
$DBI::VERSION=1.14
$DBD::Oracle::VERSION=1.06
Oracle 8.1.7.0.0
i am
Roberto,
You have to use the db2profile that is in the [$DB2HOME]/sqllib directory.
It contains all the environment variables that are needed for your web
server to run your scripts. It sets up your DB2DIR, DB2INSTANCE, INSTHOME,
PATH, the java path, LD_LIBRARY_PATH and runs the UDB Extender
23 matches
Mail list logo
