Re: Combining in and like - C# Discussion Boards

6-Jul-06 10:49

What will they think of next?! OMG | :OMG:

:josh:
My WPF Blog[^]

Combining in and like

Drew McGhie6-Jul-06 8:59

Drew McGhie

6-Jul-06 8:59

I'm still relatively new to SQL and I was wondering whether there was an easier way to do things.
I need to limit a query based on if a field is like one of three values. I can use "WHERE field in ('list one', 'list two', 'list three')", and I can to "WHERE field like 'list one' or field like 'list two' or field like 'list three'". Is there a way, however, to combine 'in' and 'like' to do something like "WHERE field in like ('list one', 'list two', 'list three') ?

Josh Smith6-Jul-06 9:01

6-Jul-06 9:01

Drew McGhie wrote:
WHERE field in like ('list one', 'list two', 'list three')

That sounds like Valley Girl SQL. Big Grin | :-D

You should post this to the SQL forum, you'll probably get more and faster responses than in the C# forum.

:josh:
My WPF Blog[^]

Dustin Metzgar6-Jul-06 9:26

Dustin Metzgar

6-Jul-06 9:26

Josh Smith wrote:
Valley Girl SQL

Sweet

UMM LIKE CREATE PROCEDURE Procedure1
ASIF
SELECT LIKE ALL OF Table1, DUH
UHH GO

Logifusion[^]

Judah Gabriel Himango6-Jul-06 9:30

Judah Gabriel Himango

6-Jul-06 9:30

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Messianic Instrumentals (with audio)
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Josh Smith6-Jul-06 9:32

6-Jul-06 9:32

You are like so totally a like hard core developer, or something. Cool | :cool:

:josh:
My WPF Blog[^]

User 66586-Jul-06 9:59

User 6658

6-Jul-06 9:59

awesome

modified 12-Sep-18 21:01pm.

Alexander Wiseman6-Jul-06 10:36

Alexander Wiseman

6-Jul-06 10:36

This gets the best post of the day award hands down!

I can just see the Valley Girl SQL compiler error messages now:

line 1: "CREATE PROCEDURE"
compile error, expected token UMM, LIKE, or UHH

Sincerely,
Alexander Wiseman

Dustin Metzgar6-Jul-06 11:18

Dustin Metzgar

6-Jul-06 11:18

Alexander Wiseman wrote:
compile error, expected token UMM, LIKE, or UHH

Hilarious!

Josh, I think you should patent the name.

Logifusion[^]

Vikram A Punathambekar6-Jul-06 20:50

Vikram A Punathambekar

6-Jul-06 20:50

I think your post should share the award. Laugh | :laugh:

Cheers,
Vikram.

"I am not Jesus and will never be. The fact is I was a piece of cr*p till I found Him." - Paul Selormey.

Blake Miller7-Jul-06 3:47

Blake Miller

7-Jul-06 3:47

line 1: "CREATE PROCEDURE"
Ya know, there was this like compile error, and I kinda expected a token umm, like, UMM, LIKE, or UHH

I've seen better runs in my shorts! - Patches O'Houlihan

DontSailBackwards7-Jul-06 21:22

DontSailBackwards

7-Jul-06 21:22

How about ...

Umm SELECT LIKE STUFF
FROM YOU KNOW LIKE DUH
WHERE THINGS ARE LIKE WHATEVER
ORDER BY DRIVETHROUGH, FRIESWITHTHAT = YES

ToddHileHoffer6-Jul-06 9:09

ToddHileHoffer

6-Jul-06 9:09

No you can't do that. You would have to say where (field like '%list1%' or field like '%sdf%') but that would be inefficient anyway.

how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06

Passing a Class as a method parameter?

NRavep9-Jul-06 20:55

NRavep

9-Jul-06 20:55

Select Field1,Field2,Field3 From TableName Where Field1 In(Select Field4 From Table2 Where Field4 Like '%Something%')

joshp12176-Jul-06 8:40

joshp1217

6-Jul-06 8:40

I mean be an idiot for asking this question too but is there a way to pass a class as a parameter of a method i.e.

I have a repeated block of code like this:
class pTermsEditor;
pTermsEditor = new class();
pnlViews.Controls.Add(pTermsEditor);
pTermsEditor.Dock = DockStyle.Fill;

This Block of code is repeated many times but the class type may and almose always does change, so I want to control it more by putting it into a method something like this:

myMethod(class)
{
class x;
x = new class();
//blah blah blah
}
Any help or even a better solution what be greatly appreciated

Re: Passing a Class as a method parameter? [modified]

ToddHileHoffer6-Jul-06 8:51

ToddHileHoffer

6-Jul-06 8:51

You can use the object type, and it is a valid question.

for example

<br />
myMethod(object obj)<br />
{<br />
if (obj.GetType() == typeof(classA))<br />
{<br />
 ClassA objA;<br />
 objA = (ClassA)obj;<br />
return;<br />
}<br />
if (obj.GetType() == typeof(classB))<br />
{<br />
ClassB objB;<br />
 objB = (ClassB)obj;<br />
return;<br />
}<br />
<br />
}

how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06

-- modified at 14:58 Thursday 6th July, 2006

Josh Smith6-Jul-06 9:04

6-Jul-06 9:04

You can pass a Type object and then use Activator.CreateInstance to create an instance via the default (parameterless) constructor.

Or, if you're using .NET 2, you can make a generic method whose type parameter is the type that you want to create. Then just do T obj = new T(); where T is your type parameter name.

If all else fails, you can always do the magical type parameter dance and everything should work out fine. Wink | ;)

:josh:
My WPF Blog[^]

Judah Gabriel Himango6-Jul-06 9:29

Judah Gabriel Himango

6-Jul-06 9:29

That'll work, so long as you put a new() (that is, default constructor) constraint on the method:

void CreateNew<T>() where T : new()
{
   T instance = new T();
   ...
}

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Messianic Instrumentals (with audio)
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Jun Du6-Jul-06 12:10

Jun Du

6-Jul-06 12:10

That's cool. Thought it wasn't doable Blush | :O

Best,
Jun