Search Results

Search found 18648 results on 746 pages for 'left join'.

Page 267/746 | < Previous Page | 263 264 265 266 267 268 269 270 271 272 273 274  | Next Page >

• How can you tell which columns are unused in ALL_TAB_COLS?

  - by thecoop

  When you query the ALL_TAB_COLS view on Oracle 9i, it lists columns marked as UNUSED as well as the 'active' table columns. There doesn't seem to be a field that explicitly says whether a column is UNUSED, or any view I can join to that lists the unused columns in a table. How can I easily find out which are the unused columns, so I can filter them out of ALL_TAB_COLS?

  Read the article

• Copy information only, from an external webpage and import it into a form using PHP

  - by mpw5013

  I'm looking to extract key pieces of information from the following website to simplify the signup process. More or less I want to build a quick import script that will grab the following: 1) Username 2) Type (Model / Photographer) 3) Age 4) Sex 5) City, State, Zip 6) Email 7) Photos I will then take all of this data and add it to join form / push the photos through a manipulation script. Any ideas?

  Read the article

• MS SQL 2005: Why would a delete from a temp table hang forever?

  - by Dr. Zim

  DELETE FROM #tItem_ID WHERE #tItem_ID.Item_ID NOT IN ( SELECT DISTINCT Item_ID FROM Item_Keyword JOIN Keyword ON Item_Keyword.Keyword_ID = Keyword.Record_ID WHERE Keyword LIKE @tmpKW) The Keyword is %macaroni%. Both temp tables are 3300 items long. The inner select executes in under a second. All strings are nvarchar(249). All IDs are int. Any ideas? I executed it (it's in a stored proc) for over 12 minutes without it finishing.

  Read the article

• Not Equal two Generic Lists

  - by David Johnson

  I have two generic lists, both containing different data, except 4 fields, which I want to compare to another list and find items that do not match in either list. I need to basically replace where it says equals below, with not equals! var unMatchedData = from liveLines in liveList join oldList in comapreSnapshotList on new {liveLines.ClientNo, liveLines.SequenceNo, liveLines.LineNo, liveLines.Text} equals new {oldList.ClientNo, oldList.SequenceNo, oldList.LineNo, oldList.Text} select new KNOWTXTS { ClientNo = liveLines.ClientNo, SequenceNo = liveLines.SequenceNo, LineNo = liveLines.LineNo, Text = liveLines.Text };

  Read the article

• Ruby Dir.glob works on laptop not on desktop?

  - by Nick Faraday

  I have a ruby shell script that works perfectly on my laptop, but Dir.glob doesn't seem to work when I try and run it on my desktop. Here is the code: sFileTemplate = File.join("**", sResolutions, "**", "*."+sType) sFiles = Dir.glob(sFileTemplate) Both machines run OSX 10.5 and are running ruby -v 1.9.1. Am I calling glob wrong? Thanks

  Read the article

• Find multiple line spanning text and replace using Powershell

  - by MrGrant

  Hello, I am using a regular expression search to match up and replace some text. The text can span multiple lines (may or may not have line breaks). Currently I have this: $regex = "\<\?php eval.*?\>" Get-ChildItem -exclude *.bak | Where-Object {$_.Attributes -ne "Directory"} |ForEach-Object { $text = [string]::Join("`n", (Get-Content $_)) $text -replace $RegEx ,"REPLACED"}

  Read the article

• have mysql select statement return fully qualified column names like table.field

  - by handsomeGun

  is there a way to have a mysql select statement return fully qualified column names like "table.field" without using AS for every single field? like so: SELECT * FROM table1 LEFT JOIN table2 on table1.f_ID = table2.ID and the result would be: "table1.ID", "table1.name", "table2.ID", "table2.name", ...

  Read the article

• How to translate this 2 queries from Mysql to Postgresql? :

  - by xRobot

  How can I translate this 2 queries in postgresql ? : CREATE TABLE `example` ( `id` int(10) unsigned NOT NULL auto_increment, `from` varchar(255) NOT NULL default '0', `message` text NOT NULL, `lastactivity` timestamp NULL default '0000-00-00 00:00:00', `read` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `from` (`from`) ) DEFAULT CHARSET=utf8; Query: SELECT * FROM table_1 LEFT OUTER JOIN table_2 ON ( table_1.id = table_2.id ) WHERE (table_1.lastactivity > NOW()-100);

  Read the article

• SQL Complex Select - Trouble forming query

  - by JoshSpacher

  I have three tables, Customers, Sales and Products. Sales links a CustomerID with a ProductID and has a SalesPrice. select Products.Category, AVG(SalePrice) from Sales inner join Products on Products.ProductID = Sales.ProductID group by Products.Category This lets me see the average price for all sales by category. However, I only want to include customers that have more than 3 sales records or more in the DB. I am not sure the best way, or any way, to go about this. Ideas?

  Read the article

