[Macromedia][Oracle JDBC Driver]No more data available to read.

2009-08-05 Thread Wes Middendorff
Not sure if my last post took since I didn't see it in the list or my email, so sorry if this is redundant. I am getting the following error [Macromedia][Oracle JDBC Driver]No more data available to read. when ever I try to execute a stored procedure that returns a ref cursor. I am currently

Re: [Macromedia][Oracle JDBC Driver]No more data available to read.

2009-08-05 Thread James Holmes
This is a common problem. If it persists, reduce your max pooled statements to 0. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/8/5 Wes Middendorff wmiddendo...@gmail.com: Not sure if my last post took since I didn't see it in the list or my email,

Reading / writing ANSI escaped strings

2009-08-05 Thread Francois Levesque
Hi all, I'm trying to build a web interface to an i18n resource bundle. The problem is that the values in these files are ANSI escaped: G\u00E9rer les r\u00F4les instead of Gérer les rôles. I need a way to unescape these strings so I can display them in an input field and then ANSI escape them

Re: [Macromedia][Oracle JDBC Driver]No more data available to read.

2009-08-05 Thread Wes Middendorff
Thanks for the speedy reply James. I have done as you suggested, but I still recieve the error. Afterwards, just to see if it would have an affect, disabled the maintain connections settings and it also had no affect. Not sure if it matters in this case, but I am using oracle 10gR2. Wes

Re: [Macromedia][Oracle JDBC Driver]No more data available to read.

2009-08-05 Thread James Holmes
It's possible the DB is actually unavailable (either due to network congestion, Oracle problems or other issues) when the errors occur. It's also possible that you're using shared servers rather than dedicated servers and the shared servers are having an issue. Check memory on the Oracle server,

Could use some inputs

2009-08-05 Thread Don L
Here's a situation I hope you could provide some thoughtful input. I've converted a cf8-based app into an open source one. Initially it seemed all's well but lately, right when I'm ready to deploy it (not to be hosted like many do), some core functionality like automatically data saving,

Re: Reading / writing ANSI escaped strings

2009-08-05 Thread Paul Hastings
Francois Levesque wrote: I'm trying to build a web interface to an i18n resource bundle. The problem ah a man after my own heart ;-) try this: http://www.sustainablegis.com/unicode/resourceBundle/javaRB.cfm but if you want a ready made, web accessible rb manager try jason sheedy's

RE: Could use some inputs

2009-08-05 Thread Mark Kruger
Don, You are giving us the wrong information here. What you should post is the code in question and a description of the former environment (cf8 + what? MSSQL?) and the new environment. -mark -Original Message- From: Don L [mailto:do...@yahoo.com] Sent: Wednesday, August 05, 2009

Re: [Macromedia][Oracle JDBC Driver]No more data available to read.

2009-08-05 Thread Wes Middendorff
I wish our DBA gave me that level of access the server, but I will let him know what to check into. The servers we are on are most certainly dedicated (I am the administrator for the CF side). Also I am able to connect to the DB and execute queries using the Oracle JDBC driver with any

cfgridcolumn dropping 0 zeros from string

2009-08-05 Thread Paul Ihrig
i have a column in a cfgrid user can put either text or number like 1234.56 if the enter 1234.50 the display removes the zero. so it look like 1234.5 or if the string is 1234000 it displays 1234 there are also results that at like xc2000s and those are fine. cfgridcolumn name=ArtNr header=ArtNr

Re: cfgridcolumn dropping 0 zeros from string

2009-08-05 Thread Scott Stroz
Try prepending a space before the value when you are returning the data to grid. This is a known issue. On Wed, Aug 5, 2009 at 10:01 AM, Paul Ihrigpih...@gmail.com wrote: i have a column in a cfgrid user can put either text or number like 1234.56 if the enter 1234.50 the display removes

Using Active Directory to connect to a database.

2009-08-05 Thread ib webn65
I am use to creating a DSN in the CFAdmin to allow the CF websites to connect to a SQL database. In the CF Admin the DSN’s are created using a SQL login id and password to access the database. I have been asked to use an Active Directory account instead of a SQL account to connect to a SQL

Re: cfgridcolumn dropping 0 zeros from string

2009-08-05 Thread Cutter (ColdFusion)
It'll do that. You'll have to apply a custom column renderer. There is an Ext.utils.format class, containing a numeric format function where you can set your format. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS

Re: cfgridcolumn dropping 0 zeros from string

2009-08-05 Thread Paul Ihrig
Awesome Scott, Thank You.. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

Re: removing dups from a two dimensional array using LinkedHashSet

2009-08-05 Thread Tom Chiverton
On Friday 31 Jul 2009, Tony Bentley wrote: I can do it using two nested loops but the record set is over 1000 So ? That's not very many. Does it take a particularly long time ? -- Helping to confidentially fashion professional bleeding-edge total developments as part of the IT team of the

limit date selection in cfinput datefield

2009-08-05 Thread Braden Powers
hello, I am trying to created a startdate with the cfinput datefield. The requirement is to not allow a user to select a date in the past. Thanks, Braden ~| Want to reach the ColdFusion community with something they want?

Re: Reading / writing ANSI escaped strings

2009-08-05 Thread Francois Levesque
Paul, This is awesome. Thanks for the tip! Francois Levesque http://blog.critical-web.com/ On Wed, Aug 5, 2009 at 9:37 AM, Paul Hastings p...@sustainablegis.comwrote: Francois Levesque wrote: I'm trying to build a web interface to an i18n resource bundle. The problem ah a man after my

