Hey all.

GermReturns · Post by **GermReturns** » Tue Jun 16, 2009 3:01 pm

How you all been? Where do you guys play mtm2 now? RGO seems empty, and it's gone off WGC!

Slayer · Post by **Slayer** » Tue Jun 16, 2009 4:44 pm

no one tell him where we are.

TlathamXmahtalT · Post by **TlathamXmahtalT** » Tue Jun 16, 2009 5:52 pm

Slayer · Post by **Slayer** » Tue Jun 16, 2009 5:55 pm

Nooooo the hacker knows where to find us.

ShadowPrincess · Post by **ShadowPrincess** » Mon Jun 22, 2009 6:02 am

Long time no see.
How you going Germ?

GermReturns · Post by **GermReturns** » Fri Jul 03, 2009 8:34 pm

Slayer, I thought you'd grow up by now, but seems your still the same dumbass I met a couple years ago. If you don't have anything nice to say, don't say anything at all.

Slayer · Post by **Slayer** » Fri Jul 03, 2009 8:40 pm

Heh, Don't I nearly double your age? Both mentally and physically?

Anyways, hate is timeless, you both *beep* me off and betrayed me, I am well within my right to hate you.

GermReturns · Post by **GermReturns** » Fri Jul 03, 2009 8:47 pm

I betrayed you? Go ahead and hate over the internet, you think your smarter and wiser, but your not, I been looking at your programming and their all basic programs, you haven't improved a single bit. Keep thinking I betrayed you though. When your smarter than me and can code better than me then I'll respect you, as for now, your still a joke.

By the way, say I can't code? You can visit me at my site: http://hackhound.org ... && now it isn't a hacking site, it's a programming and malware analysis site. My nick is carb0n there. ;) Send me a message there if you need help with your simple vb6 apps ;)

Slayer · Post by **Slayer** » Fri Jul 03, 2009 9:07 pm

I haven't coded any of my personal apps in ages

. Been working in the banking industry now for 2 years.

Also I am not entirely sure what my ability to code as to do with my intelligence. Meh. So what do you do for a living then? Last I saw you, you were bent on ruining MTM2 for everyone, how have you changed then?

And well actually if u wanna help, perhaps you can help with this.

My problem is simple. The first character of a piece of data in a column may be invalid. I need a script to fix it. Preferably not using a stored procedure.

My first idea was this
Update Service10
Set LN_SmString2 = ('M' + RIGHT((Select LN_SmString2 From Service10),Len(Select LN_SmString2 From Service10) - 1)))
Where LEFT(LN_SmString2,1) <> 'M' or LEFT(LN_SmString2,1) <> 'S' or LEFT(LN_SmString2,1) <> 'D'

I've bolded the specific problem, how do I tell it which row to grab the data, the select and the update need to be looking at the same row for this to work.

If there is an easy solution to this, I'd like to know.

Otherwise, my solution would be using a variable and a curser. That should work fine EXCEPT I only know how to use variables and cursors in stored procs. I again, don't want a stored proc, just a single use script. Online help is not very helpful for some reason with this issue, so help would be appreciated.

The jyst of this script is this.

If the first characters is not M, S, or D, then make it M. All characters after that must remain the same. It is a 30 character CHAR and each character represents something to the system.

Post by **Phineus** » Sat Jul 04, 2009 2:24 am

GermReturns wrote: Send me a message there if you need help with your simple vb6 apps

It may take me a while to get over there. Meantime, I can use all the help I can get with my simple vb6 apps. Drop by here and maybe you can impart some wisdom ;-)

http://mtm2.com/chat/

Slayer · Post by **Slayer** » Sat Jul 04, 2009 11:08 am

now i just gotta wonder what yoru having trouble with in VB6

. Cause internet is awesome for help, there is a crap lot of help out there, for almost everything. DevX has a crazy amount of prewritten code for you too, to just drop in place and use.

I wanna learn assembly

Slayer · Post by **Slayer** » Sat Jul 04, 2009 11:15 am

Ah dang, turns out my SQL was out in left field, guy a tech republic fixed it up for me

Code: Select all

Update Service10
Set LN_SmString2 = 'M' + SubString(LN_SmString2,2)
Where LN_SmString2 Not Like '[MSD]%'

Post by **Phineus** » Sun Jul 05, 2009 5:48 am

Code: Select all

if (SubString(LN_SmString2,2) == 'valid') {
  Update Service10
  Set LN_SmString2 = 'M' + SubString(LN_SmString2,2)
  Where LN_SmString2 Not Like '[MSD]%'
}
else {
  print qq(scorn and abuse);
  Don't bother ;
  aka exit ;
}

Slayer · Post by **Slayer** » Sun Jul 05, 2009 9:51 am

lol I don't think that would actually work, considering there are no braces or "==" in T-SQL.

Post by **Phineus** » Sun Jul 05, 2009 8:49 pm

It's z-notation ; it's meta code.

JerOutlaw · Post by **JerOutlaw** » Mon Jul 06, 2009 12:47 pm

i think my brain just seized

nome66 · Post by **nome66** » Fri Jul 10, 2009 11:33 am

woah, same here.

Nascarfan15 · Post by **Nascarfan15** » Fri Jul 10, 2009 12:26 pm

JerOutlaw wrote:i think my brain just seized

Same here!

Blown_Steel · Post by **Blown_Steel** » Thu Jul 23, 2009 2:50 pm

Ditto