Would exporting the data to a real database (with appropriate table names) be too much? SQL Server's DTS should make something like this reasonably painless. I think you can even schedule the process so that it happens periodically?
That aside, I'm stumped. (Oh, and just checking, but you did see the second ? [New?] as well, right?) Scott Thornton wrote: > Thanks, > > no it did not work. > > >>>> Haikal Saadh <[EMAIL PROTECTED]> 07/08/2007 3:00 pm >>> >>>> > > Tried two double slashes? > [changed\\?] > > Try two single quotes before the question mark: > [changed''?] > > > > 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 -~----------~----~----~----~------~----~------~--~---
