I am using the following method to dynamically build a query <cfset result=querynew(columnList)>
<cfoutput query="qData" group="primaryKeyId"> <!--- Force some values into the query ---> <CFSET QueryAddRow(Result, 1)> <cfset temp=QuerySetCell(result,'language',language)> <cfset temp=QuerySetCell(result,'ID',primaryKeyID)> <!--- loop thru the data and build a convetional query from it ---> <cfoutput> <cfset temp=QuerySetCell(result, columnName,columnValue)> </cfoutput> </cfoutput> Question: Is there a limit to the length of values which can be assigned using QuerySetCell(result, columnName,columnValue) since my MEMO fields from access are being trimmed to 255 characters by this code. Many thanks, Paul Johnson ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
