DataMgr Presentation: Installation and Instantiation
What a fool I am, in three presentations on DataMgr I have yet to cover installation. This fourth one (2 minutes) remedies that. I have also organization the presentations and the documentation a little bit better.
Watch the presentation or go to all DataMgr presentations.
Thanks for DataMgr! It has saved me loads of coding.
I was experimenting with the saveRecords() method. I was wondering, is there a way to write a "custom" where clause and have it process? In other words is it possible to include a where clause that looks something like this:
where field1 in ('fooA', 'fooB')
or this:
where (field2 > foo1 AND field2 < foo2)
Maybe its already possible (or am I asking too much)? Please let me know. Again, thanks for a great tool.
/D.Nobles
Thanks for the kind words!
That isn't currently possible. Although I am open to discussing such an enhancement, I suspect that it wouldn't be worthwhile.
DataMgr is mostly to simplify very common database interactions that we all do on a regular basis.
For anything beyond that, I think that SQL syntax is very good and I don't think I would be able to match it.
In my own work, I regularly use DataMgr and cfquery in the same components. DataMgr isn't intended to obviate the need for SQL, just simplify the tedious stuff.