Re: CF7 - 16 character limit on SQL passwords

2005-06-30 Thread Paul Hastings
Dave Watts wrote: I know that the latest DataDirect drivers do support trusted connections. However, there's no setting in the CF Admin to enable that instead of a native SQL login. I'm too lazy right now to try to get it working, though. well if you're feeling a bit more energetic then maybe

Spectra 1.5.3, cftransaction and security tags

2005-06-30 Thread Anthony Dimino
Hi, I have this cfatransaction block , the firts datasource is =#request.cfa.objectstore.dsn# , but cfa_workflowexecute use a second datasource in cfa_workflowxecute.cfm... And it's a known bugs, in Spectra 1.5.3 : Macromedia Spectra 1.5.3 uses a database connection within ColdFusion MX to

Jrun connection closing for no reason

2005-06-30 Thread Andy Jarrett
Hi there, at the moment we are getting a few of the following errors Server Error The server encountered an internal error and was unable to complete your request. JRun closed connection. The problem is that they are not *that* regular and nothing from the logs is jumping out at us. Has anyone

RE: Jrun connection closing for no reason

2005-06-30 Thread Robertson-Ravo, Neil (RX)
Yes, it is a common error - can be caused by a number of things. 1. Simultaneous connections has been reached 2. Server is too busy to handle requests 3. Long running query has not times out leading to JRun not serving requests 4. Not patched with latest Web Connectors. -Original

Re: Jrun connection closing for no reason

2005-06-30 Thread J.J. Merrick
Andy, When I started working at my employer 9 months ago they were about to lose some high profile clients due to what soon became known as The Jrun error... Well my budy and I came in and installed all the latest patches and it fixed it right up. What was causing it was the connection to

cachedwithin issues

