(no subject)

Trevor DeVore lists at mangomultimedia.com
Sun Jan 21 01:00:32 EST 2007


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
trevor at bluemangolearning.com





More information about the use-livecode mailing list