...

View Full Version : Help with CGI & SQL Statement



eeijlar
06-12-2007, 05:13 PM
Hi,

Why can't I do this in a CGI script?

select distinct CY_CYCLE from IT_DEV_$queryRelease_TESTING_DB;

$queryRelease is set to 'Release 10' earlier in the code. Perl complains about this with:

Global symbol "$queryRelease_TESTING_DB" requires explicit package name at line 83

FishMonger
06-12-2007, 05:24 PM
select distinct CY_CYCLE from IT_DEV_${queryRelease}_TESTING_DB;

eeijlar
06-12-2007, 06:05 PM
Great! It works. Thanks fishmonger!

/J



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum