It would be nice to see your embperl.log file
(probably automatically written to /tmp/embperl.log)
Also, what error messages are you getting?
Finally, use Data::Dumper and print out the form data
that you think exists like this:
[+ use Data::Dumper;
Data::Dumper->Dump([\%fdat],['fdat']);
+]
then you will know what is passed.
And of course, instead of using DBI, you might take
alook at Gerald's DBIx::Recordset, his companion
product to HTML::Embperl. You can read more about it
about
http://perl/apache.org/embperl --- "Henrickson, Diana" <DHenrickson@vignette.com>
wrote:
> I realize this may be a silly question but I cannot
> get this to work. I'm
> trying to pass form variables into a database using
> DBD::DB2..
>
> $sth = $dbh -> prepare ("INSERT INTO
> USERDATA(FIRST_NAME)
> VALUES($fdat{cgifirst})") or die "Cannot INSERT to
> '$table'" ;
>
>
> Is there a different way I need to reference my
> variables?
>
> Any help is much appreciated.
>
> --Diana
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> embperl-unsubscribe@perl.apache.org
> For additional commands, e-mail:
> embperl-help@perl.apache.org
>
=====
Terrence Brannon
90 St. Mark's Place
Apt. 2E North
Staten Island, NY 10301
914-755-4360
__________________________________________________
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com