Re: Think there is something DBI

2001-07-18 Thread borakovej
ght,$subjectarea_1,$s ubjectarea_2,$subjectarea_3,$subjectarea_4,$subjectarea_5,$subjectarea_6,$ho w_heard,$Occupation)`; my $sth= "$SQL_UP"; $str= $dbh->quote($sth); print $str; exit; - Original Message - From: "David Wood" <[EMAIL PROTECTED]> To: "borak

Re: Think there is something DBI

2001-07-18 Thread borakovej
27;,'$zip2','$inst','$school_type','$ grades_taught','$subjectarea_1','$subjectarea_2','$subjectarea_3','$subjecta rea_4','$subjectarea_5','$subjectarea_6','$how_heard','$Occupation'

Think there is something DBI

2001-07-18 Thread borakovej
OK here is an overview of my problem, I am running a script to take a pipe delimited flat file and pump the data into a database. Due to the users putting extraneous apostrophes I am getting errors that there are unclosed apostrophes in the fields. I am looking for a way to escape these apostro