2
голосов
4ответов
3292 просмотров

SQL Server 2005 search views for certain database objects

Is there a way in SQL Server to list all the views within a database that join from a particular object? ie: find all the views that join from the table myTable

2
голосов
3ответов
932 просмотров

Rails: Make views editable by end-users?

Is there anyway I can make content in my Rails views editable by end-users? Such that they can make simple text changes on pages I permit them to without having me edit the HAML files myself? Thoughts? CLARIFICATION: I know about CMS systems, and I don't think that's entirely what I want. I wa...

4
голосов
1ответов
970 просмотров

asp.net MVC - Can I reference views from a class library?

In an asp.net MVC application, is it possible to reference views from a class library in the same way that it's possible to reference a class library of server controls or user controls in Web Forms asp.net? I've seen this blog post: http://padcom13.blogspot.com/2009/04/splitting-aspnet-mvc-appl...

0
голосов
1ответов
282 просмотров

How can I rewrite this complex SQL query to not use a subquery for MySQL Views?

Well for whatever reason MySQL does not support subqueries in a View. I'm stuck using MySQL for the forseeable future and I'm needing to write a View to aggregate data from an EAV-style table into a more readable format. The View itself is going to act as the Model for a Ruby on Rails-based app...

4
голосов
2ответов
4987 просмотров

Android: What care should I take when using a View's setTag() property?

Because Java uses object references and not objects themselves, what prevents me from using setTag() to tag a view with an entire object instead of an object's property? Is it just the attribute lookup time when trying to resolve one of the attributes after the getTag() call or is there any other...

1
голосов
4ответов
5668 просмотров

SQL Server, views and datetime conversions

So I have a base table that looks something like this. SELECT [BILL_MONTH] ,[BILL_YEAR] ,[BILLED] FROM bill_Detail Everything is varchar. I created a view based on that table that converts the bill year and bill month to a datetime field. Of course, the bill_month and bill_year ...

0
голосов
1ответов
398 просмотров

Editing Multiple Records - Granting Access to All Logged-In Users

As far as I can tell, this is a views and controller problem. I need to allow users to edit multiple records in one of my database tables. Railscast 165 deals with a similar situation, but it's not quite on point for me: http://railscasts.com/episodes/165-edit-multiple I have a fixed set o...

2
голосов
1ответов
863 просмотров

