in reply to Re: generated SQL statement problem (OT)
in thread generated SQL statement problem (OT)

I modified my sql statement to this:

select csGroups.ID as groupid,csUsers.UserName as username, csGroups_lang.Title as grouptitle,csUsers.ID as uid from csGroups_lang,csUsers,csGroups,csUsers_Groups where csGroups.ID = csGroups_lang.ID and csUsers.ID = csUsers_Groups.UserID and csGroups.ID = csUsers_Groups.GroupID and (csUsers.ID IN (1,2)) order by username asc limit 0,10

and got the same error through my script:

Unknown column 'csUsers_Groups.UserID' in 'where clause'

however it ran cleanly from the mysql command line. So something between the database and my script (the dbd driver?) doesn't like it. Odd....

In Section Seekers of Perl Wisdom