Re: How to Fetch records from a Ref Cursor returned by a PL/SQL procedure
I have supported other applications with the ability to do this (Java, Delphi). Was that with a Java Web application ( JSP) or a standalone application ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279654 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to Fetch records from a Ref Cursor returned by a PL/SQL procedure
Rule of thumb, let the database do the work and not the web server. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279656 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Red Sky Beta 2
Its a shepherds delight if it happens at night Yeah, Shepherd's don't get much. The sheep keep running away when they hear the sound of a zip. Taz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Rich Text Editor
Does anyone know of any free rich text editors to build into a CMS (like a WYSIWYG)? SoEditor from siteobjects.com Taz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unknown character codes appearing in DB
Since I first posted, I have discovered that the behavior is only happening with IE 5.5. The characters represent quotes and apostophes from MS Word. #8220; = MS Word Left Quote #8221; = MS Word Right Quote #8217; = MS Word Apostophe Still stumped on this... possible IE 5.5 bug? Where on MSDN would one go to find out? They're called smart quotes, which is an MS word piece of amusement for us all. I've created a tag called cf_cleanmstext.cfm which converts these to normal versions and also strips out all of that Microsoft XML tags nonsense (smart tags, styles, etc.) You can try it out and download it here: http://www.tazmedia.co.uk/software/tags/try_cleanmstext.cfm Taz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: grrrrr ... CFSchedule
Does the script take a long time to run? If so, you might need to stick a RequestTimeout on the URL string that calls the template in scheduler. I've noticed in the past that big tasks tend to time out running via CFSchedule even though they don't require a RequestTimeout when accessed through a browser... maybe scheduled tasks are low priority (?). Taz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Cfscript help
insert() returns a string, but you're not setting ref as the new string. Therefore you get an infinite loop BTW, you should ditch the use of ##s Taz Brackets were wrong - thanks, but its still times out! Any other thoughts? ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Chatster on CFHUB
NuMedia Internet Inc, according to the copyright notice at the bottom Taz NOBODY CAN HELP WITH THIS? DOES ANYBODY KNOW WHO OPERATES CFHUB.com? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Date Compare in SQL?
Doesn't MySQL have the DAY function? BTW: there's no need for the cfqueryparams, and you should be using a WHERE clause cfquery ... SELECT TicketID FROM Tickets WHERE MONTH(dateCreated) = #DatePart(m, f_date)# AND YEAR(dateCreated) = #DatePart(, f_date)# AND DAY(dateCreated) = #DatePart(d, f_date)# ORDER BY TicketID /cfquery Taz - Original Message - From: Cedric Villat [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 24, 2002 6:00 AM Subject: Date Compare in SQL? I'm trying to compare dates in my SQL statement. I can compare month and year, but not day. Here is my query. cfquery name=getTicketCount datasource=#request.dsn# username=#request.dbuser# password=#request.dbpass# SELECT T.ticketID FROM Tickets T AND month(dateCreated) = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#DatePart(m, f_date)# AND year(dateCreated) = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#DatePart(, f_date)# ORDER BY T.ticketID /cfquery but how can I compare the Day? I'm looking for something that will work on MySQL as well as MSSQL. Any ideas? Cedric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Date Compare in SQL?
Of course you don't need to split it into date parts anyway... Taz Doesn't MySQL have the DAY function? BTW: there's no need for the cfqueryparams, and you should be using a WHERE clause cfquery ... SELECT TicketID FROM Tickets WHERE MONTH(dateCreated) = #DatePart(m, f_date)# AND YEAR(dateCreated) = #DatePart(, f_date)# AND DAY(dateCreated) = #DatePart(d, f_date)# ORDER BY TicketID /cfquery Taz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: DateFormat in CFMX
What's the error? Could you give us some examples of data that works and data that throws errors? Perhaps the locale of the system is conflicting. For example you may find that dates such as 02/03/2002 are working but 14/03/2002 are not because its mixing up the day/month as month/day (taking non-US dates as example) Taz Is there a dateformat issue using CFMX that was addressed in some update/patch, or some means?? When doing a directory listing, some directories will report fine and format the date accordingly using the DateFormat function. However, there are some directories which will throw an error. Nothing special regarding the directory. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Incrementing a variable
That's because on every page request you reset the value to zero What are you trying to do? Taz - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 12:12 PM Subject: Incrementing a variable Hi, For some reason I can't get my variable to increment when my page is reloaded. I have the following in my application.cfm file cfset child = 0 In my index.cfm file I have the following. cfset child=child + 1 Everytime I refresh the page manually or by using an a href within mu file to reload mu index.cfm it doesn't increment? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Incrementing a variable
Spooky You ought to do a ListLen() on the template path using '\' as the delimiter Taz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: IsDefined vs. ParameterExists functions
ParameterExists() is deprecated, you should use IsDefined() IsDefined is also minutely faster than ParameterExists Taz What's the difference between the functions - IsDefined and ParameterExists? Is the IsDefined function replacing the ParameterExists function? Is one better than the other using CF5 or CFMX servers? ~Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an 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. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm