ahhh the code differences, although not too many, they can still be a pain.
We are 100% Unix / Oracle here and I came from an MSSQL environment. BIG
differences to look for are:
1) In oracle 'autonumber' fields are NOT 'autonumber', you have to build
sequences and then actually sequence the values manually e.g.
SEQUENCENAME.nextval
2) inserting dates, must use the to_date function in oracle:
to_date is what's known as an *explicit* datatype conversion
command.
Oracle handles datatype conversions two ways: *explicitly* and
*implicitly*.
Oracle has built in implicit conversion of character type data into
the handling of the date type BUT ONLY IF the character string has
the format DD-MON-YY (e.g., 31-Oct-00). ANY AND EVERY other date format,
if required to be in the table as type date, must be explicitly
converted.
If CF creates a numeric value for a date, then if the oracle table
requires that the value be in date format, the value must actually
undergo two changes: to_char, to get it to character, and then to_date. If
the value is already a char value in the CF variable, then just to_date
will suffice. Be sure to 'describe' your table before working with it so
you know what field types you are working with (e.g., 'describe tablename').
So if the date is of type number we would need
to_date(to_char(#cf_variable#, 'fmt')) 'fmt' is not a required attribute
but it is useful, particularly if the table you are developing for already
has a selected date format. How to specify date format: values
(to_date('#CF_variable#')), when specifying format, could be written as:
values (to_date ('#CF_variable#', 'MM DD YYYY')) which would format the
character string variable into, as an example, 10 31 2000. Some
common format elements: YYYY - year 4 digits YEAR - year spelled out MONTH -
month spelled out MM - 2 digit month DY - day of week, three letter
abbreviation DD - day of month Q - quarter of year WW - week of year TH -
adds 'th' suffix also format can have character strings added...
values (to_date('#CF_variable#', '"The" DDTH "day of" MONTH"," YYYY'))
would today yield The 31st day of October, 2000.
chris.alvarado
cold.fusion - developer
[phone] 512.794.6563
[email] [EMAIL PROTECTED]
[web] http://www.tmanage.com
Privileged/Confidential Information may be contained in this message. It is
not for use or disclosure outside TManage without a written proprietary
agreement. If you are not the addressee indicated in this message, or agent
responsible for delivery, you may not copy or deliver this message to
anyone. Please notify the sender as soon as possible and immediately
destroy this message and its attachments entirely.
-----Original Message-----
From: Jaime Garza [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 02, 2000 2:17 PM
To: CF-Talk
Subject: RE: URGENT - compatability issue
I don't want to scare you, but it if you are involving Oracle, be warned...
It took me 5 working days to do that, 1 doing patches and installations and
4 doing Oracle. 4.5.1 SP2 recommends certain OS patches. I spent some
hours doing that... then if you have Oracle, it wants 8.1.6.2 as client
libraries. Unfortunately I had the oracle server in the same box, so I had
to move my oracle to 8.1.6.0 and try with the 8.1.6.2 clients, and after
enough problems, I ended with 8.1.7.0 server and client, and some invalid
objects in the software packages. I still trying to fix those.
I also know that there may be code that needs to be fixed, but I am not
sure.
On the good news side, CF is way faster and more stable.
<Jaime/>
> -----Original Message-----
> From: Janssen Dolores Y (Contractor)
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 02, 2000 11:48 AM
> To: CF-Talk
> Subject: URGENT - compatability issue
>
>
> i just found out that our unix sys admin team is moving our development
> server to cf v4.5.1 this weekend. our production server will remain at cf
> v4.01 for another month. we haven't even had the time to test our current
> aps for compatibility with v4.5.1 and we are still using cf studio v4.01.
> we can upgrade our studio versions to 4.5.1 but i'm wondering about
> compatibility issues when moving things finished under the new version to
> production that's still using the old version - anybody have any
> experience
> with this?
>
> thanks
>
> ------------------------------------------------------------------
> ----------
> ----------
> Dee Janssen
> Web Developer
> LESCO/LOGSA
> 256-955-9579
> [EMAIL PROTECTED]
>
> ------------------------------------------------------------------
> ------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
