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 -~----------~----~----~----~------~----~------~--~---