• Makefile patsubs double replacement

  - by aaa

  hello. is a possible to do something like this, without shell command: CXX_MODULES += $(patsubst %, %/%.cpp, $(LIBRARIES)) notice double replacement which does not work (only first replacement happens) after some tinkering I came up with $(join $(LIBRARIES), $(patsubst %, /%.cpp, $(LIBRARIES))) Thank you

  Read the article

• How to use Regular Expression to extract information from a HTML webpage?

  - by user569248

  How to use Regular Expression to extract the answer "Here is the answer" from a HTML webpage like this? <b>Last Question:</b> <b>Here is the answer</b> ..:: Update ::.. Thanks everybody! Here is my solution by using BeautifulSoup since I'm using Python framework: response = opener.open(url) the_page = response.read() soup = BeautifulSoup(''.join(the_page)) paraText1 = soup.body.find('div', 'div_id', text = u'Last Question:') if paraText1: answer = paraText1.next

  Read the article

• SQL Query Theory Question...

  - by Keng

  I have a large historical transaction table (15-20 million rows MANY columns) and a table with one row one column. The table with one row contains a date (last processing date) which will be used to pull the data in the trasaction table ('process_date'). Question: Should I inner join the 'process_date' table to the transaction table or the transaction table to the 'process_date' table?

  Read the article

