FAQ

Perl > dbi-users > July 2002

Search Discussions

214 discussions - 576 posts

  • I have a cgi query form where the user selects a date range to get data from. I used SYSDATE as a means of inserting the date/time stamp into the table. But the user will be entering the dates like: ...
    Kipp, JamesKipp, James
    Jul 25, 2002 at 2:43 pm
    Jul 29, 2002 at 2:43 pm
  • A little help, please. I "inherited" a project a little while ago, and thus have been forcibly initiated into perl and DBI with code that I did not originally author, but must maintain and upgrade ...
    StranglerwStranglerw
    Jul 24, 2002 at 7:19 pm
    Jul 29, 2002 at 1:37 pm
  • The uploaded file DBI_AdvancedTalk_2002.tar.gz has entered CPAN as file: $CPAN/authors/id/T/TI/TIMB/DBI_AdvancedTalk_2002.tar.gz size: 2492561 bytes md5: f89d88150d7156afb25a7b8816f3052b No action is ...
    PAUSEPAUSE
    Jul 19, 2002 at 8:52 pm
    Jul 29, 2002 at 1:09 pm
  • Thanks, I've received and installed DBD::ODBC 0.45_4. But it causes at least one new problem: I'm making a call to a stored procedure that returns a result via a SELECT, and I'm fetching that result ...
    Joe TebelskisJoe Tebelskis
    Jul 23, 2002 at 7:04 am
    Jul 25, 2002 at 11:02 am
  • I'm not sure exactly where the problems lie, but the symptoms are that when I try to use methods like selectrow_array() and selectrow_arrayref(), I get an error failing on calling prepare() on an ...
    Philip MolterPhilip Molter
    Jul 16, 2002 at 8:37 pm
    Jul 18, 2002 at 7:51 am
  • I'm trying to install DBD::CSV, however I'm getting a core dump in t/40blobs.t and a failed test in t/ak-dbd.t. I've searched the archives, and nothing seems relevent. I'm using perl v5.6.1 built for ...
    Steve PinerSteve Piner
    Jul 5, 2002 at 2:02 am
    Jul 8, 2002 at 12:54 pm
  • Dear, A friend recommended me this white paper: http://www.ambysoft.com/persistenceLayer.html The Author suggests to implement what he called "Robust Persistence Layer" between "Business Classes" and ...
    NYIMI Jose (BMB)NYIMI Jose (BMB)
    Jul 31, 2002 at 7:26 am
    Aug 5, 2002 at 1:57 am
  • Hi, Does any one got the DBD::AnyData working in Windows 2000 Server... I am just curious because I couldn't make it working in my windows system which has active perl running in it. Thanks, Raghu ...
    Raghu KaramelRaghu Karamel
    Jul 13, 2002 at 10:29 pm
    Jul 16, 2002 at 4:44 am
  • I'm currently working on a perl CGI script that queries a database that logs events about machines in our computer labs. Unfortunately, the query causes the script to crash & produce a coredump ...
    David CoulthartDavid Coulthart
    Jul 22, 2002 at 8:28 pm
    Jul 23, 2002 at 4:13 am
  • Hi, I'm currently writing a Perl script which insert lots of data into a database. When I insert a row in a table, I need to get the PRIMARY KEY which has been affected to this table, because I will ...
    PETAZZONI,THOMAS (Non-HP-Germany,ex1)PETAZZONI,THOMAS (Non-HP-Germany,ex1)
    Jul 19, 2002 at 7:05 am
    Aug 5, 2002 at 2:00 am
  • How can I ouput sql query results as xml ?. Is there something like xsql to use on the command line or put in a perl program that currently connects to database,does the query and outputs results as ...
    Kairam, RajKairam, Raj
    Jul 31, 2002 at 6:55 pm
    Aug 1, 2002 at 9:18 pm
  • hi guys, i got something like that: $sth = $dbh- prepare("select id,zone from location order by id"); $sth = $dbh- execute(); now the result should be returned - on the web page combo box - like ...
    Hytham ShehabHytham Shehab
    Jul 25, 2002 at 3:24 pm
    Jul 25, 2002 at 8:26 pm
  • A quick question regarding numeric formatting and SQL Server 2000. I have a view set up that has an integer field of length 4. When I fetch the data, instead of seeing values such as '1024' as it is ...
    Jim ClarkJim Clark
    Jul 23, 2002 at 1:03 am
    Jul 24, 2002 at 7:27 pm
  • Thanks, Jeff. I've installed DBD::ODBC version 0.43, and it seems to have fixed the problem of memory access violation on exit. However: (1) I was hoping that the new version would also fix another ...
    Joe TebelskisJoe Tebelskis
    Jul 19, 2002 at 3:18 am
    Jul 23, 2002 at 2:12 am
  • Althaugh Im not subscribed to this list I was wanted to add to this thread that I had the exact same problem (t\general....ok 9/17Can't call method "prepare" ) on a Linux machine (x86 RedHat 6.1) ...
    Stéphane PeiryStéphane Peiry
    Jul 17, 2002 at 2:13 pm
    Jul 17, 2002 at 9:30 pm
  • file: $CPAN/authors/id/T/TI/TIMB/DBI-1.29.tar.gz size: 256485 bytes md5: 1811579779bf790e7db5879d302bf4f6 =head2 Changes in DBI 1.29, 15th July 2002 NOTE: This release changes the specified behaviour ...
    Tim BunceTim Bunce
    Jul 15, 2002 at 11:51 am
    Jul 16, 2002 at 9:20 pm
  • HI, I am running perl 5.00503 on a SCO UnixWare 7.1.1 box with Oracle 8.16 installed. I am using DBI version 1.21 and DBD::Oracle Version 1.12 to connect to the database. What I am trying to do is to ...
    Hapworth, AdamHapworth, Adam
    Jul 1, 2002 at 2:20 pm
    Jul 2, 2002 at 9:13 pm
  • I have a stored procedure in oracle accepting array as an input parameter and array as an output parameter. how to call this procedure thru perl DBI calls.any help at the earliest will be ...
    Sundarraj, Senthil Kumar (Cognizant)Sundarraj, Senthil Kumar (Cognizant)
    Jul 26, 2002 at 5:30 am
    Aug 22, 2002 at 8:19 am
  • I'm trying to insert into a table where only 3 fields (1 being the primary key) are required, yet I get the following error when I execute: --------------- Died while executing: [Microsoft][ODBC ...
    Nick Hoffman [UWO]Nick Hoffman [UWO]
    Jul 30, 2002 at 7:16 pm
    Jul 30, 2002 at 8:58 pm
  • 5

    DBI

    I am running the latest version of DBI/DBD. A simple question. I compile DBI against Oracle 9. If I try to connect to a database with the ORACLE_HOME set to Oracle 8 it doesn't work. I ran truss on ...
    Adam B. EdwardsAdam B. Edwards
    Jul 12, 2002 at 3:48 pm
    Jul 27, 2002 at 9:18 pm
  • Hi, I am getting the following error when I use the blob_read() function. Does anyone know what is the solution for this? I don't want to use the "LongReadLen" attribute to specify the maximum size ...
    Raghu KaramelRaghu Karamel
    Jul 24, 2002 at 6:51 pm
    Jul 26, 2002 at 5:19 pm
  • I am working on a development server right now and am ready to migrate to the production box. I have written a script that exports the data stored in tables to xml files but I'm having trouble ...
    Brad FikeBrad Fike
    Jul 24, 2002 at 10:23 pm
    Jul 25, 2002 at 11:37 pm
  • Under DBI-1.21, the following DBD's built with no errors: DBD-Oracle-1.12 DBD-Sybase-0.94 DBD-CSV-0.2002 After installing DBI-1.29 this morning, Sybase and CSV re-built, Oracle did not. Since 1.21 to ...
    PersicomPersicom
    Jul 15, 2002 at 3:23 pm
    Jul 16, 2002 at 11:10 pm
  • Hello, I am currently attempting to read data from a text file that contains 1 column of numbers, use each record that was read to query a database. However, (depending Upon how the code is written) ...
    Dana LucentDana Lucent
    Jul 9, 2002 at 1:41 pm
    Jul 9, 2002 at 2:55 pm
  • I just tried to prepare/execute/fetch results for the following a dbcc call in MS SQL Server. I get an error stating that there is no select statement running--which is true. Is there a mechanism for ...
    Accardo, GlenAccardo, Glen
    Jul 3, 2002 at 4:29 pm
    Aug 5, 2002 at 12:54 am
  • For those following the thread, thought you might be interested in the results: This does not work: my $sth = $dbh- prepare(" SELECT * FROM stats WHERE sdate BETWEEN trunc($fromDate) AND ...
    Kipp, JamesKipp, James
    Jul 26, 2002 at 5:02 pm
    Jul 26, 2002 at 6:50 pm
  • My table has a DATE field which contains DATE/TIME info. A general select in sqlplus returns DATE/TIME, but the same select in perl only returns the DATE. It is critical that I get the TIME ...
    ScdardenScdarden
    Jul 26, 2002 at 3:50 pm
    Jul 26, 2002 at 5:34 pm
  • When I unwittingly try to bind an undef value, it says: Can't bind non-scalar value (currently) That tends to make one think an aref bind was attempted (at least it did for me!). It might be more ...
    Phil R LawrencePhil R Lawrence
    Jul 10, 2002 at 3:17 pm
    Jul 11, 2002 at 10:17 pm
  • Well -- just doing a simple test connect and disconnect eat up nearly 1,000 items (multiple connects and disconnects have no effect on the qty of items eaten, at this point -- so, I'm "guessing" that ...
    Jeff UrlwinJeff Urlwin
    Jul 30, 2002 at 11:04 pm
    Aug 1, 2002 at 10:21 am
  • Not sure if this question belongs on this list or the CGI list, but here goes: I have a checkbox that passes the selected 'hosts' to my CGI script. So i collected the params with: my @hosts = $q- ...
    Kipp, JamesKipp, James
    Jul 31, 2002 at 2:03 pm
    Jul 31, 2002 at 5:41 pm
  • Hello, Is there anyway to specify the rollback segment to use in Oracle via the DBD::Oracle module? I did not see anything in the DBD::Oracle or DBI perldocs other than the begin_work DBH Object ...
    Guidarelli, JohnGuidarelli, John
    Jul 30, 2002 at 7:51 pm
    Jul 30, 2002 at 9:07 pm
  • It's supposed to be corrected in 0.45_8. Can you shrink it down to a reasonably small sample with any create table, create procedure, etc at the top of the script? Joe Tebelskis supplied a nice one ...
    Jeff UrlwinJeff Urlwin
    Jul 29, 2002 at 3:49 pm
    Jul 30, 2002 at 12:31 pm
  • Hi, I'm using DBI with mysql. Here's what I'm doing. <code use strict; use DBI; my $sqlhost='localhost'; my $sqluser='username'; my $sqlpass='password'; my $sqldb='database'; my $statement=qq{select ...
    Reid SutherlandReid Sutherland
    Jul 26, 2002 at 8:13 pm
    Jul 26, 2002 at 9:43 pm
  • Is there any work being done to support the use of multiple tables in a single SQL statement? The project I am working on has established code that uses DBI to access a postgres DB for information. ...
    Jim BlomoJim Blomo
    Jul 24, 2002 at 1:02 am
    Jul 25, 2002 at 11:38 pm
  • I am having a problem that I have seen others are having but I have not found a solution yet. When I try to load DBD::pg I get the following error: install_driver(Pg) failed: Can't locate loadable ...
    Harvey CaryHarvey Cary
    Jul 25, 2002 at 5:01 pm
    Jul 25, 2002 at 7:39 pm
  • Here is a script that exercises another bug in DBD::ODBC 0.45_4. It creates two tables (table1, table2) and a stored procedure (proc1) that simply inserts a value into table1. If you execute proc1, ...
    Joe TebelskisJoe Tebelskis
    Jul 25, 2002 at 12:56 am
    Jul 25, 2002 at 10:17 am
  • Hello all, After learning basic perl programming, i learnt DBI, LDAP by getting some help from this user group. It was always been helpfull for me. So, though this is DBI group, i thought to catch u ...
    Ajay KumarAjay Kumar
    Jul 24, 2002 at 6:33 pm
    Jul 24, 2002 at 7:52 pm
  • Hello, I am trying to connect to a Sybase database via DBI for the first time and am getting the error below. Thanks in advance for any help, Jim (dialog) perl.exe - Entry Point Not Found The ...
    Jim SilversteinJim Silverstein
    Jul 19, 2002 at 7:45 pm
    Jul 22, 2002 at 4:44 pm
  • Dear All, I have configured and run a proxyserver connecting to an oracle DB. It successfully blocks IP's and usernames, and returns correct select and insert statements. My question is about the SQL ...
    Glen MurasGlen Muras
    Jul 15, 2002 at 5:22 am
    Jul 16, 2002 at 1:26 pm
  • Hi, When accessing CSV with AnyData as a tie hash, I found that although the C<while (my $row = each %$table) syntax is valuable, it C<last as soon as I try to modify the table inside the loop, for ...
    Pomin WuPomin Wu
    Jul 11, 2002 at 8:01 pm
    Jul 12, 2002 at 4:29 pm
  • Hello, I'm having the following problem using DBI. My perl version is 5.005, and Oracle.pm version is 1.47. Can you help? Samir -----------------CGI script------------------------ use DBI; use CGI; ...
    Kakli, Samir (S.A.)Kakli, Samir (S.A.)
    Jul 9, 2002 at 1:04 pm
    Jul 10, 2002 at 10:32 pm
  • Is there any way to use DBI to move data in TeleMagic Database [DOS based v14.5] (dBase III+ compatible data file structures) to MS Access? What DBDs do I need? Can anyone provide a skeleton for ...
    PARLEY,JON (HP-MountainView,ex1)PARLEY,JON (HP-MountainView,ex1)
    Jul 8, 2002 at 10:03 pm
    Jul 10, 2002 at 12:46 pm
  • Is the column_info command supported in the 0.76 release of the DBI for Perl? We are trying to get our developers to use the DESCRIBE INPUT when coding for parameter markers and they the release they ...
    Cioffi, James [IT]Cioffi, James [IT]
    Jul 8, 2002 at 5:40 pm
    Jul 8, 2002 at 8:33 pm
  • Can anyone assist on the following problem please? marlin:/home/jz26xf/DBD-Oracle-1.12 # make test cp ora_explain blib/script/ora_explain /usr/bin/perl -I/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0 ...
    Carson, JimCarson, Jim
    Jul 3, 2002 at 2:59 pm
    Jul 5, 2002 at 11:48 am
  • Hi all. Using DBI 1.28 and DBD::Oracle 1.12 compiled against Oracle 8.1.7, I have the following: use strict; use DBI; $text = "This is a test.\n"x6000; $sth = $dbh- prepare(qq{ DECLARE next NUMBER; ...
    Stacy MaderStacy Mader
    Jul 1, 2002 at 1:52 am
    Jul 2, 2002 at 1:30 am
  • hi there , can someone please tell me what's wrong and how can i fix it . thanks in advance .
    Koh koonbeeKoh koonbee
    Jul 26, 2002 at 6:43 am
    Jul 30, 2002 at 8:49 pm
  • Hello All, I'm not completely sure this is the right place to ask... so if it isn't please point me in the right direction and I do admit I'm a little new at this so I apologize in advance for any ...
    Matt NeimeyerMatt Neimeyer
    Jul 26, 2002 at 8:13 pm
    Jul 26, 2002 at 9:14 pm
  • Jeff; I'm using DBI v1.30 and DBD-ODBC v0.43. My database app is invoked about 40,000 times over the course of about 2 days to generate test scripts for some automated test equipment. I've been ...
    Gary GauthierGary Gauthier
    Jul 26, 2002 at 12:37 pm
    Jul 26, 2002 at 1:52 pm
  • Teradata Support?Forwarded to DBI-users. -----Original Message----- From: Simpson, Paul Sent: Thursday, July 25, 2002 9:15 AM To: 'jurlwin@bellatlantic.net' Subject: Teradata Support? Are you aware ...
    Jeff UrlwinJeff Urlwin
    Jul 25, 2002 at 3:36 pm
    Jul 25, 2002 at 4:21 pm
  • Can anyone help identify why following code block will fetch only one row when csv_tables- {skip_rows} is set to 0? A solution for this will go a long way toward solving a more complex scenario I'm ...
    Andrew CrumAndrew Crum
    Jul 24, 2002 at 10:15 pm
    Jul 25, 2002 at 1:33 am
Jul 2002
12345
Group Navigation
period‹ prev | Jul 2002 | next ›
Group Overview
groupdbi-users @
categoriesperl
discussions214
posts576
users216
websitedbi.perl.org

216 users for July 2002

Tim Bunce: 45 posts Michael A Chase: 38 posts Jeff Urlwin: 37 posts Kipp, James: 21 posts Jeff Zucker: 16 posts Joe Tebelskis: 12 posts Hardy Merrill: 10 posts Bart Lateur: 9 posts Raghu Karamel: 9 posts Stranglerw: 7 posts Hapworth, Adam: 7 posts Paul DuBois: 7 posts Philip Molter: 7 posts Ronald J Kimball: 7 posts Martin: 6 posts Andy Lester: 6 posts Gary Gauthier: 6 posts Matthew O. Persico: 6 posts Nick Hoffman [UWO]: 6 posts Christopher G Tantalo: 5 posts
show more
Archives