I'm designing a page which will retrieve info from a database and do so complex filtering however i've hit a road block and that I can only use access .mdb databases. The search options are very limited and basic.
I was thinking i could read the database and make it into a XML file or something like that.
Can I then search an XML file and have complex search strings such as group by, limit?
Any ideas will be appreciated.
[man]SQLite[/man] is a much better environment for a relational database than XML.
But I then need a SQlite database don't I?
Obviously you need a database - it's what your data is stored in.
Try reading the introduction to SQLite in the manual. It's only two paragraphs; six sentences.
Obviously you need a database - whatever you store your data in and however you store it, that's your database.
Try reading the introduction to SQLite in the manual (it's why I provided the link). It's only two paragraphs; six sentences.
Also, considering Access had support for joins, where clause, group by and limit clauses over 10 years ago using VBA, it really should have support for the same things using ODBC today (if it didn't allready back then).
odbc does not support the group by and limit functions.
Well according to a google search for odbc group by leading to http://msdn.microsoft.com/en-us/library/windows/desktop/ms710892%28v=vs.85%29.aspx, ODBC supports group by. And since you're dealing with access, can't you use TOP instead of limit?
