Re: inserting a structure...within a structure...within a structure

2008-11-11 Thread Jason Fisher
A little OT, but you can save some keystrokes with proper use of the '#' symbol. Safer to lose the internal reference to the query inside the loop, too: cfquery name=cats datasource=#Application.DSN# snip .. /cfquery cfloop query=cats cfif NOT StructKeyExists(allcats, category)

RE: inserting a structure...within a structure...within a structure

2008-11-11 Thread Dave Francis
Just to clarify ... Are you saying that within a CFOUTPUT or CFLOOP, CF changes its order of precedence and looks for query. scoped variables first? ie. cfset x=acfoutput query=abc#x#/cfoutput will give abc.x rather than the local variable x? -Original Message- From: Jason Fisher

RE: inserting a structure...within a structure...within a structure

2008-11-11 Thread Adrian Lynch
Yup, that's the case. Adrian -Original Message- From: Dave Francis Sent: 11 November 2008 14:24 To: cf-talk Subject: RE: inserting a structure...within a structure...within a structure Just to clarify ... Are you saying that within a CFOUTPUT or CFLOOP, CF changes its order of

RE: inserting a structure...within a structure...within a structure

2008-11-11 Thread Jason Fisher
Yes, that is how I have always understood it. CF does not go digging through variables, form, url, etc first when inside a query loop. From: Dave Francis [EMAIL PROTECTED] Sent: Tuesday, November 11, 2008 9:24 AM To: cf-talk cf-talk@houseoffusion.com

RE: inserting a structure...within a structure...within a structure

2008-11-11 Thread Jason Fisher
No, sorry don't have any code. Haven't run into the situation for many years now, since I've been leaving my internal refs off since 4.5 ... Jason From: Adrian Lynch [EMAIL PROTECTED] Sent: Tuesday, November 11, 2008 9:12 AM To: cf-talk

Re: Coldfusion +Ajax, best route?

2008-11-11 Thread Massimo Foti
I've read that jQuery is also included in Dreamweaver CS4. Can anyone confirm this? Some facts: - DW CS 4 offers some intellisense for JavaScript. Not up to Aptana, but better than nothing. Of course this should work with all the major frameworks/libraries out there, including jQuery. - The

Re: Coldfusion +Ajax, best route?

2008-11-11 Thread Massimo Foti
Confirmed: From Adobe website re: Dreamweaver Write JavaScript more efficiently with improved support for JavaScript core objects and primitive data types. Put the extended coding functionality of Dreamweaver CS4 to work by incorporating popular JavaScript frameworks, including jQuery,

Re: inserting a structure...within a structure...within a structure

2008-11-11 Thread Peter Boughton
I've never seen myQuery.myColumn inside a query loop not return what it should. Got some sample code? Below is some sample code - it shows the problem with CF7 (haven't tested it with anything else). Note, as you will see, this bug(?) means that with nested queries you should *fully* scope the

Re: Rember DOS?

2008-11-11 Thread Tom Chiverton
On Saturday 08 Nov 2008, Don L wrote: I'm having a hard time with some string manipulation with DOS for the last half an hour or so including googling to no avail. Save yourself the trouble and install the GNU tools. -- Tom Chiverton Helping to continually transform supply-chains

Re: inserting a structure...within a structure...within a structure

2008-11-11 Thread Azadi Saryev
so, then, VARIABLEs scope var inside a query cfoutput/cfloop should always be scoped as variables.var, right, to save cf some processing (as well as to avoid any possible inadvertent var mix-up)? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Jason Fisher wrote: Yes, that is how I have

Re: cfdumperror: unexpected constant #1 83

2008-11-11 Thread Azadi Saryev
look here: http://www.macromedia.com/support/coldfusion/releasenotes/mx/knownissues_mx_j2ee_p2.html and here: http://www.talkingtree.com/blog/index.cfm?mode=entryentry=B11F99A1-45A6-2844-7E6E11C8B765E19B and, of course, here: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:47947

cfdumperror: unexpected constant #1 83

2008-11-11 Thread Marco de l'Isle
Since yesterday suddenly all CFDUMPs return the following error structure. Error Occurred While Processing Requestunexpected constant #1 83 Nothing was changed in the admin section. Any ideas on how to solve this issue, use this for all debugging ;-) Detailed error msg below. Error

