[thelist] Mysql query question

Scott McPhee scott at rigent.com
Mon Oct 7 13:22:01 CDT 2002


I think that the To is a reserved word... try your query with something
else in its place.

sm

> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org] On Behalf Of PeterV
> Sent: October 7, 2002 2:14 PM
> To: thelist at lists.evolt.org
> Subject: [thelist] Mysql query question
>
>
> Hi,
> Mysql throws an error with this query:
>
> select to.name as name, to.id as id FROM xfml_occurrence oc,
> xfml_page pa, xfml_topic to WHERE oc.map_id = 10 AND
> pa.map_id = 10 AND to.map_id = 10 AND pa.url =
> '/prototype/multiplefacets.php?mapid=10' AND oc.page_id =
> pa.id AND oc.topic_database_id = to.id
>
> Error:
> You have an error in your SQL syntax near 'to WHERE oc.map_id
> = 10 AND pa.map_id = 10 AND to.map_id = 10 AND '
>
> I can't find what's wrong with it? Any ideas on where to
> start looking?> Peter
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !




More information about the thelist mailing list