ANNOUNCE: DBIx::AnyDBD 1.99

2001-04-22 Thread Matt Sergeant
This class is an alternative approach to developing database independant code, which differs from modules that write SQL for you (such as DBIx::Recordset). Instead this module provides an OO inheritance hierarchy for putting methods that do your SQL. For example, you create a Default.pm file (in

Re: DBI-1.15 and DBD-Oracle-1.06 on RH6.2

2001-04-22 Thread Michael A. Chase
If your problem is that plsql.t test 55 failed, this is a known issue with DBI 1.15 and DBD::Oracle 1.06. If no other failures were reported, you may install DBD::Oracle. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish

Re: multiple SQL Statements

2001-04-22 Thread Michael A. Chase
This question belongs in dbi-users, not dbi-dev. Run 'perldoc DBI' and 'perldoc DBD::Oracle' and read the fine manuals. There are working example scripts in Oracle.ex/ in DBD-Oracle-1.06.tar.gz which you can download from CPAN. Oracle.ex/commit would be especially appropriate in your case. If

Re: Question: CAN I use DBI to connect to MS SQL via a unix system?

2001-04-22 Thread Alexander Farber (EED)
Everett Hickey wrote: > First... does anyone know how to get a unix system (linux in particular, running >perl 5.004) to connect to a microsoft SQL database running on the same network? http://www.xray.mpe.mpg.de/mailing-lists/dbi/2001-01/msg00311.html

Re: multiple SQL Statements

2001-04-22 Thread Michael A. Chase
This question belongs in dbi-users, not dbi-dev. Run 'perldoc DBI' and 'perldoc DBD::Oracle' and read the fine manuals. There are working example scripts in Oracle.ex/ in DBD-Oracle-1.06.tar.gz which you can download from CPAN. Oracle.ex/commit would be especially appropriate in your case. If

Re: Question: CAN I use DBI to connect to MS SQL via a unix system?

2001-04-22 Thread Thomas A . Lowery
http://tlowery.hypermart.net The DBI-FAQ contains instructions for a number of methods. On Fri, Apr 20, 2001 at 10:55:55AM +0100, Everett Hickey wrote: > I've torn through website after website, faq after faq, and the man page for DBI... >searched CPAN, search engines, and interrogated a number

Force unique input to field from web form into Oracle primary key field...

2001-04-22 Thread Seasundown
Help??? This must be a common thing to do but have not seen an example to reference. Must create a web input form dialogue box ( dbi/oracle/CGI module ) which allows user to input a string. String will be placed in table if it is unique. String must be unique since it is to be placed int

DBI-1.15 and DBD-Oracle-1.06 on RH6.2

2001-04-22 Thread Alberto Ugolini
Hello, this is about a failed installation of DBD-Oracle-1.06 on Red Hat Linux 6.2, perl 5.005_03, Oracle 8.1.7.0.1 (standard installation). I say that both DBI-1.15 and Oracle istallation were OK, and the previous problem, happened with the same environment above, but with Oracle 8.0.5. By the

RE: Force unique input to field from web form into Oracle primary key field...

2001-04-22 Thread Steve Howard
If I understand what you are wanting to do, why not just have the file in the ACTION arguement of the FORM tag first perform the search against the database to see if the string is unique (SELECT COUNT(*) FROM $database WHERE $column = $value) , then based on the results of that search (which wil

RE: RE: Error in connecting to Oracle through IIS

2001-04-22 Thread Gilad Tsur
A note on this - Oracle 8.17 (and I think 8.16) have some problems in performing operations on CLOB's on Unicode databases. I'd recommend staying with 8.15 if you plan on doing CLOB stuff. -Original Message- From: Prasanna Gopalakrishna [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19,