I am using MySQL. But if we cannot pass a user defined variable to the database query builder then it makes the database-linked controls kind of weak. I hope that you complete that user interface soon.
Perhaps I can use the database-liked controls in combination by viewing subsets of records with only one or two of the fields and then going to that record for the whole card and its set of fields -- which means I still have to get the update function working. The other problem is that moving through records only works for one table and that fields which are populated by records linked by primary keys to other tables have to be updated by a separate call (calls). I guess I'm not having very much luck with writing queries in the builder that use left joins -- are there some example MySQL access stacks using query builder that I can look at? I would be happy to send you my example stack and a nice database it accesses if you need something more to test. On 6/28/04 6:16 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > The :1 is best explained by the Transcript Dictionary > entry for the 'revdb_query' function. Basically these > are replaced by the content of variables, passed by > their names. > A quick trip to the code leads me to believe that you > will only receive an empty error like this, if the > database fails to return the number of affected rows > -- I don't recall which database you are using ? _______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
