LiveCode Forums.

So, I'm working with what should be a simple piece of code - it strips data from a temporary holding space and cleans it for insertion into a database. Or not:

-- Prep for Date
repeat until line 1 of tData contains <td class="date">
delete line 1 of tData
end repeat

I haven't figured out how to "properly" escape those quotes, regardless of research and forum information. Of course, it appears that part of my problem may be the keyword "date" combined with & quote options that causes the problem.

What, pray tell, am I doing wrong?

should do the trick

Good one - solved the problem!

A more robust solution, and a handy technique for you:
1) a function can make the quote handling easier You can do your typing and swap another character for a double quote to make it easier, in the example below, use ~ as if you were typing a double quote inside the literal string. The second parameter tells the function which character you used to be the fake quote 2) The code as you had it would loop forever if the data did not contain the target string. This example will end the repeat if the data becomes empty. (Which would probably be just as bad for your program operation but still.)
The wait with messages is a line which gives the engine a moment of as near zero duration as possible but stops the repeat loop becoming blocking and your application unresponsive if there is a lot of data to chunk through.

Hypercard introduced the "quote" as a constant over 2000 years ago just for this purpose, that the syntactical requirement for quoted strings made it necessary to have a, er, quote available "outside" and apart from such strings.

"Tab" is a similar constant, but is not so intimately embedded into the syntactic structure of our beloved xTalk paradigm, and can be far more easily differentiated between the constant itself and the character created with a keypress.

Craig

If the end result is just to escape the quotes so you can insert it into a database, i find it would just be easier to use query placeholders and let LiveCode work it's magic. And it is safer since it would avoid SQL injections.