I cant get fields based on lookup tables to show in an asp page, i get this error
Item cannot be found in the collection corresponding to the requested name or ordinal.
Even if I try a query based on the table I get the same error
Any ideas please?Please can you post your query code? It sounds like one of your column names is wrong. Do any of the names have spaces in? If so put square brackets round it: [fieldname].
If that's not it, it could be that your database connection isn't working properly. It will sometimes give you that error if you are not connected, it can be a bit misleading.
Item cannot be found in the collection corresponding to the requested name or ordinal.
Even if I try a query based on the table I get the same error
Any ideas please?Please can you post your query code? It sounds like one of your column names is wrong. Do any of the names have spaces in? If so put square brackets round it: [fieldname].
If that's not it, it could be that your database connection isn't working properly. It will sometimes give you that error if you are not connected, it can be a bit misleading.