It worked!! Thank you so much. I have lots to learn as a newbie. >in most databases that i'm aware of, month() is a built in function >and as such is a reserved word. > >as such, it really shouldn't have worked in CFMX 6. be glad it worked >for as long as it did :) > >if you can't change the column name, enclose it in square brackets: > >SELECT [Month] >FROM [Month] >WHERE monthID = <cfqueryparam value="#getStatRecords.monthID#" >cfsqltype="cf_sql_integer" /> > >oh, and use cfqueryparam :) > >might also want to alias the column name so as not to run into any >nasty SNAFUs later on in using the data: > > >SELECT [Month] AS someWordOtherThanMonth >FROM [Month] >WHERE monthID = <cfqueryparam value="#getStatRecords.monthID#" >cfsqltype="cf_sql_integer" /> > >On 4/5/07, sheldon turchin <[EMAIL PROTECTED]> wrote: >>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274630 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
