RE: Sending data to Actionpage

2007-10-25 Thread Dale Fraser
Looping over the array and building one or many hidden form fields is perfectly valid. Although doing this with Ajax on CF8 would be fairly easy also. Regards Dale Fraser http://learncf.com -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Friday, 26 October 2007

Re: MySQL Stored Procedure Help!

2007-10-25 Thread Richard White
try this link we found it really useful although we built the database tables slightly different: http://www.dougboude.com/blog/1/2006/06/Recursive-Functions-in-ColdFusion.cfm ~| ColdFusion is delivering applications solutions

Re: Sending data to Actionpage

2007-10-25 Thread Richard White
ok thanks, ok ill give it a go and see what happens! thought id get some advice before attempting it :) thanks Dale ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" n

RE: Sending data to Actionpage

2007-10-25 Thread Dale Fraser
If you use get you will run into limites. If you use post your form with large sets of hidden data will work fine. Regards Dale Fraser http://learncf.com -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Friday, 26 October 2007 10:46 AM To: CF-Talk Subject: Sending

Re: Sending data to Actionpage

2007-10-25 Thread Richard White
thanks charlie, a session variable would be great but of course i am manipulating the data on the client in javascript and by the time i click save - its just getting the data over to the server to store it in a session variable! hmmm not sure what is the best way to do this, i suppose i may ha

Re: MySQL Stored Procedure Help!

2007-10-25 Thread Richard White
We have built several programs that build a tree structure an infinite amount of levels deep. the best way we have found to do it is to have a table that contains all items each with a unique reference. for example with 2 columns folderId and folderName; Then have another table called folderch

Re: Sending data to Actionpage

2007-10-25 Thread Charlie Griefer
On 10/25/07, Richard White <[EMAIL PROTECTED]> wrote: > i would like each hidden input field to store an array of data then send it > to the actionpage if you're referring to a true array, you can't store it in a hidden field (not without serializing it into a string via CFWDDX first). how abou

Sending data to Actionpage

2007-10-25 Thread Richard White
Hi, I have a grid of data that is managed by javascript on one of my pages. At the moment i am not looking heavily into Ajax to transfer any data changes to the server but was wondering of the best way to pass the data to the actionpage. when the user clicks save i was thinking that a good way

Re: PAYPAL PRO CFC

2007-10-25 Thread Dan Vega
What code? If you are talking about payflow pro on riaforge I am the creator and would be happy to help, just email me back. On 10/25/07, Elliott Kayne <[EMAIL PROTECTED]> wrote: > > I need someone who has working knowledge of PAYPAL PRO and PAYPAL's CFC > code. If you do please contact me at 570

Re: CFQueryParam apostrophe problem when using SET NOCOUNT

2007-10-25 Thread Janet MacKay
What version are you using? I don't notice the problem with mx 7.0.2 >Why do you have SET NOCOUNT in the first place? The resulset generated by the insert can prevent cfquery from picking up the SELECT @@identity statement. SET NOCOUNT supresses the insert's resulset. Though they should be usi

RE: CFMX 7 - Jrun 100%

2007-10-25 Thread Dave Watts
> does anyone know how i can repair this Verity mess please? Identify the offending document(s) by indexing them serially. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington

RE: CFMX 7 - Jrun 100%

2007-10-25 Thread Jenny Gavin-Wear
sorry .. a bit desperate here .. does anyone know how i can repair this Verity mess please? Thanks -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 25 October 2007 12:14 To: CF-Talk Subject: RE: CFMX 7 - Jrun 100% Back to the drawing board. It is a Verity coll

Re: Deleting Attachments Immediately After CFMAIL

2007-10-25 Thread Nathan Wells
>Nathan, > > >Adobe did this to speed up mass e-mailings that all use a common set of >attachments--which is common when doing bulk mailings. Obviously in this >case there's considerably less disk space used and does speed things up. >However, when you're trying to send dynamically generated conten

RE: CFQueryParam apostrophe problem when using SET NOCOUNT

2007-10-25 Thread Dave Watts
> With this setup, what I noticed was, when I insert an item, > any apostrophes get stripped from string values. However, > when I update the item, the apostrophes stayed put. > Additionally, when I removed everything but the actual > SQL/CFQueryParam code from the insert query, the apostroph

CFQueryParam apostrophe problem when using SET NOCOUNT

2007-10-25 Thread Mosh Teitelbaum
All: I've stumbled onto a strange problem that I'm hoping someone can help out with. I've built a standard CRUD setup, using CFQueryParam tags on the backend. For this particular situation, after adding an item to the database, I need to retrieve the itemID. So, I've setup the query along th