• Getting a substring in Ruby by x number of chars

  - by wotaskd

  I'm trying to produce some Ruby code that will take a string and return a new one, with a number x number of characters removed from its end - these can be actual letters, numbers, spaces etc. Ex: given the following string a_string = "a1wer4zx" I need a simple way to get the same string, minus - say - the 3 last digits. In the case above, that would be "a1wer". The way I'm doing it right now seems very convoluted: an_array = a_string.split(//,(a_string.length-2)) an_array.pop new_string = an_array.join Any ideas?

  Read the article

• How to get latest files in C#

  - by Newbie

  I have some files with same name but with different dates. Basically we are finding the files with most recent dates The file patterns are <FileNames><YYYYMMDD><FileExtension> e.g. test_20100506.xls indicates <FileNames> = test_ <YYYYMMDD> = 20100506 <FileExtension> = .xls Now in the source folder, the files are standardization_20100503.xls, standardization_20100504.xls, standardization_20100305.xls, replacement_20100505.xls As can be seen that, standardization_.xls are 3 in numbers but replacement_.xls is only 1. The output will be a list of file names whose content will be standardization_20100504.xls and replacement_20100505.xls Because among all the standardization_.xls is the most recent one and replacement_.xls is also the same. I have tried with my own logic but somehow failed. My idea is as under private static void GetLatestFiles(ref List<FileInfo> validFiles) { List<FileInfo> validFilesTemp = new List<FileInfo>(); for (int i = 0; i < validFiles.Count; i++) { for (int j = i+1; j < validFiles.Count; j++) { string getFileTextX = ExtractText(validFiles[i].Name); string getFileTextY = ExtractText(validFiles[j].Name); if (getFileTextX == getFileTextY) { int getFileDatesX = Convert.ToInt32(ExtractNumbers(validFiles[i].Name)); int getFileDatesY = Convert.ToInt32(ExtractNumbers(validFiles[j].Name)); if (getFileDatesX > getFileDatesY) { validFilesTemp.Add(validFiles[i]); } else { validFilesTemp.Add(validFiles[j]); } } } } validFiles.Clear(); validFiles = validFilesTemp; } The ExtractNumbers is: public static string ExtractNumbers(string expr) { return string.Join(null, System.Text.RegularExpressions.Regex.Split(expr, "[^\\d]")); } and the ExtractText is public static string ExtractText(string expr) { return string.Join(null, System.Text.RegularExpressions.Regex.Split(expr, "[\\d]")); } I am using c#3.0 and framework 3.5 Help needed .. it's very urgent Thanks .

  Read the article

• Organizing github repository for java 6 and 7

  - by Edmon

  I am wanting to create a gihub repository that offers benchmarking code that works for concurrent features available only in JDK 1.7 (Fork/Join) as well as for older ones found in JDK 1.6. Offering both options is important for what I need. Does anyone have a recommendation how should I structure the repository. I was planning on having a repo called and under it: jdk17 build src mycode ... jdk16 build src mycode Please suggest any alternatives, possibly use of Maven or other more practical approaches, if any.

  Read the article

• How can this SQL be wrong? What am I not seeing?

  - by ropstah

  Can anybody please spot my error, this should be a legal query in SQL shouldn't it?? Unknown column u.usr_auto_key in the ON clause This is the database schema: User: (usr_auto_key, name, etc...) Setting: (set_auto_key, name etc..) User_Setting: (usr_auto_key, set_auto_key, value) And this is the query... SELECT `u`.`usr_auto_key` AS `u__usr_auto_key`, `s`.`set_auto_key` AS `s__set_auto_key`, `u2`.`usr_auto_key` AS `u2__usr_auto_key`, `u2`.`set_auto_key` AS `u2__set_auto_key`, `u2`.`value` AS `u2__value` FROM `User` `u`, `Setting` `s` LEFT JOIN `User_Setting` `u2` ON `u`.`usr_auto_key` = `u2`.`usr_auto_key` WHERE (`s`.`sct_auto_key` = 1 AND `u`.`usr_auto_key` = 1 AND admin_property is null)

  Read the article

• SQL Server 2005: Why would a delete from a temp table hang forever?

  - by Dr. Zim

  DELETE FROM #tItem_ID WHERE #tItem_ID.Item_ID NOT IN (SELECT DISTINCT Item_ID FROM Item_Keyword JOIN Keyword ON Item_Keyword.Keyword_ID = Keyword.Record_ID WHERE Keyword LIKE @tmpKW) The Keyword is %macaroni%. Both temp tables are 3300 items long. The inner select executes in under a second. All strings are nvarchar(249). All IDs are int. Any ideas? I executed it (it's in a stored proc) for over 12 minutes without it finishing.

  Read the article

• Waiting for a subset of threads in a Java ThreadPool

  - by David Semeria

  Let's say I have a thread pool containing X items, and a given task employs Y of these items (where Y is much smaller than X). I want to wait for all of the threads of a given task (Y items) to finish, not the entire thread pool. If the thread pool's execute() method returned a reference to the employed thread I could simply join() to each of these Y threads, but it doesn't. Does anyone know of an elegant way to accomplish this? Thanks.

  Read the article

• How to translate this query:

  - by xRobot

  How can I translate this 2 queries in postgresql ? : . CREATE TABLE example ( id int(10) unsigned NOT NULL auto_increment, from varchar(255) NOT NULL default '0', message text NOT NULL, lastactivity timestamp NULL default '0000-00-00 00:00:00', read int(10) unsigned NOT NULL, PRIMARY KEY (id), KEY from (from) ) DEFAULT CHARSET=utf8; . SELECT * FROM table_1 LEFT OUTER JOIN table_2 ON ( table_1.id = table_2.id ) WHERE (table_1.lastactivity > NOW()-100);

  Read the article

• how can i execute large mysql queries fast

  - by testkhan

  I have 4 mysql tables and have a single query with JOIN on multiple tables and I am requesting it via jquery ajax, but it takes to much long time from about 1-3 minutes while I want to execute them on average 2-5 seconds. is there any special way to execute the quries fast

  Read the article

• Oracle: How to update master with newest row from detail table?

  - by LukLed

  We have two tables: Vehicle: Id, RegistrationNumber, LastAllocationUserName, LastAllocationDate, LastAllocationId Allocations: Id, VehicleId, UserName, Date What is the most efficient (easiest) way to update every row in Vehicle table with newest allocation? In SQL Server I would use UPDATE FROM and join every Vehicle with newest Allocation. Oracle doesn't have UPDATE FROM. How do you do it in Oracle?

  Read the article

• Better mode for do a select with group by

  - by Luca Romagnoli

  Hi i've wrote a query that works: SELECT `comments`.* FROM `comments` RIGHT JOIN (SELECT MAX( id ) AS id, core_id, topic_id FROM comments GROUP BY core_id, topic_id order by id desc) comm ON comm.id = comments.id LIMIT 10 I want know if is possible and how rewrite it for get better performance. thanks

  Read the article

• Hibernate reverse engineering

  - by EugeneP

  I have a structure where the main table is USER, other tables include CATEGORY (contains user_id). What I got after the standard reverse engineering procedure was: the class User contained a collection of categories, the class Category didn't contain the foreign key (user_id) but it did contain the User object. Why did it not contain the foreign key as a class property? And how do I join these two tables in HQL without that glue? HQL - please explain this part.

  Read the article

• Do views only perform the joins that they need to, or all joins always?

  - by Nate

  I am on an oracle DB. Lets say I have one view that joins to three tables. The view has two fields each. Each field only needs data from two of the three tables. If I query the view and return only one field, does the view still join to three tables or just to the two tables that it needs to calculate the field?

  Read the article

• Django. Invalid keyword argument for this function. ManyToMany

  - by sagem_tetra

  I have this error: 'people' is an invalid keyword argument for this function class Passage(models.Model): name= models.CharField(max_length = 255) who = models.ForeignKey(UserProfil) class UserPassage(models.Model): passage = models.ForeignKey(Passage) people = models.ManyToManyField(UserProfil, null=True) class UserProfil(models.Model): user = models.OneToOneField(User) name = models.CharField(max_length=50) I try: def join(request): user = request.user user_profil = UserProfil.objects.get(user=user) passage = Passage.objects.get(id=2) #line with error up = UserPassage.objects.create(people= user_profil, passage=passage) return render_to_response('thanks.html') How to do correctly? Thanks!

  Read the article

< Previous Page | 263 264 265 266 267 268 269 270 271 272 273 274  | Next Page >