OT: CF and mySQL - cont'd thread
I don't know what I'm doing wrong. I've check the DOC but I can't seem to import a comma-delimited text file exported from Access into mySQL. I've created the database, table and fields. WHen I do a Import texfile everything looks OK via MySQL-Front. My text file contains only commas as delimiters separating each field. MySQl fields and settings: ID (Type: TinyINT(3), Primary Key, autoincrement) var (longtext) destination (longtext) Access fields: ID (generated automatically by Access) var destination When I import the text file anf go into data I should have 841 entries but I only see 127? I see no text in the fields other than (Memo). What am I doing wrong? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
CF and MySql?
Can Cold Fusion querys work with MySQL? What would I have to do if anything to make it work? WD - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: CF and MySql?
Install an ODBC for MySql... - Original Message - From: Wade DeWerff [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 26, 2001 2:57 PM Subject: CF and MySql? Can Cold Fusion querys work with MySQL? What would I have to do if anything to make it work? WD - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: CF and MySql?
There are many ways to do this - I'm assuming you want to do this on an Windows box. One way is through MyODBC. It's an ODBC driver that you can install on your server, available from the MySQL web site. From there, all you have to do is create a new DSN, either through the CF Admin or Windows. You can then reference this DSN just like you would any other ODBC connection. Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Original Message - From: Wade DeWerff [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 26, 2001 11:57 AM Subject: CF and MySql? Can Cold Fusion querys work with MySQL? What would I have to do if anything to make it work? WD - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: CF and MySql?
If you are using Cold Fusion server, yes they will work.. You have to download MyODBC from www.mysql.com install it.. and then set it up in the ODBC control panel (assuming you are using windows). Then you should be able to see the mysql databases as a datasource in the Cold Fusion admin page. CAA -Original Message- From: Wade DeWerff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 1:58 PM To: [EMAIL PROTECTED] Subject: CF and MySql? Can Cold Fusion querys work with MySQL? What would I have to do if anything to make it work? WD - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php