Search Results

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

Page 41/1146 | < Previous Page | 37 38 39 40 41 42 43 44 45 46 47 48  | Next Page >

• Why is the ( ) mandatory in the SQL statement select * from gifts INNER JOIN sentgifts using (giftID

  - by Jian Lin

  Why is the ( ) mandatory in the SQL statement select * from gifts INNER JOIN sentgifts using (giftID); ? The ( ) usually is for specifying grouping of something. But in this case, are we supposed to be able to use 2 or more field names... in the example above, it can be all clear that it is 1 field, is it just that the parser is not made to bypass the ( ) when it is all clear? (such as in the language Ruby).

  Read the article

• mysql statement with inner SELECT - how to improve performance

  - by ernie

  This statement appears inefficient because only one one out of 10 records are selected and only a of 100 entries contain comments. What can I do to improve it ? $query = "SELECT A,B,C, (SELECT COUNT(*) FROM comments WHERE comments.nid = header_file.nid) as my_comment_count FROM header_file Where A = 'admin' "

  Read the article

• Is using the break statement bad practice?

  - by Lchi

  I've been told by professors and peers at my university that using the break statement is bad practice, but through my coursework haven't come up with a great reason why. Those who claim that it is bad say that it's a "get out of jail free card" and that you can always avoid using it. My guesses for why its considered bad would be that you could possibly skip some cleanup code after the break, or similarly exit some control structure in an inconsistent state. Is there any reason why using break is(n't) bad practice?

  Read the article

• iPhone Game Having a statement checked every 50 points

  - by user298261

  Hello! I've run into a little hurdle and wanted to see if somebody could help me! I want to write an algorithm for an if statement that says: if (for every 50 points) { //do something } I thought += 50 would do the trick, but nope. Any ideas? Thanks!

  Read the article

• IF Statement in VBA

  - by Edmond

  How would I code a IF statement if I was trying to say IF the date today is equal to Monday THEN Have Outlook prepare 3 emails ELSE Have Outlook prepare 2 emails END IF I just need help setting up the "IF the date today is equal to Monday." How would that code look.

  Read the article

