Search Results

Search found 14757 results on 591 pages for 'switch statement'.

Page 222/591 | < Previous Page | 218 219 220 221 222 223 224 225 226 227 228 229  | Next Page >

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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 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 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

• 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

• 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

• 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

• AppendTo does not work as desired

  - by Gokul

  When I say, msg.appendTo(ele.parent().next()), the msg successfully gets appended to a <p> with class=foo How can I specify it explicitly in the statement? I tried msg.appendTo(ele.parent().next().find('.foo')); but it doesn't work

  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

• 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

• "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

• Display the Element ID

  - by Gokul

  I am using this statement alert(el.parent().next()); But I am getting [object] [object] as an alert. How do I display the ID of the element?

  Read the article

• Play a wav file retrieved from a database on the iPhone?

  - by user312917

  I have alot of wav files stored in sqlite3, but when I retrieve one of them, I can't play it. The retrieve code is NSData *soundData = (NSDATA *)sqlite3_column_blob(statement, 0); mPlayer = [[AVAudioPlayer alloc] initWithData:soundData error:&error]; The data is stored as binary and it's there when I search for it using sqlite3.

  Read the article

• Easy mysql question regarding primary keys and an insert

  - by MPX

  In mysql, how do I get the primary key used for an insert operation, when it is autoincrementing. Basically, i want the new autoincremented value to be returned when the statement completes. Thanks!

  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

• java: primitive arrays -- are they initialized?

  - by Jason S

  If I use a statement in my code like int[] a = new int[42]; does it initialized the array to anything in particular? (e.g. 0) I seem to remember this is documented somewhere but I am not sure what to search for.

  Read the article

• In SQL Server, how can I insert data into a table that has just one column which is of identity type

  - by Yousui

  In SQL Server, how can I insert data into a table that has just one column which is of identity type? Such as insert into the following table t. How can I write the insert statement? CREATE TABLE t ( id INT IDENTITY(1, 1) PRIMARY KEY ) Great thanks.

  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

• nested sql statements

  - by Hadad

  Hello, I've a self join table when I delete or update it's id I want to delete or update all the direct and indirect affected records SQL server does not allow this type of cycle cascading I've decided to use triggers but this triggers will file recursively and they will be terminated at 34 level and I don't know the depth of records and event I disable the trigger and re enable it after completing the process how can I construct a SQL statement that achieve this logic?

  Read the article

< Previous Page | 218 219 220 221 222 223 224 225 226 227 228 229  | Next Page >