2005-06-30 Thread Protoculture
I've set this up on our site and I've noticed some weird behaviour with it. (*) Users performing different queries are getting the same results. ( Ie. I do a search for 'c++' which returns 100 records. Another user does an any any search and gets back the same records. ( btw the any any should

RE: Jrun connection closing for no reason

2005-06-30 Thread Robertson-Ravo, Neil (RX)
What was causing it was the connection to SQL server was constantly I doubt that this was the root cause - it is more likely that queries were taking too long to process etc and the connections to CF were filling up not the connections to SQL Server. -Original Message- From: J.J.

RE: Jrun connection closing for no reason

2005-06-30 Thread Robertson-Ravo, Neil (RX)
To make it clearer - CF was accepting more and more request but could not close them as there was some rogue connection / query going on. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 30 June 2005 12:49 To: CF-Talk Subject: RE: Jrun connection

Re: Fusebox Methadology Question

2005-06-30 Thread S . Isaac Dealey
On 6/29/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: (forgive me if I mangle the XML, I haven't been working with FB recently) fuseaction name=x set variable=request.FA value=someFuseAction / do action=#request.FA# / /fuseaction do is a compile-time construct so

Re: cachedwithin issues

2005-06-30 Thread S . Isaac Dealey
I've set this up on our site and I've noticed some weird behaviour with it. (*) Users performing different queries are getting the same results. ( Ie. I do a search for 'c++' which returns 100 records. Another user does an any any search and gets back the same records. ( btw the any any

Re: Spectra 1.5.3, cftransaction and security tags

2005-06-30 Thread S . Isaac Dealey
snip And it's a known bugs, in Spectra 1.5.3 : Macromedia Spectra 1.5.3 uses a database connection within ColdFusion MX to call the security tags. Because of this, the cftransaction tag may fail with multiple database errors. snip I have to use this 2 differents datasources aname (CODB

Debugging in CFMX7

2005-06-30 Thread Smith, Daron [PA]
It seems that in CFMX7 especially, using functions, when there is an error, I get the standard IIS 'HTTP 500 - Internal server error page' rather than a CF error page. Is there a setting or something else that will allow me to see what's causing the errors? Thanks, Daron Smith

Re: Debugging in CFMX7

2005-06-30 Thread S . Isaac Dealey
It seems that in CFMX7 especially, using functions, when there is an error, I get the standard IIS 'HTTP 500 - Internal server error page' rather than a CF error page. Is there a setting or something else that will allow me to see what's causing the errors? An error that causes the IIS

Re: Jrun connection closing for no reason

2005-06-30 Thread J.J. Merrick
yeah that's what I meant... I should learn not to respond to email before 8:00 am :-) J.J. Merrick Robertson-Ravo, Neil (RX) wrote: To make it clearer - CF was accepting more and more request but could not close them as there was some rogue connection / query going on. -Original

CFDOCUMENT only works once

2005-06-30 Thread Scott Wolf
I'm having a really bizarre problem with using CFDOCUMENT to create a PDF file. When I first re-start my ColdFusion server, I can successfully visit my page and generate my PDF, but only one time. Every time I try after that, IE just keeps waiting for a response and never seems to get one. Any

Re: Fusebox Methadology Question

2005-06-30 Thread J.J. Merrick
What? Ontap guy looking at Fusebox? :-) I live in Nashville and can't wait to hear you at our user group tonight! J.J. Merrick S. Isaac Dealey wrote: On 6/29/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: (forgive me if I mangle the XML, I haven't been working with FB recently) fuseaction

Re: Fusebox Methadology Question

2005-06-30 Thread S . Isaac Dealey
What? Ontap guy looking at Fusebox? :-) Yep. :) I'm sure there are a lot of folks who perceive me as being somewhat bigotted with regard to frameworks (because I'm so passionate about my work and my comments on the mailing lists often don't come across quite the way I intend), but I really do

Re: cachedwithin issues

2005-06-30 Thread Aaron Rouse
I believe that cachedwithin will cach the query by its name assignment regardless of any SQL changes you might do to it. Or are you saying you have the same query name on multiple pages that is cached on all pages but the SQL is different between those? I have never tested to see if that would

RE: Bind Expressions in repeated CFForm pages

2005-06-30 Thread Mike Nimer
Try this. label=3D{q_thequery.currentItem.col1} {q_thequery.currentItem.col3} ---nimer -Original Message- From: Chris Velevitch [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 28, 2005 11:12 PM To: CF-Talk Subject: Bind Expressions in repeated CFForm pages In CFMX 7 using flash forms,I

RE: AutoTab Through Forms?

2005-06-30 Thread Mike Nimer
ColdFusion 7 has a new mask attribute for cfinput. So you can place the / in as needed cfinput type=text mask=99/99/ As for auto tab, the html tabIndex property of the form fields should let you define which order you can tab through a form. ---nimer -Original Message- From:

Re: Debugging in CFMX7

2005-06-30 Thread Paul Stewart
Dont know if its a CF7 prob i had it with earlier versions. Are you using IE? If so turn off show friendly HTTP error messages in tools - internet options - adavanced, or try Firefox. Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com - Original Message - From:

FTP ListDir not working in 7?

2005-06-30 Thread Scott Brady
We have an automated script that ftps into a company's server to regularly get a spreadsheet so we can import new data. However, since we upgraded to CF7, it's not seeing any files in the directory. I've manually ftp-ed into the server and am able to see the file. This was working fine in 6.1.

More weird HOF list problems

2005-06-30 Thread James Holmes
It seems that a few hours ago I stopped getting any of my HOF lists mail at my gmail account. The only stuff I'm getting now is CF-Talk, to my other (old) email addy. I changed my settings many days ago to leave just my gmail account in the HOF profile, so I'm not sure what's up. Does anyone have

Congressional Contact Info

2005-06-30 Thread Scott Mulholland
Anyone know of any existing public resources for congressional contact information (preferably email addresses)? Ideally some sort of feed or export. Thanks, Scott --- [This E-mail scanned for viruses by Declude Virus. Service provided by Accurate Imaging, Inc.]

RE: CFDOCUMENT only works once

2005-06-30 Thread Mike Klostermeyer
Scott, It's a little fuzzy now, but we had a problem with CFDocument initially after upgrading to 7. We resolved it by removing the other JVM(s) that were installed before the install of 7, then specifically installing the version CF 7 required (if it wasn't done already). Has worked flawlessly

RE: Congressional Contact Info

2005-06-30 Thread Jim Davis
Thomas is still probably the most complete: http://thomas.loc.gov/ I'm not sure about feeds... but it's definitely got everything. Jim Davis ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket

Re: Debugging in CFMX7

2005-06-30 Thread Douglas Knudsen
also, if using IE, make sure you have 'show friendly error HTTP messages' set to off. DK On 6/30/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: It seems that in CFMX7 especially, using functions, when there is an error, I get the standard IIS 'HTTP 500 - Internal server error page'

RE: CFDOCUMENT only works once

2005-06-30 Thread Scott Wolf
There is only one version of the JVM installed on that server: 1.4.2_05-b04 From what I can find, that version should work with what I'm trying to do. -Scott -Original Message- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: Thursday, June 30, 2005 12:46 PM To: CF-Talk

Re: cachedwithin issues

2005-06-30 Thread Douglas Knudsen
oddness! I do not see the original post of this thread, only the reply. Maybe the server is hanging out at CFUnited :( lol CF uses three pieces of information to identify a cached query. 1) the name attribute in CFQUERY 2) the datasource attribute in CFQUERY 3) the SQL as Isaac mentioned,

