problem installing DBI in Solaris 8

Hello, I have a problem installing DBI in Solaris 8. 1. perl Makefile.PL (no errors) # root@SOLMAN1:/tmp/DBI-1.32perl Makefile.PL *** Note: The optional PlRPC-modules (RPC::PlServer etc) are not installed. If you want to use the DBD::Proxy driver and

CGI/DBI/mySQL Placeholder problem..

Hi All, I am facing problem while using placeholder.. I am using CGI/DBI/mySQL. When html form is submitted, if the form text box contains ? then, the INSERT query fails.. If I dont use the plcaholder, it stores form data ? as NULL.. i.e every occurance of ? in text is stored as

Re: Q: MySQL 'v' Postgres column attributes

On Wed, Feb 19, 2003 at 01:10:00PM -0800, David Wheeler wrote: On Wednesday, February 19, 2003, at 01:03 AM, Ron Savage wrote: Is there a Postgres DBI/DBD::Pg call which will retrieve the column attributes the way show columns from $table does under MySQL? column_info().

Problems with compiling and linking DBD::Oracle

Hi, I am new to this arena of Make and GCC, so I probably do something wrong. Searching around in news groups and internet did gave some hints and tips but not the solution for the following problem: The linker LD can not find libgcc.a and libgcc_eh.a. The first step perl Makefile.PL seems to

ANNOUNCE: CGI::Application::Generator 1.0

Version 1.0 of CGI::Application::Generator is now available via CPAN! Download site for CGI::Application::Generator: http://search.cpan.org/search?dist=CGI-Application-Generator CHANGES SINCE VERSION 0.01: - First release version of CGI::Application::Generator, a module intended to allow

Re: problem installing DBI in Solaris 8

Filipe, (There is a FAQ on this but ...) At 15:46 19/02/03, Filipe Vasconcelos wrote: Hello, I have a problem installing DBI in Solaris 8. snip cc -c -xO3 -xdepend -DVERSION=\1.32\ -DXS_VERSION=\1.32\ -KPIC -I/usr /perl5/5.00503/sun4-solaris/CORE -DDBI_NO_THREADS Perl.c

RE: Problems with compiling and linking DBD::Oracle

Please post the output from a make. Might be that either the wrong ld is called (instead of letting gcc handle that). You DID actually install perl after building and testing it, right ? As for the order: 1. Perl 2. DBI (preferably 1.30) 3. DBD (1.12) To build DBI extact tar-file and run

dbiproxy mode=threads, Win32, ActiveState 5.8 build 804

Trying to get dbiproxy to accept multiple simultaneous connections in threaded mode on Win32 under ActiveState Perl 5.8 build 804. Using the following .ppd's from Randy Kobes' site at http://theoryx5.uwinnipeg.ca/ppms/ DBI 1.32 Storable 2.06 Net-Daemon 0.37 PlRPC 0.2016 Running

prepare with fetchrow_array

Hello all, I am having a problem with prepared sth that uses fetchrow_array with two parameters passed in. The problem is as follows: in one of my tables I have a column STAT_DEF_ID ( CHAR(8) ) which is also one of the four unique constraints for that table. I am able to select my rows into an

Re: dbiproxy Problem on Win2K...

On Tue, 18 Feb 2003 11:10:52 +, Tim Bunce wrote: *Please* give back to the community that gave the modules to you, by sending the patches to the maintainers of the modules. We would have fedback earlier, but have just been too busy. I'll be dropping an email to the relevant maintainers as

Re: Q: MySQL 'v' Postgres column attributes

On Wednesday, February 19, 2003, at 03:29 PM, Keith Keller wrote: I'm not sure this is supported by DBD::Pg: it's not mentioned there (and most supported methods are). I haven't had a chance to try yet, though--I'll see if I can do it later. There's a column_info() method, but you're right

Re: CGI/DBI/mySQL Placeholder problem..

