RE: More on Oracle strings

Hi, when using Oracle it is always good to bind variables. The advantages are speed improvement and you do not have to worry about the ' to '' conversion. Florian Clever USA 503 977-0480 (Office) USA 503 246-2803 (home) http://www.Clever-Software-Solutions.de -----Original Message----- From: Richard Yaker [mailto:ryaker@withoutabox.com] Sent: Tuesday, July 18, 2000 4:51 PM To: php-general@lists.php.net Subject: More on Oracle strings These are my settings in php.ini magic_quotes_gpc = On ; magic quotes for incoming GET/POST/Cookie data magic_quotes_runtime= On ; magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc. magic_quotes_sybase = On ; Use Sybase-style magic quotes (escape ' with '' instead of \') I am running php as a static module for apache, any idea why I am still getting update BLANKset festival_name='blank\'s',festival_nickname='music',festival_description='',a ddress1='8888 street',address2='',address3='',city='LA',state='CA',zipcode='90064',country _code='241',telephone='333.333.3434',fax='333.333.3434',url='http://www.with outabox.com',email='info@with.com',mission_statement='To suceed and go where no one has gone before',objective='To rock the house',anniversary='16',market='Y',academy_nominating='Y',WAB_award='N',WAB_ sponsor_interest='',general_rules='',online_payment='Y',create_date='11-JUL- 00' where festival_id='1001' instead of update BLANKset festival_name='blank''s',festival_nickname='music',festival_description='',a ddress1='8888 street',address2='',address3='',city='LA',state='CA',zipcode='90064',country _code='241',telephone='333.333.3434',fax='333.333.3434',url='http://www.with outabox.com',email='info@with.com',mission_statement='To suceed and go where no one has gone before',objective='To rock the house',anniversary='16',market='Y',academy_nominating='Y',WAB_award='N',WAB_ sponsor_interest='',general_rules='',online_payment='Y',create_date='11-JUL- 00' where festival_id='1001'