RE: Handling invalid recipient in mailing list
Dave, You could have your code 'automatically' scrub the list and use a 'log' to keep track of the changes. This way you won't have to do a test run. Also, you could set up your code on a 'dummy' email server that will send the email but trap it prior to being mailed, this way you don't have to bother your recipients list. Also, you could create an email validation loop so that you can 'verify' the list without the concern for sending an email out at all (instead of doing a 'cfmail' tag, you would do the validation of the email address). I don't know how large your recipient's list is, but I would try to not bother them with testing emails. Just my 2 pence, William -- William Seiter -Original Message- From: Dave Long [mailto:d...@northgoods.com] Sent: Thursday, April 02, 2015 3:55 PM To: cf-talk Subject: RE: Handling invalid recipient in mailing list Thanks to all. The scheme worked perfectly. Next I will have to warn my recipients that a test is coming so I can remove invalid recipients. Unless maybe you can suggest a method to delete them as they occur. I intend to add a confirmation message requirement to our contact form, which should have been there all along, but a means of automatically cleaning the existing mailing list would help everyone... me most of all though. Thanks again for your help. Dave Long -Original Message- From: Rick [mailto:cfh...@kchost.net] Sent: Thursday, April 2, 2015 5:20 PM To: cf-talk Subject: RE: Handling invalid recipient in mailing list cftry Run you CFMAIL.. cfcatchMark email bad in database/cfcatch /cftry -Original Message- From: Dave Long [mailto:d...@northgoods.com] Sent: Thursday, April 02, 2015 5:12 PM To: cf-talk Subject: Handling invalid recipient in mailing list I am trying to send a mass mailing to a somewhat carelessly created list of contacts using e-mail addresses which were not verified at the time of entry. Whenever the cfloop tag comes to an erroneous recipient, it quits and throws an error. Is there anything I can do to the code to make it keep going? Here's the code: CFLOOP list=#Form.SelectedRecipients# index=Recipient CFMAIL from=#Form.Sender# to=#Recipient# subject=#Form.Subject# type=HTML htmlheadlink rel=stylesheet href=http://www.northgoods.com/global.css; type=text/css //headbody bgcolor=black table width=800 align=center TR TD align=center colspan=2 table width=800 align=center border=4 cellpadding=10 bgcolor=blacktrtd strongfont face=Arial size=+1 color=##FF6600 #Form.Message# /font/strong /td/tr/table table align=center trth colspan=2strongfont face=Arial size=-1 color=##FF6600If you would like to be removed frombrour mailing list, please click here:/font/strongbr a href=http://www.northgoods.com/unsubscribe.cfm?delEmail=#Recipient#; title=UNSUBSCRIBEfont face=Arial size=-1 color=whitestrongUNSUBSCRIBE/strong/font/abr font face=Arial size=-1 color=##FF6600You will receive one last message from us to confirm your removal from our list./font/strong/th/tr /TABLE/body/html /CFMAIL /CFLOOP ~| 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:360355 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF Builder 3
Good Afternoon, I have been playing with the mobile abilities of CF11 recently and just noticed that my trial copy of the CFB is coming to an end soon. Does anyone have an extra license for CFB 3 that they would be willing to part with? I don't want to pay the full retail price for something I am just 'playing with' yet. Thanks, William -- William Seiter ~| 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:360180 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Cannot access session variables in a cfc
Can you give us some code examples of how it 'used' to be setup? Where was the CFC saved. Where was the CFC called. How was it called. Etc. Not that fixing the actual problem will set you suddenly into best practices, but it will fix your current headache and then you can follow up with BP later when the fires are out. Thanks, William -- William Seiter -Original Message- From: John Pullam [mailto:jpul...@mcleansystems.com] Sent: Wednesday, January 28, 2015 8:57 AM To: cf-talk Subject: Re: Cannot access session variables in a cfc I know this isn't ideal, but it is a live application and the decision to move the cfc's outside of the doc root was taken because CF was having trouble finding them (for no obvious reason). Code that has worked since CF7 started breaking. So we moved them and this problem began. I am looking for a quick solution for now, knowing that I need to develop a better one. I'm wondering about putting the variable in the Application scope? Do the cfc's have access to that? ~| 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:360024 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Cannot access session variables in a cfc
You will need to pass your session variables as a parameter in order to use them in the CFC, this is best practices anyways. Good news, however, is that you can send them as a complete struct, you don't necessarily need to have them send all separately. cfargument name=sSession type=struct required=yes / Hope this helps, William -- William Seiter -Original Message- From: John Pullam [mailto:jpul...@mcleansystems.com] Sent: Wednesday, January 28, 2015 8:08 AM To: cf-talk Subject: Cannot access session variables in a cfc My app is running in a CF10 system and since I moved my cfc's out of the document root, they are losing access to the session variables. It seems that they work for around a day and then can no longer be found. I initialize them in my application.cfm to a value and I can still cfdump them in a regular web page, but the cfc fails with the error Element XXX is undefined in SESSION. Is this normal behaviour? If it is, then what is the alternative method of passing a variable into the cfc (other than making it a parameter when calling)? ~| 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:360022 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Call Rail API / CF
This line in the PHP seems to indicate that they are using double quotes
around the key.
curl_setopt($ch, CURLOPT_HTTPHEADER, array(Authorization: Token
token=\{$api_key}\));
Have you tried using double quotes around the key?
cfhttpparam type=header name=Authorization value='Token
token=MYKEYHERE' /
--
William Seiter
-Original Message-
From: Robert Harrison [mailto:rharri...@aimg.com]
Sent: Monday, January 19, 2015 8:48 AM
To: cf-talk
Subject: RE: Call Rail API / CF
Yes. The PHP version does pull the data. The CF version comes up empty.
Robert Harrison
Full Stack Developer
AIMG
rharri...@aimg.com
Main Office: 704-321-1234 ext.121
Direct Line: 516-302-4345
www.aimg.com
-Original Message-
From: Dean Lawrence [mailto:dean...@gmail.com]
Sent: Monday, January 19, 2015 11:46 AM
To: cf-talk
Subject: Re: Call Rail API / CF
Ok, good, I just wanted to make sure. So, when you use a GET, it sounds like
you are authenticating correctly, no? This my sound stupid, but do you have
any companies added to the system for the API to return? Also, have you
tried removing the single quotes from your API key in the header? In the API
documentation, it does not have quotes around it,
Authorization: Token
token=abc1234.
On Mon, Jan 19, 2015 at 11:37 AM, Robert Harrison rharri...@aimg.com
wrote:
I'm not using my key here... I just not posting my key to a public
forum that's indexed in Google.
And I've treid get also... I've tried every variation I can think of.
I got a 200 response from GET but no data. Otherwise I get 401.
Robert Harrison
Full Stack Developer
AIMG
rharri...@aimg.com
Main Office: 704-321-1234 ext.121
Direct Line: 516-302-4345
www.aimg.com
[image: profile picture] *Dean Lawrence*
*President*
Internet Data Technology
*Phone:* 888-438-4381 x701
*Web:* www.idatatech.com
*Email:* d...@idatatech.com
Programming | Database | Consulting | Training
~|
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:360002
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: local install - ses non working(I think)
Phillip, I like your sense of humor. --- William Seiter On Dec 23, 2014, at 4:00 PM, Phillip Vector vec...@mostdeadlygame.com wrote: *stares blankly at the screen* *gets up and goes to get some popcorn* Ok.. Proceed. On Tue, Dec 23, 2014 at 3:58 PM, Matthew Smith chedders...@gmail.com wrote: I have been developing on our live server as the site has been down for some time. I am trying to get things right and just installed apache and cf11 on my local box. This is the error I get when I try to bring up the site's home page. Any ideas, I am not sure what to try. Thanks. MissingInclude Could not find the included template /site_theartoflovingcatsanddogs_com/index.cfm/cfid/2/cftoken/60648468/index.cfm. Note: If you wish to use an absolute template path (for example, template=/mypath/index.cfm) with CFINCLUDE, you must create a mapping for the path using the ColdFusion Administrator. Or, you can use per-application settings to specify mappings specific to this application by specifying a mappings struct to THIS.mappings in Application.cfc. br Using relative paths (for example, template=index.cfm or template=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. /site_theartoflovingcatsanddogs_com/index.cfm/cfid/2/cftoken/60648468/index.cfm [empty string] [empty string]cfcatch.tagcontext - array1cfcatch.tagcontext - struct COLUMN0IDCFINCLUDELINE29RAW_TRACEat cfindex2ecfm1457390167.runPage(C:\wwwroot\index.cfm:29)TEMPLATE C:\wwwroot\index.cfmTYPECFML2cfcatch.tagcontext - structCOLUMN0IDCFINCLUDE LINE198RAW_TRACEat cfApplication2ecfc65118548$funcONREQUEST.runFunction(C:\wwwroot\Application.cfc:198) TEMPLATEC:\wwwroot\Application.cfcTYPECFML -- Regards, chedder is bedder ~| 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:359883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: local install - ses non working(I think)
That's not it... --- William Seiter On Dec 23, 2014, at 4:05 PM, Maureen mamamaur...@gmail.com wrote: It is fairly clear that the path you are using for the include is invalid. It needs to be a physical path, not a url, and I doubt if your physical path includes /site_ theartoflovingcatsanddogs_com/index.cfm/cfid/2/cftoken/60648468/index.cfm Are you using a variable to build the include path? On Tue, Dec 23, 2014 at 6:58 PM, Matthew Smith chedders...@gmail.com wrote: I have been developing on our live server as the site has been down for some time. I am trying to get things right and just installed apache and cf11 on my local box. This is the error I get when I try to bring up the site's home page. Any ideas, I am not sure what to try. Thanks. MissingInclude Could not find the included template /site_theartoflovingcatsanddogs_com/index.cfm/cfid/2/cftoken/60648468/index.cfm. Note: If you wish to use an absolute template path (for example, template=/mypath/index.cfm) with CFINCLUDE, you must create a mapping for the path using the ColdFusion Administrator. Or, you can use per-application settings to specify mappings specific to this application by specifying a mappings struct to THIS.mappings in Application.cfc. br Using relative paths (for example, template=index.cfm or template=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. /site_theartoflovingcatsanddogs_com/index.cfm/cfid/2/cftoken/60648468/index.cfm [empty string] [empty string]cfcatch.tagcontext - array1cfcatch.tagcontext - struct COLUMN0IDCFINCLUDELINE29RAW_TRACEat cfindex2ecfm1457390167.runPage(C:\wwwroot\index.cfm:29)TEMPLATE C:\wwwroot\index.cfmTYPECFML2cfcatch.tagcontext - structCOLUMN0IDCFINCLUDE LINE198RAW_TRACEat cfApplication2ecfc65118548$funcONREQUEST.runFunction(C:\wwwroot\Application.cfc:198) TEMPLATEC:\wwwroot\Application.cfcTYPECFML -- Regards, chedder is bedder ~| 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:359884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: local install - ses non working(I think)
My best guess, without looking at your admin, is that you did not setup your directories (for includes) in the administrator. Take a look at the live sites admin settings and mimic them on your local admin --- William Seiter On Dec 23, 2014, at 3:58 PM, Matthew Smith chedders...@gmail.com wrote: I have been developing on our live server as the site has been down for some time. I am trying to get things right and just installed apache and cf11 on my local box. This is the error I get when I try to bring up the site's home page. Any ideas, I am not sure what to try. Thanks. MissingInclude Could not find the included template /site_theartoflovingcatsanddogs_com/index.cfm/cfid/2/cftoken/60648468/index.cfm. Note: If you wish to use an absolute template path (for example, template=/mypath/index.cfm) with CFINCLUDE, you must create a mapping for the path using the ColdFusion Administrator. Or, you can use per-application settings to specify mappings specific to this application by specifying a mappings struct to THIS.mappings in Application.cfc. br Using relative paths (for example, template=index.cfm or template=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. /site_theartoflovingcatsanddogs_com/index.cfm/cfid/2/cftoken/60648468/index.cfm [empty string] [empty string]cfcatch.tagcontext - array1cfcatch.tagcontext - struct COLUMN0IDCFINCLUDELINE29RAW_TRACEat cfindex2ecfm1457390167.runPage(C:\wwwroot\index.cfm:29)TEMPLATE C:\wwwroot\index.cfmTYPECFML2cfcatch.tagcontext - structCOLUMN0IDCFINCLUDE LINE198RAW_TRACEat cfApplication2ecfc65118548$funcONREQUEST.runFunction(C:\wwwroot\Application.cfc:198) TEMPLATEC:\wwwroot\Application.cfcTYPECFML -- Regards, chedder is bedder ~| 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:359885 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Creating columns that aren't included in a query result
I know this topic has gone far since we last reviewed together, but I wanted to touch on this subject quickly. cfset variables.list1 = Agree,Disagree,Neither Agree nor Disagree,Strongly Agree,Strongly Disagree cfset variables.list2 = '#ValueList(getincreasedKnowledge.INCREASEDKNOWLEDGE)#' List 1 is a defined set of values or 'column headers' in a table. (HTML) List 2 is a resultset of values (valuelist()) or 'Row values' in a table. (query) By doing a 'ValueList()' for list2 you are telling the code to make a list of all of the resultset values for a specific column that was returned. By checking the second list for a matching value to the first, you are comparing 'column header' strings to 'row result values (possibly numeric?)'. -- William Seiter -Original Message- From: Torrent Girl [mailto:moniqueb...@gmail.com] Sent: Thursday, December 11, 2014 5:42 AM To: cf-talk Subject: Re: Creating columns that aren't included in a query result William, your suggestion is what I went with it initially: Here is my code: cfoutput cfloop index=i list=#variables.list1# cfif listFind(variables.list2, i) td align=centercfoutput#getimprovedCompetence.TOTALIMPROVEDCOMPETENCE#/cf output/td cfelse td align=center0/td /cfif /cfloop /cfoutput Here are my lists: cfset variables.list1 = Agree,Disagree,Neither Agree nor Disagree,Strongly Agree,Strongly Disagree cfset variables.list2 = '#ValueList(getincreasedKnowledge.INCREASEDKNOWLEDGE)#' The problem is for the cells that are supposed to have a value, it puts ALL of the values in these cells. This is where I got stuck. It seems illogical that a column would not exist from the query. Could you post the query that is being run? As to your display issue... cfif structKeyExists([qName],'[colName]') td#[qName].[colName]#/td cfelse td0/td /cfif One of these per column... ~| 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:359832 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Creating columns that aren't included in a query result
If I understand correctly Select response1 from [table] The resulting Query can equal 'response1' == 'Agree' or 'Disagree' or 'Neither Agree nor Disagree' or 'Strongly Agree' or 'Strongly Disagree' Then you loop over the results from the query and (I am guessing here) you want to place an 'X' in the box under the correct header? Simplest I can think of would be cfoutput query=[qname] tr cfswitch expression=#[qname].response1# cfcase value=Agree tdX/tdtd/tdtd/tdtd/tdtd/td /cfcase cfcase value=Disagree td/tdtdX/tdtd/tdtd/tdtd/td /cfcase cfcase value=Neither Agree nor Disagree td/tdtd/tdtdX/tdtd/tdtd/td /cfcase cfcase value=Strongly Agree td/tdtd/tdtd/tdtdX/tdtd/td /cfcase cfcase value=Strongly Disagree td/tdtd/tdtd/tdtd/tdtdX/td /cfcase /cfswitch /tr /cfoutput -- William Seiter -Original Message- From: Torrent Girl [mailto:moniqueb...@gmail.com] Sent: Wednesday, December 10, 2014 4:03 PM To: cf-talk Subject: Creating columns that aren't included in a query result I am hoping I can explain this correctly. I have a table which houses responses to a survey. The columns can have any of the following values: Agree,Disagree,Neither Agree nor Disagree,Strongly Agree,Strongly Disagree I have a table with the headers equal to all of the values above. I have a 2nd row that loops through the query and adds a cell in the row for each value: EX: td#query.value#/td Here is my problem: There are times when not all of the values exists, so I don't have enough of the dynamic cells in the row. EX: I have a header called Agree but the value agree is not returned from the query so it messes up the row. My question is how can I create a fake column from the query OR create an empty cell in the row if a value doesn't exist? NOTE: The values don't exist so I can test for existence if that makes sense. Thanks in advance. ~| 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:359804 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Creating columns that aren't included in a query result
It seems illogical that a column would not exist from the query. Could you post the query that is being run? As to your display issue... cfif structKeyExists([qName],'[colName]') td#[qName].[colName]#/td cfelse td0/td /cfif One of these per column... -- William Seiter -Original Message- From: Torrent Girl [mailto:moniqueb...@gmail.com] Sent: Wednesday, December 10, 2014 4:29 PM To: cf-talk Subject: Re: Creating columns that aren't included in a query result Russ there is only one loop. It's a very simple table with a static first row with headers and a simple query loop to add columns. So here is my header row: Agree, Disagree, Neither Agree nor Disagree, Strongly Agree, Strongly Disagree And here is my dynamic row created from the query: Agree, Disagree, Strongly Agree, Strongly Disagree So, if 'Neither Agree nor Disagree' is not returned from the query, I am short of one cell and it throws it off. I need to create an empty cell for each one that wasn't returned. why do you need the 2nd loop rather than simply outputting the value of the query column from the main loop? On Thu, Dec 11, 2014 at 12:02 AM, Torrent Girl moniqueb...@gmail.com wrote: ~| 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:359808 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Redirects
Unless you need these redirects to be dynamically controlled by a datasource, I would handle them outside of CF. You could use a mod_rewrite on the server or even a virtual directory. If you are determined to utilize CF for this, look into the cflocation tag. (http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0 811cbec22c24-7cac.html) It does what you are looking to do. Hope this helps, William -- William Seiter -Original Message- From: Steve LaBadie [mailto:slaba...@po-box.esu.edu] Sent: Monday, November 10, 2014 12:39 PM To: cf-talk Subject: Redirects We are currently using a meta date redirect from a UNIX box. The redirects currently sit on www and the production server sit at www4. We are taking down www so the redirects have to be recreated on our new production server which will be taking www. Current redirect structure: HTML BODY META HTTP-EQUIV=REFRESH CONTENT=1;URL=http://www4.esu.edu/about/offices/police/index.cfm; /BODY /HTML When the user types in www.esu.edu/policehttp://www.esu.edu/police it takes you to the correct page. We use this format to avoid long URLs on marketing pieces. Can someone give me directions for best practices using CF. The new production server currently runs CF9 but looking to upgrade to CF11. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edumailto:slaba...@esu.edu [facebook-16x16]http://www.facebook.com/eaststroudsburguniversity [twitter-16x16] http://twitter.com/esuniversity [youtube-16x16] http://www.youtube.com/user/esuedu ~| 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:359595 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Avoiding a boat load of queries inserting multiple records - Better Way?
It sounds like your client needs a smarter application. When your client uploads their XLS document, you can add functionality that displays back to them the first line of the excel spreadsheet and have them identify which column is filled with which data...( email|first name|last name|company) Then you can instruct whichever method you end up using to correlate the correct column with the correct data. William -- William Seiter -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Thursday, October 09, 2014 5:51 PM To: cf-talk Subject: Re: Avoiding a boat load of queries inserting multiple records - Better Way? Not knowing much about your overall process, I'll try to stick to some generic ideas. Let's assume you don't need this stuff dumped into the database the very second it gets sent to you. This is actually part of a client's admin system on their website. They send out legal newsletters. LOTS of legal newsletters. And they have boats loads of various list they can send them too. Some lists go to 15,000 or more subscribers at a time. They want to be able to import as many list as they want with as many records at any time they want by just clicking the import list button... This app have been around for awhile. They just upgraded their server, so up to this point the import function was using the POI utility. Even when they entered a legal spreadsheet into the system, if it had too many records or extra crap for POI to chew through, the whole thing would time out. They KNOW that the damn spreadsheet is supposed to be formatted a very specific way for this to work, and there's a template they're supposed to use, but clients being clients, they will attempt to shove ANYTHING in there at times, and then yell when it doesn't import. Even the concept of the email address HAS to be the first column just gets ignored a lot. This particular application has been a huge challenge from day one, mostly because the rules get ignored half the time, so the app kicks the spreadsheet back out at them and demands it be reformatted, and they yell about it thinking that it should be able to import whatever they try to put in. Ain't never gonna happen. Really, how hard is: email|first name|last name|company? But I see sheets with hidden columns, paragraphs of extra stuff, formulas (what the heck for? It's supposed to be a list of addresses!!), email address in the 9th column when the app is specifically set to ignore anything past the first four ... it's unreal. Since the server upgrade, sheets that would time out seem to get parsed pretty quickly by cfspreadsheet functions. I'm happier with it now. But, I'm trying to improve on the efficiency of the whole thing by optimizing the queries, because I KNOW that running 20,000 queries to import 5000 email addresses isn't a good thing as far as cpu cycles go. I'm having my local SQL Server expert meet with me tomorrow and we'll get a stored procedure written to take care of all this in one fell swoop... Clients, huh?? Sheesh! ~| 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:359449 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Avoiding a boat load of queries inserting multiple records - Better Way?
Have you investigated using a Stored Procedure that does both inserts? -- William Seiter -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Thursday, October 09, 2014 9:31 AM To: cf-talk Subject: Avoiding a boat load of queries inserting multiple records - Better Way? I've got an application that imports email list from Excel sheets. Mostly working fine, but I've got one spot where I'd like to optimize things if I could. Once the data is imported I run two queries against each email address: 1. see if the email address is already in the group in question 2. see if this person has already unsubscribed from this list --- If both of those return no records, and I've already run some other validation making sure entered info is valid, I add everything to an array: cfset mailREC[CurrentRow][1] = email / cfset mailREC[CurrentRow][2] = fname / cfset mailREC[CurrentRow][3] = lname / cfset mailREC[CurrentRow][4] = other / Now the problem ... I need to do two inserts - first to enter the info into the email database - second to capture the ID from the first insert, and put that into a relational table that assigns that address to the specified group. I removed cfqueryparam from the below to make it more compact... So, I loop through my array and enter all the records.. loop.. cfquery name=insertEMAIL SET NOCOUNT ON . remainder of insert code SET NOCOUNT OFF SELECT @@IDENTITY AS fromLISTID /cfquery cfquery name=insertGROUP INSERT INTO nl_catREL ( groups_id, email_id ) VALUES ( #req.thisGROUPID#, #insertLIST.fromLISTID# ) /cfquery /loop.. The problem is, some of these spreadsheets and have up to 5,000 or more email addresses. That means, just for the insert, two queries for each address = 10,000 queries. If it was just one insert query, no big deal, as I could loop inside the query tag itself and reduce it to one call. It's the two combined that are giving me a headache. The application IS working the way it is, but shove a 15,000 email list into it, and it obviously chokes. Is there a better way to set up my two insert queries above so it's not making two calls for every single address? ~| 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:359427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Avoiding a boat load of queries inserting multiple records - Better Way?
What kind of database? MSSql? Mysql? Oracle? ... -- William Seiter -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Thursday, October 09, 2014 1:29 PM To: cf-talk Subject: Re: Avoiding a boat load of queries inserting multiple records - Better Way? On 10/9/2014 1:49 PM, Cameron Childress wrote: Most databases will let you issue multiple SQL statements in a single request/transaction. You just have to separate them with a semicolon. If you did it this way, how would you get the ID from the first insert for use in the 2nd ... (because I'm looking at stored procedures and I'm not ashamed to admit that doing that inside SQL Server is beyond my coding capabilities - unless somebody can point me to /The Complete Idiot's Guide to Writing this Procedure with SqlServer 10/ (which I've been looking for but haven't found yet...) So something like: cfquery cfloop insert into table_1 (...) values (...); insert into table_2 (table_1_id, other_stuff) values (#Id_from_above_insert#, #other_stuff# ) /cfloop /cfquery ~| 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:359436 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Avoiding a boat load of queries inserting multiple records - Better Way?
Off the top of my head... To insert the last inserted unique id in a transaction... cfquery INSERT dbo.table(column) SELECT 1; SELECT @newID = SCOPE_IDENTITY(); INSERT dbo.table_2 (column) SELECT @newID; /cfquery -- William Seiter -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Thursday, October 09, 2014 2:14 PM To: cf-talk Subject: Re: Avoiding a boat load of queries inserting multiple records - Better Way? On 10/9/2014 5:00 PM, Cameron Childress wrote: A few years ago I stopped using numerics and auto-increment and started using UUID for all PK/FK columns. On new stuff, this is what I'm doing as well. Unfortunitely, this is a pre-existing app and would take a good bit of rewrite to do that. Still scratching my head over writing the procedure itself. ~| 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:359438 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using a variable to dynamically specify table name in CF10?
What is the error message that you receive? -- William Seiter On Mar 29, 2013, at 9:40 AM, Marty Franklin ma...@assetresearch.com wrote: I am in the process of moving from CF8 to 10. I have a couple of queries where I dynamically specify the table name. For some reason this technique does not work in CF10? So for instance... cfset tblname = cooltbl cfquery name=dblist datasource=#application.ds# SELECT * FROM #tblname# /cfquery Thanks is advance. -- Best Regards, *Marty Franklin* /Information Technology/ *Asset Research Services, Inc.* ma...@assetresearch.com mailto:ma...@assetresearch.com ~| 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:355205 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: validating query string error
From the Coldfusion docs:
If TestValue = 234A56?7', Val(TestValue) returns 234.
If TestValue = 234'5678'9?', Val(TestValue) returns 234.
If TestValue = BG234, Val(TestValue) returns the value 0, (not an
error).
If TestValue = 0, Val(TestValue) returns the value 0, (not an error).
So lid=14%27%2F%2A%2A%2For%2F%2A%2A%2F1%3D%40%40version
Val('14%27%2F%2A%2A%2For%2F%2A%2A%2F1%3D%40%40version') would be equal to
14, which is numeric.
-Original Message-
From: Mike Little [mailto:m...@nzsolutions.co.nz]
Sent: Monday, June 11, 2012 3:09 PM
To: cf-talk
Subject: validating query string error
on my pricing page, i have the following if statement to ensure invalid url
vars are not being input...
if (isnumeric(val(URL.lid))) {
however the query string below seems to get through? what should i be doing
instead?
--- error message ---
Diagnostics: The LOCATION_ID argument passed to the get_term_loaded function
is not of type numeric. If the component name is specified as a type of this
argument, its possible that a definition file for the component cannot be
found or is not accessible.
The error occurred on line 153.
Referrer:
Template: /pricing.cfm
Query string: lid=14%27%2F%2A%2A%2For%2F%2A%2A%2F1%3D%40%40version--
~|
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:351548
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: bizarre cffile upload bug.
Is that location inside of the web root? You say the file exists but isn't openable, right? If it is outside of the web root, you may need to add a mapping to the server. -- William Seiter On May 7, 2012, at 6:32 PM, Tony tonyw...@gmail.com wrote: hi there. im sending a file to my server with the following code: cffile action=upload destination=d:\webserver\doman.com\www\docs nameconflict=overwrite filefield=pdf_file attributes=readonly / the result of this when I browse the file in chrome and safari (on my mac) both result in a Failed to Load PDF Document error. _however_ if I simply ftp the file, the same exact file from my machine, and I browse to it, it's working just fine :) *when I use CFFILE, the file actually appears on the server, and i can see the file, with filesize as I would expect it. this doesnt work, I need to build this for my client to manage the files themselves, ive done this 20 other times for other clients, but today, its just not working... any clues?! ive tried every attribute i can think of... nothing is making sense. thanks tw ~| 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:351040 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SEO
Hey Dave, The description of what you are trying to accomplish is very vague. If you just wanted clarification on redirects vs SEO, they are not good practice and will probably mess everything up. If you want advice on how to handle what you need to accomplish on an SEO friendly way, please post what it is that your index page is doing, being as specific as possible. Or hit me up off list -- William Seiter On Jan 20, 2012, at 7:15 AM, Dave Hatz daveh...@hatzventures.org wrote: Sorry about the OT here, but I know there are some really good SEO people that are on this list. I have a CFM page that processes some information, then redirects to another CFM page. I have a client that is telling me that my redirect inside my cfm page is not going to work for SEO. I have index.cfm, it parses the URL for some data, updates the DB, then I use CFLOCATION to send the page to another CFM page. Client says this will not work for his SEO stuff. As you can tell, I am not well versed in SEO. Can I get some verification from others on this list that are well versed on SEO topics and let me know if my client is right or wrong? ~| 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:349581 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFSELECT - Required
The message isn't appearing because your form element has a value. the blank space is considered a value. William -- William E. Seiter On Dec 13, 2011, Robert Harrison rob...@austin-williams.com wrote: According to the CF documentation you can make a select list required and you can get around the need to set the size gt 1 by entering as the value of the first option. This is the documentation: REQUIRED... Note: This attribute has no effect if you omit the size attribute or set it to 1, because the browser always submits the displayed item. You can work around this issue: format forms by having an initial option tag with value= (notice the space character between the quotation marks). This is the code: cfselect name=dob_mm style=width: 100px; class=#color3# required=yes message=Please enter your date of birth option value= Month/option option value=1January/option option value=2February/option option value=3March/option option value=zzzMore/option /cfselect What am I doing wrong? I just want to get the message when the users selects the Month option. Thanks Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged ~| 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:349080 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: RE: CFSELECT - Required
I would be curious as to what adobe documentation said that is the way to do it. I guess the classification as a 'bug' would be determined by the definition of why that message would launch. CF does not actually process the form when submitted. CF creates the javascript and form elements and allows the browser to process the HTML event. Because of this, HTML sees an option in the select statement and says that the form field has value (even if that value is empty or just a space) If, however, you were to create a muli-choice select box, or a select box that has 'no options' in it, then the message would react as you are expecting. The select form element gives options to the user to choose from. By default, a selection is made when the page is loaded, whether the user actually activated the element or not. Because of this, the message doesn't launch. If there were no options in that select element, then the message would launch accurately. In order to throw an error on that select box, you will probably do best to roll some of your own javaScript that throws the error message if the value of that selected option is 'blank' or ' '. I haven't tested this, and the docs don't indicate that it is supported, but I would try this. cfselect name='whatever' validate='numeric' message='I said, choose a value' option value=''Choose a Value/option option value='1'One/option option value='2'Two/option /cfselect -- William E. Seiter On Dec 13, 2011, Robert Harrison rob...@austin-williams.com wrote: The message isn't appearing because your form element has a value. the blank space is considered a value. According to the CF documentation that is how to make it work. Regardless, it also does not work if you say value= or leave out the value clause altogether. I looked this up on Adobe forums and apparently this has been a long-standing bug that Adobe has not addressed. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or.#160; It must be#160;. Plug in to our blog:#160;AW Unplugged http://www.austin-williams.com/unplugged ~| 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:349083 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Amazingly annoying concurrent CFC variable issue
Inside your methods (cffunction) use scoping. For example. cffunction name=DoSomeAction output=no returntype=any cfargument name=RecordID required=yes type=numeric cfset var local = StructNew() / cfset local.GetRecord = Application.Functions.GetRecordFromRecordID(arguments.RecordID) !--- HERE IS THE PROBLEM: arguments.RecordID doesn't always match GetRecord.RecordID --- cfreturn local.Whatever /cffunction -Original Message- From: Tavs Dalaa [mailto:j...@dalaa.com] Sent: Saturday, October 15, 2011 8:47 AM To: cf-talk Subject: Amazingly annoying concurrent CFC variable issue I've got some pretty simple CFC code which fails when executed with 10+ concurrent connections. Variables between requests get mixed up, so one request with recordID 10 suddenly returns with recordID 2 etc, causing issues in the application. This is simplified version of code: application.cfm cfapplication name=OurApp applicationtimeout=#CreateTimeSpan(0,1,0,0)# cfset Application.functions = createObject(component,com.ourapp.functions).init() / functions.cfc cfcomponent displayname=Our functions cffunction name=init output=false returntype=any access=public cfreturn this / /cffunction cffunction name=DoSomeAction output=no returntype=any cfargument name=RecordID required=yes type=numeric cfset GetRecord = Application.Functions.GetRecordFromRecordID(arguments.RecordID) !--- HERE IS THE PROBLEM: arguments.RecordID doesn't always match GetRecord.RecordID --- cfreturn Whatever /cffunction cffunction name=GetRecordFromRecordID output=no returntype=any cfargument name=RecordID required=yes type=numeric cfquery name=GetRecord datasource=#Application.AppDatasource# SELECT RecordID,RecordTitle FROM Records WHERE RecordID = cfqueryparam value=#arguments.RecordID# cfsqltype=CF_SQL_NUMERIC /cfquery cfreturn GetRecord /cffunction /cfcomponent index.cfm cfset ActionResult = Application.Functions.DoSomeAction(URL.RecordID) Now, pretty simple, and tons of irrelevant code removed. If we fire 50 requests at the same moment to index.cfm, like: index.cfm?RecordID=1 index.cfm?RecordID=2 .. .. .. Then within the DoSomeAction function, we see that 1 out of 25 requests on average there's a mixup, we get a result for a different record than the one we requested. Tried to wrap in CFLOCK, eg: cflock name=Lockname timeout=15 type=exclusive cfset GetRecord = Application.Functions.GetRecordFromRecordID(arguments.RecordID) /cflock .. no diff. Tried to Var and cflock, ie: cflock name=Lockname timeout=15 type=exclusive cfset Var GetRecord = Application.Functions.GetRecordFromRecordID(arguments.RecordID) /cflock Any ideas? ~| 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:348184 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Amazingly annoying concurrent CFC variable issue
I was not referring to 'var'ing, I was referring to 'scoping'. When you create a scope inside of the function, that scope only has value within that function. You will want to upgrade the ' GetRecordFromRecordID' to also use scoping as well. William -Original Message- From: Tavs Dalaa [mailto:j...@dalaa.com] Sent: Saturday, October 15, 2011 9:00 AM To: cf-talk Subject: Re: Amazingly annoying concurrent CFC variable issue Makes no difference. As mentioned, I've already tried var'ing within the functions. Tavs Inside your methods (cffunction) use scoping. For example. cffunction name=DoSomeAction output=no returntype=any cfargument name=RecordID required=yes type=numeric cfset var local = StructNew() / cfset local.GetRecord = Application.Functions.GetRecordFromRecordID(arguments.RecordID) !--- HERE IS THE PROBLEM: arguments.RecordID doesn't always match GetRecord.RecordID --- cfreturn local.Whatever /cffunction I've got some pretty simple CFC code which fails when executed with 10+ concurrent connections. Variables between requests get mixed up, so one request with recordID 10 suddenly returns with recordID 2 etc, causing issues in the application. This is simplified version of code: application.cfm cfapplication name=OurApp applicationtimeout=#CreateTimeSpan(0,1,0,0)# cfset Application.functions = createObject(component,com.ourapp.functions).init() / functions.cfc cfcomponent displayname=Our functions cffunction name=init output=false returntype=any access=public cfreturn this / /cffunction cffunction name=DoSomeAction output=no returntype=any cfargument name=RecordID required=yes type=numeric cfset GetRecord = Application.Functions.GetRecordFromRecordID(arguments.RecordID) !--- HERE IS THE PROBLEM: arguments.RecordID doesn't always match GetRecord.RecordID --- cfreturn Whatever /cffunction cffunction name=GetRecordFromRecordID output=no returntype=any cfargument name=RecordID required=yes type=numeric cfquery name=GetRecord datasource=#Application.AppDatasource# SELECT RecordID,RecordTitle FROM Records WHERE RecordID = cfqueryparam value=#arguments.RecordID# cfsqltype=CF_SQL_NUMERIC /cfquery cfreturn GetRecord /cffunction /cfcomponent index.cfm cfset ActionResult = Application.Functions.DoSomeAction(URL.RecordID) Now, pretty simple, and tons of irrelevant code removed. If we fire 50 requests at the same moment to index.cfm, like: index.cfm?RecordID=1 index.cfm?RecordID=2 .. .. .. Then within the DoSomeAction function, we see that 1 out of 25 requests on average there's a mixup, we get a result for a different record than the one we requested. Tried to wrap in CFLOCK, eg: cflock name=Lockname timeout=15 type=exclusive cfset GetRecord = Application.Functions.GetRecordFromRecordID(arguments.RecordID) /cflock .. no diff. Tried to Var and cflock, ie: cflock name=Lockname timeout=15 type=exclusive cfset Var GetRecord = Application.Functions.GetRecordFromRecordID(arguments.RecordID) /cflock Any ideas? ~| 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:348187 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How CF works
Post code -- William Seiter On Oct 14, 2011, at 2:09 PM, Stephens, Larry V steph...@indiana.edu wrote: Thanks. I found the culprit. Odd thing is I've used it on a lot of pages without a problem but this page (and one other) acts up with it. It's a third party js library I got from Dynamic Drive several years ago - jumptop.js Allows the user to jump to the top on a long page. The error is Warning: an unbalanced tree was written using document.write()causing data from the network to be reparsed. I pinpointed the line but don't see the error. I've just taken the library out. -Original Message- From: Nathan Strutz [mailto:str...@gmail.com] Sent: Friday, October 14, 2011 1:24 AM To: cf-talk Subject: Re: How CF works Larry, ColdFusion will not return something different to different browsers unless you explicitly tell it to do so. The most likely culprit here is bad HTML, Javascript and CSS. It sounds like an unclosed (or unopened) table tag, a missing quote on an inline style attribute, or something related. Set a doctype (I like !doctype html) and and run the W3C validator or an html lint, then try jslint and csslint, you will find the problem with one of these, and if not, just rewrite the html, remove your table tags except where they are literally needed, separate your styles and javascript from your html, and just spruce things up. If there's something about the page that IE doesn't like (and it wouldn't be the first time), move elements around and play with the stylesheet until it does. nathan strutz [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz] On Thu, Oct 13, 2011 at 7:57 PM, Stephens, Larry V steph...@indiana.eduwrote: I have a page that does a moderately involved query: it returns 16 fields with 3 left joins, a simple WHERE and ORDER. (I'd include it here but I'm remoting in and can't copy-and-paste). The database is small - only 40 or so record at this point. I can see it in Mozilla and IE, with XP and Windows 7. I'm on DSL and it pops for me almost immediately. A user, on DSL using IE, complained the page just flashed at her. I finally duplicated the problem by accident: my laptop started updating its virus definitions and then the page started flashing at me. These aren't public pages so I can't give free access. That user switched to Mozilla and her problem went away. Next user, same problem. I'm to the point where all I display is a CFDUMP of the query and one header row of the output. She still can't see it. So, the user loads the page and a query is sent to the CF server. It returns a table with 14 columns, a couple of header rows. So why does it appear to return he menu options and the the beginning of the table, then send the same thing over and over but never filling out the table (with only 12-24 rows)? I believe it's because her machine is too busy to process what the server is sending it but I must be missing something. Especially since it works in Mozilla but not IE. Thanks. ~| 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:348165 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Caching ajax / dhtml
JavaScript is run on the client side, so unless that JavaScript is pointed to your server to get the information... You will need to find another way. -- William Seiter On Sep 13, 2011, at 4:12 PM, Matt Williams mgw...@gmail.com wrote: I have some divs that are populated with tweet.js (jquery plugin for twitter). So on document.ready(), the divs are populated by the plugin. I don't want to hit twitter on every page load and want to cache the populated divs somehow. Is there a way to take those populated divs and cache them? Simply saving the content to html is still saving the javascript too and not the actual output. I guess I may have to switch to grabbing the feed using cffeed or something, but this code is already done and styled, so I was hoping for something else. Thanks, -Matt ~| 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:347451 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Way to send data as a form without using a form?
There are different ways to handle this, posting your form variables into your subsequent URL variables being one of them. A few questions to establish what you are actually looking for. 1. The 'conditional' redirect; Are you redirecting the user to a different website, or just to a different page on your website? 2. If you are sending the user to a different website, do you have to? Can you use cfhttp to call the page on the other site, using your form variables, and then just display the results to your user on your own site? 3. If you are keeping the user on your own website, does the url have to change to the 'redirected' page in order for the application to work properly? If you are concerned with the url having the form data in it, you could use a 'main' page that 'includes' a subsequent page (chosen from many) depending on the form entry's information. For example. If it is a 'search page' and the search results would display differently depending on what was searched. Main.cfm cfif form.SearchType eq 'person' [include, method call, etc to have the person search results display] cfeleseif form.SearchType eq 'place' [include, method call, etc to have the place search results display] /cfif If there is a different concept you are trying to create, share the specifics and I am sure we can point out one or two ways to accomplish it. William -Original Message- From: Pete Ruckelshaus [mailto:pruckelsh...@gmail.com] Sent: Sunday, August 21, 2011 11:47 AM To: cf-talk Subject: Way to send data as a form without using a form? Hopefully simple question. I would like to do a conditional redirect from one page to another. For some of those conditions, I would like to send data along with this redirect, and I would prefer to not do it via URL parameters. Is there any way to send data as form values without actually using a form? Thanks, Pete ~| 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:346908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SerializeJSON is Undefined
SerializeJSON was added in CF8 http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_f_21. html William -Original Message- From: Joshua O'Connor-Rose [mailto:joshua.oconnorr...@gmail.com] Sent: Saturday, August 13, 2011 9:45 AM To: cf-talk Subject: SerializeJSON is Undefined I'm worknig through the pains of an inexpensive host that severely limits CF functionality. I'm setting up ajax for the site and step one of everything is putting error handling in place. In any case this is my first cf ajax project and I was adding Bens ajax error handling and the test cfm file has this line cfset strJSON = SerializeJSON( objResponse ) / I'm getting an error back Variable SERIALIZEJSON is undefined the server is CF7 any thoughts -Joshua O'Connor-Rose -All is Good ~| 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:346744 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: loop timing out
Hey Daniel, In order to assist you, it would be helpful to see the code that has the loop as well as some knowledge of what the 'database call' is doing. (maybe the database call isn't returning?) The cfsetting that you mention, does only change the timeout setting for the page that it is set in. It does not change the master settings in the cfadmin, so it will not effect other pages on your website directly. (this is true from CF7 thru CF9, and I would expect any future version of CF as well) The issue that it appears that you are running into is two-fold. 1. how many 'actions' are you looping over combined with 2. how long does it take to complete each action. Setting up a 'grouped' plan to only run x of them is a valid assessment, but I would suggest that you do this by tracking which ones need to be redone outside of the page. An example would be, you could have each of the necessary redone's to show up in a database table, and mark them as completed once they are done. The you would just need to pull the oldest 5 of them each time you load the page. (this would mean the page would have to be loaded more often. The best solution for you, will probably come after you have posted some more information (the loop code and 'what' the action is doing) hope this helps, William -- William E. Seiter On Jun 27, 2011, daniel kessler dani...@umd.edu wrote: I'm creating a scheduled_task to correct a problem. For the correction, I'm doing a query for the list of problem records. Then I'm looping through the problem records and resending each one of them through the same code that it went through when it developed the problem. That code has several database updates. Unfortunately, I'm timing out of the cfloop. I don't have access to the page that I'm looping through, so I can't change it. Is there a way to let a loop have other transactions so that it doesn't time out? I thought of putting the loop in another loop, so that it only does 5 at a time, but then that's just a loop in a loop and then the outer one will time out. Did I state this clearly? A friend of mine suggested the line: cfsetting requestTimeOut = 120â I am told that this setting will only be persistent for that page and that the timeout will revert to it's previous setting once the page is done running. Is that correct? I was also concerned that when CF is upgraded (we're on CF7 for this app) that this setting might be trouble. Any thoughts? Overall, I'd like a different solution than this, something that will make the loop more acceptable. thank you for any assistance. daniel ~| 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:345806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: DateDiff Weirdness/Possible bug
It looks like the times are off by 1 hour. Did you check your server's
clocks to make sure they are both set to the same time?
-Original Message-
From: Ruslan Sivak [mailto:cfli...@ruslansivak.com]
Sent: Thursday, June 09, 2011 9:43 PM
To: cf-talk
Subject: DateDiff Weirdness/Possible bug
I'm having trouble with different results for DateDiff between CF and SQL
Server. I'm guessing it has something to do with DST, but it seems that CF
is doing it wrong.
Doing a SQL Query like this:
select DateDiff(s,'1/1/1970','6/1/2011') as datediff
I get 1306886400.
Doing
cfdump var=#DateDiff(s,'1/1/1970','6/1/2011')#
I get 1306882800.
Converting SQL's result back to Date using CF:
#dateAdd('s',1306886400,'1/1/1970')#
I get {ts '2011-06-01 01:00:00'}
According to http://www.epochconverter.com/, 1306886400 is the correct
number of seconds for midnight on June 1st, 2011.
Is there a reason that CF is returning the wrong number of seconds?
Russ
~|
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:345141
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Problem Using QueryNew
You are using a simple cfloop from to, instead of a cfquery or a cfloop query. Because of this, when you call #stockTable.stockTitle#, it defaults to the first line of the query. Either change your loop to a cfloop query=stockTable Or change your data call to #stockTable.stockTitle[R]# William -Original Message- From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] Sent: Saturday, April 23, 2011 9:45 AM To: cf-talk Subject: Problem Using QueryNew My first time using created queries, I can't understand why this is putting the same value on every row. cfset stock = QueryNew(StockTitle, Varchar) cfoutput cfloop from=1 to=#stockTable.recordcount# index=R cfset newrow = QueryAddRow(stock,1) cfset temp = QuerySetCell(Stock, stockTitle, #stockTable.stockTitle#, R) /cfloop /cfoutput cfoutput query=stock #stock.stockTitle#br / /cfoutput No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3591 - Release Date: 04/23/11 07:36:00 ~| 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:343910 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re: file upload - preventing double or more full stops in file name
Please have a look at this post: http://www.williamoncoldfusion.com/index.php/knowledgebase/file-uploading If you are referring to the cffile.serverfilename key that is available after the cffile upload command, that brings back somefile.mack, the extension is in a different key off of cffile of serverfileext. checkout this page as well: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_f_10.html -- William E. Seiter On Mar 7, 2011, Don danfar...@hotmail.com wrote: Why do you need to do this before you process it with CFFILE? Because once its uploaded the server hacks off the last (.) For example: original file: somefile.mack.txt renamed file on server: somefile.mack I would like to retrieve the original path of the file upload for the purposes of grabbing the initial file name and then checking to see how many full stops (.) are in the original file. I need this to happen before I process it via CFFILE. Right now the form data posts back in a cfdump var=#form. b_original_form_filefield# as: C:\JRun4\servers\cfusion25\SERVER-INF\temp\cfusion. war-tmp\neotmp4910092545170934955.tmp which is sort of useless for my needs. Is there a workaround? Why do you need to do this before you process it with CFFILE? All that happens when you use CFFILE ACTION=UPLOAD is that CF writes the file to a specified location on the filesystem. The file has already been received by the web server, and stored in a temporary file location. So, write the file to the filesystem in one place, then move it somewhere else with a subsequent CFFILE if you really want to. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:342815 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: RE: Database Lookup - Possible with CF?
Curious... Where are you that they are moving away from CF onto .NET and Java(ADF)? -- William E. Seiter On Mar 3, 2011, Ian Vaughan i.vaug...@neath-porttalbot.gov.uk wrote: Hi Dave I'm willing to give CF a go, even though here the move is away from CF onto .NET and Java (ADF) Do you have any step by step tutorials that I could follow that I can use to implement the feature below in CF, if they can see what it can do it would certainly help its case. All I am looking to do is when a user fills in their employee number in a form text field, ajax calls CF to run a SQL query to bring back and populate the other fields in the form with that employees info. Is it really that difficult to achieve the above? Are there any ajax/jquery libraries I could use to integrate in with CF because javascript is not be strong point -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 03 March 2011 15:02 To: cf-talk Subject: Re: Database Lookup - Possible with CF? So would I be better developing this application in a language that is more scaleable/future proof than CF You won't be using ASP.NET then, right? Because (a) it's not more scalable, and (b) any platform effectively limited to Windows is not more future-proof. I mean, I could see your point if you were talking about Java, even if I'd quibble on the scalability bit. Having worked with some high-scalability clients, I am very confident that CF is as scalable as .NET. I've mentioned them on the list before, so I'm not going to bother enumerating them now, but I'll be happy to provide further details on request. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:342726 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Change in ColdFusion management
Anyone have Adam's announcement? I keep trying to access it and get a blank page. Thanks, William -- William E. Seiter On Feb 14, 2011, cft...@fusionlink.com wrote: In case people don't know and many may not due to the way it was announced late last friday, there is a debate going on with the recent change in Adobe's management of Coldfusion. Whether you agree with my concerns or not, it's important that everyone get a chance to voice their opinions on this. Here a the blog posts to look at... Adam's announcement http://www.adrocknaphobia.com/post.cfm/the-modern-age-of-coldfusion My reaction http://www.codfusion.com/blog/post.cfm/so-there-s-this-story-about-a-frog-in-boiling-water -there are comments that add additional problems to this move Brian Meloche's reaction http://www.brianmeloche.com/blog/index.cfm/2011/2/12/End-of-another-era John ma...@fusionlink.com twitter: john_mason_ ~| 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:342202 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re: Change in ColdFusion management
Got it, thanks everyone for the google cache link... must be a bad brain day monday for me ;) William -- William E. Seiter On Feb 14, 2011, cft...@fusionlink.com wrote: It's cached by Google.. http://webcache.googleusercontent.com/search?q=cache:3G9LdiSkodEJ:www.adrocknaphobia.com/post.cfm/the-modern-age-of-coldfusion+http://www.adrocknaphobia.com/post.cfm/the-modern-age-of-coldfusioncd=1hl=enct=clnkgl=usclient=safarisource=www.google.com - Original Message - From: William Seiter [mailto:will...@seiter.com] To: cf-talk@houseoffusion.com Sent: Mon, 14 Feb 2011 19:08:14 + (GMT) Subject: Re: Change in ColdFusion management Anyone have Adam's announcement? I keep trying to access it and get a blank page. Thanks, William -- William E. Seiter On Feb 14, 2011, cft...@fusionlink.com wrote: In case people don't know and many may not due to the way it was announced late last friday, there is a debate going on with the recent change in Adobe's management of Coldfusion. Whether you agree with my concerns or not, it's important that everyone get a chance to voice their opinions on this. Here a the blog posts to look at... Adam's announcement http://www.adrocknaphobia.com/post.cfm/the-modern-age-of-coldfusion My reaction http://www.codfusion.com/blog/post.cfm/so-there-s-this-story-about-a-frog-in-boiling-water -there are comments that add additional problems to this move Brian Meloche's reaction http://www.brianmeloche.com/blog/index.cfm/2011/2/12/End-of-another-era John ma...@fusionlink.com twitter: john_mason_ ~| 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:342208 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re: Re: Re: Change in ColdFusion management
Were you ever 'off' the list of skeptics? -- William E. Seiter On Feb 14, 2011, jqdur...@gmail.com wrote: I'll believe it [Adobe's renewed commitment] when I see it. And, apparently, that won't be a for a long time. For now, put me on the list of skeptics. On Feb 14, 2011 1:53pm, William Seiter will...@seiter.com wrote: Got it, thanks everyone for the google cache link... must be a bad brain day monday for me ;) William -- William E. Seiter On Feb 14, 2011, cft...@fusionlink.com wrote: It's cached by Google.. http://webcache.googleusercontent.com/search?q=cache:3G9LdiSkodEJ:www.adrocknaphobia.com/post.cfm/the-modern-age-of-coldfusion+http://www.adrocknaphobia.com/post.cfm/the-modern-age-of-coldfusioncd=1hl=enct=clnkgl=usclient=safarisource=www.google.com - Original Message - From: William Seiter [mailto:will...@seiter.com] To: cf-talk@houseoffusion.com Sent: Mon, 14 Feb 2011 19:08:14 + (GMT) Subject: Re: Change in ColdFusion management Anyone have Adam's announcement? I keep trying to access it and get a blank page. Thanks, William -- William E. Seiter On Feb 14, 2011, cft...@fusionlink.com wrote: In case people don't know and many may not due to the way it was announced late last friday, there is a debate going on with the recent change in Adobe's management of Coldfusion. Whether you agree with my concerns or not, it's important that everyone get a chance to voice their opinions on this. Here a the blog posts to look at... Adam's announcement http://www.adrocknaphobia.com/post.cfm/the-modern-age-of-coldfusion My reaction -there target=_blankhttp://www.codfusion.com/blog/post.cfm/so-there-s-this-story-about-a-frog-in-boiling-water -there are comments that add additional problems to this move Brian Meloche's reaction http://www.brianmeloche.com/blog/index.cfm/2011/2/12/End-of-another-era John ma...@fusionlink.com twitter: john_mason_ ~| 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:342219 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Multiple applications with a single codebase issues
I had a similar issue that came up a couple of years ago for me. As it turned out I had the name of the application the same across all of the sites, so the application variables weren't unique to each site. -- William E. Seiter On Feb 8, 2011, Pete Ruckelshaus pruckelsh...@gmail.com wrote: I'm having a bit of an issue here. Over time, I have developed a CF web-based content management system (hey, who hasn't?). The software is currently running a handful of sites, all on different web hosts. It works fine in this mode. Recently, I realized that I could get a VPS for less money than the several web hosting accounts I'm using; this would have the added benefit of allowing me to update the core software in one location rather than in several. I have it set up so that IIS sees the root directory of the CMS software as each web sites' root, and then I set up a virtual directory to the site-specific content for each domain. For instance, c:\inetpub\wwwroot\app\core is set as the root directory; in it, I have an application.cfc file that sets up variables, security, etc. For site-specific stuff in the application.cfc, I am including a file that sets the app name, etc. before the onApplicationStart() runs. I then have the site-specific stuff (templates, config files, etc.) in separate directory paths, each set up mapped to /site as virtual directories for their respective web sites. The problem I am having is that application.applicationname is being set to whatever site loads first; i.e., I have SiteA and SiteB set up in IIS, restart CF, and if I load SiteB first, then SiteA has SiteB's application.applicationname value. This is a problem. Has anyone here tried to do this and succeeded? Or do I need to rethink how I have this site architected? Thanks, Pete ~| 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:342022 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Coldfusion Hosting
Yeah, you're dreaming. But you can check out gearhost.com. I moved to them a couple years ago and have never had a problem creating robust OO based coldfusion 8 websites there. William -Original Message- From: Adam Bourg [mailto:adam.bo...@gmail.com] Sent: Friday, January 28, 2011 10:49 AM To: cf-talk Subject: Coldfusion Hosting Can anyone recommend a decent yet cheap web host for ColdFusion? Right now I'm hosting my site at DreamHost (Simple wordpress as CMS site). I'm looking for SQL PHP 5 and Coldfusion 8 support all under $6. Am I dreaming? ~| 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:341674 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: http://mail.seiter.com/webmail/driver?nimlet=showcanvas#Lions, Tigers and Images, Oh My!
http://www.williamoncoldfusion.com/index.php/knowledgebase/file-uploading -- William E. Seiter On Oct 12, 2010, Everett Alexander reac...@anizanmedia.com wrote: Hello, I have a an form that will be updating a database for creating webpages. That form will need to upload images (along with various other fields, text, etc.) to a server. So I want to point to a specific folder on the server to upload images, and then reference that location in the database. Currently, when I upload an image, I get this in the database field: /opt/jrun4/servers/DISCOVERY/SERVER-INF/temp/cfusion.war-tmp/neotmp2153518236327741178.tmp When it should be this: /images/news/volcanos.jpg Any tips or direction? Thanks in advance... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338094 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to point to a Directory?
AIR is not the only method, but you can't get it done with just html. You will need A java applet or flash or air or some other program that can talk to the system as well as your app. -- William Seiter On Oct 4, 2010, at 4:39 PM, Gonzo Rock gonzor...@gmail.com wrote: Well the purpose is to capture and store the Directory as part of a configuration routine. Then days in the future other users of the application will trigger it to process some datafiles... but coldfusion needs to know where those datafiles are located. The current user has no idea where they are stored... they just want the files in the directory processed. Currently during the configuration session we can capture it by making them point to a file in the directory and then stripping the actual file name from the network path they navigated down... however how to do this when there is NO file in the directory for them to use while configuring the Directory Location for future use... that is the problem... which Dave suggests can only be solved using AIR :-( On Mon, Oct 4, 2010 at 4:18 PM, Russ Michaels r...@michaels.me.uk wrote: also u do not need to remember the path as this is the default behaviour of windows. When you open a browse window it always takes you to the last location you used. On Tue, Oct 5, 2010 at 12:15 AM, Dave Watts dwa...@figleaf.com wrote: Using input type=file works great to let a user point to a file... but how do you let the user browse and point to a Directory? I am trying to figure out how to let a user browse to a particular directory location on their network and then capture that location for future use. In this instance the application will always look in this location for files that it needs to process for the user. There's nothing built into HTML to capture a directory path. Also, browsers won't let you store a directory path for later use, for security reasons - the user always has to choose the file directly. Adobe AIR is a nice alternative here. Downloadable applications can do all sorts of things that browsers won't allow. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337847 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re: sending a form through CF and catching the results
The page you are trying to hit with cfhttp is expecting a numeric value for 'di_20156'. try changing the value in your script from SPHL-School of Public Health to 20 William -- William E. Seiter On Aug 26, 2010, daniel kessler dani...@umd.edu wrote: Seems like the error isn't really giving much help. Can you get full debugging from that error on jobs.cfm? Can we see the code on and around line 346 of jobs.cfm? How would I get the full error? The code on and around 346 is the block of code that I posted last. cfhttp method=POST url=https://jobs.umd.edu/applicants/jsp/shared/search/SearchResults_css.jsp; columns=di_0_20156 name=blah port=443 cfhttpparam type=formfield name=di_20156 value=SPHL-School of Public Health / /cfhttp Line 346 is the: cfhttpparam type=formfield name=di_20156 value=SPHL-School of Public Health / though as pointed out earlier, the value should be 20 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336583 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
West Side Rentals
Hey, Does anyone know who is the developer or involved with IT at Westside Rentals in Los Angeles? Contact me offline. William [at] Seiter [dot] com Thanks, William ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Seriously PO'd - cfqueryparam and/or struct dereference flakes out
When CF throws an error on a stored proc, it will usually reference the last line of the stored proc, not necessarily which line has bad data. If I were you, I would dump the values that are being sent into the stored proc and review to see if any of it is null or blank (or string) going into any of the integer declared procparams. Hope this helps, William -- William E. Seiter On Jun 24, 2010, Marc Funaro subscripti...@advantex.net wrote: The function below was written literally MONTHS ago. Worked fine the whole time, even today... then suddenly it's throwing the error: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER. The error points to the line in the WHERE clause, referencing a.articleId. Next, I purposely set the output=true on this function, and did a cfdump of #a.articleId# -- it's definitely a valid integer. but it's now choking on it for some reason. as a test, i hard coded an article id into the where clause, removing the cfqueryparam. with a hard coded number, it chokes on the next cfqueryparam up. if i reference #a.articleId# directly (outside of cfqueryparam), I also get the same error. how can a.articleId suddenly become '' right after dumping it and successfully showing it to be an integer?? I've restarted both the cf server and the database server, wondering if there was some sort of strange hangup there... no joy. I'm losing my mind... help!! cffunction name=updateArticle returntype=void access=private output=true cfargument name=structArticle required=true type=Struct hint=A structure containing all fields of an article, and the values to be saved. cfset var a = arguments.structArticle cfset var qUpdateArticle = !--- uncommenting this line gives me a valid integer on screen --- !--- cfdump var=#a.articleId#cfabort --- cfquery name=qUpdateArticle datasource=#request.dsn# UPDATE Article SET categoryId = cfqueryparam value=#a.categoryId# cfsqltype=cf_sql_integer /, title = cfqueryparam value=#a.title# cfsqltype=cf_sql_varchar /, byLine = cfqueryparam value=#a.byLine# cfsqltype=cf_sql_varchar /, imageId = cfqueryparam value=#a.imageId# cfsqltype=cf_sql_integer /, imageCaption = cfqueryparam value=#a.imageCaption# cfsqltype=cf_sql_varchar /, abstract = cfqueryparam value=#a.abstract# cfsqltype=cf_sql_varchar /, body = cfqueryparam value=#a.body# cfsqltype=cf_sql_varchar /, isLead = cfqueryparam value=#a.isLead# cfsqltype=cf_sql_bit /, publishDateTime = cfqueryparam value=#a.publishDateTime# cfsqltype=cf_sql_timestamp / WHERE articleId = cfqueryparam value=#a.articleId# cfsqltype=cf_sql_integer / /cfquery /cffunction ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334821 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list of declared functions
this can be built rather simply. 1. add to your Application.cfc in the OnRequestStart function cfset request.loadedFunctions = ArrayNew(1) / 2. change all of your functions to read like this: cfif not ListFindNoCase(ArrayToList(request.loadedFunctions,'[name of the function]',',')) your function declaration cfset request.loadedFunctions = ArrayAppend(request.loadedFunctions, '[name of the function]') / /cfif this way you can call a function to your hearts content, but it will only load if it wasn't already loaded. hope this helps, William -- William E. Seiter On Jun 18, 2010, daniel kessler dani...@umd.edu wrote: I am receiving the error Routines cannot be declared more than once, which is true. This function can be declared in multiple places so it's sort of difficult to track. Is there a way I can test and check whether a function is already declared (please say yes, it's easy? Can I query for a list of declared functions? Also, this is on a shared hosting server, if that makes any difference. thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334660 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How to loop over a dataset twice.
We will need to see more of the code. If the second loop doesn't work then there is probably something in the code that is stopping your action. Once the query has been created, it will persist until it is erased by the code. -Original Message- From: Dave Hatz daveh...@hatzventures.org Sent: Tuesday, June 08, 2010 5:45 PM To: cf-talk cf-talk@houseoffusion.com Subject: How to loop over a dataset twice. I am trying to loop over a dataset twice. I am trying using CFLOOP but the 2nd CFLOOP will not process. cfquery dataset=mydsn name=dset select first,last from name /cfquery //loop through DataSet 1st time cfloop query=dset /cfloop //Now I want to loop through the DataSet a 2nd time cfloop query=dset . /cfloop How do I get the 2nd cfloop to loop over the DataSet without calling the query again? Thanks, Dave ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334398 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Redirect question
The easiest way I can think of would be to change the page name from: http://www.domain.com/acme.cfm to: http://www.domain.com/acme/index.cfm Your 'http://www.domain.com/acme' call would automatically call the index.cfm page, and it will be easier for future maintenance needs. William -- William E. Seiter On Jun 2, 2010, Donnie Carvajal donnie.carva...@transformyx.com wrote: I have a client that would like to send out URLs without .cfm. For example, there is a page in the website called acme.cfm. To access the page, a visitor would go to http://www.domain.com/acme.cfm. The client would like to also access acme.cfm by the following URL: http://www.domain.com/acme. We are on Windows and IIS 6. Has anybody ever done anything like this before? It seems that there would need to be an ISAPI filter or maybe have a custom error redirect or some setting change in IIS. I can write Coldfusion code for this, but that means I would have to create folder for every page and drop this CF code in the folder as the default and redirect to the acme.cfm page. I would like to avoid creating thousands of folders, just for this redirect. All help is appreciated. Thanks, Donnie ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334237 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Comma delimited list
Break out the comma dilimited list into a cross ref table then you query the tables with an inner join to get the features. -Original Message- From: Bill Hartley b...@whdservices.com Sent: Friday, May 28, 2010 7:37 PM To: cf-talk cf-talk@houseoffusion.com Subject: Comma delimited list I am trying to display feature codes from a comma delimited list inside a database. Here is my setup: Table: Listings has a column called FEATURE_CODES and example of the data in this column is B01,E09,E20,G12,J07 Then I have another table inside the same database called FeatureCodes the data inside this table is arranged FEATURE_CODE FEATURE_DESCRIPTION B01 Sold As Is E09 Frame and Stucco and so on I need to display the feature description from the FeatureCodes table on the display page by reading the feature_codes from the listing table Any Suggestions?? Please!! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to make a select option tag selected in CF?
on page load, to default to the previously saved data... option value=nothing cfif form.choice eq 'nothing'selected=selected/cfifChoose From Below/option and input type=radio name=pagetype value=notapplicable cfif form.pagetype eq 'notapplicable'checked=checked/cfif /Not Applicable if, however, you are having a problem where this isn't working for you, then you probably are experiencing 'persistent form choices'. This would not be a problem with the code, but with the local browser. best way to reload the defaults would be to hold down the 'ctrl' button and press the 'f5' button. This will do a 'hard refresh' of the browser, hopefully erasing any persisting data selections. William -- William E. Seiter On May 27, 2010, Phillip Perry philjpe...@gmail.com wrote: Hi, I am making a form and I would like to have the user review the form answers before it gets sent to the processing template. I know how to populate all the other things but the drop down list and the radio buttons are confusing me. It's been a while since I used CF for this so I forget. Below is the select and radio button form fields: select name=choice class=baco option value=nothing selected=selectedChoose From Below/option option value=clothesClothing Store/option option value=sportsSporting Goods Store/option option value=hobbiesHobby Shop/option option value=computersComputer Related Sales/option option value=medicalMedical Profession/option option value=foodsGrocery Store/option option value=publicationPrinted Publications/option option value=accountingAccounting Firm/option option value=utilityUtilities Company/option option value=othersOther/option /select input type=radio name=pagetype value=personal /Personal input type=radio name=pagetype value=business /Business input type=radio name=pagetype value=notapplicable checked=checked /Not Applicable How do I make these 2 selected/checked when the user submits the form? Thanks for the help. Phil ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334038 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: FIXED: cflock and cfloop question
Please be sure to post the fix that was used so that persons using the archive in the future will be able to troubleshoot their stuff as well. William -- William E. Seiter On May 26, 2010, cfcom cf...@aceligent.com wrote: ISSUE IS FIXED - THANKS EVERYONE! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334024 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Need CF help- is anyone available
It sounds like the images were moved to their new homes, but the site code might still be pointing to the old location. Or the old location isn't accessible to the new site. If the code is pointing to an image that does exist, take a look at the permissions on the directory to verify that your site has access to files there. Hope this helps, William -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Tuesday, May 25, 2010 2:28 PM To: cf-talk Subject: RE: Need CF help- is anyone available We have a legacy site that was originally written without error handling. Yesterday the old programmer ran a script to clear out the images folder that had grown to 20 gigs. He set up a new image folder but all the images stopped showing up in queries. We've spent all day chasing down globals but it keeps throwing errors and the pictures aren't showing up. Heres notes from what the old programmer did: wrote a script to break up the directory in to smaller directories. The created 900 subdirectories inside a new folder called images_new The image 90031_7.jpg will be in the folder images_houses_new\900\ because it begins with 900. then put a url redirect on the original directory to redirect any 404 errors to a script which will try to find the correct image. also threw the file Directorybreaker.exe into the root dir of the e drive. running it with the old dir as param one and the new drive as param two will break up any new images. only updated the listings pages. His note goes on to something about creating an object called Image.cfc and then extend that to HouseImages.cfc With the exception of the images-folder too big before he touched the code we had most things functioning and now they are not. - any help would be greatly appreciated. -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: 2010-05-25 16:50 To: cf-talk Subject: Re: Need CF help- is anyone available The best solution is to ask directly here. It allows for allot of people to help. So what's the issue? On Tue, May 25, 2010 at 1:47 PM, cfcom cf...@aceligent.com wrote: Having serious problem with a piece of code Is there anyone who could take a look Been racking my head on this all day Please contact off list And thank you in advane ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333992 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: idea paint
I am not certain the reason for the link, but that website is one of the worst i've seen recently when viewed from my smartphone browser. william -Original Message- From: Brian Thornton vegasthorn...@gmail.com Sent: Friday, May 21, 2010 8:27 PM To: cf-talk cf-talk@houseoffusion.com Subject: idea paint http://www.ideapaint.com/work/installation/ -- Brian Thornton (303) 997-1777 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 Hosting
GearHost has all of their servers on CF9. I just spoke to Adam Patton in sales who confirmed that the servers are updated, but the website hasn't been yet. http://www.gearhost.com/hosting/shared/coldfusion/ William -- William E. Seiter On May 20, 2010, Kelly Matthews ke...@webdiva.org wrote: Anyone know any good, reasonable CF 9 hosting companies w/ mysql. Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re: CF 9 Hosting
I wouldn't use them anymore at all, if they had told one of my clients that. William -- William E. Seiter On May 20, 2010, Dawn Sekel dawnt...@yahoo.com wrote: I have used them for years too -- but I have recently had a really bad experience with them. I signed one of my new customers up under a shared hosting account -- just a small application. The server he was on kept crashing. Their technical support told him that the problem was Coldfusion and that he needed to switch to another technology. They said Coldfusion is going out of business and know one uses it any more. Anyway -- I don't user them any more for my smaller customers that can't afford a dedicated server. I'll +1 for CrystalTech. I've been using them for years. Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com Alan Rother wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333870 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re: Re: Adobe ColdFusion Anthology released
good to know, Thanks! -- William E. Seiter On May 20, 2010, Sean Corfield seancorfi...@gmail.com wrote: On Mon, May 17, 2010 at 1:25 PM, William Seiter will...@seiter.com wrote: I bought mine through amazon a couple weeks ago. Can you let us know what was wrong with the original so that we can verify we didn't receive a corrupted copy? Chapter 7 is missing (and the 'Part 2' intro page appears between chapters 6 8 instead of 5 6 and the 'Part 3' intro page is missing - it should be between 7 8). Apress are reprinting this week or next week and will be shipping new copies shortly after. They seem to be making quite an effort to recall all the faulty copies. If you get a misprinted version, go back to the seller and ask them to replace it with a reprinted copy. If that fails, contact Apress directly. -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwoo ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re: Adobe ColdFusion Anthology released
I bought mine through amazon a couple weeks ago. Can you let us know what was wrong with the original so that we can verify we didn't receive a corrupted copy? Thanks, William -- William E. Seiter On May 17, 2010, Reed Powell r...@powellgenealogy.com wrote: Mike: 2 copies just arrived to give out at my next UG meeting - from leafing through it looks great! I got an email a few minutes ago from the publisher telling me that 2 reprinted copies are on their way because of some printing error in the first ones. Any concrete info available on just what was changed? Is it so bad I shouldn't give away those copies? thanks, -reed ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333766 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone done this before???
Having very little knowledge of MS Access for the web, can you have the report output to a static table, where the web page reads the data from the table, and the report runs hourly, or more/less often? Or, can you port the report functionality to a 'view' and have the web page read its data from the view? William -- William E. Seiter On May 7, 2010, Stephen Hoskins shosk...@andonia.com wrote: I have a pretty complex MS Access report that takes in an ID and outputs a report, how the heck can I get this to run online??? Im poking through cfexecute but no luck yet. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333487 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re: Anyone done this before???
I am confused as to what language they changed on you? the database? the report scripting language? the web server language? as far as pass the id, it will all depend on what your system actually looks like and what you are trying to accomplish. I would suggest that you give us a longer, more detailed, description of what you have there, and what you want to do with it, or you hire a professional CF consultant to take a look at what you have and devise a blueprint on how to get to where you want to go. Thanks, William -- William E. Seiter On May 7, 2010, Stephen Hoskins shosk...@andonia.com wrote: There are about 5,000 reports with conditional statements in VB script. I started creating pdfs and was going to use cfdirectory to parse through them. After spending a day creating 1,000 of them manually, they changed the language on me. Im suprised there isnt a way to pass the id and pull up each report in CF. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333496 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: query for experts?
I think I am a bit confused as to what your scenario is... Is 5 the minimum a customer can purchase? If they order 5 or more, is $12 their price, or if they order 1-5 it is $12? If the pricing is for 1-5 = $12 each, then I think you can adjust your table a little to get the proper results. Add a row, 1, 12.00 Change 5, 12 to 6, 11.55 And so on. Then you can use your example query to pull the correct data. Also, the 'price' should be a number (without the $ sign). It will make it easier to use the number for multiplying with later. William -- William E. Seiter -Original Message- From: Mike Little [mailto:m...@nzsolutions.co.nz] Sent: Wednesday, May 05, 2010 5:12 PM To: cf-talk Subject: query for experts? hey guys, hopefully an easy one... tblPricing -- min_qty (INT) price a product has the following rows... 5, $12.00 10, $11.55 the customer adds a quantity of 4 to their cart. how do i establish that the price should be $12.00? existing query would be... SELECT price FROM tblPricing WHERE product_min = cart.qty ORDER BY product_min DESC LIMIT 1; doesn't work in this case. mike ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:75 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: query for experts?
Is this just a list of price breaks where the single item price is in a different table? -- William E. Seiter -Original Message- From: Mike Little [mailto:m...@nzsolutions.co.nz] Sent: Wednesday, May 05, 2010 8:49 PM To: cf-talk Subject: Re: query for experts? william that would be ideal. my problem is that the client inputs their own price breaks. most of their products require a minimum greater than 1. azadi, i have done the following and it still outputs some odd results (using a cart qty of 4 to test)... SELECT FLOOR(product_price * CEILING(4 / product_min)) AS price FROM tblPricing WHERE 1=1 (i am using mySQL by the way) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:86 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfqueryparam question (null attribute)
You can do nested iif, but not a full cfif/cfelseif/cfelse
-Original Message-
From: Matthew Lowrey rid...@gmail.com
Sent: Tuesday, May 04, 2010 12:26 PM
To: cf-talk cf-talk@houseoffusion.com
Subject: Re: cfqueryparam question (null attribute)
Sean, I'm pretty sure I already know this answer, but now that you've brought
this new way of thinking to my attention. I'm going to place my cards on the
table here and ask the million dollar question. Is it possible to have a
cfelseif in this param? :-D I know... I have a pair of 4's... not likely to
beat your cards haha
Matt...
YA SEAN WINS THE PRIZE!! Thank you Mr.
Corfield. This worked beautifully and better yet I didn't have to set
anything or cfif anything, just one tag with everything all inside of
it. Thanks a million x yourVal
Matt...
Since you're on CF9:
cfqueryparam value=#isDefined('form.myVar')?form.myVar:''#
null=#!isDefined('form.myVar')# /
The (new in CF9) ?: operator only evaluates the true-expr if the
condition is true.
On Mon, May 3, 2010 at 8:12 AM, Matthew Lowrey rid...@gmail.com
wrote:
This is getting to be quite an interesting challenge. All the
examples I've seen logically make sense but none of them have worked
so far. I will say I'm learning quite a bit from everyone's
knowledge/wisdom. I will try and list here all the different
methods
I've tried out and have failed. First, the method I've used (and
still using):
cfif isDefined(form.myVal)cfqueryparam
cfsqltype=cf_sql_varchar value=#form.myVal#
maxlength=50cfelsecfqueryparam
null=yes/c
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:29
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfform won't submit
Without seeing your full application, my assumption would be that the code that is running (after the username unique validation) is not returning to the browser any data. I would take a look at any querries you are running and possibly add a timeout to them so you can see if they are running, unusually long. William -- William E. Seiter On May 4, 2010, Steve Logan st...@sagescholars.com wrote: I must be missing something obvious here. I have a simple user enrollment form that submits fine on the first submit, but can't seem to be submitted a 2nd time. There is no submit once validation. For example, if I test it with a username that I know is in use, it quickly submits and generates and error message stating that the username is in use. If I select a username that's good and resubmit, it just hangs. In the browser status bar it simple sits at waiting for test.server.com until it times out with a connection reset error. I installed a Firefox plugin to watch the HTTP traffic and it seems to confirm that there's no response from the server on the 2nd submit. Yet if I open up countless new browsers and tabs, the server is working fine. Any ideas?? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:37 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re: Using two submit buttons to control form action
When using a regular HTML form, we rely on the browser to act like a regular browser. Only the 'activated' elements of a form are sent. Form elements with the same name and are 'activated' will be received by the server as a comma-delimited list. In a regular form, only the button that is pressed is 'activated' so your scenario works correctly. Now enter into the world of cfwindow/cfform. These two tag-groups are extremely powerful, but do cause some changes in the way the form is processed. As you mentioned, when you changed your cfform to a regular form, it worked correctly, but you lost the 'keep in the cfwindow' functionality. Cfform and cfwindow appears to work together to submit forms via AJAX. The script probably compiles the form in the usual manner, any field with an active value are sent to the server. The ajax probably identifies the button that was pressed, by its name, and then gathers the values for that 'named field' In this case, you can achieve your needs in 1 of 2 ways (probably a lot more, but working on little sleep here). 1. make your buttons unique names, and parse on the server side based on the button that was pressed. 2. create an additional hidden field, when one of the buttons is pressed, pass the value of the pressed button to the hidden field using javascript, and have your server check the value of the hidden field, instead of the button. Hope this helps, William -- William E. Seiter On Apr 29, 2010, John Pullam jpul...@mcleansystems.com wrote: Thanx for all the feedback. I'm about 95% sure that I've done all this before and made it work. And the examples given have been tried too. There must be something different in my case. This simple use of 2 buttons on a page worked for me. But when I put it back into the live case it fails, so I think I am missing something there. I have trimmed out irrelevant code in an attempt to get this down to a basic test but still it fails showing me a string that has both button names (it didn't do this when I started with a single page). My case includes a cfwindow, so there are 2 bits of code below ... the page and the window. The calling page: ... ~| 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:333244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Looking in LA?
A friend and I were at lunch the other day and he was telling me how hard it was for his company to find any CF developers in Los Angeles. I told him that there were plenty if you know where to look. I would like to take a very rudimentary poll of the members of this list who reside in, are moving to, or work in the Los Angeles, CA area. Please let me know what your current situation is: - happily employed - employed and looking - not employed and looking - not employed and not looking I will compile the responses and post to the list. Post your answer here or email me at william [at] softexconsulting [dot] com -- William E. Seiter ~| 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-jobs-talk/message.cfm/messageid:4312 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
Re: FileExists using variable - not working
try
cfif FileExists('#variables.ImageSource#')
or
cfif FileExists(variables.ImageSource)
--
William E. Seiter
On Apr 8, 2010, Fred Grainger i...@fredgrainger.com wrote:
Ok - I'm about to pull my hair out.
I am using fileexists() function to determine whether a image file exists on
the server. When I type in the path it works fine, but when I use a variable it
always returns false.
My code is like this:
cfset variables.ImageSource = C:\somedirectoy\somefile.txt
cfif FileExists(#variables.ImageSource#)
do something
cfelse
do something else
/cfif
The variable works everywhere else in the code. I am outputting it to the
browser and have double triple checked to make sure the variable value is
correct.
I've been working on this a day and a half and cannot get it to work.
HELP!
~|
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:332774
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re: FileExists using variable - not working
try: cfset variables.blah = '[filelocation filename you know exists]' cfif fileExists(variables.blah) Success!! cfelse Failed!! /cfif cfdump var=#variables.blah# -- William E. Seiter On Apr 8, 2010, Fred Grainger i...@fredgrainger.com wrote: Took the hash marks out. Put quotes, trimmed the variable, checked the length of the file name to make sure there weren't any control characters or anything. My code is very straight forward. A day and a half later, still no dice. This is the first time I've used this function. We just upgraded to CF9 a few weeks ago, but it is up to date. This makes no sense whatsoever. When I type the file path into the FileExists function it works fine. Will not work with a variable. Period. ~| 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:332787 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: RE: storing a cfinput inside of a variable
Hey Steve, Can you tell us what the bigger picture is, what is it that you are trying to accomplish by saving the cfinput in a variable? cfinput is rendered by coldfusion for the browser in respect to the cfform tags that are around it. Are you trying to create a reuseable form field where you can just paste the results into your form by calling the variable, for any given form you may create? There are different methods for handling different scenarios. You could create a structure that you set at the top of the page and then copy/paste the cfinput that uses that structure for its settings. You could create a function that creates the cfinput field, and then call that function everywhere that you want that cfinput to show up. Let us know where you want to go, and we can help you get there. :) -- William E. Seiter On Apr 8, 2010, Andy Matthews li...@commadelimited.com wrote: The only option would be to evaluate the variable, and even that might not work: cfoutput #Evaluate(config.formFieldA)# /cfoutput -Original Message- From: Steve Logan [mailto:st...@sagescholars.com] Sent: Thursday, April 08, 2010 1:37 PM To: cf-talk Subject: storing a cfinput inside of a variable Is there anyway to use cfset or cfsavecontent to store a complete cfinput tag? i.e. cfset config.formFieldA = cfinput type=text name=fieldname value=// If I do a view source, I see it the code on my output page, but it won't render at all in the browser. If I try cfsavecontent it errors because the cfinput isn't in a cfform (since the cfinput is in a CFC being called by the form page). The reason for this is that this one form field could have different max lengths, validations, validation patterns, and messages based on a variety of factors. If I can move the input into a CFC that returns all sorts of other partner specific info, it keeps me to having just one space to enter config data. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: populate cf variable using javascript array
Hey Charlie, Once the 'cfinput' is viewed in the browser, it is translated into a regular input statement (view source to see) Javascript only runs after the page is translated to the regular input statement, so you should be able to interact with that input with javascript directly (no need to translate the javascript array into a coldfusion array) If you give more details of what you want to do, we can probably help. William -- William E. Seiter On Mar 11, 2010, Charles Heizer heiz...@llnl.gov wrote: Hello, I would like to know if it's possible to set a coldfusion variable from a javascript array? If so how? What I really want to do is populate a cfinput with the values from the javascript array. Thanks, Charlie ~| 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:331617 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jquery ajax tabs cfinclude
if you show us the code that is breaking, we might be able to assist you better. -- William E. Seiter On Feb 17, 2010, Sachin Mohan send.sac...@yahoo.com wrote: Hi, Just wondering if someone has come across such an issue. I am loading in coldfusion content into jquery tabs using ajax. i.e. a href=dispAppointments.cfm. If I have a cfinclude inside dispAppointments.cfm, I get a '500 error - Could not find the included template' It works fine if there is no cfinclude inside dispAppointments.cfm. Thanks in advance! Sachin ~| 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:330828 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 Review?
without seeing the context of the code, it appears to be holding values that may be used for 'tracking' the user on the site. What is the error that you are receiving from it? -- William E. Seiter On Feb 10, 2010, Glyn Jackson glyn.jack...@newebia.co.uk wrote: I have been asked to looked as some code within this page is below. I have no idea what its doing however I was told its needed but keeps giving me errors. is your opinion why does this exists? cfparam name=referer_itemID default=0 cfparam name=referer_popupID default=0 cfif len(cgi.HTTP_REFERER) !--- Item ID --- cfset begin_itemID = find(item_id:,cgi.HTTP_REFERER) + 8 / cfif begin_itemID cfset end_itemID = find(/,cgi.HTTP_REFERER,begin_itemID) / cfset referer_itemID = mid(cgi.HTTP_REFERER,begin_itemID,end_itemID-begin_itemID) / /cfif !--- MP ID --- cfset begin_mpID = find(mp_id:,cgi.HTTP_REFERER) + 6 / cfif begin_mpID cfset end_mpID = find(/,cgi.HTTP_REFERER,begin_mpID) / cfset referer_popupID = mid(cgi.HTTP_REFERER,begin_mpID,end_mpID-begin_mpID) / /cfif cfif not isNumeric(referer_itemID) cfset referer_itemID = 0 / /cfif cfif not isNumeric(referer_popupID) cfset referer_popupID = 0 / /cfif cfparam name=livewireLaunch default=0 cfif livewireLaunch cfset referer_itemID = -1 / /cfif /cfif ~| 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:330535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: setting cf var with javascript
There is a misunderstanding about how the coldfusion works with JavaScript, I think. On the server, the coldfusion is translated to pure HTML and Javascript (or any language that is 'client side'). Once the page is delivered to the browser, there is no coldfusion left on the page. This means that when javascript runs on the client, there is no way to interact with coldfusion, without sending information back to the server first. if you let us know what you are trying to accomplish, maybe we can suggest some alternative methods? Thanks, William -- William E. Seiter On Feb 5, 2010, Keith McGee kpmc...@frontiernet.net wrote: How do you set a CF variable with a java script variable. I have a script that adds three weekdays to the current day, document.write(mydate) and I want to set this to a CF variable cfset mydate = document.write(mydate) any suggestions Keith ~| 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:330433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: IE8 is killing my website
I have heard that if you replicate this tag as a cfheader tag, it works. (although I don't know why) -Original Message- From: Marc Funaro subscripti...@advantex.net Sent: Tuesday, February 02, 2010 11:21 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: IE8 is killing my website Try setting this Meta tag in you document head: meta http-equiv=X-UA-Compatible content=IE=EmulateIE7 That may solve your issue. Robert B. Harrison This tag's been in place for a couple weeks; no effect. ~| 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:330363 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why i fear ColdFusion is on its last legs
I can't speak to your experience with [A] or [C], but I will try to do a parallel to [B]. In Los Angeles, we have had what amounts to a 'dead' CF user group. I think 2 meetings in the last year since it was resurrected, after being shelved for many many years. However, the job market for CF developers in the Los Angeles area has never been better. We do have a 'general' Adobe users group that meets, but they don't really care much for CF programmers, and focus mainly on the products you had mentioned. If I went to one of those meetings as a litmus test for CF strength in the area, I would write LA off. But because I work in the market, I know better. If you are having issues finding projects that are starting to use CF, keep in mind that most new companies trend toward the free server-side programming languages simply because it's free. In contract work, I have taken a few of the contracts and changed their minds about CF by citing and proving some of the basic tenets of CF development. Fast to market, advanced developers tend to be actually advanced (not 'I worked with PHP for a year, I must be a 'senior'), etc. If I were you, instead of looking for 'jobs' that are using CF, try looking for 'startups' that are looking for a solution, and then sell them on you and CF. Just my 2 deenah, William -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Wednesday, January 20, 2010 9:52 PM To: cf-talk Subject: Why i fear ColdFusion is on its last legs I know that's a 'Chicken Little kind of subject line. I hope my impressions are wrong. Might be - i have been wrong before. I remember i was wrong once when i thought i was incorrect, but i wasnt. Anyway, these are the reasons i think the trends tell me ColdFusion is either a dead duck of soon to be a dead duck at least in Sydney anyway. I dont know about other places. ... [A] there is almost no new development going on in ColdFusionIn the last 12 months there has been just a handful of coldfusion jobs advertised. And most of those have been advertised by time-wasters who didnt end up appointing anyone. I'm sorry Mike, they've put that project on hold for now ... yada yada yada (or so they said maybe they were just too gutless to tell me i didnt get the assignment) In the last 12 months i have had NOT ONE assignment as a result of any advertisements for CF developers. If I hadnt dug up business on my own I'd have starved. Contrast this with a few years ago when freelancers like me had jobs lined up one behind the other. Maybe its just me, maybe everyone else has lots of jobs lined up. But somehow i doubt it. [B] There is next-to no apparent activity in the Usergroups on coldfusion, at least as far as I've seen. Everyone's fussing about Flex and Flash and Railo and Ruby on Rails and no one's talking about ColdFusion.I'd have made the 4 hour trek into the user group meeting if there'd been anything to do with coldfusion on. Apparently developers think there is nothing to talk about with ColdFusion. How newer developers are getting on learning the product I have no idea. [C] Adobe dont seem to be doing anything to promote ColdFusion here. I might be wrong on that, and its just that they dont tell us what they're doing, but I havent seen any evidence that they're putting much effort into marketing ColdFusion. I dont consider sending speakers to a COLDFUSION conference like WebDU or CfObjective to be promoting new ColdFusion installations because they're preaching to the choir there. Those folks are already sold on CF. Yes it's important to keep those lines open with the developer community but I dont see much use for gaining new users that way. ( I said something similar a few years ago, and Mark Blair got highly indignant about it - called me and told me all the things he was doing to promote ColdFusion. But after that, nothing) I would like to know that Adobe care enough about their server product to put some money behind it and promote it a bit here.It would make me feel more comfortable about building my business around it. -- Cheers Mike Kear ~| 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:329884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: line-through in select tag
In this page ' http://htmlhelp.com/reference/css/text/text-decoration.html', this code is used: span style=text-decoration: line-throughline-through/span I am able to view the desired effect using IE8 and FF 3.5.6 I cannot test this on IE7 and earlier at the moment, however. William -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Monday, January 04, 2010 2:47 PM To: cf-talk Subject: Re: line-through in select tag This worked on FF but not IE 7 (got figure). select option style=text-decoration:line-through;span style=text-decoration:line-through;#dollarFormat(productData.Price)#/spa n/option /select On Mon, Jan 4, 2010 at 3:18 PM, Chad Gray cg...@careyweb.com wrote: Anyone know of a way to get a CSS line-through in an HTML select tag? I tried this but it does not work. select optionspan style=text-decoration:line-through;#dollarFormat(productData.Price)#/spa n/option /select ~| 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:329402 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: adding ip address to email body
Alex, to make your code modular, you can create a custom function that wraps around the cfmail tag and adds all of your intended updates. Then you would call the new function instead of cfmail, directly. This will allow easy server migrations withot 'hacking' cf settings. -Original Message- From: Alex DeMarco alex.dema...@suny.edu Sent: Wednesday, December 09, 2009 11:00 AM To: cf-talk cf-talk@houseoffusion.com Subject: adding ip address to email body Is there any way to get the cfmail tag to automatically include the submittors IP address? I realize if can be done programaticaly within the cfmail tag, but was looking for server based solution. Can the tag be hacked to include the ipaddress? This would be for CFMX 8 and 9. - Alex ~| 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:329029 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Possible thread issue?
Last_insert_id does just that, gets the last inserted id. No matter who entered it. This means that under intense traffic, that select may not return the id associated with that transactions action. You should find the mysql equivalent to ScopeIdentity() Or if you are using a newer version of cf, the generatedkeys. -Original Message- From: Andre Kapp kap...@gmail.com Sent: Monday, December 07, 2009 11:22 AM To: cf-talk cf-talk@houseoffusion.com Subject: Possible thread issue? I'v now come across a code problem that I simply cannot understand what is happending here. The code is part of a cfc module that is behind a web-service. This is not inside a loop - just a normal cfc with a function that enter, process and returns data... The problem here is the transID. When you start putting a bit of load on this code, the transID gets mangled/confused/ When looking at the first cflog here, the trans id is the correct value is an thedatabase table. However, after the values are assigned to stTrans, the trans id is different! It is that of another tx that happend later on... Nowere is the transID updated in the code between the two cflog's. The value in the cflog is correct, as it is this value that I receive on the other side of the WebService module Here is the logfile output Look for card no 00213 Information,jrpp-5,12/07/09,20:11:27,GCCSVPWS,Process tx for xxx00213 with tx id 163537 and Thread.txid is 163537 Information,jrpp-0,12/07/09,20:11:27,GCCSVPWS, Process tx (after transaction) for x000346 with tx id 163537 and Thread.txid is 163537 Information,jrpp-4,12/07/09,20:11:27,GCCSVPWS, Process tx (after transaction) for 38304 with tx id 163537 and Thread.txid is 163537 Information,jrpp-7,12/07/09,20:11:27,GCCSVPWS,Process tx for 254 Information,jrpp-9,12/07/09,20:11:27,GCCSVPWS,Process tx for xxx0270 Information,jrpp-16,12/07/09,20:11:27,GCCSVPWS, Process tx (after transaction) for xx005097 with tx id 163537 and Thread.txid is 163537 Information,jrpp-18,12/07/09,20:11:27,GCCSVPWS, Process tx (after transaction) for xx00239 with tx id 163537 and Thread.txid is 163537 Information,jrpp-19,12/07/09,20:11:27,GCCSVPWS, Process tx (after transaction) for xx00304 with tx id 163537 and Thread.txid is 163537 Information,jrpp-8,12/07/09,20:11:27,GCCSVPWS,Process tx for x12 with tx id 163538 and Thread.txid is 163538 Information,jrpp-9,12/07/09,20:11:27,GCCSVPWS,Process tx for x270 with tx id 163539 and Thread.txid is 163539 Information,jrpp-3,12/07/09,20:11:27,GCCSVPWS, Process tx (after transaction) for 0288 with tx id 163539 and Thread.txid is 163539 Information,jrpp-7,12/07/09,20:11:27,GCCSVPWS,Process tx for xxx254 with tx id 163540 and Thread.txid is 163540 Information,jrpp-5,12/07/09,20:11:27,GCCSVPWS, Process tx (after transaction) for xx0213 with tx id 163540 and Thread.txid is 163540 I found a problem when I did code optimizationon the other side of the webservice. First thought it was the web service, but trace it right down to this bit of code on the one server. This is happening on my Mac's VM's running CentOS 5.2 and Coldfusion 8 on top of that. Coldfusion details: Server Product ColdFusion Version 8,0,1,195765 Operating SystemUNIX OS Version 2.6.18-128.2.1.el5 JVM Details Java Version1.6.0_04 Database is MySQL version 5.0 Any any any ideas will be appreciated! snipped SELECT last_insert_id() AS transid; /cfquery cfset theTransID = trans_insert.transid cfset Thread.txid = trans_insert.transid cflog file=transdao_cfc text=Process tx for #cardnumber# with tx id #theTransID# and Thread.txid is #Thread.txid# type=information !--- Update acct balance on gateway --- cfquery datasource=#variables.dsn# UPDATE acct_balances SET acct_balance = acct_balance + #arguments.amount#, acct_balance_available = acct_balance_available + #arguments.amount# WHERE acct_id = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#arguments.acctid# /cfquery /cftransaction !--- CHECK FOR NEG to POS cftry cfif theCurrentActualBalance LT 0 AND theNewActualBalance GTE 0 cfquery datasource=#variables.dsn# UPDATE fees_collection SET settled = cfqueryparam cfsqltype=CF_SQL_INTEGER value=1,
Re: Scheduled Tasks
sounds like a great reason to follow his advice of creating a log file for the http responses. If its not recreatable, yet you know it happens. -- William E. Seiter Sep 28, 2009 03:53:19 PM, cf-talk@houseoffusion.com wrote: === Right...but the URL's in question never produce 401 or anything like that when I call them manually... On Mon, Sep 28, 2009 at 4:51 PM, Ian Skinner wrote: Do you have the scheduled task configured to log the results it gets when it makes the HTTP request? I find these can be very helpful when the request generates unexpected results such as a 401 access denied error that to a programmer is a failed task run, but to the ColdFusion server is a success. It made an HTTP request it got an HTTP response, it is happy. ~| 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:326721 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 error
1. The scope is arguments, note the s
2. If the query returns a recordcount of 0, what does the function return?
-Original Message-
From: ch g chr_...@yahoo.com
Sent: Wednesday, August 05, 2009 10:40 AM
To: cf-talk cf-talk@houseoffusion.com
Subject: Re: Web service error
After i changed the file name it's working, so i developed another service to
verify the information aganist my database. Now i am receiving this error.
Cannot perform web service invocation testUser.
The fault returned when invoking the web service operation is:
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.runtime.UndefinedElementException : Element FIRSTNAME is
undefined in ARGUMENT.]
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.runtime.UndefinedElementException : Element FIRSTNAME is undefined
in ARGUMENT.]
at
coldfusion.xml.rpc.CFComponentSkeleton.__createCFCInvocationException(CFComponentSkeleton.java:723)
at
coldfusion.xml.rpc.CFComponentSkeleton.__invoke(CFComponentSkeleton.java:670)
at serviceTest.testUser(C:\Inetpub\wwwroot\devsite\serviceTest.cfc)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
... ''
And here is my function
cffunction name=testUser access=remote returntype=array output=no
cfargument name=FirstName type=string required=yes
cfargument name=LastName type=string required=yes
cfquery name=getInfo datasource=#data_source#
SELECT *
FROM...
/cfquery
cfif getInfo.recordcount GTE 1
cfset resarry = ArrayNew(1)
cfset i = 1
cfoutput query=getInfo
cfset resary[i] = getInfo.OrderNo
cfset i = i + 1
/cfoutput
/cfif
cfreturn resary
/cffunction
What's wrong with the above function?
Thank you so much for all your time and suggestions.
A quick test on my own server shows that your function works fine.
cfset x =
createobject(webservice,http://www.ecodes.biz/UserVerif.cfc?wsdl;).echoSt
ring(hello World)/
cfoutput#x#/cfoutput
I suspect you have compiled the WSDL and the stub is being cached. You need
to refresh the cache... But as a quick fix just rename your file to
UserVerify.cfc or something and try again :)
-mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
I included that also
cffunction name=echoString returnType=string output=no
access=remote
cfargument name=input type=string required=yes
cfreturn #arguments.input#
/cffunction
Still receving the same error message
Web service operation echoString with parameters {input={hello}} cannot
be found.
Thank you.
~|
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:325230
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 METADATA
I guess keeping track of the field types at the time the form is created is better than what I'm doing now. My field names are coded, so I loop through FORM.fieldNames looking for a keyword which triggers the correct type of validation. I could save the field name and field type in a session variable, then I wouldn't have to worry about the type being altered. ~| 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:323420 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 METADATA
Since the form submit won't inherently send the 'type' of the field that was sent, you could use a method of naming your fields according to the type of form field that was used. eg. select name=sel_stateoption... or input type=text name=txt_Name_First or textarea name=tarea_comments Just a thought. William Does anyone know if there is a way to get metadata about form fields in a cfform? I want to be able to identify which fields are text fields when I pass the FORM struct into a cfc. 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:323422 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 METADATA
I guess keeping track of the field types at the time the form is created is better than what I'm doing now. My field names are coded, so I loop through FORM.fieldNames looking for a keyword which triggers the correct type of validation. I could save the field name and field type in a session variable, then I wouldn't have to worry about the type being altered. --sorry if this is a repost, the first one didn't seem to go through-- Since the form submit won't inherently send the 'type' of the field that was sent, you could use a method of naming your fields according to the type of form field that was used. eg. lt;select name=sel_statelt;option... or lt;input type=text name=txt_Name_First or lt;textarea name=tarea_comments Just a thought. William ~| 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:323423 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: new to cflayout/cflayoutarea
If you want your form to load its action page into the current 'container' then you will need to use lt;cfform tags instead of plain lt;form tags. William I've tried using cflayout/cflayoutarea for the first time. ~| 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:323426 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 deal with Delivery Status Notification (Failure) cfmail
email is correct on receiving server but the recipient is over its size limit Yes, the generic code that is returned is 'failure', thus the 'fail to' email address gets the response. I would suggest that your cfpop do a quick and dirty search for possible reasons for non-delivery of the email and only delete the ones reported as 'unrecoverable'. William ~| 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:323427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Moving from CF to Java - redirecting old pages to new ones
I would suggest handling it at the webserver level. If you just put the cfheader data in the page, then the redirect won't occur until after the page has already been processed and sent back to the user's browser. By handling it at the server level, you reduce your companies processing for the page, and reduce the time waiting for the extra page call from the user's browser. William I know someone knows a better way but I have done it in the application.cfm using cfheader statuscode=301, statustext=Moved Permanently then another cfheader name=Location value=new url. First detecting whether it's the page in question of course. -- Ryan LeTulle ~| 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:323429 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
[sot] Postgres?
Hey all, I am venturing into using postgres for the first time. I have read that you can setup postgres to accept network connections, but I can't find a sample on the internet on how to do it. Currently only accepting localhost. Any ideas? Thanks, William ~| 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:322527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Storing SSN ... I know, I know
I would suggest you contact the banks/financial companies that your client is working with. Ask them what their encryption requirements are for SSNs. If they don't have one, then you can use any system that you like, I prefer ones that have variable seeds to them, but that is just me. If they do have a specific requirement, post back here so we can help you figure out a good method that adheres to their requirements. William -Original Message- From: ColdFusion Developer [mailto:cfdev...@gmail.com] Sent: Monday, May 11, 2009 5:19 PM To: cf-talk Subject: Storing SSN ... I know, I know What's a best practice for securely storing a social security number? I've talked myself blue trying to talk my client out of doing this, but the bank he's working with for this project absolutely, positively cannot process his transactions without the SSNs of our users (most of the businesses they work with are payroll companies with secure internal data storage, not a public-facing site like his will be). What would you all recommend as a process/method for storing this info in the most secure way possible? Most of what I've read just says encrypt/decrypt it in the database and you're fine -- but I'm not so sure that's the best course. Thanks in advance! ~| 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:322391 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: making new tab the target of a url
Gonzo, I am assuming that you are referring to the 'browser' tabs as opposed to a tab in a cfajax element. The control over that part of the browser is only available to the computer user. There is a setting in most of the browser with tabs that I have looked at, that allows new windows to be opened in a tab rather than a new window. This is part of the 'sandbox' control of the browser. That invisible line between what a website can do on a computer and what it can't do. William -Original Message- From: Gonzo Rock [mailto:gonzor...@gmail.com] Sent: Monday, May 11, 2009 4:51 PM To: cf-talk Subject: making new tab the target of a url How does one make a new tab, or a named tab for that matter, the target of a url? Everything I try ends up in a new window, not a tab. ;-( Thanks, Gonzo ~| 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:322395 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: making new tab the target of a url
Hey Gonzo, I have opened this page you have provided in 3 different browsers. 1. FF, 2. Safari, 3. Chrome (all on the pc). In each instance the links work exactly the way I set them up to in the settings. Maybe I answered too soon and did not know what exactly it is that you are trying to do. I had thought that you wanted to open a page link in a new tab (if the browser supports tabs) rather than a new browser window. This just isn't possible to do on your end of the code. IF you have a confined area of users who are at the whim of your requirements, you can instruct them, or go to each computer yourself, and set up the settings to match your needs. But that assumes a lot about your environment. IF you had meant that you wanted to know how to open a new window/tab instead of just loading the new page in the same window/tab that your user already has open, then there are several ways to do this. 1. use the parameter 'target' with the value '_blank'. (a href='link' target='_blank'link/a 2. user the javascript window.open() command (you should google it if you don't know of it already) I hope this post was little more helpful to you than my last one was. William -Original Message- From: Gonzo Rock [mailto:gonzor...@gmail.com] Sent: Monday, May 11, 2009 6:52 PM To: cf-talk Subject: Re: making new tab the target of a url Hey William, Somehow it IS controllable... for example: http://www.selexgalileo.com/SelexSAS/EN//index.sdo Notice that at the very top of that page, in Red, there is a link labeled Innovation... it opens Innovation in a new tab. Notice that there is another link at the bottom of the page, marked Credits... it opens in the same tab. The Innovation URL is contained in an iframe and the target is _blank and it opens in a tab. The Credits URL is of course a classic URL which opens in the same window/tab. But there is more to this... _blank always opens in a new window when I write it... can't figure out how to make this tabbed behavior happen and I've been goggling for most of the day reading and trying various approaches. Gonzo On Mon, May 11, 2009 at 5:07 PM, William Seiter will...@seiter.com wrote: Gonzo, I am assuming that you are referring to the 'browser' tabs as opposed to a tab in a cfajax element. The control over that part of the browser is only available to the computer user. There is a setting in most of the browser with tabs that I have looked at, that allows new windows to be opened in a tab rather than a new window. This is part of the 'sandbox' control of the browser. That invisible line between what a website can do on a computer and what it can't do. William -Original Message- From: Gonzo Rock [mailto:gonzor...@gmail.com] Sent: Monday, May 11, 2009 4:51 PM To: cf-talk Subject: making new tab the target of a url How does one make a new tab, or a named tab for that matter, the target of a url? Everything I try ends up in a new window, not a tab. ;-( Thanks, Gonzo ~| 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:322403 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: billing
A practice I usually do is invoice weekly on a project. I rarely do 'quoted' jobs anymore, however I do give a guesstimate if the client wants one. I don't have the relationship that you have with your client, but if you have racked up legitimate hours on a project, I would charge them full price. If you want to give them a 'forever' discounted rate, then you can discount the billing on the invoice, but let the client know what the original price was. I would not suggest discounting the billing, at least not until the client has asked for it, and given sufficient reason. William -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Monday, May 04, 2009 10:54 AM To: cf-talk Subject: billing Does anyone give price breaks for quantity of hours in a project? Usually I quote jobs, but this latest one they just said go do it and we have racked up 400+ hours and I think they are going to freak out when they see the bill. We have worked with the company many times in the past so I feel I have to keep my pricing similar to what we have billed before. ~| 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:322151 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: billing
In the case of 'no pay until complete', the situation has arisen in the past where the concept of 'complete' was at issue. We worked it out well, and both of us got good on the deal, but hopefully mentioning this will work as a word of caution... Clients don't always know the 'ins and outs' of our business, so their terminology tends to differ. (I recently have had the same functionality called different things in a meeting - modal window, ajax exploder, grayedout popup window..., just as an example). The differences between 'not complete' and 'additional functionality' is an area where some customers don't see the difference. Part of our jobs with customers like this is not only to protect ourselves with policies that make sense, is also to help educate the client. I have worked with people who require a portion up front before getting started, sometimes with 'milestones' for the next portion of the money. I have worked with people who start on a hand-shake. I have worked with people who invoice periodically (like I do). The most important thing is to do things in a way that makes you feel fiscally protected and the client understands/accepts. If you do things on a 'special' basis to win a client over, make sure that the 'special' method is an introductory thing and that in the future they will adhere to your current methodology. Be careful. As there are many supposed programmers out there that will take a client's money and never produce any results, there are many client's out there that will take your productivity and refuse to pay you for your work, sending you to a lawyer to recover your fees. Stay tuned for my next rant, 'Make it a practice to develop on your own servers' William -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Monday, May 04, 2009 1:06 PM To: cf-talk Subject: RE: billing Thanks for all the feedback. The original site was a $20k project in 2002. Now this redesign which is more complex is hitting the $40k range. I went back and looked closer at all the billing we have done in the past ( I was not in charge at that time of billing ) and I feel this new price is legitimate for the amount of labor we have in it. For these projects in the future I will be doing weekly billing... I have always liked to tell the customer that we wont bill them until the project is complete and they are absolutely happy with the result according to the quote we provide. I kind of got in that mindset and did not want to charge them until the project was done. Thanks! Learned my lesson. -Original Message- From: Al Musella, DPM [mailto:muse...@virtualtrials.com] Sent: Monday, May 04, 2009 3:49 PM To: cf-talk Subject: Re: billing ~| 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:322163 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: js question - getting rusty
For this, pretend that the contents of the iframe actually resides in a
different browser window.
When you click on bn1, you are changing the computers focus to a different
window. So all other commands, without using the mouse to change to the
other window, will only effect that window.
I haven't tried this, but I would suggest having the code after
'eventTrigger' be [iframeid].focus(). If this works, it will change the
'active' window back to the framed page. Of course, this assumes that this
is what your user would 'expect' the layout to do after a click on a
button...
William
iframe id=frm1 .../iframe
button id=bn1... evenTrigger1();document.getElementById('frm1').focus();
/
button id=bn2... evenTrigger2();document.getElementById('frm1').focus();
/
button id=bn3... evenTrigger3();document.getElementById('frm1').focus();
/
-Original Message-
From: Don L [mailto:do...@yahoo.com]
Sent: Sunday, May 03, 2009 4:38 PM
To: cf-talk
Subject: js question - getting rusty
I's an embarrasing js question, been on and off on js, pretty rusty with
it...
I have an iframe for text data input, in the meantime, I have a button
(id=d2) that has an event trigger to open up another window to do
something else, once it is done for the pop-up window, when a user
goes back to the iframe for more typing/data input, there's a problem,
if he/she hits the space bar, it triggers the id of d2 again, pop up a
window again. Browser = IE7. I didn't notice this odd behavior in
the past, is it because the computer has been hacked hence the
keyboard is not functioning nomally but I've just tried two computers
with the same odd behavior.
Someone at the js NG suggested adding the this.blur() event after it, it
worked for button1 but not button2, button3 etc.
iframe .../iframe
button id=bn1... evenTrigger1();this.blur(); / -- this one works
button id=bn2... evenTrigger2();this.blur(); / -- not this one
button id=bn3... evenTrigger3();this.blur(); / -- nor this one
Any idea? Thanks.
Don
Chunshen Li
~|
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:322141
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Injection
Justin, That is a great piece of code, thank you for publishing it. I have a question about it. In the process of it, you create a structure, use it, then delete that structure. If I am using an Application.cfc, would there be any benefit of putting the structure into the application scope, then never deleting it? If I did this and referred to this struct in your code, would this save on overhead time, since I wouldn't need to recreate the structure every page load? Thanks, William -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Friday, April 24, 2009 10:59 AM To: cf-talk Subject: RE: SQL Injection We have one site on our server that was built about 10 years ago. Today some bot is hitting the site and appending their content to the content already in the system. I can't figure out how or where they are getting in. Anyone have any ideas how I can stop this. If you're sure it's SQL injection, start by implementing my basic protector available at: http://www.gravityfree.com/_SQLPrev.cfm.txt Next, run this against your files to find queries where CFQUERYPARAM isn't being used: http://qpscanner.riaforge.org/ Finally, implement CFQUERYPARAM on your queries to protect them against these attacks. Rinse and repeat as necessary. -Justin ~| 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:321949 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 upload - Form Field contains no file
Fawzi, Are you saying that you removed the nested cf-tags and the problem persists? If that is what you are saying, please post your new code as edited, so we can see what else might be wrong. William -Original Message- From: Fawzi Amadu [mailto:abd...@gmail.com] Sent: Tuesday, March 31, 2009 3:39 PM To: cf-talk Subject: Re: Cfform upload - Form Field contains no file I had posted my full code earlier but got no response. I would appreciate it if you can look at it as see whether your thinking about giving a wrong value to the FILEFIELD is correct. The code is at: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:59106 Thanks for your help. this: cfinput type=File name=cfoutput#variables.filename#/cfoutput / is just wrong. you can't nest cf tags like that, and you do not need to: cf automatically evaluates variables in cf tag attributes: cfinput type=file name=#variables.filename# will do just fine. whay cf throws that error is a different issue. my guess would be because you are giving a wrong value to FILEFIELD attribute of cffile tag on the form's action page... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Fawzi Amadu wrote: ~| 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:321137 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL server - Order totals by month, even without month data
There are 2 ways that come to mind right off the bat. 1. Create another table that has each month in it. Do an outer join that allows the other table to return 0 for the months where you have no records in your original table 2. Inspect the query in CF for missing months. If there are any missing months, then create a new query using QueryNew to hold the old query, plus the new rows of months that have a 0 in them. William -Original Message- From: Will Tomlinson [mailto:w...@wtomlinson.com] Sent: Wednesday, March 25, 2009 4:26 AM To: cf-talk Subject: SQL server - Order totals by month, even without month data I have your typical tblorders. I'm trying to query it to get order totals by month, and I'm outputting them in cfchart All goes fine, except in 2009. We have no order data for April-December of course, so the query returns just three rows (Jan, Feb, March). I need it to return all 12 months, with 0 for the months with no orders (April-Dec) I've played with this query and can't get anything to work for me. Any ideas? Thanks! Will select year(orderdate) as orderYear, month(orderdate) as monthOrdered, sum(ordertotal) as totalOrders, dateName(month, orderdate) as monthName from tblorders where orderpaid = 1 and year(orderdate) = 2009 group by year(orderdate), month(orderdate), dateName(month, orderdate) order by year(orderdate) asc, month(orderdate) asc ~| 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:320921 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
FFMpeg FlowPlayer
Hi all, I have been working on this for a few days now and haven't got a clue on how to continue. I was hoping that someone out there has some knowledge of this and can help me. I am building a video upload process that translates video into Flash. I am using a simple form to upload the video. I am using FFmpeg (cfexecute) to translate the video to flash. The video file then exists, but I am unable to play it in flowplayer, or any other flv player that I have downloaded and installed. In my research, I found that FFMpeg used to have a problem where it would not add metatags to the file, and could cause a problem that way, so I installed flvtool2. I now run the flvtool2 on the file after I am done with ffmpeg conversion. When I do this on the command-line on the server, it appears to work very quickly, but the end file still doesn't get called by flowplayer. (I get a 200, file not found). When I do this programmatically through cfexecute, the process times out. (my current timeout is set to 30 minutes). Anyone have any ideas of how I might fix this? I am on a windows server, I have the most recent build of ffmpeg from http://ffmpeg.arrozcru.org/builds/, and we are running CF8. William -- William E. Seiter ~| 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:320859 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FFMpeg FlowPlayer
Thank you, Can you tell me how I would do that? I have access to updating the server myself, but I have never added a mime-type. william -Original Message- From: FROEHLING, ROBERT (ATTSI) [mailto:rf5...@att.com] Sent: Tuesday, March 24, 2009 10:26 AM To: cf-talk Subject: RE: FFMpeg FlowPlayer William, Be sure to check your web server. It needs to be allowed to serve FLV files. I had this issue in IIS and just had to add the appropriate MIME type. Fro -Original Message- From: William Seiter [mailto:will...@seiter.com] Sent: Tuesday, March 24, 2009 11:53 AM To: cf-talk Subject: FFMpeg FlowPlayer Hi all, I have been working on this for a few days now and haven't got a clue on how to continue. I was hoping that someone out there has some knowledge of this and can help me. I am building a video upload process that translates video into Flash. I am using a simple form to upload the video. I am using FFmpeg (cfexecute) to translate the video to flash. The video file then exists, but I am unable to play it in flowplayer, or any other flv player that I have downloaded and installed. In my research, I found that FFMpeg used to have a problem where it would not add metatags to the file, and could cause a problem that way, so I installed flvtool2. I now run the flvtool2 on the file after I am done with ffmpeg conversion. When I do this on the command-line on the server, it appears to work very quickly, but the end file still doesn't get called by flowplayer. (I get a 200, file not found). When I do this programmatically through cfexecute, the process times out. (my current timeout is set to 30 minutes). Anyone have any ideas of how I might fix this? I am on a windows server, I have the most recent build of ffmpeg from http://ffmpeg.arrozcru.org/builds/, and we are running CF8. William -- William E. Seiter ~| 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:320863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: FFMpeg FlowPlayer
That worked! Thank you! William -Original Message- From: John Drake [mailto:thedangerman...@yahoo.com] Sent: Tuesday, March 24, 2009 8:14 PM To: cf-talk Subject: Re: FFMpeg FlowPlayer Here is Adobe's Tech Note on making FLV files work by changing the MIME type in IIS. http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19439sliceId=2 William, Be sure to check your web server. It needs to be allowed to serve FLV files. I had this issue in IIS and just had to add the appropriate MIME type. Fro ~| 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:320903 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CreativeCircle.com??
Has anyone heard of this recruiter firm before? I have been speaking to this company via email for about a week now and they are one of the only companies that I have come across that will not discuss the position that they have available, beyond the very generic job description, until I come into the office and sign an NDA with their company. I was hoping there might be someone on this list who has worked with this company before in the Los Angeles area who can confirm that they are a good company to work with or, more importantly, that they are not. Any help would be great. William ~| 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:4223 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: CreativeCircle.com??
Hey Raj, Can you tell me why? What problems did you find with them? William -Original Message- From: Parikh, Raj [mailto:raj.par...@cdicorp.com] Sent: Tuesday, March 17, 2009 10:42 AM To: cf-jobs-talk Subject: RE: CreativeCircle.com?? Run away from them. -Original Message- From: William Seiter [mailto:will...@seiter.com] Sent: Tuesday, March 17, 2009 1:24 PM To: cf-jobs-talk Subject: CreativeCircle.com?? Has anyone heard of this recruiter firm before? I have been speaking to this company via email for about a week now and they are one of the only companies that I have come across that will not discuss the position that they have available, beyond the very generic job description, until I come into the office and sign an NDA with their company. I was hoping there might be someone on this list who has worked with this company before in the Los Angeles area who can confirm that they are a good company to work with or, more importantly, that they are not. Any help would be great. William ~| 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:4226 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: CreativeCircle.com??
I found 1 review for that office which described a company's experience with 'seth'. Do you have any personal experience with them? William -Original Message- From: ssl...@rubbergumball.net [mailto:ssl...@rubbergumball.net] Sent: Tuesday, March 17, 2009 10:34 AM To: cf-jobs-talk Subject: Re: CreativeCircle.com?? There are a few reviews of the SF office on yelp... Has anyone heard of this recruiter firm before? I have been speaking to this company via email for about a week now and they are one of the only companies that I have come across that will not discuss the position that they have available, beyond the very generic job description, until I come into the office and sign an NDA with their company. I was hoping there might be someone on this list who has worked with this company before in the Los Angeles area who can confirm that they are a good company to work with or, more importantly, that they are not. Any help would be great. William ~| 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:4227 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: CreativeCircle.com??
Thanks Raj, I thought it was kind of fishy that they wouldn't give me the NDA to review prior to the onsite meeting. I'll bet they keep you plenty interrupted while you are trying to read that contract too. William -Original Message- From: Parikh, Raj [mailto:raj.par...@cdicorp.com] Sent: Tuesday, March 17, 2009 11:27 AM To: cf-jobs-talk Subject: RE: CreativeCircle.com?? They want to sign a contract that you willonly work with them which is a problem. -Original Message- From: William Seiter [mailto:will...@seiter.com] Sent: Tuesday, March 17, 2009 1:49 PM To: cf-jobs-talk Subject: RE: CreativeCircle.com?? Hey Raj, Can you tell me why? What problems did you find with them? William -Original Message- From: Parikh, Raj [mailto:raj.par...@cdicorp.com] Sent: Tuesday, March 17, 2009 10:42 AM To: cf-jobs-talk Subject: RE: CreativeCircle.com?? Run away from them. -Original Message- From: William Seiter [mailto:will...@seiter.com] Sent: Tuesday, March 17, 2009 1:24 PM To: cf-jobs-talk Subject: CreativeCircle.com?? Has anyone heard of this recruiter firm before? I have been speaking to this company via email for about a week now and they are one of the only companies that I have come across that will not discuss the position that they have available, beyond the very generic job description, until I come into the office and sign an NDA with their company. I was hoping there might be someone on this list who has worked with this company before in the Los Angeles area who can confirm that they are a good company to work with or, more importantly, that they are not. Any help would be great. William ~| 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:4229 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
