listContains() isnt a function of the database but, rather, a CFML function. If youre storing the list as a string list, and are querying the database, then your query will have to use Access string functions as it doesnt know CFML:
http://www.techonthenet.com/access/functions/ HTH, Jon On Aug 26, 2014, at 8:13 PM, te...@it-werks.com te...@it-werks.com <te...@it-werks.com> wrote: > > I haven't done this is ages and could use some help, please. > > Here I define a list of checkboxes of picture types: > > <input type="checkbox" name="tt" value="1" <cfif gtype contains > '1'>checked</cfif>>Solid<br> > <input type="checkbox" name="tt" value="2" <cfif gtype contains > '2'>checked</cfif>>Open<br> > <input type="checkbox" name="tt" value="3" <cfif gtype contains > '3'>checked</cfif>>Insulated<br> > <input type="checkbox" name="tt" value="4" <cfif gtype contains > '4'>checked</cfif>>Combination<br> > > At form submit I update the record: > <cfquery name="upcontent" datasource="#dsn#" maxrows=1> > update pgallery set gtype = '#tt#' > where id = #picid# > </cfquery> > > Now here's where I screw up: > <cfquery name="getslides" datasource="#dsn#"> > select * from pgallery where listContains(gtype, "1") > </cfquery> > > Here;s the error: > Error Executing Database Query. > [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft > Access Driver] Undefined function 'listContains' in expression. > > Terry > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359196 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
