Anytime you start with an Access Problem and try to fix it with a Cold
Fusion Solution your in deep dodo.
The issue with Access in the first place is that it's a wholly
inadequate database which is closed sourced and purposefully non
standardized (BROKEN - Did you know you could call a column primary in
Access and that the dating scheme has now changed 3 times in three
releases!!).
If you use anything outside of an ODBC solution or a DBI Solution to
solve this problem, your going to end up with a broken application 3
months down the road when they switch to Access 2000 or Cold Fusion 2001
- a WebSpace Oddity!!
Ruben
Derek M Wickersham wrote:
>
> I'm in the process of converting an Access database to a MySQL database. Cold
> Fusion makes this pretty easy -- here's what I'm doing:
>
> 1) put Cold Fusion on a Windows machine. I believe there's a developer's
> version you can get for free.
>
> 2) install MyODBC on that Windows machine and connect it to the MySQL database
> on the Unix machine
>
> 3) define the Access database and the MySQL database as datasources in the Cold
> Fusion administration utility
>
> 4) create the table structures in the mysql client to match the Access table
> structures
>
> 5) use a simple Cold Fusion script with this template:
>
> <cfquery name="getRecs" datasource="AccessDatabase">
> select *
> from TableName
> </cfquery>
>
> <cfloop query="getRecs">
>
> <cfquery name="insertRecs" datasource="MySQLDatabase">
> insert into TableName
> (
> <cfif #getRecs.Field1# IS NOT "">Field1</cfif>
> <cfif #getRecs.Field2# IS NOT "">,Field2</cfif>
> )
> values
> (
> <cfif #getRecs.Field1# IS NOT
> "">,#getRecs.Field1#</cfif>
> <cfif #getRecs.Field2# IS NOT
> "">,'#getRecs.Field2#'</cfif>
>
> )
> </cfquery>
>
> </cfloop>
>
> 6) Alter script for each table and run. Voila!
>
> monty@stripped on 03/22/2000 04:32:00 PM
>
> To: myodbc@stripped@INTERNET
> mysql@stripped@INTERNET
> cc: (bcc: Derek M. Wickersham/0A/Caterpillar)
>
> Subject: Converting Access tables to MySQL data on Unix
> Retain Until: 04/21/2000 Retention Category: G90 - Information and
> Reports
> Caterpillar Confidential: Green
>
> Hi!
>
> A MySQL customer just asked me if anyone has been able to directly
> access rows in a Access97 database file on Unix. If anyone has a
> solution or know a solution (even commercial) of this, please mail me
> about this.
>
> The idea is to, from time to time, copy Access97 datafiles to an Unix
> server and there extract the rows from them and put them into a MySQL
> database.
>
> Regards,
> Monty
>
> PS: I tried to search the email mailing archive before posting..
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread1366@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail myodbc-unsubscribe@stripped instead.
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread1384@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail myodbc-unsubscribe@stripped instead.
--
Ruben I Safir
ruben@stripped
ruben@stripped
Perl Notes:
http://www.wynn.com/jewish/perl_course
http://www.brooklynonline.com
Manager of Intranet Development NYU College of Dentistry
Resume: http://www.wynn.com/jewish/resume.html
