Coldfusion?

2002-01-11 Thread MSL

Quick Newbie question:

Can I use MySQL with Coldfusion server? If yes, are there any limitations or
provisos I should know about?

Thanks as always
Mark


-
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




Coldfusion?

2002-01-11 Thread MSL

Quick Newbie question:

Can I use MySQL with Coldfusion server? If yes, are there any limitations or
provisos I should know about?

Thanks as always
Mark



-
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: Coldfusion?, Database, SQL, etc!

2002-01-11 Thread MSL

Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:

database,sql,query,table

If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for example.

You have written the following:

Robert, Bjorn et all

Thanks for your advice and support - great to know that folks are using it
in this way and getting good results. I'm looking forward to getting stuck
into this, and appreciate knowing there is an active community out there
too.

Cheers
Mark
P.S. By the way, this is the 5th attempt to send this message, I'm getting
auto replies from the server telling me that my reply appears to be spam or
off-topic. It seems the server filter is very strict as it's rejected a
number of my attempts to send today! I've changed the subject as advised by
the server responses.



-
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: Coldfusion? Database, MySQL

2002-01-11 Thread MSL

database,sql,query,table


Hi Stephen

Good to hear your very postive notes on Win2K/Coldfusion/MySQL. I'm just
setting up, and wondering about some notes in the MySQL documentation:

In the following circumstances you will need to use the MySQL
configuration file:

1.The install/data directories are different than the default `c:\mysql' and
`c:\mysql\data'.

2. If you want to use one of the these servers:

 mysqld.exe

mysqld-max.exe

mysqld-max-nt.exe

3. If you need to tune the server settings.



There are two configuration files with the same function: `my.cnf' and
`my.ini' file, however

please note that only of one these should can used. Both les are plain text.
The `my.cnf'

file should be created in the root directory of drive C and the `my.ini'
file on the WinDir

directory e.g: `C:\WINDOWS' or `C:\WINNT'. If your PC uses a boot loader
where the C drive

isn't the boot drive, then your only option is to use the `my.ini' file.
Also note that if you

use the WinMySQLAdmin tool, only the `my.ini' file is used. The `\mysql\bin'
directory

contains a help file with instructions for using this tool.

Using notepad.exe, create the configuration file and edit the base section
and keys:

[mysqld]

basedir=the_install_path #e.g. c:/mysql

datadir=the_data_path #e.g. c:/mysql/data or d:/mydata/data

If the data directory is other than the default `c:\mysql\data', you must
cut the

whole `\data\mysql' directory and paste it on the your option new directory,
e.g.:

`d:\mydata\mysql'.

If you want to use the InnoDB transactional tables, you need to manually
create two new

directories to hold the InnoDB data and log les, e.g. `c:\ibdata' and
`c:\iblogs'. You

will also need to add some extra lines to the configuration file.

If you don't want to use InnoDB tables, add the skip-innodb option to the
configuration file.

Now you are ready to test starting the server.





I have the MySQL database installed under directory drive letter 'E:\MySQL'
, the 'E:\' directory being what I use for all my software, and I use my
'D:\' directory for all data. This would seem to suggest that I fall under
number 1. of the above circumstances. However, I am finding the following
notes (as copied above) from the documentation less than clear.

Can you advise or clarify what the correct process is in this case?

Mark















-
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: Coldfusion?database,sql,query,table

2002-01-11 Thread MSL

database,sql,query,table

Hi Andy

Wow! Well, that's made me take a double take! Sorry to hear of your woes, as
I know having to deal with that sort of thing (especially for so long!) is
no joke.

Seems strange that there are such diverging reports on coldfusion today, but
your experience and tales from 3rd parties has to be seriously considered.
Trouble is, I'm not too familiar with PHP and like everyone else, don't know
where the time can be found to learn yet another format, etc!

Mark


-
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