(no subject)

[Robert Mann]

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: use-revolution-bounces at lists.runrev.com
[mailto:use-revolution-bounces at lists.runrev.com] 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
trevor at bluemangolearning.com


_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution