You wouldn't by any chance be calling it $pid in one place and $position_id in another?
DARFC, GStC. -----Original Message----- From: Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 2:49 PM To: beginners-cgi@perl.org Subject: bind values and cgi params I have a form that is submitting and the url ending is "?position=BSIPL". My form has "method="get"" in it. I have tried it without a method as well. I have in my CGI: my $pid = $q->param('position'); # which should now hold BSIPL right? My SQL is as so: my $sth = $dbh->prepare(" SELECT position_id, dstrct_code, authty_type, authty_given, authty_sevrty, authty_rule, authty_low_lim, orig_ctl_flag, authty_upp_lim FROM msf872 WHERE position_id = ? "); $sth->execute($pid); I run the CGI through "perl -cw" as well as having "use strict" and "use warnings". I get no errors but I also get no data back when there is data. Any suggestions? Robert -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response> -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
