» Home » Select » Page 1
Moving options from a <select> to a <select multiple> - the option select attribute is breaking?
by stargazr in Web Design

I'm trying to write a plugin for Prototype where a user clicks on a dropdown and it replaces it with a multi-select element. I am almost finished with it. Everything works great until a user selects what they want displayed, and submits the form to the same page. I am using PHP to keep what the user chose selected using the selected attribute of the <option> tag.

mySQL Select priority - select one row OR another (select a default or “fallback” row)
by Sascha Brossmann in Programming Languages

This should be fairly simple but it's tricky to find the right term to use when searching.

In the query below, I need to select WHERE lang='en' ONLY if WHERE lang='nl_NL' returns nothing. In other words, I want to find all records WHERE script='generic', prioritised by lang=nl_NL

SELECT * FROM international WHERE scr

Pre-select Select or Mult-Select options from the existing ones instead of adding and selecting a new option
by California in Programming Languages

This code retrieves and displays the customer's account information from the database and pre-selects the values matching their information.

The problem is that instead of selecting from amongst the existing Select or Mult-Select options it is adding and selecting a new option with the relevant value/s. How can I correct it so that it selects from the existing options?


Select max value within other select statement and display also a relevant field from the nested select
by markku in Databases

I have a problem to express the next statement on mySql to return true results:

select max(alltaken)mn, b.title from
(select count(bc.taken) as alltaken, b.title
from books_clients bc
join books b on b.book_id = bc.book_id
group by b.title) as mn
join books b on b.title = mn.title

I need to return from

How to select in select where the inner select is a substring of return result
by AJ. in Databases

This is beset illustrate by an example that I think should work but doesn't:

select * from TABLE_A where KEY in (
select substr(DYNAMIC_KEY,3) from TABLE_B where DYNAMIC_KEY like '$$%' and RECORD_ID='104251893783388824');

Basically, the inner select statement return a set of result which had a '$$' prefix. This is use as a lookup key in TABLE_A which d

Select 1 Updates Select 2, but Select 2 doesn't fire
by NextInLine in Web Design

I'm trying to have Select 1 update Select 2 and then have Select 2 fire.

Select 2 only fires when controlled directly.. I'm stumped!!


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta ht

Inner joining to a select statement where the inner select statement's where clause references the outer select?
by Ir0nh1de in Databases

This is a slimmed down query of my greater problem, but the gist is that I'm trying to inner join to a select where the select is limited by the outer select. Is that possible? I'm getting an error about multipart identifier S.Item and S.SerialNum on the inner select.

The gist is this, we have to group by the item/serial, and the query is big enough, we don't want to go back and

How do I place pictures into a panel grid using the mouse to select a picture and select a square?
by CodeAndLearn in Programming Languages

Without disclosing details and spoiling the fun, I'll just say I'm making a game in vb.net and I need help with panels and more specifically, their paint grid features.

I already have this:

Private Sub gridPanel_Paint(ByVal sender As System.Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles gridPanel.Paint

Creating multiple select list options on the fly and reducing is subsequent select lists
by laptop302.vn in Web Design

I have been trying to solve the following problem for the last week or so, and after many searches around the internet, and on here, haven't found an exact solution for what I am trying to achieve.

This is my first post on here, and decided to post here as this forum has saved my bacon several times!

This is what I would like to happen:

User selects the numbe

How to use javascript or jQuery to quickly select a preset of multi-select listbox items?
by docp in Javascript

So say my page has a list of indexes '1,3,4,5,9,12' and a multi-select listbox with 12 items in it.

What's a fast way to use javascript to tell the listbox to multi-select all items at those indexes?

How would this be done using jQuery?

So for example if the user selects the 'caramel' preset associated with the 'candybar' listbox, it will select all the candy

Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2014 © bighow.org All Rights Reserved .