Help!
I'm at zero hour with a project and I just discovered an "issue" with SQL (the language, not the database): Here it goes: I have an Array holding some text and I'm inserting that text into the database, simple enough. But within this text the author used parentheses just like you would write a story. The problem is that SQL seems to run across the parentheses within the chunk of text I'm trying to insert and (I think) it trys to interrupt the contents of the parentheses as part of The SQL statement rather than text to be inserted into the database. The result is a syntax error. Is there some way I can escape the text? I know about the UrlEncoded format and the HTMLCodedFormat but this database is going to be used by a lot of people so I want to store the text as straight forward and unadulterated. Is there a SQL escape function? Any ideas? I know the underling coded works -I looped over 55 records just fine until I hit this one with the parentheses. Thank you in advance for your help in I a big hurry and I don't have time to figure it out on my own!! Thank you ,thank you ,thank you! Jason
