[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Dreamweaver changes database table name to lower case

Posted on 2007-07-27
5
Medium Priority
?
357 Views
Last Modified: 2010-04-25
Hi,
I'm using Dreamweaver 8 on a PC.

Whenever I use Dreamweaver to create a recordset from a mysql database, DW is changing the table name to all lower case. For example it references the table 'plugContacts' as 'plugcontacts'. I then have to go and edit it back manually in the code view, or I get an error when the page is executed.

It's just a bit of a bother! Can anyone recommend a fix to stop this action? I can't really change the database.

(BTW- it doesn't make changes to the case in the field references)

thanks
Nige
0
Comment
Question by:nigelhayler
  • 2
3 Comments
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 19582439
Hi nigelhayler,

I use DW8 at work and I do not have the same issue.  In your site definition, is "Case Sensitive Link Checking" checked?

Also, are you patched to 8.02?
0
 

Accepted Solution

by:
nigelhayler earned 0 total points
ID: 19591263
Hi Jason1178
Thanks, I tried your suggestion, but I've just realised something.

To investigate I have just installed an old copy of mySQLFront, and connected to the database using that. I can now see that the problem is actually in the copy of the database I have made locally, and not DW's fault at all. The local copy has somehow lost all its upper case chars in the table names (not in fields though- strangely), so DW is just using what it sees. Why didn't I think of that earler?

Many thanks for your suggestion though. Sorry about that!
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 19593982
No objections, V.  Close it up.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses
Course of the Month19 days, 17 hours left to enroll

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question