CFMX7 Integration with J2EE - How complete is the integration?

2005-06-30 Thread Mosh Teitelbaum
All: I have a client that, for reasons that much matter, wants to move one of their CF apps to a J2EE server (running BEA WebLogic). The server's administrator is adamant that only pure J2EE applications may be deployed on this server. My understanding of CFMX7's capabilities with this respect

RE: CFMX7 Integration with J2EE - How complete is the integration?

2005-06-30 Thread Dawson, Michael
From what I understand, CFMX implemented on J2EE is an application. Not only does it contain your .cfm page code, but it includes the entire environment to run the pages. Just tell your admin it is a true application. Tell him not to be a CFMX hater. M!ke -Original Message- From: Mosh

weird coldfuson errors

2005-06-30 Thread Russ
We've been getting weird errors in our sites. I just can't explain it.. If this was a previous version of coldfusion I would've guessed some problem with locking, but from what I've read, you don't need to lock anymore as much in MX. We have a few pages that consistently show up in error logs

Best practices for CFMX 6.1 to CFMX 7 Standard Upgrade

2005-06-30 Thread Rey Bango
I need to upgrade a client from CFMX 6.1 to CFMX 7. Can someone point me to a good upgrade article or perhaps lend some insight into the best approach for doing the upgrade? I'm very interested in how to preserve the 6.1 settings and carry them over to CFMX 7 (car file perhaps). Should I have

Embedded urls in CFGRID

2005-06-30 Thread SStewart
Im using cfform to create a tabbed interface based in flash. Within the first tab I have a CFgrid (also in flash) can I embed a url, such that if someone clicks on the value in the grid field it will take them to another page based on that field/ I hope this makes sense. sas Scott A.

RE: CFMX7 Integration with J2EE - How complete is the integration?

2005-06-30 Thread Jim Davis
-Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Thursday, June 30, 2005 2:18 PM To: CF-Talk Subject: CFMX7 Integration with J2EE - How complete is the integration? All: I have a client that, for reasons that much matter, wants to move one of their CF

CFMX7 Integration with J2EE - How complete is the integration?

2005-06-30 Thread Robert Munn
Technically, I believe your client's admin is correct. Take a look at this page on installing CFMX 7 in J2EE mode with WebLogic. http://www.macromedia.com/support/coldfusion/j2ee/cfmx7j2ee_weblogic_deploy.html One component of ColdFusion is a J2EE servlet application that compiles CFML into

ODBC Error Code = S1C00 (Driver not capable)

2005-06-30 Thread Brian Holder
what do you make of this... ODBC Error Code = S1C00 (Driver not capable) [Microsoft][ODBC SQL Server Driver]Optional feature not implemented error when i try exectuting a stored procedure with an odbc sql server driver for the dsn. sql server 2000, cf5, btw the dsn is verifiable and will

Re: URLDecode and %space

2005-06-30 Thread Scott Brady
On 6/21/05, Ian Skinner [EMAIL PROTECTED] wrote: What's in the UDF? Most of the time, a well written UDF is not that hard to figure out. Now if it is several hundred lines long, it probably is not a well written UDF, possible but not likely. It's actually only that one line of the UDF that

RE: Server names

2005-06-30 Thread Hugo Ahlenius
My machines at home are named after cheeses, I am typing this on Stilton (my laptop), then there is Parmesan, Portsalut, Ricotta and Gorgonzola. The office machines are named after Moomin characters (finnish childrens/adult book) -- Hattifnatt, Hemul, Mumin, Filifjonkan, Sniff, Pappan. I think it

Re: FTP ListDir not working in 7?

2005-06-30 Thread Scott Brady
Here's a follow-up, in case anyone has any ideas. I tried putting another file on the server (in this case, a .cfm file, because putting up a .txt file or a .csv file for some reason causes CF to throw an error on the ftp page). Now, when I run our file, CF can see the .cfm file I put up, but

RE: CFMX7 Integration with J2EE - How complete is the integration?

2005-06-30 Thread Mosh Teitelbaum
All: Thanks for the replies. I don't think the admin is a CFMX hater, just someone who has enough on his hands managing their WebLogic boxes without having to learn another management interface (the CF Admin). And, as someone who wishes he had more free time on his hands, I can't find fault

OT: count() within a larger query

