> Wise Ones,
>
> We have to change hosting services and need to make a quick decision
> about
> converting from MS Access to SQL and/or MYSQL.��Two questions, if one
> of
> you experts would like to advise on?
>
> 1. I think that I recently saw a posting in CFTalk that you can
> convert an
> existing DB by reading from Access and writing to SQL and/or MYSQL.
>
> 2. The bigger unknown in my mind is the coding, i.e., just how much
> different is the coding?
>
> Assuming an illustration would simplest. What changes would need to
> be made
> to the following code to operate on SQL and/or MYSQL?
>
> Thanks,
>
> Nick
>
> <CFQUERY NAME="GetRecords" DATASOURCE="DB1" DBTYPE="ODBC">
> SELECT *
> FROM "Table1"
> WHERE ID = ID
> </CFQUERY>
none
>
> <CFQUERY NAME="ExtractData" DATASOURCE="DB1" DBTYPE="ODBC">
> SELECT *
> FROM "Table1"
> WHERE ID = ID
> </CFQUERY>
>
none
> <CFQUERY NAME="CreateTable" DATASOURCE="DB1" DBTYPE="ODBC">
> CREATE TABLE "Table1" (
> ID AUTOINCREMENT,
> Field1 TEXT (100),
> Field2 NUMBER (20)
> )
> </CFQUERY>
>
in SQL-SERVER
..... id Identity primary key
in MySQL no change
> <CFQUERY NAME="AddCompletions" DATASOURCE="DB1">
> insert into Table1 (Field1,Field2)
> values���('#session.Variable1#', #session.Variable2#)
> </CFQUERY>
no change
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
