Just select [Changed?] as Changed then query of query it Regards Dale Fraser
http://dalefraser.blogspot.com -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 7 August 2007 3:30 PM To: cfaussie@googlegroups.com 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 cfaussie@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