Re: removing dups from a two dimensional array using LinkedHashSet

2009-08-05 Thread Tony Bentley
Yes, but this is resolved. I was looping through the same array twice which took a very long time. Instead I used the original query object and while looping the array did a query of query to check duplicates - if (recordcount gt 1){delete}. cfloop to=#ArrayLen(xlsrry)# from=1 index=i

Web service error

2009-08-05 Thread ch g
Hi all, I am developing a simple web service, but i am getting an error like this Web service operation echoString with parameters {INPUT={hello}} cannot be found. Here is the published web service cfcomponent cffunction name=echoString returnType=string output=no cfargument

Re: ADA Captcha

2009-08-05 Thread Dan Baughman
Nice, I think I've decided to go with recaptcha, just because this captcha isn't really part of a form. This implemntation is being used to restrict access to certain areas of the site. On Tue, Aug 4, 2009 at 4:30 PM, Phillip Vector vec...@mostdeadlygame.comwrote: I found CFFormProtect to be

RE: Web service error

2009-08-05 Thread Mark Kruger
You need to set the access level for the function to remote if you wish to use it as a WS. cffunction name=echoString Access=remote -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: ch g

Re: Web service error

2009-08-05 Thread ch g
I included that also cffunction name=echoString returnType=string output=no access=remote cfargument name=input type=string required=yes cfreturn #arguments.input# /cffunction Still receving the same error message Web service operation echoString with parameters

RE: Web service error

2009-08-05 Thread Mark Kruger
A quick test on my own server shows that your function works fine. cfset x = createobject(webservice,http://www.ecodes.biz/UserVerif.cfc?wsdl;).echoSt ring(hello World)/ cfoutput#x#/cfoutput I suspect you have compiled the WSDL and the stub is being cached. You need to refresh the cache...

Re: Web service error

2009-08-05 Thread ch g
After i changed the file name it's working, so i developed another service to verify the information aganist my database. Now i am receiving this error. Cannot perform web service invocation testUser. The fault returned when invoking the web service operation is: AxisFault faultCode:

RE: Web service error

2009-08-05 Thread Milburn, Steve
It's hard to tell because you did not include the entire SQL statement, but the error message indicates that you neglected to put an s on arguments.firstName. You probably have argument.firstname. ~Steve From: ch g [chr_...@yahoo.com] Sent: Wednesday,

RE: Web service error

2009-08-05 Thread William Seiter
1. The scope is arguments, note the s 2. If the query returns a recordcount of 0, what does the function return? -Original Message- From: ch g chr_...@yahoo.com Sent: Wednesday, August 05, 2009 10:40 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Web service error After i

Re: Web service error

2009-08-05 Thread ch g
Thank you so much for all of your time and suggestions. Problem is typo mistake in SQL statement, i was in hurry, so i didn't went through the entire error message. Thank you once again. It's hard to tell because you did not include the entire SQL statement, but the error message

Re: Could use some inputs

2009-08-05 Thread Will Tomlinson
I have help with problems to your motivated issue of capable proportions that might hint to the extinction of the not cf coding issue... Here's a situation I hope you could provide some thoughtful input. I've converted a cf8-based app into an open source one. Initially it seemed all's

Re: Could use some inputs

2009-08-05 Thread Don L
Don, You are giving us the wrong information here. What you should post is the code in question and a description of the former environment (cf8 + what? MSSQL?) and the new environment. -mark Mark, the converted app uses a cfml engine, sql2005express and Ext (2) for UI, I've tested the

Re: Could use some inputs

2009-08-05 Thread Don L
What nonsense are you churning out? I have help with problems to your motivated issue of capable proportions that might hint to the extinction of the not cf coding issue... ~| Want to reach the ColdFusion community with

Re: Using Active Directory to connect to a database.

2009-08-05 Thread Jason Fisher
If your users have to login to the application using NTFS authorization, such as if you disable Anonymous access in IIS, then CF will have access to the user's network credentials and you could pass those into the query calls: cfquery name=getMyStuff datasource=mySqlDatasource

Re: Could use some inputs

2009-08-05 Thread Don L
This note is to correct myself, Railo rocks in general and I'm grateful to Gert etc. It's not some sort of promo for them but rather a remedy in case of misunderstanding of the op. ~As you know, I'm impatient and a great friend of mistakes.

RE: Could use some inputs

2009-08-05 Thread cftalk
How about you start with a search of your code base for the word DELETE. Rows can't just be deleted without a DELETE statement. If your app uses stored procedures, you may need to look there. Also check your database for any triggers that may be setup to delete rows. The alternative is that

Re: Could use some inputs

2009-08-05 Thread Maureen
You can't delete a row without delete, but you can overwrite it, which appears to be what is happening here. The last row written is overwriting the previous rows because the identity field is not changing. On Wed, Aug 5, 2009 at 3:39 PM, cftalkcft...@logiforms.com wrote: How about you start

Re: Could use some inputs

2009-08-05 Thread Gerald Guido
Don, This scenario has been repeated so many times with your posts it is as it follows a script. One could call it The Don Show. Scene 1 You post a nebulous, vague and rambling post where you don't really ask a question but ask for help. You may provide some pseudo code but nothing that people

Re: Could use some inputs

2009-08-05 Thread Azadi Saryev
i do not think anyone could have said it better, G! though i did laugh at Will's reply (and even more at DonL's reply to that) :) Azadi Saryev On 06/08/2009 07:09, Gerald Guido wrote: Don, This scenario has been repeated so many times with your posts it is as it follows a script. One