• "with" scope and properties with square bracket notation

  - by Anurag

  Is it possible to access object properties that can only be accessed with the square bracket notation when inside a "with" statement. Example: var o = { "bad:property": 1, "goodProperty": 2 }; with(o) { console.log(goodProperty); // works awesome console.log(???) // how to access "bad:property"? }

  Read the article

• IF statement error

  - by Jasl

  I have the following columns in TableA TableA Column1 varchar Column2 int Column3 bit I am using this statement IF Column3 = 0 SELECT Column1, Column2 FROM TableA WHERE Column2 > 200 ELSE SELECT Column1, Column2 FROM TableA WHERE Column2 < 200 But the statment does not compile. It says Invalid Column Name 'Column3'

  Read the article

• SQL CASE WHEN NULL - question

  - by cc0

  Ok, so I'm trying to select an amount of rows from a column that holds the value 3, but only if there are no rows containing 10 or 4, if there are rows containing 10 or 4 I only want to show those. What would be a good syntax to do that? So far I've been attempting a CASE WHEN statement, but I can't seem to figure it out. Any help would be greatly appreciated. (My database is in an MS SQL 2008 server)

  Read the article

• Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing

  - by Paresh

  I am getting the error from the application as following with SQL server 2005 "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0" How can i find the stage where this error raised? how can i found the missing transaction or the stored procedure where it is not committ or rollback?

  Read the article

• multiple params in a mysql statement

  - by Kaartz

  i use this statement for a single where condition ('SELECT * FROM users WHERE id = ?', 1) if I want to check two conditions, how would I do that ('SELECT * FROM users WHERE id=? AND age=?', 1,23)- is this correct?

  Read the article

• jquery if else, why does not work?

  - by Cesar Lopez

  In the following function it goes through the if and the else, why is that? function test(){ $(".notEmpty").each(function() { if($(this).val() === ""){ alert("Empty Fields!!"); return; } else{ AddRow_OnButtonClick('tblMedicationDetail',6); } }); } Is there any if and else statement on jquery that I am not aware of? Thanks

  Read the article

• Ternary operator in if-statement?

  - by Pindatjuh

  I've written the following if-statement in Java: if(methodName.equals("set" + this.name) || isBoolean() ? methodName.equals("is" + this.name) : methodName.equals("get" + this.name)) { ... } Is this a good practice to write such expressions in if, to separate state from condition? And can this expression be simplified?

  Read the article

• convert a sql statement to class?

  - by walter

  Is there a tool or code to convert a sql statement to class? Something like: Dim sqlText = "SELECT CustomerID, Name, Address, City FROM dbo.Customer WHERE CustomerID = 1" Dim obj As New ***SqlStatementTool***(sqlText) obj.GetTables() 'Will Return Tables in sqlText obj.GetWheres() 'Will Return conditions in sqltext obj.GetParameters() 'will return parameters in sqltext

  Read the article

• How do I reference sqlite db column to use in update statement

  - by user244190

  I am trying to update a datetime column in an android sqlite db to use international date format (yyyy-mm-dd) instead of the current format (mm/dd/yyyy). I want to use the sqlite date() function to reformat the current value of the column. I thought it would be as simple as the following: update tblename set thedate = date(thedate) but the above does not work. How would i write the sql statement to accomplish this? thanks patrick

  Read the article

• Nested if statements or not

  - by Zaps

  Hi, I hope this hasn't been asked before. I have a nullable boolean called boolIsAllowed and a if condition like so: if(boolIsAllowed.HasValue && boolIsAllowed.Value) { //do something } My question is this good code or would I be better separating it into a nested if statement? Will the second condition get checked if boolIsAllowed.HasValue is equal to false and then throw an exception? I hope this question is too stupid. Thanks in advance.

  Read the article

• about Select statement !

  - by user329820

  hi, I have read that after select we use column-names but I have found a statement that was like this: SELECT 'A' FROM T WHERE A = NULL; would you lease help me? thanks (A is a column- name here?) my DBMS is MySQL

  Read the article

• Linq to Sql statement for multiple aggregate values in single expression

  - by Jeff Langston

  How would I write a linq to sql statement for the following tsql? select count(*), sum(Amount), avg(Amount), min(Amount), max(Amount) from TableName

  Read the article

• when using javascript how do you use select form to do if else statements?

  - by Nelson

  How do you take a value of an option in a select form and use it for a if else statement? for example if apple is selected as an option then write to the document how to make applesauce but orange is selected then write how to make orange? so far I have a basic form and select options and I know how to do the document.write but I dont know how to use a select form with if else thanks for the help

  Read the article

• C segmentation fault before/during return statement

  - by wolfPack88

  I print the value that I'm returning right before my return statement, and tell my code to print the value that was returned right after the function call. However, I get a segmentation fault after my first print statement and before my second (also interesting to note, this always happens on the third time the function is called; never the first or the second, never fourth or later). I tried printing out all of the data that I'm working on to see if the rest of my code was doing something it maybe shouldn't, but my data up to that point looks fine. Here's the function: int findHydrogen(struct Amino* amino, int nPos, float* diff, int totRead) { struct Atom* atoms; int* bonds; int numBonds; int i; int retVal; int numAtoms; numAtoms = (*amino).numAtoms; atoms = (struct Atom *) malloc(sizeof(struct Atom) * numAtoms); atoms = (*amino).atoms; numBonds = atoms[nPos].numBonds; bonds = (int *) malloc(sizeof(int) * numBonds); bonds = atoms[nPos].bonds; for(i = 0; i < (*amino).numAtoms; i++) printf("ATOM\t\t%d %s\t0001\t%f\t%f\t%f\n", i + 1, atoms[i].type, atoms[i].x, atoms[i].y, atoms[i].z); for(i = 0; i < numBonds; i++) if(atoms[bonds[i] - totRead].type[0] == 'H') { diff[0] = atoms[bonds[i] - totRead].x - atoms[nPos].x; diff[1] = atoms[bonds[i] - totRead].y - atoms[nPos].y; diff[2] = atoms[bonds[i] - totRead].z - atoms[nPos].z; retVal = bonds[i] - totRead; bonds = (int *) malloc(sizeof(int)); free(bonds); atoms = (struct Atom *) malloc(sizeof(struct Atom)); free(atoms); printf("2 %d\n", retVal); return retVal; } } As I mentioned before, it works fine the first two times I run it, the third time it prints the correct value of retVal, then seg faults somewhere before it gets to where I called the function, which I do as: hPos = findHydrogen((&aminoAcid[i]), nPos, diff, totRead); printf("%d\n", hPos);

  Read the article

• What's wrong with this statement in perl?

  - by benjamin button

  print "$_", join(',',sort keys %$h),"\n"; It's giving me an error below: Use of uninitialized value in string at missing_months.pl line 36. 1,10,11,12 this print statement is present in a for loop as below: foreach my $num ( sort keys %hash ) { my $h = $hash{$num}; print "$_", join(',',sort keys %$h),"\n"; }

  Read the article

• Styling an If Else Statement

  - by ThatMacLad

  I know that it's not possible to style any given PHP but I do know that it is possible to style the output HTML that the PHP provides you with. I was wondering if there was any method available for me to use that would enable me to style the output from my IF ELSE statement. if ($result != false) { print "Your entry has successfully been entered into the blog."; }

  Read the article

• why is optional chaining required in an if let statement

  - by b-ryan ca

  Why would the Swift compiler expect me to write if let addressNumber = paul.residence?.address?.buildingNumber?.toInt() { } instead of just writing: if let addressNumber = paul.residence.address.buildingNumber.toInt() { } The compiler clearly has the static type information to handle the conditional statement for the first dereference of the optional value and each following value. Why would it not continue to do so for the following statements?

  Read the article

• need help with a simple SQL update statement.

  - by Tony

  There's a field with type of varchar. It actually stores a float point string. Like 2.0 , 12.0 , 34.5 , 67.50 ... What I need is a update statement that remove the ending zeros of fields like 2.0 , 12.0 , change them to their integer representation , that is 2 , 12 ...,and leave 3.45 , 67.50 unchanged . How should I do this ? I am using oracle 10.

  Read the article

• SQL Server merge statement source and target issue

  - by George2

  Hello everyone, I am using SQL Server 2008 Enterprise and using the new Merge statement. From my experiment, I find source is always read only (table content not modified, i.e. no record is deleted/inserted/updated)? Is that correct understanding? thanks in advance, George

  Read the article

• HAML indentation problem IF

  - by Pieter Demoor

  This is my code: [email protected] do |a| -if @i%3 == 0 %ul %li=link_to a.name, a -@i += 1 I need the li to be inside the ul which is inside the if-statement. I can't do it because of the indentation. Can't I just tell the li to indent automatically? Thanks

  Read the article

< Previous Page | 37 38 39 40 41 42 43 44 45 46 47 48  | Next Page >