Hi Dale, I think my last email crossed over the wires with yours.
I can use Select * and the field is returned n the query object. I cannot reference it via coldfusion, or in a query of query by its name. My next question is, can I refer to it by its column number. Am currently scouring the docs for this info. Cheers, >>> "Dale Fraser" <[EMAIL PROTECTED]> 07/08/2007 3:32 pm >>> Where does the problem occur? Is it just in the where perhaps Try without the where, but include the field in the select and see if you can dump it. You might then be able to do query of query or loop over the query. If select [Changed?] as Changed works you will have a lot more options. 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 2:32 PM To: [email protected] Subject: [cfaussie] Query Problem against MS Access data source 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 -~----------~----~----~----~------~----~------~--~---
