Revisit topic of getting quotemarks into a DB -- SQL write

Lar_123 · **Posted:** February 14th, 2009, 10:25 am

I have lost my way. I am now seemingly playing the old "Stomp-the-mole" boardwalk game. When I fix the script to work one way, some other aspect is broken.

Specifically trying to write a section of paragraph text to the SQLite DB. The scripts I am using pass fine when paragraph has no quotemarks at all. When I write the code one way, I get errors for single-quote apostrophes which are in the paragraph. Write code the other way, and errors for standard quotemarks --- ".

Code:

//use Full quotes " for the SQL statement, single quotes around values to be set
"UPDATE tablePROD SET " +pgvarFieldName + " = +'"+pgvarTextParagraph+"' , etc WHERE etc  "  

//use single quotes ' to demarcate the SQL statement, and double-quotes encapsulate values returned from Opus variables.
'UPDATE tablePROD SET ' +pgvarFieldName + ' = +"'+pgvarTextParagraph+'" , etc WHERE etc '  

What's weird is I thought I had conquered this obstacle before. Is there a solid reference guide for this somewhere?

Lar_123 · **Posted:** February 14th, 2009, 9:50 pm

I'm having a 'brain thaw' now. I do remember that I did do some string processing to detect single-quotes and put in two chars in sequence, O'hara becomes O''hara. (thanks to an earlier post).

I guess I was just playing with discrete amounts of data then, and went on to some other things. Now it seems I've got to build that into a standard procedure.

WYSIWYGTSFTGWYW
what you see is what you''ve got to script for to get what you want. :roll:

Digital Workshop

Revisit topic of getting quotemarks into a DB -- SQL write

Who is online