Retrieving the selected value from a popup_menu()/html select

2003-03-21 Thread Colette Lamm
I have successfully created code that generates a popup_menu with the fields id & name. I would like to retrieve user's selection though by retrieving the selected id and passing it to functions that update a mysql database with the use of an Insert and an Update statement. What is the correct way

Re: undefined subroutine DBD::Pg::db::_login

2003-03-21 Thread Richard Schilling
Yeah, I know I've got to upgrade - but the production server I'm working has the older version of DBD::Pg. Anyway, I did solve the problem. My error was caused by the order in which I installed all the necessary drivers. Installing in the order of DBI, DBIx-Recordset, then DBD::Pg seemed to

Re: Fewer rows than expected with DBD-Oracle query

2003-03-21 Thread John Costello
Foo. I hate being a newbie. Again. Thank you, Ronald. I'll go back to the perldoc before asking more questions. --John On Fri, 21 Mar 2003, Ronald J Kimball wrote: > On Fri, Mar 21, 2003 at 02:20:51PM -0800, John Costello wrote: >[snip snip] > > You have not fetched all the rows from the st

Re: Fewer rows than expected with DBD-Oracle query

2003-03-21 Thread Ronald J Kimball
On Fri, Mar 21, 2003 at 02:20:51PM -0800, John Costello wrote: > I have a simple query that, when run via Oracle SQL*Plus returns 38947 > rows. > > If I run the query using Activestate/DBI/DBD, I get 187 rows. Does DBI > buffer results? > > Here is the script, with the original query: > > --

Fewer rows than expected with DBD-Oracle query

2003-03-21 Thread John Costello
I'm running ActiveState Perl 5.6, DBI 1.34, DBD::Oracle 1.06. The database is Oracle 8.1.7, running on an NT 4.0 server. (No budget for an upgrade to W2K or solaris this year. :-/) I have a simple query that, when run via Oracle SQL*Plus returns 38947 rows. If I run the query using Activest

Re: Activestate Perl and DBD-Oracle

2003-03-21 Thread John Costello
What info do you get when you run ActiveState's Perl Package Manager and issue the command search dbd-oracle ? I've got ActiveState Perl 5.6 w/DBI and DBD-Oracle. Not sure if this is a 5.8 specific issue. John --Simon wrote: Hi I have just downloaded the latest version of Acti

Re: undefined subroutine DBD::Pg::db::_login

2003-03-21 Thread Jeffrey Baker
On Fri, Mar 21, 2003 at 01:01:48PM -0800, Richard Schilling wrote: > I am having trouble running Pg version 0.92. I get the error > that DBD::Pg::db::_login is undefined. It is called on about > line 97 in Pg.pm. > > Could not find any explaination in the archives, and didn't > see it address

undefined subroutine DBD::Pg::db::_login

2003-03-21 Thread Richard Schilling
I am having trouble running Pg version 0.92. I get the error that DBD::Pg::db::_login is undefined. It is called on about line 97 in Pg.pm. Could not find any explaination in the archives, and didn't see it addressed in subsequent versions of the Pg driver. Anyone got a clue as to the worka

Re: Oracle 9.2 + Solaris 8 woes..

2003-03-21 Thread Robert Towster
Since I have continued to be unsucessful in getting this working is there someone out there who has gotten it to work that could at least tell me that it will work? Thanks Robert Towster wrote: I am having to deal with several servers that have been using oracle 8 and perl DBI/DBD to connect to t

Re: auto-quoting w/ placeholders and execute() ?

2003-03-21 Thread Rudy Lippan
On Fri, 21 Mar 2003, Hardy Merrill wrote: > > INSERT INTO entry_reference (reference_typeID, entryID, value) > > VALUES ('9', '2118', http://synfin.net/) > > How did you figure out that the 3rd value is NOT being quoted? > Did you use 'trace' to see the query that's actually going to the > d

Re: :ODBC 1.05 on HP. Need help!!!

2003-03-21 Thread Vassiliy Truskov
Hello, Frans. I'm using perl2exe (5.8.0). In case I rebuild perl with pthread, will perl2exe work after that? I found that if I set env LD_PRELOAD=/usr/lib/libpthread.1 it starts working, but of course it is not a good thing to do. I will rebuild perl and try it without perl2exe, but the final p

Re: auto-quoting w/ placeholders and execute() ?

2003-03-21 Thread Hardy Merrill
Aaron Turner [EMAIL PROTECTED] wrote: > > Ok, I'm going crazy with this. I know that if I use placeholders (?) > in my queries, and pass the values via execute() that it's supposed > to automatically call quote() on them. And it does that about 99% > of the time. Of course that 1% is *argh*! >

RE: :ODBC 1.05 on HP. Need help!!!

2003-03-21 Thread Frans . Postma
Your perl was build without the pthread and cl libraries, those should have been at the start of the libs used during compile of perl itself. Rebuild perl, use the following command to configure, it will place two required libraries before any other libs in the library path. That does solve the L

Activestate Perl and DBD-Oracle

2003-03-21 Thread Simon Windsor
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I have just downloaded the latest version of Activestate Perl, for 5.8, and installed DBI by ppm without any problems. However I cannot find a DBD-Oracle ppm or binary install for Win32. Does anyone know where I can get a binary ppm/zip file of

DBI and perlcc

2003-03-21 Thread Thomas Chiverton
Is this still broken ? I have a recent install of perl and DBI/DBD/Oracle and still get the undefined subroutine &DBI::dr::connect error message. Applying the fix from Jan1999/0656.html mearly leads to port.c:33361: conflicting types for `boot_DynaLoader' port.c:11: previous declaration of `boot_D

Regarding DBD::Oracle or DBD::ODBC module download

2003-03-21 Thread Shailaja Valakatte
Hello, I tried to install DBD-Oracle and DBD-ODBC modules using PPM. But it couldnt find those modules on the server itself , so it failed. Could you please let me know from where I can install these modules for Windows 2000? Thanks, Shailaja Valakatte MIS Director Omni Logistics Hackettstown,

auto-quoting w/ placeholders and execute() ?

2003-03-21 Thread Aaron Turner
Ok, I'm going crazy with this. I know that if I use placeholders (?) in my queries, and pass the values via execute() that it's supposed to automatically call quote() on them. And it does that about 99% of the time. Of course that 1% is *argh*! Here's the code: $sth = $dbh->prepare(q{INSERT I

DBD::ODBC 1.05 on HP. Need help!!!

2003-03-21 Thread Vassiliy Truskov
Hello, everybody. I'm trying to build DBD::ODBC 1.05 module on HP. It looks like it was built correctly, but the first test failed with the following error: t/01base/usr/lib/dld.sl: Can't shl_load() a library containing Thread Local Storage: /usr/lib/libc.2 /usr/lib/dld.sl: Exec forma