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]

Reply via email to