MySql won't report case mismatches as errors.
MySQL can be configured to convert all table names to lower case on storage and
lookup. Add the line:
set-variable = lower_case_table_names=1
to my.ini (or my.cnf)
-Original Message-
From: William R. Mussatto [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 05, 2002 11:39 AM
To: Gerald R. Jensen
Cc: Ben Bennett; [EMAIL PROTECTED]
Subject:Re: Dreamweaver MySql Databases
Does your server support .jsp pages?
Does your version of dreamweaver support editing .jsp pages?
If yes to both questions, you can install a copy of MySql on your
development box and develop there and move the pages up when you are
ready to go live. Make sure both databases have the same structure, if
you are developing under windows, keep the table names lower case as
windows does not respect case and MySql won't report case mismatches as
errors.
I do the same with Forte/Sun One. However, a page artist friend use
dreamweaver this way (avoids beans however) and recommends it.
On Thu, 4 Jul 2002, Gerald R. Jensen wrote:
Date: Thu, 4 Jul 2002 17:45:29 -0500
From: Gerald R. Jensen [EMAIL PROTECTED]
To: Ben Bennett [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Dreamweaver MySql Databases
Ben:
Is your website on the same server as the MySQL database? If so, you should
be able to install your HTML/ASP/PHP/Perl code with the query, and connect
via the localhost.
With the most popular (server-side) scripting languages, the query is
actually executed on the server.
Gerald Jensen
- Original Message -
From: Ben Bennett [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 04, 2002 7:10 PM
Subject: Dreamweaver MySql Databases
I can't upload my sql query to my remote MySQL database.
I'm using Dreamweaver and need to use a database for a few pages. My
hosting doesn't allow for remote Sql connections. What do I need to do?
-
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
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
-
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