At 2:31 -0800 2/19/03, Tushar Balapure wrote: Hi All, I am facing problem while using placeholder.. I am using CGI/DBI/mySQL. When html form is submitted, if the form text box contains ? then, the INSERT query fails.. If I dont use the plcaholder, it stores form data ? as NULL.. i.e

Perl + DBI + Oracle DBD drivers

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 All, I am using Perl 5.6.1 build 629, DBI 1.14, DBD-Oracle 1.06, DBD-Oracle8 1.06 on Windows 2000. I am trying to use the following code to transmit a string including hex values to Oracle.

Re: dbiproxy Problem on Win2K...

On Thu, Feb 20, 2003 at 04:45:44PM +, oliver wrote: On Tue, 18 Feb 2003 11:10:52 +, Tim Bunce wrote: *Please* give back to the community that gave the modules to you, by sending the patches to the maintainers of the modules. We would have fedback earlier, but have just been too

DBD::mysql - column_info() ?

Does enyone have a reasonably working implementation of column_info() for mysql? Tim.

DBD::Oracle on RedHat 7.3 install help

Help Please.. I'm trying to build a linux box with DBD::Oracle. The Oracle 9i client works fine. I have installed DBI with not problem now for DBD.I'm getting the feeling that DBD does not work with Oracle 9i. [root@niss-cgi DBD-Oracle-1.12]# perl Makefile.PL Using DBI 1.32 installed in

Re: case sensitivity when creating a table.

Francois Desarmenien wrote: On Thu, 20 Feb 2003 14:44:02 -0500 Jose Blanco [EMAIL PROTECTED] wrote: Any ideas why SQL statements like this one: SELECT collid FROM Collection where collid= '123' and (userid = 'JoseA' or userid = 'JoseB') Are not working with SQL::Statement version 1.005, but

question on views!!

Hi I am working on a perl script that runs a sql which extracts all data from a view and prints them on a web page. But the problem is I am not able to print the field names as headings of the respective columns. Does anyone have any idea? Thanks - Do

Re: retrieving column names from a table using DBI module

Thanks Dave But i made the mistake of caling it a table but actually it is a view and table_info ethod does not work for that. Also i tried to run table_info for a table but it does not return the column names. There is a column info method for tables to do this. But it does not work for

Re: question on views!!

How about posting your code? -Joe --- Ms manisha gupta [EMAIL PROTECTED] wrote: Hi I am working on a perl script that runs a sql which extracts all data from a view and prints them on a web page. But the problem is I am not able to print the field names as headings of the respective

Re: case sensitivity when creating a table.

On Thu, 20 Feb 2003, Jeff Zucker wrote: Francois Desarmenien wrote: On Thu, 20 Feb 2003 14:44:02 -0500 Jose Blanco [EMAIL PROTECTED] wrote: Any ideas why SQL statements like this one: SELECT collid FROM Collection where collid= '123' and (userid = 'JoseA' or userid = 'JoseB') Are

Re: case sensitivity when creating a table.

Rudy Lippan wrote: I am confused. IIRC, SQL-99 (I don't have a 92 ref) says that delimited identifiers are case sensitive so Collection only matches Collection; however, COLLECTION will match Collection (collection COLLECTION) because each character of the regular identifier Collection is

Re: case sensitivity when creating a table. (corrected)

Jeff Zucker wrote: There is no database independent way to match a delimited identifier to an undelimited identifier. That part of my previous post is correct, but my examples were bad. Here is a better explanation with examples from two differing implementations: In the ANSI standard, a

Re: DBD::mysql - column_info() ?

On Thu, 20 Feb 2003 18:57:37 +, Tim Bunce wrote: Hi TIm Does enyone have a reasonably working implementation of column_info() for mysql? Do you mean Have I implemented it? or do you mean Can I get it to work? The answers are No and No. DBI V 1.32. DBD:mysql V 2.1021. template.pl: