Date formats from SQL using DBD::ODBC

2003-02-05 Thread Timothy Johnson
This is probably something really simple that I'm missing, but I was wondering if there is some way to get SQL to return a date field in the same format as Perl's time() or localtime(). Right now I keep getting a string like this: "1/20/2003 10:37:17 AM", which doesn't help me when it comes to

Installing DBI under Perl 5.6.0 & MacOSX Server 10.2.3 - broken

2003-02-05 Thread Eric Gorr
Attempting to install the latest version gives this error: t/10examp..dubious Test returned status 20 (wstat 5120, 0x1400) DIED. FAILED tests 104-245 Failed 142/245 tests, 42.04% okay This was done with the following command: perl -MCPAN -e 'install "DBI"' Installing the p

RE: MySQL and JDBC

2003-02-05 Thread Sterin, Ilya (I.)
This is a Java language, more than Perl, unless you'll use the Perl's JDBC bridge. And Tomcat really has nothing do with that at that point, it's a server. If you are looking for a Java answer, refer your question to either a java list, or I strongly recommend looking into the Struts framework.

MySQL and JDBC

2003-02-05 Thread Tay, William
Hi, I am developing a Web application that uses servlets as the server side scripting language, and Mysql as the database engine. Could you point me to where I can get information about how to use JDBC to connect Tomcat to Mysql? Thanks. Will

RE: :DB2 Do I need to compile on each box or can I copy the insta lled version to another box? (AIX)

2003-02-05 Thread Steve Haslam
> I've been told by our DBA that the Application Development Client could be > installed onto one of our test boxes in order to install DBD::DB2 to that > box, however it is not allowed on any of the Live boxes. My question > therefore is would it be feasible to install DBI and DBD::DB2 on one RS6

DBD::DB2 Do I need to compile on each box or can I copy the installed version to another box? (AIX)

2003-02-05 Thread kathrynjoy
Hello, My environment is as follows: AIX 4.3.3.0 running perl 5.005_03 Installed DBI 1.32 Installed DB2 vsn 7.2 I'm requiring install of the DBD::DB2 driver onto a number of AIX RS6000 machines. The install originally failed compilation because I hadn't installed the DB2 Application Development

Re: Newbie problem with Oracle functions

2003-02-05 Thread Dave K
David, > numeric when passed a 6 digit number. Here is an example of how it is > called within Oracle: > DECLARE >RetVal NUMBER; > > BEGIN >RetVal := COLLEGE.SPISFINANCIAL ( 123456 ); > END; Try calling it the same way wrapped in a begin end block in DBI > eval { > my $func = $dbh->

RE: Newbie problem with Oracle functions

2003-02-05 Thread Gaul, Ken
You can only do this the function has no side effects, or the PRAGMA RESTRICT REFERENCES clause is used. I forget exactly what is required but as far as I remember its quite restrictive. Ken. > -Original Message- > From: Steve Haslam [mailto:[EMAIL PROTECTED]] > Sent: 05 February 2003 10:

RE: Newbie problem with Oracle functions

2003-02-05 Thread Steve Haslam
>eval { > my $func = $dbh->prepare(q{ > BEGIN > :retval := SPISFINANCIAL( > parameter1_in => :parameter1 > ); > END; > }); > > $func->bind_param(":parameter1", '123456'); > $func->bind_param_inout(":retval", \$retval, 6); >

RE: DBI and DBD not found

2003-02-05 Thread Scott T. Hildreth
Are you using gmake/gcc ? On 04-Feb-2003 Chamlee, Douglas, B. (Contractor) wrote: > Ok, looks like I had at least 3 verions of perl. I have uninstalled them all > and reinstall just 5.6.1 from the SGI freeware web site. I tried to compile > the DBI module but I get 101 errors in the DBI.c file. I

Re: ODBC via tcp

2003-02-05 Thread Skorpion
it sounds good to use DBD::Sybase i heard it need some work to get mssql7 to work with - but still hope it works fine with mssql2k - my client machine is linux debian - i tried to use easysoft software for bridging connection - it should work fine (connection is ok - i've already checked) but i sti