Re: Re: Re: Re: CGI or DBI 'cache' problem

here's the problem I encounter
using

my ($s_off_no) = @_;
[download]

I don't seems to be retrieving the value into the variable $s_off_no

and using my original code

my $s_off_no = $s_off_no;
[download]

while i get the value, my query only works one time.
after which, even though I am submitting different query, it is still executing the previous query.

Comment on Re: Re: Re: Re: CGI or DBI 'cache' problem Select or Download Code

Replies are listed 'Best First'.

Re: Re: Re: Re: Re: CGI or DBI 'cache' problem
by grep (Monsignor) on May 13, 2002 at 07:01 UTC

If you are sending the variable through to the sub

queryresult($s_off_no);

then this will work

sub queryresult {
    my ($s_off_no) = @_;
    ## Do stuff
}
[download]

Other than that I would recommend reading my first post and fixing some of those other things I mentioned (at the very least you should use placeholders).

grep
Unix - where you can throw the manual on the keyboard and get a command

[reply]
[d/l]
[select]