Stack Overflow
Stack Overflow

Questions tagged [except]

Used for the MS .NET LINQ Except() method and the Python except keyword for exception handling. Use the tag sql-except for questions related to the SQL operator EXCEPT

This tag is used for two different things:

  1. The Microsoft [.NET] Framework [LINQ] Except() method which produces set differences of two sequences.

  2. The [Python] keyword except used for exception handling.

Please use the tag for questions related to the SQL operator EXCEPT

598 questions
-1
votes
1 answer

Get difference of unique and duplicate set - SQL

I have two similar data sets (table, view, CTE), one of which contains unique rows (guaranteed by DISTINCT or GROUP BY), the second contains duplicates (no primary key constraint involved). How can I get the difference of two data sets so that I…
Hakim
  • 452
  • 4
  • 15
-1
votes
1 answer

SQL Except or Minus

I have two table with same "id" for companies and i need for "select all" make as minus special companies which do invoice in concrete date. I tried minus fuctions but its does not work in our ERP systems but i can use "except" but it does not work…
Radek Tarant
  • 227
  • 1
  • 5
  • 14
-1
votes
2 answers

How to find not matching records in Generic List in C#

I have two Generic List object, I want to get records which are not matching in second Generic list object. Below is my code. But it returning all records. I want to ignore matching record in first list. public class CuratedIncludeUid { …
Shakeer Hussain
  • 2,230
  • 7
  • 29
  • 52
-1
votes
1 answer

Figuring out except ValueError

Following along with Al Sweigarts python lessons and tried modifying his cat code some. I can input the "except ValueError" fine using just if and elif statements but I think using a while statement I am messing something up. I want this simple code…
Mook
  • 39
  • 7
-1
votes
2 answers

Why EXCEPT function doesn't work?

I have mysql query like this below: $missingTypo = mysql_query("SELECT m.ID FROM table1 AS m LEFT JOIN table2 AS ut ON ut.matchID = m.ID …
Łukasz Mikowski
  • 5
  • 3
-1
votes
2 answers

Datatables, Except, c#

I have two Datatables Datatable A; //has a primany key ID Datatable B; // has a primary key ID I want the difference between A and B (A minus B). When using except operator in C#, on what parameter does except function? I want the difference…
Vineet Alampally
  • 3
  • 1
  • 5
-1
votes
2 answers

except, it returns the excepts but it continues to run, python

hours = input("Enter hours: ") rate = input("Enter rate: ") try: hours = float(hours) rate = float(rate) except: print("Enter real numbers") def computepay(hours, rate): if hours <= 40.0: pay = hours * rate return…
Che
  • 1
-1
votes
2 answers

Except Finally - Operator

i have an curious Question regarding except Block, especially finally: During the first Block of Code finally works as it is supposed to work, meanwhile in second which is minimaly different from the first one it always gives you an…
Roman
  • 113
  • 1
  • 1
  • 6
-1
votes
2 answers

Write a basic program that takes number and returns its corresponding month abbreviation

I'm trying to write a basic function that takes a number and returns the abbreviation of each month. It sounds simple enough, but how can I use a "try-except"block to handle any exceptions? Here's what I have so far. def month(): months =…
Brian
  • 81
  • 1
  • 3
  • 9
-1
votes
2 answers

Python Syntax Error in Except Suite

I am getting a syntax error in a try suite on a variable created within the try suite. Is it not correct to call a variable in the except suite that was created in the try suite? This is the only reason I could think of that there would be a syntax…
juggy_crisp
  • 11
  • 1
-1
votes
3 answers

a regular expression with except word doesn't work

I have the code let dirtyHtml = ` `; let clearHtml = dirtyHtml.replace(/]+(?!emojione)[^<>]+>/gi,…
constantant
  • 1,192
  • 1
  • 13
  • 25
-1
votes
1 answer

What is the difference between IQueryable .Where and IQueryable.Except?

I tried to use Except method. I thought this method was more powerfull and generates a cleaner SQL than a WHERE clause but not. It generates the same sql. So why / when use Except method ? EDIT : here is a sample : // Get customers except those…
Florian
  • 4,507
  • 10
  • 53
  • 73
-1
votes
2 answers

Python try/except

I'm trying a small program out of the Automate the Boring Stuff book. I want to ensure that someone inputting a non-int variable will not crash the program. The code kicks out an error saying that the "break" command is not in the loop. Any help…
Michael Porter
  • 229
  • 3
  • 12
-1
votes
2 answers

How can I make a Validation Try and Except Error for this?

I have this code as shown below and I would like to make a function which has a try and except error which makes it so when you input anything other than 1, 2 or 3 it will make you re input it. Below is the line which asks you for your age. Age…
EDoggyDog
  • 17
  • 1
  • 5
-1
votes
2 answers

How do I catch a particular exception that I am expecting?

I have been trying to make a simple zip file password cracker (just for fun, not malicious purposes) however my try and except statement will not work. No matter the input it always leads to the except statement, and the else is never executed (even…
Ellis
  • 105
  • 2
  • 10
1 2 3
…
39 40