select

HTML Select shortcut key override

I have dropdown list (HTML select element) which simply contains a heap of dollar amounts. E.g. $50,000 $100,000 $150,000 $200,000 and so on.. An example of one of the option elements inside it would be: <option value="150000">$150,000</option> I want the user to be able to start typing in 1..5..0.. and get it to auto-jump down ...

Displaying duplicate options values in a select with Cakephp

Hi, Using the form helper in Cakephp 1.3, I'm trying to display a list (drop-down list) which contains several duplicates value fields (in <option> tag of course), but cake seems not to want to let me doing it, and outputs only the first occurrence of each value. For instance, here's the 'options' array of the $form->input: array( ...

MySQL INSERT - SELECT syntax problem!

INSERT IGNORE INTO table3 (id1, id2) VALUES SELECT id1, id2 FROM table1, table2; What's wrong with the above SQL query? It shows me syntax error. ...

Codeigniter: getting select option from form

I'm trying to get the option item selected in a form select element using Codeigniter... I have a controller named results with this code in it ... `//get form data if($_SERVER['REQUEST_METHOD'] == "POST"){ $data['searchdata'] = array( "ionum" => $this->input->post('ionum'), "thisdb" => $this->input->post('thisdb') ...

What methods are present to select elements in chrome extensions?

I know about getElementById, getElementByNames ... and getElementsByTagName What other methods are available to select an element or elements from the DOM ? What if an item does not have an Id or Name. I have heard that I can use XPath expression to select a range of HTML elements. How do i do that using JavaScript? Is there a library ...

Javascript: Get selected option from list and paste it on a label tag

I have a list of countries, html, they have numeric ids and country name: Ex: <select name="userDto.nationality" id="userDto.nationality"> <option value="">Seleccione</option> <option value="1">Alemania</option> <option selected="selected" value="2">Argentina</option> <option ...

Dynamically adding items to a select list in Ruby On Rails using Ajax

I have looked at a whole bunch of solutions for this and maybe I am just dense, but I can't get anything to work. These are the two selects I am trying to tie together in a product/new view that will allow the user to select a category of product and then constrain the subcategory listing: <p> <%= f.label :category_id %>: <%= f...

Count number of NULLs in a row

Is there a way to get a column indicating the number of NULL fields in a row? This would be within a SELECT statement. For Example: Field1 Field2 Num_Null ----------------------- NULL "A" 1 UPDATE: I want this query so I can sort based on how many Affiliates sales there are of a given Book. So having 3 affiliates would b...

PHP Variable in Select Statement

Hey, first sorry that i had written it in german. Ok in english: i've written this PHP-Script which is working, and now i want to change the rowname into a variable to (not sure if row is correct), i mean the "name" from the select name... I've tried near everything, but nothing gave me the right result. I know that the normal thing ho...

iphone UIPickerView select row

Hi all, I have my view that contains the UIPickerView... I tried to make this code: [self.picker selectRow:rowSelected inComponent:0 animated:true]; to select the row with index rowSelected, but this doesn't work... I need to put this in viewdidload?? ...

How to identify when select option was selected (not necessarily changed) ?

The following code displays the new selected value if it is different from the current value: HTML: <select> <option value='123'>123</option> <option value='456'>456</option> <option value='789'>789</option> </select> JS: $(function() { $('select').change(function() { alert($(this).val()); }); }); I would like to d...

Need help with a complex SQL query

I have a stored procedure that uses this select statement: SELECT dbo.VendorProgram.id, dbo.VendorProgram.CODE, dbo.Programs.ProgramName + '-' + dbo.Divisions.Division + '-' + dbo.Vendors.Source + '-' + dbo.Mediums.Medium + '-' + dbo.VendorProgram.content AS SourceDe...

How my select list become uneditable?

Hi everybody, I am coding some sort of booking system - calendar. One of the features is also a (js) pop up window with detailed information about event - user can either view them or edit. Now my problem - I have put there a HTML select control (dropdown box), quite simple - 5 options. But somehow, and I have no ide why, this select i...

Mootools doesn't fire the "onChange" event for Selects in IE7

Hi, i'm working with mootools 1.2.4 and i have a select with an event "change" that works fine in Firefox but when i try to test it in iexplorer 7 it gives me an error saying that the select doesn't have that property or method: my code is as simple as: $('zone').addEvent("change",function(E){ alert("change"); }); i've ...

How to populate zend form select element?

Hello I have been searching for it from last couple of hours and have read every matching result google can give me but still can't get it to work. I am creating a zend form select element through: this->addElement('select','my_select', array( 'label' => 'Currency', 'value' => 'blue', 'multiOptions' => array( 'red' => 'Rouge'...

Select from dropdown list selected option with php after check

Hi! I ran out of ideas... Imagine, I have fields that must be filled <select> <option value="1">Yes</options> <option value="2">No</options> <option value="3">Fine</options> </select> <input type="text" value="" name="name"> <input type="submit" value="go" name="go"> butI forgot to fill my name and I press submit. How to return option...

How to implement where clause on Android Query method?

I'm trying to query a word, for this Im using the db.query method. But I want use a where clause, I've done like this on my code, but, the emulator returns an error. public String select(String wrd) { String list = new String(); Cursor cursor = this.db.query(TABLE_NAME, new String[] {"word"}, "word like " + wrd + "", null, null...

Collection_Select Default Value Not Set

I am having a strange issue with a collection_select I am using in an edit profile view in my rails application. The database IS being updated with the correct value, however the default value is not being selected for the select box when the user goes to edit their profile. I can not get a :include_blank => true or a :prompt => true t...

Simplify complex union all in PostgreSQL

I have very complex query in PostgreSQL that unions several tables, that all have common set of fields we want to union. currently we're pregenerating this query. I have seen solution to this using UNPIVOT and I'm wondering if it's possible to do this in PostgreSQL flavour of SQL. What I have is something like SELECT a,b,c FROM a UNION...

How to trigger a select box to open when a link is pressed. (HTML/iPhone/Javascript)

Basically, I'm building a mobile site with LOTS of content. I have a header, then a menu with three buttons that I need to open select menus so that the iPhone's select wheel will appear. Any ideas? So far my searching says not possible... ...