close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Are predefined views not supported?

Thread began 4/13/2015 10:35 am by info4753 | Last modified 5/12/2015 4:53 pm by Ray Borduin | 800 views | 10 replies |

info4753

Are predefined views not supported?

This post has been deleted.

Ray BorduinWebAssist

Views should be supported and should work just like tables. Are you sure the view returns the same column names? The issue should not be the fact that you are using a view itself... there must be something else causing the issue.

Sign in to reply to this post

info4753

Thanks for your fast reply Ray. At the end I had a double WHERE in the statement (one from the view and one from the URL-filtering built with your tool) but the extension didn't show up the error while creating the dataset. On the page there were simply no data filtered and no errors shown.

Sign in to reply to this post

Ray BorduinWebAssist

I'm glad you got it figured out. There is a property where you can turn on debugging in the query class include file. You may get better error messaging when that is turned on. We have also updated the query file to improve debugging in the past few months, so you may want to try a fresh install and update if you haven't recently.

Sign in to reply to this post

info4753

Thanks Ray, I'll give it a try.

Sign in to reply to this post

info4753

I've tried this again and I think there is a major bug in your software. When using a view (with included WHERE statements) and then filter this view with an URL-Parameter no records will be found. Please see the code samples in the private section.

Sign in to reply to this post

Ray BorduinWebAssist

Please post your phone number in a reply to this thread and I'll call to debug this with you directly and try to figure out what is going wrong.

Sign in to reply to this post

info4753

Could you reproduce the problem? Even the easierst views can be filtered when using the Select-Statement that your extension ist creating. This should be easy to reproduce for you: Create a view in a database, the create a MSQLi recordset and filter the id with a session or a url parameter in your advanced panel. You won't get any data.

Sign in to reply to this post

Ray BorduinWebAssist

I was unable to reproduce the problem in my tests. If you post a US phone number or Skype contact information I'd do a screen sharing session to see what is going on.

Sign in to reply to this post

info4753

I don't have an US phone number and no Skype (neither cam and mic) on my developer Mac. I'll try to install everything on my laptop when I find the time. Thanks so far.

Sign in to reply to this post
loading

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...