Re[2]: [PHP-WIN] Converting apostrophes for insertion into Oracle

John: You could do something like this (I'm not sure if this will work): if (!isset($SHORT_NAME) || $SHORT_NAME=="") { $SQL=" INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES(\"$Max_ID\", null) "; } else { $SQL=" INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES(\"$Max_ID\", \"$SHORT_NAME\") "; } Saludos, Pablo _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Monday, February 05, 2001, 3:42:12 PM, John wrote: AJ> The error comes up when you have something like this AJ> INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) AJ> VALUES("$Max_ID", "$SHORT_NAME") AJ> and $SHORT_NAME is empty so the SQL looks like this AJ> INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES("20002", AJ> "") //doesn't work AJ> If I use the single quote or apostrophe, it works fine.... AJ> INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES('20002', AJ> '') //works fine >> -----Original Message----- >> From: Svensson, B.A.T. [mailto:B.A.T.Svensson@lumc.nl] >> Sent: Monday, February 05, 2001 4:39 PM >> To: Asendorf, John >> Subject: RE: [PHP-WIN] Converting apostrophes for insertion >> into Oracle >> >> >> That seams to be related to the name of the attribute(?) >> (filed), not the >> content of the attribute (filed). Or do I misinterpret the >> error message? >> >> >-----Original Message----- >> >From: Asendorf, John [mailto:JAsendorf@lcounty.com] >> >Sent: Monday, February 05, 2001 10:21 PM >> >To: Pablo Vera; Php-Windows (E-mail) >> >Subject: RE: [PHP-WIN] Converting apostrophes for insertion >> into Oracle >> > >> > >> >Hi Pablo >> > >> >To answer your question, yes... It doesn't seem to like that >> >because the >> >field can be empty... for some reason Oracle won't allow you >> >to have an >> >empty field enclosed by two "'s... ORA-01741: illegal zero-length >> >identifier >> > >> >John >> > >> >> John: >> >> >> >> When you say that your SQL statement has apostrophes, you >> mean single >> >> quotes enclosing a string value ?, if this is the case, why not try >> >> changing the single quotes in your SQL for double quotes. >> >> >> >> Saludos, >> >> Pablo >> >> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ >> >> >> >> Monday, February 05, 2001, 3:03:21 PM, John wrote: >> >> >> >> AJ> I've got a web form that might have someone entering >> apostrophes. >> >> AJ> Unfortunately, my SQL statement has apostrophes in it and >> >> it seems to be >> >> AJ> messing it up... >> >> >> >> AJ> Any suggestions other than a regex (which I could do myself)? >> >> >> >> AJ> John >> >> >> >> AJ> --------------------- >> >> AJ> John Asendorf - jasendorf@lcounty.com >> >> AJ> Web Applications Developer >> >> AJ> http://www.lcounty.com - NEW FEATURES ADDED >> >> AJ> DAILY! >> >> AJ> Licking County, Ohio, USA >> >> AJ> 740-349-3631 >> >> >> >> AJ> The benefit to the government of replacing all $1 Federal >> >> Reserve notes with >> >> AJ> $1 coins would be $522.2 million per year, according to >> >> estimates of the >> >> AJ> General Accouting Office released on April 7, 2000. >> >> >> >> >> >> >> >> -- >> >> PHP Windows Mailing List (http://www.php.net/) >> >> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >> >> For additional commands, e-mail: php-windows-help@lists.php.net >> >> To contact the list administrators, e-mail: >> >> php-list-admin@lists.php.net >> >> >> > >> >-- >> >PHP Windows Mailing List (http://www.php.net/) >> >To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >> >For additional commands, e-mail: php-windows-help@lists.php.net >> >To contact the list administrators, e-mail: >> >php-list-admin@lists.php.net >> > >>