Re: decrypting a string...using CF 6.1

2006-08-11 Thread Kris Jones
It is simple to fix. You just need to check for content in the variable before trying to decrypt iit. Something like: cfif len(email) gt 0 cfset email = decrypt(email,MLS) /cfif Cheers, Kris Sadly I have no clue. It's not a huge deal...I just thought it would be simple enough to fix.

Re: Sessions seem to go away for some (CFMX701-Linux)

2006-08-09 Thread Kris Jones
If you use CFLOCATION on the same template after a CFCOOKIE set, the cookie will not be set. I've also found this behavior to vary depending on version of CF (works on 4.5, and 5, but not MX6 or MX7). Cheers, Kris We are running a site on CFMX 7.0.1 on Linux, and encountering a very strange

OT: tortoise svn and eclipse

2006-08-08 Thread Kris Jones
Has anyone gotten the TortoiseSVN plugin to work well in Eclipse? I may be confused about my setup (SVN, Eclipse, and Tortoise are all pretty new to me). Here's my issue: On my team we get a lock on a file before we edit, using TortoiseSVN. This works fine from Windows Explorer. Inside Eclipse, I

Re: OT: tortoise svn and eclipse

2006-08-08 Thread Kris Jones
I am using the tabaquismo Tortoise eclipse plugin. But I also have subclipse installed. Maybe that is the problem--a conflict? Or, perhaps I still don't understand which submenu goes with which: In Eclipse, from my filecontext menu, I've got: a Tortoise submenu a Team submenu I've got Lock and

CF Report Builder: accessing the properties via code?

2006-08-07 Thread Kris Jones
Hi all, Does anyone know if/how you can access report element properties through code, rather than through the report builder interface itself? I'm thinking something along the lines of: cfreportparam name=elementname.propertyname value=propertyvalue / so, changing the alignment on a query field

Re: Problem running script against data

2006-08-07 Thread Kris Jones
Hi Ray, I'll bet there is a custom tag already written for this out there somewhere. Take a look around the usual places: adobe developer center, fusionauthority. I'm sure there are others, but I just can't think of them right now. Cheers, Kris I see. Well converting a script of this size and

Re: You know what?

2006-08-06 Thread Kris Jones
There are documented problems with installing/running CF on the new intel Macs. See: http://www.forta.com/blog/index.cfm/2006/7/17/CFMXLauncher-Simplifies-ColdFusion-On-Mac (the comments have helpful discussion) http://webmages.com/cfmxIntelOSXguide.html (CFMX on Intel Macs - The Definitive

Re: Query problem with lists of values

2006-08-04 Thread Kris Jones
but one item has entries of 15,16,30,49,50,52,75 and it is being put in a catecory that has the id of 2 there are lots of these that are behaving this way. any one think of a way to help with this? SELECT catid FROM deep_images WHERE #uid# IN (catid) IN is evil. It will randomly stop

Re: SQL concat? help

2006-08-04 Thread Kris Jones
The syntax you're using is, I think, correlated subquery. Not sure what that concat() function does--maybe that was a UDF that returned an actual list of IDs? In any case, here is a simple join that would return a recordset of related IDs: select s.someid, so.someotherid from mytable s left outer

Re: SQL concat? help

2006-08-04 Thread Kris Jones
In CF, getting a list of values from a column in a query is pretty trivial: valuelist(qryname.colname) Cheers, Kris What I actually wanted was a list of all someotherID's for a someID in a single column. I found a function that sort of does this (Coalesce), and after digging up my old code,

Re: QoQ SQL support.

2006-08-03 Thread Kris Jones
I know for sure that LEFT, RIGHT don't work. I would suspect that most string parsing functions will not work. And, while I haven't tested them, when I posted about this on the forums, I got responses that the following also do not work: -- CASE, DECODE, joins between more than 2 tables, LEFT

SOLUTION: CFReport, IE, and active content problem

2006-08-03 Thread Kris Jones
Finally found an answer to my IE, CFReport, CFC issue. I had narrowed the issue down to occuring only when requesting Flashpaper format. Another hapless soul posted his troubles (and solution) on the forums yesterday. The issue is apparently an IE bug, and only happens when asking for Flash-based

Re: Query problem with lists of values

2006-08-03 Thread Kris Jones
How about: SELECT catid FROM deep_images WHERE #uid# IN (catid) Cheers, Kris but one item has entries of 15,16,30,49,50,52,75 and it is being put in a category that has the id of 2 there are lots of these that are behaving this way. any one think of a way to help with this?

