Hi everybody,
Although it is mentioned in the Query of Queries User Guide (see below) the IN operator is not supported anymore (see error message below)!!! Any answer from Macromedians? Who�s wrong documentation or program ????? Thanks Dominique Developing ColdFusion MX Applications with CFML Previous <http://localhost:8500/cfdocs/Developing_ColdFusion_MX_Applications_with_CFM L/using_recordsets3.html> Up One Level <http://localhost:8500/cfdocs/Developing_ColdFusion_MX_Applications_with_CFM L/using_recordsets.html> Next <http://localhost:8500/cfdocs/Developing_ColdFusion_MX_Applications_with_CFM L/using_recordsets5.html> Home <http://localhost:8500/cfdocs/dochome.htm> Search <javascript:top.perdido.document.searchApplet.makeAppear();> _____ Using Query of Queries Query of Queries user guide <snip> Using conditional operators ColdFusion lets you use the following conditional operators in your SQL statements: * Test * Null * Comparison * Between * IN * LIKE Error Executing Database Query. Query Of Queries runtime error. Unsupported type comparison. The Error Occurred in C:\CFusionMX\wwwroot\projects\extraprint\util\user\act_saveaccess.cfm: line 40 Called from C:\CFusionMX\wwwroot\projects\extraprint\index.cfm: line 81 Called from C:\CFusionMX\wwwroot\projects\extraprint\util\user\act_saveaccess.cfm: line 40 Called from C:\CFusionMX\wwwroot\projects\extraprint\index.cfm: line 81 <snip> _____ SQL select * from qry_menuall where fa_name <> '' and menu_id in (MSTYLE_EDIT,MUSER_EDIT,MGRP_EDIT) ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
