Search Results

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

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

• 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

• Is this MySql Query Statement correct?

  - by Stanley Ngumo

  Hi I would like to know whether this MySql statement will be executed correctly, "SELECT sum(price) FROM products WHERE productid IN (SELECT productid FROM shoppingcart WHERE sessionid=".$this->$sessionid.")" And if not please give me pointers as to where I am wrong. Thanks

  Read the article

• jquery - if else if?

  - by YesThatsRight

  I've been trying to figure out the syntax for an if / else if statement in jquery, but googling gives me mixed messages... There are some sites that say I need a plugin, and others that suggest that it's already possible. Trying those suggestions give me jquery errors in the jquery.js file, so I'm wondering, do I need a plugin or not? Does someone have an example of an if () { //do something } else if () { //do something else } else { //do something } in jquery?

  Read the article

• how to generate the "create table" sql statement for an existing table in postgreSQL

  - by Raja

  I have a table created long ago in postgreSQL. Now i want to look at the sql statement used to create it but cannot figure it out. Also when i do the \dS+ tablename it says table not found, but \dt+ tablename is working fine. The \dS+ lists all the table names owned by the root postgres user and doesn't show up tables that i created with my user account. Any help is greatly appreciated. Thanks

  Read the article

• Conditional statement, etc. organizing in gedit

  - by Onion

  Hi, I was wondering if it was possible to group/organize conditional statement blocks in gedit in much the same manner as notepad++, via a plug-in or other means. Thanks to all in advance. http://i50.tinypic.com/2vuyd5f.png (Image, for reference.)

  Read the article

• Constructing an if statement from the client data in python

  - by Vishal

  Hi, I need to construct an if statement from the data coming from the client as below: conditions: condition1, condition2, condition3, condition4 logical operators: lo1, lo2, lo3 (Possible values: "and" "or") Eg. if condition1 lo1 condition2 lo3 condition4: # Do something I can think of eval/exec but not sure how safe they are! Any better approach or alternative? Appreciate your responses :) PS: Client-side: Flex, Server-side: Python, over internet Thanks

  Read the article

