How do you mean? Thanks! I tried a = as well... Didn't work either. > On Jun 12, 2014, at 23:03, LRS Scout <lrssc...@gmail.com> wrote: > > > Did you look up the sql "in" >> On Jun 12, 2014 11:00 PM, "Matthew Smith" <chedders...@gmail.com> wrote: >> >> >> Yes same error. Frustrating. Need to get site up ASAP >> >>> On Jun 12, 2014, at 20:36, LRS Scout <lrssc...@gmail.com> wrote: >>> >>> >>> Same error? >>>> On Jun 12, 2014 7:51 PM, "Matthew Smith" <chedders...@gmail.com> wrote: >>>> >>>> >>>> <cffunction access="public" name="qry_ordersGet" output="no" >>>> returntype="query"> >>>> <cfargument name="orderKeyList" type="string" required="no" default=""> >>>> <cfargument name="personKeyList" type="string" required="no" >> default=""> >>>> <cfquery >>>> name="qry_ordersGet" >>>> datasource="#variables.datasource#"> >>>> SELECT o.tablePK >>>> ,o.tblPeopleFK >>>> ,o.createdOn >>>> ,o.shippingMethod >>>> ,o.itemSubTotal >>>> ,o.totalBeforeTax >>>> ,o.tax >>>> ,o.shippingCost >>>> ,o.total >>>> ,p.firstName + ' ' + p.lastName AS name >>>> >>>> FROM #request.sqlObjectPrefix#tblOrders o >>>> INNER JOIN #request.sqlObjectPrefix#tblPeople p >>>> ON o.tblPeopleFK = p.tablePK >>>> WHERE 1 = 1 >>>> >>>> <cfif len(arguments.orderKeyList)> >>>> AND o.tablePK = <cfqueryparam >>>> value="#arguments.orderKeyList#" cfsqltype="CF_SQL_INTEGER" list="Yes"> >>>> </cfif> >>>> >>>> <cfif len(arguments.personKeyList)> >>>> AND o.tblPeopleFK = <cfqueryparam >>>> value="#arguments.personKeyList#" cfsqltype="CF_SQL_INTEGER" list="Yes"> >>>> </cfif> >>>> >>>> >>>> </cfquery> >>>> <cfreturn qry_ordersGet> >>>> </cffunction> >>>> >>>> -- >>>> Regards, >>>> chedder is bedder > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:370899 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
