Search Results

Search found 6988 results on 280 pages for 'statement'.

Page 135/280 | < Previous Page | 131 132 133 134 135 136 137 138 139 140 141 142  | Next Page >

• How to find out if a Java ResultSet obtained is empty?

  - by Bruce

  Class.forName("org.sqlite.JDBC"); Connection conn = DriverManager.getConnection("jdbc:sqlite:userdata.db"); Statement stat = conn.createStatement(); ResultSet rs = stat.executeQuery("SELECT * from table WHERE is_query_processed = 0;"); How can I find out if rs is empty?

  Read the article

• Escapeing values in PDO statements

  - by Pardoner

  Doesn't prepare() escape any quotes(') in a PDO statement? For some reason when I do this: $sql = "INSERT INTO sessions (id, name) VALUES (1,'O'brian')"; $query = $this->connection->prepare($sql); $query->execute(); I get this error: Could not insert record SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'brian'. How could this be if I'm using prepare()?

  Read the article

• How can I implement a 'select all' check-box on my CRM 4 custom form?

  - by Gryphoenix

  I am working on a custom CRM form with numerous checkboxes, organized by sections. I would like to implement a 'select all' feature to the form and am trying to understand how to format the JavaScript. My research thus far has pointed me to the possibility of using a FOR statement to iterate through all of the elements in the section I want to process, setting their values accordingly, but am unsure of which document.getElements ... method to utilize.

  Read the article

• how to return some default value in oracle cursor when nothing is found

  - by john

  I have following statement in one of the oracle SP: OPEN CUR_NUM FOR SELECT RTRIM(LTRIM(num)) as num FROM USER WHERE USER_ID = v_user_id; When the above does not return anything the SP result just has no column name in it. But I'd like the cursor to still have num column with some default value like NOTHING when no data is found. Is this doable ?

  Read the article

• iPhone time comparison

  - by Rob

  I am trying to figure out how to create an 'if' statement that uses a time value as a condition. For example: if (time <= 10:00) { score = 3; } else if (time <= 20:00) { score = 5; } else { score = 9; } I know that a string of "5:23" cannot be compared this way but I don't think I can just turn a string value like that directly into an integer. Any thoughts?

  Read the article

• What is the use of "Partition" keyword in MySQL?

  - by chandru_cp

  As I am a MySQL newbie. What does PARTITION mean in this MySQL statement? CREATE TABLE employees ( id INT NOT NULL, fname VARCHAR(30), lname VARCHAR(30), hired DATE NOT NULL DEFAULT '1970-01-01', separated DATE NOT NULL DEFAULT '9999-12-31', job_code INT NOT NULL, store_id INT NOT NULL ) PARTITION BY RANGE (store_id) ( PARTITION p0 VALUES LESS THAN (6), PARTITION p1 VALUES LESS THAN (11), PARTITION p2 VALUES LESS THAN (16), PARTITION p3 VALUES LESS THAN (21) );

  Read the article

• Are There Any Other Web Programming Languages That Can Be Used Without A Framework Aside From PHP?

  - by Ygam

  Python needs a framework, so does Java (for the web). I don't know much about Ruby or Coldfusion. But is there another language out there for the web that can stand alone as it is without a need for a framework or without strict adherence to a design pattern (MVC and the likes) aside from PHP? BTW, the statement that Python and Java needs a framework to work with the web came purely from my readings on articles and books; I might be mistaken.

  Read the article

• SSIS to copy data from one table to another, where not in destination table

  - by alex

  I'm in the process of creating an SSIS package on a server (server1) that looks at the data in a sql db on another site (server2) and copies relevant rows across. The SQL statement required is: SELECT * FROM server2.ordersTable WHERE OrderID Not In (SELECT OrderID FROM server1.ordersTable This selects data from server1 which isn't in the table on server2 (based on order id) I then need to insert the result into a table on server1 How would I approach this? What components do I need etc...?

  Read the article

• C++: Short question regarding switch and break

  - by oh boy

  Example: switch( x ) { case y: if ( true ) { break; } cout << "Oops"; break; } If the switch statement selects y, will Oops be written to the standard output? - Is break in switch statements a dynamic keyword like continue which can be called under conditions or static like a closing bracket }?

  Read the article

• Page Fault Interrupt Problems

  - by Vikas

  This is a statement referring to problem caused by page fault:(from Silberschatz 7th ed P-310 last para) 'We cant simply restart instructions when instruction modifies several different location Ex:when a instruction moves 256 bytes from source to dest and either src or dest straddles on page boundary , then,after a partial move, if a page fault occurs, 'we can't simply restart the instructions' My question is Why not? Simply restart the instruction again do the same copy after page is in. Is there any problem in it?

  Read the article

