Doesn't work, Error Message: Complex object types cannot be converted to simple values. The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you might be trying to use a query variable in a <CFIF> tag. This was possible in ColdFusion 2.0 but creates an error in later versions. The error occurred on line 64.
>>> "Dale Fraser" <[EMAIL PROTECTED]> 07/08/2007 3:36 pm >>> Try '#myquery['changed?']# Regards Dale Fraser http://dalefraser.blogspot.com -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 7 August 2007 3:30 PM To: [email protected] Subject: [cfaussie] Query Problem against MS Access data source Okay, I can use Select * and the field is returned in the query okay. Next challange, using the field in CF presents a problem as CF chucks an error: Invalid token '?' found on line 64 at column 23. when i use #myquery.changed?# So, If I know the order of the columns of the query, can I refer to it that way? >>> Haikal Saadh <[EMAIL PROTECTED]> 07/08/2007 3:03 pm >>> Another though, does cfqueryparam work for table names? Scott Thornton wrote: > Hi, > > Running the following query in MS Access query designer. > > SELECT [Prostheses List].[Billing Code] AS mbs_item_no, > [Prostheses List].MinBenefit AS mbs_item_cost, > [Prostheses List].[Benefit Changed] AS mbs_Cost_Start_Date, > [Prostheses List].[Product Name] AS desc1, > [Prostheses List].[Further Description] AS desc2, > [Prostheses List].Size AS desc3 > FROM [Prostheses List] > WHERE > > ((([Prostheses List].[Changed?])=Yes)) OR ((([Prostheses List].[New?])=Yes)) > > ORDER BY [Prostheses List].[Billing Code]; > > it works fine. > > When I run it in CF, I get the following error: > > Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect > > After some investigation I think the error is related to the question mark character in the where clause. > > I cannot change the field name in the table, as it is provided by the Federal government. > > I've tried text quotes around the field name.. but nothing has worked.... > > Any idea to get around this? > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
