I had the exact same problem recently with one of my forms. The only way I
could resolve it was to convert all of the ' characters to a double
character combo like ~` using $instring=eregi_replace("'", "~`", $instring)
before the db insert/update and reversing it on the db selects.
Ron Woods/GAI
-----Original Message-----
From: Asendorf, John
To: Pablo Vera; Php-Windows (E-mail)
Sent: 2/6/01 8:26 AM
Subject: RE: Re[2]: [PHP-WIN] Converting apostrophes for insertion into Or
acle
The only problem with that is that I truncated the actual SQL statement
which has about 15 variables it is updating... the combinations are
dizzying...
---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
The benefit to the government of replacing all $1 Federal Reserve notes
with
$1 coins would be $522.2 million per year, according to estimates of the
General Accouting Office released on April 7, 2000.
> -----Original Message-----
> From: Pablo Vera [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 6:06 PM
> To: Php-Windows (E-mail)
> Subject: 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:[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]
>
--
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]
