Dreamweaver with myPHPAdmin - Columns don't show!

[sinistapenguin]

Hi All

I have just set up my first test mySQL database. I downloaded EasyPHP to get all the bits and I created a database using myPHPAdmin.

The database has a single table 'testTable' with 2 columns (although for some reason myPHPAdmin seems to call these fields!).

The fields are called 'Key' and 'testData'.

I then made a PHP page with a dynamic table and I can retrieve the records in my databae so I know the connection is working.

However, the next step was to create a form which uses the 'Insert Record' server behaviour in Dreamweaver.

When I open the server behaviour, I can select the connection and table, but I would normally expect to see the column names appear so that you can map the form fields to them.

When I do this I don't get any columns so I can't progress any further.

Does anyone know why I don't get anything in the 'columns' box?

Thanks

Sinista

 

[vacunita]

We need a little more information. How have you set up the site in dreamweaver. did you set up the connection to the database server. Is it giving off any errors. etc..
Did you define a connection and/or
Did you select the proper connection on the recordset dialog box.
???


If all is correctly configured you should get the list of fields in the small textbox below. the connection pull down menu.



----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[sinistapenguin]

Hi There

I have set up the site properly and set up the connection correctly. (I followed a tutorial from Macromedia!!)

If I enter data into the database through myPHPAdmin, then I can retrieve it in a recordset and display it in a dynamic table. So I think the connection etc is working properly.

When I open the Server Behaviour I can select the connection and it shows the only table, it's just when I choose the table, no columns show in the text box below!

Thanks

Sinista

 

[vacunita]

Other than checking that the user you are attempting to connect with has the proper permissions on the DB. There's not much more i can say.

What DB are you using? MYSLQ? PostgreSQL??
Where is the DB located, on you machine or ona remote server?

Bus since you say that everything else works, i.e the recordset behaviour, I'm baffled as to why the Insert behcaviour is acting up.

On a side note, Have you created a Form to atatch to the Insert Behaviour??

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[sinistapenguin]

I've figured out what the problem was - I wasn't selecting a 'Collation' for each column of the table when I set it up.

Does anyone know which one would be best? I'm using ASCII_General something now!!

Cheers

Sinista