-------- 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. <suppressed> To: suppressed References: <suppressed> <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 Bingo! That was it!!! Thanks John! Barry -- 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!
-- 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
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.