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
