Solved

Can't see my Fields in my MySQL database when I view through Dreamweaver

Posted on 2004-10-20
14
173 Views
Last Modified: 2010-04-25

Perhaps something shamefully obvious, but I can't see the fields of my MySQL database when I try to view it  through Dreamweaver. I have connected to my mySQL database and am able to see the database table in my database applications window, but when I click on the  database, it appears to be empty.

I created the database using MySql and pHpmyadmin, and when I view it on pHpmyadmin it is populated and I can see the fields. But when I click on the table or try to view through  record insertion form - form fields area (I want to create a record insertion form) nothing seems to be there.

Thanks for viewing this.
0
Comment
Question by:ayounis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
  • 2
  • +1
14 Comments
 
LVL 10

Expert Comment

by:rockmansattic
ID: 12357541
so your saying that DW is connected t ot he database and it can see the tables (even new ones?)
but when you are trying to run a query, you cant see any fields (as in advanced mode?)

rockman
0
 

Author Comment

by:ayounis
ID: 12358249
Yes, it is connected to the database. I was following a tutorial which was going well up until I opened up a Record Insertion form, and where I expected to see my Form Fields, nothing was there. Should I see them? I sense I have missed a step or something. I haven't tried to run any queries yet.
0
 
LVL 10

Expert Comment

by:rockmansattic
ID: 12358324
not just using a insert form.  If you use the wizard, then it will do all the work for you.  the only way to see the fields in the insert form, it to create a form for the data, then add a server behavior, then you can choose which form field goes into which database field.

So , no you shouldnt see the fields in insert form.
you should if you run a normal request query.

Rockman
0
[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

 

Author Comment

by:ayounis
ID: 12358474
So... I choose a recordset and defined my connection(the connection to my database). My table appeared, I selected it, but '***no column found' appeared.

Now, did I run a normal request query there - or was that something else?

Thanks.

Adam
0
 
LVL 10

Expert Comment

by:rockmansattic
ID: 12358529
"Now, did I run a normal request query there - or was that something else?"
Yes.
wierd.

Are you connecting to this database locally?
how did you test the connection to the database in DW?

Rockman
0
 

Author Comment

by:ayounis
ID: 12358578
No, I am connecting to a database on a remote hosting company server.

I tested the connection by clicking on the database icon and selecting Test in the MySQL dialogue box. The connection came up as successful. Also, if I click on the + to expand the connection, I can see my table, but when I click on it, it appears to be empty. Also when I click on the connection in the recordset, my database appears.
0
 
LVL 10

Expert Comment

by:rockmansattic
ID: 12358634
I little beyond my expertise, but it could be that you dont have proper user access to the database.  
This hardly seems possible since you can see the table.

This is as far as I can go....
I would check with your hosting company to see if the settings are correct on thier side.
I would also put a 20pt question in the mysql section of EE that point to this one.  It may be a mysql question and not DW.

Good Luck, and Ill do some research when I get a chance.

Rockman
0
 

Author Comment

by:ayounis
ID: 12358667


Thanks for your time and the advice.

Cheers,

Adam
0
 

Expert Comment

by:scottparks
ID: 12365645
Make sure you have access to the MySQL database and that port 3360 is not closed at their router.  Typically you can not connect and use MySQL from a different host unless you have added that user.  

Say you have a user name:  dreamweaver and you are connecting from 192.168.0.5.  You would add a user dreamweaver @ 192.168.0.5 to the MySQL user table.

If you can not connect after that make sure port 3360 on your ISP is not blocked.

-Scott
0
 

Author Comment

by:ayounis
ID: 12370574

Hi Scott,

Sorry for the delay - I'm in Japan.Yes I have a connection. I have been playing around with it a bit more and I can now see the contents of the database. I am worried I am wasting other people's time here, and I should probably read the help files again. Basically I tried to create a recordset - I selected the connection I had created and my database table appeared. However what troubled me was that no columms were found even though the 'all' radio button was selected.

However when I clicked 'test', the database contents appeared in a 'test SQL statement' - so I guess it is there. I just expected it to be viewable in the recordset dialogue box under columns. Anyway, I'm going to go back to the tutorials I originally looked at, create the SQL database again and try again. I don't want to waste people's time here, if what I am seeing is completely normal - or due to me setting up my SQL database incorrectly.

Thanks for your help. I'll be back if I can't make progress with the new database.

Cheers Scott,

Adam
0
 

Author Comment

by:ayounis
ID: 12378267
Got this one sorted I think. The problem seemed to have been that mysql database had no autonumber specified and wasn't set to incriment.

I can see the contents now.

Thanks all.
0
 
LVL 10

Accepted Solution

by:
Havin_it earned 500 total points
ID: 12378699
Hi Adam,

I think it may be a bug in DW. Many people here have reported similar issues and (as in my own case) an explanation is not always forthcoming. If the problem recurs, check whether you are also unable to use Live Data View or conduct a URL Prefix test in the Site Definition wizard. I found these failed at the same time as the database connection.

I haven't found a fix or explanation for this behavior, it's happened to me on two different PCs, but it seems to go back to normal after a while (equally without warning). Not much help I guess, but just to let you know.
0
 

Author Comment

by:ayounis
ID: 12382146
thanks.

Adam
0
 
LVL 10

Expert Comment

by:Havin_it
ID: 12389458
You're welcome - hope it works itself out for you.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
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…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses

617 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