AW: searching database on emailaddress field

2006-01-30 Thread Renee Backer
Hi Luke, you should have a look at the "Placeholder and Bind Values" section in the DBI documentation: http://search.cpan.org/~timb/DBI-1.50/DBI.pm#Placeholders_and_Bind_Values regards, Renee -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 3

AW: need help to know the column names and data types

2005-10-02 Thread Renee Backer
my ($sth) = $dbh->column_info(undef,undef,$tablename,'%') or die $dbh->errstr(); while(my $row = $sth->fetchrow_hashref()){ print "Name: ",$row->{COLUMN_NAME},"\tType: ",$row->{TYPE_NAME},"\n"; } -Ursprungliche Nachricht- Von: Umesh Barik [mailto:[EMAIL PROTECTED] Gesendet: Frei