AjaxCFC Debugging

2009-09-28 Thread Andrew McDuff
Hi there, I've got a nasty / dreaded Error executing Database Query error appearing when using AjaxCFC with CF8. Problem is that the code works fine in all of my CFC functions on my local machine but fails on certain functions on the hosted server. In other words, some CFC functions work fine

Using a Listbox to allow Users Access

2009-09-28 Thread Damo Drumm
Hi, I have a drop down list on a form showing a list of Companies, which ive linked to a table called Company, Im trying to use this list to give access for each username, at them min when someones name is added to the Table (Users) they have access to all Companies on the list box, im trying

Re: Using a Listbox to allow Users Access

2009-09-28 Thread Randy Adkins
Depending on how you have your validation structured for permissions, an idea would be: Session.CompanyAccess = '1,2,5,6' Then you can validate it when needed. Now if you are going further to set permissions such as CRUD: Session.CompanyAccess.Permissions_1 = C,R,U,D

Re: Using a Listbox to allow Users Access

2009-09-28 Thread Damo Drumm
Thanks, The first option will suit me so if i set up a field in My Users table called CompanyAccess, then followed by the correct code it will be able to pick out wheather or not I can access it depending which numbers I have entered in my CompanyAccess field Depending on how you have your

RE: AjaxCFC Debugging

2009-09-28 Thread Scott Stewart
Andrew, If you're not using Firefox w/the Firebug plugin, get it, the Net function alone can help tremendously in tracking down CF errors in Ajax calls. Ray Camden has also written a plugin for Firefox called ColdFire which brings CF errors into the Firebug interface. -Original

How to Handle Objects when Doing Several Updates and Once?

2009-09-28 Thread Glyn Jackson
I am trying to work with objects and better understand how to use them. So far it has been straight forward when updating/creating/deleting one record at a time. But I now need to update many records at once is getting a bit tricky. I simplified version of what I am doing so far is below...

Re: selecting different template based on file name

2009-09-28 Thread Tom Chiverton
On Tuesday 22 Sep 2009, Damo Drumm wrote: where IINVOICE_Key = #url.invoice# AND InvoiceTemplateType_Key = 1 /cfquery Use CFQUERYPARAM ! Unless you really want someone putting

Re: How to clear local cache when users logout

2009-09-28 Thread Tom Chiverton
On Thursday 24 Sep 2009, Nathan Chen wrote: How do you clear users' local cache after they log out and the session variable is cleared? I can clear the session on the server, but if users click the Back button, they can still get back and that's not what I want. This must have been discussed

Re: cf_barcode height not working in Firefox:

2009-09-28 Thread Richard White
does anyone have any ideas what may cause this? thanks thanks for your reply, this has sorted out the height issue, although the width has increased significatly (again only in Mozilla but works fine in IE) do you know what would cause this? thanks see if adding

Re: cf_barcode height not working in Firefox:

2009-09-28 Thread Azadi Saryev
did you try specifying a fixed width in the span's style? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 28/09/2009 20:42, Richard White wrote: does anyone have any ideas what may cause this? thanks thanks for your reply, this has sorted out the height issue, although the

javascript / coldfusion ajax communication

2009-09-28 Thread Richard White
hi our client side scripting is in javascript and server side code is coldfusion. our javascript sends string data to coldfusion via url. what is the best way to encode/escape the javascript strings and decode/unescape them in coldfusion thanks richard

Re: Using a Listbox to allow Users Access

2009-09-28 Thread Randy Adkins
Yes, however you will need to validate permissions when needed Ex: CFIF ListFind(Session.companyAccess,thisCompanyID) ... GOOD CFELSE ... BAD /CFIF On Mon, Sep 28, 2009 at 7:14 AM, Damo Drumm damien.dr...@quinn-group.comwrote: Thanks, The first option will suit me so if i set up a field

Re: cf_barcode height not working in Firefox:

