Have you noticed that when you write an ActiveX DLL, passing values ByRef is faster than ByVal, but when you write an ActiveX EXE the opposite is true?

Just as an aside, every year in Britain we have the New Years honors list where persons who have made a great contribution to British life get enobled with awards...

Frank,

The $HTTP_REFERER, $HTTP_POST_VARS and $HTTP_GET_VARS stuff is dictated by the PHP.INI file. I'll find out which setting it is that determines thebehaviour and pass it on when I return...

I appreciate your problems with a couple of hundred databases, but the thought of trusting the backup of that lot to one maintenance plan gives me the screaming heebie jeebies.

One...

My brother in-law described PHP to me as "imagine if all the frustrated ASP programmers got together and said 'I wish ASP did this', then they got drunk and added...

I suppose the aim is to have a quality mark against the posts on the forum.

The stars do not affect the validity of the answers given.

At present you have a...

You could have coded your SP as follows

CREATE PROCEDURE usp_check_login

  @username varchar(20),

  @password varchar(20) AS

  SET NOCOUNT ON

  SELECT user_id,

    user_active as login_active,

    user_loginattempts as login_attempts,

    user_type

  FROM tbl_user

  WHERE user_username = @usernameAND user_password = @password

  RETURN @@ROWCOUNT

GO

That...

TRUNCATE also fails if you use foreign key constraints, regardless of whether they are violated.

I fully agree that people should not be allowed to create datbases willy-nilly.

If developers go creating...

Firstly, I've come across SQL6.5 a couple of times recently because it was a huge undocumented, mission critical application written in C++ where the source code had been lost. ...

I tend to use short meaningful abbreviations, which is fine for databases with a few tables, but if you get an app with thousands of tables then your abbreviations cna...

quote:

---

Dude should have normalized his database...

---

Probably bought the list from a...

quote:

---

For the second best practice, i would like to add

Give proper alignments or Indent while writing the joins to make...

Perhaps you should write an article and submit it to the site.

Enlighten us all and earn US$25 in the process.

========================

He was not wholly unware of the potential lack of insignificance.

Yep, Douglas Adams.

The robot was Marvin the paranoid android but I'm thinking of a character in a later book in the series but can't think of his name.

There...

Sorry, forgot the language barrier.

They say that eskimos have thousands of names for snow, the British have millions that can be used as insults.

Bodily parts can be used as insults...