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