Resolving interface as UIElement (Unity, PRISM, C#)

when using PRISM the normal way to hookup things with unity is to define an interface and register an implementation with this interface. Now, I have a problem regarding views. The scenario is simple: Assume a custom video control which allows to set a Play command. This control is defined by a ...

0
голосов
3ответов
244 просмотров

Oracle IDE to visually create views?

Oracle IDE to visually = wizard (not writing sql) create views? any names? (eg like toad) SQL Server Management Studio = can create views visually for sql server what is same for oracle

2
голосов
2ответов
639 просмотров

Oracle material views vs analytic workspaces

In Oracle, what are the pros and cons of using materialized views, and of analytic workspaces? What are the best practices surrounding the use of these features? We have an OLTP system, but would also like to access summary information in reports and interactive decision support tools.

4
голосов
4ответов
1062 просмотров

Does the number of columns in a view impact performance?

I have a view that pulls about 200 columns from a table, no joins. The procs that use the view only use about 10 columns from it. Does having the extra 190 columns have a significant impact on performance using the view? EDIT: Just to clarify based on original questioner's comment, the query in ...

1
голосов
1ответов
361 просмотров

Trouble with Multiple Modal Views

The issue that I'm having is that I have My start page, then the user can select a button from there to open a settings page (Modal View). From the settings page the user selects the switch to turn on the PIN code page (another Modal View). I have been killing myself trying to implement this simp...

4
голосов
5ответов
979 просмотров

asp.net mvc - constructing views completely off custom fields in DB

i'm working on designing an asp.net mvc web app. There will be half a dozen (maybe more to come) different user groups of the app and they all work with similar but tweaked UIs, each with a few custom fields but all using the same objects. one idea for creating the UI is to store Control info ...

9
голосов
7ответов
3300 просмотров

asp.net MVC - complex example?

We're evaluating asp.net MVC and are looking for some more complicated examples over and above NerdDinner. Specifically, in a more complex web app, I might have a navigation bar (including primary nav, a search box and a log-in status display), a main content area, a sub-content area (including ...

3
голосов
4ответов
2119 просмотров

Putting an ID on in ASP.NET MVC

I would like my views to be able to specify a class for the <body> tag, which lies in my master page. My first take was to do something like this: <asp:Content ContentPlaceHolderID="BodyClassContent" runat="server"> view-item</asp:Content> However, that would require th...

2
голосов
1ответов
562 просмотров

Intelligent Keyword Searching

I have a taxonomy vocab assigned to a content type in Drupal 6. I've then exposed (using "is one of") it as a field in views which allows a user to search via keywords. The problem is when it runs the query it is first referencing the term so instead of using a like statement it looks the term u...

9
голосов
10ответов
5402 просмотров

Is it OK to nest database views?

In the world of oracle, I have the impression that views based on other views are considered to be bad practice. I myself have complained about this when the trying to solve performance issues and the nesting seemed excessive and hid away unneeded complexity in the underlying views. Now I find my...

25
голосов
5ответов
17432 просмотров

MySQL Views - When to use & when not to

the mysql certification guide suggests that views can be used for: creating a summary that may involve calculations selecting a set of rows with a WHERE clause, hide irrelevant information result of a join or union allow for changes made to base table via a view that preserve the schema of ori...

0
голосов
1ответов
313 просмотров

Drupal6: Every node view of a certain type leads to 404 error

For some reason, trying to view any node of a certain content type leads to a 404 error. When viewed in a View table, they display just fine. What could be happening? Viewing the database with phpMyAdmin shows the data just fine. The problematic node type was created with CCK.

2
голосов
2ответов
1346 просмотров

MVC View and JavaScript file

When inside a View, within MVC, and you have your JavaScript, I tried to move it to a JavaScript file in the same directory, and it reports it can not file the javascript file As an example I user NerdDinner and the DinnerForm.aspx, created a JavaScript file in the same directory as the DinnerFo...

0
голосов
2ответов
711 просмотров

django view function code runs after return

I have a django view that looks like... def add_user(request): if User.objects.get(username__exact = request.POST['username']): context = { 'message': "Username already taken"} return render_to_response("mytemplate.html", context, RequestContext(request)) ...

0
голосов
3ответов
359 просмотров

ASP.NET - Avoiding Database calls to display Grid Views

We are working on Grid Views in an ASP.NET application. Here we would like to avoid the database calls for binding dataset/data table to grid view whenever a user clicks on sort (column sorting), pagination links or whenever he updates a record. Would you please let me know the best practice to...

0
голосов
2ответов
558 просмотров

Rails - Problem calling column from join table

I have an index of users where I display the user name, location of user and a field called categories, which can range from zero to many items. I'm having trouble getting the categories to display properly. Here are my details: User has_many :user_categories has_many :categories, :through =...

0
голосов
5ответов
1073 просмотров

Where can I find a host with stored procedures?

I have created a project that uses mysql stored procedures and views. I have a lot of difficulties to find a hosting service that would support them. Do you know where I can go? thank you.

0
голосов
1ответов
768 просмотров

Drupal 6: How do I only call up "events" by upcoming date?

I am a newbie to Drupal so this may be a simple answer... I am building a site that on the homepage I want to be able to call up events that will happen in the next 6 months and then disappear after the event has past. I have made a field called event_start_date that you can enter the "From" and...

0
голосов
3ответов
2132 просмотров

Drupal path problem - views vs node

I've got a problem with my site search not linking properly to my views pages. I've got a views page set up to display recipe data. It has the URL properties of: index.php?q=recipe/%1/%2 where %1 is the recipe category, for example, breakfast, and %2 is the recipe name, for example, Muffin. Th...

0
голосов
2ответов
117 просмотров

Strongly typed views

is it possible to pass derived types where base types are expected to strongly typed views? I.e Products/List News/List where "list" view Inherits System.Web.Mvc.ViewPage<Model<BaseList>> controller renders view i.e View("List", ProductsList) edited return View("List", new ...

0
голосов
1ответов
106 просмотров

Linking to Dynamic Content in Rails?

I have three models. User, Product, and Season. I used a standard "has many through" approach: user has_many :seasons user has_many :products, :through => :seasons product has_many :seasons product has_many :users, :through => :seasons seasons belong_to :product seasons belong_to :user...

2
голосов
1ответов
144 просмотров

Can I disable auto formatting in vs2008?

How can I disable auto formatting for views (html files) in vs2008?

0
голосов
4ответов
102 просмотров

CakePHP views question

I am working on a project using CakePHP and have been trying to update some views. The file uploads to the server correctly but the system seems to serve the old version. I am kind of new to Cake so I'd appreciate any pointers. Thanks!