Can CF build tables in an Oracle DB?? 1

[bizbul]

I have a question as to whether ColdFusion can build tables in a database. I have a web application that needs to get the information from a text file and then build a table from that information. Can CF do this or is it better to use shell scripts for this purpose?
Thank You
Jennifer

 

[GunJack]

I can't say whether it would be better to use shell scripts but this is how you can build tables in Access. This might work but you'll probably have to modify one or more of the field types for Oracle.

<cfquery name=&quot;d&quot; datasource=&quot;myDS&quot;>
create table myTableName
(
pKey counter primary key,
textFieldName text(50) null,
numericFieldname short null,
myDate datetime
)
</cfquery>

Hope this helps,
GJ

 

[bizbul]

Thank You, I'm going to try this. I really appreciate your sharing your expertise with me.
Jennifer :-D

 

[GunJack]

Np, many others have done the same for me over the years Let me know how it works, I'd be curious to see what if any you have to modify for Oracle. I think most of it like &quot;text(50)&quot; is standard SQL but the &quot;primary key&quot; may be a MS only value.

GJ

 

[bizbul]

Will do. I'll be working on this project over the coming weeks and will let you know how it's going.
Thanks again,
Jennifer