Can't do the VA thing, too much money, or this shit would have been dealt with already.
-- Timothy Heald Analyst, Architect, Developer [EMAIL PROTECTED] W: 202-228-8372 C: 703-300-3911 -----Original Message----- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Monday, April 03, 2006 2:06 PM To: CF-Community Subject: RE: Tim's House closing was (RE: SQL Question, Switch Case ) If this one goes under, try Navy Federal Credit Union. You should be eligible under vet status. They're fast and will work with you. Glad to know that the insurance came through...... Thanks Scott Scott A. Stewart Webmaster/ Developer GlobalNet Services, Inc http://www.gnsi.com 11820 Parklawn Dr Rockville, MD 20852 Voice: (301) 770-9610 x 335 Fax: (301) 770-9611 The information contained in this message may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or any employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. -----Original Message----- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Monday, April 03, 2006 2:01 PM To: CF-Community Subject: RE: Tim's House closing was (RE: SQL Question, Switch Case ) It didn't. We lost our mortgage 2 hours before the closing. Going with a new company now. Man it's been a rough couple of weeks. The med shit isn't helping. We finally got some good news today though. BC/BS approved our medical insurance, and the new mortgage company is actually going to be cheaper. We should close by wed or thurs. -- Timothy Heald Analyst, Architect, Developer [EMAIL PROTECTED] W: 202-228-8372 C: 703-300-3911 -----Original Message----- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Monday, April 03, 2006 10:12 AM To: CF-Community Subject: Tim's House closing was (RE: SQL Question, Switch Case ) Thanks Tim, How'd the closing go? Thanks Scott Scott A. Stewart Webmaster/ Developer GlobalNet Services, Inc http://www.gnsi.com 11820 Parklawn Dr Rockville, MD 20852 Voice: (301) 770-9610 x 335 Fax: (301) 770-9611 The information contained in this message may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or any employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. -----Original Message----- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Sunday, April 02, 2006 9:10 PM To: CF-Community Subject: RE: SQL Question, Switch Case Yeah. I do something like this sometimes: <cfcquery> Select * from table Where 1 = 1 <cfcase expression="#entity_type#"> <cfswitch value="1"> and this = that </cfswitch> <cfswitch value="2"> and that = this </cfswitch> </cfcase> </cfquery> I use where 1 = 1 sp I don't have to mees around with the wheres and ands. -- Timothy Heald Analyst, Architect, Developer [EMAIL PROTECTED] W: 202-228-8372 C: 703-300-3911 -----Original Message----- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Friday, March 31, 2006 11:19 AM To: CF-Community Subject: SQL Question, Switch Case All, Can you use a switch case statement to build a dynamic where clause based on parameters passed to a stored procedure? I'm using T-SQL in SQLServer 2000 IE: Case where entity_type is X "piece of where clause" Case where enity_type is Y "piece of where clause" Thanks Scott Scott A. Stewart Webmaster/ Developer GlobalNet Services, Inc <http://www.gnsi.com> http://www.gnsi.com 11820 Parklawn Dr Rockville, MD 20852 Voice: (301) 770-9610 x 335 Fax: (301) 770-9611 The information contained in this message may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or any employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:5:202571 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54