RE: Best regex for this, getting software version numbers

2007-10-25 Thread Andy Matthews
I came up with this: ([a-zA-Z0-9 !]+).?([a-zA-Z0-9]+) Is there a better way to do this? -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 4:27 PM To: CF-Talk Subject: Best regex for this, getting software version numbers I have these str

Re: Best regex for this, getting software version numbers

2007-10-25 Thread Ben Doom
Without testingL ^.*?($|\d+\.\d+) Which is, basically, beginning of string, shortest possible string, (end of string or digits dot digits). --Ben Doom Andy Matthews wrote: > I have these strings: > > Firefox 2.0.0.8 (Firefox 2.0) > > Internet Explorer 7.0 (Internet Explorer 7.0) > > Goog

Re: Deleting Attachments Immediately After CFMAIL

2007-10-25 Thread Ben Doom
Without having tried it, the first thing that springs to mind is to turn off mail spooling. In theory, attaching files should not be that much of a bother. I think you have to add a header specifying filename, MIME header, etc., and you have to add the file as a base-64 encoded block at the en

Best regex for this, getting software version numbers

2007-10-25 Thread Andy Matthews
I have these strings: Firefox 2.0.0.8 (Firefox 2.0) Internet Explorer 7.0 (Internet Explorer 7.0) Googlebot 2.1 (Googlebot 2.1) Yahoo! Slurp (Yahoo! Slurp) etc. I'd like to grab everything up to a second period (if it exists). What I want is in parens next to each string. Anyone have

RE: Deleting Attachments Immediately After CFMAIL

2007-10-25 Thread Dan G. Switzer, II
Nathan, >Is there any way to safely delete files that were attached using a > tag to an email that was generated with the tag? If >you delete the attached file too soon, then the file doesn't get attached >to the email, at best, and at worst, the email fails altogether. > > > > See attached f

PAYPAL PRO CFC

2007-10-25 Thread Elliott Kayne
I need someone who has working knowledge of PAYPAL PRO and PAYPAL's CFC code. If you do please contact me at 570-686-2300 or [EMAIL PROTECTED] ~| Get involved in the latest ColdFusion discussions, product development sharing, a

MySQL Stored Procedure Help!

2007-10-25 Thread Jessica Kennedy
Hey, I have posted a couple of times on getting a hierarchal tree 22 levels deep programmed for an MLM company. My original coding was using too much memory, as I was more or less creating a FILO type structure with several arrays. I have looked over the various methods for displaying hierarch

Deleting Attachments Immediately After CFMAIL

2007-10-25 Thread Nathan Wells
Is there any way to safely delete files that were attached using a tag to an email that was generated with the tag? If you delete the attached file too soon, then the file doesn't get attached to the email, at best, and at worst, the email fails altogether. See attached file, #GetFil

Re: Doctor's appt on Monday

2007-10-25 Thread Michael Dinowitz
This thread has been deleted. Please do not reply to it. Thank you. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/in

RE: Doctor's appt on Monday

