Hi there, I'm stuck on a problem with sql. I have a table with many duplicate entries with column names like:- eventnumber housenumber value1 value2 None of these column names are the primary key as there are many duplicates. What I would like to do is select into another table by distinct housenumber but I seem to get the whole tabl...
This is an odd problem and likely a rookie mistake. For some odd reason, if I use the arrow keys to select a select option from below, it fails to submit unless I deselect by clicking somewhere else on the page. If I keep focus on the select option, the submission will fail to recognize the value. Am I committing some stupid mistake? <s...
I'm trying to do a SELECT INTO using Oracle. My query is: SELECT * INTO new_table FROM old_table; But I get the following error: SQL Error: ORA-00905: missing keyword 00905. 00000 - "missing keyword" Any ideas what's wrong? Thanks! The Standard behavior of the above should be as I originally thought: However Oracle implemented...
I have a select box using the dropdownchecklist jquery plug-in. I want to have a change event fire only after the select box loses focus. The jquery .change event fires for select boxes immediately upon selecting an item in the list. In my case since multiple items can be selected I only want the change to fire after focus is lost a...
I am designing the layout and usage of an Amazon SimpleDB application. The docs for simpleDB give several example queries: Here is one: ref: http://developer.amazonwebservices.com/connect/entry.jspa?externalID=1231 select * from mydomain where Title = 'The Right Stuff' I would like to use something like: select * from mydomain where * ...
Hello, $res (array)-> (count 50 (!) ) Example: ( [1] => Array ( [artistname] => Lady GaGa [songname] => Love Games [duration] => 3:31 [url] => 7e91a5ca16ae [server] => 3 ) [2] => Array ( [artistname] => DJ Layla [songnam...
I have a panel that is filled with a large number of circles (Ellipse2D). The circles are stored in a 2 dimensional array (rows and columns). My goal is to be able to "paint" the circles as I drag the mouse over them. I will eventually want to use selection shapes that will change the color of all the circles contained within the selec...
Hello! I have one very interesting question (for me :) ).. I'm using jquery and I want to find in HTML the first tag after my reference one . For example my HTML : <a href="#" class="A" >A</a> <table> ..... </table> <a href="#" class="B" >A</a> <table> ..... </table> <a href="#" class="c" >A</a> ...
I'm quite a begginer and I have two tables: "product" and "product attributes". Here's some imaginary data (the actual stuff involves more tables ) Products Table: product_id | product_name 10 | aaa 11 | bbb 12 | ccc Product Attributes Table: attribute_i...
If I have valvo that obtain from database, How can I set volvo option status into active(checked) by using JQuery? <select name="car"> <option value="volvo">Volvo</option> <option value="saab">Saab</option> <option value="mercedes">Mercedes</option> <option value="audi">Audi</option> </select> I don't know how ...
I'd like to get the ID of a particular row from within a Firebird 2.1 stored procedure. I can't seem to remember the syntax, and it's driving me nuts. This is how the code might look in TSQL, used by Microsoft SQL Server. @ID = SELECT ID FROM ADDRESS WHERE POBox = :POBOX AND ExtendedAddress = :EXTENDEDADDRESS AND ...
Is there any cross-browser way to italicize select options? With the following CSS and HTML, FireFox shows the second option in italics, but not the third. None of the options are italicized in IE 7 or Safari. <style> option.bravo { font-style: italic; } </style> <select> <option>Alpha</option> <option class="bravo">Bravo...
With this code: import scipy from scipy import * x = r_[1:15] print x a = select([x > 7, x >= 4],[x,x+10]) print a I get this answer: [ 1 2 3 4 5 6 7 8 9 10 11 12 13 14] [ 0 0 0 14 15 16 17 8 9 10 11 12 13 14] But why do I have zeros in the beginning and not in the end? Thanks in advance. ...
We need to store a select statement in a table select * from table where col = 'col' But the single quotes messes the insert statement up. Is it possible to do this somehow? ...
I've been trying to figure out how to query a shopping cart database to find all Orders that contain tangible items (items can be downloadable, therefore, not shipped) that have not been assigned a UPS tracking label. I haven't been able to do it. The involved tables are as follows: // dbo.Inventory - details about the individual produ...
On a page, I have a select (multiple) box with many options. Now I want to react on the last clicked item to display some data with ajax. As the "click" event on the option element does not work in IE, I currently use the "change" event. The problem is, that the "value" and the selectedIndex attribute point to the first selected item, ...
I have a table that looks like this: Timestamp Event User ================ ===== ===== 1/1/2010 1:00 PM 100 John 1/1/2010 1:00 PM 103 Mark 1/2/2010 2:00 PM 100 John 1/2/2010 2:05 PM 100 Bill 1/2/2010 2:10 PM 103 Frank I want to write a query that shows the events for each day and a count fo...
Id expect this to work (below) If iTestVar is 1, I'd expect DoStuff() to be fired. However it always falls into the else. I have researched const in the past and found they can only be defined outside of classes. The select statement is inside the class. 'This is defined outside of the class (vbscript won't allow const inside c...
This is probably a basic CSS question, but I am not fluent in CSS and just seem to be going in circles. Here's what I have in English: I have a fixed width select element of 400px. The text for each of the options does not fit in that 400px width. I don't get a horizontal scroll bar, it just cuts off the text. How do I get the scroll b...
I'm trying to allow multiple clients to connect to a host using select. Will I have to connect each one, tell them to move to a different port, and then reconnect on a new port? Or will select allow me to connect multiple clients to the same port? This is the client code: int rv; int sockfd, numbytes; if ((rv = getaddrinfo(hostN...