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:370895 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm