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:[EMAIL PROTECTED]]
>> 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:[EMAIL PROTECTED]]
>> >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 - [EMAIL PROTECTED]
>> >> AJ> Web Applications Developer
>> >> AJ> http://www.lcounty.com - NEW FEATURES ADDED 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: [EMAIL PROTECTED]
>> >> For additional commands, e-mail: [EMAIL PROTECTED]
>> >> To contact the list administrators, e-mail:
>> >> [EMAIL PROTECTED]
>> >>
>> >
>> >--
>> >PHP Windows Mailing List (http://www.php.net/)
>> >To unsubscribe, e-mail: [EMAIL PROTECTED]
>> >For additional commands, e-mail: [EMAIL PROTECTED]
>> >To contact the list administrators, e-mail:
>> >[EMAIL PROTECTED]
>> >
>>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
