Thanks I looked at that site but did not find a way to filter it so I just ran the complete query then filtered it after seems to work fine
Thanks Rob -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor DeVore Sent: Sunday, January 21, 2007 1:01 AM To: How to use Revolution Subject: Re: (no subject) On Jan 20, 2007, at 11:34 AM, Robert Mann wrote: > Thanks Trevor, > I got this working but is there a way to do this for selected columns > Something like > > gfields is a list of fields separated by comma > > > put "SHOW "& gfields &" COLUMNS FROM `" & gtable & "`" into theSQL > > this does not work get > > revdberr,You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to > use near > '(addyrmodperm_id,tunername)COLUMNS FROM `addyrmodsize_permission`' > at line > 1 I haven't tried filtering before but maybe you can get some ideas from this page: <http://dev.mysql.com/doc/refman/5.0/en/show-columns.html> -- Trevor DeVore Blue Mango Learning Systems - www.bluemangolearning.com [EMAIL PROTECTED] _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution