RE: SQL Triggers

I took the liberty of rewriting your trigger for you. Just a hint, when posting a question like this, include the table create statements if you can. It makes writing the answer code easier (and in most cases correct). Remember that in triggers you have the inserted and the deleted tables. You can

RE: SQL Triggers

WHOA THERE! The biggest misconception that people have with the @@identity global variable is that it will give you that last identity inserted for a particular table. It actually gives you the last identity inserted for ANY identity column in the database. In a high impact environment this could

RE: query of query - order by columns not dropped - bug?

I don't get it? Why wouldn't you just do: select firstname,lastname,middlename from rsname order by lastname, firstname, middlename I don't get what the sort_ columns are -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Sunday, January 09, 2005 5:21 PM To:

RE: Blocking Comment Spammers

I believe the correct term is morally challenged. :) -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Sunday, January 09, 2005 4:07 PM To: CF-Talk Subject: RE: Blocking Comment Spammers > -Original Message- > From: Stan Winchester [mailto:[EMAIL PROTECTED] > Sen

RE: Blocking Comment Spammers

Just a thought. But how would someone who is blind be able to get the code from an image? Being a webmaster for a government webpage, we have to make sure that we are section 508 complaint. I just don't see how you can include something like this that a text reader would be able to read and still h

RE: Clustering multiple CFMX server

That's just it. The steps that I followed are outlined on this page: http://www.talkingtree.com/blog/index.cfm?mode=entry&entry=25A98D33-45A6-284 4-7E780B5AEBD8C085 Please do me that favor of looking over the instructions on that webpage and tell me if it is different from what you did. I really

RE: cfqueryparam and Unique Identifiers

Actually you are suppose to be using CF_SQL_IDSTAMP. -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 9:59 PM To: CF-Talk Subject: RE: cfqueryparam and Unique Identifiers VARCHAR Michael T. Tangorre > -Original Message- >

Clustering multiple CFMX server

I’ve been stuck on this for 2 days now and I can’t seem to figure this out. I really need someone’s help out there. Here is the scenario. I am following the directions from: HYPERLINK "http://www.talkingtree.com/blog/index.cfm?mode=entry&entry=25A98D33-45A6-28 44-7E780B5AEBD8C085"http://www.talkin