And so I thought that I'd made a cute little couple of lines of code that replaced my loops. The updating worked, with a SELECT generating a slew of UPDATEs.
And then I tried to deal with the case of an apostrophe in a field. Giving me something like SET adr='Fudd's Place' I suppose I could make the query come back as something like, SET adr=@Fudd's Place@ use a replace to escape the apostrophe's & such, and then turn it the quotes back . . . I guess it's back to looping, though: If I do use an ascii string of one or more characters, I need to deal with users entering that string (although this is in the "already fully compromised" category . . .) -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode