How can I check if a View exists in a Database?
Hi, I have some SQL code that needs to be executed if a certain View exists in a database. How would I go about checking if the View exists? EDIT: The DBMS being used is Microsoft SQL Server ...
view
ORDER BY in a Sql Server 2008 view
Hi all... we have a view in our database which has an ORDER BY in it. Now, I realize views generally don't order, because different people may use it for different things, and want it differently ordered. This view however is used for a VERY SPECIFIC use-case which demands a certain order. (It is team standings for a soccer league.) Th...
Changing a UITableView's scroll insets programatically to reflect the size of an iPhone keyboard
I know you can use the "Inset" property in Interface Builder to make a scroll view be inset from the main window so that it doesn't go below existing controls on the screen such as a tab bar, but how can you do this programatically to adjust for when a keyboard is added to the screen? Currently my scroll view has cells under the keyboard...
ORACLE : Materialized view- change START WITH CLAUSE
I created a Materialized view using the following code: CREATE MATERIALIZED VIEW M_USER_HIERARCHY BUILD IMMEDIATE REFRESH COMPLETE START WITH TO_DATE('25-Aug-2009 10:34:24','dd-mon-yyyy hh24:mi:ss') NEXT SYSDATE + 1 WITH PRIMARY KEY AS SELECT * FROM V_USER_HIERARCHY; However, I want to be able to change the START WITH date A...
How to set default XAML view in Visual Studio 2008
In Visual Studio 2008, when you add a new XAML window to a WPF Application Project, the default view you get is "split view" where the visual designer and the XAML code are shown one above the other in the same document. I prefer an alternative view which you can get by double-clicking on either the Design or XAML tabs. The visual desig...
Multiview - View Clear State
Hello all, Thanks in advance for your help. I am using c#.net. I have two views on my webpage (contained within one multiview), both contain buttons. view_1 Contains a repeater/datasource and an custom made ‘edit’ button (which holds the ID for each row returned). view_2 Contain an ‘update’ form and a ‘update’ button. When the u...
How do you check for updates across many tables in Oracle?
I have a trigger to check for a single column in a table, when there is an update (AFTER UPDATE) in that column my trigger is called and then I call a stored procedure from within my trigger in order to perform some business logic coded in Java. So far, so good. Now things are getting more complicated, there is a new requirement that im...
inserting into a view in SQL server
I have a SQL Server as backend and use ms access as frontend. I have two tables (persons and managers), manager is derived from persons (a 1:1 relation), thus i created a view managersFull which is basically a: SELECT * FROM `managers` `m` INNER JOIN `persons` `p` ON `m`.`id` = `p`.`id` id in persons is autoincremen...
Time Touch Events Take in iPhone SDK
Hi Everyone: I am wondering how I would go about measuring the time in between touches inside a view in the iPhone SDK. I know that the first event triggered is touchesBegan: and then the last one triggered is touchesEnded:, however I just don't know how I would go about measuring the time that the user has touched the view for. For i...
Cannot put breakpoint in an ASP.NET MVC view when running in IIS7
I'm forced to use IIS7 because Casini is only x86 and we are running with x64 ELMAH. Something I've noticed since I've switched is that I cannot set breakpoints in ASP.NET MVC views anymore. I'm not totally sure it's because of IIS7, is it? Does it happen to you as well? The Visual Studio (2008) project is configured to use the local I...
CRUD pattern for urls.py, passing object from URI to view
Can the object value be looked up and passed to the generic view? Would the generic views need to be moved to views.py in order to support the object lookup? urls.py urlpatterns = patterns('myapp.views', url(r'^mymodel/create/$', view='mymodel_create', name='mymodel_create'), ) urlpatterns += patterns('django.views.generic', ...
Qt jpg image display
I want to display .jpg image in an Qt UI. I checked it online and found http://doc.trolltech.com/4.2/widgets-imageviewer.html. I thought Graphics View will do the same, and also it has codec to display video. How to display images using Graphics View? I went through the libraries, but because I am a totally newbie in Qt, I can't find a c...
Django: how to retrieve an object selected by the ``object_detail`` generic view ?
Hi (sorry for my ugly english) I wonder if this is possible to retrieve an object which was selected with the object_detail generic view. For example : from django.views.generic.list_detail import object_detail def my_view(request, slug) response = object_detail(request, MyModel.objects.all(), slug=slug, slug_fie...
How do I choose the correct view for zooming with multiple UIScrollView objects in a view (iPhoneSDK obj-C)?
I have added several UIScrollViews as subviews of a single UIView and set the frames so that each one is clearly visable. I set scrollEnabled to YES and set the contentSize larger than the bounds/frame. I do this in a for loop, and with each pass of the loop I release the UIScrollView (though the object is still stored because it has bee...
[ASP.NET MVC] Two data sources in one create view
This is what my data model classes look like: public class Employee { public string FirstName { get; set; } public string LastName { get; set; } public Position Position { get; set; } } public class Position { public string Title { get; set; } } I have a Create view where I want to have two text boxes for first name a...
MVC Navigate to different controller view
I'm having trouble navigating to a different controller view from another controller action. e.g. return view("edit", "profile", profile); I'm trying to navigate from the account controller to the edit view in the profile controller. Any suggestions? Thanks, -Mike ...
View for each condition in ASP .Net MVC Controller
Should I create a related view for each condition in my controller? e.g. I have the following code public ActionResult List(){ List<Report> reports = getReport(); if(report.Count > 0){ //returning the normal view return View(); }else{ //show the view for no reports return View("NoReportAvailable"); } } or i can also have only one...
Register identical views with different services using Composite Application Library
I'm using the Composite Application Library with Silverlight, and I need to add three "zones" to my region. These "zones" all have essentially the same view and presentation model. (I'm getting these words from the StockTraderRI application. Correct me if I'm wrong.) The only difference I have is where I get the data from, so I want ...
MySql View - Value from one column where some other column is max
I have Table1 and Table2 related on Table1.ID. There can be zero or more Table2 records for a given Table1.ID. I have a view where I want to get Table2.Value where Table2.ID is max for a given Table1.ID. A friend suggested a derived table, but that requires a subquery in the from clause, and MySQL doesn't like that. Are there any oth...
ASP.NET MVC Views problem
Hi, I'm hit a problem when attempting to deploy a MVC app as a sub-application of an existing ASP.NET 3.5 app (non MVC). The error is: - The view 'index' or its master could not be found. The following locations were searched: ~/Views/employment/index.aspx ~/Views/employment/index.ascx ~/Views/Shared/index.aspx ~/Views/Shared/index.as...