Search Results

Search found 28627 results on 1146 pages for 'case statement'.

Page 279/1146 | < Previous Page | 275 276 277 278 279 280 281 282 283 284 285 286  | Next Page >

• Python combinations no repeat by constraint

  - by user2758113

  I have a tuple of tuples (Name, val 1, val 2, Class) tuple = (("Jackson",10,12,"A"), ("Ryan",10,20,"A"), ("Michael",10,12,"B"), ("Andrew",10,20,"B"), ("McKensie",10,12,"C"), ("Alex",10,20,"D")) I need to return all combinations using itertools combinations that do not repeat classes. How can I return combinations that dont repeat classes. For example, the first returned statement would be: tuple0, tuple2, tuple4, tuple5 and so on.

  Read the article

• virtual function == function pointer?

  - by httpinterpret

  A set of function pointers grouped into a data structure are often referred to as a virtual function table (VFT). The above statement makes me feel that virtual function == function pointer,is that so?

  Read the article

• What is an "import" called?

  - by Oscar Reyes

  It is not a statement nor an expression. What is that called then? A directive?

  Read the article

• references in C++

  - by Alexander

  Once I read in a statement that The language feature that "sealed the deal" to include references is operator overloading. Why are references needed to effectively support operator overloading?? Any good explanation?

  Read the article

• Init array with bool values

  - by iFloh

  my attempt to init an array with a number of bool values using: [myArray initWithObjects:[NSNumber numberWithBool:YES], [NSNumber numberWithBool:YES], [NSNumber numberWithBool:YES], nil]; seems to fail since the debugger shows an empty array after this statement is carried out ... Any clues?

  Read the article

• How can I get the name of all tables in a JavaDB database?

  - by Jonas

  How can i programmatically get the names of all tables in a JavaDB database? Is there any specific SQL-statement over JDBC I can use for this or any built in function in JDBC? I will use it for exporting the tables to XML, and would like to do it this way so I don't miss any tables from the database when exporting.

  Read the article

• Spring's JdbcDaoSupport (using MySQL Connector/J) fails after executing sql that adds FK

  - by John

  I am using Spring's JdbcDaoSupport class with a DriverManagerDataSource using the MySQL Connector/J 5.0 driver (driverClassName=com.mysql.jdbc.driver). allowMultiQueries is set to true in the url. My application is an in-house tool we recently developed that executes sql scripts in a directory one-by-one (allows us to re-create our schema and reference table data for a given date, etc, but I digress). The sql scripts sometime contain multiple statements (hence allowMultiQueries), so one script can create a table, add indexes for that table, etc. The problem happens when including a statement to add a foreign key constraint in one of these files. If I have a file that looks like... --(column/constraint names are examples) CREATE TABLE myTable ( fk1 BIGINT(19) NOT NULL, fk2 BIGINT(19) NOT NULL, PRIMARY KEY (fk1, fk2) ); ALTER TABLE myTable ADD CONSTRAINT myTable_fk1 FOREIGN KEY (fk1) REFERENCES myOtherTable (id) ; ALTER TABLE myTable ADD CONSTRAINT myTable_fk2 FOREIGN KEY (fk2) REFERENCES myOtherOtherTable (id) ; then JdbcTemplate.execute throws an UncategorizedSqlException with the following error message and stack trace: Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [ THE SQL YOU SEE ABOVE LISTED HERE ]; SQL state [HY000]; error code [1005]; Can't create table 'myDatabase.myTable' (errno: 150); nested exception is java.sql.SQLException: Can't create table 'myDatabase.myTable' (errno: 150) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) and the table and foreign keys are not inserted. Also, especially weird: if I take the foreign key statements out of the script I showed above and then place them in their own script that executes after (so I now have 1 script with just the create table statement, and 1 script with the add foreign key statements that executes after that) then what happens is: tool executes create table script, works fine, table is created tool executes add fk script, throws the same exception as seen above (except errno=121 this time), but the FKs actually get added (!!!) In other words, when the create table/FK statements are in the same script then the exception is thrown and nothing is created, but when they are different scripts a nearly identical exception is thrown but both things get created. Any help on this would be greatly appreciated. Please let me know if you'd like me to clarify anything more.

  Read the article

• something about ansi_nulls

  - by user329820

  Hi I have a question that we always say that null =null is false ,I want to know that when the ansi_nulls is off this statement which is "null=null" is also false? thanks

  Read the article

• How to insert custom date time in oracle using java?

  - by shree

  Hi i have a column (type date).I want to insert custom date and time without using Preparedstatement .i have used String date = sf.format(Calendar.getInstance().getTime()); String query = "Insert into entryTbl(name, joinedDate, ..etc) values ("abc", to_date(date, 'yyyy/mm/dd HH:mm:ss'))"; statement.executeUpdate(query); but am getting literal doesnot match error. so even tried with "SYSDATE".Its inserting only date not time.So how to insert the datetime using java into oracle?please any one help..

  Read the article

• Release Quickie

  - by Meltemi

  How to succinctly handle this situation. I'm not properly releasing contactDictionary in the if statement... NSNumber *pIDAsNumber; ... NSMutableDictionary *contactDictionary = [NSMutableDictionary dictionaryWithDictionary:[defaults dictionaryForKey:kContactDictionary]]; if (!contactDictionary) { contactDictionary = [[NSMutableDictionary alloc] initWithCapacity:1]; } [contactDictionary setObject:pIDAsNumber forKey:[myClass.personIDAsNumber stringValue]]; [defaults setObject:contactDictionary forKey:kContactDictionary];

  Read the article

