Hi, I wasn't sure if I should post this here on in the Newbie section but since
it's more SQL than Coldfusion...here I am.
I have been tasked with creating a database in an Oracle9i database. The
existing database is MS Access. Most of these tables have over 200,000 records
so I'm writing a script to transfer them into Oracle. My problems is that some
of these tables have "memo" fields which contain characters like ^ <> . : ' ""
; $ and so forth. I need to transfer these characters into the Oracle DB
however when I run my script I get errors when a field with those characters
come up. I create an insert statement by appending values to the end of a
string:
<cfset List ="INSERT INTO #newtable#.TableName ( fname, lname, etc..) VALUES (">
<cfif "#fname#" GT 0>
<cfset myList = "#List#"& "'#fname#'">
<cfelse>
<cfset myList = "#List#" & " NULL">
</cfif>
<cfquery name="CreateRecord" datasource="#Newdatasource#">
#PreserveSingleQuotes(MyList)#
</cfquery>
As I stated, this works fine until one of those characters appears in a field.
Any help or suggestions will be apprecited greatly.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2785
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
