I finally got the following few lines of code to work:
$userdb=$feilds{'user'};
$rows=$dbh->do
("INSERT INTO bandbook (user, ect, ect, ...)
VALUES (?,?,?,?,?,?,?)", undef, $userdb,
'ect', 'ect', ....)
|| die "fucked up inserting data: $DBI::errstr";
print "$rows row(s) added to bandbook\n";
I must admit that I don't understand the purpose of
the ?'s but after many hours of debugging, I'm not
complaining.
--- Jason Wong <[EMAIL PROTECTED]> wrote:
> On Saturday 03 November 2001 04:26, paco anubis
> wrote:
>
> > Hello,
> > I started learning Perl 4 weeks ago and mysql 3
> days
> > ago so I know that I am in over my head, but here
> goes
> > nothing. I am trying to build a Perl CGI
> application
> > (using DBI) to pass form contents from a web page
> > directly into a MySql database.
> > I don't know how to pass the Perl variable from
> the
> > form into the database. I tried to assign the
> value
> > using the following code (where "$feilds{user}" is
> the
> > Perl variable to pass):
> >
> > $userdb=$dbh->($feilds{user});
> >
> > $rows=$dbh->do
> > ("INSERT INTO bandbook (user, ect, ect...)
> > VALUES ($userdb, 'ect', 'ect',
> ...)")
> >
> > || die "fucked up inserting data: $DBI::errstr";
> >
> > print "$rows row succesfully added to bandbook\n";
> >
> >
> > As you may have guessed the table, bandbook is
> still
> > empty because the script always dies. Can anyone
> point
> > me in a better direction. Due to my unfamiliarity
> with
> > either language, I am definately not ruling out a
> > syntax error.
>
> It's good practice to assign your SQL query to a
> variable which you can
> then print out for debugging purposes. It also
> allows you to copy and
> paste that query into mysql directly and see what
> results it yields.
>
> I think your problem is that you haven't quoted the
> VALUES that you're
> inserting. Try:
>
> $QRY = "INSERT INTO bandbook (user, ect1, ect2...)
> VALUES ('$userdb', '$ect1', '$ect2', ...)";
> print("$QRY"); ## For debugging
> $rows=$dbh->do($QRY) || die "Error";
>
>
>
> hth
> --
> Jason Wong
> Gremlins Associates
> www.gremlins.com.hk
>
>
---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list
> archive)
>
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>
__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