2009-09-28 Thread Richard White
we cannot specify a fixed width as it is a barcode feature that has varying widths between all the bars. the full code is as follows: !--- == FILE: barcode39.cfm - Custom tag for Code 39 (3 from

CF9 ORM - Using a mapping for cfclocation?

2009-09-28 Thread Jeff Chastain
Has anybody tried using a mapping or a directory path outside of the web root for the CF9 ORM cfclocation setting? I have tried both a mapping defined in the Application.cfc as well as a full directory path and the components / entities are found on reload as the database schema is built.

RE: cf_barcode height not working in Firefox:

2009-09-28 Thread Josh Nathanson
I used this tag, and I think (this was awhile back) I modified it so instead of using spans, it used table cells (td's). Once I did that I was able to control the width and height across browsers. -- Josh -Original Message- From: Richard White [mailto:rich...@j7is.co.uk] Sent:

Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Robert Kelso
Hi guys, I'm doing a computer forensic investigation on a bad hard drive with Cold Fusion MX7 installed. I'm trying to find out if the installed version is Enterprise or Standard. Is there a way I can determine in the version is Enterprise or Standard just by looking at the files on the

RE: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Mark Kruger
Robert, Find the serial number (in license.properties) and go to an existing CF installation - even one on your dev box - and update the serial number. Then look at the server settings. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com

RE: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread brad
Better yet-- if you have access to the server.log file, crack it open and look at its last restart: Information,main,09/04/09,15:24:12,,Starting logging... Information,main,09/04/09,15:24:12,,Starting license... Information,main,09/04/09,15:24:14,,Enterprise Edition enabled It should tell you

RE: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Mark Kruger
Doh! That is better :) -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] Sent: Monday, September 28, 2009 2:33 PM To: cf-talk Subject: RE: Cold Fusion Enterprise or Standard Installed? Better yet-- if you have access to the server.log file, crack it open and look

Re: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Robert Kelso
Hi Brad, Thanks for that (Thanks to Mark as well). I have looked through the server log but see no reference to either Enterprise or Standard. Do you think the absence of the line Enterprise Edition enabled means that non-Enterprise edition was installed, or could it be something else?

Re: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Robert Kelso
Mark, Since the server.log didn't seem to give me what I was looking for, I started down the road of your idea of replacing the S/N into an existing installation of ColdFusion. Of course, I had no such thing since I am a computer forensics guy, not a developer and I've never used ColdFusion.

RE: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Craig Dudley
I think the 'CED' at the beginning of the serial stands for ColdFusion Enterprise Edition, perhaps not a great idea posting the whole serial though ;-) Anyway, you can prove it by logging into the administration web page and going to the system information page, though I'm not sure if it's

