Re: Fusebox 4 question

2007-07-13 Thread Phillip M. Vector
Got it fixed by putting it from development to production. I didn't think it really mattered due to either it's on the local machine or on a live server if I was the only one accessing it and I didn't mind waiting the longer time while it compiles. I guess it does matter. :) Thanks for the help

Error parsing the form under encoding - UTF-8 - still stumped

2007-07-13 Thread Casey C Cook
It appears the debug template is having issues? [0]coldfusion.runtime.CFPage$FormParsingIOException: Error parsing the form under encoding - UTF-8. at coldfusion.runtime.CFPage.SetEncoding(CFPage.java:887) at cfclassic2ecfm1115156690._factor18(C:\CFusionMX7\wwwroot\WEB-INF\debug\clas

Re: shared hosting with cfobject support (sandboxed)

2007-07-13 Thread Robertson-Ravo, Neil (RX)
Do you really need it - is JavaLoader not an option? "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also

shared hosting with cfobject support (sandboxed)

2007-07-13 Thread Jim Rising
I was just wondering if there are any shared hosting providers who support cfobject at all? Jim Rising Sr. Cold Fusion Developer ICGLink Inc. www.icglink.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integr

Re: Query Result Problem

2007-07-13 Thread Doug Bezona
Yes - this is a connection-wide directive. The solution would be to find the query that's setting it to 50, and either change it to use "TOP" in the select statement, or make sure to add the SET ROWCOUNT 0 after it. On 7/13/07, Bill Fears <[EMAIL PROTECTED]> wrote: > > that seams to have worked f

RE: SQL Server 2005 datasource - permissions

2007-07-13 Thread Dave Watts
> You are correct sir! Thank you. I do have a follow up > question, however. I'm curious - the password I was trying to > use that was being rejected was a GUID created using > CreateUUID(). Should/can such identifiers not be used as > passwords in the CF Administrator? My thought was that you

Re: Need help with an INSERT query in to MS Access, please...

2007-07-13 Thread Claude Schneegans
>>You might prefer these options though: But this won't work with Access. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks.

Re: Help with Query and Loop

2007-07-13 Thread Janet MacKay
No magic involved. But glad you'll be alive to enjoy the weekend ;-) ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive:

Re: SOT: Eclipse Plugins

2007-07-13 Thread Cutter (CFRelated)
Due to my need to use nested taskdefs in Ant that were only available in 1.7, I had to upgrade to Eclipse 3.3. This, in the end run, was quite painful because it is 'suggested' that you use a Java 1.5+ JVM, from the SDK (wanted more than just the JRE?) Although all of my plugins loaded ok, CFEc

Re: Help with Query and Loop

2007-07-13 Thread Joel Watson
> > As an illustration, say that users table has the following entries: > > > > userID_fk [1] > > stationID_fk [4] > > checked [0] > > > > So here, the query will return only the value of the second and > forth > > row. > > The forth row isn't checked. I'm assuming that's just a typ

Re: Help with Query and Loop

2007-07-13 Thread Janet MacKay
> As an illustration, say that users table has the following entries: > > userID_fk [1] > stationID_fk [4] > checked [0] > > So here, the query will return only the value of the second and forth > row. The forth row isn't checked. I'm assuming that's just a typo. If I'm understand

Re: SQL Server 2005 datasource - permissions

2007-07-13 Thread Andrew Peterson
>> I have a SQL Server database and I want to make it accessible > >I'll bet you actually have the incorrect password. There's nothing special >you have to to create logins that you can use from CF. Try changing the >password. > >Dave You are correct sir! Thank you. I do have a follow up questio

Re: Fusebox 4 question

2007-07-13 Thread Phillip M. Vector
Yup. It's loading the correct files. and yeah, with identical code, the only thing I can figure is the server somehow blocking something. Barney Boisvert wrote: > Sounds like it's looking for the main circuit inside it's internal > data structures, and not finding it. How that could happen with

Help with Query and Loop

2007-07-13 Thread Joel Watson
I have a table that contains user and station information, as well as a boolean field for whether the information is displayed or not. It looks roughly like this: uStationID userID_fk stationID_fk checked I have another very similar table that looks like this cStationID customerID_fk stationID

Re: Fusebox 4 question

2007-07-13 Thread Barney Boisvert
Sounds like it's looking for the main circuit inside it's internal data structures, and not finding it. How that could happen with identical code, I'm not sure. You've double checked that all the files you think you're using are the ones that are actually being used? On 7/13/07, Phillip M. Vecto

Re: Handling complex data returned from consumed .NET web service

2007-07-13 Thread Dominic Watson
GetClass() is a method in the *java.lang.Object *class which is a base class for pretty much any variable in CF (perhaps all?). The documentation for *java.lang.Object *is here (includes GetClass()): http://java.sun.com/j2se/1.4.2/docs/api/java/lang/Object.html Dom On 13/07/07, james carberry

Re: Fusebox 4 question

2007-07-13 Thread Phillip M. Vector
I did the structDelete and that fixed the main error. Thank you. :) Now, if you are up to it, is another error I'm now getting (again, I'm not getting it in the local server). "Element Main is undefined in a CFML structure referenced as part of an expression." Can you explain this in laymens t

