Re: DBI prepare syntax

2007-11-08 Thread Mike
That was a rookie mistake :). Double quotes works, thanks Beginner! Beginner [EMAIL PROTECTED] wrote: On 8 Nov 2007 at 8:59, Mike wrote: Hi, #Update override_exclude set th_flag=N to indicate that thesaurus entries #have been added to sierra2_thesaurus.xml use DBI; my

Re: DBI prepare syntax

2007-11-08 Thread Douglas Hunter
Mike wrote: Hi, I have a variable setup as $pid and i've tried to call this in the prepare part of the DBI module but i'm get an Unknown column $pid syntax error. Probably $pid was passed as a string instead of a variable inside the prepare (''). Anyone has an idea of how i can fix this?

Re: DBI prepare syntax

2007-11-08 Thread Beginner
On 8 Nov 2007 at 8:59, Mike wrote: Hi, #Update override_exclude set th_flag=N to indicate that thesaurus entries #have been added to sierra2_thesaurus.xml use DBI; my $dbh = DBI-connect(dbi:mysql:endeca_tracking,$user,$password); my $sth = $dbh-prepare('update

Re: DBI prepare syntax

2007-11-08 Thread Mike
Perl is Awsome! Thanks for explaining that basic concept to me Douglas! Douglas Hunter [EMAIL PROTECTED] wrote: Mike wrote: Hi, I have a variable setup as $pid and i've tried to call this in the prepare part of the DBI module but i'm get an Unknown column $pid syntax error. Probably