[Fwd: Re: [Fwd: Re: [ic] [perl tables=tiers] producing error: Table TIERS not found in databases]]

[Barry Treahy, Jr.]

-------- Original Message --------
Subject: 	Re: [Fwd: Re: [ic] [perl tables=tiers] producing error: Table 
TIERS not found in databases]
Date: 	Tue, 06 Sep 2005 20:28:51 -0700
From: 	Barry Treahy, Jr. <Treahy at MMaz.com>
To: 	interchange-users at icdevgroup.org
References: 	<431E4ADE.9000107 at MMaz.com> <431E51A7.7070601 at sonic.net>



John Young wrote:

> Barry Treahy, Jr. wrote:
>
>> I believe I've isolated the problem.  Withn commonadjust, I reference 
>> a usertag which does a:
>>
>> $sql = "select quantity,discount from tiers where tier='" . $tier ."' 
>> order by code desc"; $results = $Tag->query({ wantarray => 1,sql => 
>> $sql } );
>
>
> This won't matter with regard to your current problem, but you could
> simplify your string -- the single quotes don't affect the interpolation
> of $tier when included within double quotes:
>
> $sql = "select quantity,discount from tiers where tier='$tier' order 
> by code desc";
>
>
>> And it is here that IC is blowing...  Now I'm beginning to remember 
>> that I had to load a module that would allow emulation of SQL for 
>> GDBM databases.  Anyone remember what that module is so that I can 
>> get this loaded?
>
>
>
> I'm not sure... perhaps you're talking about SQL::Statement
> if you aren't running a current version of IC.  Mike coded
> in functionality a few months ago so that SQL::Statement is
> no longer needed.  If you *do* need SQL::Statement, make sure
> it is version SQL-Statement-0.1021 -- later versions did not
> work with IC.

I'm running 4.8.6 and you are right, I'm runing a new 
SQL-Statement...    THanks

Barry

Bingo!  That was it!!!   Thanks John!

Barry



-- 

Barry Treahy, Jr                     E-mail: Treahy at MMaz.com
Midwest Microwave, Inc.                  Phone: 480/314-1320
Vice President/CIO                        FAX:  480/661-7028

                      ... but it's a DRY HEAT!                          





-- 

Barry Treahy, Jr                     E-mail: Treahy at MMaz.com
Midwest Microwave, Inc.                  Phone: 480/314-1320
Vice President/CIO                        FAX:  480/661-7028

                       ... but it's a DRY HEAT!