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

["Barry Treahy, Jr." <suppressed>]

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
> suppressed
> http://www.icdevgroup.org/mailman/listinfo/interchange-users

--

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

                      ... but it's a DRY HEAT!                          


_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users