funniest thing from my perspective is that once I found it, the datatype change had already been made.
Of course I was gone to Maine for a week, so it's not like it's a problem. Tim Nick McClure wrote: > Yeah, while I don't mind helping people out. If things like this keep going, > then it will only get worse. > > I always ask for complete information before beginning. > > >>-----Original Message----- >>From: Tony Weeg [mailto:[EMAIL PROTECTED] >>Sent: Monday, August 08, 2005 11:05 AM >>To: CF-Community >>Subject: Re: SQL Server Question >> >>lack of full request is worse than long time for response. >> >>make them wait one time, and hopefully next time you get >>full req's >> >>tw >> >>On 8/8/05, Loathe <[EMAIL PROTECTED]> wrote: >> >>>Different work schedules mean I wouldn't get a response for quite >> >>sometime. >> >>>Nick McClure wrote: >>> >>>>Yeah, of course, I'd just send 'em back an email saying, hey, what >> >>table? >> >>>> >>>>>-----Original Message----- >>>>>From: Loathe [mailto:[EMAIL PROTECTED] >>>>>Sent: Monday, August 08, 2005 10:43 AM >>>>>To: CF-Community >>>>>Subject: Re: SQL Server Question >>>>> >>>>>Cool, >>>>> >>>>>I also figured out I could get the table name by doing a join to the >>>>>sysobjects table on ID. >>>>> >>>>>Thanks man. >>>>> >>>>>Jochem van Dieten wrote: >>>>> >>>>> >>>>>>Loathe wrote: >>>>>> >>>>>> >>>>>> >>>>>>>So if someone sent you a request to change a datatype on a field, >> >>but >> >>>>>>>they didn't tell you what table the column was in, how would you go >>>>>>>about finding out? >>>>>> >>>>>> >>>>>>SELECT * >>>>> >>>>>>FROM INFORMATION_SCHEMA.COLUMNS >>>>> >>>>>>WHERE column_name LIKE '%research%' >>>>>> >>>>>>Jochem >>>>>> >>>>>> >>>>> >>>>> >>>> >>> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:168363 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
