Search DaniWeb - excluding

Excluding portions of an image comparision 13 Years Ago by TahoeSands … there would be a more simple and elegant way of excluding these rounded corner areas from the process. Here is the… Re: Excluding portions of an image comparision 13 Years Ago by TahoeSands … exclude just happens to be equal to 0 (zero), so excluding these areas is a no brainer. how to calculate the days between two dates excluding saturday and sunday 16 Years Ago by hidash_in how to calculate the days between two dates excluding saturday and sunday foe example if i am calculating the days between 14/12/2007 to 17/12/2007 the answer for no of days should be 4... pls send the code for above problem. advance thanks hidash. Re: how to calculate the days between two dates excluding saturday and sunday 16 Years Ago by hidash_in how to calculate the days between two dates excluding saturday and sunday foe example if i am calculating the days between 14/12/2007 to 17/12/2007 the answer for no of days should be 2... pls send the code for above problem. advance thanks hidash. Calculate DateDifference excluding Sundays 14 Years Ago by S2009 …)); } Can any body help me out in calculating the fine excluding the sundays? Please help me out! Thanks in advance! how to get the difference between 2 dates excluding weekends and holidays 13 Years Ago by sickpuppy18 … figure out how to compute the difference between 2 dates excluding weekends.I browsed the web on how to compute the… need help with regex to grab two numbers while excluding another number 11 Years Ago by deadsolo … regex that will grab two numbers from a line, while excluding a specific number. Here is an example of what the… Re: Excluding portions of an image comparision 13 Years Ago by JamesCherrill You could solve this in a generic sort of way by also having a "mask" image - same size as the card images, with each pixel either black or white depending on whether or not you want to compare the corresponding pixels in the two card images. That way, if the shape or size of the images changes you just need 1 minute in a picture editor … Best LowCost Software Tools, C or VB 4 Years Ago by chuckc Excluding freeware, what would be the best reasonably priced software tools (… excluding even numbers and formatting 15 Years Ago by Andrewsc1 alright basically what the program does is convert Kilograms into pounds, then displays its on a table. There are two problems i am having the first one is getting rid of the even numbers. I've been trying combinations of modulator and the NOT expression and so far have been unsuccessful and nothing prints out in the display. I was thinking that i… Re: excluding even numbers and formatting 15 Years Ago by Ezzaral It's as simple as incrementing by 2[code]for (int i=1; i<200; i+=2){ System.out.println(i); }[/code] The printf documentation isn't the easiest read in the world, but here is how you can limit to 3 decimal places[code]double d = 4444.3434545; System.out.printf("%.3f \t\t %.3f ", d, d*2.2);[/code] Re: excluding even numbers and formatting 15 Years Ago by Andrewsc1 wow i cant believe i didnt see that, thanks alot. Excluding rows from result 13 Years Ago by gunnarflax Let's say that I want to retrieve rows from just one table and exclude rows with certain ID's. Hypothetical table: [CODE] +----+-------+------+ | id | value | type | +----+-------+------+ | 1 | foo | cool | +----+-------+------+ | 2 | bar | cool | +----+-------+------+ | 3 | lor | cool | +----+-------+------+ | 4 | ips | … Re: Excluding rows from result 13 Years Ago by hielo try: [CODE]SELECT * FROM table WHERE type='cool' AND (id NOT IN(2,3,5) )[/CODE] Re: Excluding rows from result 13 Years Ago by gunnarflax Thank you! I think that solved it, I'll let you know if it doesn't work :) Excluding result from SELECT statement 12 Years Ago by blivori Hi, I have a table called BookTitle that holds book information. I have an SQL statement that lists all books that have the same value of a book called 'Northern Lights'. The code works but what I want to do is to exclude 'Northern Lights' from the result. This is the code I have: [CODE]SELECT bt2.btName FROM BookTitle bt1, BookTitle bt2… Re: Excluding result from SELECT statement 12 Years Ago by simplypixie Use != for 'Not equal to'. Change this [CODE]WHERE bt1.btName = 'Northern Lights'[/CODE] to this [CODE]WHERE bt1.btName != 'Northern Lights'[/CODE] Re: Excluding result from SELECT statement 12 Years Ago by hfx642 I think what you really want is... [CODE]SELECT bt2.btName FROM BookTitle bt2 WHERE bt2.btName != 'Northern Lights' AND bt2.value = (Select bt1.value From BootTitle bt1 Where bt1.btName = 'Northern Lights') Order by Upper (bt2.btName) ;[/CODE] This should get you what I think you are looking for. Re: Excluding result from SELECT statement 12 Years Ago by simplypixie How do you know that is what they really want and have therefore completely over-complicated the code the OP posted? Re: Excluding result from SELECT statement 12 Years Ago by hfx642 Well... I don't know about you, but... I read the requirements! Re: Excluding result from SELECT statement 12 Years Ago by simplypixie Yes, so did I [QUOTE]The code works but what I want to do is to exclude 'Northern Lights' from the result[/QUOTE] Quite simple in their requirements I think Re: Excluding result from SELECT statement 12 Years Ago by hfx642 Yes... I think the requirements are quite simple. However... Your modification will return ALL books (even 'Northern Lights'), MULTIPLE times (because of the join to itself). This does NOT fulfill the requirements the OP posted. Re: Excluding result from SELECT statement 12 Years Ago by easy2teach Just you have to replace WHERE bt1.btName != 'Northern Lights' instead of WHERE bt1.btName = 'Northern Lights' Re: Excluding result from SELECT statement 12 Years Ago by hfx642 Your answer is the [B][U]same[/U][/B] as [I]simplypixie[/I]'s answer. Sorry... But, this will NOT work. Excluding folders with certain files 12 Years Ago by bobgodwin I'd like to get a list of folders that don't contain certain files. I'm using this to list directories & files: [code=php]$path = "media"; $dir_handle = @opendir($path) or die("Unable to open $path"); function list_dir($dir_handle,$path) { while (false !== ($file = readdir($dir_handle))) { $exclude = array(&… Re: Excluding folders with certain files 12 Years Ago by diafol You could try this: I love glob but it doesn't have a negation. There are quite a few ways to do this, but this is a dirty and not very quick method. Have a look at SPL file - may suit you better. BTW - anybody who wants to tidy up my mess, feel free :) [CODE]function getExclusiveFiles($path,$f2e,$extensions=NULL,$pullpath=false){ $ext = ($… Re: Excluding folders with certain files 12 Years Ago by pritaeas This is another solution: [CODE] <?php $path = "media"; $dir_handle = @opendir($path) or die("Unable to open $path"); function list_dir($dir_handle, $path) { $result = array (); while (false !== ($file = readdir($dir_handle))) { $exclude = array(".", "..", "_player_thumbs&… Re: Excluding folders with certain files 12 Years Ago by bobgodwin Thanks for the replies. I ended up going with the the second example, as it was closer to what I had. Turns out I needed also to 1) Not show the other .SWFs and 2) Show only folders for another list. I ended up with this: [CODE=php]$path = "media"; $dir_handle = @opendir($path) or die("Unable to open $path"); function list_dir… Excluding Records to Insert Into DB 11 Years Ago by Stuugie Hi all, I have a csv that has over 800,000 records that gets loaded into my db via SSIS package routines. However, there are about 190 records that I do not want to be loaded into the the database. The csv comes from an external source and is unaltered at package runtime. In order to not load these records, I made a table to control load … Re: Excluding Records to Insert Into DB 11 Years Ago by BitBlt There are several approaches you could take. It all depends if you want to exclude the rows before the load. Given the small proportion of rows to exclude, I would suggest you just go ahead and load the entire CSV into the database, then as a next step, join that table to your exclusion list and delete. The statement might look something like …