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
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
