Solved

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

Posted on 2004-10-20
14
167 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
 

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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

707 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now