-----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".
Chris
LEGAL NOTICE
Unless expressly stated otherwise, this message is confidential and may be
privileged. It is intended for the addressee(s) only. Access to this E-mail by
anyone else is unauthorized. If you are not an addressee, any disclosure or
copying of the contents of this E-mail or any action taken (or not taken) in
reliance on it is unauthorized and may be unlawful. If you are not an
addressee, please inform the sender immediately.
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
