select

Custom css select boxes using jquery

Hi all, I'm using this script http://mondaybynoon.com/2009/02/23/creating-custom-form-elements-using-jquery-selects/ to create custom css select boxes in my page. Javascript code that is used to apply the css styles on selectboxes, uses their id as a parameter: $(document).ready(function() { $('#cont').selectbox({debug: true}); }); <...

Does SELECT DISTINCT work with Perl's DBD::CSV?

Hello, I found a SELECT-example on the web. When I try it in my script I get this error-message: Specifying DISTINCT when using aggregate functions isn't reasonable - ignored. at /usr/lib/perl5/site_perl/5.10.0/SQL/Parser.pm line 496. #!/usr/bin/perl use warnings; use strict; use DBI; my $dbh = DBI->connect( "DBI:CSV:", undef, undef,...

Nested SELECT clause in SQL Compact 3.5

In this post "select with nested select" I read that SQL Compact 3.5 (SP1) support nested SELECT clause. But my request not work: t1 - table 1 t2 - table 2 c1, c2 = columns select t1.c1, t1.c2, (select count(t2.c1) from t2 where t2.id = t1.id) as count_t from t1 Does SQL Compact 3.5 SP1 support nested SELECT clause in this c...

In Selenium IDE how can you select an option by index in a dropdown menu?

The problem is the option labels change and so I cant grab by label. I need to grab by say option[0] any idea? I'm using Selenium IDE (Firefox), this is the piece im asking about: <tr> <td>select</td> <td>dateRangeString</td> <td>index=1</td> </tr> the last TD there is the VALUE field in the IDE, I already am targeting...

jquery - how do I make a select menu display itself without clicking it?

Using jquery, how would I make a SELECT menu display itself without actually clicking on it? I tried sending a click() event (in Safari and Firefox) but no luck. $('#myselectmenu').click(); Also tried focus() and select() (and various combinations of the three). Any ideas? Thanks! ...

Rails collection_select html options.

I can't seem to find the syntax to add a class to a select tag generated by rails collection_select. Some help? ...

List like select dropdown with jQuery?

Please, I want to simulate dropdown select, but there will be just links, no form. Trouble is how to have selected, and visible category or subcategory link where You are currently? <ul><li>Category <ul> <li>Subcategory1</li> <li>Subcategory2</li> </ul> </li></ul> So, when you are on the Category, visible will be nam...

disable text selection in gwt

hi, i am pretty new to GWT, i have an image that i have placed a text on top, i need the text to look as part of the image. i have used the image widget and the HTML widget to position it on top of it, i need this text to change according the locale. the problem that the text is selectable, so it does not look right. 1) is there any ...

Detect when a specific <option> is selected with jQuery

Hi, I have the following drop-down menu: <select name='type' id='type'> <option id='trade_buy' value='1' selected='selected'>Buy</option> <option id='trade_buy_max' value='1'>Buy max</option> <option id='trade_sell' value='2'>Sell</option> <option id='trade_sell_max' value='2'>Sell max</option> </select> I'd like jQue...

Using select fields in other computed fields in SQL Server

I have a table with columns A, B and C, and I want to select from that table, but with some additional fields computed from A, B and C and other computed fields. For example: D = A * B + C E = 2 * D + 4 * A F = D * D * E I thought I could solve that like this: select A, B, C, (A * B + C) as D, (2 * D + 4 * A) as E, (D * D * E) as F ...

XPath. Select nodes based on an other, related node

Hi All, I have an xml that contains two groups of related values: <Rows> <!-- first group --> <Row> <Sequence>100</Sequence> <Value>+</Value> </Row> <Row> <Sequence>105</Sequence> <Value>+</Value> </Row> <Row> <Sequence>110</Sequence> <Value>-</Value> </Ro...

<SELECT> (dropdown) doesn't render correctly when you add a <!DOCTYPE html blah blah blah...

I find this amusing and really annoying. On windows XP with IE7/8 the input boxes and dropdown boxes are rendered with a thib border and with rounded corners and they look good. I was redesigning our intranet (very messy code) and I started putting <!DOCTYPEs and all the "modern" things like css and so on when I noticed the dropdown box ...

MySQL: Select distict field, but get the rest of the columns as well?

I want to select distinct product_series, but I want all the other columns too. This is my query as it stands: SELECT DISTINCT product_series FROM cart_product WHERE product_brand = "everlon" AND product_type = "ring" AND product_available = "yes" But this only gives me product_series, but I need all the other columns in that row...

How to prevent saving in global variable to know the last clicked radio button?

I am trying to implement a grid with radio button selector. When the radio button is clicked, the row is set to a different color. Also, when a radio is selected in the grid, it needs to see if there was a previously selected radio button so that it could change the color set. <script type="text/javascript"> var lastSelectedId = ''; fun...

Jquery dynamically update "other" option in select

I'm working on a project that will be using a lot of select menus to enter various data. I'd like to include an 'other' option directly in the select that will trigger a simple dialog and allow users to enter a custom value (where appropriate) similar to the following javascript code: <script type="text/javascript" language="javascript"...

Php automatic page reload when choosing a value from HTML's <select>

PLEASE NO JS!!! <select> <option value="volvo">Volvo</option> <option value="saab">Saab</option> <option value="mercedes">Mercedes</option> </select> I simply want that whenever someone selects "saab", the page would reload. It's kinda like having the whole <select> inside a form (which is the ultimate solution), but I need no "...

Make it possible to ONLY select one row in datagrid?

Hey guys, As the title says - I want my datagrid to only allow one single row as selected at the same time. I guess I can do this by adding code to the datagridviews selectionChanged-event, but is there a better solution? I would prefer to just have a property to set, I.E. : mydatagridview.maximumNrOfRowsSelected = 1; or something sim...

Q>Query in Order/Purchase History of Northwind database.

How can I select query the order/purchase history in northwind database? There are 2 tables(orders and purchase order table) then connected to Inventory Transaction table. ...

How to have a query with columns needing different conditions in MySQL?

For a game, I want to count the number of user sign-ups by hour (using MySQL.). Quite easy, something like that: SELECT COUNT(*), DAY(date_user), HOUR(date_user) FROM users, GROUP BY DAY(date_user), HOUR(date_user) After that, I want to only take in consideration users which have played the game at least one time. I have a second t...

Select substring based on a string of options.

I have the following code // this text box can contain a URL such as: // http://vimeo.com/ // http://www.youtube.com/ // and so on. var text = $('#myTextBox').val(); var providers = "youtube|flickr|viddler|qik|revision3|hulu|vimeo"; if( text.match(providers).length > -1) { var selectedProvider = ???; } the match method looks i...