Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › MySql View Problem

MySql View Problem

Thread began 1/02/2013 2:50 pm by john70964 | Last modified 1/03/2013 8:05 am by Jason Byrnes | 576 views | 2 replies |

1/02/2013 2:50 pm | #1 john70964

MySql View Problem

I deleted two fields from a table which is used in a query. This caused a view to become unusable.
I created another view with the same name and it opens correctly from within Navicat.

I am using the view in a recordset in Dreamweaver and if I test the recordset it opens correctly.
However when I try to open a page where the recordset is used it creates an error message saying
Table 'bfsn.fullpath_image1' doesn't exist

I wondered if you can suggest a reason for this and how to correct the situation.
Many thanks
John

1/03/2013 4:17 am | #2 john70964

Just to let you know, I deleted and replaced the page with a new version and the problem disappeared.

1/03/2013 8:05 am | #3 Jason ByrnesWebAssist

most likely there was a place on the page that was trying to display the bfsn.fullpath_image1 column.

glad to hear you solved the problem by recreating the page.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.