Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Feb 2006
    Posts
    61
    Thanks
    11
    Thanked 0 Times in 0 Posts

    Help with CGI & SQL Statement

    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

  • #2
    Super Moderator
    Join Date
    May 2005
    Location
    Southern tip of Silicon Valley
    Posts
    2,871
    Thanks
    2
    Thanked 164 Times in 159 Posts
    select distinct CY_CYCLE from IT_DEV_${queryRelease}_TESTING_DB;

  • #3
    New Coder
    Join Date
    Feb 2006
    Posts
    61
    Thanks
    11
    Thanked 0 Times in 0 Posts
    Great! It works. Thanks fishmonger!

    /J


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •