semi OT : SQL syntax question

[jbv]

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
> trevor at mangomultimedia.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