<cfquery>
SELECT ...
WHERE <cfqueryparam value="changed?" /> = YES ...
</cfquery>
I'm not sure if cfqueryparam can be used for a table name, so not sure
if it'll work, but worth checking out.
Scott Thornton wrote:
> Hi,
>
> How do you mean?
>
> Also,
>
> I tried using select *, and then used a query of query, but it doesn't seem
> to like square brackets and the question mark in the qoq either.
>
>
>
>
>>>> 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
-~----------~----~----~----~------~----~------~--~---
