Re: SQL Syntax error in DBI::Informix

What's the value of $table? From: "paul@conxsysinc.com" <paul@conxsysinc.com> > >My script connects with the Informix DB server, but it doesn't like my >INSERT >statement (below). This code below is supposed to store a new user into >a database. > >print "DEBUG: OK, so we are adding $userd with password > $passd and server $host at port $port\\n"; >my $sth = $dbh->prepare(" > INSERT INTO $table > VALUES ($userd, $passd, $host, $port) > ") > or die "Can't prepare SQL statement to INSERT data\\n"; > >The error message it gives is: >DBD::Informix::db prepare failed: SQL: -201: A syntax error has >occurred. at >./adduser line 53. > >(and yes, I know I should change the name, but later). This is not a >program where >users are added to the System with accounts. It is for a different >service. > >If anyone can help, thanks a lot > >Paul King > > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com