Search Result

Kezn · Apr 11 '12, 07:29 AM

Hi ... i tryin to update my SQL using this method but it didn't update...Anyone have a better way to do this ?

------------------------------------------------------------

Code:

Case "OUT"

                Dim connectionstring As String = "Server=PENW3GFSB2S\SQLEXPRESS;Database=People;Trusted_Connection = yes"
                Dim query As String = "Update [Names] Set [TimeOut]=

...

wisni1rr · Jan 25 '12, 05:49 PM

I am building a calculator program to help learn PHP. In the following example, I wrote a function to calculate exponents. When I run this function, It always takes the first case.

Code:

function power_of($base, $exponent)
{
	$result = $base;
	switch ($exponent)
	{
		case $exponent = 0:
			$result = 1;
			break;
		case  $exponent > 1:
			while ($exponent > 1)

...

eli meli · Dec 27 '10, 05:16 PM

Hi.

I am looking to query our of the db2 internal system tables the unique identifier of a SQL statement as well as the unique identifier of the execution plan. I need to see those for an active query.

In Oracle - each sql statement has a hash_value which is a unique identifier (column hash_value in v$sql)
in addition, each execution plan has a unique identifier called plan_hash_value (column plan_hash_value...

Charles Sherman · Dec 14 '10, 07:20 PM

Code:

import java.util.Random;
import TerminalIO.KeyboardReader;
 public class random
 {
  public static void main(String args[])
  {
  int guess;
  int answer;
  Random generator = new Random();
  KeyboardReader reader = new KeyboardReader(); 
  System.out.print("Enter Guess");
  guess = reader.readInt();
  answer = generator.nextInt(99+1);
  while(guess!=answer){

...

NDayave · Mar 29 '10, 02:48 PM

Hi,

I have a query that is sorting people into their respective areas of the country and need to assign each postcode the correct label (Eg: 'North', 'Wales', etc.). I am trying to do this in a CASE statement at the moment but it does not like the IN() part, returning all the values with the 'N/A' label. Everything parses fine and the query runs, it just doesn't assign the correct labels.

Code:

SELECT	PH.SERIALNUMBER,
	PH.PLEDGEID,

...

seegoon · Mar 25 '10, 04:59 PM

Hi guys.

I'm trying to write some php so that, depending on the page displayed, a certain <div> will load a certain class, giving it a certain background image. I have it down in theory, but there's a problem. My current code is returning multiple results as true, leading to the user receiving source like:

Code:

<div id="wrap" class="flower-1flower-2">

In this instance, it is obviously...

RiddleMeThis · Feb 4 '10, 04:54 PM

Im trying to use 2 CASE statements together in a SELECT query without much luck.
The second CASE uses the output from the first CASE as it’s expression (well it’s supposed to).
When the 2nd CASE statement is removed it works, but when it is included i get this error:

Code:

SELECT accountNum

,balanceCalculation = CASE
	WHEN Balance > 5000 THEN Balance *2
	ELSE Balance /2
END

...

elimeli1 · Dec 16 '09, 04:27 PM

Hi all

I have a monitoring application that running outside the DB server that every 1 minutes queries the snapshot tables and logs it into an internal repository of it. for later tuning.

I have a problem with getting SQL statements from it that has non-english letters inside.

here is small sample test I did from control center to simulate the problem :

select stmt_text from
table(snapshot_ statement('DBNA ME',-1))...

Search Result

VB Failed To Update SQL Using Update ... SET....WHERE

PHP coding

statement and plan "hash value"

How to fix Unreachable Statements?

SELECT CASE WHEN IN() statement

Newb problem: "if" statement returning multiple results as true

A CASE statement using another CASE statement as it's expression

snapshot_statement stmt_text unicode problem