The error comes up when you have something like this
INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME)
VALUES("$Max_ID", "$SHORT_NAME")
and $SHORT_NAME is empty so the SQL looks like this
INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES("20002",
"") //doesn't work
If I use the single quote or apostrophe, it works fine....
INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES('20002',
'') //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]