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 Thanks Rob _______________________________________________ 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
