RE: Dreamweaver MySql Databases

[Gerald R. Jensen]

>>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:mussatto@stripped]
Sent:	Friday, July 05, 2002 11:39 AM
To:	Gerald R. Jensen
Cc:	Ben Bennett; mysql@stripped
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 <gjensen@stripped>
> To: Ben Bennett <ben.bennett@stripped>, mysql@stripped
> 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" <ben.bennett@stripped>
> To: <mysql@stripped>
> 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 <mysql-thread113813@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-autodata=execpc.com@stripped>
> 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 <mysql-thread113816@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-mussatto=csz.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 

Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27