Does anyone know what product you need to qualify for the Studio upgrade? <br><br><br>Mark Smeets/stranger0/ICQ #1062196 My new email: [EMAIL PROTECTED] "Mr. West, not every situation requires your patented approach of shoot first, shoot later, shoot some more and then when everybody's dead try to ask a question or two" - Wild Wild West A Stranger's Domain http://24.113.34.178/stranger Official Splitting Adam Homepage http://www.splittingadam.com/ >From: [EMAIL PROTECTED] (CF-Talk) >Reply-To: <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Subject: CF-Talk-list V1 #64 >Date: Sun, 29 Jul 2001 06:25:38 -0400 >MIME-Version: 1.0 >Received: from [207.31.122.190] by hotmail.com (3.2) with ESMTP id >MHotMailBD2D2F27007F40043117CF1F7ABE0E560; Sun, 29 Jul 2001 03:23:43 -0700 >From [EMAIL PROTECTED] Sun, 29 Jul 2001 03:24:27 -0700 >Precedence: bulk >Message-ID: <[EMAIL PROTECTED]> > >CF-Talk-list Sun, 29 Jul 2001 Volume 1 : Number >64 > >In this issue: > > Re: DateAdd Strangeness? (Or is it me?) --it's you!! > Re: Vote on ColdFusion Enhancements! > Calling Stored Proc.... > Re: How do these things happen? > RE: Vote on ColdFusion Enhancements! > SQL Datatype Datetime > Re: SQL Datatype Datetime > SQL 7.0 linking Tables to Access > Cancel: SQL 7.0 linking Tables to Access > > >---------------------------------------------------------------------- > >Date: Sat, 28 Jul 2001 20:46:16 -0600 >From: "Jim McAtee" <[EMAIL PROTECTED]> >Subject: Re: DateAdd Strangeness? (Or is it me?) --it's you!! >Message-ID: <008b01c117d8$a3b1fc50$352fa8ce@Jim> > >----- Original Message ----- >From: "Lee Fuller" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Saturday, July 28, 2001 12:46 PM >Subject: RE: DateAdd Strangeness? (Or is it me?) --it's you!! > > > > Yes.. But... (isn't there always one?? ;) > > > > You're correct.. Except that a "Quarter", when used in calendar terms, > > means Jan-Mar, Apr-Jun, Jul-Sep, and Oct-Dec. So by using the first > > test, with "now()" as the date it answers correctly. However, when > > using a random date, it does not... It simply adds 3 months. > > > > Maybe it's just me assuming that "quarter" is for "calendar quarter". > > But when someone says "Q1 2001".. We all assume they mean Jan-Mar of > > 2001. And if you add 1 to the Q1, you get Q2, which is Apr-Jun of 2001. > > > > Oddly enough.. If you use "Quarter(now())" it returns the number based > > on calendar quarters. So if you're trying to modify a date to get the > > next "calendar" quarter.. It would be simple to use the dateadd to add a > > quarter and voila! But.. Sadly it doesn't work that way. :( > > >Maybe your confusion lies within the fact that DateAdd() works with dates, >not quarters. DateAdd("q", n, date) quite simply adds multiples of three >months to the date argument. As such, it's somewhat redundant. It would >seem more than a little confusing if adding one "quarter" to June 26, 2001 >returned a date of July 1, 2001. > >If you want to add quarters to a date, and return the beginning month of >the >resulting quarter, you could use the following: > ><cfset m = Quarter(DateAdd("q", 1, somedate)) * 3 - 2> > >Jim > > > >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >------------------------------ > >Date: Sat, 28 Jul 2001 22:54:40 -0400 >From: "Bill Davidson" <[EMAIL PROTECTED]> >Subject: Re: Vote on ColdFusion Enhancements! >Message-ID: <002c01c117d9$cff3fba0$[EMAIL PROTECTED]> > >Yeah, I am well aware of it, thanks. There's just a few things I think >could >benefit from the voting system. I really appreciate the MM people putting >this up for CF. It shows that at least they appear to care, which makes me >happy! Beta testing and feature requests should not go together. The last >thing you need when you are trying to fix something is a new feature to >come >along and break something else. > >However I'd be more than happy to dive into formal beta testing of the new >Studio.... I am where I am today from working with software companies to >develop their products - literally. I worked so closely with a company >that >I beta test with that I ended up in their office space for almost 2 years, >which decided where brainbox would be born. > >Best regards. >-Bill >www.brainbox.tv >----- Original Message ----- >From: "Peter Tilbrook" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Saturday, July 28, 2001 7:46 PM >Subject: RE: Vote on ColdFusion Enhancements! > > > > Bill, Macromedia are working on the new version (5.0) right now. > > > > Check out "http://beta.allaire.com";. > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]]On Behalf Of Bill > > Davidson > > Sent: Sunday, 29 July 2001 1:47 AM > > To: CF-Talk > > Subject: Re: Vote on ColdFusion Enhancements! > > > > > > Terry - can you add a category for Studio (or tell me where it is)? I >know > > it's a different product, but there are some issues there, I would love >to > > see addressed. > > > > Regards. > > -Bill > > www.brainbox.tv > > > > > > >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >------------------------------ > >Date: Sat, 28 Jul 2001 23:28:30 -0400 >From: "BT" <[EMAIL PROTECTED]> >Subject: Calling Stored Proc.... >Message-ID: <[EMAIL PROTECTED]> > >I'm getting SQL/ODBC Error when incorporating the following CF code and >Stored Procedure... Anyone had this? >There are not triggers as well... > >Error: >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >------------------------------ > >Date: Sun, 29 Jul 2001 00:53:35 -0400 >From: Jim Finucane <[EMAIL PROTECTED]> >Subject: Re: How do these things happen? >Message-ID: <[EMAIL PROTECTED]> > >Bud, > >I had a similar problem with more that one site in the past. I finally >figured it out (quite by accident) >when I was testing some error handling on a form submission. I entered >some garbage input and submitted the >form on the resulting test page I was outputting the list >Form.fieldnames on the top of the page and I discovered >that all the fields did not show up. I looked back at my garbage input >and saw that the submission was cut off at >an & character that I entered in one of the text fields. I tested this >several times and found that whatever field I >entered an & character would cut of the rest of the form fields as if >they had not been submitted at all. >I do not know if this is a CF specific problem in how it deals with form >posts ( is the & some kind of escape char?) >or something else (IIS HTTP). I meant to look into this further but >never got around to doing it. > >Run a few tests putting a & into different input fields and see if you >can duplicate the error. >Let me know if this was the problem. > > >Regards, > >Jim > > >----- Original Message ----- >From: "Bud" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Saturday, July 28, 2001 9:02 AM >Subject: How do these things happen? > > > > Man. I come across stuff like this and it simply makes me dizzy > > trying to figure out what is wrong. > > > > While looking at my errors log, I find a bunch of these: > > > > The QUERY attribute of the tag does not specify the name of an > > available query<p>The error occurred while processing an element with > > a general identifier of (CFOUTPUT), occupying document position > > (50:6) to (50:43) in the template file > > F:\USERS\LATIN-LOVECONNECTION\HTDOCS\SEARCH\DETAILS.CFM. > > > > OK, so at that document position is a cfoutput tag with a query of > > itemsLong. Above that are 2 queries called itemsLong, the one that > > runs depending upon the category ID that's passed. The referer that's > > specified in the rror is correct, so they're not just going there > > without clicking the form button, which will pass the hidden > > category_id field. Whenever I go to the page, itemsLong is run. > > > > Stuff like this makes me nuts. There is absolutely no rhyme nor > > reason for it other than CF deciding "well, I just won't run the > > block of code with the query in it". > > -- > > > > Bud Schneehagen - Tropical Web Creations > > > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > > ColdFusion Solutions / eCommerce Development > > [EMAIL PROTECTED] > > http://www.twcreations.com/ > > 954.721.3452 > > > > >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >------------------------------ > >Date: Sun, 29 Jul 2001 15:02:21 +1000 >From: "Peter Tilbrook" <[EMAIL PROTECTED]> >Subject: RE: Vote on ColdFusion Enhancements! >Message-ID: <[EMAIL PROTECTED]> > >Bill... Agreed! > >I just finished downloading the latest build of Studio 5 (beta 2) on a >33.6K >connection. I'm that keen! > >About to start using it to see if the promised improvements are there. > >Some comments in the forums appear to want something totally "new" for >Studio. I disagree. It has a fine pedigree started with Nick Bradbury's >HomeSite product. Most long-term CF developers started with Studio 3.1 at >least. 4.01 was good. 4.5 faltered with some major bugs (zero byte file >saves my major problem. 4.5.2 appears/appeared to be rock solid although >the >zero byte file save occurred occasionally. > >If it isn't broken don't fix it. HomeSite/Studio is a great project based >code/HTML editor. >Version 5.0 of both appear to be on the right track. > > > >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >------------------------------ > >Date: Sun, 29 Jul 2001 15:38:06 +1000 >From: "Andrew Scott" <[EMAIL PROTECTED]> >Subject: SQL Datatype Datetime >Message-ID: ><!~[EMAIL PROTECTED]> > >Is it possible to have a null Datetime field although I have allowed >nulls, it still complains. Or would it be better to have a very distant >past date... > > > > >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >------------------------------ > >Date: Sat, 28 Jul 2001 23:48:15 -0600 >From: "Jim McAtee" <[EMAIL PROTECTED]> >Subject: Re: SQL Datatype Datetime >Message-ID: <00e501c117f2$0fb94890$352fa8ce@Jim> > >----- Original Message ----- >From: "Andrew Scott" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Saturday, July 28, 2001 11:38 PM >Subject: SQL Datatype Datetime > > > > > > Is it possible to have a null Datetime field although I have allowed > > nulls, it still complains. Or would it be better to have a very distant > > past date... > > >Have you tried inserting the value NULL, or are you using a zero length >string? > >Jim > > >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >------------------------------ > >Date: Sun, 29 Jul 2001 07:56:35 +0100 >From: "Jerry Staple" <[EMAIL PROTECTED]> >Subject: SQL 7.0 linking Tables to Access >Message-ID: <[EMAIL PROTECTED]> > >Hi > Can any one inform me of a way to link from a SQL Db to an >access db table?The access table in future will be transfered to SQL >7,but not yet. I know about the import etc but i would like the SQL >database to be linked to a live Access Table. > > >Any Ideas?????? > >Jerry Staple > >Web Applications Developer >BizNet Solutions >133 - 137 Lisburn Rd >Belfast >BT9 7AG > >Tel: +44 (0)28 9022 3224 >Fax: +44 (0)28 9022 3223 >www.biznet-solutions.com >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >------------------------------ > >Date: Sun, 29 Jul 2001 08:21:43 +0100 >From: "Jerry Staple" <[EMAIL PROTECTED]> >Subject: Cancel: SQL 7.0 linking Tables to Access >Message-ID: <[EMAIL PROTECTED]> > >Sorted! > >-----Original Message----- >From: Jerry Staple >Sent: 29 July 2001 07:57 >To: CF-Talk >Subject: SQL 7.0 linking Tables to Access > > >Hi > Can any one inform me of a way to link from a SQL Db to an >access db table?The access table in future will be transfered to SQL >7,but not yet. I know about the import etc but i would like the SQL >database to be linked to a live Access Table. > > >Any Ideas?????? > >Jerry Staple > >Web Applications Developer >BizNet Solutions >133 - 137 Lisburn Rd >Belfast >BT9 7AG > >Tel: +44 (0)28 9022 3224 >Fax: +44 (0)28 9022 3223 >www.biznet-solutions.com >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >------------------------------ > >End of CF-Talk-list V1 #64 >************************** >FAQ: http://www.thenetprofits.co.uk/coldfusion/faq >Archives: http://www.mail-archive.com/[email protected]/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
