Trouble with CF 9 Spreadsheet functions
Hi, I'm going nuts trying to retrieve VALUES out of an Excel 2007 workbook with ColdFusion 9. What's happening is that I'm getting the 'formulas' instead of the 'values'. The formulas are 'cross sheet' formulas (meaning they refer to another sheet in the same workbook). I'm assuming this has something to do with the difficulty. Here's what I've tried so far: 1. reading sheet in with cfspreadsheet into a query. 2. reading sheet in with SpreadsheetRead into an object and then using SpreadsheetGetCellValue() to get the cell value. 3. I've updated the POI jar's in my CF 9 installation with 3.8 POI jar's from Apache 4. I've tried using Ben Nadel's POI Utility, but I get an object instantiation error on this line: LOCAL.ExcelFileSystem = CreateObject( java, org.apache.poi.poifs.filesystem.POIFSFileSystem ).Init( LOCAL.FileInputStream ); (I've confirmed that I'm using the full path (as is indicated on his website) I'm at a loss of how else to get this data out of the spreadsheet. Has someone had success with this and, if so, what can I do? Thanks, Dave ~| 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:353301 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Excel 2003/2007 Recalculating Interaction
Hi all, I'm working with Excel using the Spreadsheet functions in CF 9. I have some weird behavior going on with formulas, and I have a workaround, but I don't like it, so I'm looking for some direction. I have an Excel 2007 spreadsheet. The spreadsheet has simple formulas on it that sum other cells. Here's what I do: 1. Open the Excel 2007 with ColdFusion 9 SpreadsheetRead() 2. Set some values in some of the cells 3. save the file with SpreadsheetWrite() Now, if I open the spreadsheet with Excel 2007 (on my desktop), the cells with the formulas have not 'recalculated' to reflect the newly entered values in the cells which they are summing. I don't know whether this is intended behavior or not, but it's not the behavior I want. So, here's my workaround. 1. On my desktop, I open the file in Excel 2007. 2. I save the file 'as' Excel Type 97-2003 (.xls) 3. When I save as this type I get a dialog asking me if I want to check compatibility when opening this file. I 'uncheck' the option and click continue. 4. I then get a dialog asking if I want this workbook to 'recalculate' every time it is opened. I say 'YES'. 5. The file is now saved as an .xls file. Now, when I work with this .xls file, and update the values in the respective cells with CF and then open the final version, all the formulas reflect the updated values. So, the bottom line is this issue is forcing me to use an older version of Excel files. I know that Excel 2007 files are built differently and utilize XML, but what I don't understand is why the recalculation is not happening automatically. Is there some 'underlying' function in the code CF is using that will force a 'recalculate' in the Excel 2007 file when I have it open in CF? Or is there some other solution someone has an idea for? Thanks! Dave Phillips ~| 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:351290 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Challenge
Okay, I have a challenge out there for all you who like challenges... For a few weeks now I have been trying to add a meeting request in Exchange with the cfexchangecalendar tag and set the 'show as free/busy/tentative/out of office' flag to FREE. I have not been successful. I have tried doing it not only with the built in tags in CF 9, but even manually using webdav requests. On this link, microsoft shows that there IS a property called 'busyStatus', however, if I set this property in the event structure I pass to cfexchangecalendar, ColdFusion says that it's not a valid property. And, of course, it's not mentioned in the CF docs either. http://msdn.microsoft.com/en-us/library/ms877306(v=exchg.65).aspx I know there are some of you out there who like challenges, so I'm hoping this piques at least one of your interest. It almost seems like Adobe left this 'feature' out of the exchange features, which may be true, but I'm convinced there has to be a way to set it. Let me know your thoughts. Thanks, Dave Phillips ~| 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:349518 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Fwd: Re: [DFW CFUG] cfexchangecalendar busyStatus property
Anyone know how to expose the underlying Java objects of the Exchange variety? -- Forwarded message -- From: Dave Phillips experiencedcfdevelo...@gmail.com Date: Jan 12, 2012 5:22 PM Subject: Re: [DFW CFUG] cfexchangecalendar busyStatus property To: dfwc...@googlegroups.com I'd like to try that but not sure how I find the underlying Java object. Any thoughts? On Jan 12, 2012 5:04 PM, Steve Good st...@stevegood.org wrote: I'll preface with this, I have zero experience with these tags. That said, if these tags are anything like most of the other integration tags then there is probably an underlaying Java object. You might research accessing that directly and setting your params there. Not sure if that will help or hinder, but it's all I got. Thanks! --- Steve Good http://stevegood.org/ http://twitter.com/stevegood/ On Jan 12, 2012, at 4:44 PM, Dave Phillips wrote: Anyone have any thoughts on this? Dave -- Forwarded message -- From: Dave Phillips experiencedcfdevelo...@gmail.com Date: Jan 11, 2012 12:38 PM Subject: cfexchangecalendar busyStatus property To: cf-talk cf-talk@houseoffusion.com Hi all, I tried to send this through a few hours ago, but it hasn't gone through and other messages have, so I'm not sure why. Anyways, if it ends up here twice, please forgive the dual posting. I am trying to set the busyStatus property of an appointment with cfexchangecalendar (the 'Show As' property you see in Outlook: Busy/Tentative/Free/Out of Office). The cfexchangecalendar tag will not accept it as a property, but it is clearly a property according to Microsoft's definition of the Appointment calendar object. Any thoughts? Thanks, Dave ~| 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:349498 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfexchangecalendar busyStatus property
Hi all, I tried to send this through a few hours ago, but it hasn't gone through and other messages have, so I'm not sure why. Anyways, if it ends up here twice, please forgive the dual posting. I am trying to set the busyStatus property of an appointment with cfexchangecalendar (the 'Show As' property you see in Outlook: Busy/Tentative/Free/Out of Office). The cfexchangecalendar tag will not accept it as a property, but it is clearly a property according to Microsoft's definition of the Appointment calendar object. Any thoughts? Thanks, Dave ~| 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:349413 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: problems querying date in access 2007
Just use this: WHERE expenseDate cfqueryparam value=1/1/2006 cfsqltype=cf_sql_timestamp Then you don't have to worry about the format and it's also not DB dependent code. Dave Phillips -Original Message- From: GLM [mailto:g...@glmdesigns.com] Sent: Wednesday, March 03, 2010 7:14 AM To: cf-talk Subject: RE: problems querying date in access 2007 Thx. I was missing the quotes. I thought that ## replaced the quotes. I just tried it with single quotes inside and out; and double quotes inside and out. and it's the same thing. Inside it stays the same. Outside I get errors (Invalid bracketing) or Data mismatch. I'm missing something simple in the syntax with access 2007. Either that or the data in the table is not formatted correctly but I think the data should be correct. The datatype is: date/time with a format of short date. I added a few rows and typed in some data thinking that this new data would have to be good. But that didn't help. -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Wednesday, March 03, 2010 2:17 AM To: cf-talk Subject: Re: problems querying date in access 2007 Is your original query actually missing the quotes? Because this: WHERE expenseDate #1/1/2006# means WHERE expenseDate 0.000498 mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 3 March 2010 11:05, GLM g...@glmdesigns.com wrote: I don't use access too often and there appears to be major differences between 2003 and 2007. I've just wasted the last 2 hours trying to get a simple query to work. I'm trying to make a basic query for example: WHERE expenseDate #1/1/2006# and #1/1/2007#. ~| 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:331301 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: problem with a condition cfif in a cfquery
Alex, You can't use a CF condition within your SQL that you want to evaluate each record in the query. For that, you'd need to use an SQL condition. You could use CF conditions inside your cfquery only to evaluate the 'text' of the query (like to decide WHICH SQL statement to use for example based on values that exist apart from your data). You can use a 'isnull' function to solve this (this is a DATABASE function, not a CF function, and is, therefore, DB dependent). I'm not sure which DB you are using, but for SQL Server it's isnull. For Oracle it's NVL. cfquery name=recipients datasource=labels SELECT isNull(emailaddr1,emailaddr2) as emailaddr ... /cfquery This says, if emailaddr1 has a value, then return it as 'emailaddr', but if it is null, then return the value in emailaddr as 'emailaddr'. If emailaddr2 is also null, then 'emailaddr2' will be null. If you want another default value such as 'N/A', then you would just wrap it all with another function like this: SELECT isNull(isNull(emailaddr1,emailaddr2),'N/A') as emailaddr Hope this helps! Dave Phillips -Original Message- From: alex poyaoan [mailto:ap.cli...@tiscali.it] Sent: Wednesday, March 03, 2010 7:09 AM To: cf-talk Subject: problem with a condition cfif in a cfquery HI everybody I have a table with two email addresses for every person there are cases though that emailaddr1 is empty and emailaddr2 has a value. I need to output the addresses that if emailaddr1 is empty it would be substituted by emailaddr2. I tried using a cfif inside the query written below but doesn't work cfquery name=recipients datasource=labels SELECT cfif (emailaddr1)eq emailaddr2, cfelse emailaddr1/cfif /cfquery cfoutput#recipients#/cfoutput 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:331303 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFIF within CFmail?
Actually, that's not true. You can easily put CFIF inside of your cfmail tag. I've done it for 12+ years! Your only problem was that you used the equals sign (=) instead of EQ. This should work for you: CFMAIL from=#FORM.email# To=t...@test.com cfif form.intype EQ K-12cc=te...@test2.com/Cfif Subject=New Jersey -Original Message- From: I. Addoum. [mailto:sol_xp...@yahoo.com] Sent: Monday, February 22, 2010 9:03 AM To: cf-talk Subject: Re: CFIF within CFmail? that will not work ... you should have your CFIF before the cfmail tag cfif form.intype EQ K-12CFSET V_cc=te...@test2.com CFELSE CFSET V_cc= /Cfif CFMAIL from=#FORM.email# To=t...@test.com cc=#V_cc#Subject=New Jersey From: Orlini, Robert rorl...@hwwilson.com To: cf-talk cf-talk@houseoffusion.com Sent: Mon, February 22, 2010 4:57:08 PM Subject: CFIF within CFmail? Hello, I'm trying to include a cfif within a cfmail. If a form element is K-12, then I want to add a cc to the cfmail part. Here is what I have in part: CFMAIL from=#FORM.email# To=t...@test.com cfif #form.intype#=K-12cc=te...@test2.com/Cfif Subject=New Jersey It generates an error. Is there a better way to do this? Thanks. RO HWW ~| 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:331020 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFIF within CFmail?
Oops, I spoke too soon. That's what I get for NOT reading all the code. You can do this if you want to do it INLINE: CFMAIL from=#FORM.email# To=t...@test.com cc=#iif(form.intype EQ 'K-12',DE('te...@test2.com'),DE(''))# Subject=New Jersey Dave Phillips -Original Message- From: Dave Phillips [mailto:experiencedcfdevelo...@gmail.com] Sent: Monday, February 22, 2010 9:23 AM To: 'cf-talk@houseoffusion.com' Subject: RE: CFIF within CFmail? Actually, that's not true. You can easily put CFIF inside of your cfmail tag. I've done it for 12+ years! Your only problem was that you used the equals sign (=) instead of EQ. This should work for you: CFMAIL from=#FORM.email# To=t...@test.com cfif form.intype EQ K-12cc=te...@test2.com/Cfif Subject=New Jersey -Original Message- From: I. Addoum. [mailto:sol_xp...@yahoo.com] Sent: Monday, February 22, 2010 9:03 AM To: cf-talk Subject: Re: CFIF within CFmail? that will not work ... you should have your CFIF before the cfmail tag cfif form.intype EQ K-12CFSET V_cc=te...@test2.com CFELSE CFSET V_cc= /Cfif CFMAIL from=#FORM.email# To=t...@test.com cc=#V_cc#Subject=New Jersey From: Orlini, Robert rorl...@hwwilson.com To: cf-talk cf-talk@houseoffusion.com Sent: Mon, February 22, 2010 4:57:08 PM Subject: CFIF within CFmail? Hello, I'm trying to include a cfif within a cfmail. If a form element is K-12, then I want to add a cc to the cfmail part. Here is what I have in part: CFMAIL from=#FORM.email# To=t...@test.com cfif #form.intype#=K-12cc=te...@test2.com/Cfif Subject=New Jersey It generates an error. Is there a better way to do this? Thanks. RO HWW ~| 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:331021 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Total Two Field From Two Tables
Instead of this: cfloop query=zip cfif story.fdd_id EQ zip.fdd_id (#NumberFormat(zip.fdcount)#) /cfif /cfloop Use a QofQ (Query of Queries) - it will be faster: cfquery dbtype=query name=qZipCheck SELECT fdcount FROM zip WHERE zip.fdd_id = cfqueryparam value=#story.fdd# cfsqltype=cf_sql_integer /cfquery (#NumberFormat(qZipCheck.fdcount)#) This will avoid having to loop through your zip query for every time through your story loop. Also, I assumed your fdd_id is an integer, if it's not, use cf_sql_varchar for the cfsqltype value instead. Dave -Original Message- From: Barry Mcconaghey [mailto:bmcconag...@gmail.com] Sent: Tuesday, February 16, 2010 7:53 AM To: cf-talk Subject: Re: Total Two Field From Two Tables Good Morning. This code works below but I'm not sure if there is a better way. Please let me know. cfquery name=Zip datasource=#request.dsn# SELECT a.zipcode, f.fdd_zip, f.fdd_name, f.fdd_state, f.fdd_id, count(f.fdd_id) AS FDCount FROM articles a, fddirectory f WHERE a.zipcode = LEFT(f.fdd_zip, 5) AND f.fdd_state = cfqueryparam value=#URL.statecodeID# cfsqltype=CF_SQL_VARCHAR GROUP BY f.fdd_name ORDER BY f.fdd_name ASC /cfquery cfquery name=Story datasource=#request.dsn# SELECT F.fdd_id, F.fdd_name, F.fdd_zip, S.statename, S.abrev FROMfddirectory F, states S WHERE F.fdd_state = cfqueryparam value=#statecodeID# cfsqltype=CF_SQL_VARCHAR AND F.fdd_state = S.abrev ORDER BY fdd_name ASC /cfquery !---Display--- cfoutput query=story #story.fdd_name# cfloop query=zip cfif story.fdd_id EQ zip.fdd_id (#NumberFormat(zip.fdcount)#) /cfif /cfloop br /cfoutput Thanks again for your time, Barry ~| 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:330773 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Total Two Field From Two Tables
Barry, Try this: cfquery name=Zip datasource=#dsn# SELECT a.zipcode, f.fdd_zip, f.fdd_name, a.IsPublished, a.IsActive, f.fdd_state, count(distinct a.zipcode) as zip_count FROM articles a, fddirectory f WHERE a.zipcode = f.fdd_zip AND f.fdd_state = cfqueryparam cfsqltype=cf_sql_varchar value=MD GROUP BY a.zipcode, f.fdd_zip, f.fdd_name, a.IsPublished, a.IsActive, f.fdd_state ORDER BY (whatever order you want them) /cfquery Let me know if this works or not for you. Not sure if it will work right in mySQL or not. If not, try this then: cfquery name=Zip datasource=#dsn# SELECT a.zipcode, f.fdd_zip, f.fdd_name, a.IsPublished, a.IsActive, f.fdd_state FROM articles a, fddirectory f WHERE a.zipcode = f.fdd_zip AND f.fdd_state = cfqueryparam cfsqltype=cf_sql_varchar value=MD ORDER BY (whatever order you want them) /cfquery cfquery dbtype=query name= qZipTotals Select zipcode,count(*) as zip_count From Zip Group by zipcode Order by zipcode /cfquery ... now inside your loop, do this: cfloop query=Zip cfquery dbtype=query name=qGetThisZipCount Select zip_count from qZipTotals Where zipcode = cfqueryparam value=#Zip.zipcode# cfsqltype=cf_sql_varchar /cfquery cfoutput#fdd_name# (#qGetThisZipCount.zip_count#)br/cfoutput /cfloop This is using query of queries so you don't have to hit the database twice. There are a number of ways to accomplish this. Dave Phillips ~| 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:330759 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Total Two Field From Two Tables
What didn't work with the second set of queries? Did you get an error message? That logic is sound. There might be some syntax issues as I didn't test it... Dave -Original Message- From: Barry Mcconaghey [mailto:bmcconag...@gmail.com] Sent: Monday, February 15, 2010 10:28 PM To: cf-talk Subject: Re: Total Two Field From Two Tables Hi Dave. Thanks for the code! Those two did not work. I got two queries to work perfect but I don't know how to display them. !---Get all data--- cfquery name=Story datasource=#request.dsn# SELECT F.fdd_id, F.fdd_name, F.fdd_zip, S.statename, S.abrev FROMfddirectory F, states S WHERE F.fdd_state = cfqueryparam value=MD cfsqltype=CF_SQL_VARCHAR AND F.fdd_state = S.abrev ORDER BY fdd_name /cfquery !---Count each fdd_name--- cfquery name=Zip datasource=#request.dsn# SELECT a.zipcode, f.fdd_zip, f.fdd_name, f.fdd_state, count(f.fdd_id) AS FDCount FROM articles a, fddirectory f WHERE a.zipcode = LEFT(f.fdd_zip, 5) AND f.fdd_state = cfqueryparam cfsqltype=cf_sql_varchar value=MD GROUP BY f.fdd_name ORDER BY f.fdd_name ASC /cfquery !---Display--- cfoutput query=zip #fdd_name# (#NumberFormat(zip.fdcount)# br /cfoutput This works great but it only displays fdd_name when a.zipcode = LEFT(f.fdd_zip, 5). I would like to display something like this: cfoutput !---Display all fdd_name--- #story.fdd_name# !---Display this if GT '0'--- (#NumberFormat(zip.fdcount)# br /cfoutput Thanks for your time. Barry ~| 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:330763 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to query encrypted password
Oh yeah, YES - It's the Yodeling Encryption System - the method is quite simple actually, but deeply mathematical in principle - Each encryption is done using a key of the binary data produced by a 10 second yodeler. No two yodels are alike, of course, so that produces a mathematically impossible to break algorithm that then locks down your data so hard that it can never be unlocked. Of course, the practical implications are limited. Dave Phillips (one who watches Numb3rs too much!) -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, January 06, 2010 12:25 PM To: cf-talk Subject: Re: How to query encrypted password Interesting - I have never heard of the encryption algorithm called Yes. It's very flexible! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VSOB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:329442 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cftransaction
I'm pretty sure the rollback is not occurring because your cfstoredproc call inside your saveDataToDatabase() function is running in it's own transaction. I think you'd need to include a rollback; command inside your stored procedure if you have a failure. Dave -Original Message- From: Christophe Maso [mailto:zum...@hotmail.com] Sent: Friday, December 11, 2009 10:12 AM To: cf-talk Subject: cftransaction Hi all, I understand the gist of cftransaction, but I've tried using it with a conditional rollback on an action page in the below example and it doesn't seem to work. saveDataToDatabase() submits data to a stored procedure, which always returns a string: empty string if the data was saved, or a message stating what the problem was if not. cfset allReturnMessages = cftransaction cfloop cfset returnMessage = someCFC.saveDataToDatabase() cfset allReturnMessages = allReturnMessages returnMessage br /cfloop cfif len(trim(allReturnMessages)) cftransaction action=rollback / /cfif /cftransaction I'm not including cftry in this example, just to illustrate that I'm not looking for a database or other type of CF error per se - rather, I'm looking for any return message from the stored proc that isn't an empty string, such as sorry - everything is otherwise kosher, but this stored proc is coded not to save the data if field x is above value y. That's not a database error as far as CF is concerned, so cftry wouldn't catch it. But in testing this code, I've found that the rollback doesn't take place, even when the cfif statement is true. Am I not using cftransaction correctly? ~| 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:329096 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: convert this cfscript back to tag?
Glyn, cfloop from=1 to=#listLen(form.whatToUpdate)# index=i cfset tempVal = listGetAt(form.whatToUpdate,i) cfset form.ID = tempval !--- Option ID --- cfset form.newRank = form[rank_ tempVal] /cfloop Hope this helps! Dave Phillips -Original Message- From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] Sent: Thursday, December 10, 2009 8:43 AM To: cf-talk Subject: convert this cfscript back to tag? Hi all, could someone convert this cfscript back to tag? for(i=1;i lte listlen(#form.whatToUpdate#,,);i++){ tempVal = #listgetat(form.whatToUpdate,i,,)#; form.ID = #tempVal#; //Option ID form.newRank = form[rank_ #tempVal#]; } 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:329044 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: \ColdFusion8\Mail\Spool
John, Anything revealing in your mail log? I've seen this behavior before, but not with CF 8. It was with older versions. We ended up scheduling a nightly restart of the service to alleviate things like this occurring. Dave Phillips -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Tuesday, December 08, 2009 7:17 AM To: cf-talk Subject: C:\ColdFusion8\Mail\Spool So this AM, my production server had not sent me my usual batch of emails (via cfmail). I went to Server Settings Mail, checked Verify mail server connection, clicked Submit Changes, and received Connection Verification Successful. I stopped and restarted my SMTP server and then noticed that email I was expecting to receive was sitting in C:\ColdFusion8\Mail\Spool. I stopped and restarted the CF server (CF 8 with CHF 4) and now all of the mail is being delivered. Is this a fluke? Known issue? Anything I can do to prevent it from recurring? Thanks! -- John Bliss IT Professional @jbliss (t) / http://www.brandiandjohn.com ~| 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:328946 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLogout confusion
Yes, I believe so. www is a 'subdomain', albeit a standard one, just like any other 'subdomain' (whatever.mysite.com for example) and each one represents a potentially different domain and therefore a different session. I've experienced this to, but in a positive way. When I did a site for a client, the requirement was to create 'affiliate' sites like this: Affiliate1.mysite.com Affiliate2.mysite.com And so on.this worked to my advantage of course, if someone was on affiliate1's site and logged in and doing something, they should not be logged into affiliate2's site and vice versa. Dave Phillips -Original Message- From: Stefan Richter [mailto:ste...@flashcomguru.com] Sent: Tuesday, November 10, 2009 8:03 AM To: cf-talk Subject: CFLogout confusion I'm using cflogin and cflogout on my site. A user is logged into http://www.mysite.com and then clicks log out. I run cflogout and redirect her to http://mysite.com (note I missed the www off). There seems to be some kind of double session going on when I previously logged into http://www.mysite.com as well as http://mysite.com because after the logout I still see to be logged in as the user who previously logged into the other respective site (of course there is only one site). I hope this makes sense. Is this expected behaviour? Stefan ~| 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:328175 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Session is invalid error is driving me nuts!
Steve, There are a number of ways (probably more than I'm listing here): 1. If you're using Application.cfm, sdd code to it so that if of your session (say, session.logged_in) is undefined, then it will redirect the user to a login page. This way, the 'processing' page for your form never even gets loaded and the result is no error (just a frustrated user from having filled out the form and now they will have to do it again) 2. Add a meta tag redirect to your form page that matches your session timeout. Although this is a client side redirect, it can accomplish pretty much the same thing - if there is no activity in the browser for that period of time, the page redirects to a specified page (your session has timed out, click here to login) or something like that. I would prefer option 1, but others prefer option 2. There are probably some other options some may have here on the list as well. Dave Phillips -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Wednesday, November 04, 2009 1:02 PM To: cf-talk Subject: Session is invalid error is driving me nuts! All, Ok, this is a little pet peeve of mine. We have session timeout set and we tell users that they have to do something within so much time. Problem is the users ignore that. They open a page with a form, leave it open for an hour, then when they submit the form Session is invalid error. They see a nicely formatted An Error has occurred page, but I get an email for each one. Any ideas (besides changing the timeout) of what I might do to prevent this? I have toyed with the idea of locking the form and putting up a message saying that they timed out. Then they would have to close the window/tab. Even if they hit refresh it would generate a new session, so no error. I'm just not sure of the best way to go about that. Also, anything I'd try to figure out should be able to just be cfincluded or done in Application.cfm/cfc so that I don't have to go through hundreds of files to solve this one. Thanks, Steve ~| 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:328034 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Session is invalid error is driving me nuts!
Oh, I meant to add that if you are using application.cfc instead of .cfm, then you would put your code to redirect in the OnSessionEnd function. Dave -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Wednesday, November 04, 2009 1:02 PM To: cf-talk Subject: Session is invalid error is driving me nuts! All, Ok, this is a little pet peeve of mine. We have session timeout set and we tell users that they have to do something within so much time. Problem is the users ignore that. They open a page with a form, leave it open for an hour, then when they submit the form Session is invalid error. They see a nicely formatted An Error has occurred page, but I get an email for each one. Any ideas (besides changing the timeout) of what I might do to prevent this? I have toyed with the idea of locking the form and putting up a message saying that they timed out. Then they would have to close the window/tab. Even if they hit refresh it would generate a new session, so no error. I'm just not sure of the best way to go about that. Also, anything I'd try to figure out should be able to just be cfincluded or done in Application.cfm/cfc so that I don't have to go through hundreds of files to solve this one. Thanks, Steve ~| 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:328036 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Education
I can remember coding I did from more than 10 years ago, but I can't remember to pick up milk when I go to the grocery store for diapers (or vice versa!). I suppose that' what 40 will do to you! BTW - to chime in on the whole education thread - I have a BA degree in Religion which, as you can tell, perfectly qualifies me to be a ColdFusion developer. :) On top of that, I didn't earn my BA until I was 35 years old (of course, I started it when I was 28 - yeah, I know, 7 years...but hey, at least I finished it!). I have never been held back from my career because of a lack of a degree, let alone a technology degree, however, since I now have aspirations for management, I am working on a MS degree in CIS as it will help to get my resume in front of the right people for a management position in other companies. Although I would rather move up in my company, I just don't know what the prospects for that will be like in 3-5 years when I'm ready to move into management, so until then, I'll finish up this MS degree and then work on my MBA. Once I have MBA and MS in CIS, then I feel with my 20 years of IT experience that I will be perfectly qualified to jump into a management position. Dave -Original Message- From: s. isaac dealey [mailto:i...@turnkey.to] Sent: Saturday, October 24, 2009 3:18 PM To: cf-talk Subject: Re: Education I get you though...it strikes me as odd when others can't see the patterns I do. For me I think it's due to my memory...it even scares me sometimesremembering line numbers or code above/below the code you are remembering 5 years after writing it is just creepy. Now that's some memory! Mine isn't that good. I have a darned good memory for technical details, but it's typically selective. So I remember the formula for the volume of a cone, which I've never used, but I misremember the release schedule for versions of ColdFusion. ;) In my case in particular, my skills are fairly slanted toward the technical, meaning that my people skills are rusty. Just means I have to work harder at them, but at least now I know why and I've been able to find some books that I think are really helping me to shore up my challenge areas. Just finished reading Words that Work, Crucial Conversations, Influencer, Carol Dweck's Mindset and a few others this year. And boy let me tell you, there are things in there I wish I'd known when I presentated at cf.Objective a few years ago. :) Well if this application development thing doesn't work out I can always be a circus freak ;-) Maybe we missed our calling. ;) -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301 http://onTap.riaforge.org/blog ~| 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:327649 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Sorting 2d arrays
Tony, Probably a ton of ways to do this. Would this get you what you want?: (note: the below would be for oracle, you need + instead of || for Sql server - not sure about what db you're using) cfquery datasource=whatever name=qMySuggestions select sql_id, alphanumeric_id || description as auto_suggest_descr from mytable union select sql_id, description || alphanumeric_id as auto_suggest_descr from mytable order by augo_suggest_descr /cfquery Now you should have a query with the results in the order you want them with the original sql_id also there. Now instead of looping through an array to do a match, you simply do a query of query: cfquery name=qFindMatch dbtype=query SELECT sql_id FROM qMySuggestions WHERE (put your condition here to find a match) /cfquery qFindMatch.sql_id is the record you want. Dave Phillips ~| 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:327252 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, 64 bit, and Microsoft Access
If it's shared hosting, then you're probably out of luck because you are at their mercy. If you have a virtual server, however, then maybe you can try installing the access 32 bit odbc driver on your 64 bit system, and then use it through the ODBC Socket driver in ColdFusion.it's worth a try... Dave -Original Message- From: John Pullam [mailto:jpul...@mcleansystems.com] Sent: Thursday, October 15, 2009 12:02 PM To: cf-talk Subject: CF8, 64 bit, and Microsoft Access I've just been told by my ISP that CF8 doesn't support Microsoft Access on a 64 bit server, and seeing as they are implementing it on a 64 bit server, I'm in trouble. Don't get me wrong--I understand that Access isn't strategic and I will be moving away from it, but I have an app that gets an Access mdb and must process it and I really need to move up to CF8 to start adding Ajax features. Is it true? And if yes, is there anything I can do? Are there technical alternatives to allow me to use Access from a 64 bit CF8 system? I looked at the brief CF9 doc on the Adobe site and it implied that Access is fully supported. ~| 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:327255 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Browser not recognizing CFM tags
It's possible if you associated .CFM files with an editor on your local machine and you did File/open in your browser and you selected a .CFM that was local on your machine that your browser might 'appear' to open the file, when, in reality, the associated program you associated with the .cfm files would actually be opening it. It might open 'in-line' in the browser, or externally in the associated program. I haven't attempted this, just trying to explain what may have gotten you those results in the past. Dave Phillips -Original Message- From: Timothy Laureska [mailto:tlaure...@dhmh.state.md.us] Sent: Tuesday, October 13, 2009 10:28 AM To: cf-talk Subject: Re: Browser not recognizing CFM tags yes, that works... its been a while since I worked in CF - I really seem to remember it working with just a file/open as well... maybe my feeble mind is failing me And thanks to all that helped ~| 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:327136 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Upgrading from CF MX6.1 to 8 - Verity question....
Hi all, We have an app that has been in 6.1 for years and we are finally working on upgrading it to CF 8. My questions is simple, although I'm afraid the answer will not be: Why does it take 5 times as long to create a collection in CF 8 as it does to create a collection CF MX 6.1 ? We have a module that creates about 24 collections. Each collection takes about 2 seconds to create in MX 6.1. In CF 8, they take around 10-12 seconds to create. This is Windows platform. I even checked to see if CF 8 collections have more files, and while, an empty collection in MX 6.1 has 27 files and 20 folders, an empty collection in CF 8 has 30 files, but only 9 folders. 47 hits to the OS in MX 6.1 and only 39 in CF 8 and it still takes 5 times as long. We have other modules that actually do indexing in these collections and those have also been running about 5 times as long. Has anyone run into this and, if so, can it be explained? Is there possibly something wrong? Thanks! Dave Phillips ~| 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:327045 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: modifying a query object
Chad, I had to do this very same thing for cfindex. There is another alternative - look for a stored procedure code for your database server that strips HTML. If you can find one, you can transform it in the database before you get it. Dave -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] Sent: Wednesday, October 07, 2009 3:39 PM To: cf-talk Subject: RE: modifying a query object Query of queries offer no string manipulation. Therefore I would recommend a cfloop over the result set and a regular expression applied to each record. ~Brad Original Message Subject: modifying a query object From: Chad Gray cg...@careyweb.com Date: Wed, October 07, 2009 3:06 pm To: cf-talk cf-talk@houseoffusion.com So I am doing a query on a database and passing the query object to CFIndex to refresh a Verity collection. I need to remove some characters (HTML tags in the query result) from the query object before passing it to CFIndex. What is the best way to find/replace the HTML tags in the query object before passing the query to CFIndex? ~| 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:327007 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: modifying a query object
In our case, we couldn't do it in the DB (Oracle) because we were dealing with CLOB's and they were just too big. Once we had it in a CF query, however, looping over the results wasn't a big deal because this was working in a nightly batch job anyway. Hey anyone, does CF 9 allow this: cfquery dbtype=query UPDATE myQuery SET myString = replace(myString,no,NO,all) /cfquery Now THAT would be nice... ;-) Dave -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] Sent: Wednesday, October 07, 2009 3:59 PM To: cf-talk Subject: RE: modifying a query object Good point Dave. I had jumped to the conclusion that the OP had no control over the SQL being run on the database. I'm not going to promise the database will be any faster depending on how complex of a replacement you need, but doing it prior to the app server is a definite option. ~Brad Original Message Subject: RE: modifying a query object From: Dave Phillips experiencedcfdevelo...@gmail.com Date: Wed, October 07, 2009 3:47 pm To: cf-talk cf-talk@houseoffusion.com Chad, I had to do this very same thing for cfindex. There is another alternative - look for a stored procedure code for your database server that strips HTML. If you can find one, you can transform it in the database before you get it. Dave ~| 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:327010 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: GROUP BY problem...
Which database server are you using? Some allow you the ability to return an aggregate of values in the form of a comma delimited list. You might be able to get your result set to look like this: EMPID NAME OFFICES 1 DaveBoston (NE), Dallas (SW), Miami (SE) 2 JohnSan Diego (W), New Orleans (S) Is that the kind of result set you are looking for? Dave -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Friday, October 02, 2009 11:10 AM To: cf-talk Subject: GROUP BY problem... SELECT employees.empID employees.name, employees_office.theORDER office.office_name areas.area_NAME FROM employees INNER JOIN employees_office ON employees.empID = employees_office.empID INNER JOIN office ON employees_office.id_office = dbo.office.office_id INNER JOIN areas ON areas.empID = employees_office.empID ORDER BY employees.name, employees_office.theORDER OK, here's the problem I need to be able to GROUP BY employees.empID so each employee is returned only ONCE (a unique empID), but, I can't include any of the columns in the other tables in the GROUP BY, because there may be multiple records from those tables. An employee may exist in more than one city and may also be assigned to many areas. So, get the employee only ONCE, but return multiples from the other joined tables. Obviously using just GROUP BY empID get us the columns not included in aggregrate error. I'm not sure how to fix this. I'd like to do it one query, not multipe queries... Advice? ~| 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:326847 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ssl
My guess is you don't have a valid security certificate on the server. If you have any cert installed, Firefox is first going to get that cert info from the web server before your request ever gets to ColdFusion. What you probably need to do is turn off the SSL on that site if you don't want people going to it. If you want to accomplish the redirect below without a warning, you'll have to install a valid certificate. Dave -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, October 02, 2009 1:43 PM To: cf-talk Subject: ssl I have some code in application.cfm that is supposed to re-direct the user to a non-ssl version of the page. !--- redirect to non-SSL --- cfif CGI.HTTPS eq on cfif Len(CGI.QUERY_STRING) cflocation url=http://www.#CGI.SERVER_NAME##CGI.PATH_INFO#?#CGI.QUERY_STRING#; addtoken=no cfelse cflocation url=http://www.#CGI.SERVER_NAME##CGI.PATH_INFO#; addtoken=no /cfif /cfif I get this error in Firefox when I try to use it: Secure Connection Failed invalid security certificate. The certificate is not trusted because the issuer certificate is unknown. (Error code: sec_error_unknown_issuer) * This could be a problem with the server's configuration, or it could be someone trying to impersonate the server. * If you have connected to this server successfully in the past, the error may be temporary, and you can try again later. Any ideas why this would happen? Thanks! Chad ~| 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:326849 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ssl
How about a client side redirect? cfif CGI.HTTPS eq on cfif Len(CGI.QUERY_STRING) scriptwindow.location = 'cfoutputhttp://www.#CGI.SERVER_NAME##CGI.PATH_INFO#?#CGI.QUERY_STRING#/c foutput';/script cfabort cfelse scriptwindow.location = 'cfoutputhttp://www.#CGI.SERVER_NAME##CGI.PATH_INFO#/cfoutput';/script cfabort /cfif /cfif Maybe Firefox is trying to protect a user from hitting an SSL page that has been hijacked somehow Dave -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, October 02, 2009 2:06 PM To: cf-talk Subject: RE: ssl I remove the code and hit the web site with ssl and it works fine. I know the certificate is good. https://www.beeculture.com/ This one has me stumped. -Original Message- From: Dave Phillips [mailto:experiencedcfdevelo...@gmail.com] Sent: Friday, October 02, 2009 2:58 PM To: cf-talk Subject: RE: ssl My guess is you don't have a valid security certificate on the server. If you have any cert installed, Firefox is first going to get that cert info from the web server before your request ever gets to ColdFusion. What you probably need to do is turn off the SSL on that site if you don't want people going to it. If you want to accomplish the redirect below without a warning, you'll have to install a valid certificate. Dave -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, October 02, 2009 1:43 PM To: cf-talk Subject: ssl I have some code in application.cfm that is supposed to re-direct the user to a non-ssl version of the page. !--- redirect to non-SSL --- cfif CGI.HTTPS eq on cfif Len(CGI.QUERY_STRING) cflocation url=http://www.#CGI.SERVER_NAME##CGI.PATH_INFO#?#CGI.QUERY_STRING#; addtoken=no cfelse cflocation url=http://www.#CGI.SERVER_NAME##CGI.PATH_INFO#; addtoken=no /cfif /cfif I get this error in Firefox when I try to use it: Secure Connection Failed invalid security certificate. The certificate is not trusted because the issuer certificate is unknown. (Error code: sec_error_unknown_issuer) * This could be a problem with the server's configuration, or it could be someone trying to impersonate the server. * If you have connected to this server successfully in the past, the error may be temporary, and you can try again later. Any ideas why this would happen? Thanks! Chad ~| 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:326851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ssl
I think that simply translates what the user typed. If they typed in the www, then it will be part of it. If not, it won't. The CGI doesn't look into your web server to see what your actual domain name is. Do this: cfdump var=#cgi# This will give you all the CGI variables and you can figure out what your results actually are with different attempts. Dave -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, October 02, 2009 2:30 PM To: cf-talk Subject: RE: ssl I tried this code and it takes me to http://www.www.beeculture.com/ www. Should not be part of CGI.ServerName right? -Original Message- From: Dave Phillips [mailto:experiencedcfdevelo...@gmail.com] Sent: Friday, October 02, 2009 3:16 PM To: cf-talk Subject: RE: ssl How about a client side redirect? cfif CGI.HTTPS eq on cfif Len(CGI.QUERY_STRING) scriptwindow.location = 'cfoutputhttp://www.#CGI.SERVER_NAME##CGI.PATH_INFO#?#CGI.QUERY_STRING# /c foutput';/script cfabort cfelse scriptwindow.location = 'cfoutputhttp://www.#CGI.SERVER_NAME##CGI.PATH_INFO#/cfoutput';/scrip t cfabort /cfif /cfif Maybe Firefox is trying to protect a user from hitting an SSL page that has been hijacked somehow Dave -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, October 02, 2009 2:06 PM To: cf-talk Subject: RE: ssl I remove the code and hit the web site with ssl and it works fine. I know the certificate is good. https://www.beeculture.com/ This one has me stumped. -Original Message- From: Dave Phillips [mailto:experiencedcfdevelo...@gmail.com] Sent: Friday, October 02, 2009 2:58 PM To: cf-talk Subject: RE: ssl My guess is you don't have a valid security certificate on the server. If you have any cert installed, Firefox is first going to get that cert info from the web server before your request ever gets to ColdFusion. What you probably need to do is turn off the SSL on that site if you don't want people going to it. If you want to accomplish the redirect below without a warning, you'll have to install a valid certificate. Dave -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, October 02, 2009 1:43 PM To: cf-talk Subject: ssl I have some code in application.cfm that is supposed to re-direct the user to a non-ssl version of the page. !--- redirect to non-SSL --- cfif CGI.HTTPS eq on cfif Len(CGI.QUERY_STRING) cflocation url=http://www.#CGI.SERVER_NAME##CGI.PATH_INFO#?#CGI.QUERY_STRING#; addtoken=no cfelse cflocation url=http://www.#CGI.SERVER_NAME##CGI.PATH_INFO#; addtoken=no /cfif /cfif I get this error in Firefox when I try to use it: Secure Connection Failed invalid security certificate. The certificate is not trusted because the issuer certificate is unknown. (Error code: sec_error_unknown_issuer) * This could be a problem with the server's configuration, or it could be someone trying to impersonate the server. * If you have connected to this server successfully in the past, the error may be temporary, and you can try again later. Any ideas why this would happen? Thanks! Chad ~| 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:326858 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ssl
But you said the cert works fine in firefox when you go the https://www.beeculture.com, right? That's why I think Firefox is trying to recognize the server side redirect and thinks it might be a hacking attempt. Microsoft probably would never be so thoughtful to put that into IE. ;-) On the other hand, if that is the case, then it's a headache for you and you may have to put some firefox specific code into place (i.e. the client-side redirect, only if it's firefox). Dump the CGI scope, I think you'll find everything you need there to accomplish what you need... Dave -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, October 02, 2009 2:35 PM To: cf-talk Subject: RE: ssl OH.. hang on it only errors in firefox. I tried IE and the certificate and my original code work fine (after I remove the www.) CGI.ServerName does include www. (DUH!). Now I just have to figure out why the SSL cert does not work in FireFox. -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, October 02, 2009 3:30 PM To: cf-talk Subject: RE: ssl I tried this code and it takes me to http://www.www.beeculture.com/ www. Should not be part of CGI.ServerName right? -Original Message- From: Dave Phillips [mailto:experiencedcfdevelo...@gmail.com] Sent: Friday, October 02, 2009 3:16 PM To: cf-talk Subject: RE: ssl How about a client side redirect? cfif CGI.HTTPS eq on cfif Len(CGI.QUERY_STRING) scriptwindow.location = 'cfoutputhttp://www.#CGI.SERVER_NAME##CGI.PATH_INFO#?#CGI.QUERY_STRING# /c foutput';/script cfabort cfelse scriptwindow.location = 'cfoutputhttp://www.#CGI.SERVER_NAME##CGI.PATH_INFO#/cfoutput';/scrip t cfabort /cfif /cfif Maybe Firefox is trying to protect a user from hitting an SSL page that has been hijacked somehow Dave -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, October 02, 2009 2:06 PM To: cf-talk Subject: RE: ssl I remove the code and hit the web site with ssl and it works fine. I know the certificate is good. https://www.beeculture.com/ This one has me stumped. -Original Message- From: Dave Phillips [mailto:experiencedcfdevelo...@gmail.com] Sent: Friday, October 02, 2009 2:58 PM To: cf-talk Subject: RE: ssl My guess is you don't have a valid security certificate on the server. If you have any cert installed, Firefox is first going to get that cert info from the web server before your request ever gets to ColdFusion. What you probably need to do is turn off the SSL on that site if you don't want people going to it. If you want to accomplish the redirect below without a warning, you'll have to install a valid certificate. Dave -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, October 02, 2009 1:43 PM To: cf-talk Subject: ssl I have some code in application.cfm that is supposed to re-direct the user to a non-ssl version of the page. !--- redirect to non-SSL --- cfif CGI.HTTPS eq on cfif Len(CGI.QUERY_STRING) cflocation url=http://www.#CGI.SERVER_NAME##CGI.PATH_INFO#?#CGI.QUERY_STRING#; addtoken=no cfelse cflocation url=http://www.#CGI.SERVER_NAME##CGI.PATH_INFO#; addtoken=no /cfif /cfif I get this error in Firefox when I try to use it: Secure Connection Failed invalid security certificate. The certificate is not trusted because the issuer certificate is unknown. (Error code: sec_error_unknown_issuer) * This could be a problem with the server's configuration, or it could be someone trying to impersonate the server. * If you have connected to this server successfully in the past, the error may be temporary, and you can try again later. Any ideas why this would happen? Thanks! Chad ~| 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:326859 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Code being truncated...
Hi all, CF8 - Linux environment We have a situation where the code in our module is being truncated. It's at a specific length ( characters). If I add or remove enough characters where the truncation occurs within a CF tag, I get a CF error on the page. If I add/remove enough characters so that the truncation happens within just regular HTML, then I don't get a CF error, but my output still doesn't look right because of the truncation. All content in the file past this point of truncation never makes it to the browser. Here's what we've tried to troubleshoot it: 1. We've taken the exact same code and ran it on another CF8 - Linux server and get the same result. 2. We've taken the exact same code and ran it on a Windows CF8 server and it works without a problem. 3. We've taken the exact same code and ran it on a Windows MX 6.1 server and it works without a problem. 4. We've changed the filename to a .html extension and it loads just fine in the Linux environment without truncating any content. Any ideas what might be causing this? (and yes Brad, I know - I always get the weird ones!) Thanks! Dave Phillips ~| 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:325933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Code being truncated...
Hi all, CF8 - Linux environment We have a situation where the code in our module is being truncated. It's at a specific length ( characters). If I add or remove enough characters where the truncation occurs within a CF tag, I get a CF error on the page. If I add/remove enough characters so that the truncation happens within just regular HTML, then I don't get a CF error, but my output still doesn't look right because of the truncation. All content in the file past this point of truncation never makes it to the browser. Here's what we've tried to troubleshoot it: 1. We've taken the exact same code and ran it on another CF8 - Linux server and get the same result. 2. We've taken the exact same code and ran it on a Windows CF8 server and it works without a problem. 3. We've taken the exact same code and ran it on a Windows MX 6.1 server and it works without a problem. 4. We've changed the filename to a .html extension and it loads just fine in the Linux environment without truncating any content. Any ideas what might be causing this? (and yes Brad, I know - I always get the weird ones!) Thanks! Dave Phillips ~| 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:325934 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Code being truncated...
Hi all, CF8 - Linux environment We have a situation where the code in our module is being truncated. It's at a specific length ( characters). If I add or remove enough characters where the truncation occurs within a CF tag, I get a CF error on the page. If I add/remove enough characters so that the truncation happens within just regular HTML, then I don't get a CF error, but my output still doesn't look right because of the truncation. All content in the file past this point of truncation never makes it to the browser. Here's what we've tried to troubleshoot it: 1. We've taken the exact same code and ran it on another CF8 - Linux server and get the same result. 2. We've taken the exact same code and ran it on a Windows CF8 server and it works without a problem. 3. We've taken the exact same code and ran it on a Windows MX 6.1 server and it works without a problem. 4. We've changed the filename to a .html extension and it loads just fine in the Linux environment without truncating any content. Any ideas what might be causing this? (and yes Brad, I know - I always get the weird ones!) Thanks! Dave Phillips ~| 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:325935 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Code being truncated...
Hi all, CF8 - Linux environment We have a situation where the code in our module is being truncated. It's at a specific length ( characters). If I add or remove enough characters where the truncation occurs within a CF tag, I get a CF error on the page. If I add/remove enough characters so that the truncation happens within just regular HTML, then I don't get a CF error, but my output still doesn't look right because of the truncation. All content in the file past this point of truncation never makes it to the browser. Here's what we've tried to troubleshoot it: 1. We've taken the exact same code and ran it on another CF8 - Linux server and get the same result. 2. We've taken the exact same code and ran it on a Windows CF8 server and it works without a problem. 3. We've taken the exact same code and ran it on a Windows MX 6.1 server and it works without a problem. 4. We've changed the filename to a .html extension and it loads just fine in the Linux environment without truncating any content. Any ideas what might be causing this? (and yes Brad, I know - I always get the weird ones!) Thanks! Dave Phillips ~| 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:325936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Code being truncated...
Okay, so I'm going to answer my own question here for those who encounter this in the future. Apparently, the feature that Word has to save a Word Doc as filtered HTML is a little buggy... (surprise!). We had a form in Word and saved it as HTML (filtered) so it wouldn't have all the word specific tags in it. It turns out that there were three special characters that were NOT filtered when the html was saved. Two I've encountered before: the Word hyphen (ascii character 8211) and the Word apostrophe (ascii character 8217). In addition, we had checkboxes on the form (Word checkboxes, not HTML) and instead of Word converting those to HTML checkboxes, it saved them as ascii character 160, which happens to appear on your screen as a space (nice!). Bottom line is, what I had to do was take the entire content and stick it in a variable on my windows box (since it wasn't truncating on Windows) and loop through every character in the content and find the ones that were over ascii value 127. Once I did this, I found 160, 8211 8217. I then did some replaces on them and outputted the new content to the screen. I copied that from the source, saved it in my ORIGINAL CFM module and ran it and voila, no truncation. It is apparent that ColdFusion ON Linux has a problem with these characters. It's not the Linux web server (in our case WebSphere) because it worked fine with the special characters in the HTML file, but specifically ColdFusion. Anyway, just wanted to pass along the solution for those searching for this quirky behavior in the future. Dave Phillips ~| 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:325937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using CFReport in a Websphere (linux) environment
Ain't that the truth - I guess I'm just lucky... Okay, I saw that post, and I don't have the ability to change the application environment by installing anything, but I do have the ability to modify the JVM configuration. It seems to me that the problem is that the system cannot find the class that is needed, and that if I were to locate that class within the CF installation (or the websphere installation) and add that path to the classpath option in the JVM config that this would solve my problem. The issue is I'm not sure where to look for this class or even how to find it easily (if that is even a possibility). Any thoughts? I'm copying the DFW CFUG group on this so sorry for anyone who gets it twice. Oh, and yes, the environment is headless - it is a 'websphere server farm'. I'll copy Dave on this e-mail as well. Thanks! Dave Phillips -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] Sent: Thursday, August 27, 2009 1:06 PM To: cf-talk Subject: RE: Using CFReport in a Websphere (linux) environment You always find the weird ones Dave. :) I don't have an answer, but it appears you aren't the first with the problem: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:29706 You could try Barney's suggestion of installing X11, or perhaps you can get a hold of Dave Carabetta and see how he fixed his problem. http://www.cbetta.com I assume your Linux install is running headless? ~Brad Original Message Subject: Using CFReport in a Websphere (linux) environment From: Dave Phillips experiencedcfdevelo...@gmail.com Date: Thu, August 27, 2009 11:40 am To: cf-talk cf-talk@houseoffusion.com Hi all, I'm trying to create a simple report with CFReport (CF 8) and am getting the following error: Error 500: Could not find class: com.gp.java2d.ExHeadlessGraphicsEnvironment ~| 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:325831 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Using CFReport in a Websphere (linux) environment
Hi all, I'm trying to create a simple report with CFReport (CF 8) and am getting the following error: Error 500: Could not find class: com.gp.java2d.ExHeadlessGraphicsEnvironment Can anyone give me any direction on how to solve this problem? I've tried CFREPORT with type=PDF or type=FlashPaper and get it with both of them. I've confirmed that the report works fine on my local windows development machine, so there is nothing wrong with the report file or the CFM file. Thanks! Dave Phillips ~| 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:325787 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Regex Help - Can this be simplified?
I'm not an expert with Regex, but you could do this: cfset finalDescription = replace(replace(replace(trim(form.description),br,br/,all),p/p ,br /br /,all),p,br /br /,all) Again, this is not regex, but it is a much more simplified (and faster I believe) way of doing the same thing with 1 line of code. Dave Phillips -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Thursday, August 13, 2009 1:14 PM To: cf-talk Subject: Regex Help - Can this be simplified? Is there a way using CF's Regex functions to simplfy the lines of code below into one line? Some kind of built in regex list comparison maybe? cfset finalDescription = replace(trim(form.description), br, br /, ALL) cfset finalDescription = replace(finalDescription, p/p, br /br /, ALL) cfset finalDescription = replace(finalDescription, p, br /br /, ALL) Thanks, CV ~| 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:325436 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Regex Help - Can this be simplified?
This, of course, is completely a matter of opinion. I prefer 1 line - faster processing, and still easy to support. Again, that's MY opinion, and I'm sure we have about a hundred other opinions on this list. There's no doubt that there are many ways to accomplish something in ColdFusion. But an alternate method should not be shot down as not simplified especially when the provider of the alternate method was just trying to help. Dave Phillips -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Thursday, August 13, 2009 1:29 PM To: cf-talk Subject: Re: Regex Help - Can this be simplified? less lines != simplified :) A year from now, which version are you going to want to come back to when it needs work? The 3 line version or the 1? I'd prefer the 3. Easier to read. ~| 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:325440 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: valueList not giving me what i want.. quick look
I think Francios meant something like this: cfoutput query=getAce group=title cfquery dbtype=query name=qAids select aid from getAce where title = cfqueryparam value=#getAce.title# cfsqltype=cf_sql_varchar /cfquery aid: #valueList(qAids.aid)# /cfoutput That should give you your comma delimited list of only the aid values that match the current title in the grouping. Dave Phillips -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Tuesday, August 11, 2009 10:54 AM To: cf-talk Subject: Re: valueList not giving me what i want.. quick look Then something like...? cfoutput query=getAce group=title cfset thisaid = cfoutput cfset thisaid = ListAppend(thisaid, getAce.aid) /cfoutput aid: #thisaid# /cfoutput ~| 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:325336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Decipher CFLDAP date values
Wally, I don't know if you figured this out yet or not, but using this page: http://techtasks.com/code/viewbookcode/1607 And trying to convert that code to ColdFusion, I think I'm close, but not quite there. Here's what I have, maybe with this, you can figure it out (I don't know what the correct date/time stamp actually is: cfset sLDAPDate = 128922162522263907 cfset iLogonTime = left(sLDAPDate,4) * (2^32) + right(sLDAPDate,4) cfset iLogonTime = iLogonTime / (60 * 1000) cfset iLogonTime = iLogonTime / 1440 cfset iLogonTime = iLogonTime + createDateTime(1601,1,1,0,0,0) cfoutput#dateFormat(iLogonTime, dd, )# #timeFormat(iLogonTime,hh:mm:ss)#/cfoutput Dave Phillips -Original Message- From: Wally Randall [mailto:wally.rand...@comcast.net] Sent: Friday, July 31, 2009 3:31 PM To: cf-talk Subject: Decipher CFLDAP date values When returning date/time values from active directory the CFLDAP tag provides an integer value which must be decoded. What is the formula for converting the integer value to a human readable date? example: LASTLOGON returns 128922162522263907 ~| 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:325159 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: On line project site
Guru.com was good for me a few years ago. Some clients post projects looking for US only coders and therefore are willing to pay a normal hourly range. I picked up a client that I kept for about 2 years until she stopped doing the business. Dave -Original Message- From: C. Hatton Humphrey [mailto:chumph...@gmail.com] Sent: Monday, December 22, 2008 8:02 PM To: cf-jobs-talk Subject: Re: On line project site I got one project on Rent-a-Coder that was less than encouraging. Maybe it was my lack of experience in managing client expectations at the time or maybe it was what this particular client had dealt with (and gotten away with) in the past but I ended up terminating the project before completion. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4154 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Application.cfc question
Hi - I'm trying to use application.cfc on a new app I'm building and I'm having a strange occurrence. I'm sure it's just because I'm not as familiar with it as application.cfm, but I am trying to 'avoid' just switching back to application.cfm. Here's the issue: I have the following code. When I try to execute my URL with the reloadConfig=yes parameter, The app fails on the first line of the onSessionStart() function with 'application.datasource does not exist.' Since onSessionStart is called AFTER onApplicationStart(), clearly, the cfsets that set application.datasource occur before that line of code. Any ideas? cfcomponent output=false cfset this.name = zarts_tag_prod cfset this.SessionManagement = true cfset this.sessionTimeout = createTimeSpan(7,0,0,0) cfset this.ApplicationTimeout = createTimeSpan(30,0,0,0) cfif isDefined(url.reloadConfig) AND (isBoolean(url.reloadConfig) AND url.reloadConfig) cfset onApplicationStart() /cfif cfif isDefined(url.reloadSession) AND (isBoolean(url.reloadSession) AND url.reloadSession) cfset onSessionStart() /cfif cffunction name=OnApplicationStart access=public returntype=boolean cfset application.datasource = zarts_tag cfset application.from_email = [EMAIL PROTECTED] cfset application.developer = [EMAIL PROTECTED] cfset application.baseURL = http://tag.zarts.com; cfset application.verify_page = verify.cfm cfset application.game_name = ZARTS TAG cfset application.authentication_cookie_name = cookie.authenticated cfset application.zarts_tag_from_email = [EMAIL PROTECTED] cfreturn true/ /cffunction cffunction name=onSessionStart cfset session.security = createObject(component,com.security).init(application.datasource) cfset session.user = createObject(component,com.user).init() cfset session.isAuthorized = false /cffunction /cfcomponent ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315801 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Quick response needed...
Three questions: 1. What is the average salary 'range' for CF developers right now in the US ? I have my own idea, but I'd like to know others. I'm talking a Senior developer (10+ years in CF). Regardless of location, there should be a 'range'. 2. Is $105,000 per year feasible for a Senior CF Developer for a job in America with 5 weeks paid vacation and 10 paid holidays? 3. Anyone know any recruiters who specialize in placing ColdFusion Developers? Thanks! Dave P.S. I apologize for those who get this on cf-community also, but I need a wide response. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4128 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Quick question on session issue (hopefully)
Hey folks, I have a quick question (hopefully). Something weird is going on, and I canât place it, and Iâm feeling like I'm having a brain freezeâ¦. This shouldnât be an issue. I have a simple application in MX 7. Application.cfm has the following: cfapplication name=zarts_tag5 sessionmanagement=true sessiontimeout=#createTimeSpan(7,0,0,0)# applicationtimeout=#createTimeSpan(30,0,0,0)# setclientcookies=true I have an index.cfm with a simple login form (username and password). That form posts to a file called âlogin_exec.cfmâ. This file then authenticates the user and after authentication is successful, I have: cfset session.isAuthorized = true If I put a dump of the session scope right after this, I can see that the variable IS getting set to true. So, after this, I had a CFLOCATION to my statistics.cfm page. But on the statistics.cfm page, a dump revealed that session.isAuthorized was now false. Now, I seemed to remember a bug in MX (or 5.0, canât remember which) that you couldnât do a cflocation after a set of cookies or session variables on a page or you would lose the variables. So, thinking this was my problem, I changed the cflocation to the following: script window.location = âstatistics.cfmâ; /script However, that didnât help the problem. The changes to the session scope that are made in login_exec.cfm are NOT persisting through to the next page, even with a client side re-direct. I have 10+ years experience in CF and the fact that I havenât figured this out yet is driving me nuts. Iâm sure itâs something simple that Iâm just not seeing. I guess hitting 40 will do that to you. :/ Anyone got any ideas where my culprit is? Thanks! Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick question on session issue (hopefully)
To answer both Brad and Dan: Brad: Yes, I have dumped the session and CFID, CFTOKEN and SESSION ID are all the same in both dumps. The dump in login_exec.cfm that shows session.isAuthorized value of true, and the dump in statistics.cfm that shows session.isAuthorized false, right after the client side redirects. Dan: I verified my cookies were on. I have been using IE 7, so I fired up firefox (pun intended) and tried it there. Same result. I even looked at the cookies in Firefox and found both the CFID and the CFTOKEN cookies with the same values that matches my dump. Do you think it has anything to do with developing on http://localhost:8300/ ? I can't imagine as I've done that for years. I'm sure it's something simple I'm missing. But I'm at least glad that no one had an answer yet! (so I don't look dumb) :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick question on session issue (hopefully)
Same application name. I even tried this: Instead of redirecting, I did the following in login_exec.cfm: cfdump var=#session# cfset session.isAuthorized = true a href=statistics.cfmStatistics/a cfdump var=#session# cfabort When I got to this page, I could see my session.isAuthorized was set to false before the cfset and true after it. Then, I clicked on the statistics link, and the cfdump var=#session# on that page shows: Same application name Same CFID Same CFTOKEN Same Session ID but session.isAuthorized shows false. :( I'm going to try putting the code on another machine to see if it solves the problem or not. I'm pulling my hair out (well, if I had any hair!). Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315333 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick question on session issue (hopefully)
Well, that didn't help either. I moved it to another server and it works fine, so apparently my code is not the issue. I restarted ColdFusion and that didn't help the situation either. The bottom line is, my session variables aren't getting persisted, but only on this machine. Again, I've tried with two different browsers, and even verified with firefox that my cookies are there and have the right CFID CFTOKEN. I really need to be able to develop this app locally, so if anyone has any other suggestions, please let me know. Dave Try appending cfid and cftoken to the url before going to your statistics page. If the cfid/cftoken stays the same and your session sticks, then you'll know that something is going on with the cookies. Judah ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Job Market
Hi all, My job will be ending sometime next year due to a merger. I'm a Senior level CF Developer with 10+ years experience. I am wondering what the job market is looking like out there for us senior type CF developers with the economy the way it is here in the US. What I'm concerned about most that I see is more job descriptions asking for mid-level and junior developers, and lower salaries for those as well. I'm wondering if I might have trouble finding a job when the time comes because my salary demands would be too high and/or the employer would rather pay someone a lower salary for less experience, thinking they are getting the same efficiency. Please share whatever your thoughts are on this topic. I think this thread will be useful for anyone visiting it in the next 12-18 months, so let's really try to provide some good 'intel', if you will on the 'near future' CF market. Thanks! Dave Phillips ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4109 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
RE: CF Job Market
Michael, Long timers have their way and any other approach is met with hesitation and disdain. This is a personality issue, NOT a result of having 10+ years of experience. I know plenty of CFers who have been around for 10 years that are doing OOP in CF, including myself. Also, I 'embrace' new approaches, not meet them with 'hesitation and disdain'. It sounds to me like you've just had some bad experiences. Dave -Original Message- From: Michael MacDonald [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2008 1:37 PM To: cf-jobs-talk Subject: RE: CF Job Market Michael, You make a great point and your grasp of the reality of the current landscape is commendable. I am actually looking for Jr-Mid-Level CFMX programmers for this exact reason. Those with less time in the market typically are less procedural and more likely to have an OO state of mind. Also, our company is looking to move to .NET in the future and having someone who 1) knows CFMX from a CFC/OO standpoint will be more likely to understand the architectural challenges of the OO world 2) they are more likely to have a CS degree 3) They haven't developed a view of the way things should be. Long timers have their way and any other approach is met with hesitation and disdain. Also, greener programmers are more likely to have developed in Agile project management style organizations. If they haven't they are less likely to rebuff this approach. I want to preface all my comments with the fact that this is my view and not the entire IT fields perspective. Thanks, Michael MacDonald Sr VP, Product Development / NEOGOV [EMAIL PROTECTED] -Original Message- From: Michael Perlstein [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2008 2:15 PM To: cf-jobs-talk Subject: RE: CF Job Market I don't think it's all about salary. Most people from my experience who have been using CF for longer periods of time, 10+ years, don't use CF in a way that truly leverages the oop attributes of the language. In fact more times then not the longer someone has been using CF the higher the chances they use it in a procedural capacity. This is especially true if CF has been for the most part the only language they feel comfortable with. But even in circumstances where they know Java or ...Net when one sits down to do CF if they are veteran of the language they revert to the procedural form. Jr. to Mid level developers can often times imply that they have only been exposed to the J2EE platform versions of CF, especially if they have a comp sci degree where they are taught Java and C++. They program oop if for no other reason then they don't know how to do it any other way. So not only do you get the cheaper salary but you get someone with all the benefits of a true oop background.. Regards, Michael Perlstein VP Program Management Rockville, MD 301.468.9246 x154 301.468.9670 (f) 703-869-6086 (m) www.AboutWeb.com -Original Message- From:Dave Phillips [EMAIL PROTECTED] To: cf-jobs-talk ; Sent: Nov 6, 2008 02:03:59 PM Subject: CF Job Market Hi all, My job will be ending sometime next year due to a merger. I'm a Senior level CF Developer with 10+ years experience. I am wondering what the job market is looking like out there for us senior type CF developers with the economy the way it is here in the US. What I'm concerned about most that I see is more job descriptions asking for mid-level and junior developers, and lower salaries for those as well. I'm wondering if I might have trouble finding a job when the time comes because my salary demands would be too high and/or the employer would rather pay someone a lower salary for less experience, thinking they are getting the same efficiency. Please share whatever your thoughts are on this topic. I think this thread will be useful for anyone visiting it in the next 12-18 months, so let's really try to provide some good 'intel', if you will on the 'near future' CF market. Thanks! Dave Phillips ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4116 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
RE: lists question
Michael, I like the form idea very much for cf-jobs. To be honest, I'm guessing most 'new' posters are posting with the form anyway (can you tell that?) The main reason I like it is that it can be structured so that we can always identify the pieces of information we need to know up front and those who are posting for the first time won't be so unsure about their post because the form itself will inform them on what they need to provide. I can't tell you how many posts I've seen over the years where the poster didn't even include the location of the job in the post. Too funny, really. :) Thanks for looking at this! Dave -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2008 3:32 PM To: cf-jobs-talk Subject: Re: lists question CF-Jobs is written so that any reply is automatically sent to the original posters email address, not to the cf-jobs list. In order to reply to the cf-jobs list someone would have to write the cf-jobs email address in specifically or have a bad email client. I'm setting the cf-jobs list to reject any 'reply-to' message which will stop replies but the off topic stuff would still be a problem. The answer to that is something I've been planning for a while which is to use a singe, standard job posting form to post to the list rather than free-flow emails. In other words, you would have to post from the site only for cf-jobs. On Wed, Nov 5, 2008 at 3:29 PM, Larry C. Lyons [EMAIL PROTECTED]wrote: No. I do not want to see the CF-jobs talk littered with chatter and garbage. its bad enough that people automatically respond to the list without checking for the sender's email address. Combining the two lists will really reduce the signal to noise ratio. On Wed, Nov 5, 2008 at 12:32 PM, Steve Runyon [EMAIL PROTECTED] wrote: Given how infrequently the lists are used correctly, would it make sense to combine CF-Jobs and CF-Jobs-Talk? I agree that the concept of splitting the two is a good one in theory, but maybe it doesn't make real-world sense. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4102 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
RE: ColdFusion Trend Information?
This is more appropriate for cf-jobs-talk, so we should move it there. FYI - this is only for odesk.com trends, not ColdFusion in general. Dave -Original Message- From: Daryl James [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2008 3:47 PM To: cf-jobs Subject: ColdFusion Trend Information? Does anyone know of any additional a href=http://www.odesk.com/trends/ColdFusion;Cold Fusion Developer Trends/a information? I'm doing some personal research and need more information. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4086 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Adobe Certified ColdFusion Developer Directory
Hi all, Macromedia had a page on their site that allowed someone to verify that a person was a Certified ColdFusion MX 7 Developer or Advanced Certified ColdFusion MX 7 Developer. Does anyone know where this page can be found? I have not been able to located it on Adobe's website. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314767 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion Developer needed in Suffolk County Long Island
This seems like it should be a private conversation and is not meant to be distributed to the entire listam I right? -Original Message- From: Dan Lodato Jr. [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2008 9:41 AM To: cf-jobs-talk Subject: RE: Coldfusion Developer needed in Suffolk County Long Island No my company does not pay for relocation unfortunately, this position would allow a telecommute to perform this job! Thanks, Daniel Lodato IT Recruiter Lloyd IT 445 Broadhollow Road, Melville, NY 11747 631-777-7600 x702 Email: [EMAIL PROTECTED] http://www.linkedin.com/pub/7/148/247 -Original Message- From: Parikh, Raj [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2008 10:34 AM To: cf-jobs-talk Subject: RE: Coldfusion Developer needed in Suffolk County Long Island HI Dan, I may have a candidate for you who is willing to relocate any where in US. Does you company pay for relocation? I will email my candidate your information. Thanks Raj Raj Parikh Sr Technical Recruiter CDI Business Solutions Phone: 248 786 5917 Fax: 248 786 5717 Toll Free: 1-800-555-4234 www.cdicorp.com -Original Message- From: Dan Lodato Jr. [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2008 10:12 AM To: cf-jobs-talk Subject: RE: Coldfusion Developer needed in Suffolk County Long Island Raj, I will send Chicago Coldfusion developers I come across as well. I will pay 350$ referral fee to anyone I receive that is placed which is my companies policy. Raj is there anyway to view resumes on this website I was having trouble figuring that out navigating the site? There are literally no COldfusion Developers on LI and this search has been very challenging. Thanks, Daniel Lodato IT Recruiter Lloyd IT 445 Broadhollow Road, Melville, NY 11747 631-777-7600 x702 Email: [EMAIL PROTECTED] http://www.linkedin.com/pub/7/148/247 -Original Message- From: Parikh, Raj [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2008 10:09 AM To: cf-jobs-talk Subject: RE: Coldfusion Developer needed in Suffolk County Long Island Hi Dan, I am also looking for a couple of Cold Fusion Developer but in Detroit, MI. If I come across anyone that is not interested in this location, I will forward it to you. Thanks Raj Parikh Sr Technical Recruiter CDI Business Solutions Phone: 248 786 5917 Fax: 248 786 5717 Toll Free: 1-800-555-4234 www.cdicorp.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4048 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
cfschedule action=run .... asynchronous or not?
Hi all, I'm on CF8 - linux OS. Trying to find out why my cfschedule action=run task=whatever tag is not running asynchronously. I was under the impression that it should execute the task and then continue on, not making the user wait. Am I wrong about this? Thanks! Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313420 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What Cold Fusion Job boards are there?
I am a full-time permanent employee of a Fortune 500 company and am a full-time telecommuter. I live in Arlington, Texas and my boss and *most* of my team members are in Wilkes-Barre, Pennsylvania. It works out really well. I have full benefits as I am a regular employee. I have also managed employees remotely, and while I will admit that there are some challenges to managing remote employees, from a development perspective, you can collaborate and work together just as well remotely as you can in person, and in some cases, are even more productive. The issue that I think most managers have with hiring remote employees is TRUST. They don't trust the employee to be in front of their keyboard 8 hours a day, 5 days a week. What they fail to realize, is that most employees in an office aren't in front of their keyboard 8 hours a day either. There's chatting with their co-workers, going to coffee or smoke breaks, long lunches because you have to drive 15 minutes to a restaurant, etc. Also, you are more likely to be interrupted when someone (especially the end-user) can walk by your desk than if they must pick up the phone or IM you. In fact, if you're busy, and someone IM's you, just ignore it and answer later. If you're busy and someone phones you, ignore it and answer later. But if you're busy and someone walks by your desk, what are you going to do, say, sorry, I can't talk right now, can you please leave? No, you're going to stop what your doing, and interruptions can cost 2-5 times more than the actual time of the interruption (for example, interrupt a programmer for 10 minutes, and it could actually be a loss of 20-30 minutes because of the time it takes to get ramped back up and 'in the zone', depending on what they were doing at the time of interruption. All that is said to say this: When I become a manager again, I won't have any problem hiring remote employees. If they don't produce, then I will let them go and get someone who will. The bottom line is that most remote employees (if they have experience being remote) knows that and they will produce oftentimes, even better than someone 'in the office'. Results are what matters, not how much time is spent tapping on their keyboard. Are they meeting deadlines? Are they producing quality code? Then who cares where they are located! Dave Phillips -Original Message- From: Vicky [mailto:[EMAIL PROTECTED] Sent: Saturday, September 13, 2008 11:40 AM To: CF-Jobs-Talk Subject: Re: What Cold Fusion Job boards are there? That's your prerogative. I just don't want people misled that hiring telecommuters necessarily means not having to provide benefits. While many telecommuters are contracted, many are not. On Sat, Sep 13, 2008 at 12:33 PM, Don Bellamy [EMAIL PROTECTED] wrote: I've been in business for myself for 14+ years. Have always paid for my own health insurance, it can be had for pretty cheap, got full coverage with a $5k annual deductible for $280 per month for a family of 6. Adjust your hourly rates accordingly if that seems high. I for one don't want anyone else in charge of my health care or anything else important to me such as my 401k plan. Don -Original Message- From: Vicky [mailto:[EMAIL PROTECTED] Sent: Saturday, September 13, 2008 11:07 AM To: CF-Jobs-Talk Subject: Re: What Cold Fusion Job boards are there? Agreed on just about everything but the health insurance. Full-time telecommuters still often require full benefits with regard to health insurance, 401k, etc. True, you still save money on the overhead. I happen to be on my husband's insurance, but many are still the sole providers. On Sat, Sep 13, 2008 at 10:33 AM, Phillip M. Vector [EMAIL PROTECTED] wrote: I know I've got a major bias here, but I'll say it anyway. carl starm wrote: Our preference is for someone to work at our location in NYC. Carl, there are several good people out there that you are bypassing because you are wanting someone in NYC. Did you consider the following? 1) A remote location person can be as connected with your team (perhaps more so) then someone on site via IM, email, video conferencing, etc. 2) By not asking them to take transportation every day to work, you are helping the planet (Ok, perhaps you aren't interested in being green, but perhaps you are). 3) This one is usually the one that grabs peoples attention. Hiring a telecommuting person not only means that you have more people to select from, but it may be CHEAPER... Consider the cost of living in NYC. It's pretty high. Now compare that to the cost of living in (let's say) Montana. I would presume that it's much less. It would probably cost less to hire a programmer there. Not only that, but you don't need to provide space in the office, a computer, worry about lunch breaks, health insurance, etc. Seriously. Unless you have something you
Re: (ot) How do you preload a SWF file?
Hey, i know I'm a week late in responding (I was on vacation, forgive me!), but I do have one more question about this: Are there any concerns around the additional load on the web server from having to load the swf file for every user, even those that may never actually launch the application? On the main page just have an object/embed call with the SWF loaded in at 1 pixels by one pixel. Hey folks - this is OT but I know someone on this list will know the answer: I need to 'pre-load' a SWF file prior to it ever being launched with a click. I have done some googling and it appears it can be done, but I'm just wondering if someone here has done it below. Here is the scenario: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312229 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Wildcard characters in filepath?
Have you tried: /2008_0830_??/ ? That's how you would do it at the command line in windows anyway. Dave -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Saturday, August 30, 2008 10:56 AM To: CF-Talk Subject: Wildcard characters in filepath? How can I use wildcard characters in a file path? Is it possible? I have a data vendor that makes data available for download using file paths that use as part of the path, .../2008_0830_103028/ In other words the paths are auto-generated and include the year, date, hour/minute/second, in the file path. I want to just specify the year and date in the path and use .../2008_0830_xx/... so I can automate the data processing. I could use contains, I guess, but I'd rather specify the path using variable characters. How can I do this? Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311837 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) How do you preload a SWF file?
Hey folks - this is OT but I know someone on this list will know the answer: I need to 'pre-load' a SWF file prior to it ever being launched with a click. I have done some googling and it appears it can be done, but I'm just wondering if someone here has done it below. Here is the scenario: We have a Flex app with a fairly good size footprint. When a user hits the main page of our website, they get our HTML page with graphics, etc. There are multiple ways for them to click to launch the Flex App. When they click one of the links/graphics to launch the app, they then have to wait for the app to load completely before they can navigate it. What we want to be able to do is for those users who come to our main page and start reading information there, we want the app to be loading in the background without them being aware of it. If they read long enough for the app to load, then, when they click one of the links/graphics to launch the app, it will come up very quickly because it's already in the browser cache. 1) Can you confirm this is possible and 2) Do you have any sample code or a reference that I can use to go by? Thanks! Dave Phillips ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311787 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Here's an interesting little problem...
Rick, What database are you using? One thought that comes to mind is to do TWO selects with a UNION and give each their own ORDER BY clause. Something like this: Select . where class NOT in ('A','AA','AAA') ORDER BY class DESC UNION ALL Select . where class in ('A','AA','AAA') ORDER BY class ASC You might need some parenthesis around the queries to make it work, not sure which DB you're using. At least that might get you on the right track. I don't think a CASE statement would work in this 'case' (no pun intended), but I've never tried one in an ORDER BY. Might be worth a shot. Dave -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 11:31 AM To: CF-Talk Subject: Here's an interesting little problem... I need to order query results by class desc. Classes are typically AA, A, B, C, D, etc. Order by class desc puts the AA, A in the correct order, but when all are ordered, I get: D C B AA A The only double letters involved in classes are AA, and AAA. I need a conditional order by statement... Order by class desc where class is AA or AAA, otherwise order by class asc Suggestions? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311593 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Here's an interesting little problem...
Because the column name will be represented by whatever the FIRST select is, and in this case, that is 'top_shooter_class'. Try this: cfquery name=get_results datasource=#application.dsn# select t.name, t.date, t.time, s.firstname, s.lastname, s.state, s.nsca, r.con, r.class, r.shot, r.broke from tournaments t, shooters s, registrations r where r.shooter_id = s.shooter_id andr.class in ('A', 'AA', 'AAA') andr.tournament_id = t.tournament_id andt.tournament_id = cfqueryparam cfsqltype=integer value=#url.tournament_id# order by class, broke desc union all select t.name, t.date, t.time, s.firstname, s.lastname, s.state, s.nsca, r.con, r.class, r.shot, r.broke from tournaments t, shooters s, registrations r where r.shooter_id = s.shooter_id andr.class not in ('A', 'AA', 'AAA') andr.tournament_id = t.tournament_id andt.tournament_id = cfqueryparam cfsqltype=integer value=#url.tournament_id# order by class desc, broke desc /cfquery If that doesn't work, try some parentheses around each of the selects. If that still doesn't work, last resort you can do this: cfquery name=get_results1 datasource=#application.dsn# select t.name, t.date, t.time, s.firstname, s.lastname, s.state, s.nsca, r.con, r.class, r.shot, r.broke from tournaments t, shooters s, registrations r where r.shooter_id = s.shooter_id andr.class in ('A', 'AA', 'AAA') andr.tournament_id = t.tournament_id andt.tournament_id = cfqueryparam cfsqltype=integer value=#url.tournament_id# order by class, broke desc /cfquery cfquery name=get_results2 datasource=#application.dsn# select t.name, t.date, t.time, s.firstname, s.lastname, s.state, s.nsca, r.con, r.class, r.shot, r.broke from tournaments t, shooters s, registrations r where r.shooter_id = s.shooter_id andr.class not in ('A', 'AA', 'AAA') andr.tournament_id = t.tournament_id andt.tournament_id = cfqueryparam cfsqltype=integer value=#url.tournament_id# order by class desc, broke desc /cfquery cfquery dbtype=query name=get_results Select * from get_results1 Union all Select * from get_results2 /cfquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311614 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query of queries or something else
How about something like this: cfquery name=qryGetOtherProperties datasource=#appDSN# SELECT f.AssetID, f.name, i.text, i.amount FROM FixedAssets f INNER JOIN InvoicesWork i ON i.AssetID = f.AssetID WHERE f.JobID = #qryGetInvoice.JobID# AND f.AssetID IN (select AssetID FROM InvoiceWork WHERE condition to get assets from InvoiceWork that you want ) AND f.AssetID NOT IN (select AssetID FROM InvoiceWork WHERE condition to get assets from InvoiceWork that you DO NOT want ) /cfquery I'm guessing on a few things here, but if you list out your table and columns that we're talking about here and confirm the conditions, I'm sure you could get this all in one query instead of using QofQ (unless of course you're talking about different datasources, which it doesn't look like you are). Dave Phillips http://www.dave-phillips.com/ -Original Message- From: Andrew Whone [mailto:[EMAIL PROTECTED] Sent: Saturday, August 23, 2008 3:47 PM To: CF-Talk Subject: query of queries or something else If a qry a couple of tables: !---get Job Property details --- CFQUERY Name=qryGetJobProperties datasource=#appDSN# SELECT AssetID, Name FROM FixedAssets WHERE FixedAssets.JobID=#qryGetInvoice.JobID# /CFQUERY cfset PropertyFieldID = ValueList(qryGetJobProperties.AssetID) !---get invoice Property details --- CFQUERY Name=qryGetInvoiceProperties datasource=#appDSN# SELECT AssetID, Text, Amount FROM InvoicesWork WHERE InvoiceID=#qryGetInvoice.InvoiceID# /CFQUERY I now need a query that will extract any Asset from the Table FixedAssets that is included in qryGetJobProperties but not in qryGetInvoiceProperties so that I can display it in a dynamic form. Something like this; CFQUERY Name=qryGetOtherProperties dbtype=query SELECT qryGetJobProperties.AssetID, qryGetJobProperties.Name, qryGetInvoiceProperties.AssetID FROM qryGetJobProperties, qryGetInvoiceProperties WHERE qryGetInvoiceProperties.AssetID != qryGetJobProperties.AssetID /CFQUERY I have also tried Nested Loops and Unions but am really struggling, everything I try doesn't seem to make sense. I could mess about with an array but is there really any need? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311469 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cflayout weird problem
To my knowledge, this is a browser issue, not a cflayout issue, as you will get different results in different browsers. You can avoid this completely by using javascript to validate your fields. Dave -Original Message- From: BJ McShane [mailto:[EMAIL PROTECTED] Sent: Friday, August 22, 2008 3:24 PM To: CF-Talk Subject: cflayout weird problem I'm using the cflayout for tabs on my form. When the form submits, I check a couple of the fields for error checking and if the fields are wrong or not filled in I send the user back using the history.back() function. The forms returns but all the input the user put in is gone. If I take off the cflayout and just have a regular form the input data stays if there is an error. Does any one know of a work around or something I can do. thanks, bj ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311436 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cflayout weird problem
BJ, Post your form code (or a snippet) and what fields you're trying to validate and what you want validated and we can help. Also, check out the CF docs for CFFORM as it has a lot of built-in javascript validation that you can utilize through CF tags like CFINPUT and so on. Dave -Original Message- From: BJ McShane [mailto:[EMAIL PROTECTED] Sent: Friday, August 22, 2008 3:59 PM To: CF-Talk Subject: Re: cflayout weird problem Dave, thanks for the reply. I did run it in firefox and the data doesn't get wiped out in that browser. So you are right it looks like it is a browser issue. I've never validated with just javascript, I'll have to look around for examples. thanks bj ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311441 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cflayout weird problem
BJ, Okay, not familiar with cf_betterselect, but the below should still work for you: Change your cfform tag to this: cfform action=NewEmployeeEntry.cfm name=newEmpInsertForm method=POST onsubmit=return doSubmit(); IN your head area, add the following: script function doSubmit() { var oForm = document.newEmpInsertForm; if(oForm.p_supervisor.selectedIndex == 0) { alert('must select a supervisor'); return false; } if(oForm.p_location.selectedIndex == 0) { alert('must select a location'); return false; } return true; } /script Change your cfselect to: select name=p_Location class=boxes required=yes message=select location option/option cfoutput query=EmpLocationsList option value=#emp_locat##emp_locat#/option /cfoutput /select Modify the alerts to say whatever you want to say when wrong information is entered. Dave -Original Message- From: BJ McShane [mailto:[EMAIL PROTECTED] Sent: Friday, August 22, 2008 4:54 PM To: CF-Talk Subject: Re: cflayout weird problem Dave, I am using cfform and some of the validation on tags with it. The two places I don't is a custom tag I'm using cf_betterselect and the regular select. the betterselect allows the user to type and narrow down the list. the select tag I want the user to select a location and not have it default to one so I put in an empty option tag. With this the validation will not work when I set the cfselect tag to required. Here's my code: cfform action=NewEmployeeEntry.cfm name=newEmpInsertForm method=POST cflayout type=tab style=width:900; cflayoutarea title=Employee Info style=background-color:##CC table id=formTable tr td colspan=4 align=right input type=submit name=insertHRpartButton value=Update /td /tr trtd colspan=4hr width=80% align=center/td/tr tr thName:/th td cfinput type=text name=p_employeeName class=boxes size=50 maxlength=70 required=yes message=Please enter the new employee's name onChange=spacesCk(this); /td thEmployee No.:/th td cfinput type=text name=p_employeeNo class=boxes size=4 maxlength=4 required=yes message=Please enter the employee's number validate=integer onChange=spacesCk(this); /td /tr tr thTitle:/th td colspan=3 cfinput type=text name=p_employeeTitle class=boxes size=80 maxlength=100 required=yes message=Please enter the new employee's title onChange=spacesCk(this); /td /tr tr thRCN:/th td cfinvoke component=/hr/hr_CFCs/HR_employee method=HREmployeeRCNInfo returnvariable=rcnlist select name=p_employeeRCN class=boxes option value=/option cfoutput query=rcnlist option value=#emp_rcn##emp_rcn# - #mid(emp_rcn_name,9,35)#/option /cfoutput /select /td thTime Reporting Group:/th td cfinput type=text name=p_employeeRptRCN class=boxes size=6 maxlength=6 required=no message=Please enter the new employee's Time Reporting Group onChange=spacesCk(this); /td /tr tr thSupervisor:/th td cf_betterselect name=p_supervisor formname=newEmpInsertForm class=boxes option/option cfoutput query=EmpInfoQuery option value=#emp_no#,#emp_last_name#,#emp_nick_name##emp_last_name#, #emp_nick_name#/option /cfoutput /cf_betterselect /td thStart Date:/th
RE: Query Too Complex for Access?
Have you tried: AND Works.ThisInventory not in (#listQualify(valueList(getActiveWorks.ThisReference),')#) ?? Dave -Original Message- From: David Moore [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2008 1:18 PM To: CF-Talk Subject: Query Too Complex for Access? I know I am setting myself up for another Query too complex issue, so before I start I thought I would ask for suggestions. I run into this when I have to reference two different Access databases that are Client imposed (don't ask). Basically, I have to use one for active data and one to show available date (minus the active data). This is, of coures, where the problem comes in. The queries will help: cfquery name=getActiveWorks datasource=#DSN# SELECT * FROM Works WHERE Works.PageReference = #FORM.ThisPage# AND Works.TypeReference = '#FORM.ThisType#' /cfquery cfquery name=getWorks datasource=#DSN2# SELECT * FROM Works, Artists WHERE Artists.ArtistNumber = Works.ArtistNumber AND Works.Type = '#FORM.ThisType#' cfloop query=getActiveWorks AND Works.ThisInventory '#getActiveWorks.ThisReference#' /cfloop/cfif ORDER BY Works.Title Asc /cfquery Where the cfloop is is where the problem is going to come into play when the Active Works get to a certain level and the Query becomes Too Complex. What is the Best way to handle this? I am using CF8, Windows Server 2003, and MS Access w/Unicode ODBC Connector. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311309 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Query Too Complex for Access?
Acutally, the first part is correct. The listQualify() function actually just places 'single quotes' around each of the values in your valuelist since that would be required by the DB. List qualify doesn't check any variables. I noticed you had a stray /cfif tag. Were you missing a cfif condition as you only wanted to compare against 'some' of the records in getActiveWorks? If so, send your CFIF statement as we'll have to modify what I sent you earlier. Dave -Original Message- From: David Moore, Jr. [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2008 1:37 PM To: CF-Talk Subject: RE: Query Too Complex for Access? No I haven't. What you are saying is that I should use valueList to build a full list from all values in the getActiveWorks query and then listQualify to see if any variable matches. Thanks David! I will give it a shot. Does anyone else know of any other ways? David G. Moore, Jr. UpstateWeb. LLC Subject: RE: Query Too Complex for Access? From: [EMAIL PROTECTED] To: cf-talk@houseoffusion.com Date: Wed, 20 Aug 2008 13:27:34 -0500 Have you tried: AND Works.ThisInventory not in (#listQualify(valueList(getActiveWorks.ThisReference),')#) ?? Dave -Original Message- From: David Moore [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2008 1:18 PM To: CF-Talk Subject: Query Too Complex for Access? I know I am setting myself up for another Query too complex issue, so before I start I thought I would ask for suggestions. I run into this when I have to reference two different Access databases that are Client imposed (don't ask). Basically, I have to use one for active data and one to show available date (minus the active data). This is, of coures, where the problem comes in. The queries will help: cfquery name=getActiveWorks datasource=#DSN# SELECT * FROM Works WHERE Works.PageReference = #FORM.ThisPage# AND Works.TypeReference = '#FORM.ThisType#' /cfquery cfquery name=getWorks datasource=#DSN2# SELECT * FROM Works, Artists WHERE Artists.ArtistNumber = Works.ArtistNumber AND Works.Type = '#FORM.ThisType#' cfloop query=getActiveWorks AND Works.ThisInventory '#getActiveWorks.ThisReference#' /cfloop/cfif ORDER BY Works.Title Asc /cfquery Where the cfloop is is where the problem is going to come into play when the Active Works get to a certain level and the Query becomes Too Complex. What is the Best way to handle this? I am using CF8, Windows Server 2003, and MS Access w/Unicode ODBC Connector. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311312 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Query Too Complex for Access?
David, I don't know if it will or not, you will just need to test. I'm sure there is some upper limit as to how many bytes you can send in a call to the DB, but I'm also betting that's driver dependent. Oh, if there is a possibility that getActiveWorks might be empty, you will want this: cfif getActiveWorks.recordCount AND Works.Inventory NOT IN (#listQualify(valueList(getActiveWorks.ThisReference),')#) /cfif If you don't have that condition around it, you could end up with this SQL, which would bomb: AND Works.Inventory NOT IN () If your app is going to exceed some limit, you may need to break your query down somehow. Hopefuly that won't be an issue though. Hope this helps! Dave -Original Message- From: David Moore, Jr. [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2008 3:48 PM To: CF-Talk Subject: RE: Query Too Complex for Access? I noticed that after I hit the 'send' button. I had a cfif to check if there were actual records before running the statement. I didn't think I needed to show all that, so I took it out, but left the stray end code. The code works well. I haven't tested it at a lot of values though. This will not have the same issue once their are like 100 records in the getActiveWorks query. Right? ~David G. Moore, Jr. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Web Service Issue , pls help
Vishnu, Do you already have any current code that you are using? Your request is not completely clear, but based on what I am 'assuming', you want to know how you can invoke the java web service and retrieve the attachment from the soap response. I *think* you could do this with CFHTTP. CFHTTP can retrieve binary data by specifying getAsBinary=yes in the CFHTTP call. So your call might look something like this: cfhttp url={url to web service here} getAsBinary=yes path={path to folder where you want to store binary file here} filename={filename you want for image} ...any other attributes you need your cfhttpparam tags, if needed /cfhttp After you do that, you should then be able to retrieve the file a number of ways: 1. if you just want to display the file, and it is in your web root: img src={path and filename of the image you retrieved} 2. If you want to display the file, and it is not in your web root: cfcontent ... (can't remember the parameters right now, but you can check the docs) 3. If you want to move the file somewhere, then use: cffile action=move source={path and filename of image you retrieved} destination={new destination} If this is not what you are looking for, please describe in more detail exactly what you are trying to do with the data returned from the web service and post any code you may already be using. Sincerely, Dave Phillips -Original Message- From: vishnu prasad [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 9:01 PM To: CF-Talk Subject: Re: Web Service Issue , pls help how to get the attachment from soap response and use it in coldfusion Could you please provide with a code snippet? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311243 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) SQL question...
Che, Try this: SELECT count(total) as sourcetotal, source FROM ( select count(*) as total, source from listings group by source union all select count(*) as total, source from speclistings group by source union all select count(*) as total, source from psportlistings group by source ) GROUP BY source ORDER BY source DESC Sincerely, Dave Phillips http://www.dave-phillips.com -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2008 9:11 AM To: CF-Talk Subject: (ot) SQL question... Hello all. I'm looking to output the total number of entries, grouped by source from 3 tables. I'd like to modify the sql below so that each source shows up only once, yet tablulates the totals from all of the tables. Any ideas. Thanks, Che. --- select count(*) as total, source from listings group by source union all select count(*) as total, source from speclistings group by source union all select count(*) as total, source from psportlistings group by source order by total desc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating a database with repeated information
Melissa, This is exactly what ColdFusion is designed to do. You will have ten separate .cfm files and each of the files represents one of your 10 pages. Whatever information is 'static' for each page (in other words, whatever information stays the same for every state) can be hardcoded into the .cfm file. Anything that is dynamic (can be different for each state) should be referenced in the database. There are a number of ways to accomplish this (as just about anything in ColdFusion can be done different ways) so you might get different ideas on here from other people, but you can simply pass a 'url' parameter called 'state_id' or something like that that references a unique column in your database and that represents the state. Then you will have a cfquery tag at the top of each of your .cfm pages that pulls the necessary 'dynamic' information from your database for each state. Finally, when you want to display dynamic information from the query, surround your output with a cfoutput tag and your queryname and column names with # signs like this: Welcome to cfoutput#qMyQuery.state_name/cfoutput Something like that. I recommend starting simple, with just creating your first page that displays the dynamic 'welcome to' message and then you can build it up from there. Dave -Original Message- From: Melissa Cope [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 8:25 AM To: CF-Talk Subject: Creating a database with repeated information Let's say you're making a MySQL database-driven website for states and each state will originally be set up with the same ten pages worth of information. (All states will have a home page saying Welcome to our state, all will have a contact page saying Contact our state, etc.) Obviously each state will want to personalize their pages through a self-administration interface (being able to change their home page to Welcome to Rhode Island and adding information about historic sites, for example) so each state will have to have its own entries in the database for each page. Which means you're looking at 500 entries to set up. Is there a way to create the original ten entries, then somehow loop through the next 49? I certainly hope so. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311175 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating a database with repeated information
Melissa, I think I have a little better understanding of what you want now. You are talking about the initial 'records' in your database (before the user can modify them) right? So, what you could do is set up a few lines of code (maybe put in a cfinclude even) that will query to see if that 'state' record exists and, if not, then it will create the state record. So something like this: cfquery tag to get your state information for whatever url.state was passed in Now have the following: cfif NOT qQueryname.recordCount in here, you put your cfquery to insert the state with your 'default information' (which you might also pull from the db with another SELECT ... after you insert, before leaving this cfif do the same cfquery you did initially to get the state information for url.state. /cfif now your code to display continues. This way, your state record gets created 'on demand' the first time someone visits a page for that state, and it's built dynamically. Is this closer to what you were looking for? If you just want to set up all records initially, and you will only do it once, you don't need a CF page for that. Just write your SQL and run it in the mySQL query browser or administrator to get all the records inserted initially. If it's a one time thing, I don't usually write a CF page for that, especially since it is only 50 queries you're talking about. Dave -Original Message- From: Melissa Cope [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 10:05 AM To: CF-Talk Subject: Re: Creating a database with repeated information Thanks for the welcoming answers. :) I am relatively new to ColdFusion, but I may have misstated my question; it's not the pulling information from the database I'm not sure how to do, it's the setting the database up (efficiently) in the first place. I figure each record will need five fields: the ubiquitous auto-incremented ID, the page title, the page content, then the state and the page name (to call in from the URL, like index.cfm?page=aboutstate=VA). Since all the states will have the same set of ten pages to start, it seems that one should be able to use a cfloop of insert statements. Where I get jammed up is figuring out how to tell it what state to insert in the state field. Would it need to be a long cfswitch saying if i=1 the state is AL, if i=2 the state is AK, etc.? Thanks again! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311194 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Accessing Session and Application variables from another app
Couldn't you create a CFC in your main app that will return a value of a variable, something like this: cffunction name=getVar cfargument name=scope cfargument name=varname cfreturn #arguments.scope#.#arguments.varname# / /cffunction Expose the CFC to public and use CFINVOKE from your 'child' app. You could also access it with cfhttp if you would rather do that. Similar to your solution below, but more secure as it doesn't just dump all the variables - you have to know the name of it to get the value. You might want to add some error checking in case the varname or scope passed doesn't exist. In your 'child' app, you could set up a process that grabs those values and populates your application and session scope in the child app automatically on each request. Not pretty, but it should work. Dave -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 4:14 PM To: CF-Talk Subject: Accessing Session and Application variables from another app For reasons I won't go into, we have one directory in our main application which has it's own application scope. Is there any way for this sub-application to access session and application variables from the main app? Things that I've thought of: - A simple CF page which outputs the variables needed to the page. Then this page can be hit via HTTP request. Things I've tried - A CFC in the root which returns the variables requested I can't include, or reference the root app, so that option is out. Any other things that I can try? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311227 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Accessing Session and Application variables from another app
Sorry Andy, I didn't read your whole message. It appears you already tried this. -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 4:21 PM To: CF-Talk Subject: RE: Accessing Session and Application variables from another app Couldn't you create a CFC in your main app that will return a value of a variable, something like this: cffunction name=getVar cfargument name=scope cfargument name=varname cfreturn #arguments.scope#.#arguments.varname# / /cffunction Expose the CFC to public and use CFINVOKE from your 'child' app. You could also access it with cfhttp if you would rather do that. Similar to your solution below, but more secure as it doesn't just dump all the variables - you have to know the name of it to get the value. You might want to add some error checking in case the varname or scope passed doesn't exist. In your 'child' app, you could set up a process that grabs those values and populates your application and session scope in the child app automatically on each request. Not pretty, but it should work. Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311230 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Announcement: CF8 Exam Buster released for ColdFusion 8 certification
Read what people are saying about the Exam Buster product on our testimonials page (some early CF8 comments are already on there): Just wanted to throw in my two cents that Exam Buster helped me prepare for my MX 7 developer exam, and I aced it with a 97% and earned the Advanced MX 7 Developer certification. It's a great program! Thanks Brian Sincerely, Dave Phillips My new blog: http://www.dave-phillips.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311121 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfform validation for newbie
Christine, I believe you will need to do some custom javascript validation for this (someone who has used cfform a lot can surely suggest otherwise). Here's how you could do it: Add the following to cfform tag 'onsubmit=return doSubmit(); Then, inside your head tags, add the following: script vunction doSubmit() { var oForm = document.formname; if(oForm.discode.value != 'xyz123' oForm.discode.value != 'abc1234') { alert('put your error message here'); return false; } // if we are here, then one of the values were entered. if(oForm.discode.value == 'xyz123') { oForm.paytype[0].checked = true; } else { oForm.paytype[1].checked = true; } return true; } /script This is as assuming that your first radio button is NAxyz123 and your second radio button is NAabc1234. You can adjust accordingly, but this should get you on the right track. DISCLAIMER: I have not tested the above code - so it may not be bug free. :) Dave -Original Message- From: Christine Stephens [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2008 9:23 AM To: CF-Talk Subject: cfform validation for newbie HI I need assistance with cfform validation, please. I have a text field 'discode' that is not required however if it is filled out it can only have 2 possible answers in it: 'xyz123' or 'abc1234'. And then if the 'discode' field is filled out correctly with 1 of those 2 values then another radion button field 'paytype' needs to be set to 'NA#discode#'. can anyone help me? thank you. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310968 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: javascript question
BJ, Yes, there is a way you can do that. I'm not sure of the exact syntax, but hopefully you can google this and get a solution: You need to use the onkeypress event, something like this: input type=text name=whatever onkeypress=changePeriod(); Your changePeriod() function should look at the window.event.keyCode (which is the ascii value of the key pressed) and it matches the ascii value of a period (46), change it to a tab (9). Something like this might work: function changePeriod() { if(window.event.keyCode == 46) { window.event.keyCode = 9; } } Try that and see if it works. I know it will work in IE, but not sure about other browsers. Hope this helps! Sincerely, Dave Phillips http://www.dave-phillips.com -Original Message- From: BJ McShane [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2008 10:25 AM To: CF-Talk Subject: javascript question I built a form for my users where they enter IP addresses. They are use to putting in the .(period) in between the numbers but I built the form so all they would have to do is type in the number. Is there a way I can change the keystroke of a . (period) to a tab. So when they are typing they could type in the . but it would tab over to the next field? thanks for any help, bj ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310983 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Outputting columned UL tags
Why does this matter and why are we wasting bandwidth and time on this discussion? I'm sure that most people would agree that there are just some things in web development that are left up to the developer to choose and that there are almost always more than one way to do something? Why even make a big deal about it? Since I'm on my soap box, my other beef is people on this list who don't answer questions, but instead, ask why are you doing it that way?. It's happened more than once today already and I feel bad for those asking the questions, because they are looking at a solution. In some cases, it's good to offer alternative ways of doing things but, at least offer a possible answer to the question and THEN suggest another way of doing it. Responding with why aren't you doing it this way instead? and not evening offering an answer to the question can be very disappointing to a developer who has already banged their head against the wall for several minutes, hours or days before making themselves vulnerable by asking a question in an open forum like this. They sure don't need sarcastic remarks and/or time wasting remarks. Okay, I'm off my soap box now. :) Dave Phillips -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2008 12:55 PM To: CF-Talk Subject: Re: Outputting columned UL tags then HTML tables are best used for database type information. No doubt about that. But the question here is should I use a table to output a list if I want it to look like a table, my answer is definitely YES. The only purpose on HTML is to define the layout of a page. If your layout requires something, coming from a database or not, to be a table, the the TABLE tag is the choice. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311008 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 validation for newbie
Sorry, I thought the field was required. Try this: if(oForm.discode.value.length 0 !(oForm.discount.value == 'xyz123' || oForm.discount.value == 'abc1234')) { This says if they enter a value, and that value is NOT 'xyz123' or 'abc1234', then display the error. If they don't enter a value, it will never evaluate the comparison condition. See how that works. If it doesn't work, post your code as you have it so we can look at it all. Dave -Original Message- From: Christine Stephens [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2008 3:01 PM To: CF-Talk Subject: Re: cfform validation for newbie Hi Dave the line - if(oForm.discode.value != 'xyz123' oForm.discode.value != 'abc1234') { is giving an error - saying Expected ';' also i wanted to claify - i might not have been so clear in my request... the user could enter 1 of 2 possible entries into the non-required field... 'xyz123' OR 'abc1234' i only add that in because it looked like in the coding below - that it would only accept the answer of 'xyz123' - do you know how you could have it check for both? Thank you!! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311019 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
The next level...
Hi all, I've been developing CF applications for over 10 years now. I've architected applications as well, taking them from concept through design, development, and implementation. I am now interested in making the shift into management. I'm not quite sure how to proceed and how to present myself. Several years ago, I did manager my own team of developers, but it was for my own company. I have since sold that company and have worked for other companies since 2005. Although I have 20 years of experience in IT, my Bachelor's degree is a BA in Religion and it is recent, from 2003 anyway. I've considered going back and getting a BS in Computer Science/Software Engineering, and then going on to get an MBA. I want to position myself to not only be a manager now, but also to be able to move into the director level position and above in the years to come. My current position is great, however, it may go away next year due to an impending acquisition of our company. As a result, moving up within my existing organization is probably not going to be an option for me. Any suggestions anyone has on how I should proceed? Thanks! Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3969 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
RE: cfarguments... determining which argument to use based on passed variables
Scott, Is your 'list' a list of person id's ? Dave -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2008 9:19 AM To: CF-Talk Subject: cfarguments... determining which argument to use based on passed variables Sorry for the cryptic subject In a function I have three arguments. cfargument name =person_id/ cfargument name = list/ cfargument name = dept_no_search/ at any given time only one will be populated, based on the existence of a url variable. and then cfif structKeyExists(Arguments,arguments.person_id) is Yes run queries based on person_id /cfif cfif structKeyExists(Arguments,arguments.list) is Yes run queries based on list /cfif etc... I know I could break the function up into separate functions, and the arguments have to be the first items in a function but is there a simple way to do this.. cfif IsDefined(url.person_id) cfargument name =person_id/ cfelse /cfif ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310917 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfarguments... determining which argument to use based on passed variables
Scott, Although it is not well-formed ColdFusion, you could leave off the cfargument tags altogether. They are not required. Then do whatever logic you want cffunction name=myTest cfdump var=#arguments# cfoutput #arguments[1]#br #arguments[2]# /cfoutput /cffunction cfset myTest('blah',1) You will see a dump of a structure with two keys, and you can access them like an array. Dave -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2008 9:19 AM To: CF-Talk Subject: cfarguments... determining which argument to use based on passed variables Sorry for the cryptic subject In a function I have three arguments. cfargument name =person_id/ cfargument name = list/ cfargument name = dept_no_search/ at any given time only one will be populated, based on the existence of a url variable. and then cfif structKeyExists(Arguments,arguments.person_id) is Yes run queries based on person_id /cfif cfif structKeyExists(Arguments,arguments.list) is Yes run queries based on list /cfif etc... I know I could break the function up into separate functions, and the arguments have to be the first items in a function but is there a simple way to do this.. cfif IsDefined(url.person_id) cfargument name =person_id/ cfelse /cfif -- -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310918 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Outputting columned UL tags
Andy, Check out Ben Nadel's blog entry from March last year: http://tinyurl.com/5tjcmf Sincerely, Dave Phillips http://www.dave-phillips.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2008 2:54 PM To: CF-Talk Subject: Outputting columned UL tags I'm looking to output a series of ULs and LIs in a 3 column fashion, like this: link1--link4--link7 link2--link5--link8 link3--link6 I've got code which lets me do it like this: link1--link2--link3 link4--link5--link6 link7--link8 But I'm a little mystified at how to accomplish the first. I actually thought it would be a piece of cake since I could just easily output the LIs inside the UL, but figuring out how many should be in each is bigger challenge than I first thought. Anyone have code like this already written? Yes, I feel like a chump because of this. No I haven't had any coffee yet today. Yes I'm going home to cry on my huge pilla'. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310928 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Submit ASP form using CFHTTP
They might be setting some cookies initially and also a session id of sorts. What you may need to do is hit their 'form' page once and capture the cookies (just dump the cfhttp scope after an initial hit and you can find them there - I think http-cookie scope, not sure). Then you will need to include those when you make the call to the form processor page. It will take some finagling, but you should be able to do it. Dave -Original Message- From: Billy Cox [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2008 2:38 PM To: CF-Talk Subject: Submit ASP form using CFHTTP I want to submit a zipcode to a form on another website and then manipulate the results using cfhttp.filecontent. When I run the code below, it churns for awhile and then gives me an ASP runtime error. cfhttp url=http://www.thesite.com/default.aspx; resolveurl=yes method=post cfhttpparam name=__EVENTTARGET value= type=formfield encoded=no cfhttpparam name=__EVENTARGUMENT value= type=formfield encoded=no cfhttpparam type=formfield name=__VIEWSTATE value=/wEPDwULLTIwMjUyMTc5NjdkZA== encoded=no cfhttpparam type=formfield name=TxtBox value=77083 cfhttpparam type=formfield name=Btn value=Find cfhttpparam name=__EVENTVALIDATION value=/wEWBwLBnPWtDgLJr7rmBQK7v+jaBALM9PumDwKGyM+UAgLI5IvWAQLTq+asCA== type=formfield encoded=no /cfhttp cfoutput#cfhttp.FileContent#/cfoutput I copied the values for __VIEWSTATE and __EVENTVALIDATION form fields from the 'view source', but they seem to be server-generated values aimed at preventing what I'm trying to do. Is there any way around this? I don't think that __EVENTTARGET and __EVENTARGUMENT are required. Billy Cox Old World Spices [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310889 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: select problem
Have you looked at your 'view source' code to see if 'selected' is every being generated? Are there any records in your table that have an empty cty_iso2 column? Dave -Original Message- From: Eclectic User [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2008 1:07 PM To: CF-Talk Subject: select problem tr tdCountry/td td select name=addr_country cfoutput query=getCountries option value=#getCountries.cty_iso2# cfif variables.addr_country eq getCountries.cty_iso2selectedcfelseif not len(trim(variables.addr_country)) and getCountries.cty_iso2 eq 'US'selected/cfif#getCountries.cty_name#/option/cfoutput /select /td /tr and I am using this query cfquery name=getCountries datasource=country table SELECT cty_iso2, cty_name FROMref_countries ORDER BY cty_name /cfquery but unfortunately, the correct country is not getting selected. If a country value is there, I want it to be selected, if nothing is there, I want United States as default. The column cty_iso2 has two letter code for the country like 'US' and cty_name contains the whole name like United States of America. I am not able to pin point what's wrong with this code. Also, I convert all the form fields values into variables scope before the start of the page. Please help. Thanks for help in advance. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310749 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using CFLoop to Define Variables
Jeanmarie, Another way is like this: cfset setVariable(SCx,listElement) Or for more cfscript purists: cfscript loop here... { setVariable(SCx,listElement); } Regarding cfset SC#x# = listEelment : Since this is an 'evaluation', and I have heard that 'evaluations' cost more performance wise than using a setVariable() with a concatenated variable name, I prefer to use the first method I indicated above. However, I can't confirm this performance issue, although maybe someone else on the list has done some performance testing with 'evaluations' and can comment on that. Dave Phillips -Original Message- From: Jeanmarie Richardson [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2008 12:32 PM To: CF-Talk Subject: Re: Using CFLoop to Define Variables Thanks Josh!! Not sure why I didn't try that :-) Try putting quotes around your variable: cfset SC#x# = listElement / -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310751 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using CFLoop to Define Variables
From http://www.cfquickdocs.com/?getDoc=SetVariable#SetVariable: Description This function is no longer required in well-formed ColdFusion pages. Well, that's good news. So all it comes down to then is preference. Although I do second Yuliang's comment that using an array might be better design. Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310757 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Redirection old ID values to new ID values
Paul, Can you change the old code? If so, you could just add something like the following to the top of each of the pages that use the ID's: (I don't know ASP syntax, but I think you will get the picture) asp code to access your new data source... SELECT new_id from new_table where old_id = #url.id# now do an ASP redirect to the new CF page with the NEW ID... If you can't change the old code, you could right a CF page that you redirect all pages to in IIS. Then, it will look at the CGI scope to determine the referrer (which would be the original page) and use that information to determine where to send it on the new site. Dave -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2008 4:00 PM To: CF-Talk Subject: RE: Redirection old ID values to new ID values Also note, this is on an IIS Server and the customer is leary of adding additional software to the server. -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2008 3:51 PM To: CF-Talk Subject: Redirection old ID values to new ID values I have a client whos old site (in ASP) is converting over to our CF storefront. We have the old ID values for their products and have stored them alongside the new ID values for the new store. I'm sure there is a way, but what would be the best solution when someone tried to go to the old page http://www.whatever.com/somepage.asp?id=1234 and call a CF page to look up id=1234 to re-direct them to the correct page? Is this possible? Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310770 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFQueryparam and NULLs.
I always use: null=#NOT len(trim(form.whatever))# as that catches everything. Dave -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2008 9:55 AM To: CF-Talk Subject: RE: CFQueryparam and NULLs. If FORM.makeID is either zero or a number: cfqueryparam value=#trim(form.makeid)# cfsqltype=cf_sql_integer null=#NOT FORM.makeID# Maybe throw in a Trim in the null= too. Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310367 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Installation of CF 8 (developer edition) is not working
Tgirl, When you tried re-install, did you first 'uninstall' CF, and then remove all existing CF directories so that you were doing a 'fresh' install? Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310396 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Installation of CF 8 (developer edition) is not working
* I uninstalled but didn't make sure all of the directories were removed. Should I try again? I would. Based on your last post, your jrun.jar file isn't even there, so you obviously don't have a full installation. I would check the downloaded file size as Ian pointed out. Then, if you can confirm you have a good download, go ahead and uninstall. Then remove all the coldfusion directories. I don't know if it's just c:\ColdFusion8 or not, maybe someone more familiar with 8 could pipe up on that one. There might be some registry entries to remove as well. Sincerely, Dave Phillips ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310400 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Installation of CF 8 (developer edition) is not working
Is there a better source to download from? No. Delete the download you have (permanently) and then download it again. Maybe even to a different location to be safe. Then check the size/md5 hash to be sure you have a good download. Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310402 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: When is a struct not a struct ?
Hmm, so how can I reliably tell I'm holding a struct and not a CFC ? isStruct() and not isObject() ? I think you can tell when you are holding a struct and not a CFC like this: cfif isStruct() and NOT isObject() this is a struct cfif isStruct() and isObject() this is an Object Since isObject() will only return true if it is an object, if you check both of them to confirm you have a structure, you will know for sure. Of course, if you just interrogate isStruct() then you won't know for sure, but if you check both, you will since we have proven that isObject() returns false on a structure, even if you have loaded it with functions to make it LOOK like an object. Of course, if you're checking to see if something is an object, you don't have to check both, you can just do isObject(), but in your case, I think you want to know if it is a structure and I think based on what we've seen, to be 100% sure, you have to do both. Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310200 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Installation of CF 8 (developer edition) is not working
Tgirl, I also just thought to ask are you on a VPN? When I'm on my VPN, I cannot access localhost as they have it locked down. I have to disconnect from VPN for it to work OR use my IP address as Scott is recommending below in #2. Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 7:32 AM To: CF-Talk Subject: Re: Installation of CF 8 (developer edition) is not working No you don't. It should work with the built in webserver for development. You can try a couple of things 1) http://127.0.0.1:8500/cfide/administrator/index.cfm 2) Run IPConfig from the command line. Find out what the IP address is for the machine that you're installing on, and use that IP instead of 127.0.0.1 3) Run netstat from the command line and find out what port ColdFusion is actually running on. As far as I know, You can build reports without ColdFusion running, but in order to view, test and set up any needed datasources you need the ColdFusion server running. -- Scott Stewart ColdFusion Developer http://www.sstwebworks.com/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310203 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Query of Queries
Heath, Can you run the following in a test.cfm file on your server (OUTSIDE OF YOUR EXISTING APP): cfquery datasource=yourdatasource name=qTest SELECT ID FROM WHATEVER (just use a simple query here) /cfquery cfquery dbtype=query name=qTestQOQ SELECT ID FROM qTest /cfquery cfdump var=#qTest# cfdump var=#qTestQOQ# Just trying to narrow down the issue. Sincerely, Dave Phillips -Original Message- From: heath stein [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 8:27 AM To: CF-Talk Subject: Re: Query of Queries Acctuly none of the tables have changed at all. Also every query that was using query of queries stoped working. Below is the error. java.sql.SQLException: String index out of range: 17 at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:73) at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:56) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:214) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447) at cfdsp_lesson_interface2ecfm1632308106.runPage(/nterface/dsp_lesson_interface ..cfm:31) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Have any of the tables changed? Could be that if you're using cfqueryparam on the original queries and the tables have changed, there might be a column mis-match. Adrian Today our development server got hung up. We had to restart coldfusion and after the restart all queries using query of queries stopped working. The error message says (string out of index 7). Our development server is a linux box with cf 6 installed. If any one has come across this issue please let me know. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310207 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Query of Queries
Yikes! Have you tried it with a different datasource? I can't imagine it is something with the way the database is returning the records, or even the driver for that matter, however, just to eliminate other possibilities. I'd try it with a different datasource (of the same type) and then if you still get it, a different datasource (of a different type), to rule that out too. If that still fails, then, since it is a development server, I would go ahead and reinstall CF and see if that solves the problem. If that doesn't work either, then I'm not sure what else to do short of deleting your entire installation and starting with a fresh new install. I'm sure you've thought of all that already, but I tried googling (as you have as well, I'm sure) and don't find any solutions out there on this, and I'm sure you don't want to be down longer than you need to be. Sorry I can't be of more help! Sincerely, Dave Phillips -Original Message- From: heath stein [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 8:55 AM To: CF-Talk Subject: Re: Query of Queries Thanks Dave, I actually did this out side of the current app, on a new table and got the same error. Heath Stein ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: Forms Generator
Anyone know of a quick way to generate some forms for several database tables? I'm using oracle, but that's not even a requirement at this point. Just looking for something to start with to save me some time. Preferably something Open. Thanks! Sincerely, Dave Phillips ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310216 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Deleting Session on Browser Close
Hi all, Most of you are probably familiar with the approach below to delete a session on the closing of the browser. I have, however, an environment where this is not working: Browsers: All IE 6+ O/S: Linux (Websphere flavor I believe) CF Ver: MX 6.1 (I know, I know - not my decision. ) Has anyone experienced this before? Here's the code I'm using (FYI - this same code works for an app hosted on a Windows box): cfif isdefined('Cookie.CFID') and isdefined('Cookie.CFTOKEN') cfset Variables.cfid_local = Cookie.CFID cfset Variables.cftoken_local = Cookie.CFTOKEN cfcookie name=CFID value=#Variables.cfid_local# cfcookie name=CFTOKEN value=#Variables.cftoken_local# /cfif Sincerely, Dave Phillips ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310231 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiple documents in a single cfdocument
cfdocument site:livedocs.adobe.com/coldfusion/8/ And if you don't remember that syntax, just google: cfdocument 8 By adding the 8, it will generally get you the version 8 results (you can do the same for 7 usually, 6 6.1, sometimes and 5 rarely) :) Sincerely, Dave Phillips ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310263 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4