select

How should i modify this SQL select?

SELECT TOP (5) mydb.Te.TeamGR AS TeamInGR, Te_1.TeamGR, SUBSTRING(mydb.Data.AkrivesSkor, 1, 1) AS GoalsIn, SUBSTRING(mydb.Data.AkrivesSkor, 3, 1) AS GoalsOut FROM mydb.Te INNER JOIN mydb.Data ON mydb.Te.TeamID = mydb.Data.TeamInID INNER JOIN mydb.Diorganoseis ...

Stack Overflow exception (0xC00000FD) at winsock select function

Hello, I have an application which makes use of winsock. I/O part is handled on an other thread. And I am using blocking select method for sockets. But the point is that after 5-6 hours,my application gives 0xC00000FD exception, at the line of select function. As far as I know, this exception occurs when there is recursion, or very l...

How to select columns from a table which have non null values ?

I have a table containing hundreds of columns many of which are null, and I would like have my select statement so that only those columns containing a value are returned. It would help me analyze data better. Something like: Select (non null columns) from tablename; I want to select all columns which are not-nullable for all rows. Ca...

Display input element when select option

I have a select element in the form with different options. On property of the 'select' is onchange="testRecurrence(this.form)" and the js function it's just: function testRecurrence(form) { if(form.repeat.value != "N") { form.endR.style.display = 'inline'; } return true; } Being 'repeat' the select and 'endR' the...

Set select options with jQuery

Hi, how do I set an option value in select list with jQuery? I tried: $('#SelectGroup :all').replace("tmp4", "abc"); I mean: Search for tmp4 string and replace it with abc. By the way: in the list there are 4 items I don't mind to go directly to entrance #4. Thanks ...

WPF: ListBox - setting focus on an item breaks keyboard navigation

After selecting ListBox item programmatically it is needed to press down\up key two times to move the selection. Any suggestions? View: <ListBox Name="lbActions" Canvas.Left="10" Canvas.Top="10" Width="260" Height="180"> <ListBoxItem Name="Open" IsSelected="true" Content="Open"></ListBoxItem> <ListBoxItem...

What are your recommendations on a jQuery custom select element plugin?

I've seen quite a few online and I thought I'd consult the Stack Overflow community for which they may have experience with and can make recommendations. I basically am looking for a plugin that can replace a select element with custom dropdown that uses CSS (not tables) fair bit of flexibility with styles lightweight ...

automatic selection in jquery select

Hello, When i use the following jQuery there is something wierd: $("input[name*=RELATIVE_symbol]").live("focusout", function(){ var fieldNum = $(this).attr('id').replace("RELATIVE_symbol_",""); var newVal= $(this).val(); if (newVal !="") { $("#SelectGroup option[value='"+fieldNum+"']").text(newVal); $("...

Select Query with MAX

Hey Guys, i've got a big Problem and i was trying the whole day and did not find any Solution. Hope you can help me? I have two tables: The first one named "orders": orders_id | orders_date | ..... 1 xxxxxxxxxx 2 xxxxxxxxxx 3 xxxxxxxxxx The second is "orders_history": orders_id | order_status_id | dat...

.NET DropDownList postback selection won't select anyting but first <option>

Hi, I'm having this problem with a .NET DropDownList control. PROBLEM: Every time I do a postback, It just defaults to the same first option tag as the one selected. I can't seem to get it so that it is pointing to the actual selected . Basically, here is what is happening. I make a DropDownList control in Default.aspx <asp:DropD...

What's wrong with this SQL query?

The following query returns ORA-00904 error: SATIS: Invalid identifier. When I remove the line HAVING satis > 0, it works. What should I do? SELECT donem, bolge_adi, sehir_tasra "1=Ş, 2=T", COUNT(DISTINCT mekankodu) "M.SAYISI", SUM(b2b_dagitim + b2b_transfer - b2b_iade) satis FROM mps_view2 WHERE donem IN ('200612','20071...

Why won't Oracle SQL let us use aliases in conditions?

Oracle PL/SQL won't let users to use aliases in conditions. In most cases it's very practical for me to use aliases instead of long statements. What's the reason for that? What bad would happen if we could use aliases in conditions? Example case: http://stackoverflow.com/questions/2235166/whats-wrong-with-this-sql-query ...

jQuery select text and add span to it in an paragraph

Hi, I have a function that gets the selected text, the text is selected by mouse, and add it into a variable. I want to add tags around that variable in the selected text - in that paragraph. $("p").live("mouseup",function() { selection = getSelectedText(); if(selection.length >= 3) { var $spn = $("<span></span>").html(selection).addCl...

SQL select inverted tree

Hello i have tree structure in sql. Logics is standard: SomeID, ParentID, other fields. I have select procedure, which selects data like this: 1. 1.1 1.1.1 and so on. How to write the select procedure, to get the inverted result(first are selected the deepest branches, last - root branches), like this: 1.1.1. 1.1. 1. 2.2.2.2.2. 2.2....

MySQL - Select statement, order by number of comments per article.

Hi I'd like to do something like the following: SELECT * FROM tbl_article JOIN tbl_comments ON tbl_article.id = tbl_comments.article_id ORDER BY COUNT(tbl_comments.article_id) Can anyone suggest how I might get this to work? ...

Dropdowns with 10 thousand possible values and sequence-important dropdowns vs. graceful degredation.

Background I have this form that uses javascript exclusively to search through ~5k entries (suppliers) and populate a select dropdown from them (factories, ~10k entries). Right now, it's a javascript-required form. I'd like to make it so that javascript errors no longer render the form unusable, but the number of entries and the seque...

SQL-query to find articles with at least one of the listed tags

I have 3 tables: articles, tags and article_tag (the one which connects them). I'd like to find all articles that have some (or all) of the tags listed in the query and order them by the number of matched tags. Is it possible? Example in english: Query: Find me all articles that have at least one of these tags "jazz, bass guitar, soul...

How to mark multiple UITableViewCells and perform an action on marked cells?

Hello, I would like to do pretty much what the Mail Application does: that when I select Edit, instead of the usual Delete Button, Radio Buttons appear on the side that may be checked by the user, then the user may click on a Button to take an action on the marked cells(any kind of action not just delete). Is there any apple sample code...

winsock select based server

I need an example of select based server, which receives and sends data from/to a client. I prefer MSDN example but I could not find any on MSDN. There is a good one here; http://tangentsoft.net/wskfaq/examples/basics/select-server.html But my implementation is almost same, except for, I did not set ExceptFDs, it is null. I set select ...

I can't prevent key presses from changing a selected option in Firefox

Using Firefox 3.5.7 The following test page should behave like Opera, Safari and Chrome. Key presses (arrows or 1-5) should have no effect (i.e. The events should be cancelled so that the number never changes from the initial default "3"). [I have separate working code for IE too]. Many thanks to anyone who can make it work? <html...