I've got all of my accounts and two mortgages through them and they've never done me wrong.
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: Chesty Puller [mailto:[EMAIL PROTECTED] Sent: Monday, April 03, 2006 2:44 PM To: CF-Community Subject: Re: Tim's House closing was (RE: SQL Question, Switch Case ) Yep... I'm buying a new car and I'm going to try them (I've been a member since 1990). They have fantastic rates. Also, they are the largest credit union in the world. - Matt ----- Original Message ----- From: "Scott Stewart" <[EMAIL PROTECTED]> To: "CF-Community" <cf-community@houseoffusion.com> Sent: Monday, April 03, 2006 2:06 PM 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:202598 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=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