• Can I write this JQuery statement cleaner?

  - by Polaris878

  Hello, So I have the following: var box = $(".MyCheckBox"); if (box[0].checked) { // Do something } else { // Do something else } Is there a better way of doing this using filters or something? I know I can go: $(".MyCheckBox") .filter(function(index) { return this.checked; }) .each(function() { // do something }); But I need to do something in the else statement... easier way of doing this? Thanks!

  Read the article

• PreparedStatement.setString() method without quotes

  - by Slavko

  I'm trying to use a PreparedStatement with code similar to this: SELECT * FROM ? WHERE name = ? Obviously, what happens when I use setString() to set the table and name field is this: SELECT * FROM 'my_table' WHERE name = 'whatever' and the query doesn't work. Is there a way to set the String without quotes so the line looks like this: SELECT * FROM my_table WHERE name = 'whatever' or should I just give it up and use the regular Statement instead (the arguments come from another part of the system, neither of those is entered by a user)?

  Read the article

• Auto-complete editor for SQL statement

  - by Stan

  Is there any plugings or text editor to auto-complete SQL statement? I am using SQL Server Management Studio (ssms) 90% of time, but most of time I have to type SELECT FROM WITH(NOLOCK) WHERE blahblah. Trying to find a more efficient way. Thanks.

  Read the article

• Python: for statement behavior

  - by BandGap

  Hi all. My question concerns the output of this statement: for x in range(4), y in range(4): print x print y Results in: [0, 1, 2, 3] 2 True 2 It seems there is a comparison involved, I just can't figure out why the output is structured like this.

  Read the article

• php if statement not working in internet explorer

  - by Idealflip

  Hi everyone, ie isn't interpriting my php if statement well, any ideas? <input type="image" src="Images/submit.png" value="REGISTER" name="command" /> if($_REQUEST['command'] == 'REGISTER'){ print "test"; } else{ } It is not printing "test"

  Read the article

• Execute sql statement and get datareader - WITH flow control

  - by dotnetdev

  I have a standard method which gets some data from SQL Server. I want to refactor this so that based on the value of an enum (passed as a method parameter), a different sql statement is executed (all return datareader). I can't seem to code this in a way which is elegant and tidy. What would be a good way to do this? Thanks

  Read the article

• jquery validatie if statement

  - by Mariana Hernandez

  i have this validate function: var validator =$('#form1').validate( { ignore: "", rules: { usu_login: { required: true }, usu_email: { required: true }, usu_nombre1: { required: true }, usu_apellido1: { required: true }, usu_fecha_nac: { required: true }, usu_cedula: { required: true }, usu_telefono1: { required: true }, usu_password: { required: function() { return focusout == true; } }, usu_password2: { required: function() { return focusout == true; } }, usu_password3: { required: function() { return focusout == true; }, equalTo: "#usu_password2" } i need to apply the same if statement in the "equalTo" fuction so this can work as i want to, but i dont know how to do that. Dows anyone knows? Thanks

  Read the article

• Reset SQL variable inside SELECT statement

  - by Jason McCreary

  I am trying to number some rows on a bridge table with a single UPDATE/SELECT statement using a counter variable @row. For example: UPDATE teamrank JOIN (SELECT @row := @row + 1 AS position, name FROM members) USING(teamID, memberID) SET rank = position Is something like this possible or do I need to create a cursor? If it helps, I am using MySQL 5.

  Read the article

• if statement on UIButton within didSelectRowAtIndexPath

  - by richard Stephenson

  hi guys, i have a UITableView , within each cell i have 2 custom buttons, what i want to do is withing the didSelectRowAtIndexPath method i want to do an if statement on which button was touched so i would effectively be splitting a cell in 2 but i have no idea how i could wright the if statements. any help would be greatly welcomed Thanks

  Read the article

• Nhibernate generate plain sql query instead of execution statement

  - by Wei Ma

  Using SQL profiler, I was able to find the query generated from Nhibernate was executed in the EXEC sp_executesql N'select ...' fashion. I am wondering if there is any way to force Nhibernate to generate the plain Select ... statement instead. The reason I want this is because apparently SQL Server generated different execution plans for them, and in my scenario, the plain "select ..." runs MUCH faster.

  Read the article

• I want to do a sql update loop statement, by using the do--while in php

  - by Jean

  Hello, I want to loop the update statement, but it only loops once. Here is the code I am using: do { mysql_select_db($database_ll, $ll); $query_query= "update table set ex='$71[1]' where field='val'"; $query = mysql_query($query_query, $ll) or die(mysql_error()); $row_domain_all = mysql_fetch_assoc($query); } while ($row_query = mysql_fetch_assoc($query)); Thanks Jean

  Read the article

• "Parameter xxx has no default value" error when using Order by in SQL statement

  - by Tofig Hasanov

  I am trying to run the following SQL statement: "SELECT *, (IIF([Field]=TRUE,'StringValue1','StringValue2') AS [NewField] FROM [Table1] ORDER BY [NewField] ASC" But this gives me an error "Parameter NewField has no default value". How can I solve it? I am using Microsoft Access (MDB) database using Jet Engine from Delphi 7. Thank you!

  Read the article

• Convert this SQL statement to LINQ-to-SQL

  - by goforebroke

  I have struggled converting this SQL statement to LINQ to SQL VB.Net 9.0. I have used Linqer but no success. Any help would be appreciated select t.TeeId, t.DescriptionId, t.[Description], t.Rating, t.Slope, case when d.TotalHoles <> h.TotalHoles then 0 else 1 end [Status] from dbo.CourseDescription d inner join dbo.CourseTees t on t.DescriptionId = d.DescriptionId inner join (select TeeId, count(*) as TotalHoles from dbo.CourseHoles group by TeeId) h on h.TeeId = t.TeeId where d.CourseId = 1

  Read the article

• Spring Security Taglibs control statement

  - by Blake

  Is there a way to implement control statement with Spring Security taglibs? Currently we can only check if a user has a role... <security:authorize access="hasRole('ROLE_ADMIN')"> // display something </security:authorize> How about else?

  Read the article

• continue statement in pl/SQl?

  - by i2ijeya

  I am Using Oracle 9i and I want to use continue statement or its equivalent in PL/SQL. So is there any keyword called "continue" in oracle 9i. If not, please let me know the solution for this.

  Read the article

• C# empty statement

  - by dotnetdev

  In C#, I can write something like: using (new MyDisposableClass().MethodA()); The semicolon causes a compiler warning to be shown which states possible mistaken empty statement. I haven't run the above code but won't the method still be called? What uses is there of this type of coding convention? I saw another thread on here about this but I ask in case there areny differences now/therefore different replies. Thanks

  Read the article

• meaning of import statement in java file

  - by Rozer

  Can any one clear me exactly what happend when we do import statement in java files. does it inscrease the size of file if we add more and more java classes. why we dont use classloader for the same and what are the restrictin for importing.

  Read the article

• Multiple bindings expressions in one statement

  - by Abhijeet Patel

  Does WPF support multiple binding expressions in one statement? Something along the lines of the following: <TextBlock Text="{Binding Path=OrderID} shipped on {Binding Path=OrderDate}"/> I'm guessing that it does but I think I just don't have the correct syntax.

  Read the article

• have mysql select statement return fully qualified column names like table.field

  - by handsomeGun

  is there a way to have a mysql select statement return fully qualified column names like "table.field" without using AS for every single field? like so: SELECT * FROM table1 LEFT JOIN table2 on table1.f_ID = table2.ID and the result would be: "table1.ID", "table1.name", "table2.ID", "table2.name", ...

  Read the article

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