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. > Pr

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 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; >

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->prep