HTML Select selected value in php variable
Hi, I have a drop down in html. When I change the value of the drop down I want to store the selected value in a php variable How can i achieve this ? ...
select
HTML select box with a size of 1: when does selectedIndex is -1 ?
When I use a select box with a size atribute greater than 1 i.e. <select size="3"> <option value="a">a</option> <option value="b">b</option> <option value="c">c</option> <option value="d">d</option> </select> If user does not select any item I do get a selectedIndex of -1, as expected. When i use a 'classic' select box wi...
SQL join different tables depending on row information
Suppose I have table A with a field that can be either 1 or 2... How do I select such that for each row in table A, if the field is 1, join the select with table B and if the field is 2, join the select with table C? ...
MySQL name LIKE '%#attributes.q#%' --- Doesn't return result for an exact match?
I have the following MySQL query: SELECT * FROM customer WHERE fName LIKE '%#attributes.q#%' AND deleted = 'N' OR lName LIKE '%#attributes.q#%' AND deleted = 'N' This works fine for guesses, but if you provide an exact match: "Bill Clinton" fname=bill lname = clinton to the query above you get 0 results? where bill clint gives...
Ruby on Rails: Simple way to select all records of a nested model?
Just curious, I spent an embarrassing amount of time trying to get an array of all the records in a nested model. I just want to make sure there is not a better way. Here is the setup: I have three models that are nested under each other (Facilities >> Tags >> Inspections), producing code like this for routes.rb: map.resources :facil...
How to select min and max values of a column in a datatable?
For the following datatable column, what is the fastest way to get the min and max values? AccountLevel 0 1 2 3 ...
jquery remove selected element and append to another
I'm trying to re-append a "removed option" to the appropriate select option menu. I have three select boxes: "Categories", "Variables", and "Target". "Categories" is a chained select, so when the user selects an option from it, the "Variables" select box is populated with options specific to the selected categories option. When the ...
PL/SQL - How to pull data from 3 tables based on latest created date
Hello, I'm hoping someone can help me as I've been stuck on this problem for a few days now. Basically I'm trying to pull data from 3 tables in Oracle: 1) Orders Table 2) Vendor Table and 3) Master Data Table. Here's what the 3 tables look like: Table 1: BIZ_DOC2 (Orders table) OBJECTID (Unique key) UNIQUE_DOC_NAME (Document Name i.e...
Slow select when inserting large amounts of data (MYSQL)
I have a process that imports a lot of data (950k rows) using inserts that insert 500 rows at a time. The process generally takes about 12 hours, which isn't too bad. Normally doing a query on the table is pretty quick (under 1 second) as I've put (what I think to be) the proper indexes in place. The problem I'm having is trying to run a...
php json jquery and select box
I have this php code $jsonArray = array(); $sql = "SELECT ID,CLIENT FROM PLD_SERVERS"; $result = mysql_query($sql); while($row = mysql_fetch_array($result)) { $jsonArray[] = array('id'=>$row['ID'],'client'=>$row['CLIENT']); } echo json_encode($jsonArray); And this js function autosearchLoadServers() { $.post("php/autosearch-lo...
jquery disable/remove option on select?
Hi all, I have two select lists, I would like jquery to either remove or disable a select option, depending on what is selected from the first select list: <select name="booking" id="booking"> <option value="3">Group Bookings</option> <option value="2" selected="selected">Port Phillip Bay Snapper Charters</option> <option value="6...
Is select() Ok to implement single socket read/write timeout ?
I have an application processing network communication with blocking calls. Each thread manages a single connection. I've added a timeout on the read and write operation by using select prior to read or write on the socket. Select is known to be inefficient when dealing with large number of sockets. But is it ok, in term of performance ...
SQL SELECT Join?
I have a MySql DB. There is a table with products and orders with the structure: Products: product_id, name, manufacturers_id Orders: orders_id, product_id, quantity Now I want to get all orders (show only products where product manufacturers_id=1). I tried: SELECT orders.orders_id, orders.product_id FROM products, orders WHERE p...
performance issue in a select query from a single table
Hi , I have a table as below dbo.UserLogs ------------------------------------- Id | UserId |Date | Name| P1 | Dirty ------------------------------------- There can be several records per userId[even in millions] I have clustered index on Date column and query this table very frequently in time ranges. The column 'Dirty' is non-n...
C# Linq Select Problem in Method Chain.
Note that the _src inherit IQueryable<U> and V inherit new(); I wrote the following statement, there is no syntax error. IQueryable<V> a = from s in _src where (s.Right - 1 == s.Left) select new V(); But if i RE-wrote it as follows, the Visual Studio editor complains an error in the "Select" IQueryable<V> d = _src.Where(s => s.Right...
Hibernate: Querying objects by attributes of inherited classes
Hi all, I ran into a problem with Hibernate concerning queries on classes which use inheritance. Basically I've the following class hierarchy: @Entity @Table( name = "recording" ) class Recording { ClassA attributeSet; ... } @Entity @Inheritance( strategy = InheritanceType.JOINED ) @Table( name = "classA" ) public class Cla...
insert into select from in a table with identity column
Hi, I am using a insert into select from statement to insert the result set of a query into a table containing an identity column. I am consistently getting an error Cannot insert duplicate key row in object 'dbo.TABLE1' with unique index 'IX_TABLE1'. Please help ...
sql select statement with a group by
I have data in 2 tables, and I want to create a report. Table A: tableAID (primary key) name Table B: tableBID (primary key) grade tableAID (foreign key, references Table A) There is much more to both tables, but those are the relevant columns. The query I want to run, conceptually, is this: select TableA.name, avg(TableB.gr...
Jquery .Show() .Hide() not working as expected
I'm trying to use the show and hide to display a different set of select options when a certain report type is selected. I have a couple problems with this: The .show .hide only execute properly if I pass params, slow fast, in the the first result of my conditional statement. If I take out the params or pass params in both results, onl...
Change event on <select>
If i attach a change event listener on a<select> how do i acces the option that was selected (not just the value, the actual element). $('select').addEvent('change',function(event) { //?? }); Note: i'm using Mootools ...