Models: support IN operator in WHERE clause

Letractively / cfwheels

Automatically exported from code.google.com/p/cfwheels

0 stars 0 forks source link

Models: support IN operator in WHERE clause #113

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago

Support the IN operator in the WHERE clause of findOne/findAll.

Original issue reported on code.google.com by per.djurner@gmail.com on 20 Oct 2008 at 7:51

GoogleCodeExporter commented 9 years ago

Original comment by per.djurner@gmail.com on 31 Oct 2008 at 10:45

Changed title: Models: support IN operator in WHERE clause

GoogleCodeExporter commented 9 years ago

Original comment by per.djurner@gmail.com on 7 Mar 2009 at 9:26

Added labels: Milestone-1.2

GoogleCodeExporter commented 9 years ago

This is now supported but it doesn't cfqueryparam or auto-add table names 
though. Need 
to decide whether to add support for this or just document the limitation.

Original comment by per.djurner@gmail.com on 13 Nov 2009 at 9:32

Changed state: Started

GoogleCodeExporter commented 9 years ago

Original comment by per.djurner@gmail.com on 6 Dec 2009 at 6:03

Removed labels: Milestone-1.2

GoogleCodeExporter commented 9 years ago

Original comment by tpetru...@gmail.com on 25 Jan 2010 at 2:38

Changed state: Accepted

GoogleCodeExporter commented 9 years ago

[deleted comment]

GoogleCodeExporter commented 9 years ago

Why it doesn't support cfqueryparam, I guess we could take the whole list 
inserted by the user and do a 

<cfqueryparam  CFSQLType="I-GUESS-HERE-IS-THE-TRICKY-PART" list="yes" 
value="WHAT-THE-USER-USED" 
/>

Notice the "list" part, if the parenthesis are a problem, then the user can 
type those in :D

Original comment by rierar...@gmail.com on 25 Jan 2010 at 6:42

GoogleCodeExporter commented 9 years ago

r4585.

Original comment by per.djurner@gmail.com on 1 Jul 2010 at 8:41

Changed state: Fixed