select

How to make <option> wider than <select> in IE6?

The <select> has a width of 60px, but the content of <option> is longer than that. Which is hidden in IE6. How to fix that? ...

JQuery select the next element

Hey, I am trying to use JQuery to select the next element in a set of elements with the same class. Here is the HTML setup: <div class="sameClass selected"> <p>Text in here</p> </div> <div class="differentClass"> <p>Text in here </div> <div class="sameClass"> <p>Text in here</p> </div> When I have the first div with the class ...

How to update a view part on change of a select tag

Hi, Using ASP.Net MVC 1.0 I have a form with some input control on it. One of them is a dropdown (select). When this dropdown gets changed by the user I like to update a DIV-tag using RenderPartial() or something like this. My view currently look like this: <% using (var form = Html.BeginForm()) { %> <label for="FieldIdentif...

How to add option to select list in jquery

My select list is called dropListBuilding. The folliowng code seems to not work: for (var i = 0; i < buildings.length; i++) { var val = buildings[i]; var text = buildings[i]; alert("value of builing at: " + i.toString() + " is: " + val); $("#dropListBuilding").addOption(val, text, false); } This line dies: $("#dr...

bug when prototype and jQuery are both loaded

I have function in Javascript which works fine using prototype. The function is used to dynamicaly change a select field based on the selection of another field. var sizes_286 = new Array(); sizes_286.push(new Array(536, 'Pequeno', 1661)); sizes_286.push(new Array(536, 'Médio', 1662)); sizes_286.push(new Array(536, 'Grande', 16...

A select question

There are groups like this; USER_ID SEQ_ID NAME 1 2 Armut 1 3 Elma 1 4 Kiraz 2 1 Nar 2 2 Uzum 4 3 Sheftali 4 4 Karpuz 4 5 Kavun After select query I want to see only; USER_ID SEQ_ID NAME 1 2 Armut 2 1 Nar 4 3 Karpu...

Tabulating an option of a select tag

Hi everyone, I am currently developing a Struts (1.3.10) application and I'm trying to show in a combo box a set of data. Every single option(row) is a String created by the union of 3 different Strings. My question is if it's possible to tabulate that information in every option from the combo box, to show the information like the exa...

Interbase SQL SELECT query using CASE

I'm running the following query against a .gdb-file: SELECT CASE USERS.USERID WHEN 1 THEN 'God' ELSE 'Somebody else' END FROM USERS; However, running essentially the same query against a .ib-file, I get "Error at line 1 Dynamic SQL Error, SQL error code = -104, Token unknown - line 1, char 17". It seems it doesn't recognize the part C...

TSQL SELECT then UPDATE in one transaction, then return SELECT

I am really having trouble with a query in my ColdFusion application (backended to MS SQL 2008). I keep getting DB deadlock errors on this transaction: <code> <cftransaction> <cfquery name="selectQuery"> SELECT TOP 20 item_id, field2, field3 FROM Table1 WHERE subject_id = #subject_ID# AND lock_field IS NULL AND ...

Selecting one element with multiple selectors in Jquery

Hi All, Im kinda new to Jquery, so this might be easy, then again i cant seem to find anything on Google. So here goes. I basically have this: <div> <div id="row1" class="col1" onMouseOver="OnMouseOver(11)"> I dont want to select this </div> <div id="row1" class="col2" onMouseOver="OnMouseOver(12)"> I wan...

selecting a row of data in sql for comparison

I have a set of string & numbers that I'd like to use between databases. the idea is that table A has a row of data with 2 values acting as a single primary key Table B has the same 2 values of data in a single row, or it doesn't... So... Id like to find out how many values from Table A (2 column values in a single row) match in colu...

SQLite - SELECT over multiple entries of the same data/column

I am a bit new to SQLite, and I am having a slight dilemma about my database design. I'll explain. Suppose you and your friends use a number of different nicknames on the Internet (can be more than one per person). What we have here is an ID of the person and a list of all nicknames that this person uses. This is a single entry in a larg...

Using char index to find numeric values

I have a column on a mysql table that stores mostly numeric values, but sometimes strings. It's defined as VARCHAR(20). There is an index on this column for the first four characters. ADD INDEX `refNumber` USING BTREE(`refNumber`(4)); Since the field is mostly numeric, it is useful for the user to be able to query for values that fall...

jQuery, Filter on Table

Hello, I have 1 problem , I've taken one jquery plugin (filter on table). This is URL : http://gregweber.info/projects/demo/flavorzoom.html But I have a little bit different case: Instead (textbox) I use (dropdawn menu) <select class="filter_tb"> <option value="">All</option> <option value="6-K">6-K</option> <option ...

SELECTing user with earliest time and joining with other data

I have an Oracle database where I'm trying to select a user field from the earliest row (based on a time field) where certain conditions are met, and I don't know how to do it. Here's the gist of my query: SELECT id, CASE WHEN value = 'xyz' THEN 'Pending' ELSE 'Not Pending' END AS status, ti...

jQuery: How to select the values from the table's column based on tables header only

Hello, I have a table with header ID. I need to select all the fields under this header. I don't have access to the source code and no classes are used in this table. Any idea on how to get this done? ...

SQL "GROUP BY" issue

Hi, I'm designing a shopping cart. To circumvent the problem of old invoices showing inaccurate pricing after a product's price gets changed, I moved the price field from the Product table into a ProductPrice table that consists of 3 fields, pid, date and price. pid and date form the primary key for the table. Here's an example of what ...

linq query from more tables

public ActionResult myItems() { var dataContext = new RecordsDataContext(); MembershipUser myObject = Membership.GetUser(); string CurrentUserName = myObject.UserName.ToString(); var user = from i in dataContext.myUsers where i.userName ==CurrentUserName ...

HTML <br /> inside a Select Box

I would like to know if there is anyway I can divide an item on two line inside a select box. One of the values of my select box is two long to fit in my div. ...

Rails, update 2nd select with static data from partial, based on initial select.

I have a rails form where the end user is going to drop down a list of categories, select a category. I need this selection to update the next select drop down. The issue is that the 2nd select needs to be populated by static data from a partial. The reason for this, is that its a product registration page, that includes more option...