Paul
|
Posted: 01/08/2002, 3:15 AM |
|
I am using ASP with mySQL and have a single table for all my vacancies. I would like to display job for different divisions on different pages and therefore different grids. How do i restrict the grid to showing just one division? The table include a column named division_id.
I tried adding a WHERE clause in the code, but get the error:
[TCX][MyODBC]Column: 'division_id' in where clause is ambiguous
Any ideas? Thanks in advance
|
|
|
Nicole
|
Posted: 01/08/2002, 4:09 AM |
|
Paul,
try to add the number of division on form->properties->SQL tab to 'WHERE' field. E.g.:
t.division_id=2
where "t" is the table alias, CC takes first letter of table name as alias name.
Also if you add several division_id fields to the form set the different names to all the fields (on Field->Properties->Common tab)
|
|
|
|