• Remove non-alphanumerical characters excluding space

  - by Cecco

  I have this statement: String cap = Regex.Replace(winCaption, @"[^\w\.@-]", ""); that transforms "Hello | World!?" to "HelloWorld". But I want to preserve space character, for example: "Hello | World!?" to "Hello  World". How can I do this?

  Read the article

• Return in catch block?

  - by lowlyintern

  Is is wrong to have a return statement in a catch block? What are the alternatives? i.e: public bool SomeFunction() { try { //somecode return true; } catch(Exception ex) { MessageBox.Show(ex.message); return false; } }

  Read the article

• Multiple conditions on select query

  - by stats101

  I have a select statement and I wish to calculate the cubic volume based on other values within the table. However I want to check that neither pr.Length_mm or pr.Width_mm or pr.Height_mm are NULL prior. I've looked at CASE statements, however it only seems to evaluate one column at a time. SELECT sa.OrderName, sa.OrderType, pr.Volume_UOM ,pr.Length_mm*pr.Width_mm*pr.Height_mm AS Volume_Cubic ,pr.Length_mm*pr.Width_mm AS Volume_Floor ,pr.Length_mm ,pr.Height_mm ,pr.Width_mm FROM CostToServe_MCB.staging.Sale sa LEFT JOIN staging.Product pr ON sa.ID = pr.ID

  Read the article

• undefined C/C++ symbol as operator

  - by uray

  I notice that the character/symbol '`' and '@' is not used as an operator in C/C++, does anyone know the reason or historically why its so? if its really not used, is it safe to define those symbols as another operator/statement using #define?

  Read the article

• How do I make functions run by g_idle_add/g_timeout_add work asynchronously?

  - by httpinterpret

  g_timeout_add (100, (GSourceFunc) read_next_packets, NULL); I can feel the GUI response is slow because of the above statement. How can I make it work asynchronously so that it doesn't affect the GUI response?

  Read the article

• PHP get a boolean when it is set later in the page

  - by Thomas

  In the header of my page I have a conditional statement to check if $foo boolean is set, the trouble is that the $foo boolean doesn't get set until the footer is loaded. Any way to retroactively check the status of this boolean?

  Read the article

• Why do updates inside of a SQL transaction still need disk IO?

  - by usr

  In SQL Profiler you can see that very simple updates to a table by primary key take about 10-30ms each. On about every 10th update the write column shows 1, on all other updates it shows 0. This must mean that about every 10th update statement still requires disk IO. I wonder why that is. Would it not be more efficient queue up all IO until the transaction commits?

  Read the article

• Serialize checkbox array, also get checkboxes with off-value

  - by guzh

  Hi, I was wondering if this is possible. The serialize-string will be inserted in a mySQL-database, so it would be fine if all checkboxes would be inserted and not only the ones that is ticked(on). it's possible to make on column in the database for each of the checkboxes, and use this if/else-statement: if(isset($_GET['checkbox'])) { // It's checked! } else { // not checked! } but its a bit unappropriate...

  Read the article

• SQL Update to the SUM of its joined values

  - by CL4NCY

  Hi, I'm trying to update a field in the database to the sum of its joined values: UPDATE P SET extrasPrice = SUM(E.price) FROM dbo.BookingPitchExtras AS E INNER JOIN dbo.BookingPitches AS P ON E.pitchID = P.ID AND P.bookingID = 1 WHERE E.[required] = 1 When I run this I get the following error: "An aggregate may not appear in the set list of an UPDATE statement." Any ideas?

  Read the article

• what does 'legend' mean in sql?

  - by every_answer_gets_a_point

  im doing some practice sql problems one of the questions is: Prepare a shipping statement for customer 'C001' it should show the date, the legend 'Delivery' and the total value of the products shipped on each day. 'delivery' is not a table nor is it a column in any table. what does legend mean??

  Read the article

• WordPress - moving from one host to another

  - by Maor

  I am trying to move a WordPress installation from one server to another one, including all of the SQL data, and the file-system data (photos,template files). I just have a problem changing the URLs in the database, since I need to replace the new URL with the old one. I would love to have some suggestions about how can I replace the URLs (maybe there's a rplace statement in SQL?) Thanks in advance.

  Read the article

• C# How do I replace an actual asterisk character (*) in a Regex expression?

  - by fraXis

  Hello, I have a statement: I have a string such as content = "* test *" I want to search and replace it with so when I am done the string contains this: content = "(*) test (*)" My code is: content = Regex.Replace(content, "*", "(*)"); But this causes an error in C# because it thinks that the * is part of the Regular Expressions Syntax. How can I modify this code so it changes all asterisks in my string to (*) instead without causing a runtime error? Thanks.

  Read the article

• exclude joined rows from a select

  - by Vaccano

  I have two tables. One has rows with values A-Z and the other has D-G. How do I make a select statement to return only the values A-C, H-Z? (This is, of course a dumbed down version of my real tables and problem.)

  Read the article

• Apple script Editor, write message to the "Result" window

  - by Patrick

  I am using the Mac OS X Apple Script Editor and (while debugging) instead of writing a lot of display dialog statements, I'd like to write the results of some calculation in the window below, called "Result" (I have the German UI here, so the translation is a guess). So is there a write/print statement that I can use for putting messages in the "standard out" window? I am not asking to put the messages in a logfile on the file system, it is purely temporary.

  Read the article

• DataSet on Webserver

  - by Turk

  Hi, Im trying to implement something given to me however I've come across an error when using: [WebMethod] public DataSet getAll() { DataSet isnt recognised. Im guessing I'm missing one of the "using System..." statement from the start but I dont know what it is. I was wondering if anyone could help me out? Im using Visual Studio 2008

  Read the article

< Previous Page | 275 276 277 278 279 280 281 282 283 284 285 286  | Next Page >