Trevor,
Thanks, but I found the solution in the mySQL manual
about an hour ago... I was actually confusing the Postgres
and mySQL syntax... stupid me...
However, why did you add "as myCol" ?
I'm using :
SELECT concat("$",ID,"$"), col_1, col_2 FROM myTable WHERE
id < 100
and it works...
Thanks again,
JB
> On Jun 29, 2005, at 5:05 AM, jbv wrote:
> >
> > put "SELECT "$"+toString(id)+"$", col_1, col_2 FROM myTable
> > WHERE id
> > < 100" into myREQUEST
>
> This works in MySQL:
>
> SELECT concat("$",ID,"$") as myCol, col_1, col_2 FROM myTable WHERE
> id < 100
>
> --
> Trevor DeVore
> Blue Mango Multimedia
> [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
_______________________________________________
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
