I do not know if I do this with razor/xslt or the api. I have a document type of 'news items' and I want to query them based on a get variable.It is a calendar
So if I have a get variable of 22-10-2012 - I want to do a select * from events where date = "22-10-2012"
Querying the database
Hi,
I do not know if I do this with razor/xslt or the api. I have a document type of 'news items' and I want to query them based on a get variable.It is a calendar
So if I have a get variable of 22-10-2012 - I want to do a select * from events where date = "22-10-2012"
Any pointers would be appreciated.
I'm not sure if it's a good idea to query the database directly. Here is a topic with some other suggestions: http://our.umbraco.org/forum/developers/api-questions/18933-Query-multiple-websites.
If you really want to query the database I have an example query in the UpdateDAMP method. That should get you started.
Jeroen
is working on a reply...