Perl ODBC complex query example needed

From: samregen (samregen_at_aol.com)
Date: 03/22/05 

Date: 21 Mar 2005 15:01:09 -0800

Hi,

I cannot find any examples of how to issue a multi-tabe query using
perl ODBC methods.

I am currently writing a perl script to issue queries generically, but
I have no reference examples for queries against multiple tables.

Specifically, I am used to using the form shown below, where a spcific
sql connection is in scope for the query. My quer spans connections,
so I am not sure how to approach this problem.

 #Next we can issue the SQL statement and trap on warnings if it fails
 if ($db{1}{connection}->Sql($passed_sql_statement)) {
  my ($err) = $db{1}{connection}->Error;
  warn "SQL() Error\n";
  warn "\t\$passed_sql_statement: $passed_sql_statement\n";
  warn "\t\$err: $err\n";
  $db{1}{connection}->DumpData();
  warn "\nThe problem SQL statment was: \n$passed_sql_statement\n";
  warn "\n\n";
 } else {
  print STDERR "The statement \"$passed_sql_statement\" \nran
successfully\n\n";
 }

I have been digging in the bit mines for 5 hours looking for examples
for this sort of query, but nothing out there shows the use of ODBC
methods.

Thanks to anyone who can help.

Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • How do I do Paging through a large dataset via Stored Procedures
    ... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Populating a list -- learning Access
    ... It is kinda funny -- I started using databases in the early 80's with dBase and, for years, never knew that I knew SQL! ... If you are on a form or report, the most important property is the NAME, because that is how you refer to it in code. ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)
  • Re: Populating a list -- table structure?
    ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... I have one report complete, ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)