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
Solved

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

Posted on 2004-10-20
14
170 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
  • 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

 

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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying 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

Suggested Solutions

Title # Comments Views Activity
Remove LF from html text 5 417
Dreamweaver CS6 Sites Setup 2 428
installing adobe creative cloud offline 4 6,148
Element Positioning for Fluid Grid Layout 6 152
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 …
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

809 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