Re: Database insertion, escape issue

2007-06-14 Thread Northstardomus
On Jun 14, 6:59 am, [EMAIL PROTECTED] (Jenda Krynicky) wrote: > From: Northstardomus <[EMAIL PROTECTED]> > > > ... > > $dbh->prepare('INSERT INTO area_status (areaID, survey_date, > > update_time, status ) VALUES (?,?,?,?)'); > > $db

Re: Database insertion, escape issue

2007-06-13 Thread Northstardomus
On Jun 12, 6:34 pm, [EMAIL PROTECTED] (Chas Owens) wrote: > On 6/12/07, Northstardomus <[EMAIL PROTECTED]> wrote: > snip> $dbh->prepare('INSERT INTO area_status (areaID, survey_date, > > update_time, status ) VALUES (?,?,?,?)'); > >

Re: Database insertion, escape issue

2007-06-12 Thread Northstardomus
On Jun 12, 8:48 am, [EMAIL PROTECTED] (Jenda Krynicky) wrote: > From: "Mumia W." <[EMAIL PROTECTED]> > > > On 06/11/2007 06:52 PM, Northstardomus wrote: > > > [...] > > > print "Inserting into Database , @values."; > > > U

Re: Database insertion, escape issue

2007-06-12 Thread Northstardomus
On Jun 12, 4:59 am, [EMAIL PROTECTED] (Tom Allison) wrote: > On Jun 11, 2007, at 7:52 PM, Northstardomus wrote: > > > > > > > > > I have a Perl script where I try to strip some data from a web page > > and insert it > > > into a database. I'

Re: Database insertion, escape issue

2007-06-12 Thread Northstardomus
On Jun 12, 8:48 am, [EMAIL PROTECTED] (Jenda Krynicky) wrote: > From: "Mumia W." <[EMAIL PROTECTED]> > > > On 06/11/2007 06:52 PM, Northstardomus wrote: > > > [...] > > > print "Inserting into Database , @values."; > > > U

Database insertion, escape issue

2007-06-12 Thread Northstardomus
I have a Perl script where I try to strip some data from a web page and insert it into a database. I'm having a problem where, it seems like the method of quoting the data for insertion don't seem to be working (as far as escaping the text) and some of the text is ending up getting injected int