Try this: <cfquery name="rs" datasource="#accessdb#"> SELECT * FROM mytable </cfquery>
<cfloop query="rs"> <cfquery name="rsins" datasource="#mysqldb#"> INSERT INTO mytable ( my,list,of,columns ) VALUES ( <cfqueryparam value="#rs.my#" cfsqltype="cf_sql_longvarchar"> <cfqueryparam value="#rs.list#" cfsqltype="cf_sql_varchar"> <cfqueryparam value="#rs.of#" cfsqltype="cf_sql_integer"> <cfqueryparam value="#rs.columns#" cfsqltype="cf_sql_float"> ) </cfquery> </cfloop> > This is a mySQL problem methinks and it would appear to be > self-explanatory. > -----Original Message----- > From: Greg Luce [mailto:[EMAIL PROTECTED] > Sent: 27 March 2003 14:29 > To: CF-Talk > Subject: OT-DTS > Anyone ever used DTS to migrate data from MS Access to > MySQL? I've > installed the MyODBC driver and created an ODBC connection > then I'm > using DTS to export the data from the specified access db > to the mysql > db. It creates all tables, but when inserting Memo type > columns (I > think) it gives this error: > "Query-based insertion or updating of BLOB values is not > supported." > Do I need to customize the query and convert the data to > another > datatype? I'm new to MySQL. > Thanks, > Greg > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~| > 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 > Get the mailserver that powers this list at > http://www.coolfusion.com > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > ubscribe.cfm?user=633.558.4 s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4