that really sucks. Hang in there though, looks like you see the light. >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:202561 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
