Search Results

Search found 23568 results on 943 pages for 'select'.

Page 500/943 | < Previous Page | 496 497 498 499 500 501 502 503 504 505 506 507  | Next Page >

• Deceptive MySQL Query

  - by jerebear

  So I don't consider myself a novice at MySQL but this one has me stumped: I have a message board and I want to pull a list of all the most recent posts grouped by the Thread ID. Here's the table: MB_Posts -ID -Thread_ID -Created_On (timestamp) -Creator_User (user_id) -Subject -Contents -Edited (timestamp) -Reported I've tried many different things to keep it simple but I would like help from the community on this one. Just to kick this out there...this one does not work as expected: SELECT * FROM MB_Posts GROUP BY Thread_ID ORDER BY ID DESC

  Read the article

• Drupal Exposed Views Filter custom date

  - by Jack

  I have a date filter that I have exposed on my view. I want to make the interface more user friendly and tighten up the look of it. Instead of selecting a date I would like to select from the following options. The last day The last week The last year All This would then filter on the date field. Is this possible? How would you go about doing this?

  Read the article

• Programming Language Suggestion App / Database

  - by Russell Giddings

  Is there an website anywhere that allows you to select required facets of a programming language and then suggests matching options for you to choose from? For example, say I wanted an object oriented language that was functional its would suggest F#, Python, etc.

  Read the article

• Shall the website switches language based on IP address or browser language?

  - by SuperRomia

  Geo-location has been using most by Websites to redirection, but I have found that several IP addresses locate a country which has using several languages. Meantime, some users prefer to using the language setup in their system. For example, a person from United States goes to Japan and using the Internet connection from there to surf Website, but the Website redirects him to Japanese language. So, shall I giving the web user choice to select the language detect on their browser or force them to the website detected by IP address?

  Read the article

• C# analog for sql in operator

  - by er-v

  There is in operator in SQL SELECT * FROM MyTable WHERE id IN (1, 2, 3, 4, 5) Is there similar sintax in C#, I mean if(variable in (1, 2, 3, 4, 5)){ }

  Read the article

• SQL dynamic date but fixed time query

  - by Marko Lombardi

  I am trying to write a sql query like the example below, however, I need it to always choose the DateEntered field between the current day's date at 8:00am and the current day's date at 4:00pm. Not sure how to go about this. Can someone please help? SELECT OrderNumber , OrderRelease , HeatNumber , HeatSuffix , Operation , COUNT(Operation) AS [Pieces Out of Tolerance] FROM Alerts WHERE (Mill = 3) AND (DateEntered BETWEEN GetDate '08:00' AND GetDate '16:00') GROUP BY OrderNumber, OrderRelease, HeatNumber, HeatSuffix, Operation

  Read the article

• <span> tag selection problem within anchor using jquery

  - by MH

  Dear expert, I have facing a problem to select span tag using jquery. Please give a solution. code: <ul> <li> <a href="#Document1">Document 1 <span id="tab_close> x </span> </a> </li> </ul>

  Read the article

• How to disambiguate a sequence in sql?

  - by Martin

  I have a table of data which represents a series of events that persons do over time, sometimes people do the same thing several times in a row. How to select a result using MS SQL 2008 that shows only disambiguated sequences of those events? Source data: Person Event Time 1 2 1 1 2 20 1 2 33 2 1 34 1 4 43 1 2 44 2 3 45 1 2 46 1 3 50 1 3 55 Result: Person Event 1 2 2 1 1 4 1 2 2 3 1 3

  Read the article

• Oracle SQL - How to Retrieve highest 5 values of a column

  - by Trevor

  How do you write a query where only a select number of rows are returned with either the highest or lowest column value. i.e. A report with the 5 highest salaried employees?

  Read the article

• Tootip steals mouse click

  - by deerchao

  I'm writing a custom TreeView from ScrollableControl. I decided to show tooltips when mouse is hover nodes with text too long to display. I find out when tooltips are shown, user would not be able to click the node to select it, because (I think) he's clicking the tooltip window, not my control. Is there any easy solutions? As I can see System.Windows.Forms.TreeView don't have this problem. Thanks!

  Read the article