Re: Fusebox 4 question

2007-07-13 Thread Barney Boisvert
Are you reloading the fusebox when you deploy? Or you might try putting structDelete(application, "fusebox", false) in index.cfm, running it once, and then removing it, just to ensure you've got a pristine memory state. cheers, barneyb On 7/13/07, Phillip M. Vector <[EMAIL PROTECTED]> wrote: > T

Re: Fusebox 4 question

2007-07-13 Thread Phillip M. Vector
The parameter is there. Also, the core files are a direct copy from my local. So logically, it should work. Barney Boisvert wrote: > Why you're getting this error, I'm not 100% sure, but I'd bet it's > because you have different versions of the core files. If you add a > parameter in fusebox.x

Re: Handling complex data returned from consumed .NET web service

2007-07-13 Thread Tom Donovan
It's pretty easy with the ordinary CF Query*() functions: -tom- james carberry wrote: > Worked perfectly!! > > Do you know if there is an easy way to move the info in the array to a > regular ColdFusion query object? > > Thx! > > ~~

Re: Fusebox 4 question

2007-07-13 Thread Barney Boisvert
Why you're getting this error, I'm not 100% sure, but I'd bet it's because you have different versions of the core files. If you add a parameter in fusebox.xml named 'parseWithComments', that should take care of the issue, however. cheers, banreyb On 7/13/07, Phillip M. Vector <[EMAIL PROTECTED]

Fusebox 4 question

2007-07-13 Thread Phillip M. Vector
When I run an app I made on my local server, it works fine. But when I upload it to a server I host with, I get this error. "Element FUSEBOX.PARSEWITHCOMMENTS is undefined in APPLICATION." The layout I have is www -- index.cfm Application.cfm Data -- fusebox.xml and all fusebox/circ

Re: Yet another article about how 'coldfusion never took off'

2007-07-13 Thread Josh Nathanson
> Definitely flame bait. They want you to respond, and spread the article > around. Less likely flame bait than sheer ignorance. Check this out: "CFML uses tags reminiscent of HTML and need not be well-formed, which is a big help to newer (or non-meticulous) programmers who frequently forget t

Re: Yet another article about how 'coldfusion never took off'

2007-07-13 Thread Casey Dougall
On 7/13/07, Jerry Johnson <[EMAIL PROTECTED]> wrote: > > Definitely flame bait. They want you to respond, and spread the article > around. > > Step away from the keyboard. > > Jerry When you got 5 pages of crap postings, you Look like an ad-sense site. Lets report them to google! ~~

RE: Yet another article about how 'coldfusion never took off'

2007-07-13 Thread Andy Matthews
Agreed. I wouldn't pass that article around, or even bother commenting on it. -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 12:31 PM To: CF-Talk Subject: Re: Yet another article about how 'coldfusion never took off' Definitely flame bait.

Re: Yet another article about how 'coldfusion never took off'

2007-07-13 Thread Paul Hastings
Jerry Johnson wrote: > Definitely flame bait. They want you to respond, and spread the article > around. > > Step away from the keyboard. very good advice. like our forums troll andy, this is also best ignored. ~| ColdFusion MX

Re: Yet another article about how 'coldfusion never took off'

2007-07-13 Thread Jerry Johnson
Definitely flame bait. They want you to respond, and spread the article around. Step away from the keyboard. Jerry On 7/13/07, Peterson, Chris <[EMAIL PROTECTED]> wrote: > Sheesh, they are comparing Coldfusion to the likes of ALGOL and > something called 'Befunge'. Where do these editors come f

Yet another article about how 'coldfusion never took off'

2007-07-13 Thread Peterson, Chris
Sheesh, they are comparing Coldfusion to the likes of ALGOL and something called 'Befunge'. Where do these editors come from? >From the article: Given its ease of use and its position as a transitionary language from HTML, it is rather surprising that ColdFusion's popularity has waned so quickly

RE: Query Result Problem

2007-07-13 Thread Peterson, Chris
The recordcount will persist if you have 'maintain connection' or pooled connections enabled for your datasource. Then it connects, and re-uses the existing connection over and over again. You can disable that and check how well it scales, it may add some overhead to your normal transactions. I

