MySQL admin

2003-03-08 Thread FlashGuy
When I go into the Database tab of my SQL Admin I don't see any databases? Should I not see the ones that are in the datadir path? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba

MYsql won't run

2003-01-21 Thread FlashGuy
Hi, I had MYsql running on a nt4 server and w2k server. I uninstalled it a few weeks ago and just recently tried installing it again. The install went fine but when I start the service I keep getting an error no maater what I try. Using localhost and administrator. Whats going on? If I

Fwd: MYsql won't run

2003-01-21 Thread FlashGuy
Well...I uninstalled mysql and installed it again and I still can't get the service to run!!!??? ==BEGIN FORWARDED MESSAGE== From: FlashGuy [EMAIL PROTECTED] To: FlashMX [EMAIL PROTECTED] Date: Tue, 21 Jan 2003 09:05:52 -0500 Reply-To: FlashGuy [EMAIL

Re: Is it possible to export data from access to MySQL?

2002-11-26 Thread FlashGuy
Download MySQL-Font v2.5 This is what I used when I switched from Access to MySQL. Once installed just load MySQL-Front and click on Im-/Export on the toolbar. Select ODBC Import. Viola! On Tue, 26 Nov 2002 16:37:45 +0200, Steve Jackson wrote: Is it possible to export data from MS Access

Deleting matches from one field into another???

2002-11-18 Thread FlashGuy
Hi, I'm hoping I can explain this better so here it goes. I'm using ColdFusion and MySQL. My database has the following fields and what they contain: strUser_ID (auto-generated) strUsername = 'Bill' strSelect = 'D:\test\dir1,D:\test\dir2,D:\test\dir3,D:\test\dir4,D:\test\dir5' strSelectFlag =

SQL statements howto

2002-11-14 Thread FlashGuy
Hi, What SQL statements do I have to use to get the following results? I have a preferences page that lists directories with check boxes. This is displaying by querying my database. It looks something like this: Preferences: (Click to omit directories from listing) [ ] dir1 [ ] dir2 [ ]

ColdFusion and mySQL

2002-11-05 Thread FlashGuy
Hi, How can I display only certain occurences from my database based on a certain critieria. In the filed strSelect I could have a long string which would contain: strSelect = D:\temp\file.txt,D:\temp\file2.txt,D:\mywork\file.txt,D:\mywork\file.txt,D:\documents\file.txt,D:\documents\file.txt

MySQL for W2K

2002-10-30 Thread FlashGuy
Hi, I'm having a little trouble. I've installed mySQL. I've started the service via WinMySQL admin. I was able to create my databases. I also installed MySQL-Front and DBTools. The problem is when I startup any of the tools and try to create a connection I get a MySQL Error - COnnection

OT: CF and mySQL - cont'd thread

2002-10-30 Thread FlashGuy
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