select

select redirection

Hi, While considering another problem one question appeared. I do not know how to write html when I want to redirect page when select option changes. In other words user chooses option from select list and page is redirected after that. Have you met anything like this? Regards, ...

postgres counting one record twice if it meets certain criteria

I thought that the query below would naturally do what I explain, but apparently not... My table looks like this: id | name | g | partner | g2 1 | John | M | Sam | M 2 | Devon | M | Mike | M 3 | Kurt | M | Susan | F 4 | Stacy | F | Bob | M 5 | Rosa | F | Rita | F I'm trying to get the id where either the g or g2 value equals 'M'......

How can I organize many results in a selectbox using php?

I have a select box that is part of a form. It is currently querying the addresses table and displaying the addresses into the select box. I plan on having up to 100 addresses. I'm looking for a solution where I can show all the states if the user clicks on the select box. Then if the user hovers over a state it will show all the addres...

Access values of a group of select boxes in php from post

Hi, I'm new to PHP, and I can't figure this out. I'm trying to figure out how to access the data of a group of select boxes I have defined in my HTML code. I tried grouping them as a class, but that doesn't seem to work... maybe I was doing it wrong. This is the following HTML code. <form action="" method="post"> <select class="foo">...

IE6 SELECT HTML tag causes rest of page to vanish

The following HTML does not work in IE6 for me: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html><body>This text is visible.<textarea>This too.</textarea> This is not visible. <select><option value="a">A</option><option value="b">B</option></select> Neither is this. <textarea>Nor this.</textarea> Nor this. </body></h...

postgresql multiple insert with select query

Hi guys, i need to perform a insert query for multiple rows whereby the first column is a numeric and identical value and the second values are queried from another table. something like insert into table (33, select col2 from another_table); can this be accomplished with a single statement? ...

How to redirect to another page using a select menu and link_to - Ruby on Rails

Hi, I want to use a select menu to redirect to another page but when I select 'Home' it doesn't redirect me to the main page. Nothing happens... <select> <option>Select a menu</option> <option><%= link_to 'Home', '/' %></option> </select> Thank you for your help. ...

Which is the fastest way to retrive all items in SQLite?

I am programming on windows, I store my infors into sqlite. However I find to get all items is a bit slow. I am using the following way: select * from XXX; retriving all items in 1.7MB SQLite DB takes about 200-400ms. It is too slow. Can Anyone Help! Many Thanks! Thanks for your answers! I have to do a complex operation on the data,...

Customized combobox text in HTML / JavaScript

Hi, I wonder if it is possible to create combo box as in the picture below. The aim is that the actual text of the combo (select in HTML) would be different that items' texts that are displayed while the combo is opened. The application is written using Google Web Toolkit so any solution in gwt or HTML/JavaScript would be great. Tha...

How to trigger an event ONLY if both dropdowns are selected?

I have a dropdown select list on my page of class="TypeFilter". I have a jQuery event that fires when a value in that list is selected. $(".TypeFilter").change(function() { // Extract value from TypeFilter and update page accordingly )); I now have to add another list to the page, and I want to implement functionality which will...

Symfony: there is a "0" (zero) in a sfWidgetFormChoice

Hi, i want to show a select which options are the character '-' and a range of integers. I have this: $years = range(14,130); new sfWidgetFormChoice(array('choices' => array_merge(array('' => '-',array_combine($years,$years))); The problem: between the '-' and the range of integers there is a "0" (bold and italic). Any he...

Use of where in multiple joins to remove rows - linq

hi, I have a table of orders. the status is on the soilorders which is joined to the orders. I only want to return orders where the joined soilorder does not have status "Removed". I had thought that join sso in db.SoilSamplingOrders on ord.order_id equals sso.order_id where sso.status.Equals("Removed")!=true but then no re...

Copy text from TextView on Android

I have a ListView where each item is a TextView. I want to enable the long press behavior similar to an EditText that displays the default context menu with items like "Select all", "Cut all", "Copy all", etc. Is there an easy way to enable this for a TextView? ...

Making a select choice result in a popup in javascript

So this is using javascript and HTML. For example: <select name='test' > <option value='1'> <option value='2'> <option value='3'> </select> If someone chooses option value 2 (from the dropdown) I want a popup to appear. However if they choose option value 1 or option value 3 (from the dropd...

html - selection range - getting the range + starting node + ending node + distance

From my previous question for selecting specific html text, I have gone through this link to understand range in html string. Actually I am confused here very much. My question is as follows. For selecting a specific text on html page. We need to follow this steps. assumed html <h4 id="entry1196"><a href="http://radar.oreilly.com...

HOW TO SElect line number in TextBox Multiline

Hi all, I have large text in System.Windows.Forms.TextBox control in my form (winforms), vs 2008. I want find a text, and select the line number where I've found that text. Sample, I have fat big text, and I find "ERROR en línea", and I want select the line number in textbox multiline. string textoLogDeFuenteSQL = @"SQL*Plus: Releas...

mySQL query: How to insert with UNION?

Hi everybody, I am kind of new to mySQL:s union functions, at least when doing inserts with them. I have gotten the following to work based upon a example found on the net: INSERT INTO tableOne(a, b) SELECT a, $var FROM tableOne WHERE b = $var2 UNION ALL SELECT $var,$var Ok, nothing strange about that. But what happens when I want ...

sql insert error

This is my Insert Statement INSERT INTO ProductStore (ProductID, StoreID, CreatedOn) (SELECT DISTINCT(ProductId), 1, GETDATE() FROM ProductCategory WHERE EXISTS (SELECT StoreID, EntityID FROM EntityStore WHERE EntityType = 'Category' AND ProductCategory.CategoryID = EntityStore.EntityID AND StoreID = 1)) I am trying to Insert into tab...

Write a file header with select into outfile directive ?

Hi, I need to find a way to insert a file header (not column header) and dump my data after that. How would you do that ? Regards, ...

SQL: many-to-many relationship, IN condition

I have a table called transactions with a many-to-many relationship to items through the items_transactions table. I want to do something like this: SELECT "transactions".* FROM "transactions" INNER JOIN "items_transactions" ON "items_transactions".transaction_id = "transactions".id INNER JOIN "items" ON "items"....