Re: Handling complex data returned from consumed .NET web service

2007-07-13 Thread james carberry
Worked perfectly!! Do you know if there is an easy way to move the info in the array to a regular ColdFusion query object? Thx! ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. h

Re: Query Result Problem

2007-07-13 Thread James Wolfe
>that seams to have worked for that query, but other queries still return a >limit of 50 records. So I have this question, that I could not answer myself >with a google search... Is possible that a SET ROWCOUNT x in one place would >affect every query from that server? Its possible that it would p

RE: SQL Server 2005 datasource - permissions

2007-07-13 Thread Dave Watts
> I have a SQL Server database and I want to make it accessible > to CF. I can connect successfully to the datasource in CFIDE > using the sa account, but I cannot do the same using a New > Login with SQL Server Authentication. The error I receive is > "Login failed for user 'theuser'" which is

Re: Need help with an INSERT query in to MS Access, please...

2007-07-13 Thread Richard Cooper
ps. ignore the left them in accidently. ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoff

Re: Need help with an INSERT query in to MS Access, please...

2007-07-13 Thread Richard Cooper
It will wait for the DB to unlock. You might prefer these options though: Either: INSERT INTO myTable (something) VALUES ('#FORM.something#'); SELECT SCOPE_IDENTITY() AS new_id; or this: INSERT INTO myTable (something) VALUES ('#FORM.something#') SELECT @@identity as new_i

Re: Handling complex data returned from consumed .NET web service

2007-07-13 Thread Tom Donovan
try this: #i# #countryArray[i].key# #countryArray[i].value# It appears that only keys are returned. There are no values. Maybe the position in the array is the country code. i.e. maybe "Albania" is country #3 because countryArray[3].key is "Albania". -tom- ja

SQL Server 2005 datasource - permissions

2007-07-13 Thread Andrew Peterson
Hi, I have a SQL Server database and I want to make it accessible to CF. I can connect successfully to the datasource in CFIDE using the sa account, but I cannot do the same using a New Login with SQL Server Authentication. The error I receive is "Login failed for user 'theuser'" which is incid

Re: Query in a function

2007-07-13 Thread koen darling
> > That won't quite work...it will return all users where active=1, even if > userID is specified. > > -- Josh You're absolutely right. WHERE (active = '1' AND #arguments.userID# = 0) OR userID = #arguments.userID# ~| Create

Re: Handling complex data returned from consumed .NET web service

2007-07-13 Thread james carberry
Thx for your reply! That returns: org.smenet.www.LookUps.Results Two questions: 1) Is there some way to utilize this response to get the actual output? 2) I couldn't find the ColdFusion docs for getClass() or getName() - is there a help file for these functions somewhere? Thx! -j ~

Re: Handling complex data returned from consumed .NET web service

2007-07-13 Thread Dominic Watson
Does this give you anything meaningful ? On 13/07/07, james carberry <[EMAIL PROTECTED]> wrote: > > I am having trouble figuring out how to access data returned from a web > service I am consuming from my ColdFusion app. The web service is in .NET if > that makes any difference. > > The web servic

Re: SOT: Eclipse Plugins

2007-07-13 Thread Tom Chiverton
On Thursday 12 Jul 2007, Charlie Griefer wrote: > the nightly build does > http://update.aptana.com/update/nightly/3.2/ Unfortunetly it also makes my Eclipse crash every 2 hours. -- Tom Chiverton Helping to apprehensively reintermediate dot-com web-readiness on: http://thefalken.livejournal.com

Handling complex data returned from consumed .NET web service

