select

JQuery - Multiple Select Options

I am trying to grab all selected items in the following select multiple and separate them by a comma. The code is below: <select id="ps-type" name="ps-type" multiple="multiple" size="5"> <option>Residential - Wall Insulation</option> <option>Residential - Attic /Crawl Space Insulation</option> <option>Residential - Foundatio...

MySQL linking two tables without third table holding the relationship

Hi guys, say you have two tables table_a f1 <- PKEY f2 f3... table_b b1 <- PKEY b2 b3... now say table_a had a MANY to MANY relationship with table_b normally you'd have a third table to hold that relationship table_c c1 <- PKEY b1 <- PKEY of table_b f1 <- PKEY of table_a also say b1 + f1 for whatever reason could not be the ...

Sql Query With Select and IF

here is my table description: Table Name : Orders Columns : ID, NO, Quantity, Base, Code First my query should check the value of Code, if value of Code is 'B' then OUTPUT VALUE should be Code+Base if it is not 'B' then OUTPUT VALUE should be Code+Quantity the obtained rows again will be filtered by using where clause where ID='' ...

ORDER BY DECODE(BLAH, [COLUMN NUMBER]) on a single column query. How does it work?

Hi I need help to understand the decode part of a query that goes something like the following. SELECT ax.animal_code FROM raw_animal_xref ax, animal_xref_type axt WHERE ax.animal_mnemonic = l_animal_mnemonic -- Example 'COUGAR' AND ax.animal_code_type = axt.animal_code_type ORDER BY DECODE (animal_type, l_...

select option clears when page loads in php

Hey guys, the scenario is this: see select below <form name="limit"> <select name="limiter" onChange="limit(this.value)"> <option selected="selected">&nbsp;</option> <option value="5">5</option> <option value="10">10</option> <option value="15">15</option> </select> </form> I want whenever any ...

How can I verify that all select boxes have a selected option through JavaScript or JQuery or...?

I have 2 select boxes on a page with a variable number of options in them. For instance: <fieldset> <label for="fizzwizzle">Select a Fizzwizzle</label> <select name="fizzwizzle" id="fizzwizzle" size="10"> <option>Fizzwizzle_01</option> <option>Fizzwizzle_02</option> <option>Fizzwizzle_03</option> ...

Select Mulitple Records based on One record's column value

I have a table which contains related records (multiple revisions of the same record). Each record has a string field that resembles a date (date, time, and microtime). I want to select all records that are older than a specific date. If a record has a related record newer than the specific date, I do not want to select any of those rela...

load part of the page

hi i have 2 pages one is the main and the other is the sub-main main,html : <A href="sub-main.html#post5>go and load just post 5</a> sub-main.html : <DIV class=posttop id="post4"> here you can write anything ;) </div> <DIV class=posttop id="post5"> here you can write anything ;) </div> <link type="text/css" href="post.css" rel=...

HTML javascript select action

I got a selection list: <select> <option value="0" onclick="anders('1')">Anders</option> <option value="200" onclick="anders('');" selected="selected">&#8364; 200,-</option> <option value="300" onclick="anders('')">&#8364; 300,-</option> <option value="400" onclick="anders('')">&#8364; 400,-</option> <option value="500" onclick="anders(...

Selecting row while UITableView is in editing mode

I have a UITableView where when I put it in editing mode, I want selective rows to be selectable, however, they are not. Is there a way I can force them to be selectable? ...

Select database rows in range

I want to select the rows between A and B from a table. The table has at least A rows but it might have less than B rows. For example if A = 2, B = 5 and the table has 3 rows it should return rows 2 and 3. How could I get the rows in such a range? I am using Microsoft SQL Server 2008. ...

MySQL: SELECT(x) WHERE vs COUNT WHERE?

This is going to be one of those questions but I need to ask it. I have a large table which may or may not have one unique row. I therefore need a MySQL query that will just tell me TRUE or FALSE. With my current knowledge, I see two options (pseudo code): [id = primary key] OPTION 1: SELECT id FROM table WHERE x=1 LIMIT 1 ... and t...

Complex SELECT statement; one-to-many all details in one row

There are two tables: Products ID (Primary Key), ProductName PlannedByMonths ProductID (Primary Key) (Link to the Products table many-to-one), MonthNumber (Primary Key), QtytoProduce, How to write SELECT statement to retrieve results in the following format? ProductName, QtytoProduceMonth1, QtytoProduceMonth2, QtytoProduceMonth3,...

Select the number of rows instead of the content in it

Once, I used this query to select the number of items in order to create a list of pages: SELECT COUNT(id) FROM lists WHERE online = 1 But now it has become difficult, since there are more conditions. Now I need to know the number of lists that are online which have subtitles which have list items in it. I tried the following, but it...

Change DIV contents on SELECT change

I'm looking for a method of how to change the contents of a div when an option on a select dropdown is selected. I came across the following: <script type="text/javascript" src="jquery.js"></script> <!-- the select --> <select id="thechoices"> <option value="box1">Box 1</option> <option value="box2">Box 2</option> <opti...

asp.net mvc select question

i have model, in model such method public Pages GetPage(int? id) { return _dataContext.Pages.First(p => p.id == id); } if i pass whong parameter (like 123333-no record it database), it throw exception Sequence contains no elements can you suggest correct code version, or simply use try\catch? ...

Subselect Column Invalid issue

I have a sql issue with column names in a subselect im guessing its because it has yet to be assigned that name but I cannot work out how to rearange it. select Distinct Captains.Name, Captains.Team, (select count(Winners.Name) from (select HomeTeamCaptain As Name from fixture where fixture.HomeTeamCaptain = Captains.Name And fixture.ma...

How to setup a Zend_Form_Element_Select with multiple params at OPTION tags

Hi. I am creating a Zend Form to allow the user to change the current Locale from a list saved in my DB. I would like to know how to add more attribs to the option list. $obj_locales_select = new Zend_Form_Element_Select('sel_locale'); $obj_locales_select->setLabel('form-params-language-changelocale-sel_locale-label'); $obj_locales_sele...

on select display textbox with jquery?

Hi all, I'm sure this is super easy, but I can't seem to think what I'm doing wrong, anyway I have a "title" select list for my form, and I want to display a textbox if "Other" is selected. <select name="title" id="title" class="required"> <option value="" selected="selected">- Select Title -</option> <option value="Ms.">Ms.</op...

document.onmousemove / onmmouseup prevent selecting text in IE input or textarea

whenever i alter the onmousemove or onmouseup attributes of the document, for example: document.onmousemove = myOnMouseMove; document.onmouseup = myOnMouseUp; It prevents me from selecting text in any input type='text' or textarea elements in internet explorer (have tried in ie7 and ie8, fine in firefox). If I remove either of...