• compacting line of code

  - by dlee313

  Assume I have the following: unsigned int *start; unsigned int total; #define OFF_MASK (1 << 31) #define ON_MASK (~(1 << 31)) if (!(*start & OFF_MASK) && ((*start & ON_MASK) >= total))) How do I change the above if statement so that it makes just one comparison like this: if (*start >= total)

  Read the article

• What are some examples of where using parentheses in a program lowers readability?

  - by Brandon

  I always thought that parentheses improved readability, but in my textbook there is a statement that the use of parentheses dramatically reduces the readability of a program. Does anyone have any examples?

  Read the article

• How to identify the culprit in "Error converting data type varchar to numeric"?

  - by Stan

  An insert statement with a large number of values returns 'Error converting data type varchar to numeric.' How can I find which value actually triggers the error? MS SQL Server 2008 is used.

  Read the article

• mysql restore file.sql syntax error using command line

  - by Jason

  when I input mysql -u root -p XXXX dbname < c:/filename.sql alway get this error "error 1064 <42000:" you have an error in your SQL suntax; check the manual that corresponds to your MySql server version for the right syntax to use near ..... what is wrong with this statement?

  Read the article

• Efficient SQL to count an occurrence in the latest X rows

  - by pulegium

  For example I have: create table a (i int); Assume there are 10k rows. I want to count 0's in the last 20 rows. Something like: select count(*) from (select i from a limit 20) where i = 0; Is that possible to make it more efficient? Like a single SQL statement or something? PS. DB is SQLite3 if that matters at all...

  Read the article

• What was the most stupid code mistake you have ever made?

  - by Ramesh

  What was the most stupid code mistake you have ever made that had great consequences, e.g. you were fired? For example, a friend of mine wrote a cycle with conditional statement for break that was never true, which caused one high-loaded site to hang up for the whole night.

  Read the article

• Preprocessor #if directive

  - by Caslav

  I am writing a big code and I don't want it all to be in my main.c so I wrote a .inc file that has IF-ELSE statement with function and I was wondering can it be written like this: #if var==1 process(int a) { printf("Result is: %d",2*a); } #else process(int a) { printf("Result is: %d",10*a); } #endif I tried to compile it but it gives me errors or in best case it just goes on the first function process without checking the var variable (it is set to 0).

  Read the article

• Does main() need to be in every script containing handlers?

  - by Will Merydith

  Experienced Java programmer trying to learn Python. I have an applicaiton on Google App Engine and want to move my admin Handlers to a separate file. So now I have main.py and admin.py. I've set up app.yaml to route traffic properly, and have added the call to WSGIApplication() in each file to route to the appropriate Handler. My question is does each script file need def main() and the corresponding if statement: application = webapp.WSGIApplication([(r'/admin/(.*)', Admin)], debug=True) def main(): run_wsgi_app(application) if __name__ == '__main__': main()

  Read the article

• Will IE9 support conditional comments?

  - by greim

  I thought I remembered reading somewhere that IE9 would not be supporting them, but now after searching I can't find any indication that this is true. Is anyone aware of a definitive statement, either way, about whether Microsoft will be supporting conditional comments in IE9?

  Read the article

• How to create a temporary table in Oracle

  - by GigaPr

  Hi I would like to create a temporary table in a Oracle database something like Declare table @table (int id) In SQL server And than populate it with a select statement Is it possible? Thanks

  Read the article

• Why does this code sometimes throw a NullPointerException?

  - by Tiberiu Hajas

  Consider the following Java source: if( agents != null ) { for( Iterator iter = agents.keySet().iterator(); iter.hasNext(); ) { // Code that uses iter.next() ... // } } The agents is a HashMap. Why does the for statement sometimes throw a NullPointerException? Thank you.

  Read the article

• Jquery .text() call returns null?

  - by Alex

  Hey all, I'm practicing Jquery and I've written this simple Jquery statement: var someText = $("table tr td").text(); Should this not return all text of td elements found within tr's that are found within tables? How do I fix this? Currently when I run this, it says that table tr td is null, but I have a table on the page I'm testing on. Thanks!

  Read the article

• PHP Echo with single quote or double quotes?

  - by nepc

  The is a very simple echo statement but I can't solve it? echo '"What is your name?'";

  Read the article

• Unknown Column In Where Clause

  - by Corpo

  I have a simple query: SELECT u_name AS user_name FROM users WHERE user_name = "john"; I get "Unknown Column 'user_name' in where clause". Can I not refer to 'user_name' in other parts of the statement even after select 'u_name as user_name'?

  Read the article

• Scanning a mysql table from the bottom

  - by ming yeow

  When i run a mysql select statement, it takes very long because i have already previously deleted a very large number of rows. Is there a way for the table to start scanning from the bottom, as opposed to from the top?

  Read the article

< Previous Page | 131 132 133 134 135 136 137 138 139 140 141 142  | Next Page >