2007-07-13 Thread james carberry
I am having trouble figuring out how to access data returned from a web service I am consuming from my ColdFusion app. The web service is in .NET if that makes any difference. The web service is called "getCountries" and it should basically return a result set with a list of country codes (pro

RE: Updating BIT Column

2007-07-13 Thread Robert Rawlins - Think Blue
Thanks guys, You're both spot on! I was confused as when I view the table in SSMS it displays the column values as True/False and not 1/0 but this must just be a presentation thing. Thanks, Rob -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: 13 July 2007 15:35 To

RE: Updating BIT Column

2007-07-13 Thread Scott Stewart
Hey Rob "true" and "false" are access centric, you'll need to use 1 or 0 -- Scott Stewart ColdFusion Developer SSTWebworks 7241 Jillspring Ct. Springfield, Va. 22152 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks -Original Message- From: Robert Rawl

RE: Updating BIT Column

2007-07-13 Thread Dawson, Michael
Without testing this, I would say you need to pass a "0" or "1" to this column. I doubt the database knows enough to convert "True" to a boolean. Therefore, it assumes that you are setting MyColumn equal to the value from the "True" column. M!ke -Original Message- From: Robert Rawlins

Updating BIT Column

2007-07-13 Thread Robert Rawlins - Think Blue
Hello Guys, I'm trying to run a small update query but i'm having a few problems getting it working correctly, here is the query syntax: UPDATE MyTable SET MyColumn = WHERE AnotherColumn = However when i run this i get the following error: [Macromedia][SQLServer JDBC

RE: Looking for an xml-rpc client

2007-07-13 Thread Bosky, Dave
Hi Dan, I was looking for a simple client to access a few methods and post some information to an xml-rpc server. I'm not interested in weblog software, I couldn't find much on your site, perhaps you could direct me in the right location. Thanks Again. Dave -Original Message- From: Dan V

RE: Im Ashamed But Need Help

2007-07-13 Thread Robert Rawlins - Think Blue
Perfect! Lol I've not seen that before, You can all expect a virtual beer at the end of the day from ol' Rawlins. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: 13 July 2007 14:18 To: CF-Talk Subject: RE: Im Ashamed But Need Help >Thanks chaps, I would buy you all a

RE: Im Ashamed But Need Help

2007-07-13 Thread Brad Wood
>Thanks chaps, I would buy you all a pint, but to be honest I'm not that rich :-D There is always the "Virtual Beer": http://www.beermonthclub.com/sendavirtualbeer.asp ~| CF 8 – Scorpio beta now available, easily build great

Re: Query Result Problem

2007-07-13 Thread Bill Fears
that seams to have worked for that query, but other queries still return a limit of 50 records. So I have this question, that I could not answer myself with a google search... Is possible that a SET ROWCOUNT x in one place would affect every query from that server? On 7/12/07, Doug Bezona <[EMAIL

Re: Need help with an INSERT query in to MS Access, please...

2007-07-13 Thread Riaan Venter
>>>I need to know what the record number of a query > >I suppose you mean what is the last id set to an automatic counter >field, since physical record numbers are not accessible in SQL. > >Use a query to get the maximum value of your id field, and don't forget >to lock the area which contains th

Re: Need help with an INSERT query in to MS Access, please...

2007-07-13 Thread Claude Schneegans
>>I need to know what the record number of a query I suppose you mean what is the last id set to an automatic counter field, since physical record numbers are not accessible in SQL. Use a query to get the maximum value of your id field, and don't forget to lock the area which contains the inse

Need help with an INSERT query in to MS Access, please...

2007-07-13 Thread Riaan Venter
Hi Please help me. I need to know what the record number of a query is immediatly after INSERTing into the database. Looking for the latest record will not work as there might be a newer entry inserted by someone else. The only thing I can think to do is to search on one of the Text fields, whi

Re: Getting ORA-01003 error while executing a query from coldfusiion

2007-07-13 Thread hussain shaikh
> On Friday 13 Jul 2007, hussain shaikh wrote: > > I am getting an ORA-01003 error when I try to use cfqueryparam in my > query, > > but when I remove the cfqueryparam tag and hard code the value in > the where > > condition it works fine.The oracle error no. description says that > "No SQL > >

Re: SOT: Eclipse Plugins

2007-07-13 Thread Tom Chiverton
On Friday 13 Jul 2007, AJ Mercer wrote: > After downloading Eclipse and re-installing all my plugs I saw this in the > 'what's new' page > http://help.eclipse.org/stable/nav/2_3_0 This is for plug-in developers. There *should* be an update URL you can just plug into eclipse to make it update

RE: Im Ashamed But Need Help

2007-07-13 Thread Robert Rawlins - Think Blue
Hello Guys, Wow, well I'm glad to see this got such a great response, thank you all for your suggestions, they're greatly appreciated. The FTP site was defiantly not anywhere near the root of my C: drive, in fact it was on a totally different drive and quite a few levels down from the root. There

Re: SOT: creating db columns - all varchars?

2007-07-13 Thread Jochem van Dieten
Mik Muller wrote: > > I'm told that shorter fields will sort faster. They will if the content is shorter. Whether the datatype is declared as VARCHAR(x) or VARCHAR(y) should not matter, so you might as well just pick the longest one for all of them. Jochem

Re: Getting ORA-01003 error while executing a query from coldfusiion

2007-07-13 Thread Tom Chiverton
On Friday 13 Jul 2007, hussain shaikh wrote: > I am getting an ORA-01003 error when I try to use cfqueryparam in my query, > but when I remove the cfqueryparam tag and hard code the value in the where > condition it works fine.The oracle error no. description says that "No SQL > statement parsed".I

Re: SOT: Eclipse Plugins

2007-07-13 Thread Robertson-Ravo, Neil (RX)
Yeah, it's what I thought, just annoying that it can't update itself via the update site! "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains info