Re^5: inserting and showing data from an MS Access database

if the row is blank, then i suspect that %FORM is empty/bad .. to verify, do:

use Data::Dumper;
print Dumper \%FORM;
[download]

But yeah, don't parse the data yourself to begin with -- use CGI:

use CGI qw/:standard/;
$sth_ins->execute( param('firstname'), param('lastname'), param('state
+'), param('country') );
[download]

Comment on Re^5: inserting and showing data from an MS Access database Select or Download Code

Replies are listed 'Best First'.
Re^6: inserting and showing data from an MS Access database by Anonymous Monk on Apr 12, 2006 at 22:10 UTC
Hi, when I used `use Daga::Dumper; pring Dumper \%FORM;` [download] It printed $VAR1 = {}; so I guess that means %FORM is empty as you said. I'm off now to see what I can do about this.	[reply] [d/l]
Re^7: inserting and showing data from an MS Access database by Anonymous Monk on Apr 12, 2006 at 22:26 UTC
Oops, I mean Data::Dumper, not Daga::Dumper Also, don't I need to change the `read(STDIN, $buffer, $ENV{'CONTENT_LENGTH'}); @pairs = split(/&/, $buffer); foreach $pair (@pairs) { ($name, $value) = split(/=/, $pair); $value =~ tr/+/ /; $value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("C", hex($1))/eg; $FORM{$name} = $value; }` [download] bit at the top to use `$sth_ins->execute( param('firstname'), param('lastname'), param('state +'), param('country') );` [download] I seem to remember getting errors without adding something else. `my $name = $query->param($FORM{name});` [download] or something like that. I may be wrong about that though.	[reply] [d/l] [select]
Re^8: inserting and showing data from an MS Access database by Anonymous Monk on Apr 12, 2006 at 22:50 UTC
Looks like I don't need to change anything else, it's working perfectly now. Thank you very much for your help. Now it's off to figure out how to sort the data using radio buttons :)	[reply]