2007-10-25 Thread Andy Matthews
Just a minor procedure guysa little back hair removal. Strictly outpatient. -Original Message- From: Chris Jordan [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 3:05 PM To: CF-Talk Subject: Re: Doctor's appt on Monday That's good to know, Andy. I hope everything is okay.

Re: Doctor's appt on Monday

2007-10-25 Thread Chris Jordan
That's good to know, Andy. I hope everything is okay. did you intend to send that to the entire CF-Talk list? ;o) Chris On 10/25/07, Andy Matthews <[EMAIL PROTECTED]> wrote: > > Hey Aaron... > > Just wanted to let you know in advance that I have a Drs. appt on Monday > at > 9am. > > _

Doctor's appt on Monday

2007-10-25 Thread Andy Matthews
Hey Aaron... Just wanted to let you know in advance that I have a Drs. appt on Monday at 9am. Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com

I want to re-authenticate the user

2007-10-25 Thread Adalberto Gallardo
The problem is not when the session ends, but when the user enters again to the system after his(her) session ended. The applications shows the login template, the user enter the user name and password and the application (I do not know how) authenticates the user and let him(her) to enter witho

RE: Dual CORE/Quad for CF8

2007-10-25 Thread Jacob
I installed CF8/IIS/2003 R2 on a dual quad core setup with 16GB of RAM just for $h!ts and giggles... CF flies on it. Too bad the system is for my SQL server... -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 7:41 AM To: CF-Talk Subject:

Re: How should SQL handle same named columns from different tables?

2007-10-25 Thread Kris Jones
I get it now. Yes, indeed, how weird. Do you have to use the Unicode driver? Does that make a difference? > It's not a matter of the values, but the column names. Moving an > application from a CF5 server using Microsoft ODBC drivers to a CF8 > server, I found that this 'Access with Unicode' driv

Re: odd caching issue

2007-10-25 Thread Jim Rising
ftp. it turns out that my footer became my header. really odd, because my local copy was correct, but the remote copy had all my header code in it. no idea how that happened. -jim On 10/25/07, Tom Chiverton <[EMAIL PROTECTED]> wrote: > On Thursday 25 Oct 2007, [EMAIL PROTECTED] wrote: > > if i

Re: How should SQL handle same named columns from different tables?

2007-10-25 Thread Jim McAtee
From: "Kris Jones" > In general, it is up to the developer to alias the columns so that > they can be referenced appropriately in such a scenario. I also am not > a fan of the * in queries. And, I wonder, in the example you have > given, why this is an issue, since the values for the columns will

Re: CFZIP and CFINDEX

2007-10-25 Thread Raymond Camden
One thing to not forget (I'm sure you know this), in CF7, Adobe did a major update of the embedded Verity engine, so it would surprise me if it didn't work in the past. On 10/25/07, Dave Watts <[EMAIL PROTECTED]> wrote: > > That's not what I see here. I used cfzip to create a zip. I > > included t

Re: installing CF 5 on Vista

2007-10-25 Thread Christopher Vigliotti
If you get CF 5 working directly in Vista please post a how-to guide! VMWare running an older OS is going to be much easier for you. - Christopher Vigliotti Sr. ColdFusion Developer AboutWeb, LLC http://www.aboutweb.com On 10/25/07, Tom Chiverton <[EMAIL PROTECTED]> wrote: > > On Thursday 25 Oct

Re: Using ColdFusion to determine if user has Flash player?

2007-10-25 Thread Christopher Vigliotti
Another method is to have a flash movie on your first page that redirects users to a second page...if it doesn't redirect them, then flash isn't running. - Christopher Vigliotti Sr. ColdFusion Developer AboutWeb LLC http://www.aboutweb.com On 10/25/07, William Seiter <[EMAIL PROTECTED]> wrote: >

RE: CFZIP and CFINDEX

2007-10-25 Thread Dave Watts
> That's not what I see here. I used cfzip to create a zip. I > included the zip in a collection. When I searched against the > collection, Verity found a match in my zip. I had problems indexing zip files with Verity in the past; I shouldn't have assumed they were never fixed. Dave Watts, CTO,

RE: cfqueryparam and dynamically-created SQL

2007-10-25 Thread Dave Watts
>1. I believe stored procs are generally faster than sending the >same query to SQL Server due to query optimisation(?) The only query optimization that goes on is the building of an execution plan. Using conditional logic in a stored procedure can have very harmful effects on the reusabil

Re: Dual CORE/Quad for CF8

2007-10-25 Thread Nathan Strutz
Yes, they will. IIS and CF are fully multi-threaded. Any web or database server that takes multiple simultaneous requests will certainly take advantage of more than one CPU, even if the CPUs are hardwired together. -- nathan strutz http://www.dopefly.com/ On 10/25/07, Richard Colman <[EMAIL PR

Re: Problem with login in the Application.cfc (saving additional info in the session scope)

2007-10-25 Thread Jon Clausen
Placing the following in the onSessionEnd method should solve the problem: Option B is to persist some cookie data which will re-login the user when the session ends. As a side note, you can also use the name to create a list. The you can use the getAuthUser() as a list and use that

Re: weird message on logs (CF8)

2007-10-25 Thread Jon Clausen
These error messages are being generated when Coldfusion writes the client data to the Windows Registry - a setting which is adjusted in the Client Variables section of the CF Administrator. It could be a permissions issue with Coldfusion writing to the Registry. I did a search for this spe

Re: SeeFusion vs. FusionReactor

2007-10-25 Thread Ben Doom
Regardless, I currently have one instance on one server. So licensing structure isn't a big deal. --Ben Doom DURETTE, STEVEN J (ATTASIAIT) wrote: > Even with that change to the licensing, that still costs more than > Fusion Reactor when you have 6 CF instances on one box. 1 Fusion > Reactor Li

RE: weird message on logs (CF8)

2007-10-25 Thread Peterson, Chris
If it *is* high traffic at all, storing data in the registry could really bork your server. The windows registry does have a size limit, I would set it to cookie (if you are storing only non-secure data that is small) or database if you have a zippy one available. Chris Peterson Gainey IT Adob

Re: error with long form post

2007-10-25 Thread Jon Clausen
Is your form action set to "GET" (or not defined) instead of set to "POST"? If you're getting a "URL too long" error it sounds like your form data/text is being passed in the URL string. Jon On Oct 25, 2007, at 11:00 AM, William Seiter wrote: > I get a error that says url too long. this ap

RE: Using ColdFusion to determine if user has Flash player?

2007-10-25 Thread William Seiter
Andy, Because you are talking about 2 different sides of the 'firewall' Client and Server. You will be restricted to what the browser sent as it's 'identifier' message. I have not looked to see if the user can customize their browser to identify which flash version that they have when they call

Re: CF8 and CFDUMP was: (Re: Coldspring error)

2007-10-25 Thread James Holmes
Mikes' local machine is CF7 and the host is CF8. On 10/25/07, Brian Kotek <[EMAIL PROTECTED]> wrote: > You can dump the bean factory itself just fine (or at least I can). It's > when you try to call getClass() on it that it won't work. Something inside > CFDUMP is trying to call getClass() on the

RE: Using ColdFusion to determine if user has Flash player?

2007-10-25 Thread Andy Matthews
I know that I can use javascript to get those values, but I'm writing a browser detection suite and I'd love to get as much as possible using server-side code. I already have about half of what I need (cookies, timestamp, browser/version, operating system), but Flash is one of the last pieces I'd r

RE: SeeFusion vs. FusionReactor

2007-10-25 Thread DURETTE, STEVEN J (ATTASIAIT)
Even with that change to the licensing, that still costs more than Fusion Reactor when you have 6 CF instances on one box. 1 Fusion Reactor License or 3 SeeFusion licenses. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 3:10 PM To: CF-Talk

RE: error with long form post

2007-10-25 Thread William Seiter
Greg, Can you post the actual error message that you are receiving? Also, what are you doing with the post? Are you placing it into a database? Is that database column setup for text fields of this size? William -- William E. Seiter Have you ever read a book that changed your life? Go to: ww

Re: CF8 and CFDUMP was: (Re: Coldspring error)

2007-10-25 Thread Brian Kotek
You can dump the bean factory itself just fine (or at least I can). It's when you try to call getClass() on it that it won't work. Something inside CFDUMP is trying to call getClass() on the bean factory. Why, I have no idea, but it is, and that's why it's blowing up. If Mike can dump it fine on hi

Dual CORE/Quad for CF8

2007-10-25 Thread Richard Colman
If I am going to run a Web/.NET/CF8 server, will these applications take advantage of dual or quad core processers? Rick Colman ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://

Problem with login in the Application.cfc (saving additional info in the session scope)

2007-10-25 Thread Adalberto Gallardo
hi, I have a bit of a problem, and I know that happens sometimes when the sessi= on expires (and may be have something to do with the application expiration= ). OK this is it: Every time I authenticate an user (this is made by an object created in the= session scope) I create a struct that contain

Re: CF8 CFGRID bind problem on include

2007-10-25 Thread C. Hatton Humphrey
> Not sure if that is showing what it should or not. Like I said, I had > this working when it was a single page with no includes. I use the > Application.cfc onRequestStart and OnRequestEnd to include the header > and footer files. Surely that wouldn't be affecting things? Apparently it does a

Re: odd caching issue

2007-10-25 Thread Tom Chiverton
On Thursday 25 Oct 2007, [EMAIL PROTECTED] wrote: > if i put that code back in, the menu and logo literally will duplicate. How are you editing/uploading changes ? -- Tom Chiverton Helping to confidentially unleash leading-edge e-services on: http://thefalken.livejournal.com ***

Re: error with long form post

2007-10-25 Thread Dean Lawrence
Greg, Make sure your form method is set as "POST" and not "GET". You may have just inadvertantly set it this way (as I think some editors insert the "GET" as a default. Dean On 10/25/07, Greg benson <[EMAIL PROTECTED]> wrote: > Have you ever had a problem with a form post being too long? > > I a

RE: How should SQL handle same named columns from different tables?

2007-10-25 Thread Bobby Hartsfield
You'll have to reference them as alias.columnname or select them with a different alias like... Select a.userID as AuserID, b.userID as BuserID I would say that they are the same in most cases though yes? If so, there's no need to select both at all. -Original Message- From: Jim McAtee [

error with long form post

2007-10-25 Thread Greg benson
Have you ever had a problem with a form post being too long? I am trying to post a form that uses fckeditor to post a large amount of rich text. 5000+ chars. I have also tried this with out fck editor and just a normal textarea and still get the problem. If the chars is small then the post

Re: CF8 CFGRID bind problem on include

2007-10-25 Thread C. Hatton Humphrey
> What does the AJAX debugging window say? It's nothing but INFO's It shows where the CFC is invoked and I see the recordset there. Something does strike me as odd though - The top line is: info: http: CFC invocation response: then it shows the HTML and CFMenu that go above the grid (are there fr

odd caching issue

2007-10-25 Thread Jim Rising
i'm having this really strange caching issue with my application on a cf8 vps... and it doesn't happen on my local at all. for some reason, portions of code that i've commented out entirely, still parse and show up in the browser... and when i put them back in, they actually duplicate in the browse

Re: Lock question

2007-10-25 Thread Rick Root
On 10/25/07, Gaulin, Mark <[EMAIL PROTECTED]> wrote: > > A refinement would be to only lock if the application data was not > defined (so, test for it and return if it is defined) and, within the > lock, to retest for it being defined (just as you have now). The test > within the lock is to avoid a

Re: Lock question

2007-10-25 Thread Tom Chiverton
On Thursday 25 Oct 2007, [EMAIL PROTECTED] wrote: > Yeah, that sounds right. You could add a call to wget (or whatever) the results to your server's start up script too. -- Tom Chiverton Helping to simultaneously conquer enterprise action-items on: http://thefalken.livejournal.com

Re: Lock question

2007-10-25 Thread Mike Chabot
You could have a block of code inside of OnApplicationStart where all the query caching takes place, and put a cflock around that block of code, instead of altering all 55 queries. If the queries are cached OnApplicationStart, I would have high confidence that you wouldn't need to lock them when us

RE: Lock question

2007-10-25 Thread Gaulin, Mark
Yeah, that sounds right. A refinement would be to only lock if the application data was not defined (so, test for it and return if it is defined) and, within the lock, to retest for it being defined (just as you have now). The test within the lock is to avoid a race condition where many clients hi

Lock question

2007-10-25 Thread Rick Root
I have a flex app that uses a single cfc method to populate all of its drop down lists. The method is called getListData It runs 55 queries, and stores the results of those queries in a structure, and returns the structure to Flex. This works great, but it's a performance drag - especially if 10

Re: cfqueryparam and dynamically-created SQL

2007-10-25 Thread Dominic Watson
I totally agree. I like to put code in stored procs for organisational reasons more than performance ones in most cases. However, I was recently updating a site that used dynamic SQL to generate some reports and the performance of this was becoming a huge issue. The logic was so complicated that a

Re: installing CF 5 on Vista

2007-10-25 Thread Tom Chiverton
On Thursday 25 Oct 2007, [EMAIL PROTECTED] wrote: > Hi. I read the posts on installing CF 5 on Vista Any reason not to install on an older Windows box, maybe inside something like VMWare ? -- Tom Chiverton Helping to administratively fashion essential networks on: http://thefalken.livejournal.c

RE: CFMX 7 - Jrun 100%

2007-10-25 Thread Jenny Gavin-Wear
Back to the drawing board. It is a Verity collection indexing process that is causing Jrun to run high. I have it set as a scheduled hourly event. I have two Verity collections, let's call them Site A and Site B. Site A has been up and running for about 2 years. I added Site B last week. Index

RE: cfqueryparam and dynamically-created SQL

2007-10-25 Thread Robert Rawlins - Think Blue
Yep, I think like with queryparam, you have to look outside of the performance benefits when working with stored procedures. The other benefits come when you have very complex queries that are accessed from several locations within an application, or multiple applications, this means not having to

Re: Working with CFGRID

2007-10-25 Thread Anthony Doherty
Thanks for that guys i got it working "eventually!!!" ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?

Re: cfqueryparam and dynamically-created SQL

2007-10-25 Thread Dominic Watson
I whole-heartedly agree and when I get some time I will do some testing. What I imagine to be the case is that the more complex the SQL required, the more likely it is that a stored procedure is beneficial but perhaps this is wrong (it is certainly blind assumption). Regardless of that, I like to

Re: CF8 and CFDUMP was: (Re: Coldspring error)

2007-10-25 Thread Tom Chiverton
On Thursday 25 Oct 2007, [EMAIL PROTECTED] wrote: > I cfdump'ed our application.beanfactory just yesterday, on CF7 on our own servers. It's 'normally' fine. -- Tom Chiverton Helping to heterogeneously maximize bricks-and-clicks data on: http://thefalken.livejournal.com ***

Re: Using ColdFusion to determine if user has Flash player?

2007-10-25 Thread Tom Chiverton
On Thursday 25 Oct 2007, [EMAIL PROTECTED] wrote: > The flash detection kit is the way to go: SWFObject is nicer. -- Tom Chiverton Helping to apprehensively innovate virtual segments on: http://thefalken.livejournal.com This email is sent fo