2005-06-30 Thread Damien McKenna
Back to basics for me. I've got a generic products / category table relationship, products lists the category_id, name, etc, while categories includes the id, its name, etc. I'd like to be able to list the categories and the number of products that are in that category, all in one query if

Re: OT: count() within a larger query

2005-06-30 Thread Greg Morphis
select p.name, count(*) from products p, category c where c.id = p.id group by p.name On 6/30/05, Damien McKenna [EMAIL PROTECTED] wrote: Back to basics for me. I've got a generic products / category table relationship, products lists the category_id, name, etc, while categories includes

Best practices for CFMX 6.1 to CFMX 7 Standard Upgrade

2005-06-30 Thread Robert Munn
Are you upgrading Pro or Enterprise? If you are upgrading Enterprise, you can use the Archive and Deploy features as you suggested. I did it with a couple of systems, one of which had six separate server instances on it. Just go into the CF Admin for each instance, export all of the settings

RE: weird coldfuson errors

2005-06-30 Thread Dan G. Switzer, II
Russ, We've been getting weird errors in our sites. I just can't explain it.. If this was a previous version of coldfusion I would've guessed some problem with locking, but from what I've read, you don't need to lock anymore as much in MX. This error might be caused if the query is returning

Help with syntax

2005-06-30 Thread Kevin Rosenthal
Hi everyone, I got my grid to work but the syntax of the line of code is a little out of my understanding. Can someone break down what each part of this is doing so I can understand what is going on? Here is the line of code: cfinput type=text name=firstname label=First

RE: OT: count() within a larger query

2005-06-30 Thread Damien McKenna
select p.name, count(*) from products p, category c where c.id = p.id group by p.name Ah-ha, GROUP BY, that's what I was forgetting. Thanks, Greg! -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h

Re: print to pdf

2005-06-30 Thread dan martin
hmmm, silly me. The macromedia documentation clearly states that cfdocument does not support cfchart. But, yes, you are right, the cfdocument does indeed work with cfchart, atleast for the limited testing I did. A mistake in the documentation? but cfdocument does support images does it not?

Delete spaces inside form fields vars

2005-06-30 Thread Michel Deloux
Hi all I need to delete all spaces between words inside form fields. Please look this simple code included in application.cfm: !--- FORM structure exists and haves content--- cfif NOT isEmpty(FORM) cfoutput cfloop list=#form.fieldnames# index=i !---update all form fields with spaces for your

RE: Delete spaces inside form fields vars

2005-06-30 Thread Matthew Walker
You seem to be asking for all spaces in submitted values to be removed, yet your code seems to be changing all double-spaces to single spaces. What exactly do you want? Also, your syntax is a bit confusing. I'd write what you have as follows: cfloop collection=#form# item=field cfset

Re: Farcry

2005-06-30 Thread Geoff Bowers
On 6/17/05, Eric J. Hoffman [EMAIL PROTECTED] wrote: Anyone know what happened to the FarCry CMS site...hadn't been there for awhile but have a CMS need now that doesn't support a CommonSpot budget. We had a hard drive crash (unrecoverable) and a less than satisfactory backup -- we're on the

Re: OT: count() within a larger query

2005-06-30 Thread Greg Morphis
You're welcome :) On 6/30/05, Damien McKenna [EMAIL PROTECTED] wrote: select p.name, count(*) from products p, category c where c.id = p.id group by p.name Ah-ha, GROUP BY, that's what I was forgetting. Thanks, Greg! -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu

Re: Best practices for CFMX 6.1 to CFMX 7 Standard Upgrade

2005-06-30 Thread Rey Bango
Rob, I'm installing Standard. Any advice on that? Rey... Robert Munn wrote: Are you upgrading Pro or Enterprise? If you are upgrading Enterprise, you can use the Archive and Deploy features as you suggested. I did it with a couple of systems, one of which had six separate server instances

RE: weird coldfuson errors

2005-06-30 Thread Russ
Nothing is being passed in random... The query should always return a record... I am using the same exact url on reload. I'm thinking maybe it's a memory issue. I'm going to have crystaltech replace the memory and see if it helps. -Original Message- From: Dan G. Switzer, II

Phone interviews

2005-06-30 Thread Mark Holm
Is it common now for a company to say they will call for a phone interview but not give a time. Then not call on the day they say they would. 2 days later I get an email saying it has been reschedule for another day with no clue to the time? In the past all phone interview I've had were for

Re: Phone interviews

2005-06-30 Thread S . Isaac Dealey
Is it common now for a company to say they will call for a phone interview but not give a time. Then not call on the day they say they would. 2 days later I get an email saying it has been reschedule for another day with no clue to the time? In the past all phone interview I've had were for