RE: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Mark Kruger
Log into he CF admin (i.e. http://127.0.0.1/cfide/administrator/. On the left hand side under server settings there is a link to settings summary. Click on it and at the top you will see something like the following: Server Product ColdFusion MX Version 7,0,2,142559 Edition Standard

Re: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Robert Kelso
OK guys, that worked perfectly. I've been able to confirm that the serial number belongs to ColdFusion Enterprise Edition. Thanks to all of you for your help! I think the 'CED' at the beginning of the serial stands for ColdFusion Enterprise Edition, perhaps not a great idea posting the

Re: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Ian Skinner
Log into he CF admin (i.e. http://127.0.0.1/cfide/administrator/. On the left hand side under server settings there is a link to settings summary. Click on it and at the top you will see something like the following: Server Product ColdFusion MX Version 7,0,2,142559 Edition Standard

Re: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Robert Kelso
Although I have no Cold Fusion experience, I WAS smart enough to download a trial version of CF7, not CF8. Log into he CF admin (i.e. http://127.0.0.1/cfide/administrator/. On the left hand side under server settings there is a link to settings summary. Click on it and at the top you will

RE: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Mark Kruger
Er Uh Hmmm Good question. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Monday, September 28, 2009 3:41 PM To: cf-talk Subject: Re: Cold Fusion

Re: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Ian Skinner
Robert Kelso wrote: Although I have no Cold Fusion experience, I WAS smart enough to download a trial version of CF7, not CF8. Then you are pretty good indead, because I find Adobe does not make that a very easy option.

SOT aligning multiple lists

2009-09-28 Thread Ian Skinner
I have 6 alphabetical lists, CFML structure key lists but I don't think that matters. These 6 lists have many common keys with each having a few differences. I want to display a table with each list in its own column. I would like it to sort such that common keys align together in the same

Re: SOT aligning multiple lists

2009-09-28 Thread Barney Boisvert
One solution would be to create a master list first, and then loop over it, detecting which lists contain the value and indicating as such. Another would be to iterate over all three lists concurrently, and at each iteration check and see which list (or lists) contains the lowest unprocessed

Scheduled Tasks

2009-09-28 Thread John M Bliss
This is the second time I've seen this: Adobe CF Standard 8,0,1,195765 just declining/forgetting to run some (not all) scheduled tasks. No errors. Just not running. Last time, I installed the latest hot fix(es), rebooted the server, and everything has been fine for 1-2 months. This time, there

Re: SOT aligning multiple lists

2009-09-28 Thread Ian Skinner
Well I came up with one way. |!--- loop over and create master list of unique values by creating a temp structure --- cfset masterList = structNew() cfloop collection=#positions# item=type cfloop list=#structKeyList(positions[type])# index=item cfset masterList[item] = /cfloop

Re: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Dave Watts
I'm doing a computer forensic investigation on a bad hard drive with Cold Fusion MX7 installed.  I'm trying to find out if the installed version is Enterprise or Standard.  Is there a way I can determine in the version is Enterprise or Standard just by looking at the files on the hard

Re: Scheduled Tasks

2009-09-28 Thread Ian Skinner
John M Bliss wrote: This is the second time I've seen this: Adobe CF Standard 8,0,1,195765 just declining/forgetting to run some (not all) scheduled tasks. No errors. Just not running. Last time, I installed the latest hot fix(es), rebooted the server, and everything has been fine for 1-2

Re: Scheduled Tasks

2009-09-28 Thread John M Bliss
Right...but the URL's in question never produce 401 or anything like that when I call them manually... On Mon, Sep 28, 2009 at 4:51 PM, Ian Skinner h...@ilsweb.com wrote: Do you have the scheduled task configured to log the results it gets when it makes the HTTP request? I find these can

Re: AjaxCFC Debugging

2009-09-28 Thread Andrew McDuff
Hi Scott, Thks for the tips. I'm already using Firebug but didn't know about ColdFire. I'm going to install it on my local machine so if I can see CF errors within my CFC's (using AjaxCFC), it'll definitely come in handy. However, I don't think I can get hosting company (CrystalTech in my

RE: AjaxCFC Debugging

2009-09-28 Thread Rick Faircloth
Coldfire sounds interesting, but the lastest thing I see online about it is from early 2008. Is it up-to-date and working well? -Original Message- From: Andrew McDuff [mailto:andy.mcd...@gmail.com] Sent: Monday, September 28, 2009 7:00 PM To: cf-talk Subject: Re: AjaxCFC Debugging

Re: Scheduled Tasks

2009-09-28 Thread William Seiter
sounds like a great reason to follow his advice of creating a log file for the http responses. If its not recreatable, yet you know it happens. -- William E. Seiter Sep 28, 2009 03:53:19 PM, cf-talk@houseoffusion.com wrote: ===

Re: AjaxCFC Debugging

2009-09-28 Thread Andrew McDuff
Rick, Yes, looks like it: latest stable version released in June 2009. Check it out at: http://coldfire.riaforge.org/ Just installed Coldfire and it should work just fine on 'standard' CF implementations (i.e. using CFMs and CFCs) but it won't give you debug functionality on something like

How to completely stop the RDS server?

2009-09-28 Thread Claude Schneegans
Hi, I have a CF 5 server, but I never use Remote Development, so I don't need the RDS service. The service is disabled in the Windows services. However I get this line every 2 seconds in the executive.log: Error,1716,09/28/09,16:21:15,,Unexpected Windows NT error number 1058 occurred while

Re: How to completely stop the RDS server?

2009-09-28 Thread Dave Watts
The RDS service is completely stopped. I don't know of a way to keep the Executive service from generating these errors other than stopping the Executive service as well. I recommend you simply disregard these errors as they are harmless. Dave Watts, CTO, Fig Leaf Software On 2009-09-28, Claude

Re: How to completely stop the RDS server?

2009-09-28 Thread Claude Schneegans
... other than stopping the Executive service as well. Which of course I can't do, or all scheduled tasks won't run. I recommend you simply disregard these errors as they are harmless. No, they are harmless, except for building a hudge file for nothing. I have to remember to delete it from

RE: AjaxCFC Debugging

2009-09-28 Thread Rick Faircloth
I'll have to check it out. I do all my ajax with jQuery. Hopefully it'll work... -Original Message- From: Andrew McDuff [mailto:andy.mcd...@gmail.com] Sent: Monday, September 28, 2009 8:22 PM To: cf-talk Subject: Re: AjaxCFC Debugging Rick, Yes, looks like it: latest stable version

input type of File in a cflayout tab

2009-09-28 Thread Kevin Huff
I have this form, in a cflayout tab that I submit to a different page. The form has a input type file field in it. This works fine outside of the tab but within the tab the type file field always returns none. What is going on here? Any help would be great.

Re: input type of File in a cflayout tab

2009-09-28 Thread Azadi Saryev
is your form a regular form tag or cfform? a cfform inside a cf ajax container (which cflayoutarea is) will submit to that container (and not the main page) using an ajax post request, which does not support uploading files. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 29/09/2009