This looks cool too (for oracle):
select dbms_metadata.get_ddl('TABLE','THE_TABLE_NAME') from dual
:D
On 8/11/06, Deanna Schneider <[EMAIL PROTECTED]> wrote:
>
> For the clobs, your best bet is to use a cfqueryparam on the insert.
> Of course, that screws up the idea of using cfinsert. You can figure
> out what the fields were though with a little data dictionary query.
>
> <cfquery name="gettabs"....>
> select table_name, column_name, data_type, data_length, data_scale,
> nullable
> from cols
> order by table_name
> </cfquery>
>
>
>
>
> On 8/11/06, Lars Gronholt <[EMAIL PROTECTED]> wrote:
> > How'd I make that mistake?? you're right of course - they are indeed
> CLOBs.
> >
> > >Oracle BLOBS are binary, not text - they are going to break if you put
> > >them in a text field. Are you sure you don't mean CLOBs?
> > >
> > >On 8/11/06, Lars Gronholt <[EMAIL PROTECTED]> wrote:
> > >>
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249546
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
