XML Parsing in CF Help
Hi, I'm working on parsing an xml document and have run into a brick wall. A portion of the xml is below... Here's the issue... I can sucessfully retrieve the ap-online-code using the following code: cfset mydoc = XmlParse(xmldoc) #mydoc.nitf.head.meta[8].XmlAttributes.content# (the above code outputs '1110' as expected) But I'm worried about the document changing. Can I somehow retrieve this by the name attribute (in this example 'ap-content-code') instead of position number? Thanks, Jonathan ?xml version=1.0 encoding=UTF-8? !DOCTYPE nitf SYSTEM nitf.dtd nitf head meta name=ap-transref content=V1463/ meta name=ap-origin content=pf1apon/ meta name=ap-selector content=-/ meta name=ap-category content=a/ meta name=ap-format content=bx/ meta name=ap-routing content=ENTITLEMENTS,pfONLINE,pf1110/ meta name=ap-profile-country content=country: United States; ISOCountry3: USA; UNTop: 021; APGroup: NorthAmerica/ meta name=ap-online-code content=1110/ meta name=ap-cycle content=AP/ meta name=ap-keyword content=Walking Across America/ meta name=ap-xhl content=Once 410 Pounds, California Man Nears End of His Cross-Country Odyssey/ meta name=ap-dheadline content=Man nears end of his cross-country odyssey/ meta name=ap-dxhl content=Once 410 pounds, California man nears end of his cross-country odyssey/ docdata doc-id regsrc=AP id-string=D8HG6H880/ urgency ed-urg=7/ date.issue norm=20060509T100123Z/ du-key key=Walking Across America/ doc.rights owner=http://www.ap.org; agent=http://license.icopyright.net; type=online,reprint/ doc.copyright year=2006 holder=Copyright 2006 The Associated Press. All rights reserved. This material may not be published, broadcast, rewritten or redistributed./ /docdata /head .. /nitf ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240003 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Long URLs in flash forms
Has anyone run across this, or know of a (better) workaround? Apparently a URL in an a href tag inside cfformitem type=html is truncated to 128 characters. However, using a cfinput type=button with a GetURL() function works with URLs longer than 128 characters. CFMX 7 obviously... since it's a flash form. -- Jonathan Mauney Web Application Developer 1110 WBT AM 107.9 the LINK [WLNK] PersonalityAC(r) Radio Network Jefferson-Pilot Communications Co. -- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225757 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Flash cfform and recompilation
In the ColdFusion documentation under Best practices for Flash forms it says: Only data should be dynamic. Whenever a variable name changes, or a form characteristic, such as an element width or a label changes, the Flash output must be recompiled. If a data value changes, the output does not need to be recompiled. Does anyone know if the content between a cfformitem type=text tag is considered data or a form characteristic? Basically I'm trying to figure out if a custom error message from the server can be inside the flash form, or if I should output it in the html outside the form. My actual code is this: cfformitem type=text style=font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; color:##FF;#variables.errormessage#/cfformitem Normally variables.errormessage is empty, but would be populated if the user's login credentials were incorrect or the account was inactive. Thanks, Jonathan -- Jonathan Mauney Web Application Developer 1110 WBT AM 107.9 the LINK [WLNK] PersonalityAC(r) Radio Network Jefferson-Pilot Communications Co. -- ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212108 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Flash cfform and recompilation
Awesome... Thanks for the response... Just to be clear... These are cfformitem tags, not cfforminput as quoted below. Thanks, Jonathan -Original Message- From: Mike Nimer [mailto:[EMAIL PROTECTED] Sent: Monday, July 18, 2005 3:38 PM To: CF-Talk Subject: RE: Flash cfform and recompilation That would be ok. The data between the cfforminput/cfforminput tags is considered the value of the field so it does not force a recompile. Hth, ---nimer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 18, 2005 10:13 AM To: CF-Talk Subject: Flash cfform and recompilation In the ColdFusion documentation under Best practices for Flash forms it says: Only data should be dynamic. Whenever a variable name changes, or a form characteristic, such as an element width or a label changes, the Flash output must be recompiled. If a data value changes, the output does not need to be recompiled. Does anyone know if the content between a cfformitem type=text tag is considered data or a form characteristic? Basically I'm trying to figure out if a custom error message from the server can be inside the flash form, or if I should output it in the html outside the form. My actual code is this: cfformitem type=text style=font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; color:##FF;#variables.errormessage#/cfformitem Normally variables.errormessage is empty, but would be populated if the user's login credentials were incorrect or the account was inactive. Thanks, Jonathan -- Jonathan Mauney Web Application Developer 1110 WBT AM 107.9 the LINK [WLNK] PersonalityAC(r) Radio Network Jefferson-Pilot Communications Co. -- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212151 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Session vs. Client Variables
Hello all... Next month I'm beginning a complete rewrite of a site that gets about 120,000 page views per day. For background, here is our server configuration: CFMX 6.1 Enterprise, J2EE Configuration for JRun 2 Windows 2003 Servers with 4 GB RAM for IIS and JRun/CFMX MS SQL 2000 on a separate Windows Server 2003 Hardware Load Balancer This site has one JRun instance on each server joined in a cluster Session Replication is enabled Both CFMX and JRun have the latest updaters installed (There are 5 more instances of JRun on each server running smaller, lower traffic sites) The site requires tracking a small amount of demographic information (zipcode, etc) throughout the entire user's session. There is also a login for contest/poll entry, managing subscriptions, access to certain types of content, etc. All of this MUST work if the user has cookies disabled in their browser. (I use URLSessionFormat() for all links). I'm getting conflicting reports on which is best for this scenario: Session Variables or Client Variables I know Session Replication is faster, but it's been a little flakey since we started using JRun clusters... especially due to a bug where when a JRun instance is brought back online, the session is dropped and the user gets a new one. (Macromedia is supposed to be fixing that one soon). But as a test, I tried switching to client variables (using database) and we took a serious performance hit (probably 50%) with the current application. I'll do my best to streamline it during the rewrite, but does anyone have any suggestions on the best route to take here? Thanks, Jonathan _ Jonathan Mauney Web Application Developer/Manager, Digital Media Properties News Talk 1110 WBT/107.9 the LINK/PersonalityAC(r) Radio Network Jefferson-Pilot Communications Co. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188991 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Strange cfmail error
Hello, I just happened to look at my mail.log file in the CF Admin and there are a lot (5-6 every minute) of this error: Error,scheduler-1,12/22/04,05:23:35,,550 Body From: of '@107' is banned Anyone seen this before, or have an idea of what it might be? Our domain is 1079thelink.com, which is where the @107 could come from, but why is it banned, who's banning it and why it it in the log so much? Thanks, Jonathan _ Jonathan Mauney Web Application Developer/Manager, Digital Media Properties News Talk 1110 WBT/107.9 the LINK/PersonalityAC(r) Radio Network Jefferson-Pilot Communications Co. One Julian Price Place Charlotte, North Carolina 28208 704.374.3862 voice 704.374.3543 fax ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188530 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Admin on JRun Cluster
I like this idea... but I'm not sure how to implement it. When I run the wsconfig, it only shows the cluster under JRun Server, not the individual JRun instance so now I'm back to the same problem as I had using CF Admin through the primary virtual host... Jonathan From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, August 30, 2004 9:33 PM To: CF-Talk Subject: Re: CF Admin on JRun Cluster We run a separate virtual host on our web servers for each app server. Those vhosts aren't load balanced, SSL-only, and they're access-restricted to specific IPs (the office and my house).So we've got our main vhost and app running at x.x.x.1, and then x.x.x.2-n are the extra vhosts that go to each server directly. I like this setup because I can still access my CF Admin from anywhere with a normal web browser.At the most, I'll need an SSH client to go in an add an allowed IP address to the Apache conf, but that's a 300k download, so hardly an issue. cheers, barneyb On Mon, 30 Aug 2004 20:22:04 -0400, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello all... Does anyone have any suggestions/best practices for running the CFMX Administrator when ColdFusion is running as part of a cluster? Obviously if I run it through IIS I never know which of the two servers (instances) I'm making a change to.Can I leave the built-in JRun web server running if I lock it down so it's only accessable at localhost? Thanks, Jonathan -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF Admin on JRun Cluster
Hello all... Does anyone have any suggestions/best practices for running the CFMX Administrator when ColdFusion is running as part of a cluster? Obviously if I run it through IIS I never know which of the two servers (instances) I'm making a change to.Can I leave the built-in JRun web server running if I lock it down so it's only accessable at localhost? Thanks, Jonathan WBT / WLNK / Jefferson-Pilot Radio Network Charlotte, NC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Executing the SQL statement is not allowed
I am completely stumped on this one. I'm trying to execute this query on my development box (Win XP Pro, CFMX 6.1, MS SQL Server 2000 Development, Apache 2): CREATE TABLE [RADIOPrimary].[dbo].[testform2] ( [testform2ID] int NOT NULL IDENTITY PRIMARY KEY, [testcolumn] varchar (8000) NULL, [CMSUseOnlySortOrder] int NULL, [CMSUseOnlyFeatureSortOrder] int NULL, [CMSUseOnlyPublish] bit NULL, [CMSUseOnlyDateTimeStamp] datetime NULL ) I get Executing the SQL statement is not allowed. every time. The datasource uses the MS SQL sa account and the query runs fine with the MS SQL Query Analyzer using sa. The datasource has all permissions checked. At one point this would have worked on my development box. Here's the weird part, the same code runs fine on my Production Box (Win 2K Server, CFMX 6.1). What could possibly be causing this issue? All other queries on this datasource (SELECT, INSERT, DELETE) run fine. Thanks, Jonathan __ Jonathan Mauney Web Application Developer / Manager, Digital Media Properties 1110 WBT AM / 107.9 the LINK (WLNK-FM) / JP Radio Network Jefferson-Pilot Communications Co. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Executing the SQL statement is not allowed
Thanks Steve, but that didn't work either. I get the same error. Remember the exact same code works fine in my production environment the only differences are Dev is Win XP and Apache with MS SQL Dev Edition on the same box and the production is on Win 2K Server with IIS and MS SQL is on separate box. -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 4:48 PM To: CF-Talk Subject: RE: Executing the SQL statement is not allowed Jonathan, I believe that Identity needs a seed.Also, I know that the limit on the size of a row is somewhere around 8000. Try: create table [RADIOPrimary].[dbo].[testform2] ( [testform2ID] int NOT NULL IDENTITY (1, 1) PRIMARY KEY, [testcolumn] varchar(7000) NULL, [CMSUseOnlySortOrder] int NULL, [CMSUseOnlyFeatureSortOrder] int NULL, [CMSUseOnlyPublish] bit NULL, [CMSUseOnlyDateTimeStamp] datetime NULL) Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:57 PM To: CF-Talk Subject: Executing the SQL statement is not allowed I am completely stumped on this one. I'm trying to execute this query on my development box (Win XP Pro, CFMX 6.1, MS SQL Server 2000 Development, Apache 2): CREATE TABLE [RADIOPrimary].[dbo].[testform2] ( [testform2ID] int NOT NULL IDENTITY PRIMARY KEY, [testcolumn] varchar (8000) NULL, [CMSUseOnlySortOrder] int NULL, [CMSUseOnlyFeatureSortOrder] int NULL, [CMSUseOnlyPublish] bit NULL, [CMSUseOnlyDateTimeStamp] datetime NULL ) I get Executing the SQL statement is not allowed. every time. The datasource uses the MS SQL sa account and the query runs fine with the MS SQL Query Analyzer using sa. The datasource has all permissions checked. At one point this would have worked on my development box. Here's the weird part, the same code runs fine on my Production Box (Win 2K Server, CFMX 6.1). What could possibly be causing this issue? All other queries on this datasource (SELECT, INSERT, DELETE) run fine. Thanks, Jonathan __ Jonathan Mauney Web Application Developer / Manager, Digital Media Properties 1110 WBT AM / 107.9 the LINK (WLNK-FM) / JP Radio Network Jefferson-Pilot Communications Co. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1, Apache WinXP Pro
I did that my first go round and got an error at the end of the installation process saying that it could not install the connectors and that I would need to do it manually. So I uninstalled CFMX and deleted the cfusionmx directory and followed the steps below as recommended in other forums and Macromedia's website. I've also tried stopping all other services that might interfere and still no luck. Jonathan -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 3:45 AM To: CF-Talk Subject: RE: CFMX 6.1, Apache WinXP Pro Should you not have installed ColdFusion to Apache and not as a standalone installation (on port 8500)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 October 2003 6:19 AM To: CF-Talk Subject: CFMX 6.1, Apache WinXP Pro I've done several searches on the web for this problem with no results... I find it hard to believe I'm the only one having this problem. Here's what I've done: 1. Installed Apache 2.0.47 for windows. The installation works, going to http://localhost http://localhostshows the default Apache index page. 2. Installed ColdFusion MX 6.1 as Standalone. This installation also works, admin at http://localhost:8500/CFIDE/Administrator http://localhost:8500/CFIDE/Administratorallows login to CFMX Admin. 3. Opened the Apache httpd.conf file and added the following: Alias /CFIDE C:/CFusionMX/wwwroot/CFIDE Alias /cfide C:/CFusionMX/wwwroot/CFIDE Directory C:/CFusionMX/wwwroot/CFIDE Options Indexes FollowSymLinks MultiViews IncludesNoExec AddOutputFilter Includes html AllowOverride None Order allow,deny Allow from all /Directory 4. Restarted Apache 5. Edited c:\cfusionmx\bin\connectors\Apache_connector.bat to reflect path to Apache conf director 6. Verified that both Apache and CFMX 6.1 were running 7. Ran the Apache_connector.bat --- here's where the problem is: Created file C:\CFusionMX\runtime\lib\wsconfig\jrunwin32.dll Could not connect to any Jrun/ColdFusion servers on host localhost. Possible causes: Server not running -Start Macromedia JRun4 or ColdFusion MX server Server running -JNDI listen port in jndi.properties blocked by TCP/IP filtering or firewall on server -host restriction in security.properties blocking communications with server Press any key to continue... What am I doing wrong? I have no firewall installed and this is a standard Windows XP Professional installation. Has anyone else had these issues? Any ideas? I ran into this same problem a while back with IIS, and finally gave up and used the built-in server. But this time I really need to use Apache. Thanks, Jonathan __ Jonathan Mauney Web Application Developer / Manager, Digital Media Properties 1110 WBT AM / 107.9 the LINK (WLNK-FM) / JP Radio Network Jefferson-Pilot Communications Co. www.wbt.com www.1079thelink.com www.bobandsheri.com www.mattandramona.com www.pamstoneshow.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX 6.1, Apache WinXP Pro
I've done several searches on the web for this problem with no results... I find it hard to believe I'm the only one having this problem. Here's what I've done: 1. Installed Apache 2.0.47 for windows. The installation works, going to http://localhost shows the default Apache index page. 2. Installed ColdFusion MX 6.1 as Standalone. This installation also works, admin at http://localhost:8500/CFIDE/Administrator allows login to CFMX Admin. 3. Opened the Apache httpd.conf file and added the following: Alias /CFIDE C:/CFusionMX/wwwroot/CFIDE Alias /cfide C:/CFusionMX/wwwroot/CFIDE Directory C:/CFusionMX/wwwroot/CFIDE Options Indexes FollowSymLinks MultiViews IncludesNoExec AddOutputFilter Includes html AllowOverride None Order allow,deny Allow from all /Directory 4. Restarted Apache 5. Edited c:\cfusionmx\bin\connectors\Apache_connector.bat to reflect path to Apache conf director 6. Verified that both Apache and CFMX 6.1 were running 7. Ran the Apache_connector.bat --- here's where the problem is: Created file C:\CFusionMX\runtime\lib\wsconfig\jrunwin32.dll Could not connect to any Jrun/ColdFusion servers on host localhost. Possible causes: Server not running -Start Macromedia JRun4 or ColdFusion MX server Server running -JNDI listen port in jndi.properties blocked by TCP/IP filtering or firewall on server -host restriction in security.properties blocking communications with server Press any key to continue... What am I doing wrong? I have no firewall installed and this is a standard Windows XP Professional installation. Has anyone else had these issues? Any ideas? I ran into this same problem a while back with IIS, and finally gave up and used the built-in server. But this time I really need to use Apache. Thanks, Jonathan __ Jonathan Mauney Web Application Developer / Manager, Digital Media Properties 1110 WBT AM / 107.9 the LINK (WLNK-FM) / JP Radio Network Jefferson-Pilot Communications Co. www.wbt.com www.1079thelink.com www.bobandsheri.com www.mattandramona.com www.pamstoneshow.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: What happened to my digest?
Same here... What's going on? Jonathan -Original Message- From: Rachel Maxim [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:48 PM To: CF-Talk Subject: What happened to my digest? I was subscribed to CF Talk in digest mode, I seem to have started receiving individual posts. Is digest no longer available now that the HTML version is live? Rachel Maxim - - - - - - - - - - - - - - - - - - - - - - - - Creative Director Case Design/Remodeling, Inc. Case Handyman Services, LLC. [EMAIL PROTECTED] CaseDesign.com - CaseHandyman.com ~| ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803 Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138458 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
FW: What happened to my digest?
-Original Message- From: Schlosser, JoAnn [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 1:42 PM To: Jonathan Mauney Subject: RE: What happened to my digest? Get this - since my company changed our email addresses, I can't even comment on this mess or unsubscribe! I used to get the digest and it went into my CF folder, now everything is recognized by the person who sent the message, not the list so I can't filter it, either. Please post this for me. I will probably end up unsubscribing to this otherwise. JoAnn A. Schlosser Senior Consultant Grant Thornton LLP Vienna, Va. Tel: (703) 637-2668 Fax: (703) 637-4084 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:55 PM To: CF-Talk Subject: RE: What happened to my digest? Same here... What's going on? Jonathan -Original Message- From: Rachel Maxim [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:48 PM To: CF-Talk Subject: What happened to my digest? I was subscribed to CF Talk in digest mode, I seem to have started receiving individual posts. Is digest no longer available now that the HTML version is live? Rachel Maxim - - - - - - - - - - - - - - - - - - - - - - - - Creative Director Case Design/Remodeling, Inc. Case Handyman Services, LLC. [EMAIL PROTECTED] CaseDesign.com - CaseHandyman.com ~| Get the mailserver that powers this list at http://www.coolfusion.com Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138487 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Resume Posting Application
Hello all... Does anyone know of any free (or very cheap) CF applications that would allow users to post a resume to a website and list job openings? One of our radio shows wants to offer this as part of a feature they do on air. I need it to be simple and easy to set up. Thanks, Jonathan Jonathan Mauney Manager, Digital Media Properties / Web Application Developer 1110 WBT AM / 107.9 the LINK (WLNK-FM) / Jefferson-Pilot Radio Network Jefferson-Pilot Communications Co. One Julian Price Place Charlotte, North Carolina 28208 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Browser Login Feature
Has anyone had any luck implimenting this? I copied this code directly from the Developing ColdFusionMX Applications with CFML book that Macromedia includes with CFMX into an Application.cfm template: cfapplication name=Test clientmanagement=yes/ cflogin cfif IsDefined( cflogin ) cfif cflogin.name eq admin and cflogin.password eq p1 cfset roles = user,admin cfelseif cflogin.name eq user and cflogin.password eq p2 cfset roles = user /cfif /cfif cfif IsDefined( roles ) cfloginuser name=#cflogin.name# password=#cflogin.password# roles=#roles# cfelse !--- User has not logged in or authentication failed - send 401 --- cfsetting enablecfoutputonly=yes showdebugoutput=no cfheader statuscode=401 cfheader name=WWW-Authenticate value=Basic realm=MySecurity cfoutputNot authorized/cfoutput cfabort /cfif /cflogin The login box pops up every time, but it won't accept the correct password Just pops up the login box again for 2 more times then I get a browser error about not being authorized. CFMX, Updater 3, tried on Windows XP Pro, Windows 2000 Server... same results. Jonathan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Advanced query question
Hello, In an application that I'm building I have a db table of users, and a table of company divisions. The users table has a DivisionID column that contains a comma delimited list of the Division IDs the user should have access to in the Application. I know how to do a join to match up the Division Name to the user if the DivisionID column in users only contained a single DivisionID, but is there any way to do this with a comma delimited list of IDs? My goal is to be able to display the users in a cfgrid where the division column will contain a comma delimited list of the Division Names (not the Division IDs). Can I do this, or did I screw myself in the way I designed the app? Thanks, Jonathan Jonathan Mauney Manager, Digital Media Properties / Web Application Developer 1110 WBT AM / 107.9 the LINK (WLNK-FM) / Jefferson-Pilot Radio Network Jefferson-Pilot Communications Co. One Julian Price Place Charlotte, North Carolina 28208 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problems Duplicating a Query
I've worked at this for hours and I can't figure out why this doesn't work! Here's the deal... This is a function inside a cfc. I'm calling a function in another cfc that returns a structure. One of the items in that structure is a query. I'm trying to add 3 columns to the query using arrays and the QueryAddColumn function. Then I make a copy of query using Duplicate(). However, when I call for the copy in a Query of Queries I get this error: Table named records1SELECT was not found in Memory. It is misspelled, or the table is not defined. If I comment out the three QueryAddColumn lines, it works fine! Why would the copy work fine if the query not modified, but apparently not work if it was? Also, if I comment out everything from the query of queries on down and change the function to output the original query instead of a boolean I can see the additional columns added by the QueryAddColumns. The entire code is listed below. Thanks, Jonathan cffunction name=LoadFormData access=private returntype=boolean output=no cfargument name=LayoutID type=numeric required=true cfargument name=applicationVars type=struct required=true cfargument name=sessionVars type=struct required=true cfset var i = cfset var sRecords = cfset var loopcount = 1 cfset var temp = !--- Run a query to get the layout data --- cfinvoke component=cms.extensions.CMSQueries method=GetLayouts returnvariable=layoutsSELECT cfinvokeargument name=RoleName value=#arguments.SessionVars.rolename#/ cfinvokeargument name=DivisionID value=#arguments.SessionVars.DivisionID#/ cfinvokeargument name=LayoutID value=#arguments.LayoutID#/ /cfinvoke !--- Loop through Forms selected for layout --- cfloop index=i list=#layoutsSELECT.Forms# delimiters=, !--- Get the records from this table --- cfinvoke component=cms.extensions.CMSQueries method=GetRecords returnvariable=sRecords cfinvokeargument name=FormID value=#i#/ /cfinvoke !--- Create Arrays that will be added to the query --- cfset aIDColumn = ArrayNew(1) cfset aTableName = ArrayNew(1) cfset aDSNName = ArrayNew(1) cfloop index=i from=1 to=#sRecords.FormRecords.recordcount# cfset aIDColumn[#i#] = sRecords.IDColumn cfset aTableName[#i#] = sRecords.TableName1 cfset aDSNName[#i#] = sRecords.DSNName /cfloop !--- Add the arrays to the query as a column --- cfset QueryAddColumn(sRecords.FormRecords, IDColumn, aIDColumn) cfset QueryAddColumn(sRecords.FormRecords, TableName, aTableName) cfset QueryAddColumn(sRecords.FormRecords, DSNName, aDSNName) !--- Duplicate the query so we don't overwrite it on the next loop --- cfset records#loopcount#SELECT = Duplicate(sRecords.FormRecords) !--- Set a variable with the name of the Identifying column - this will be the first column the webmaster choose for the index --- cfset column#loopcount# = ListGetAt(sRecords.ColumnNameList, 1, ',') !--- Set a variable with the name of the IDColumn so we can use it in the query of queries below --- cfset IDColumn#loopcount# = sRecords.IDColumn !--- Increase the loopcount by one if we are not on the last loop --- cfif loopcount lt ListLen(layoutsSELECT.Forms, ',') cfset loopcount = loopcount+1 /cfif /cfloop !--- Loop the number of times we had to loop above, joining the records from the different querys --- cfquery name=allrecordsSELECT dbtype=query cfloop index=i from=1 to=#loopcount# SELECT #Evaluate(IDColumn#i#)# AS ID, #Evaluate(column#i#)# AS DisplayName, CMSUseOnlyFeatureSortOrder As SortOrder FROM records#i#SELECT cfif i lt loopcount UNION /cfif /cfloop ORDER BY SortOrder
Decision operators as variables
Hello, I'm probably missing something simple, but how can I make this cfif statement work using only variables? cfif NOT Evaluate(arguments.FormVars.#this.aFieldsCart[i].RequiredFieldName#) this.aFieldsCart[i].FieldComparisonValue this.aFieldsCart[i].FieldComparisonValue Where Evaluate(arguments.FormVars.#this.aFieldsCart[i].RequiredFieldName#) is the variable name, this.aFieldsCart[i].FieldComparisonValue is a Decision Operator (gt, lt, gte, lte, eq, etc...) And this.aFieldsCart[i].FieldComparisonValue is the value I'm checking against. Thanks, Jonathan Jonathan Mauney Manager, Digital Media Properties / Web Application Developer 1110 WBT AM / 107.9 the LINK (WLNK-FM) / Jefferson-Pilot Radio Network Jefferson-Pilot Communications Co. One Julian Price Place Charlotte, North Carolina 28208 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
java.lang.IndexOutOfBoundsException
Has anyone ever seen this before? It's not consistent, if I reload the page it usually works. java.lang.IndexOutOfBoundsException - in C:\Inetpub\wwwroot\cms\wwwroot\form\form.cfm : line 2 Index: 637, Size: 546 Thanks, Jonathan Jonathan Mauney Manager, Digital Media Properties / Web Application Developer 1110 WBT AM / 107.9 the LINK (WLNK-FM) / Jefferson-Pilot Radio Network Jefferson-Pilot Communications Co. One Julian Price Place Charlotte, North Carolina 28208 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: java.lang.IndexOutOfBoundsException
Yes... I'm on Updater 3... I probably ought to note that this is my development machine, not a production server... Win XP Pro, IIS, MS SQL Server 2000 Development Version... Plus Office and Studio MX. It's a hefty machine, but I'm making it do a lot. Thanks, Jonathan -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 1:42 PM To: CF-Talk Subject: Re: java.lang.IndexOutOfBoundsException Yes, this was an occasional error caused by CFMX getting its class cache out of sync with what's on disk. Sometimes caused by hitting a modified page through a browser 'just after' uploading it. I believe it was fixed in one of the Updaters - are you running Updater 3 yet? Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood On Thursday, Jun 26, 2003, at 10:15 US/Pacific, [EMAIL PROTECTED] wrote: Has anyone ever seen this before? It's not consistent, if I reload the page it usually works. java.lang.IndexOutOfBoundsException - in C:\Inetpub\wwwroot\cms\wwwroot\form\form.cfm : line 2 Index: 637, Size: 546 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: java.lang.IndexOutOfBoundsException
Yes... After you pointed it out I did notice that it is only after saving a file (which I obviously was doing a lot of). -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 4:26 PM To: CF-Talk Subject: Re: java.lang.IndexOutOfBoundsException On Thursday, Jun 26, 2003, at 10:48 US/Pacific, [EMAIL PROTECTED] wrote: Yes... I'm on Updater 3... I probably ought to note that this is my development machine, not a production server... Hmm, I've not seen that error since the first or second updater so I assumed it was fixed - I used to see it often enough to be annoying with the original release of CFMX (but still infrequently). The only thing I can suggest is waiting a second or two between saving the file and hitting it through a browser. Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfheader and caching
I'm trying to keep my pages from caching in visitors browsers and/or proxy servers. I found the following code online that uses cfheader: CFHEADER NAME=Expires VALUE=Mon, 06 Jan 1990 00:00:01 GMT CFHEADER NAME=Pragma VALUE=no-cache CFHEADER NAME=cache-control VALUE=no-cache Do I have to put that code in the head/head section of my pages, or can it just go at the top? Can I put it in my Application.cfm file? Should I bother with META tags too? Has anyone had any experiences with this that could be helpful? Thanks, Jonathan Jonathan Mauney Manager, Digital Media Properties / Web Application Developer 1110 WBT AM / 107.9 the LINK (WLNK-FM) / Jefferson-Pilot Radio Network Jefferson-Pilot Communications Co. One Julian Price Place Charlotte, North Carolina 28208 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Advanced SQL Query Question
Hello, I'm working on a project where records will be added to a single table, and each record will be assigned to one of six categories (using a category column). Is there a way I can do a single query to pull the most recent record from each of the six categories? Or is my only option to do queries of queries on my CF template? Thanks, Jonathan Jonathan Mauney Manager, Digital Media Properties / Web Application Developer 1110 WBT AM / 107.9 the LINK (WLNK-FM) / Jefferson-Pilot Radio Network Jefferson-Pilot Communications Co. One Julian Price Place Charlotte, North Carolina 28208 704.374.3862 [voice] 704.374.3884 [fax] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [email] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
