Re: nvarchar vs varchar (was SQL 7.0 )
On Sat, 28 Jul 2001 04:24:31 +1000, Mike Kear [EMAIL PROTECTED] wrote: I'm really interested in this because I've had no end of problems when I upsize an access table and SQL7 sets the fields to nvarchar or ntext. I have to go in and manually change them to varchar and text. Yet other people say they have no problem with ntext and nvarchar. Can anyone else help pin down what's going on here?If there's a CF setting to make or a SQL7 setting to make to get rid of this issue I'm all ears! I think it has a lot to do with the version of CF that you are using. WebCentral in Aus for example are still stuck in the dark ages with CF 4.0 (not even 4.0.1) so I had problems with a client hosted there. I don't think that CF 4.5 has these problems. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Vote on ColdFusion Enhancements!
On 7/28/01, C. Hatton Humphrey penned: I guess my other wish would be to have a better validator in place. Granted, I work with Studio 4.0.1 so I may be behind the times a tad on that aspect, but the validator included with my version throws fits if I cfloop around a tr or close a form tag in the wrong place because I don't want that stupid extra space! I don't work with Studio, so I'm not sure about the cfloop, but the validator is doing the right thing by telling you about form tags in the wrong place. I hate the extra space also. But if any browser-makers ever start following the HTML specs, all your forms that you're building like that will stop working, as by all rights, any html code in a table but outside of a table cell should be ignored. That said, I do the same thing myself, *IF* I can't possibly get what I need doing it the right way. But the validator is correct in telling you about 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: how to re-enable CFREGISTRY?
On 7/27/01, Mark Warrick penned: OK I made a mistake. In the CFAdministrator, I disabled the CFREGISTRY tag. And then I discovered that once you do that, you can no longer use the CFAdministrator. Great. So, how do I get that thing turned back on now? ---mark I've always kept cfregistry disabled, in 4.01 and now in 4.51. I can use CF administrator just fine. -- 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL 7.0 linking 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 querypThe 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do these things happen?
Check your cfif or cfswitch statement that determines the query carefully...chances are there is some combination of circumstances - maybe rare - that will not run either query. D -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 28, 2001 9:02 AM To: CF-Talk 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 querypThe 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do these things happen?
Bud, I have seen this in some of my code also, where the query in question exists. It occurs only occasionally. I think that some browser versions occasionally drop or forget to pass some of the variables from one page to the next (or CFAS loses them). Mike Cady - 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 querypThe 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 - Original Message - From: Terry Ford [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 27, 2001 2:12 PM Subject: Vote on ColdFusion Enhancements! Hi cf-talk, We're deep in the middle of the design and development for the next major release of ColdFusion and are looking for some good input on ColdFusion enhancements. Below is a link to an enhancement-tracking application that we've put online temporarily. Inside you will find over 200 CF enhancement requests that we have received and logged over the past year that you may vote on or add to. You will need to create a simple account to vote. Note that this system will only be available publicly for two days as we need to put this application on a solid server before opening up permanently -- we'd just like some quick feedback now. http://syndication.allaire.com/vote/ Your detailed input is important. Please post comments in the app beside any features or enhancements that interest you. Not only is your vote important, but also descriptions about how you'd use such a feature or a story about how you needed such a feature in the past. Please be as verbose as possible when posting -- more info, the better! Feel free to not only vote on items but to also add your own items. Standard disclaimer: Other variables go into the blender of feature definition. 100 votes for I'd like CF to emulate the Vic-20 does not necessarily mean that this feature will make the cut. This is simply one of a number of methods that we're using to help guide product development. Thanks, Terry ColdFusion Product Management ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DateAdd Strangeness? (Or is it me?)
Try this... cfset nextq = #month(dateadd(q, 1, now()))# cfoutput #nextq# /cfoutput You should get (if you try this in July) the month returned as 10... No problem. However.. Try this... cfset newdate = 3/5/2001 cfset nextq = #month(dateadd(q, 1, newdate))# cfoutput #nextq# /cfoutput And you get the month returned as 6. Huh?? I thought quarters were January, April, July and October? How does one get a 6 as the first month in a quarter? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DateAdd Strangeness? (Or is it me?) --it's you!!
First the date is in mm/dd/ format and 3 represents 1st quarter so adding another 1 quarter results in 6.. by the way a quarter is 3 months. - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 28, 2001 11:07 AM Subject: DateAdd Strangeness? (Or is it me?) Try this... cfset nextq = #month(dateadd(q, 1, now()))# cfoutput #nextq# /cfoutput You should get (if you try this in July) the month returned as 10... No problem. However.. Try this... cfset newdate = 3/5/2001 cfset nextq = #month(dateadd(q, 1, newdate))# cfoutput #nextq# /cfoutput And you get the month returned as 6. Huh?? I thought quarters were January, April, July and October? How does one get a 6 as the first month in a quarter? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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. :( -Original Message- From: Saro [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 28, 2001 11:27 AM To: CF-Talk Subject: Re: DateAdd Strangeness? (Or is it me?) --it's you!! First the date is in mm/dd/ format and 3 represents 1st quarter so adding another 1 quarter results in 6.. by the way a quarter is 3 months. - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 28, 2001 11:07 AM Subject: DateAdd Strangeness? (Or is it me?) Try this... cfset nextq = #month(dateadd(q, 1, now()))# cfoutput #nextq# /cfoutput You should get (if you try this in July) the month returned as 10... No problem. However.. Try this... cfset newdate = 3/5/2001 cfset nextq = #month(dateadd(q, 1, newdate))# cfoutput #nextq# /cfoutput And you get the month returned as 6. Huh?? I thought quarters were January, April, July and October? How does one get a 6 as the first month in a quarter? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do these things happen?
Turn on your debugging and look to see if the query shows up in your list of run queries. That will give you a better starting point from which to figure out what's really going on. I'm guessing that the ID isn't really getting passed, or it's some weird ID that doesn't satisfy the if statement. The other possibility is that there is some combination of conditions in the if statement that will cause neither query to be run. Have you tried outputting the hidden field to see what's really in it? Todd - 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 querypThe 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DateAdd Strangeness? (Or is it me?) --it's you!!
Don't forget, some fiscal years start and end in February. Therefore, fiscal 1Q 2001 would be Feb-Apr. - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 28, 2001 2: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. :( -Original Message- From: Saro [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 28, 2001 11:27 AM To: CF-Talk Subject: Re: DateAdd Strangeness? (Or is it me?) --it's you!! First the date is in mm/dd/ format and 3 represents 1st quarter so adding another 1 quarter results in 6.. by the way a quarter is 3 months. - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 28, 2001 11:07 AM Subject: DateAdd Strangeness? (Or is it me?) Try this... cfset nextq = #month(dateadd(q, 1, now()))# cfoutput #nextq# /cfoutput You should get (if you try this in July) the month returned as 10... No problem. However.. Try this... cfset newdate = 3/5/2001 cfset nextq = #month(dateadd(q, 1, newdate))# cfoutput #nextq# /cfoutput And you get the month returned as 6. Huh?? I thought quarters were January, April, July and October? How does one get a 6 as the first month in a quarter? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DateAdd Strangeness? (Or is it me?) --it's you!!
- 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Vote on ColdFusion Enhancements!
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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Calling Stored Proc....
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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do these things happen?
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 querypThe 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Vote on ColdFusion Enhancements!
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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Datatype Datetime
- 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