• In SQL Server, how to move/import a multiple .trc files to a trace table

  - by frankadelic

  I have a set of rollover .trc files recorded with Sql Profiler. mytrace.trc mytrace_1.trc mytrace_2.trc mytrace_3.trc I can import the first one using this command: use [my-database] SELECT * INTO trace_folder FROM::fn_trace_gettable('C:\mytrace.trc', 4) However, this only appears to load the first file, not all four.

  Read the article

• Bizarre Escape Character Question

  - by William Calleja

  I have the following c# code embedded in a literal <% %> of a c# asp.net page string commandString = "SELECT tblData.Content " + "FROM tblData " + "WHERE (tblData.ref = N\'%"+myCurrentREF+"%\')"; This is breaking my code since it apparently cannot use the \' escape character. Why is it so? other escape characters like \" are working so why isn't \' working?

  Read the article

• How do I create a Django ModelForm, so that it's fields are sometimes required, sometimes not?

  - by Graf

  Ok, here is the question. Imagine I have a ModelForm which have only two fields. like this one: class ColorForm(forms.Form): color_by_name = forms.CharField() color = forms.IntegerField(widget = forms.Select(choices=COLOR_CHOICES)) So a user can either input a color name, a choose it from a list. Color is required, but that doesn't mean, that user should enter it manually. There do I put validation, so that my code checks if user selected color in dropdownlist and if not then he should write it manually?

  Read the article

• how to store a value returned from a sql query in a variable in batch programming ?

  - by Arunachalam

  how to store a value returned from a sql query in a variable in batch programming ? i can invoke sqlserver queries from my cmd prompt using sqlcmd server name then the qwery this is query statement i m going to use SELECT CASE WHEN DATEDIFF(minute, record_timestamp, GETDATE()) < 10 THEN 1 ELSE 0 END how to store the value returned i tried using set variablename but it save the statement rather than the return value .. and if i save this in a variable what type of variable it will can i compare it with numeric values in if condition

  Read the article

• Current network being accessed

  - by gn-mithun

  Is there way i can get the current network being used by iPhone programmatically in an iPhone app. To SImplify, suppose there are 3 networks visible in the wifi vicinity of the phone and i can see them in the settings page. I select one and is it possible for any app to find that out?

  Read the article

• How to create a drop-down list in java swing with multiple item selection?

  - by kartiku

  I'm aware of JList and JComboBox.....i need the combo box drop down functionality with multiple selection functionality that JList provides.... This is because the contents of the list are too huge to be displayed using a simple list. I also need to select multiple items, otherwise i would have been content with JComboBox. Any suggestions? Thanks.

  Read the article

• Can you create a linked server in SQL Server and then refer to it with an alias

  - by Craig HB

  Can you create a linked server in SQL Server 2008 and then refer to it with an alias. So, I create a linked server to "SalesServer", but I give it the alias "Sales", so I can use it like this: SELECT * FROM Sales.DB1.dbo.DailySales

  Read the article

• VB.NET Use With keyword on existing object?

  - by ropstah

  Is it somehow possible to use the 'With' keyword on an existing object? I would like to do the following using LINQ to objects and can't seem to find a way: From m as Product in Me _ Select m With {.Match = m.Name.IndexOf(query)} _ Where m.Name.IndexOf(query) > 0

  Read the article

• Use of var in linq

  - by mazhar

  What does var really do in the following case? var productInfos = from p in products select new { p.ProductName, p.Category, Price = p.UnitPrice };

  Read the article

• please help me construct this MYSQL Query (date / time)

  - by sebb

  Hi there i would like to construct a query that fetches results that occurred between NOW and 15 minutes ago, im getting a mysql error when I try the following , can you help me? thanks SELECT * WHERE user_id = '000' AND date_time < now( ) AND date_time > DATE_SUB( now( ) , INTERVAL 15 MINUTE)

  Read the article

• Django: Sum on an date attribute grouped by month/year

  - by Sébastien Piquemal

  Hello, I'd like to put this query from SQL to Django: "select date_format(date, '%Y-%m') as month, sum(quantity) as hours from hourentries group by date_format(date, '%Y-%m') order by date;" The part that causes problem is to group by month when aggregating. I tried this (which seemed logical), but it didn't work : HourEntries.objects.order_by("date").values("date__month").aggregate(Sum("quantity"))

  Read the article

