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. _____ Cabbage Tree Creative Ltd. Paul Johnson | web programmer Phone +64 3 377 7544 Email <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] Web <http://www.cabbagetree.co.nz> www.cabbagetree.co.nz manage your own web site with Thrive - contact us to learn how! <http://www.cabbagetree.co.nz> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
