select

How To Insert OPTIONs into SELECT with jQuery -- Cross-Platform, Even IE6

I need a cross-platform way to insert OPTIONs into a SELECT with jQuery. I think I recall in the past that IE6 does nothing when this is called: <select id="myselect" size="1"> <option value=""></option> </select> <script type="text/javascript"> $('#myselect').append('<option value="test1">test1</option>'); $('#myselect').append('<optio...

moving select options up and down via jquery

so I got this code working for Firefox and Chrome...what it does is it allows you to reorder the options within an HTML select form...but then when I tested the code via IE8, it's kind of patchy...it only works for the first few clicks and after that you have to click many times on the button for it to work.. Does anybody know any other...

Html 'Select' control always returnh selected index as 0

I have placed HTML 'Select' control on aspx page and it's items(options) are loaded dynamically using javasvript. The items in dropdown appear properly on web page. But when I select any item from dropdown, it's selected index is not returned in aspx.cs file. In fact, it shows selected index as 0 and size of 'Select' html control as -1. ...

Complex SQL query :: display data inline from multiply tables

Hi i have a proble in finding solution. I have 3 tables: Customer customer_id customer_name Relation subscription_id customer_id Subscriptions One customer can have relation with many subscriptions and i want to display data like so: customer_id, customer_name, subscription_first, subscription_second, subscription_n ...all i...

how to do mysql select query on two tables linked by another table

Suppose I have a table whose function is specifically to link two other tables in terms of OOP So suppose that I have two tables: one for person's name and another one for phone numbers Table 1: id person's name 1 John 2 Smith Table 2: id Phone number 5 23424224 6 23424242 And then I have a third table that links ...

how to get selected text from iframe with javascript ?

how to get selected text from iframe with javascript ? ...

Transact Sql LEFT function weird output

select replace(stuff('123456',2,2,'ABCD'),'1',' ') select LEFT('ABCD456',4) select left(replace(stuff('123456',2,2,'ABCD'),'1',' '),4) Ok now the first select outputs 'ABCD456', the series of functions evaluates to that exactly the first parameter to the left function in the second select second select returns 'ABCD' as expected thir...

[CakePHP] Why is the first item in select menu always empty?

Hi all, Using CakePHP, I created select-option form element with: echo $form->select('items', $numeration , array('selected' => 0)); It creates selection box, but the first option is always empty. How can I get rid of that empty option? I did not manage to do anything with showEmpty option... please help.... :-(( UPDATED: cakeph...

Aggregate functions return wrong values when joining more tables

I want to display all customers and their addresses and the number and total sum of their orders. My query looks like this: select *, sum(o.tota), count(o.total) from customer c natural join orders o group by c.custId; which works fine. but if I add a new table to the query: select *, sum(o.tota), count(o.total) from customer c ...

adding an additional link to the wp_pages_dropdown menu in wordpress

I'm working on a wordpress theme that uses dropdowns for part of the site navigation. I'm using wp_pages_dropdown and wp_dropdown_categories to output my menus as a dropdown jump menu, this is all good,works fine, but I would like to add a 'home' link to the end of the list of <option>'s I have been having a go at it - my html/css is ...

select_tag multiple and partials

I'm having a problem with some pesky select_tags, I can get them to show data fine on the new but when it comes to edit, they don't show up, here is the code I have at the moment. I think I need to use include? but I don't know where to put it. This is what I have at the moment for the new <% @data = Code.find(:all, :conditions => "sec...

SQL how to find rows which have highest value of specific column

For example, the table has columns MYINDEX and NAME. MYINDEX | NAME ================= 1 | BOB 2 | BOB 3 | CHARLES Ho do I find row with highest MYINDEX for specific NAME? E.g. I want to find ROW-2 for name "BOB". ...

Android - Inter thread communication and network socket

Hi this is what I am trying to achive 1) My main application/activity starts a thread to listen to network messages (tcp). But I want this thread to listen to network messages (on tcp socket) as well as messages from main activity. I am exploring if I can use socket for network messages and Looper for internal messages. I dont think it...

MooTools - How to use getSelected()

Been searching for this for over a day on google without any answers. Finally putting fingers to keyboard for this. So frustrating! I'm trying to learn MooTools and am a TOTAL javascript noobie so please be gentle with me. Okay, what I'm tying to do is to change the state of a disabled input field (type is text) when a particular optio...

PHP/SQL: Using only one query, SELECT rows from two tables if data is in both tables, or just SELECT from one table if not.

I have two rating/votes tables. One for user votes and stats and another for external votes. The external votes table always have data because it has a DEAFULT = 0, but the users votes only contains data if any user have voted for that specific ID. So I do something like this: $sql = 'SELECT ratings_stats.votes, ratings_stats.tota...

show/hide checkbox based on select option value

How to show/hide a checkbox based on select option value? I want to show a checkbox based on a single value in select option and want to hide it when other values are selected. I am trying for jquery solution. $('#abcselect').change(function(){$('#unknownlicense').toggle($(this).val() == 'first')}); ...

design of a select box - found something but need help

i have found this one: http://www.prismstudio.co.uk/2009/05/jquery-plugin-stylish-select-unobstrusive-select-box-replacement/ the problem i'm having is that i have 3 gifs: 1 for the left side rounded corner. 1 for the 2 paralel lines (i don't know the length of the dynamic select box). 1 for the select arrow how can i have that in this...

SQL select until full sort of problem

Hi I am trying to write some SQL that pulls from several tables using unions, where the date on the rows is less than a hour. But if the total rows from the SQL query doesn't add up to about 20 then it should change the where to the date being less than two hours and so forth until 20 rows retrieved. Is this possible to do solely in S...

Webmobile - Display 3 select boxes at the same time !

Hi! I have a mobile website (mainly iPhone, but Android and others too..) with a simple form. It contains three select boxes for the day, the month and the year. The iPhone automatically displays a pretty nice wheel for each one of the select boxes, but only one at the same time. Is there an easy way to display the 3 wheels (correspond...

How to select only one element of associated objects in to_json / to_xml

I have the following problem. My App (a prototype of an api) should be able to react on params (like language). I'm already able to respond to an request by sending an entierly object (with associated objects included) as JSON. But now i want to select the associated objects by parameter. my code: object.to_json(include => { :texts_...