Search found 5 matches

by EVoskamp
Sun Jan 02, 2005 8:07 am
Forum: General EM Discussion
Topic: MSSQL Help Wanted
Replies: 10
Views: 11451

Re: MSSQL Help Wanted

ADD TABLE will not work: the UNSIGNED keyword on the [int] datatype is not valid: no such beast. Simply leave off the UNSIGNED keyword ALTER TABLE on column SSN is invalid: you cannot have a default on an IDENTITY column Note that several have the GO statement on the same line as the CREATE TABLE o...
by EVoskamp
Sun Jan 02, 2005 7:47 am
Forum: General EM Discussion
Topic: MSSQL Help Wanted
Replies: 10
Views: 11451

Re: MSSQL Help Wanted

Hi, I have a lot of database development experience and develop actively on both MSSQL and MySQL, the latter on FreeBSD 4.8. Currently I'm running MSSQL 2000 SP3a and MySQL 4.0.18. I'll be happy to test, answers questions and the like. As far as your questions go: GO is not part of MSSQL its SQL (kn...
by EVoskamp
Wed Jan 07, 2004 10:46 pm
Forum: General EM Discussion
Topic: [rejected] "Turn off password" select
Replies: 27
Views: 16331

Re: [rejected] "Turn off password" select

I see what happened: there is a closing quote, part of which got eaten.
Odd, I'll have to try and quote that post again, see what happened.
by EVoskamp
Wed Jan 07, 2004 7:06 am
Forum: General EM Discussion
Topic: [rejected] "Turn off password" select
Replies: 27
Views: 16331

Re: [rejected] "Turn off password" select

What was the point of that post? This isn't a test forum, you know.... :| Earlier in this thread, LLKwerv posted a little mod to implement the rejected feature. It did not work for me, so I thought I'd share what I'd had to do to fix it, on the thread where I found that mod. If this is not appropri...
by EVoskamp
Wed Jan 07, 2004 1:49 am
Forum: General EM Discussion
Topic: [rejected] "Turn off password" select
Replies: 27
Views: 16331

Re: "Turn off password" select

Here's the mod, very simple: http://www.zorfox.net/easymod_pass_remove.txt " target="_blank In 0.0.11a of EasyMOD, this does not work because of the md5 encryption: a blank password is not an empty string. Use this instead (the mod, with md5() encryption of the empty string to compare against): ###...