• Visual Studio highlighting source code in bold

  - by widgisoft

  While editing HTML/ASPX/ASCX etc; whenever I select an html tag, visual studio highlights the entire tag in black and bold; the black I'm not so fussed about but the bold changes the length of the line and really messes up the formatting. Is there a way to disable this? Thanks, Chris

  Read the article

• php, sql selection

  - by cosy

  I have a stupid question, I have this table : id_product name value 1 price 10-20 1 type computer 2 price 20-30 3 price 100-200 and I want to select from this table GROUP BY id_product and ORDER BY value WHERE name='price' how can i do this? Thanks a lot

  Read the article

• Help With LINQ: Mixed Joins and Specifying Default Values

  - by Corey O.

  I am trying to figure out how to do a mixed-join in LINQ with specific access to 2 LINQ objects. Here is an example of how the actual TSQL query might look: SELECT * FROM [User] AS [a] INNER JOIN [GroupUser] AS [b] ON [a].[UserID] = [b].[UserID] INNER JOIN [Group] AS [c] ON [b].[GroupID] = [c].[GroupID] LEFT JOIN [GroupEntries] AS [d] ON [a].[GroupID] = [d].[GroupID] WHERE [a].[UserID] = @UserID At the end, basically what I would like is an enumerable object full of GroupEntry objects. What am interested is the last two tables/objects in this query. I will be displaying Groups as a group header, and all of the Entries underneath their group heading. If there are no entries for a group, I still want to see that group as a header without any entries. Here's what I have so far: So from that I'd like to make a function: public void DisplayEntriesByUser(int user_id) { MyDataContext db = new MyDataContext(); IEnumberable<GroupEntries> entries = ( from user in db.Users where user.UserID == user_id join group_user in db.GroupUsers on user.UserID = group_user.UserID into a from join1 in a join group in db.Groups on join1.GroupID equals group.GroupID into b from join2 in b join entry in db.Entries.DefaultIfEmpty() on join2.GroupID equals entry.GroupID select entry ); Group last_group_id = 0; foreach(GroupEntry entry in entries) { if (last_group_id == 0 || entry.GroupID != last_group_id) { last_group_id = entry.GroupID; System.Console.WriteLine("---{0}---", entry.Group.GroupName.ToString().ToUpper()); } if (entry.EntryID) { System.Console.WriteLine(" {0}: {1}", entry.Title, entry.Text); } } } The example above does not work quite as expected. There are 2 problems that I have not been able to solve: I still seem to be getting an INNER JOIN instead of a LEFT JOIN on the last join. I am not getting any empty results, so groups without entries do not appear. I need to figure out a way so that I can fill in the default values for blank sets of entries. That is, if there is a group without an entry, I would like to have a mostly blank entry returned, except that I'd want the EntryID to be null or 0, the GroupID to be that of of the empty group that it represents, and I'd need a handle on the entry.Group object (i.e. it's parent, empty Group object). Any help on this would be greatly appreciated. Note: Table names and real-world representation were derived purely for this example, but their relations simplify what I'm trying to do.

  Read the article

• mysql custom sorting first alpha then numeric using case when

  - by Nizzy

  How can you sort a query using ORDER BY CASE WHEN REGEXP? or other alternatives? I don't want to use UNION. Thank you mysql> SELECT `floor_id`, `floor_number` FROM `floors`; +----------+--------------+ | floor_id | floor_number | +----------+--------------+ | 1 | 4 | | 2 | 7 | | 3 | G | | 4 | 19 | | 5 | B | | 6 | 3 | | 7 | A | +----------+--------------+ Expected result: +----------+--------------+ | floor_id | floor_number | +----------+--------------+ | 7 | A | | 5 | B | | 3 | G | | 6 | 3 | | 1 | 4 | | 2 | 7 | | 4 | 19 | +----------+--------------+

  Read the article

< Previous Page | 496 497 498 499 500 501 502 503 504 505 506 507  | Next Page >