logo-dw

Go Back   Dreamweaver Club Forums > Hand Coders Forum > PHP
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 03-02-2017, 02:09 PM   #1
a1adiver
 
Join Date: Feb 2017
Location: Atlanta GA
Posts: 3
Default View Created in MySql Not shown in Dreamweaver

MySQL 5.6, MAMP, Dreamweaver CS6 on Mac OS Sierra.

I have created a View in a MySQL database. The view correctly returns the data in MySQL workbench.

When I open up Dreamweaver (php) page and attempted to create a record set. In the advanced menu you can choose either tables, views, or stored procedures. I open the view. It has an arrow next to it, but there is no view listed. Any ideas.

Kent
a1adiver is offline   Reply With Quote
Old 03-03-2017, 12:52 AM   #2
edbr
edbr's Avatar
 
Join Date: Aug 2005
Location: Bali
Posts: 11,164
Default

none im afraid as i dont use dw for connections.
i did a quick yahoogle and there are a few issues posted. It would seem some issues with mysqli and only working if using PDO. in any case i dont think the dw wizards are up to the task.
In the ppast they always relied apomnt thier own very verbose connection procedure so unless you can create views in house and use prepared statements i would not use dreamweaver for this
__________________
If you're happy and you know it shake your meds!
different style links examples

Flight / Hotel search
Free script download
Bali Villas
edbr is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:32 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com