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" <[email protected]> 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:202597 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
