select

JQUeryUI Dialog and HTML select

I have an ASPX page where jQuery UI dialog will appear on the screen ,on clicking on a button,When the UI dialog is active ,User cant interact with any other controls.ITs working good. But I have a Dropdown list (Select ) in the page .It is still active .User is able to go and choose any option from the dropdown. I know that in IE6,Its c...

SQL: grouping 2 tables as 1 with join, union, and then?

Here i am again :) I have 5 tables: customers id - name p_orders id - id_customer - code - date p_items id - id_order - description - price and h_orders and h_items, that are exactly the copy of p_orders and p_items. When the p_ tables reach a big amount of rows, i move the oldest to the h_ tables.. they due as history. So, my pro...

Reading from FIFO in C: select() doesn't return?

Hi all, I've got a C program I'm writing. Here's what it does: Create n fifos using mkfifo Open them for read (with the O_NONBLOCK flag set) Open them for write Spawn a thread In the thread, run in a loop: Create an fd_set of the file descriptors for all n fifos Call select(n, &my_set, NULL, NULL, NULL) For each fd ready for I/O (...

If I'm querying a database, how can I get the 5th row back from a given row?

If I have a row id and I want the 5th row back from that row how would I do this? Normally I could just go rowId - 5 and that would be the id of the 5th row back... However, I need to account for if a row has been deleted, this would mean that, for example 39, 40, 41, 42, 43, 44, 45 if rowId was 45, then I would get rowId of 40 fo...

Selecting content of a textbox in a sortable, jQuery

I'm trying to get the content of a textarea inside a sortable item in jQuery... I can't seem to figure it out! Here's what I have now: jQuery(document).ready(function() { jQuery("#list").sortable({ axis : 'y' , revert : 'true' , opacity : 0.5 , stop : function (e, ui) { jQuery("input#output"); } }); ...

Proper way of lazy-loading a single select box options via ajax once clicked.

I have a select box that should be populated only when clicked. The query involved takes a long time so I'm deattaching it from the standard data shown on the page. I have implemented the function loadMyData(element, id) which does an ajax request and returns the data as JSON. Then it populates the select box. the event is binded to t...

MySql Select, MANY FIELDS, how best to display in terminal?

I'm using Putty (Command-line) and running a mysql> SELECT * FROM sometable; The 'sometable' has many fields and this results in many columns trying to be displayed in the terminal. The fields wrap onto the next line so it is very hard to line up Column titles with Field values. What solutions are there for viewing such data in term...

SQL Query for retrieving search results

I need help designing a query that will be used to return a website's search results. Users search by selecting items from a list of attributes. Each search result item returned must have ALL the attributes selected by the user. The challenge (for me at least!) is figuring out how to only return results that have ALL the attributes ve...

when will select statement without for update causing lock?

I'm using MySQL, I sometimes saw a select statement whose status is 'locked' by running 'show processlist' but after testing it on local,I can't reproduce the 'locked' status again. ...

How/why does the width work on INPUT and SELECT elements if they are inline elements?

As I understand, width/padding/margin properties only work on block level elements. However, on INPUT and SELECT elements I am able to specify the width, which works. Should it? I could write something like this: <input type="text" style="display:block;" /> But is it necessary? Can anyone explain please why it works? ...

django select box size option

I have three drop down select boxes, which I have to expand for web visibility reasons with the size='' option. If I select one from each box I receive no errors, but if I leave one or more boxes without a selection I receive an error. {% for pathology in pathology_list %} {{ pathology.pathology }} {% endfor %} ...

mysql query works manually but returns no results when running from code

I use a very simple query with "Like" to find product by its name SELECT p_pid, p_name, p_cat FROM products WHERE p_sid=346 AND p_name LIKE 'product name here in utf-8 encoding, can be various languages' LIMIT 1 When I run this query from code with valid product name, I get no results. If I copy the query (echoed by php to the browser...

Rails: How do I save a string representation back into a model?

I have an Employee model that has a SecurityClearanceLevel. When you make a new employee, you're asked to set a SecurityClearanceLevel by choosing from a <select> list. The problem is that when I save the object, it's a string, not a SecurityClearanceLevel, so the save fails. Where do I take care of this kind of back-and-forth conversio...

Faster 'select distinct thing_id,thing_name from table1' in oracle

I have this query: select distinct id,name from table1 For a given ID, the name will always be the same. Both fields are indexed. There's no separate table that maps the id to the name. The table is very large (10 of millions of rows), so the query could take some time. This query is very fast, since it's indexed: select distinct...

mysql fake select

My purpose is: to get multiple rows from a value list,like (1,2,3,4,5),('a','b','c','anything') and so on. mysql> select id from accounts where id in (1,2,3,4,5,6); +----+ | id | +----+ | 1 | | 2 | | 3 | | 5 | | 6 | +----+ 5 rows in set (0.00 sec) The above sql is surely ok,but my question is:is there a way to get the same result...

mysql select sum group by date

Quick question, I have the following table +-------------+---------------------+ | total | o_date | +-------------+---------------------+ | 35 | 01-11-2009 19:32:44 | | 41.5 | 01-12-2009 22:33:49 | | 61.5 | 01-23-2009 22:08:24 | | 66 | 02-01-2009 22:33:57 | | 22.22 | 02-01-200...

Read STDIN (SYSIN) in COBOL

I want to read the lines out of STDIN (aka SYSIN) in COBOL. For now I just want to print them out so that I know I've got them. From everything I'm reading it looks like this should work: IDENTIFICATION DIVISION. PROGRAM-ID. APP. ENVIRONMENT DIVISION. INPUT-OUTPUT SECTION. FILE-CONTROL. SELECT SYSIN ASSIGN TO DA-S-SYSIN OR...

SELECT forum topic with most different participants

So, i'm building a members rewarding system for my forum and got stuck on this query for selecting "forum topic with most different participants". I already have this query that counts how many posts (replies) each forum topic in last 24 hours has. SELECT poster . * , count( odgovori.id_odgovor ) AS broj, members.username FROM poster I...

Wordpress advanced SQL - joins and counts

This is how things work I use Wordpress category tables and have 2 main categories. The first one is called "location" and the other one "subject". Both categories have sub categories of their own. In my example we have "location" category 17 and "subject" category 3. This is what I want to do I want to select ONLY the data where BOTH ...

Computing average values over sections of date/time.

Problem: I have a database of sensor readings with a timestamp for the time the sensor was read. Basically it looks like this: Sensor | Timestamp | Value Now I want to make a graph out of this data and I want to make serveral different graphs. Say I want one for the last day, one for the last week and one for the last month. The reso...