Did you look up the sql "in" On Jun 12, 2014 11:00 PM, "Matthew Smith" <[email protected]> wrote:
> > Yes same error. Frustrating. Need to get site up ASAP > > > On Jun 12, 2014, at 20:36, LRS Scout <[email protected]> wrote: > > > > > > Same error? > >> On Jun 12, 2014 7:51 PM, "Matthew Smith" <[email protected]> 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:370898 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
