User Profile

Collapse

Profile Sidebar

Collapse
Jeffy
Jeffy
Last Activity: Nov 11 '08, 01:58 PM
Joined: Oct 10 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Jeffy
    started a topic SQL IF...ELSE syntax
    in SQL Server

    SQL IF...ELSE syntax

    I'm trying to create an if/else case in a stored procedure where if te record is not found, it returns blank values, and if it is found I get the real values. But when I try to execute the SP update I get column does not exist for the else clause (all columns starting with shift through sequence)

    I'm sure this is a simple problem, and I apologize in advance.

    Code:
    USE [ADC]
GO
/****** Object:  StoredProcedure
    ...
    See more | Go to post
    • Jeffy
      replied to limiting combobox
      in .NET
      Thanks guys! I'll see what this does for me!
      See more | Go to post

        Leave a comment:

      • Jeffy
        started a topic limiting combobox
        in .NET

        limiting combobox

        Newbie question:

        I have a bunch of comboboxes, and I only want the user to be able to accept a value in the list. I want them to be able to type in the field and have it auto position to the corresponding value in the list which works nicely, but how do I validate that the entry is one of the list items while they are typing?

        For instance:
        if the values are [Brian, Frank, Jeff, Martin] and they type JEFF...
        See more | Go to post
        No activity results to display
        Show More
        Working...