Dreamweaver MX & mySQL

munkyonline.co.uk · 12-15-2005, 06:19 AM

I'm pretty new at this and am learning as I go along. I'm having trouble understanding why Dreamweaver MX will pick up all the tables for my databases in the database panel but when I try and use a certain one to make a recordset from the bindings panel - the fields don't come up in the 'wizard'. This happens even if I have manually inserted info into the table using phpMyadmin. Yet afterwards if I create the recordset anyway - the fields are displayed in the bindings panel.

I also have the same sort problem when using the insert record feature with the same recordset and table. The form input names/id's are not displayed in the 'wizard' with the fields from the table in the database. If I try and insert a record into any of the other tables then they work fine.

This has completely confused me! I know it's something i'm doing/ Dreamweaver MX as it's doing the same with Oneandone and Verio as the host.

Any help will be greatly appreciated!

munkyonline.co.uk · 12-16-2005, 04:52 AM

I've narrowed it down now to two of the enum values. I think i may be able to work it out now. Thanks for all your help lol

12-15-2005, 06:19 AM	#1 (permalink)
munkyonline.co.uk New Member Join Date: Dec 2005 Location: Suffolk, UK Posts: 17 10.00 NP$ (Donate)	Dreamweaver MX & mySQL I'm pretty new at this and am learning as I go along. I'm having trouble understanding why Dreamweaver MX will pick up all the tables for my databases in the database panel but when I try and use a certain one to make a recordset from the bindings panel - the fields don't come up in the 'wizard'. This happens even if I have manually inserted info into the table using phpMyadmin. Yet afterwards if I create the recordset anyway - the fields are displayed in the bindings panel. I also have the same sort problem when using the insert record feature with the same recordset and table. The form input names/id's are not displayed in the 'wizard' with the fields from the table in the database. If I try and insert a record into any of the other tables then they work fine. This has completely confused me! I know it's something i'm doing/ Dreamweaver MX as it's doing the same with Oneandone and Verio as the host. Any help will be greatly appreciated! __________________ Real eyes realise real lies. ----------------------------------------- My website : munkyonline.co.uk

12-16-2005, 04:52 AM	#2 (permalink)
munkyonline.co.uk New Member Join Date: Dec 2005 Location: Suffolk, UK Posts: 17 10.00 NP$ (Donate)	I've narrowed it down now to two of the enum values. I think i may be able to work it out now. Thanks for all your help lol __________________ Real eyes realise real lies. ----------------------------------------- My website : munkyonline.co.uk

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOWTO: Install the Apache Web Server, Perl, PHP, and MySQL on Windows	deadserious	Webmaster Tutorials	96	05-27-2007 01:24 PM
Great Scripts for Sale With Resale Rights!	Zeeble	Scripts For Sale	20	01-04-2006 01:39 AM
MySQL Tips	shahid_146	Webmaster Tutorials	4	10-18-2005 12:53 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)