If you use #myquery['changed?']# a lot of the time you need to use an index because you cant just output an array like that. If you know there is only one record in the recordset then use #myquery['changed?'][1]#
Steve -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 7 August 2007 3:45 PM To: [email protected] Subject: [cfaussie] Query Problem against MS Access data source 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 -~----------~----~----~----~------~----~------~--~---
