Re: reading AIF metadata?
No, there's chunk data stored in the binary file - AIF has author, copyright, tempo and other details included in the data, as well as a chunk for ID3 info. That's the info I'll be needing to get at. What sort of metadata are you after? Looks like GetFileInfo might be what you're looking for... http://coldfused.blogspot.com/2007/07/new-file-io-in-coldfusion-8-part-ii.html -- Josh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
reading AIF metadata?
An RFP just got handed to me that involves uploading and storing AIF audio files, and reading and storing the metadata of those files. So far, Google has not come up with a lot of info on reading in the metadata of these files - especially in a Windows/CF environment. Any pointers on where I should be looking or if someone else has built a library or function that can read this data? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
optimizing CFIDE for cfform
I'm becoming a little obsessed with that damn YSlow meter trying to wring some more performance out of our web server. My last hangup is the 20 javascript and CSS files that a having a simple cfform and cfwindow causes to load. Is there any tips for reducing that or are all 20 files really necessary? I am using cfajaximport to pull in the files from a CFIDE hosted on a domain for our static content, and I have listed as the tags cfform and cfwindow only. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336665 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfform won't submit
I must be missing something obvious here. I have a simple user enrollment form that submits fine on the first submit, but can't seem to be submitted a 2nd time. There is no submit once validation. For example, if I test it with a username that I know is in use, it quickly submits and generates and error message stating that the username is in use. If I select a username that's good and resubmit, it just hangs. In the browser status bar it simple sits at waiting for test.server.com until it times out with a connection reset error. I installed a Firefox plugin to watch the HTTP traffic and it seems to confirm that there's no response from the server on the 2nd submit. Yet if I open up countless new browsers and tabs, the server is working fine. Any ideas?? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:34 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF8 sessions being dropped all of a sudden
We have an application that's been working fine for 9+ years now (started on CF5, now CF8.01). Yesterday we started to receive some comments from users that they weren't able to log in. I could log into their accounts fine, but they could not. They were using correct info (a failed login attempt was not being logged). One was on Firefox, the other on IE. In both cases, exiting and restarting the browser did the trick. Now this morning it started happening to me and I was able to dump the cookie and session info. What seemed to be happening was that the session variables to determine if a user was logged in, the user id, the login time etc. were being set correctly in the session, but when the user gets redirected via cflocation the session is reset. In Application.cfm (yes I know - it's not an easy conversion to cfc - trust me - we're rewriting from the ground up because it's easier!), we have: setclientcookies=Yes setdomain cookies is not specified. We're setup in Admin to use JSESSIONID. We're not changing from www.host.com to host.com when the user logs in. Today I come in and see that our current users online is only 5 - it's normally about 20 at this time of day so I'm thinking this might be more widespread than originally thought. We also have a few support e-mails where users can't login and don't get any sort of login failed error message. No changes have been made to the server, application.cfm or login processes. The server was physically rebooted last night. I've seen a few other posts on the web about this behavior but no concrete answer that fits our situation. Thanks, ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333182 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: storing a cfinput inside of a variable
Thanks to everyone who suggested passing it an attributeCollection - you learn something new each day (well, more than one thing reading this list!) To do what you want, provide dynamic parameters to the tag. Use the attributeCollection where you can define the attribuetes as a structure and pass it to the cfinput... (or any other CFML) tag. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332815 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
storing a cfinput inside of a variable
Is there anyway to use cfset or cfsavecontent to store a complete cfinput tag? i.e. cfset config.formFieldA = cfinput type=text name=fieldname value=// If I do a view source, I see it the code on my output page, but it won't render at all in the browser. If I try cfsavecontent it errors because the cfinput isn't in a cfform (since the cfinput is in a CFC being called by the form page). The reason for this is that this one form field could have different max lengths, validations, validation patterns, and messages based on a variety of factors. If I can move the input into a CFC that returns all sorts of other partner specific info, it keeps me to having just one space to enter config data. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332789 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Null Pointers are another name for undefined values
I have a friend who came to me a while ago with a site that wanted to change hosts and have a new look and feel. He would handle the look and feel and I'd take care of the backend. Originally he wanted to rewrite from CF to ASP, but I told him keep it CF and I can do it a lot faster and cheaper. That sold him. Unfortunately, his client pre-paid for 3 years of hosting at Network Solutions and is insisting on using their Coldfusion hosting. Even though I used to work for a hosting company that has really good CF hosting, cheaper than NSI, they're sold on the reliability of the big boys. Ugh - fine. Convert existing db from MySQL to Access, convert all SQL to be compatible, test locally and it works like a charm. Upload a test Application.cfc and index.cfm file to NSI (it took NSI 7 days to add a DSN for me) and immediately get an error as follows: The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. I've trimmed the Application.cfc file down to just: cfcomponent cfscript this.name = ihatenetworksolutions; this.applicationTimeout = createTimeSpan(1,0,0,0); this.sessionTimeout = createTimeSpan(0,0,20,0); this.sessionmanagement = yes; this.setClientCookies = yes; this.setDomainCookies = no; /cfscript cffunction name=onApplicationStart returntype=boolean output=false cfreturn this/ /cffunction cffunction name=onApplicationEnd returntype=void output=false cfargument name=applicationScope required=true /cffunction /cfcomponent If I don't upload an index.cfm file, I get a Directory Listing Denied error. As soon as I upload an index.cfm file - even just a hello world one, I get that null pointer error. I'm assuming their NSI's support will be useless if it took them a week to set a DSN. Some googling on this error took me to several forums where there error is there, but there seems to be a just a lot of ideas as to the cause (broke JVM), and no real concrete solutions. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Null Pointers are another name for undefined values
Yes - removing the application.cfc file and just putting up a simple index.cfm file works fine. I have literally stripped everything out of the application.cfc file and except for onApplicationStart and onApplicationEnd. I also changed the cfscriptthis.name=myapp/cfscript to cfset THIS.name = myapp/ and still getting that error. I've also loaded this application.cfc onto a CFMX7 server that I administer and it works fine there (development environment is CF8 as that's where I was anticipating hosting them until they insisted on NSI). Can you upload just a hello world index.cfm without an Application.cfc (or Application.cfm)? Just curious as to whether or not the issue is definitely in the Application.cfc. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329176 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Null Pointers are another name for undefined values
Application.cfm DOES work. Appserver: JRun4 ProductLevel: Enterprise ProductVersion: 7,0,1,116466 x86 Windows 2003 version 5.2 So why would Application.cfm work and not application.cfc on CF7? ... and you're sure that the hosting environment is CF7? does an Application.cfm work? can you dump the server scope to verify the CF version? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329179 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Null Pointers are another name for undefined values
Nope. Both CreateObject and cfinvoke both throw the same null pointer errors. Dammit! I can hear it now I KNEW we should have just rewritten it from scratch in ASP - which is EXACTLY what they're going to say even though the site ran fine for years on the old host (that was charging them $200 / mo. for shared hosting), and at my host (which would be $200 / yr for CF8 + MySQL on a low volume shared server). Not a clue... but I'm wondering if it has anything to do with restrictions enforced by NSI. Can you manually instantiate any other CFCs? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329181 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Null Pointers are another name for undefined values
I submitted a ticket but I don't have much hope for it. It took 7 days to get a simple DSN setup Might want to ping NSI and see if they can do anything for you. I had a shared host once that disabled createObject() by default, but upon request they would enable it for whatever sandbox your site is in. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329183 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfinput=datefield display problems in IE7
I was getting the same thing, so I played around a little bit with wrapping the cfinput in another div, and this seems to work in IE7 and FF2: div style=clear:both;position:relative;z-index:3;cfinput type../div div style=clear:both;position:relative;z-index:2;cfinput type../div div style=clear:both;position:relative;z-index:1;cfinput type../div I have a form with auto-generated datefields that are vertically aligned on top of one another. In IE7, the div holding the javascript generated calendar gets displayed underneath the form field items directly below it. Does anyone have any ideas about how to fix this? I am currently using a javascript function to throw the calendar out to the side of the fields, but I would prefer the default functionality. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301183 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFFTP - put file problems
Unfortunately, no answer for you, but we're also have an CFFTP issue under CF8. A working template (under CF5) that FTP'd backup files to a remote server nightly no longer works on CF8. The files are generally around 10mb, but they always time out now at around 3mb +/-. Generally around 30 seconds. I've tried adjust the timeouts in the CFFTP tag, adding a request timeout etc. Here it does try to upload the files but nothing appears in the target directory. Both files are around 3 MB. I have successfully uploaded a sample file from explorer so I know that the FTP server is ok. I also successfully put a file using the command line ftp client. I'm beginning to think that it might be better to try getting the file using CF on the target server rather than putting the file from the source server. Steve Logan No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.9/1155 - Release Date: 11/27/2007 8:30 PM ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 Administrator help
I was adding a class path to my Java and JVM settings page so I could register a new Java CFX tag this morning, and when I restarted the CF service, I now get errors on the Java and JVM settings page and the Settings Summary page. When I go to Java and JVM, I get: Element JDKPATH is undefined in FORM. The error occurred in jvm.cfm: line 174 Called from jvm.cfm: line 145 Called from jvm.cfm: line 143 Called from jvm.cfm: line 1 -1 : Unable to display error's location in a CFML template. Remote Address 127.0.0.1 Referrerhttp://127.0.0.1/CFIDE/administrator/navserver.cfm Date/Time 16-Nov-07 01:46 PM Stack Trace at cfjvm2ecfm485176473._factor2(E:\cf8_final\cfusion\wwwroot\CFIDE\administrato r\settings\jvm.cfm:174) at cfjvm2ecfm485176473._factor4(E:\cf8_final\cfusion\wwwroot\CFIDE\administrato r\settings\jvm.cfm:145) at cfjvm2ecfm485176473._factor5(E:\cf8_final\cfusion\wwwroot\CFIDE\administrato r\settings\jvm.cfm:143) at cfjvm2ecfm485176473.runPage(E:\cf8_final\cfusion\wwwroot\CFIDE\administrator \settings\jvm.cfm:1) coldfusion.runtime.UndefinedElementException: Element JDKPATH is undefined in FORM. [rest of debug info edited out] On the Settings Summary page I now get: Variable RETHROW is undefined. The error occurred in runtime.cfc: line 1606 Called from runtime.cfc: line 30 Called from runtime.cfc: line 1 Called from _report.cfm: line 8 Called from _report.cfm: line 1 Called from index.cfm: line 14 -1 : Unable to display error's location in a CFML template. Variable RETHROW is undefined. The error occurred in runtime.cfc: line 1606 Called from runtime.cfc: line 30 Called from runtime.cfc: line 1 Called from _report.cfm: line 8 Called from _report.cfm: line 1 Called from index.cfm: line 14 -1 : Unable to display error's location in a CFML template. Resources: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.8.1.9) Gecko/20071025 Firefox/2.0.0.9 Remote Address 127.0.0.1 Referrerhttp://127.0.0.1/CFIDE/administrator/navserver.cfm Date/Time 16-Nov-07 01:47 PM Stack Trace at cfruntime2ecfc21267795$funcGETPROPS.runFunction(E:\cf8_final\cfusion\wwwroot \CFIDE\adminapi\runtime.cfc:1606) at cfruntime2ecfc21267795._factor4(E:\cf8_final\cfusion\wwwroot\CFIDE\adminapi\ runtime.cfc:30) at cfruntime2ecfc21267795.runPage(E:\cf8_final\cfusion\wwwroot\CFIDE\adminapi\r untime.cfc:1) at cf_report2ecfm955180241._factor73(E:\cf8_final\cfusion\wwwroot\CFIDE\adminis trator\reports\_report.cfm:8) at cf_report2ecfm955180241.runPage(E:\cf8_final\cfusion\wwwroot\CFIDE\administr ator\reports\_report.cfm:1) at cfindex2ecfm1514503215.runPage(E:\cf8_final\cfusion\wwwroot\CFIDE\administra tor\reports\index.cfm:14) coldfusion.runtime.UndefinedVariableException: Variable RETHROW is undefined. at coldfusion.runtime.CfJspPage._get(CfJspPage.java:241) at coldfusion.runtime.CfJspPage._get(CfJspPage.java:226) at cfruntime2ecfc21267795$funcGETPROPS.runFunction(E:\cf8_final\cfusion\wwwroot \CFIDE\adminapi\runtime.cfc:1606) [rest of debug info edited out] I did look for changed files from earlier this morning and found the .bak of the neo*.xml files, restored those - no change. Also found jvm.bak and restored that to jvm.config - no change. Not sure if this is any clue or not, the errors all list E:\cf8_final\cfusion\wwwroot\CFIDE\, but that is not the path to CF - e:\ is the DVD drive that was the install source. No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.33/1133 - Release Date: 11/15/2007 8:57 PM ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293483 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
http headers showing up in page
I have an application that's been running fine for years (we're getting ready to upgrade from CF5 to CF8), but we just noticed something odd on one template. The template is a client detail page, so coming in to it we know the client's ID and all queries on this template are selects. At the very top of the page - above the header graphic - we're starting to get HTTP headers: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 18 Oct 2007 14:45:25 GMT Connection: close Content-type: text/html Page-Completion-Status: Normal Page-Completion-Status: Normal If you reload the page, they go away. We have all sorts of client / sub-client deatail pages that are similar to this one, and those headers do not show up there - or in any other template in the entire web app. I've even replaced the code on that page to just say ello world and I still get that header. I'm 99% sure this isn't a CF issue, but I figured I'd ask this here in hopes that someone has seen something like this before. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291409 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFFORM with flash format does not work in Internet Explorer ONLY
Same thing here. Simple flash form works perfectly in Firefox, but doesn't display at all in IE7 (7.0.5730.11). Hi, I tried the given code on CF8 and IE version 7.0.5730.11. It works absolutely fine. Didnt find any issue at all. Thanks Regards, Jayesh Viradiya Adobe CF Team ONLY I'm struggling with the same problem, and have not found a solution. Here's the situation: CF8 IE7 Flash forms don't display at all in IE7, they look fine in all other browsers. The same exact code works fine on a CF 7.0.2 server. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286216 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF5 / W2K intermittent server stops
Starting about a month ago, one of our CF5 / W2K servers would intermittently stop responding to requests. The server houses about 4 sites, 2 of which run off access dbs, and 2 run of MySQL 5 dbs (working on converting the other two). Session vars are stored in access dbs. Looking at the windows performance monitor, graphing some Cold Fusion items, the item db response time gets pinned at 100 when the server stops responding. Looking in the access log from the most recent incident, I'm seeing this: The first error is expected - the category.cfm file did have a missing item from a cfinclude, so that is now fixed. Error,4632,02/11/06,07:01:31,,66.249.64.13, Googlebot/2.1 (+http://www.google.com/bot.html), Template file not found.PP BH3HTTP/1.0 404 Object Not Found/B/H3PNote: If you wish to use an absolute template path (e.g. TEMPLATE=/mypath/index.cfm) with CFINCLUDE then you must create a mapping for the path using the ColdFusion Administrator. PUsing relative paths (e.g. TEMPLATE=index.cfm or TEMPLATE=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible.PpThe error occurred while processing an element with a general identifier of (CFINCLUDE), occupying document position (66:4) to (66:38) in the template file D:\MCAG\CATEGORY.CFM./pPPDate/Time: 02/11/06 07:01:31BRBrowser: Googlebot/2.1 (+http://www.google.com/bot.html)BRRemote Address: 66.249.64.13BRQuery String: pgid=categorycID=8P However, 8 minutes later, these are the last 3 entries: Error,4632,02/11/06,07:09:55,,, , Error,4632,02/11/06,07:10:00,,, , Error,4632,02/11/06,07:10:08,,, , Scrolling back to the previous time it happened, I see the same thing: Error,4356,02/01/06,19:27:28,,65.54.188.74, msnbot/1.0 (+http://search.msn.com/msnbot.htm), Template file not found.PP BH3HTTP/1.0 404 Object Not Found [snip] Error,3952,02/01/06,20:42:16,,, , Error,4052,02/01/06,20:55:18,,, , Error,4052,02/01/06,20:55:24,,, , IS there any way to diagnose this? An IP isn't even logged so I can't tell if it's a bot or something else. In the server.log, I see some Windows 232 and 109 errors from the same time - which would make sense since the site wasn't responding. The cure is a quick stop and start of the CF Application Server. Has anyone seen this before? Any tips on where to start diagnosing it? Steve ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232043 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
Session.SESSIONID
I was (maybe incorrectly) under the impression that if session management is enabled in cfapplication, then session.sessionid should be available for all users? What's happen is that it's being set inconsistently - sometimes it gets set, sometimes not - and I can't seem to figured out why. My application tag is: cfapplication name=testMFY clientmanagement=Yes clientstorage=ClientStore sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,0,30,0)# applicationtimeout=#CreateTimeSpan(0,1,0,0)# I've currently got a Firefox browser open, and an IE open - after a fresh restart, and I'm dumping the session scope and IE shows the session.sessionID and firefox doesn't: IE: SESSIONID TESTMFY_27_75871719 URLTOKEN CFID=27CFTOKEN=75871719 Firefox doesn't show that either of those session vars exist. It seems to maybe be related to my 'logout page' which clears the session stucture and then redirects users back to the home page: CFAPPLICATION NAME=testMFY SESSIONMANAGEMENT=YES SESSIONTIMEOUT=#CreateTimeSpan(0,0,0,0)# CFLOCK TIMEOUT=10 scope=session CFSET structClear(session) /CFLOCK CFLOCATION URL=../index.cfm Why is it not getting reset when they go back to index.cfm and thus hit the main application.cfm page? This is CF5 on W2K. Thanks. Steve ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230881 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
Re: free mail server preferences
POP before SMTP is a way of authenticating an SMTP session. Basically, if the user can sucessfully POP mail from the server, the mail server would then let them send mail through it. Other methods of allowing mail relaying would typically be SMTP-Authentication (username password required to send - useful if your clients don't all have POP accounts on the server) and via IP rules. If anyone on this list is ever looking for a non-Windows mail server configuration, check out Inter7.com. They do full installations of a modified qmail systems on any flavor of *nix for a couple hundred dollars remotely. We've had them build several mail servers that are all very well setup. Steve Here's a question about ArgoSoft for anyone... I see that only the Pro version ($88) offers POP before SMTP as a feature...what does that mean? Rick ~| 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:227846 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
(SOT) reseller / developer CF hosting
Has anyone used hostek.com for CF hosting? They seem to have really good pricing for resellers ($25 per month for the first 5 domains and then $5 per month for each additional domain). Or, is there a reliable CF hosting company that has good pricing (and a good security / reliability) that can be recommended here? I'll be looking to host between 50 and 100 sites in the first year, after which I'd like to setup some dedicated servers (if anyone knows / works for a co-lo facility that wants to work with me on this that is in the Philadelphia, PA area - please contact me off list). Thanks. Steve ~| 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:209970 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
consultant wanted
After 11 hours on the phone with Microsoft today, I'm giving up and reformatting one of my Windows servers tomorrow. Right now I have 4 CF5 servers running fine, but this W2K CFMX SQL server bugged out on us today and I'm at wits end with it. Basically, IIS refuses connections - even to http://localhost from the machine itself. IE will show a DNS error - Mozilla says connection refused. After about 10 hours with 2 Microsoft techs, we got it so that it just seemd the anonymous account was busted - I could view CFM pages locally and remotely after entering a valid login when prompted. Take the 5 minute drive home figuring something just trashed permissions and I needed to look at my perms on the CF directory - and I'm back to where I started this morning. Can't even view a simple HTM document on the server. So, what we're looking for is an experienced IIS/W2K/CFMX/SQL2000 consultant / person who can put in a few remote hours going over the configuration / setup / security etc. once we get the OS reinstalled tomorrow. If anyone is interested, contact me off list - [EMAIL PROTECTED] with your experience, hourly rate and a couple references. Thanks. ~| 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:194182 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
e-commerce and Endicia / Dazzle
Is anyone aware of any CF shopping carts that have support for Endicia / Dazzle's XML capability to produce shipping lables? Normally I use CFWebStore for my e-commerce applications, but this client is insisting on support for the Endicia / Dazzle package. Before I go an look into writing something custom I thought I'd see if anyone else has done it with CFWebstore or if there's a pre-made e-com package out there. Thanks. Steve ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188817 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
cfmx admin not loading
CFMX 6.1, all updaters on Windows 2000 Server. Starting this morning, the CF Admin won't load. It prompts for login, and bring up the frames for the page, but the only content that actually loads is the tiny black nav menu in the very upper left. The lower left menu frame and the main content frame never load. Has anyone seen this before? Steve ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187730 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
CF5 Registry Errors
Had 2 incidents on a CF5 / Windows 2000 server this morning that are making me real neverous. 1) Went to add a new CFX tag in the CFAdmin and got the following error message: Error Diagnostic Information Unable to set the registry key hkey_local_machine\software\allaire\coldfusion\currentversion\CustomTags\ A problem was encountered trying to access the system registry. Error number 2 occurred - The specified registry key does not exist. Date/Time: 12/13/04 10:24:47 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322) Remote Address: 127.0.0.1 HTTP Referrer: http://127.0.0.1/CFIDE/Administrator/extensions/cfxedit.cfm?type=cpp Query String: type=cpp Then, when I got out of the error ALL of my installed CFX tags are gone. Tried a restart on the machine, and when it came back up, I tried to get back into the CF Admin and it spawned a Windows Meida player which gave an error that index(1).asx was an invalid media stream. When I went into the IIS Admin all of the sites in IIS admin were stopped, and when I tried to start them I kept getting an error the IP address is already in use. In services I stopped all of the Windows Meida services and got that fixed, so at least sites that don't require CFX tags are running. Before I panic and drop the $499 to Allaire for a single incident of support, can anyone give any insight on this? ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187368 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
error loading cfx dll
I'm relatively new to CFMX 6.1 (though I do have a handfull of CF5 servers I'm in charge of). This one is CFMX 6.1 / Windows 2000 Advanced Server. Anyway, I've put a cfx tag (CFX_ResolveDNS.dll) in my C:\CFusionMX\CustomTags directory. I've registered it in CF Admin, but each time we try to load up the test page we get an error of Unable to Load Library. I've tried all versions of letter case - cfx_resolvedns, CFX_ResolveDNS etc. - no help. To see if it's a permissions issue, I temporarily gave the CustomTags folder and the specific dll Everyone / Full Control privs - no help (also, there is another cfx tag in that folder that is working fine and I've matched the security permissions between the two DLLs to no avail). Not sure if this stack trace info is any help, but here it is: Stack Trace (click to expand) at cfCFX_ResolveDNS2ecfm142035402.runPage(D:\UserHome\varady\CFX_ResolveDNS.cfm:32) coldfusion.tagext.DerivedNativeCFXException: Unable to load library at coldfusion.tagext.NativeCfx.processRequest(Native Method) at coldfusion.tagext.CfxTag.doStartTag(CfxTag.java:110) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1876) at cfCFX_ResolveDNS2ecfm142035402.runPage(D:\UserHome\varady\CFX_ResolveDNS.cfm:32) 12:44:40.040 - coldfusion.tagext.DerivedNativeCFXException - in D:\UserHome\varady\CFX_ResolveDNS.cfm : line 32 Unable to load library Any ideas? Thanks! Steve ~| 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:184765 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
Re: error loading cfx dll
Thanks Dave (and Lewis) for the suggestions. I ran depends.exe on it on the server and there didn't seem to be any missing or otherwise problematic dll files. Back to the drawing board.. Steve Anyway, I've put a cfx tag (CFX_ResolveDNS.dll) in my C:\CFusionMX\CustomTags directory. I've registered it in CF Admin, but each time we try to load up the test page we get an error of Unable to Load Library. Are there any dependencies within the library? You might load it up in Dependency Walker (depends.exe) to find out. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| 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:184802 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
searching .gz compressed files
Does anyone know if the standard Verity server with CF 5 or 6.1 can catalog the contents of .gz files?I'm building a tool to archive all incomign and outgoing mail to a server and to offer a web based search tool that can be used to search through the arcived mail based on date ranges, and search for either plain text contents of mail messages, or all mail from: or all mail to: etc. Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfheader question
On a site that I'm working on, there's a lot of MS Word documents available to download.Instead of letting IE open the document in a window, I have a download.cfm page that uses cfheader to force the document to download.
Unfortunately, I can't figure out how to get the previous page that the link was called from to reload, which updates the list of available documents and removes the one that was just downloaded.
For example:
documents.cfm
Link to document to download:index.cfm?pgid=downloadresID=#res_id#
download.cfm
[some queries here to change status]
cfheader name=content-disposition VALUE=attachment; filename=#selResume.res_filename#
cfcontent type=application/octet-stream file=#session.mainuploadpath#\#selResume.res_filename# Deletefile=no
What I need to get to happen is documents.cfm be automatilly refreshed / reloaded after clicking on the link to start the download.
I'm assuming there's now way to put anything else on the download.cfm page just as _javascript_ or a cflocation that would force the documents.cfm page to download because of the cfheader tag.
The other method I'm working on is close - but uses _javascript_ to open a window - which could cause problems with pop-up blockers.
The link for the document to download is:
a href="" >
And then the _javascript_ is:
script
function timedreload(inRes) {
window.open(index.cfm?pgid=downloadresID= + inRes,download,width=10,height=10,scrollbars=0,resizable=0);
setTimeout(window.location.reload();,3000);
setTimeout(window.close.download;,6000);
}
/script
Problem here is that the download window doesn't want to close automatically, and, it uses a pop-up which could cause problems with pop-up blockers.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
CFToken not being set
I have two sites, running on two separate servers (both Windows 2000 / CF 5.0) where all of a sudden cftoken isn't being set for the clients. I can certainly use something else to generate a uniqueID but my question is why all of a sudden in 2 working apps on 2 servers is this problem coming up? On both applications I'm using it to create a UniqueID for a record insert - error messages are like this: cfset UniqueID = Now()+#Session.CFTOKEN# Error resolving parameter SESSION.CFTOKEN The session variable CFTOKEN does not exist. The cause of this error is very likely one of the following things: The name of the session variable has been misspelled. The session variable has not yet been created. The session variable has timed out. It should be noted that both of these applications have been working fine for almost a year now.Here's the corresponding cfapplication tage on this one: cfapplication name=JDB clientmanagement=Yes sessionmanagement=Yes clientstorage=CFSTore SessionTimeout=#CreateTimeSpan(0,0,30,0)# ApplicationTimeout=#CreateTimeSpan(0,2,0,0)# SetClientCookies=Yes The other application with the same errors is: cfapplication name=ProFile clientmanagement=Yes sessionmanagement=Yes clientstorage=pfrClientStore SessionTimeout=#CreateTimeSpan(0,0,30,0)# ApplicationTimeout=#CreateTimeSpan(0,2,0,0)# SetClientCookies=No Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Looping problem
I have a CF page written that gets called by the scheduler once every 15 minutes to look for e-mail in a POP mailbox, and if it meets criteria, distribute it to the list members.I've tested it out with no problems, and 3 list members had used it fine until yesterday afternoon.One list member sent a message to it, and instead of it going to each of the 26 recipients one time - it went to each of the 26 recipients 26 times - oops! Is there anything here in the code here that seems like it could cause this stuck in a loop problem?I'm thinking about revising it so that the message is inserted into a database first and not held by CFX_POP3.Then, if the message meets the criteria, select it back out and send it to the recipients and flag it as a sent message so it doesn't get sent again. I'm using the CFX_POP3 tag to check the mail: CFX_POP3 SERVER=mail.server.name PORT=110 USERNAME=loginname PASSWORD=password ACTION=""> NAME=bnimailapp !--- if there are messages do something --- cfif CFX_POP3.MessageCount GT 0 cfset delCount = 0 cfset mailCount = 0 cfloop query=bnimailapp !--- looks for BNI in the subject line, or if it came from montcocc.org --- cfif FindNoCase(BNI,bnimailapp.Subject,1) OR FindNoCase(montcocc,bnimailapp.From,1) !--- ok - msg is good --- cfif bnimailapp.html is not !--- check to see if content is HTML --- !--- get the recipients --- cfquery name=selActive datasource=#Session.DSN# SELECT tblBni.Email FROM tblBni WHERE tblBni.active /cfquery !--- send out the message as HTML since HTML was present in the original email --- cfloop query=selActive cfmail to=#trim(selActive.Email)# from=#trim(bnimailapp.from)# subject=#trim(bnimailapp.Subject)# type=HTML #bnimailapp.html# /cfmail /cfloop !--- END HTML e-mail --- cfelse!--- No HTML content - proceed as plain text --- cfquery name=selActive datasource=#Session.DSN#!--- get the recipients --- SELECT tblBni.Email FROM tblBni WHERE tblBni.active /cfquery cfloop query=selActive cfmailquery=selActive to=#trim(selActive.Email)# from=#trim(bnimailapp.from)# subject=#trim(bnimailapp.Subject)# #bnimailapp.body# /cfmail /cfloop /cfif cfset mailCount = mailCount +1!--- used for logging to --- cfquery name=updMailLog datasource=#Session.DSN#!--- log date, sender, subject and recipients --- INSERT into tblMailLog (m_date, m_from, m_subject, m_recipients) VALUES (now(),'#bnimailapp.from#','#left(bnimailapp.subject,253)#',#selActive.Recor dCount#) /cfquery !--- no delete the message from the server --- CFX_POP3 SERVER=mail.server.name PORT=110 USERNAME=username PASSWORD=password ACTION=""> UID=#bnimailapp.UID# cfelse!--- message is bad and did not have BNI in subject line or come from montcocc.org --- !--- create a log entry but with 0 recipients since we did not relay this mail to the list --- cfquery name=updMailLog datasource=#Session.DSN#!--- log date, sender, subject and recipients --- INSERT into tblMailLog (m_date, m_from, m_subject, m_recipients) VALUES (#CreateODBCDateTime(Now())#,'#bnimailapp.from#','SPAM-#left(bnimailapp.subj ect,253)#',0) /cfquery !--- delete the bad message --- CFX_POP3 SERVER=mail.server.name PORT=110 USERNAME=username PASSWORD=password ACTION=""> UID=#bnimailapp.UID# cfset delCount = delCount +1 /cfif /cfloop /cfif !--- close main condition of if messages are present --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Looping problem
What do the query bnimailapp look like? Jim Louis it's the CFX_POP3 function - this gets the messages from the mail server - sender, to, subject, body, UID etc. CFX_POP3 SERVER=mail.server.name PORT=110 USERNAME=loginname PASSWORD=password ACTION="" NAME=bnimailapp [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT - SQL Server 2000
Since this is going to be considered off topic for this list, it'd be best to reply to me off list unless this sparks an interesting discussion. I've kind of evolved in being the person who sets up the SQL servers for new users as part of my job.I've managed to muddle my way around and get SQL2000 setup for hosting customers that we develop for and for ones that just use us for hosting. My question is - what's the best practice for this?I seem to just a lot of click here, then go back and add user there etc. to get the database setup initially.I've never been able to find a good resource (web or otherwise) that really addressed SQL 2000 in a hosting environment as far as setuping up the user and db, backing up the databases properly, and making sure it's all secure and stable. Any tips, pointers, step-by-steps etc. would be greatly appreciated. Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
forcing a page reload
I have a page that displays details about a document file on the system (word doc).The word doc has a status assigned to it (1-7) - such as uploaded, downloaded, live, deleted etc. There is a select pulldown on the details page that goes to the correct status. If you click on the resume filename, there's an href to a download.cfm page which forces a file download box (I don't want it to display in browser) and runs and update query to change the status to 7 (which is the status for downloaded). Problem is, I can't get the status pulldown on the details page to update to reflect the new status - even though download.cfm is running the query and the status is being written to the page. Here's some relevent code snippets: details.cfm -- link to download file --- a href=""> -- and the status select code -- cfquery name=selStatus datasource=#Session.DSN# SELECT * FROM tblStatus WHERE display /cfquery select name=statusSelect cfloop query=selStatus option value=#selStatus.status_id# cfif selStatus.status_ID EQselResume.res_statusselected/cfif #selStatus.status_name#/option /cfloop /select -- when you click on the link to download the file a select query is run to get the file name, then an update to change the status to 7, and then cfheader and cfcontent to do the download: cfquery name=selResume datasource=#Session.DSN# SELECT res_filename FROM tblResume WHERE res_id = cfqueryparam value=#resID# cfsqltype=CF_SQL_INTEGER /cfquery cfquery name=updResume datasource=#Session.DSN# UPDATE tblResume SET res_status = 7, res_dla = #CreateODBCDateTime(Now())# WHERE res_id = cfqueryparam value=#resID# cfsqltype=CF_SQL_INTEGER /cfquery cfset session.mainuploadpath=C:\inetpub\users\dev\bronstein\filescfoutputcfheader name=content-disposition VALUE=attachment; filename=#selResume.res_filename# cfcontent type=application/octet-stream file=#session.mainuploadpath#\#selResume.res_filename# Deletefile=no /cfoutput -- everything works there fine, except that the pulldown select on details.cfm never gets reloaded to change the status - even though the status ID is now 7. I've tried all sorts of cflocation, and some basic _javascript_ but I can't seem to get that details.cfm page to reload the select. steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: bandwidth test
There are some problems with what you're trying to accomplish here.In our SLAs for aDSL/sDSL that we give to our subscribers, speed is measured from the DSLAM in the telco CO to the end users router - at least this is where the speed guarantee is. Anything past the DSLAM and you're data is on the CLEC or ILEC ATM network (i.e. Covad, Verizon) to get the data to your ISP. Once it leaves the ATM network it goes into your ISPs POP, where it's routed through their internet connection(s) to the rest of the world. So if you're experiencing poor speed, then it could be at any 1 of those 3 points. You also have to consider that if you're measuring speed every 15 minutes, if anyone else in your company is using the DSL for anything, then it's going to make your speed test show an false slower speed. Also, using a single speed test can give false results since anything could be happening on the internet between you and the speed test servers (i.e. too many people speed testing, DoS attack somewhere, hardware failure forcing traffic onto backup routes etc.). By far the best way to get data on this is through the use of SNMP and MRTG or Cricket.This will keep a relativley constant log of your bandwidth usage throughout the day.If you're paying for 1.5M ADSL and you NEVER see it above 500k, then there's an issue. Also note that ADSL speeds are always sold as up to.We've been dealing with CLEC and ILEC ADSL for 6 years and I've never seen a guarantee of speed given at the max advertised speed for ADSL.For SDSL, we do gurarantee the bandwidth to be at 99.90% of the rated speed. While I appreciate your post, it has left me WAY confused. First off, I am trying to get a fairly reliable DSL speed number for different parts of the day.I want to have a aggregate list of speeds that I can then give to my boss.I also don't want to have to do this by hand, going to a bandwidth meter site every 15 minutes.I have tried to cfhttp these various sites, but there is a redirect in the page usually, so that is obviously not going to work. I am interested in the second long paragraph below.CLI?What is that?I am not a Network guy, so I apologize if this is common knowledge... * [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
nearby zip codes
I read the thread a few weeks about about distance radius searching for US zip codes, but - what about doing neighboring zip codes.I have a client that seems to prefer the idea of seeing every zip code that is next to the one searched for.Is anyone aware of a db that can be purchased out there that has this neighboring zip data? Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF / JavaScript question
I was looking around for a code example of this and haven't been able to find one - it's definitely something that's been on my list of must learn - now it's a need to learn item. I have 2 tables in my db - one is partcategory and one is partsubcatetory. I have a CF snippet set to create a form select pulldown off of the first table, but what I want to have happen is when they make a selection from the first pull down (onChange) run a 2nd query to populate the subcategory with the appropriate items. The part category pulldown select code is this: !--- part cat select pulldown --- cfquery name=selPartCat datasource=#Session.DSN# select * from partcategory /cfquery cfparam name=PartCategorySelect default= cfparam name=FindCategory default= cfset PartCategorySelect=PartCategorySelect 'option value=0' cfset PartCategorySelect=PartCategorySelect--Make A Selection-- cfoutput query=selPartCat cfset PartCategorySelect=PartCategorySelect 'option value=#selPartCat.pc_id#' cfif pc_id eq FindCategory cfset PartCategorySelect=PartCategorySelect selected /cfif cfset PartCategorySelect=PartCategorySelect #selPartCat.pc_category# /cfoutput cfset PartCategorySelect=PartCategorySelect /select cfset PartCategorySelect='select name=PartCategorySelect' PartCategorySelect !--- end part cat pulldown --- cfoutput#PartCategorySelect#/cfoutput This gives me a nice pulldown with the correct values and selection names. Now I'm stuck on the _javascript_ to get the 2nd query / pulldown to be created. Thanks. Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Classified Ads System
Is anyone aware of a ready to be customized CF Classified Ads system. I need to compare a packaged solution vs. a 100% custom one for a meeting with a potential new client next week. Thanks. Steve _ Navpoint Internet 600 Bethlehem Pike Erdenheim, PA 19038 v: 215-836-4600 f: 215-836-2728 56K, ISDN, DSL, T1/T3, Web Hosting, Site Design ~| 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
