On 6/16/05, Gerber, Christopher J <[EMAIL PROTECTED]> wrote:
> -----Original Message-----
> > Error Message.
> >
> > Missing SearchCondCh value
> > New Search Value is
> > Printing Record for Search Conditions 950 and 2 and 'MAINTENANCE TRAINING
>
> > REQUI REMENTS REVIEW' IS FOUND OR 'MTRR' IS FOUND and SQL failed "INSERT
> > INTO Table_Of_SearchConditions (SC_lintPID, SC_etSearchType,
> > SC_stSearchCondition, SC_lintSearchCondition ) VALUES ('9000', '2',
> > ''MAINTENANC E TRAINING REQUIREMENTS REVIEW' IS FOUND OR 'MTRR' IS FOUND',
> > '')":
> > -3100[Micros
> > oft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
> > query expr ession '''MAINTENANCE TRAINING REQUIREMENTS REVIEW' IS FOUND OR
> > 'MTRR' IS FOUND'
> > '.10
>
> Sounds like the problem is not blanks... It looks like it's strings that
> contain single-quotes. You may want to try something like s/'/''/ to change
> them all to "double single-quotes".
>
Hi all,
this was discussed recently; try using $dbh->quote() on string fields;
$stmt = "INSERT INTO Table_Of_SearchConditions (SC_lintPID,
SC_etSearchType, SC_stSearchCondition, SC_lintSearchCondition ) VALUES
($db->quote($newAddPID), $db->quote($SearchType),
$db->quote($SearchCond), $db->quote($SearchCondCh))";
$rc = $db->Sql($stmt);
kDot
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
