Hello, I was wondering how sql server sorts it's data. I noticed that if I have a table that doesn't contain the column "Id" and you select data without "ORDER BY" sql server doesn't automatically sort on the primary column. Does anyone know what rule sql server follows to sort it's data? Regards, M. ...
Hi, I currently have two Ruby selects: one for categories and the other one for subcategories. As you may anticipate, the second one has to update itself every time the first one changes. For example, if I select from the first one the category "Sports", the second select should load all the sports. How can I handle that "index change...
I don't even know if I am doing this query the right way. There is a Sandwiches table that has some 7 fields and 2 of them are comboboxes (Type and Bread). So I made a query that combines all of the comboboxes values into one query, like this: SELECT TypesAndBreads.TBName, TypesAndBreads.Type FROM (SELECT [Sandwiches Types].[Sandwich T...
Hello everyone, I was wondering if anybody knows how to select using js the complete table, so that the user can right-click on the selection, copy it to the clipboard and then paste it on excel. If you select the table manually, the process works perfectly. But sometimes, if the table height is a few times larger than the screen, sele...
This is doing my head in! I have a select element with several options, however I cannot manipulate or access any of the options, as apparently the 'options' array does not exist. I have recreated the problem in a simpler html document: (original project is ASP MVC) <html><head><title>test test test</title> <script type="text/javascri...
I have an empty select element, I want to execute some code when that element is clicked on, but I do not want the dropdown list to appear, here is what I have found: When I disabled the select element I cannot catch the mousedown event. When I enable the select element I can capture the mousedown event but the dropdown list appears. ...
I have the following code to sort the items in a dropdown list: function sortDropDownListByText(selectId) { $(selectId).html($(selectId + " option").sort(function(a, b) { return a.text == b.text ? 0 : a.text < b.text ? -1 : 1 })) } this works fine except in cases where, in my first item, i have a *"Please select and ...
I want to select the first option in a select list which matches a certain value, currently the last match is selected, like so: jQuery('.edit-item').click(function(){ var id = jQuery(this).attr('id'); var assignee = jQuery('#assignee-'+id).text(); jQuery('#edit-form-'+id+' select[name=item[responsible]]').val(assignee); re...
I tried some plugins but they all come with their own styling which takes quite some time to get rid of. Is there any plugin with minimal styling (or a really simple way) to apply custom background to select element? I just need something very simple. Thanks ...
On my website, user's are allowed to filter games by Genre. When a user chooses a genre from the select box and hits submit, the page uses GET to see what the filter was. Now the filter works fine, the problem is that the select box's selection goes to the default one (Which says "All".) I want it so that after a user submits their filt...
Hi I am looking for way to implement multi selection enabled list box in windows forms C#. Any suggestions? Thanks. ...
i have a list of textboxes in a column of a html table. The table has an "Add" and "Remove" button next to it which (when clicked) will add new rows or delete existing rows. I would like to have a dropdown select on my page that is essentially linked to this array of textboxes, listing out the values of the list of textboxes so: if i ...
We're writing a client and a server to do (what I thought was) pretty simple network communications. Mulitple clients connect to the server which then is supposed to send the data back to all other clients. The server just sits in a blocking select loop waiting for traffic, and when it comes, sends the data to the other clients. This ...
i want to loop through all dropdown selects with a certain class name and add an item to it and i am just struggling with the correct selector EDIT: I must be doing something wrong as most of the upvoted accepted answer dont seem to work so i think there must be some quirk in my code. I have pasted both the HTML and the jquery code ...
I have an html table and in one column i have dropdown select. i would like a selector to get a handle to the dropdown in the last row of the table and change it to just regular text (using the value in the select). here is the tricky part, in some cases the last row will not have a dropdown and it will just be text in this cell and in...
I have two mysql tables - a sales table: +----------------+------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------------------+------+-----+---------+-------+ | StoreId | bigint(20) unsigned | NO ...
When I focus on a select box I want the hidden tooltip to appear. When I click on the select box the animation starts but the option list is hidden. How I get round this? <style> .showme {display:none;} li {height:25px;background:red; } select{z-index:100;} p{margin:0px;padding:0px;} </style> <script type="application/javascript"> $(do...
I'm sure this is super easy, but can't seem to figure it out.. I need to select all titles from my database where the title starts with A, or B, or C etc. Here's what I've tried so far: SELECT * FROM weblinks WHERE catid = 4 AND title LIKE 'A' but returns nothing.. Could someone help me out with this? Cheers ...
I'm investigating performance on an operation. I'm iterating a subset of items from a collection. I filter this collection using a Linq query. It basically looks like this: var filteredItems = items.Where(x => x.PropertyToFilterOn == filterValue); foreach (var filteredItem in filteredItems) { // do something to the filtered item } ...
Trying to use JQuery to scroll through a ul li list using class next and class prev e.g. <ul class="selectoption"> <li> Item 1</li> <li> Item 2</li> <li> Item 3</li> <li> etc .... </ul> <a href="" class="next">Next</a> <a href="" class="prev">Back</a> Only thing is I only want the selected li to be visable. So somehow need to...