Gossamer Forum
Home : Products : DBMan SQL : Discussion :

small db.cgi MOD

Quote Reply
small db.cgi MOD
I have successfully added a few fields to the user table of my database through the HTML and the db.cgi, however, I can't quite get the date to pass through. I've tried numerous variations in the sub signup():

my $dbh = DBI->connect (@db_connect) or &cgierr ("Connection Error. Reason: " . $DBI::errstr . "\n.");
my $username_q = $dbh->quote($in{'userid'});
my $password_q = $dbh->quote($in{'pw'});
my $firstname_q = $dbh->quote($in{'firstname'});
my $lastname_q = $dbh->quote($in{'lastname'});
my $country_q = $dbh->quote($in{'country'});
my $date_q =&get_date;

This was my latest one....any ideas? I have the field in the table and I have it defined as a date. The $date_q is what the SQL passes to the table in the INSERT line.

Thanks