Passing zipcode as string as struct ... still converts to numeric and trims leading 0

2008-11-11 Thread Jeremy Keith
I'm loading a form from a cfc, one of those fields is zipcode which up here mostly contain a leading 0. The db object is varchar, and short of checking the string length upon return and padding the 0 if it's only has a lenth of 4, is there any way to force the struct data type to a string

Re: Passing zipcode as string as struct ... still converts to numeric and trims leading 0

2008-11-11 Thread Azadi Saryev
Charlie Griefer wrote: CF is typeless, so all simple values are essentially Strings. If the datatype in the db is varchar, you shouldn't be losing the leading 0. You might want to elaborate on the process you're using and identify exactly where you're losing that 0. there is a catch

Re: Passing zipcode as string as struct ... still converts to numeric and trims leading 0

2008-11-11 Thread Charlie Griefer
On Tue, Nov 11, 2008 at 9:48 AM, Azadi Saryev [EMAIL PROTECTED] wrote: Charlie Griefer wrote: CF is typeless, so all simple values are essentially Strings. If the datatype in the db is varchar, you shouldn't be losing the leading 0. You might want to elaborate on the process you're

Re: cfdumperror: unexpected constant #1 83

2008-11-11 Thread Rob Parkhill
shouldn't you wrap your cfdump var with #'s as follows? cfdump var=#glDataArray# unless it is in a cfoutput? Just thinking that might be the issue? Rob On Tue, Nov 11, 2008 at 10:53 AM, Marco de l'Isle [EMAIL PROTECTED] wrote: Since yesterday suddenly all CFDUMPs return the following error

Re: inserting a structure...within a structure...within a structure

2008-11-11 Thread Jason Fisher
1) Main thing is that you don't need it, because you're already in the query 'scope' inside a CFOUTPUT or CFLOOP 2) If you do a cfoutput#cats.category#/cfoutput on its own, it pulls the first record, as though it were cats.category[1]. By putting cfoutput query=cats#cats.category#/cfoutput

RE: Coldfusion +Ajax, best route?

