Re: Oracle 11g Stored Proccedure won't talk to our ColdFusion code.
Which version of CF are you on? Oracle 11G isn't supported until CF9. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 24 July 2010 05:06, Ian Skinner wrote: > > We are attempting to execute a stored procedure with this piece of code. > > procedure="co_error.check_records" debug="yes"> cfsqltype="cf_sql_decimal" value="2010"> > > As you can see, it is a pretty small block. Executing > it returns this error. > > [Macromedia][Oracle JDBC Driver]Unhandled sql ty ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335690 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: displaying & editing text strings w/ embedded cr/lf pairs
If you are editing text directly in the database instead of on a Web form, then I agree that you might be better off storing the line breaks as characters so you can see them. This assumes that the text is primarily used for display as HTML. In general I like storing the original text. If the text doesn't get updated frequently and the HTML is displayed a lot, I store a second copy converted to HTML at the time of editing. When editing, the original text is used. When displaying in HTML, the HTML version is used. That said, if you are maintaining the text directly in the database, which is the assumption I am making, then storing two copies of the same content isn't a good idea because you would have to manually maintain both copies. -Mike Chabot On Fri, Jul 23, 2010 at 6:51 PM, Ben Conner wrote: > > Hi, > > I have a products table where the descriptions came from an outside > source. These need to be manually updated at times and I'm seeing a > difference between what gets returned by a SQL like '%xxx%' phrase vs a > REPLACE(...) phrase. The two don't always match. > > The display of the description in this store's logic uses the following: > > Replace(JSStringFormat(LongDesc),"\r\n","","ALL") > > I'm just wondering out loud if it might be more expedient to store the > text descriptions with statements vs the cr/lf combination. At > least then I could SEE the dang things and not wonder if I've missed a > space or something... > > Suggestions? > > Thanks! > > --Ben > > -- > Ben Conner ...@webworldinc.com > Web World, Inc. 888-206-6486 > PO Box 1122 480-704-2000 > Quee ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335689 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Salesforce CFC?
>Has anyone found a way to use Salesforce.cfc ( >http://salesforcecfc.riaforge.org/) with a more recent Salesforce web >services API? (17+) I have gotten through the bulk of a Salesforce >integration with the CFC mostly as-is, but now I'm running into a roadblock >because I want to access/update a Salesforce field that isn't recognized in >API version 11.1. > >I greatly appreciate any insights on updating this CFC. > > >Thanks, >Billy Cox not sure how much this would translate to Adobe Coldfusion, but on the Open BlueDragon docs site they have instructions on how to integrate SalesForce. http://www.openbluedragon.org/manual/?/webservices_salesforce >From what I've read so far, most of these instructions are readily applicable >to Adobe CF. regards, larry ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335688 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
displaying & editing text strings w/ embedded cr/lf pairs
Hi, I have a products table where the descriptions came from an outside source. These need to be manually updated at times and I'm seeing a difference between what gets returned by a SQL like '%xxx%' phrase vs a REPLACE(...) phrase. The two don't always match. The display of the description in this store's logic uses the following: Replace(JSStringFormat(LongDesc),"\r\n","","ALL") I'm just wondering out loud if it might be more expedient to store the text descriptions with statements vs the cr/lf combination. At least then I could SEE the dang things and not wonder if I've missed a space or something... Suggestions? Thanks! --Ben -- Ben Connerb...@webworldinc.com Web World, Inc. 888-206-6486 PO Box 1122 480-704-2000 Queen Creek, AZ 85242 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335687 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Proccedure won't talk to our ColdFusion code.
On 7/23/2010 3:03 PM, Scott McAllister wrote: > Hi Ian, > > What happens if you change the cfsqltype attribute of the cfprocparam tag to > be cf_sql_numeric ? > > -Scott We tried numeric, float and decimal all with the same results. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335686 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Proccedure won't talk to our ColdFusion code.
Hi Ian, What happens if you change the cfsqltype attribute of the cfprocparam tag to be cf_sql_numeric ? -Scott >We are attempting to execute a stored procedure with this piece of code. > >procedure="co_error.check_records" debug="yes"> cfsqltype="cf_sql_decimal" value="2010"> > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335685 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Oracle 11g Stored Proccedure won't talk to our ColdFusion code.
We are attempting to execute a stored procedure with this piece of code. As you can see, it is a pretty small block. Executing it returns this error. [Macromedia][Oracle JDBC Driver]Unhandled sql type The error occurred in D:\playground\warren\PpurComponents.cfc: line 49 Called from D:\playground\warren\ppur_file_import.cfm: line 53 Called from D:\playground\warren\PpurComponents.cfc: line 49 Called from D:\playground\warren\ppur_file_import.cfm: line 53 Here is what I hope is the relevant portion of a 1400 line stored procedure located in Oracle. We don't get to refactor the stored procedure until phase two of this project. PROCEDURE Check_records(p_year IN NUMBER) AS v_use_no NUMBER(8); v_error_code BINARY_INTEGER := 0; v_error_type VARCHAR2(20); ... This project is to replace a 15 year old Perl program to used to call this procedure with this code. open(SQL_OUTPUT, "sqlplus -S ops\$x/...@dev11ge \...@check_errors $year |") That executed this SQL file. * Run the error checking procedures */ SET pause off SET verify off SET TERMOUT ON SET FEEDBACK OFF SET document off SET serveroutput ON size 100 format word_wrapped WHENEVER SQLERROR EXIT 1 ROLLBACK WHENEVER OSERROR EXIT 1 ROLLBACK EXECUTE Co_error.Check_records(&1); show errors EXIT 0 Can anybody provide some insight on why this won't work form our CFML? TIA Ian ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Session timer??
Thanks Andrew! (slapping my forehead) I hadn't thought about calculating the time the test should end when the user starts--that and your other thoughts are great suggestions. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Alurium CFML (Railo) Hosting
Ya I saw your order come through. If you run into any questions just let me know. -- Peter Amiri Founder | Alurium Hosting 949-338-3862 | pe...@alurium.com | http://www.alurium.com LinkedIn: http://www.linkedin.com/in/peteramiri | IM bpamiri (AIM/MSN/Y!/GTLK/SKYPE) >Actually I already signed up, I seem to recall Sean Corfield speaking >well of your service > > >> ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335682 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Salesforce CFC?
How did the contact form break for you on RIAForge? On Thu, Jul 22, 2010 at 2:07 PM, Billy Cox wrote: > > Hey Brad. I have tried more than once to contact Tom de Manincor through the > riaforge.com site, and the contact mechanism seemed to be broken. I tried > commenting on his blog as well, but it didn't get any indication that he > ever got my comments/questions. > > btw, I saw you at the Great Mall last night. You looked busy though so I > didn't scream and wave. > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335681 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Alurium CFML (Railo) Hosting
Actually I already signed up, I seem to recall Sean Corfield speaking well of your service On Fri, Jul 23, 2010 at 2:45 PM, Peter Amiri wrote: > > Scott, > > I'll leave it for others to comment on their experience with our hosting, but > if there are any questions that I can answer for you please feel free to ask. > Keep in mind that we also provide a 30 trial account so you can always kick > the tires before you buy. > > -- > Peter Amiri > Founder | Alurium Hosting > 949-338-3862 | pe...@alurium.com | http://www.alurium.com > LinkedIn: http://www.linkedin.com/in/peteramiri | IM bpamiri > (AIM/MSN/Y!/GTLK/SKYPE) > >>This is probably the cheapest CFML hosting I've seen, is anyone using >>it and willing to comment positive or negative? >> >>thanks > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335680 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Alurium CFML (Railo) Hosting
Scott, I'll leave it for others to comment on their experience with our hosting, but if there are any questions that I can answer for you please feel free to ask. Keep in mind that we also provide a 30 trial account so you can always kick the tires before you buy. -- Peter Amiri Founder | Alurium Hosting 949-338-3862 | pe...@alurium.com | http://www.alurium.com LinkedIn: http://www.linkedin.com/in/peteramiri | IM bpamiri (AIM/MSN/Y!/GTLK/SKYPE) >This is probably the cheapest CFML hosting I've seen, is anyone using >it and willing to comment positive or negative? > >thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335679 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Session timer??
I haven't read the whole thread, but as you've alluded to you should never rely on Javascript. Malicious or curious people can modify the variables, people can have Javascript turned off, close the browser, etc. Using Javascript is fine, but you need to verify values for the redirect on the server. For example, store a session variable stating when the test is due to end, or whatever. Use that variable to start the timer when every page is generated. Then use that variable to verify that the user's Javascript has correctly requested a page redirect. You need to make sure that they haven't prematurely asked for a page to be redirected, and also that they haven't missed a Javascript redirection and are going to a page after they are supposed to. You can use Ajax to update a database record as long as you verify the request on the server as I've mentioned. If you verify all that on the server, then you should be fine. I don't have any code for you, just suggestions ;-) - Andrew. On 2010-07-23, at 11:41, Dawn Sekel wrote: > > I was reading this thread - but it is over 7 years old > http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:21407#108226 > I am working on a self assessment test website in which the psychologist I'm > developing the site for wants to keep the end user informed of how much time > they have left to complete the test. He doesn't want the session to end -- > just move them to the next test at the end of the time. Obviously there are > lots of flaws to doing a timer on a web page -- like if the end user > accidently closes the browser. I received some good clues by looking at the > thread -- but I was wondering if anyone has a recent web page timer in > Coldfusion or Javascript to share that updates a database record -- or any > recommendations - gotcha's that they have come across. > > Thanks! Dawn > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335678 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Adobe no longer part of the OpenCFML committee
Well, is Ben not part of it too? Just saying MD On 23 Jul 2010, at 17:06, Cutter (ColdFusion) wrote: > > http://www.adrocknaphobia.com/post.cfm/adobe-no-longer-part-of-opencfml > > Steve "Cutter" Blades > Adobe Community Professional - ColdFusion > Adobe Certified Professional > Advanced Macromedia ColdFusion MX 7 Developer > > Co-Author of "Learning Ext JS" > http://www.packtpub.com/learning-ext-js/book > _ > http://blog.cutterscrossing.com > > > > Dan Baughman wrote: >> Is there an official adobe announcement that it pulled out? >> >> On Thu, Jul 22, 2010 at 5:10 PM, Sean Corfield wrote: >> >> >>> On Thu, Jul 22, 2010 at 12:20 PM, Gerald Guido >>> wrote: >>> >> Or support for Amazon Web services: S3 (well before Adobe did), >> My bad. Before I get a public tongue lashing... I got Railo mixed up >>> with >>> OBD with the S3 support. >>> Yup, Railo introduced the concept of "resources" quite a long time ago >>> (in Railo 2.0, back in 2007) that allows standard file tags to work >>> with ram, S3, ZIP files, FTP sites and even database tables. >>> -- >>> Sean A Corfield -- (904) 302-SEAN >>> Railo Technologies, Inc. -- http://getrailo.com/ >>> An Architect's View -- http://corfield.org/ >>> >>> "If you're not annoying somebody, you're not really alive." >>> -- Margaret Atwo >>> >>> >>> >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335677 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Adobe no longer part of the OpenCFML committee
http://www.adrocknaphobia.com/post.cfm/adobe-no-longer-part-of-opencfml Steve "Cutter" Blades Adobe Community Professional - ColdFusion Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Dan Baughman wrote: > Is there an official adobe announcement that it pulled out? > > On Thu, Jul 22, 2010 at 5:10 PM, Sean Corfield wrote: > > >> On Thu, Jul 22, 2010 at 12:20 PM, Gerald Guido >> wrote: >> > Or support for Amazon Web services: S3 (well before Adobe did), > >>> My bad. Before I get a public tongue lashing... I got Railo mixed up >>> >> with >> >>> OBD with the S3 support. >>> >> Yup, Railo introduced the concept of "resources" quite a long time ago >> (in Railo 2.0, back in 2007) that allows standard file tags to work >> with ram, S3, ZIP files, FTP sites and even database tables. >> -- >> Sean A Corfield -- (904) 302-SEAN >> Railo Technologies, Inc. -- http://getrailo.com/ >> An Architect's View -- http://corfield.org/ >> >> "If you're not annoying somebody, you're not really alive." >> -- Margaret Atwo >> >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335676 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Session timer??
I was reading this thread - but it is over 7 years old http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:21407#108226 I am working on a self assessment test website in which the psychologist I'm developing the site for wants to keep the end user informed of how much time they have left to complete the test. He doesn't want the session to end -- just move them to the next test at the end of the time. Obviously there are lots of flaws to doing a timer on a web page -- like if the end user accidently closes the browser. I received some good clues by looking at the thread -- but I was wondering if anyone has a recent web page timer in Coldfusion or Javascript to share that updates a database record -- or any recommendations - gotcha's that they have come across. Thanks! Dawn ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Adobe no longer part of the OpenCFML committee
Is there an official adobe announcement that it pulled out? On Thu, Jul 22, 2010 at 5:10 PM, Sean Corfield wrote: > > On Thu, Jul 22, 2010 at 12:20 PM, Gerald Guido > wrote: > >>>Or support for Amazon Web services: S3 (well before Adobe did), > > > > My bad. Before I get a public tongue lashing... I got Railo mixed up > with > > OBD with the S3 support. > > Yup, Railo introduced the concept of "resources" quite a long time ago > (in Railo 2.0, back in 2007) that allows standard file tags to work > with ram, S3, ZIP files, FTP sites and even database tables. > -- > Sean A Corfield -- (904) 302-SEAN > Railo Technologies, Inc. -- http://getrailo.com/ > An Architect's View -- http://corfield.org/ > > "If you're not annoying somebody, you're not really alive." > -- Margaret Atwo > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335674 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Alurium CFML (Railo) Hosting
This is probably the cheapest CFML hosting I've seen, is anyone using it and willing to comment positive or negative? thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335673 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm