select

jQuery add blank option to top of list and make selected to existing dropdown

So I have a dropdown list <select id="theSelectId"> <option value="volvo">Volvo</option> <option value="saab">Saab</option> <option value="mercedes">Mercedes</option> <option value="audi">Audi</option> </select> This is what I would like <select id="theSelectId"> <option value="" selected="selected"></option> <option valu...

Optimizing Oracle CONNECT BY when used with WHERE clause

Oracle START WITH ... CONNECT BY clause is applied before applying WHERE condition in the same query. Thus, WHERE constraints won't help optimize CONNECT BY. For example, the following query will likely perform full table scan (ignoring selectivity on dept_id): SELECT * FROM employees WHERE dept_id = 'SALE' START WITH manager_id is n...

How to select an item in a listview which allows only 1 selected item at a time

Hello. I've been trying to select an item on an external listview but it seems to only work with listviews that accept multiple selected items: HANDLE process=OpenProcess(PROCESS_VM_OPERATION|PROCESS_VM_READ|PROCESS_VM_WRITE|PROCESS_QUERY_INFORMATION, FALSE, 0xC30); LVITEM lvi; LVITEM* _lvi=(LVITEM*)VirtualAllocEx(process, NULL, size...

How to select items in NSOutlineView without NSTreeController?

I'm using NSOutlineView without NSTreeController and have implemented my own datasource. What is the best way to select an item? NSOutlineView support already expandItem: and collapseItem:. And I'm missing a handy method like `selectItem:. How can I do it programatically ? Thank you. ...

How to empty a socket in python?

I need to empty the data on a socket (making sure that there is nothing to receive). Unfortunately, there is no function for this in the python socket module. I've implemented something this way: def empty_socket(sock): """remove the data present on the socket""" input = [sock] while 1: inputready, o, e = select.sel...

PHP: form select box doesn't write changed selection to DB

Okay, so I have this form that is set to preload a DB record for editing if you add a ?edit=1 to the url, it will load record #1 for editing into the form. I have a box that is like this- <select class="field select addr"> <option value="no"<?php if($row['has_amenities'] == "no") {echo ' selected=\"selected\"'; } ?>>No</option> <o...

Filter table from <select> input using jQuery

I'm trying to filter a table from an alphabetical <select> input with jQuery. I have first and last names in two columns of the table, and I'd like to filter the rows by either of these. I have a select input set up as so: <select> <option value="A">A</option> <option value="B">B</option> <option value="C">C</option> ....

MySQL, Given a list, selecting the missing rows from a Table

This has been driving me crazy for the past few minutes I have a table, lets say table_alphabet with three columns. letter(pri) col1 col2 a 24 55 b 45 45 c 23 44 ... y 33 55 z 45 22 Now in my application I have a list ('a', 'b', 'lol', 'cats', 'z', 'foo...

SQL: Using an INSERT within a SELECT statement

I have a SQL SELECT statement that will create its results in XML Format. I would like to INSERT into another table (Log via insert) every time a row is selected from the original SELECT Statement. Is there anyway to include an INSERT Statement inside of a SELECT Statement? SELECT cs_ads_StoreLocations.LocationGUID, *Bunch of S...

javascript selectlist remove all options

I have a <select> list which has been populated with several options, but want to remove those options to start again. I am using Jquery, and have tried: $("#selectId").length = 0; but this seems to have no effect. Part of my problem is that I am using firebug to debug, but the code does not break at the breakpoint, so I cannot s...

Make one field of Gridview the select link?

In ASP.NET 3.5, you can assign a Select link and change what the link actually displays. But can you you assign one of the fields in the gridview to act as a select button? For instance, all my records have a "SAMPLE ID" Field. It would be great to have each unique SAMPLE ID be a link that goes to the details view. I cannot find any set...

select with likewise data

I have a table in database that is having some fields one of which is 'action' action is having data like bse-similar,bse-action.....nse-similar,nse-action...etc. now i want to fetch the data that is having 'bse' in its action field. How can i do that in mysql????? One more thing i want to copy this data to another table.How can i do...

Context based search in JSP

I have a strange issue with the <Select><option/></select> tag.I don't write any code to enable context search(ie. if I type A it will list all possible combinations with A like AA,Aa,Ab,AB,Ac,AC and so on(not in the same order)).Similarly if I type Ab it should list all combinations starting with Ab which it does but the problem is you...

iphone - SQLite records on table dont coming ?

hello, i have a table. and 3 record. and i have that code; -(void) readScoreFromDatabase { sqlite3 *database; scores = [[NSMutableArray alloc] init]; if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) { const char *sqlStatement = "select name,score from game"; sqlite3_stmt *compiledStatement; if(sqlite3_prepa...

SQL Server - A script to loop through all remote tables and perform "Select * into ...'

Here's what I'd like to do. For each table in linkedserver.database whose tablename is like 'text%' (inside loop) A. If current_table exists locally, drop it B. select * into table.name (local) from linkedserver.tablename (copy schema + data) C. Possibly check for errors and Print some text about it? Next Any idea if this script ...

jQuery: Showing a div if a specific a <select> option is selected?

I'm working on the address page for a shopping cart. There are 2 <select> boxes, one for Country, one for Region. There are 6 standard countries available, or else the user has to select "Other Country". The <option> elements all have a numeric value - Other Country is 241. What I need to do is hide the Region <select> if the user sele...

"select" on multiple Python multiprocessing Queues?

What's the best way to wait (without spinning) until something is available in either one of two (multiprocessing) Queues, where both reside on the same system? ...

select all checkbox pagination help required...

Hi, I currently have a report with pagination, that displays 10 records Per page. Within this report, I also have a checkbox column for every record. Based on this, I want to incorporate a "Check All" feature, so based on my scenario which displays 10 records, when I press the "Check All" checkbox, I would like to check all the visi...

SQL select joined string for set of ids

I have to deal with a mssql database and the information given in a table like this: Users: ID Name Countries -------------------- 1 User1 1,2,3 2 User2 2,5 Countries: ID Country ---------- 1 Australia 2 Germany 3 USA 4 Norway 5 Canada Now, what i am looking for is a select statement that will give me a result like thi...

How to POST empty <select .. multiple> HTML elements if empty?

I have the following multi-select box in a HTML form, where user can select one or more option. <select id="eng_0" name="eng_0[]" multiple size="3"> <option value="Privilégier">Privilégier</option> <option value="Accepté">Accepté</option> <option value="Temporaire">Temporaire</option> </select> When the user selects no option, t...