Search Results

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

Page 289/1146 | < Previous Page | 285 286 287 288 289 290 291 292 293 294 295 296  | Next Page >

• 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

• 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

• SQL java get value assigned to auto increment primary key

  - by iamrohitbanga

  I have a primary key auto increment attribute in my table. I want to know the value assigned to it for a row that is inserted using statement.executeQuery(). How to achieve this in the best possible manner?

  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

• Oracle: how to UPSERT (update or insert into a table?)

  - by Mark Harrison

  The UPSERT operation either updates or inserts a row in a table, depending if the table already has a row that matches the data: if table t has a row exists that has key X: update t set mystuff... where mykey=X else insert into t mystuff... Since Oracle doesn't have a specific UPSERT statement, what's the best way to do this?

  Read the article

• Creating temporary tables in MySQL Stored Procedure

  - by burntblark

  The following procedure gives me an error when I invoke it using the CALL statement: CREATE DEFINER=`user`@`localhost` PROCEDURE `emp_performance`(id VARCHAR(10)) BEGIN DROP TABLE IF EXISTS performance; CREATE TABLE performance AS SELECT time_in, time_out, day FROM attendance WHERE employee_id = id; END The error says "Unknown table 'performance' ". This is my first time actually using stored procedures and I got my sources from Google. I just cant figure out what I am doing wrong.

  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

• Execute multiple queries

  - by smartali89

  I am using OleDB for executing my queries in C#, Is there any way I can execute multiple queries in one command statement? I tried to separate them with semi-colon (;) but it gives error "Characters found at the end" I have to execute a few hundreds of queries at once.

  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

• How to write 2 statements that differ just by Operator type in VB.NET

  - by Richard Bysouth

  Hi I have the following code sample, where the only difference between the 2 parts of the If statement is the less than/greater than operators. Is there a better way to write this? Could almost do with being able to define an Operator variable. If myVar = true Then Do While (X < Y) 'call Method A Loop Else Do While (X > Y) 'call Method A Loop End If thanks

  Read the article

• View Lambdas in Visual Studio Debugger

  - by Vaccano

  I have the a simple LinqToSQL statement that is not working. Something Like this: List<MyClass> myList = _ctx.DBList .Where(x => x.AGuidID == paramID) .Where(x => x.BBoolVal == false) .ToList(); I look at _ctx.DBList in the debugger and the second item fits both parameters. Is there a way I can dig into this more to see what is going wrong?

  Read the article

• Help translating from assembly to C

  - by user324994

  I have some code from a function subl $24, %esp movl 8(%ebp), %eax cmpl 12(%ebp), %eax Before the code is just the 'ENTER' command and afterwards there's an if statement to return 1 if ebp eax or 0 if it's less. I'm assuming cmpl means compare, but I can't tell what the concrete values are. Can anyone tell me what's happening?

  Read the article

• C++ header file and function declaration ending in "= 0"

  - by Adam

  hi, I have the following code inside the .h file and I'm not sure what does the assignment statement do and how is it called properly? virtual void yield() = 0; I thought that the function returns a value of 0 by default but since this function returns void I am a little bit confused. Can anyone comment on this and maybe say how can I refer to this assignment, I mean how is it called in C++ jargon? Thanks.

  Read the article

• How to construct these HQL statements

  - by losintikfos

  Do anyone know how to construct these two SQL statement in HQL; SELECT MIN(id) FROM Books WHERE mid < ? OR mid =? SELECT SUM(noOfBooks) FROM Bookcount WHERE mId=128

  Read the article

• how to run if(!User.IsAuthenticated) or access Profile.values in App_Code? c# .NET

  - by korben

  i'm trying to run a conditional statement in a class i'm placing in my App_Code folder the condition is whether the person is logged in or not. I normally have two ways to do this in my masterpage and ASPX's if (!User.IsAuthenticated) or if(Profile.username = "anonymous") however neither of these things seem available to me in the .cs i'm making. anyone know what i'm missing? maybe a using namespace up top?

  Read the article

• What is the purpose of ROWLOCK on Delete and when should I use it?

  - by RPS

  Ex) When should I use this statement: DELETE TOP (@count) FROM ProductInfo WITH (ROWLOCK) WHERE ProductId = @productId_for_del; And when should be just doing: DELETE TOP (@count) FROM ProductInfo WHERE ProductId = @productId_for_del;

  Read the article

• Magento Reindexing doesn't work

  - by Dgent

  I recently created around 700 attributes through script, all attributes look fine at backend. But when I reindex, I get following error: exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.additional_information_s' in 'field list'' in /lib/Zend/Db/Statement/Pdo.php:228 Note: this attribtue exist in Database (eav_attribtue) table. I would highly appreciate suggestion. Looking forward to heat from you geeks. Thanks

  Read the article

• How can I check for unused import in many Python files?

  - by Thierry Lam

  I remember when I was developing in C++ or Java, the compiler usually complains for unused methods, functions or imports. In my Django project, I have a bunch of Python files which have gone through a number of iterations. Some of those files have a few lines of import statement at the top of the page and some of those imports are not used anymore. Is there a way to locate those unused imports besides eyeballing each one of them in each file? All my imports are explicit, I don't usually write from blah import *

  Read the article

• if with multiple conditions, order of execution

  - by markus

  Hi, In an if statement with multiple conditions is second executed if the outcome is clear after checking the first condition? example: if(i>0 && array[i]==0){ } If I swap the conditions a seg fault may occur for negative values of i but this way the memory debugger doesn't find a problem. Can I be sure that this works always or do have have to use nested if statements?

  Read the article

• Zend Framework Multiple Table Query

  - by Jeff

  I am looking to execute this statement via Zend Framework. As I understand it, I can use Zend_Db_Select. Is it possible to use Zend_Db_Table? Three tables: classes, students, and class_students select classes.name, students.student_id, students.fname, students.lname from students, classes, class_students where class_students.student_id=students.student_id AND class_students.class_id=classes.class_id;

  Read the article

• How do I play with test command properly?

  - by httpinterpret

  [root@jiaoyou ~]# test 1 = 1 -a 0 = 1 [root@jiaoyou ~]# if [1 = 1 -a 0 = 1]then echo 1;else echo 2;fi -bash: syntax error near unexpected token `else' Why test doesn't give any output and the if statement fails? Can someone point out what's wrong here?

  Read the article

• Adding a Image to UITable View Cell

  - by Graeme

  Hi, I have a table in which I want a dynamic image to load in at the left-hand side. The table needs to use an IF statement to select the appropriate image from the "Resources" folder, and needs to be based upon [dog types]. The [dog types] is extracted from an RSS feed, and so the image in the table cell needs to match the each cell's [dog types] tag. I suspect I need to use - (UIImage *)imageForTypes:(NSString *)types { to do such a thing. Thanks.

  Read the article

• PHP function, return by value or by reference?

  - by Andree

  Hi there! When I use return statement in PHP, will the result be returned by value or by reference? Thanks! Andree.

  Read the article

• "Blank SQL" error with phppgadmin

  - by Hoàng Long

  Here is my problem: I export a database A_DB using "export" function of Phppgadmin. The dump file A_dump.sql includes both the database structure and data. Then I try to create another blank database B_DB, and import A_dump.sql into it. Every time I do that, the transaction failed with no error reported: SQL error: In statement: Is there some logs that I can find in phppgadmin that would allow me to investigate this problem? I have tried searching for an hour, but still not find anything.

  Read the article

< Previous Page | 285 286 287 288 289 290 291 292 293 294 295 296  | Next Page >