Value-lists with SQL query - syntax on my end...

[mike.jones]

[auphi]

Hmm... I don't see anything wrong either. Maybe someone else will catch the error though...

In the meantime try simplifying your sql code and then add things back in gradually to see where it breaks, i.e. try:

__sql__ = "SELECT TeacherID FROM 2013teachers"

if that works, then

__sql__ = "SELECT TeacherID, TeacherName FROM 2013teachers"

then

__sql__ = "SELECT TeacherID, TeacherName FROM 2013teachers ORDER BY TeacherName"

and maybe that will help you at least identify where the problem is.

[mike.jones]

Sounds good - I'll give that a whirl and see where I end up.

[mike.jones]

No joy - tried various combinations, but alas, nothing seemed to work. Will dig into the PHP source next, I guess. Way over my head, but that's how your learn, right?

FWIW, the SQL query worked w/o any errors in phpMYadmin - so there seems to be something incorrect with my fields.ini and valuelists.ini files...

http://www.swmobridgecontest.org/cms/contest/

After some more massaging, the teacher names will show up in the TeacherID field in the 2013contestants table - but whenever I try to add a new records in the 2013contestants table, I get the PHP/SQL error described above.

[shannah]

The SQL parser looks like it's choking on the table name "2013teachers". This is likely because it begins with a number so the parser thinks it is just a number. You can help out the parser by using backticks "`' around the table name so that it knows you want it to be an identifier. E.g.
SELECT TeacherID FROM `2013teachers`

Steve

[mike.jones]

Wow, that was it!

I owe you a coffee or something.