I have two tables coming which has data from two different systems. I need to reconcile the data in these two tables The column mapping needs to be made configurable. E.g.: Table A Table B Col1A, Col2A Col1B, Col2B MappingTable Col...
How do you select a parent based on the attribute of a child? I want to select a div: //*[@id='outer']/div/div/div/div that has a child with the 'a href' attribute equal to 'www.blah.com': //*[@id='outer']/div/div/div/div/a[@href='www.blah.com'] ...
Hi Everyone: I am wondering if there is some way to do a doesn't equal command in MYSQL. In other words, can you do a command like this: "SELECT * FROM someTitle WHERE someLabel != 'something'"? My code is returning an error when I attempt this. Thanks for any help! ...
If I want to do a check a name, I want to see how many rows/name exists in the "username" column under users table. Lets say thousands ... hundred of thousands, should I use: count(name), count(*) or SELECT username FROM users where username = 'name' Which one is the more appropriate? Or they will give same result in term of speed/...
Hello, Im working on a CMS website that creates form elements on the fly according to id and values. I need to select certain information out of these forms using a link. For radio options and checkbox options I use this code: <a href="#" onclick="document.getElementById('RAL1').checked=true">1001</a> Which works fine. RAL1 is the id o...
Do I programmatically have to manage the backcolor\highlight color on a Listview's item when selected through code? So if I do this: listView1.Items[1].Selected = true; Do I also need to do this, so it looks highlight, as it does when selected with a mouse click: listView1.Items[1].BackColor = Color.Blue; (and clear it when the select...
Hi Friends, I use codeigniter and have an issue about SELECT MAX ... I couldnot find any solution at google search... it looks like it returns only id :/ it's giving error for other columns of table :/ Appreciate helps, thanks! Model: function get_default() { $this->db->select_max('id'); $query = $this->db->...
Hy is theere a query where i can do both querys in one? This is the first $q = "select c.id as campaignId,c.priceFactor, o.cid,o.bloggerPrice,o.state as state,o.customerPrice,o.id as orderId,o.listPrice,o.basicPrice from campaign c, orders o where c.id={$campaignId} and c.id = o.c...
Hi guys, bear with me, this may be a long one. Thanks in advance for the help. I have a function in SQL server 2008 that takes a string: 'A,B,C,D' and splits it and creates a table of the values. Values ------ A B C D I now want to search a table (Users) Where a column value is LIKE one of the rows (surname) in the above table. Thi...
How do I change the highlighting color of <select> that is the color that highlights <li> while cursor passes over it by using CSS. ...
Suppose I have a log of Customers who come in on particular Days, like: Cs day -- --- 01 Tue 02 Tue 03 Wed 01 Wed 04 Thu 02 Thu I need a query that returns only the #s of those Customers who were in both on Tue and on Wed. In this case, only Cs # 01. Thank you. ...
I'm writing a portable Socket class that supports timeouts for both sending and receiving... To implement these timeouts I'm using select().... But, I sometimes need to know how long I was blocked inside select() which of course on Linux I would implement by calling gettimeofday() before and after I call select() and then using timersub(...
I tried two different variations on the same thing. The first version selects from freetexttable, the other insets into a temp table and selects from that. I've tried numerous variations on the first version (select several combinations, at both levels of scope, of group by, distinct, and casting [rank] to an integer. Regardless, the ...
hello, i need to split any mysql select statement in its main parts: SELECT, FROM, ALL THE JOINS(if there are any), WHERE(if it exists),GROUP BY(if it exists), HAVING(if it exists), ORDER BY(if it exists), LIMIT(if it exists)... i tried using regular expressions, but i'm not very good with them... for the SELECT the regex was simple (an...
I'm having a performance issue with a select statement I'm executing. Here it is: SELECT Material.* FROM Material INNER JOIN LineInfo ON Material.LineInfoCtr = LineInfo.ctr INNER JOIN Order_Header ON LineInfo.Order_HeaderCtr = Order_Header.ctr WHERE (Order_Header.jobNum = 'ttest') AND (Order_Header.revision_number = ...
I am trying to create a server which uses select() to handle multiple clients, as opposed to multi-threading which I have already accomplished. However select() just doesn't seem to do anything? I have all the necessary system calls e.g. socket() returning to an int called listener. bind() then listen(), all with suitable error checking,...
I have XML in the following format which I want to reformat: <blocks> <!-- === apples === --> <block name="block1"> ... </block> <!-- === bananas === --> <block name="block2"> ... </block> <!-- === oranges === --> <block name="block3"> ... </block> </blocks> My problem is I can't figu...
Here's a snippet of code I'm using in a loop: while True: print 'loop' rlist, wlist, xlist = select.select(readers, [], [], TIMEOUT) print 'selected' # do stuff At a certain point, select will block and "selected" is never getting printed. What can cause this behavior? Is it possible there's some kind of deadlock? U...
Hello, I am using CakePHP 1.2. I have a person model that hasMany 'Document'. When I edit a document, the select box for the owning person appears (echo $form->input('person') where person has been defined in the documents_controller like this: $allPeople = $this->Document->Person->find('list', array('fields' => array('first_name')))...
Oh help, I've tried it a million different ways yet it still does not work: If you select update or final from a select/option box, it should show the div that has an input field in it. It only does what the default shows in the switch statement. Of course, it's only after a selection is made that I want it to determine whether it shows ...