Skip to main content ↑ ↓
Topic: Database Views Not Displaying on the Web Server (Read 1498 times) previous topic - next topic

Database Views Not Displaying on the Web Server


I noticed that drop down list with Database View as data source does not show any data when page is published on the webserver. (But works well on localhost)

So also does a page with a JOIN to a Database View. Can someone help please?

Attached image for illustration: the dropdown on Department has "list_of_department" Database View as it's DataSource.
The list_of_department Database View is created from table "Codes" WHERE code_type = "DEPT"

Re: Database Views Not Displaying on the Web Server

Reply #1 –
No help Team? Or is it a bug?

Re: Database Views Not Displaying on the Web Server

Reply #2 –
please mention your domain name for it check
 

Re: Database Views Not Displaying on the Web Server

Reply #3 –
Hello,

I fixed it. I had to recreate the Views on my database directly.

BR