Re: (admin) List Status

2006-08-01 Thread Kris Jones
In Tom's defense, (although I'm sure he can defend himself), some companies auto-append those disclaimers at the mail server. So Tom's sig may only be 1 line--his name. PS - Man, Tom...you've got the longest signature block in history. Takes 2 minutes just to cut that out :o)

Re: Anyone see anything wrong with this code?

2006-07-30 Thread Kris Jones
Seems obvious, but are you sure that the query should return any results? Check your debugging output, grab the SQL that is generated and run it directly on the datasource. Cheers, Kris On 7/30/06, Rick Faircloth [EMAIL PROTECTED] wrote: CFQUERY Name=Get_Clients Datasource=#DSN#

Re: cfdocument images and https

2006-07-28 Thread Kris Jones
These issues are also affecting us on sites that are not using https (just plain old http). So, you are not alone. k, here is what I did. I changed the image links to be fullblown, and with ip address. and it seems to be working. However stylesheet links wouldn't work no matter what I did.

Re: SOT: Flash 9 install?

2006-07-28 Thread Kris Jones
Heh, we have been having this same problem with swf returned from CFREPORT as well. Very frustrating. IE only (works fine in Firefox). Tried removing and reinstalling Flash 9 player. Still no go. Note that this is only happening when the swf is returned from CFC. If we put the CFREPORT directly in

Re: SOT: Flash 9 install?

2006-07-28 Thread Kris Jones
In our scenario, the version is 9. We have no control over the declare since the swf (and, I would guess, the surrounding wrapper) are created by ColdFusion. If you right click on the Flash and choose 'about', what version of the player is it ? Almost all of the machines around here

Re: Sending Email from a valuelist.

2006-07-28 Thread Kris Jones
I think there is a functional difference in the 2 approaches. The valuelist approach sends a single email that goes to everyone in the list (one email in your CFMAIL queue), and all recipients can see the address of all the other recipients. The cfmail query attribute sends a single email to each

Re: Operation must use an updateable query?

2006-07-28 Thread Kris Jones
Are you referencing a view instead of a table? Cheers, Kris On 7/28/06, Jeff Small [EMAIL PROTECTED] wrote: I'm just trying to build a simple insertion. I used the Record Insertion Wizard in Dreamweaver. I'm getting the following error, which I've never gotten. Usually I can whip these things

Re: Odd Query issue

2006-07-26 Thread Kris Jones
Have you tried surrounding the job_id with brackets such that: Update jobs set status=0 where [job_id]=1 Perhaps, and I'm only stabbing in the dark here, job_id becomes a reserved word when submitting certain types of statements to your DBMS (where they might become jobs)? Try it and see.

Re: Generating very large pdf files with cfdocument

2006-07-26 Thread Kris Jones
We've had problems generating any PDFs with cfdocument when there are linked images or css. Doesn't matter the size of the document. Haven't been watching resource hogging with regard to it, but I'd like to hear if you find that is the source of the problem. There was a post here a week or two

CFReport, IE, and active content problem

2006-07-25 Thread Kris Jones
Okay, my earlier post about returning CFReport from a CFC came down to it just not working in IE. Silly me--I work on an IE-only app, so that is the first browser I try these days. I have to kind of float the cursor around to find the place to click to activate--to the user it just looks like a

Re: CFReport, IE, and active content problem

2006-07-25 Thread Kris Jones
I've checked resources at these sites: http://www.adobe.com/devnet/activecontent/ http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/overview/activating_activex.asp By better HTML wrapper do you mean change the way I'm calling the object, e.g., object, vs. embed? Since I am

Re: Return CFReport from CFC?

2006-07-21 Thread Kris Jones
Anybody? I've also tried cfcontent, setting the variable to the returned report. It at least pops the flashpaper viewer, but no report content. What am I doing wrong? Is it possible to return a report generated via CFReport from a CFC? I've tried a couple of different things, and only end-up

Re: Nested output...three levels

2006-07-20 Thread Kris Jones
It looks like you're missing your last cfoutput? Your final detail piece wouldn't use a group attribute on the cfoutput. I'm just guessing at the column name here, but something like this should work: cfoutput query=qGetProcedures group=Procedure1ID#qGetProcedures.Procedure1Title#br cfoutput

<    1   2   3   4