Cliff, thanks for the hibernate link. Mirroring that functionality in its entirety is beyond the scope of my current project, but its definitely a model to work towards. At least it gives me an idea of how people smarter than myself have approached this problem :)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cliff Meyers Sent: Thursday, January 12, 2006 9:45 PM To: [email protected] Subject: Spam:Re: [CFCDev] Ad-hoc queries using Data Gateway objects Hibernate has a similar concept of criteria-based queries that seems to work quite well. If you're not familiar with it, here is a link to the documentation around its use: http://www.hibernate.org/hib_docs/v3/reference/en/html/querycriteria.htm l That might serve as a useful model when you're doing your own CF implementation. On 1/10/06, Seth Johnson (KW) <[EMAIL PROTECTED]> wrote: > I'm trying to set up a data gateway object as part of a new project > I'm working on, but I don't really know what its methods should look like. > > I have a getAll() method that returns all rows from the database and a > getById() method that accepts one or more ID values and returns the > corresponding rows. This works fine for simple tables, but I also have > a large search form where users fill in their criteria for running > ad-hoc queries. How should I implement this in the DG object? > > The approach I'm exploring uses a method called getByCriteria() which > accepts a GatewayCriteria object. This object contains all of the > ad-hoc criteria definitions including the data member to match (i.e. > fieldname), search type (exact match, pattern match, etc) and value(s) > look for. The data gateway object loops through the criteria and > creates the dynamic SQL for running that query. > > Is there a better way? > > Thanks in advance for any suggestions, Seth > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). > > An archive of the CFCDev list is available at www.mail-archive.com/[email protected] > > > ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
