Re: SOT: dereference(?) a single row (fetchall_arrayref)

2002-12-24 Thread Tkil
> "Roderick" == Roderick A Anderson <[EMAIL PROTECTED]> writes: [from previous message] Roderick> The problem I'm having is how to do in a one-liner the Roderick> equivalent of this. Getting the the $domainname_key out of Roderick> the arrayref $domain_array. Roderick> foreach my $row (@$do

Re: SOT: dereference(?) a single row (fetchall_arrayref)

2002-12-24 Thread Roderick A. Anderson
On Tue, 24 Dec 2002, Michael A Chase wrote: Over zealous white space removal and too quick of fingers when replacing. Originally it was a copy paste. > That should be a '}'. > > foreach my $row (@$domain_array) { ($domainname_key, $jnk) = @$row; } So there is no way to do it without the forea

Re: SOT: dereference(?) a single row (fetchall_arrayref)

2002-12-24 Thread Michael A Chase
On Tue, 24 Dec 2002 14:04:45 -0800 (PST) "Roderick A. Anderson" <[EMAIL PROTECTED]> wrote: > This is probably off topic but I'm hoping only slightly so. I have a > script that may select zero or more rows. (I asked here and got some help > with checking the count and that works quite nice.) >

SOT: dereference(?) a single row (fetchall_arrayref)

2002-12-24 Thread Roderick A. Anderson
This is probably off topic but I'm hoping only slightly so. I have a script that may select zero or more rows. (I asked here and got some help with checking the count and that works quite nice.) If there are no rows returned do one thing, if many rows are returned offer a selection list, and

Re: Small Footprint Database

2002-12-24 Thread Bob X
"Ilya Sterin" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > This is the wrong list to ask this question. This list is for topics > related to DBI (Perl's database interface) API issues. > > Thanks for the understanding. > > Ilya > Oooops...very sorry. Bob

RE: Small Footprint Database

2002-12-24 Thread Sterin, Ilya
This is the wrong list to ask this question. This list is for topics related to DBI (Perl's database interface) API issues. Thanks for the understanding. Ilya -Original Message- From: Bob X [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 24, 2002 2:24 PM To: [EMAIL PROTECTED] Subject

Small Footprint Database

2002-12-24 Thread Bob X
What are the options for a good small footprint database...on Windows (XP). Bob

Re: DBD::ODBC fails during make

2002-12-24 Thread Michael A Chase
On Mon, 23 Dec 2002 16:36:09 -0600 "Davis, Jo" <[EMAIL PROTECTED]> wrote: > I have found a couple of hits in this mailing list that have the same > problem that I am having but those threads do not seem to include the > resolution. > I am trying to install DBD::ODBC on a SunOS 5.6 server. I had

Re: Problem with login as sysdba in DBI/DBD::Oracle

2002-12-24 Thread Jared Still
The problem you are having is most likely due to your use of v$session_connect_info. Getting your own sessions SID and using it to choose the correct row from v$session_connect_info is notoriously tricky. Try doing this instead: my $sql=q{select sys_context('userenv', 'authentication_type') aut

RE: Help with connecting two tables.

2002-12-24 Thread Jean-Claude Girard
Hi Chris, What you are trying to do is an outer join, meaning that you want to join the two tables on field1, but you want to get all of the records from table 1 even if no row from table2 matches. You can check the MySQL doc for this, as the MySQL syntax is not too familiar to me, but I think i

Help with connecting two tables.

2002-12-24 Thread Chris Rogers
I am using mysql version 3.23.41 and perl version 5.6.1-26.72.3 with perl-DBI version 1.18-1. I'm having trouble putting together a statement that will get specific fields from all the records in table1 and all the fields from table2 where certain fields match the first table. My problem is that

Urget Help regarding DBD needed

2002-12-24 Thread Vuppaladhadiam, Rajasekhar (Cognizant)
Hi all   I have a requirement like this:   1. There is a XML File which is being opened and read from a perl script.2. The perl script combines all the XML file contents into one string.3. Using Compress::Zlib, this XML string is compressed into a data variable, say $xml_object (now it is a c

Re: [OT] SQL console for MSSQL

2002-12-24 Thread K. Brian Kelley
The MS SQL Server client tools install on any build from 9x up and from NT 4.0 up (two different paths). Win2K and XP are part of the NT kernel line. Enterprise Manager is okay, but it's a lot of overhead. You'll probably want to use Query Analyzer (isqlw.exe). It's GUI, but it's easier to use than

DBD::ODBC fails during make

2002-12-24 Thread Davis, Jo
I have found a couple of hits in this mailing list that have the same problem that I am having but those threads do not seem to include the resolution. I am trying to install DBD::ODBC on a SunOS 5.6 server. I had no problems installing the DBI or the manager. The perl Makefile.PL appears to ru

RE: Stored Procedures with DBD::Sybase and FreeTDS

2002-12-24 Thread RWilbert
Thanks I will also ask on the FreeTDS mailing list. Here is a log of what happens when I execute the stored procedure. I just do a select and insert and select to so that I can insert into the database. I was not sure if it was an issue with freetds or DBD::Sybase. I should also note the procedur