Rev cgi & mySQL (again)

william humphrey shoreagent at gmail.com
Fri Jan 2 19:04:18 EST 2009


I'm interested in what Bill said:
"notice that I use single quotes to enclose strings; you shouldn't need your
" &q& " business cluttering things up"

I'm constantly doing that because I build the SQL in RunRev and then send
it. I'd like to see an example of a SQL built in RunRev

put  "select table" &q& "silly table name" &q& etc into tSQL -- without
using the &q& or when you are saying "WHERE FIELD NAME = &q& "term" &q& into
 tSQL

If you put single quotes instead (I'm going to try it when I get home) you
can avoid that? Cool...



More information about the use-livecode mailing list