Jason Spisak wrote:
Has anyone had any luck inserting a variable into the "query" string TinyTables. A thousand thanks to Ty Sarna for the Product by the way!
You're welcome! Glad others are finding it useful. Stay tuned for thr read/write capale version... In article <4.1.19990310100907.00bd7100@lisp.atmm.nl>, Martijn Pieters <mj@antraciet.nl> wrote:
TinyTables act like dictionary objects I think, and are keyed on strings.
This form of query acts like a dictionary lookup, yes (always returns either 0 or 1 rows). It's keyed on whatever type the first column is. So, if the first column is a string, you need to lookup with a string, or you won't get a match.
AUTHENTICATED_USER is not a string, but an object, so you'll have to convert it. Try calling AUTHENTICATED_USER.getUserName() instead.
That should do it.