I now know that something weird is going in inside of StackApps…
I say this because I have been so frustrated by not being able to get this to work, that I hand coded a page in PHP to connect to the same table, and run the query that I want, which works fine and pulls all the correct values.
It does not look as nice as it would in StackApps, and it is not as easy to use, but IT WORKS!
So I really do not understand why StackApps will not work…and I am not sure where to go from here, other than to hand code everything, which while being a learning experience, is not what I really want.
I wish that there were a well documented and complete SQL solution for RapidWeaver out there, but there does not seem to be one at this time.
If anyone has a suggestion, I would really like to figure this out.
In my hand coding “WHERE Contract = ‘AEBSD’” works fine…but I get 0 records returned when I us that in StackApps.
Kris --> Contract is not a key value, it is just a text value that is populated in the database. If I could get everything working, I would do the following:
??Maybe if I made it an index…I will have to try that.
1st - limit the TableGrid to all records with a particular project set in the ‘Contract’ field
2nd - provide a search to limit further by location or ‘Site’
But nothing works if I can not create a functional WHERE clause.