2008-11-11 Thread Andy Matthews
My personal opinion is that you should use jQuery. It's a heck of a lot lighter than any of the built-in components shipping with ColdFusion. But my answer to you is to use what's best for your project. andy -Original Message- From: Don [mailto:[EMAIL PROTECTED] Sent: Monday,

RE: inserting a structure...within a structure...within a structure

2008-11-11 Thread Gaulin, Mark
IMHO... Tip #1 (drop the unneeded #'s) is good. Tip #2 (drop the query name within the loop) is very, very bad. Why? Because from reading the code it isn't clear where those unscoped values are coming from. You might as well tell people not to explicitly reference the url, form, attributes,

Dynamic Documents...

2008-11-11 Thread Neal Bailey
Hello everyone... I have a question... I have been given the task to take word documents and make them have dynamic fields. What my client wants to do is have all the blank underline areas for example where you would sign your name or fill in your address, filed out on the web, then saved,

Going out on a limb...

2008-11-11 Thread jonese
Anyone out there got some free time and just dying to code something? I've got a freelance / non profit (as in free) project i'm working on and i'm finding i'm just overwhelmed with a lot of the administrative stuff. I've got no time to focus on the code and actually code this bad boy out. I've

re: Dynamic Documents...

2008-11-11 Thread Jason Fisher
Look at Adobe Acrobat Professional: create PDF forms that can be filled in and saved / printed with the user data in place. If you need more robust form handling, look at Adobe LiveCycle Forms. From: Neal Bailey [EMAIL PROTECTED] Sent: Tuesday,

Re: Going out on a limb...

2008-11-11 Thread Phillip M. Vector
So.. Is this position non-pay? I saw the As in free comment and I just wanted to clarify. jonese wrote: Anyone out there got some free time and just dying to code something? I've got a freelance / non profit (as in free) project i'm working on and i'm finding i'm just overwhelmed with a lot

Re: Going out on a limb...

2008-11-11 Thread jonese
Yea this is totally free work. I have zero budget and have already invested a ton of capital just on the domain name and some other stuff. So yes i am looking for those of you who have the time, and don't need or desire the money. That's not to say that maybe someday i'll be able to repay you,

Re: Going out on a limb...

2008-11-11 Thread Phillip M. Vector
Whenever someone asks me about taking on some free work, I always answer, Good, Fast, Cheap. Pick 2. Just saying.. :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: Going out on a limb...

2008-11-11 Thread jonese
LOL love it Phillip and i'm much the same way. The beauty of this is i'm not looking for much. I just need to get the proof of concept going. Nothing pretty at all, nothing fancy (ie no ajax, flash etc) just simple pages with data input and data output. Once this is done and i have something to

Re: Going out on a limb...

2008-11-11 Thread Wil Genovese
Erik, What type of site is this? I have done free work for some religious sites and I and the owner of Christianmp3.com and understand the zero budget situation. Also, any chance that stuff in RIAForge would just plug in and work for their needs? Wil Genovese Sr. Web Application Developer

Re: Going out on a limb...

2008-11-11 Thread jonese
Wil, Responding to you privately... ___ Eric Jones aka jonese http://www.jonese.us http://twitter.com/jonese On Tue, Nov 11, 2008 at 4:02 PM, Wil Genovese [EMAIL PROTECTED] wrote: Erik, What type of site is this? I have done free work for some religious sites and I and the

RE: inserting a structure...within a structure...within a structure

2008-11-11 Thread Adrian Lynch
Why safer to lose the query ref? Adrian -Original Message- From: Jason Fisher [mailto:[EMAIL PROTECTED] Sent: 11 November 2008 13:38 To: cf-talk Subject: Re: inserting a structure...within a structure...within a structure A little OT, but you can save some keystrokes with proper use of

Re: Passing zipcode as string as struct ... still converts to numeric and trims leading 0

2008-11-11 Thread Azadi Saryev
what type of struct are you talking about here? a query resultset? a structure? doing any QoQ in your cfc? when you say i am loading a from from a cfc i presume you are talking about form's default values? where exactly are they coming from - direct db query, or a QoQ, or a querynew() or a manual

RE: Coldfusion +Ajax, best route?

2008-11-11 Thread Andy Matthews
I've read that jQuery is also included in Dreamweaver CS4. Can anyone confirm this? andy -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2008 7:27 PM To: cf-talk Subject: Re: Coldfusion +Ajax, best route? +1 to what Charlie said. As far as

Re: Passing zipcode as string as struct ... still converts to numeric and trims leading 0

2008-11-11 Thread Charlie Griefer
On Tue, Nov 11, 2008 at 8:30 AM, Jeremy Keith [EMAIL PROTECTED]wrote: I'm loading a form from a cfc, one of those fields is zipcode which up here mostly contain a leading 0. The db object is varchar, and short of checking the string length upon return and padding the 0 if it's only has a

ColdFusion + SVNkit

2008-11-11 Thread Kamru Miah
Has anyone used the SVNkit (http://svnkit.com/) and can advise me how to interface ColdFusion (to obtain log messages from Subversion)? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get

RE: inserting a structure...within a structure...within a structure

2008-11-11 Thread Adrian Lynch
I've never seen myQuery.myColumn inside a query loop not return what it should. Got some sample code? I know there was a bug a while ago (might still be with us) with nested loops and having to set a variable in the outer to be able to reference it in the inner but I'm not sure it applies here.

Re: Coldfusion +Ajax, best route?

2008-11-11 Thread Rob Parkhill
Confirmed: From Adobe website re: Dreamweaver Write JavaScript more efficiently with improved support for JavaScript core objects and primitive data types. Put the extended coding functionality of Dreamweaver CS4 to work by incorporating popular JavaScript frameworks, including jQuery, Prototype,

Re: Going out on a limb...

2008-11-11 Thread s. isaac dealey
Anyone out there got some free time and just dying to code something? Well I've got plenty of my own projects keeping me busy, however, given what you've described, I could probably hammer something out in a pretty short time. That is of course asuming that you're okay with whatever frameworks I

StructKeyExists() + dynamic names

2008-11-11 Thread Won Lee
We just upgraded from 7 to 8 and I'm getting some unexpected behavior with StructKeyExists. I'm pretty sure this worked before: cfif structkeyexists(arguments.myStruct,'dp' daypartID 'max')../cfif Now this always resolves to false no matter what. I can forward the CFDUMP of

Input more the one value

2008-11-11 Thread Alonso Viela
Hello I'm new in coldfusion and I try to create a input form, but instead I use a regular cfselect or select, I need to use table o grid to input some amount. the product type change according SQL table The main idea is input all prodcut for company in one time Any Advise Prod1 Prod2

Re: StructKeyExists() + dynamic names

2008-11-11 Thread Charlie Griefer
On Tue, Nov 11, 2008 at 2:31 PM, Won Lee [EMAIL PROTECTED] wrote: We just upgraded from 7 to 8 and I'm getting some unexpected behavior with StructKeyExists. I'm pretty sure this worked before: cfif structkeyexists(arguments.myStruct,'dp' daypartID 'max')../cfif

Re: StructKeyExists() + dynamic names

2008-11-11 Thread Won Lee
structKeyExists(arguments.myStruct, variables['dp' daypartID 'max']) not sure i'd have expected the syntax you used to work (at least, not without an evaluate()). don't have any older versions available to test on tho. Bah sorry I posted this. My Co-worker came back and said the output was

Re: Dynamic Documents...

2008-11-11 Thread Al Musella, DPM
I do something similar but in a bizarre way.. I set up the word documents as mail merge templates. The website saves the data in a text file, then you open the word document, it reads in the data file and puts the information in the correct place At 02:48 PM 11/11/2008, you wrote: Hello

Re: StructKeyExists() + dynamic names

2008-11-11 Thread James Holmes
StructKeyExists takes a String as its second argument. 'dp' daypartID 'max' is a legitimate string. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2008/11/12 Charlie Griefer [EMAIL PROTECTED]: On Tue, Nov 11, 2008 at 2:31 PM, Won Lee [EMAIL PROTECTED] wrote:

Removing an Access database lock

2008-11-11 Thread Pete Ruckelshaus
I'm having trouble removing a lock file (.ldb) from an MS Access 2003 database file that I'm using for a data import (it's actually linked to a text file). I had to tweak the DB a little and need to upload the new version to my server, but the ldb file is preventing that. I've run a bad SQL query

Cfimage captcha wierd error message

2008-11-11 Thread Joel Richards
I'm using cfimage to generate a captcha. My script works great locally, but chokes on my shared hosting account at Hostmysite. I keep getting java.lang.IllegalStateException: Timer already cancelled. errors. Here is a stripped down version of my code: cfCaptchaProxy.cfc: cffunction

Re: Removing an Access database lock

2008-11-11 Thread Jason Fisher
May be held open by any processes accessing it. In other words, you can't delete the .ldb file until it's no longer in use. Can you delete / recreate the DSN? That might at least work to drop open connections ... I'm having trouble removing a lock file (.ldb) from an MS Access 2003

Re: Removing an Access database lock

2008-11-11 Thread Gerald Guido
Ahhh. It has been years since I seen that one. This used to work back in the CF 5 days... Just run a query with an error in it. EX: cfquery etc... SELARCT * From MyTable /cfquery HTH G On Tue, Nov 11, 2008 at 8:31 PM, Pete Ruckelshaus [EMAIL PROTECTED]wrote: I'm having trouble removing

Re: Removing an Access database lock

2008-11-11 Thread Gerald Guido
NEver mind I should read the whole post... My bad. G On Tue, Nov 11, 2008 at 9:34 PM, Gerald Guido [EMAIL PROTECTED]wrote: Ahhh. It has been years since I seen that one. This used to work back in the CF 5 days... Just run a query with an error in it. EX: cfquery etc... SELARCT *

Re: Rember DOS?

2008-11-11 Thread Don L
Save yourself the trouble and install the GNU tools. -- Tom Chiverton Helping to continually transform supply-chains Thanks for the pointer. My need is similar to advanced DOS programming, do you happen to know which GNU package may fit the bill?

Re: Removing an Access database lock

2008-11-11 Thread Gerald Guido
If you just need to make changes to the database structure you can use one of the web based DBM tools for Access. I remember using a web based tool written in asp to make changes to the structureto an Access database with out having to download it. I would Google terms like asp, .NET access DBM

Disable cfinput submit processing? How to?

2008-11-11 Thread Gonzo Rock
I have a form with many cfinput tags and it works very well for a number of years. Now I need to add a new ability to the form. I want to add a second submit button that will submit the form but without firing off the cfinput checks. When the new submit button is clicked the routine will accept

Re: Disable cfinput submit processing? How to?

2008-11-11 Thread s. isaac dealey
I think this would work onclick=this.form.onSubmit=null; this.form.submit(); I haven't tested it though -- may get you started. :) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog

Re: Disable cfinput submit processing? How to?

2008-11-11 Thread Gonzo Rock
Thanks isaac! Actually the original submit button has a routine it runs doing other things with the form... the _cf_checkFormName routines from coldfusion run on submit. The form tag in the code gets a onsubmit=return _CF_checkFormName(this) added to it by coldfusion. The new submit button has

Re: Disable cfinput submit processing? How to?

2008-11-11 Thread Brad Wood
Yeah, the CF form validation fires with the onsubmit method of the form, so you aren't going to be able to submit the form without the validation running unless you do something like Ike suggested which involves removing the onsubmit. You would need to put code like what Ike suggested in the

Re: struct/query strange behaviour

2008-11-11 Thread rex
Way to go Railo! Well, even though it's unlikely that a valid SQL query would contain a struct for a row (can it?), inserting a struct into a query variable is allowed. CF looks at the first record of a query variable whenever you reference a column from it outside of a query-looping structure

Re: Disable cfinput submit processing? How to?

2008-11-11 Thread Gonzo Rock
Hi Brad, my bad... What was suggested actually works. First the _cf_checkFormName fires off and displays am Alert dialog... and when the Okay button is clicked the form goes ahead and submits with the unvalidated data... exactly what I need. Not elegant but clearly successful! On Tue, Nov

Re: Disable cfinput submit processing? How to?

2008-11-11 Thread Brad Wood
the $64,000 question is... So how do we get to split the 64 grand? :) ~Brad - Original Message - From: Gonzo Rock [EMAIL PROTECTED] To: cf-talk cf-talk@houseoffusion.com Sent: Tuesday, November 11, 2008 11:55 PM Subject: Re: Disable cfinput submit processing? How to? Hi Brad, my

Re: Disable cfinput submit processing? How to?

2008-11-11 Thread Azadi Saryev
here's a $64,000 answer: use jQuery! tested proof of concept: =testpage.cfm code:= !--- the script below utilizes jQuery ajax features. must have jQuery. --- head script src=path/to/your/jquery.pack.js type=text/javascript/script script type=text/javascript saveform = function(){

Re: Disable cfinput submit processing? How to?

2008-11-11 Thread Gonzo Rock
u... we are going to redistribute it across all 64,000 cftalk members? On Tue, Nov 11, 2008 at 10:01 PM, Brad Wood [EMAIL PROTECTED] wrote: the $64,000 question is... So how do we get to split the 64 grand? :) ~Brad - Original Message - From: Gonzo Rock [EMAIL PROTECTED]

Re: Disable cfinput submit processing? How to?

2008-11-11 Thread Brad Wood
Let me guess, there will be a one dollar processing charge per member to send the payment? :) ~Brad - Original Message - From: Gonzo Rock [EMAIL PROTECTED] To: cf-talk cf-talk@houseoffusion.com Sent: Wednesday, November 12, 2008 12:24 AM Subject: Re: Disable cfinput submit processing?

Re: Disable cfinput submit processing? How to?

2008-11-11 Thread Gonzo Rock
perhaps more... we are re-distributors of the republican kind ;) still exploring Azadi's jQuery techniques... though I don't have jQuery ;-( On Tue, Nov 11, 2008 at 10:28 PM, Brad Wood [EMAIL PROTECTED] wrote: Let me guess, there will be a one dollar processing charge per member to send the

Re: Disable cfinput submit processing? How to?

2008-11-11 Thread Azadi Saryev
download jquery from http://jquery.com include it in your page using script src=path/to/jquery.js/script $.post( String url, Map data, Function callback ) returns XMLHttpRequest - a high-level jQuery ajax POST call. It calls a remote page using an HTTP POST request, without refreshing current