select

Select statement using WHERE x IN (SELECT ...)

I have two tables: [ product_to_category --------------------- product_id category_id [ category --------------------- category_id parent_id I need to get all product_id's with a category.parent_id of '39'. Here's what I'm trying, but it's returning empty when there are at least a few hundred: SELECT product_id FROM product_to_cate...

IE6: get value of a DOM select element

So I'm having a crossbrowser javascript issue. I've got a <select> dom element that has some descendent <option> element with selected=true. In Firefox, I can just do select_elt.value to get the value of the selected option, but this seems not to work in IE6 (which I need to support). I tried to iterate through the select_elt.getEleme...

Lost in Multiple Fork(), Pipe() and Select()

Hello, Hope I can find some help here cause I'm starting to give up. Heads up as this is an homework assignment, hence why it might be stupid. Context: Have to program something which will be shell executed as such: logn [--tick n] cmd [args] [, cmd [args]]... Basically, it's a program that multiple programs simultanously. Constraint...

Having trouble with pipes and select()

Hello, I seem to be having trouble with pipe and select. Context: Have to program something which will be shell executed as such: logn [--tick n] cmd [args] [, cmd [args]]... Basically, it's a program that multiple programs simultanously. Constraints: Each output line has to start with it's command number in front in format printf ...

Best way to unselect a <select> in jQuery?

<select size="2"> <option selected="selected">Input your option</option> <option>Input your option</option> </select> How to do it elegantly? ...

Multiple Select with Explode: only returns the word "Array"

Using Wordpress I have created a multiple select box so that users can select categories to exclude. When the page initially loads I see my default values pre-selected. However when I select new values and save... I only see the word "Array" echoed and nothing selected? <select class="amultiple" id="<?php echo $value['id']; ?>" name="<...

select() on socket (trouble)

Recently I have done this part of code: http://dumpz.org/14945/ It does work, but select() works bad. When it has got last reply from server, it begins repeating last reply string with some strange characters in the beginning of reply string. So look at this: :[email protected] PRIVMSG testuser1 :VERSION �C���C��[email protected] PR...

pdo Invalid parameter number

Hello, My problem is the following Y have two functions that are called from inside a function(method) If the outcome of the first function is TRUE, the second function runs a select and an update query. The second function runs a select with the query($sql) command The update query uses: $stmt = $db->prepare($sql); $stmt->execut...

can this be written with an outer join

The requirement is to copy rows from Table B into Table A. Only rows with an id that doesn't already exist, need to be copied over: INSERT INTO A(id, x, y) SELECT id, x, y FROM B b WHERE b.id IS NOT IN (SELECT id FROM A WHERE x='t'); ^^^^^^^^^^^ Now, I was trying to write this with an outer join ...

Scroll up/down while selecting multi-page block of text in Vim through putty

I'm using vim 6.3.81 on a xterm through putty. When I use set mouse=a , I can scroll through the file , but not select text. When mouse is disabled using set mouse=, I can select text with mouse (automatically copied to a buffer) , but if the text block is over one page long , I can't scroll up/down (and have to select text one screen at...

How to display another form on select of button

Hi everyone I created jsp which has 2 forms. In UI there are 2 buttons. On select of each button respective form should be displayed. But while trying to do this its not allowing me to display other form on button click. Can I have any sample code such that it will resolve my problem and i can proceed with my work. I will be thankful for...

html php and select box simplification

Is there a better way to structure this, using html and php? If I had a billion values, this would be a bad way to set them up, not to mention time consuming as well? I am a newb, and I am pretty sure there is a better way, however, my way of doing it seems to be the long way, as in long division, I am pretty sure there are easier meth...

MySQL - How to select data by string length

SELECT * FROM table ORDER BY string_length(column); is there a mysql function to do this (of course instead of "string_length")? thank you! ...

How to select in between?

I have a table, called Level. id | level | points(minimum) ------------------------- 1 | 1 | 0 2 | 2 | 100 3 | 3 | 200 Let say I have 189 points, how do i check which level the user in? EDIT: Best answer chosen. Now I am comparing the request by adding EXPLAIN before the SELECT query, i have this r...

select count and other recors in one single query

i have the following query select main_cat_name,cat_url from mf_main order by main_cat_name this returns whole data of my table.Now i want to have count of the total rows of this table.I can do it using another query but how can i use them in one single query??? i want two data ONE :- the rows of the table TWO:- the count how can i ha...

Multi-Select Dropdown with size of 1

Is there any way of creating a combo box (<select>) with a size of 1? All the examples I can find allow for multiple selects but with a number of options visible at any one time. If this cannot be accomplished with bog standard HTML is it possible in a JS library such as JQuery? ...

Flex Datagrid dynamically adding rows via checkboxex

Hello Stackoverflowers. Does anybody know how to add a new row to a datagrid via a checkbox. example: checkbox 1 : label (PS2) checkbox 2 : label (PS3) checkbox 3 : label (PSP) By selecting one or all of these checkboxes i what to add a new Datagrid row. Datagrid Console price row1 PS2 $20, row2 P...

How to check which <option> is actually clicked?

$('select').bind('click contextmenu',function(ev){ }) ev.target is always a select,not option. How can I know which one is now being clicked? Don't tell me to do this: $('option').bind('click contextmenu',function(ev){ }) Because it's not supported in IE8,and you can test it yourself! EDIT It should also support right click,wh...

Select Count(*) over large amount of data

Hello i want to do this for a Report but i have 20,000,000 of records in my table and it causes an TimeOut in my application. SELECT T.transactionStatusID, TS.shortName AS TransactionStatusDefShortName, count(*) AS qtyTransactions FROM Transactions T INNER JOIN TransactionTypesCurrencies TTC ON T.id_Ent = TTC.id_Ent ...

Input PHP Variable into HTML Select Tag

Hello: I have a php variable ($list) that is a list of values separated by commas. I am trying to figure out how to convert or input this variable into a HTML select tag. Here is what I have so far: $dbquery = @$db->query('SELECT * FROM Company'); while ($queryText = $dbquery->fetchArray()){ $array[]=$queryText['Company_Name']; } /...