Hello all
I am trying to create a table on the fly in Access
I have:
<CFquery name="" datasource="#FRdsn#" dbtype="ODBC">
CREATE TABLE #newname# ( res_name text, proj_name text, HOURS
number, TASK_NAME text, WORK_DAY datetime)
</CFQUERY>
Which works, but I need the number field to be decimal, currently it
defaults to double and rounds the numbers off.
I have tried:
<CFquery name="" datasource="#FRdsn#" dbtype="ODBC">
CREATE TABLE #newname# ( res_name text, proj_name text, HOURS
decimal, TASK_NAME text, WORK_DAY datetime)
</CFQUERY>
but it doesn't work
Thanks for any help
Rodney
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
