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

Barry Treahy, Jr. Treahy at MMaz.com
Tue Sep 6 23:28:51 EDT 2005


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

>
>
> HTH,
> John Young
>
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
>

-- 

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!                          




More information about the interchange-users mailing list