Re: commas and autosuggest
Yes via input. Another option? On Thu, Aug 29, 2013 at 7:58 AM, Raymond Camden raymondcam...@gmail.comwrote: You didn't say - but are you using autosuggests via cfinput? If so - you can specify another delimiter. Check the CFML Ref for cfinput. And please consider using another option for your front end AJAX-y goodness. On Wed, Aug 28, 2013 at 10:20 PM, Monique Boea moniqueb...@gmail.com wrote: hey guys/gals how do you deal with commas in values with autosugest? 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:356633 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Outputting SQL aliases as table headers
Hello all How can I output sql aliases as headers in a table? See attached. ~| 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:356635 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: commas and autosuggest
got it Thanks! I will look at the other options. On Thu, Aug 29, 2013 at 8:37 AM, Raymond Camden raymondcam...@gmail.comwrote: Use the delimiter option of cfinput for now. My comment about avoiding it wasn't helpful - sorry. As a general FYI, I avoid the front end UI stuff as much as possible. There are *multiple* other autosuggest options out there. jQueryUI is one of my favorite, or you can just go HTML5 with the datalist tag and skip JS completely. On Thu, Aug 29, 2013 at 7:08 AM, Monique Boea moniqueb...@gmail.com wrote: Yes via input. Another option? On Thu, Aug 29, 2013 at 7:58 AM, Raymond Camden raymondcam...@gmail.com wrote: You didn't say - but are you using autosuggests via cfinput? If so - you can specify another delimiter. Check the CFML Ref for cfinput. And please consider using another option for your front end AJAX-y goodness. On Wed, Aug 28, 2013 at 10:20 PM, Monique Boea moniqueb...@gmail.com wrote: hey guys/gals how do you deal with commas in values with autosugest? 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:356638 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Outputting SQL aliases as table headers
but the sql column name is what I need to have as the table column name and there are spaces in the aliases. On Thu, Aug 29, 2013 at 10:46 AM, Russ Michaels r...@michaels.me.uk wrote: in the same way that you would output any column name in a table. You just output it. thAlias Name/th On Thu, Aug 29, 2013 at 1:29 PM, Monique Boea moniqueb...@gmail.com wrote: Hello all How can I output sql aliases as headers in a table? See attached. ~| 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:356644 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Outputting SQL aliases as table headers
They are dynamic with spaces. On Thu, Aug 29, 2013 at 11:04 AM, Russ Michaels r...@michaels.me.uk wrote: I still do not see what your problem is, it is just text in a table header, it can be anything you like, including spaces On Thu, Aug 29, 2013 at 4:01 PM, Monique Boea moniqueb...@gmail.com wrote: but the sql column name is what I need to have as the table column name and there are spaces in the aliases. On Thu, Aug 29, 2013 at 10:46 AM, Russ Michaels r...@michaels.me.uk wrote: in the same way that you would output any column name in a table. You just output it. thAlias Name/th On Thu, Aug 29, 2013 at 1:29 PM, Monique Boea moniqueb...@gmail.com wrote: Hello all How can I output sql aliases as headers in a table? See attached. ~| 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:356646 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
json ReferenceError: $ is not defined error
hello all I am attempting to implement this simple checkusername code: http://ja.mesbrown.com/2009/10/coldfusion-and-jquery-using-ajax-to-call-a-cfc-and-return-json/ No matter where I put my cfc, I get a json ReferenceError: $ is not defined error. Any thoughts? ~| 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:356595 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: json ReferenceError: $ is not defined error
Sorry I don't see my posts on the site. Ok thanks On Wed, Aug 28, 2013 at 2:26 PM, Matt Quackenbush quackfu...@gmail.comwrote: As myself and others replied on your other identical thread: jQuery is not loaded or is in conflict with another library and $ is not defined. Make sure you have jQuery loaded. On Wed, Aug 28, 2013 at 2:24 PM, Monique Boea moniqueb...@gmail.com wrote: hello all I am attempting to implement this simple checkusername code: http://ja.mesbrown.com/2009/10/coldfusion-and-jquery-using-ajax-to-call-a-cfc-and-return-json/ No matter where I put my cfc, I get a json ReferenceError: $ is not defined error. Any thoughts? ~| 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:356597 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
commas and autosuggest
hey guys/gals how do you deal with commas in values with autosugest? 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:356623 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
500 there is no web application configured to service your request
Hello All. My computer went through the automatic updates last night and since I get the following message: 500 https://groups.google.com/d/topic/cfaussie/BoA4YjZRJbM there is no web application configured to service your request Thoughts? ~| 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:356477 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: 500 there is no web application configured to service your request
I checked in services and its running -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Thursday, August 15, 2013 1:43 PM To: cf-talk Subject: Re: 500 there is no web application configured to service your request usually means that cf is not running On Thu, Aug 15, 2013 at 6:34 PM, Monique Boea moni...@atlaref.org wrote: Hello All. My computer went through the automatic updates last night and since I get the following message: 500 https://groups.google.com/d/topic/cfaussie/BoA4YjZRJbM there is no web application configured to service your request Thoughts? ~| 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:356479 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: 500 there is no web application configured to service your request
It's working now for some reason. -Original Message- From: Tom McNeer [mailto:tmcn...@gmail.com] Sent: Thursday, August 15, 2013 2:28 PM To: cf-talk Subject: Re: 500 there is no web application configured to service your request The service could be hung up and deliver the error you saw, but still _appear_ to be running within the services panel. Try restarting the service. On Thu, Aug 15, 2013 at 1:55 PM, Monique Boea moni...@atlaref.org wrote: I checked in services and its running -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Thursday, August 15, 2013 1:43 PM To: cf-talk Subject: Re: 500 there is no web application configured to service your request usually means that cf is not running On Thu, Aug 15, 2013 at 6:34 PM, Monique Boea moni...@atlaref.org wrote: Hello All. My computer went through the automatic updates last night and since I get the following message: 500 https://groups.google.com/d/topic/cfaussie/BoA4YjZRJbM there is no web application configured to service your request Thoughts? ~| 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:356481 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 cftextarea richtext is stealing form focus, and being referred to by the form
is houseoffusion.com down? TESTING On Sun, Feb 13, 2011 at 5:52 PM, Michael Benoit michael.ben...@prsa.orgwrote: In addition, FCKConfig.StartupFocus= false; in fckconfig.js Hi, sorry for necroposting, but has anyone seen a solution to this problem in CF8? I'm experiencing the exact same issue, and it's a bit aggravating. 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:348414 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Weird issue with timestamp
Hi All. I am hoping this reaches the group because I can't get to the site. I need to append a variable to a url which just so happens to be timestamp. The url is for a credit card processing site and I HAVE to pass in the variable. Here is the problem: 'timestamp' is being changed to 'x' because times is the special character entity for x. Is there any way to escape times so it won't send an X? 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:348415 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Weird issue with timestamp
Wow. I am such a dork! This did it: amp;timestamp On Wed, Nov 2, 2011 at 2:29 PM, Monique Boea moniqueb...@gmail.com wrote: Hi All. I am hoping this reaches the group because I can't get to the site. I need to append a variable to a url which just so happens to be timestamp. The url is for a credit card processing site and I HAVE to pass in the variable. Here is the problem: 'timestamp' is being changed to 'x' because times is the special character entity for x. Is there any way to escape times so it won't send an X? 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:348419 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Grid like form with multiple inserts
Any sample code for a grid-like form? On Thu, Jan 27, 2011 at 8:16 PM, Monique Boea moniqueb...@gmail.com wrote: Hello All I have a form which is design like an excel spreadsheet with about 60 input rows. The user may enter values for some and not the others. I am stuck on entering the values into the database. I use the following code to loop through the forms vars but don't know where to go after this. cfloop list=#StructKeyList(form)# index=key cfif #form[key]# NEQ Submit AND #form[key]# NEQ FIELDNAMES cfoutput#key# = #form[key]#br/cfoutput /cfif /cfloop Any suggestions? P.S. Thank you guys for all of your help. It is appreciated. ~| 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:341641 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Grid like form with multiple inserts
New records. See code below. I need to parse through the submitted fields to insert them. I think I am making it much harder then what it is but I'm SO stuck. Here's the code that I am working with to process the form fields: cfif isDefined(form.submit) cfloop From=1 To= #users.recordcount# index=i cfloop item=fname collection=#form# cfoutputcfif #form[fname]# NEQ #Evaluate(form[fname] i)#br //cfif/cfoutput /cfloop /cfloop /cfif Here's the form cfloop query=users cfif users.roleID NEQ 1 tr tdinput name=userID#userID# type=checkbox value=#users.employeeID# #users.firstname# #users.lastname#/td td CFSELECT NAME=code#userID# OPTION value=/option OPTION value=PersonalPersonal/option OPTION value=PreceptorPreceptor/option OPTION value=Senior Resource NurseSenior Resource Nurse/option OPTION value=Special Project-PhoneSpecial Project-Phone/option OPTION value=System Down TimeSystem Down Time/option OPTION value=Training-In PersonTraining-In Person/option OPTION value=Training: PhoneTraining: Phone/option OPTION value=Client Training PhoneClient Training Phone/option OPTION value=Peer To Peer ConsultationPeer To Peer Consultation/option OPTION value=Gone HomeGone Home/option /CFSELECT /td tdinput name=minutes#userID# value= size=5/td /tr /cfif /cfloop On Fri, Jan 28, 2011 at 1:43 PM, Carl Von Stetten vonner.li...@vonner.netwrote: Some more information might be helpful. Can we see the code of the form itself? Also, are you just inserting new records into your database, or editing existing records? On 1/28/2011 10:34 AM, Monique Boea wrote: Any sample code for a grid-like form? On Thu, Jan 27, 2011 at 8:16 PM, Monique Boeamoniqueb...@gmail.com wrote: Hello All I have a form which is design like an excel spreadsheet with about 60 input rows. The user may enter values for some and not the others. I am stuck on entering the values into the database. I use the following code to loop through the forms vars but don't know where to go after this. cfloop list=#StructKeyList(form)# index=key cfif #form[key]# NEQ Submit AND #form[key]# NEQ FIELDNAMES cfoutput#key# = #form[key]#br/cfoutput /cfif /cfloop Any suggestions? P.S. Thank you guys for all of your help. It is appreciated. ~| 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:341643 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Grid like form with multiple inserts
*So each time the form is submitted, you'll be inserting new records into a database table? * Yes *Also, the first input is a checkbox that passes the users.employeeID if checked - what is the expected value if the checkbox is not checked?* If its not checked it won't be submitted. On Fri, Jan 28, 2011 at 2:12 PM, Carl Von Stetten vonner.li...@vonner.netwrote: So each time the form is submitted, you'll be inserting new records into a database table? Also, the first input is a checkbox that passes the users.employeeID if checked - what is the expected value if the checkbox is not checked? What is the structure of the table you are inserting to? On 1/28/2011 10:46 AM, Monique Boea wrote: New records. See code below. I need to parse through the submitted fields to insert them. I think I am making it much harder then what it is but I'm SO stuck. Here's the code that I am working with to process the form fields: cfif isDefined(form.submit) cfloop From=1 To= #users.recordcount# index=i cfloop item=fname collection=#form# cfoutputcfif #form[fname]# NEQ #Evaluate(form[fname] i)#br //cfif/cfoutput /cfloop /cfloop /cfif Here's the form cfloop query=users cfif users.roleID NEQ 1 tr tdinput name=userID#userID# type=checkbox value=#users.employeeID# #users.firstname# #users.lastname#/td td CFSELECT NAME=code#userID# OPTION value=/option OPTION value=PersonalPersonal/option OPTION value=PreceptorPreceptor/option OPTION value=Senior Resource NurseSenior Resource Nurse/option OPTION value=Special Project-PhoneSpecial Project-Phone/option OPTION value=System Down TimeSystem Down Time/option OPTION value=Training-In PersonTraining-In Person/option OPTION value=Training: PhoneTraining: Phone/option OPTION value=Client Training PhoneClient Training Phone/option OPTION value=Peer To Peer ConsultationPeer To Peer Consultation/option OPTION value=Gone HomeGone Home/option /CFSELECT /td tdinput name=minutes#userID# value= size=5/td /tr /cfif /cfloop On Fri, Jan 28, 2011 at 1:43 PM, Carl Von Stetten vonner.li...@vonner.netwrote: Some more information might be helpful. Can we see the code of the form itself? Also, are you just inserting new records into your database, or editing existing records? On 1/28/2011 10:34 AM, Monique Boea wrote: Any sample code for a grid-like form? On Thu, Jan 27, 2011 at 8:16 PM, Monique Boeamoniqueb...@gmail.com wrote: Hello All I have a form which is design like an excel spreadsheet with about 60 input rows. The user may enter values for some and not the others. I am stuck on entering the values into the database. I use the following code to loop through the forms vars but don't know where to go after this. cfloop list=#StructKeyList(form)# index=key cfif #form[key]# NEQ Submit AND #form[key]# NEQ FIELDNAMES cfoutput#key# = #form[key]#br/cfoutput /cfif /cfloop Any suggestions? P.S. Thank you guys for all of your help. It is appreciated. ~| 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:341659 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Grid like form with multiple inserts
*So each time the form is submitted, you'll be inserting new records into a database table? * Yes *Also, the first input is a checkbox that passes the users.employeeID if checked - what is the expected value if the checkbox is not checked?* If its not checked it won't be submitted. The structure of the table is simple. I just need to insert three columns. ~| 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:341660 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Hosting
I pay $15.99/month at A to Z hosting. On Fri, Jan 28, 2011 at 2:21 PM, Charlie Griefer charlie.grie...@gmail.comwrote: When you're paying $75 a year for CF hosting, you don't get the luxury of folks getting to see it in multiple browsers :D On Fri, Jan 28, 2011 at 12:16 PM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: Strange it came up for me in Firefox, but my Corporate version of IE8 gets the following error: Forbidden You don't have permission to access / on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Friday, January 28, 2011 2:10 PM To: cf-talk Subject: Re: Coldfusion Hosting Weird. Comes up for me. Came up for me a few minutes ago (I brought the site up to check the price). Hmm... ~| 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:341663 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Dynamic form fields part two
Hello all. I have been trying to figure this out all day. Any assistance would be appreciated. I have a dynamic form that is in grid format: cfform name=enterNonProd action=#cgi.SCRIPT_NAME# method=post table class=content border=1 style=border-collapse:collapse; cellpadding=5 cellspacing=5 trtd colspan=3span class=titlenbsp;nbsp;Use the form below to enter non-productive time for agents. NOTE: Please enter time as minutes/span/td/tr tr td valign=top table class=content cellpadding=5 cellspacing=5 trtd colspan=3 height=10/td/tr trtdstrongAGENT/strong/tdtdstrongREASON CODE/strong/tdtdstrongMINUTES/strong/td/tr cfloop query=users cfif users.roleID NEQ 1 tr tdinput name=user#employeeID# type=checkbox value=#users.employeeID# #users.firstname# #users.lastname#/td td CFSELECT NAME=code#employeeID# OPTION value=/option OPTION value=PersonalPersonal/option OPTION value=Gone HomeGone Home/option /CFSELECT /td tdinput name=minutes#employeeID# value= size=5/td /tr /cfif /cfloop trtd colspan=3 height=20/td/tr trtd colspan=3 align=centerinput name=submit type=submit value=submit/td/tr /table /td /tr /table /cfform When the form is submitted, I need to be able to insert the variables in the db: I have the following code that I am able to get the values of the form vars with but I don't know where to go from here: cfoutput cfloop item=fname collection=#form# cfset response = evaluate(form.#fname#) cfif response NEQ AND response NEQ submit AND #fname# NEQ FIELDNAMES #fname# - #form[fname]# /cfif cfquery datasource=alere INSERT INTO nonproductivetime ( employeeID, code, minutes) VALUES ( cfqueryparam cfsqltype=CF_SQL_CHAR value=#form[fname]#, cfqueryparam cfsqltype=CF_SQL_CHAR value=#form[fname]#, cfqueryparam cfsqltype=CF_SQL_CHAR value=#form[fname]# ) /cfquery /cfloop /cfoutput ~| 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:341679 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic form fields part two
If anyone is interested here is how I got this to work FINALLY!! cfoutput cfif isDefined(form.submit) cfloop index=i list=#Form.employeeID# cfif isDefined('form.reason#i#') AND #form[reason#i#]# NEQ cfquery datasource=alere INSERT INTO nonproductivetime ( employeeID, reason, time, addedby) VALUES ( #form[employeeID#i#]#, '#form[reason#i#]#', #form[time#i#]#, '#session.user.username#' ) /cfquery cfelse /cfif /cfloop /cfif /cfoutput On Fri, Jan 28, 2011 at 7:46 PM, Monique Boea moniqueb...@gmail.com wrote: Hello all. I have been trying to figure this out all day. Any assistance would be appreciated. I have a dynamic form that is in grid format: cfform name=enterNonProd action=#cgi.SCRIPT_NAME# method=post table class=content border=1 style=border-collapse:collapse; cellpadding=5 cellspacing=5 trtd colspan=3span class=titlenbsp;nbsp;Use the form below to enter non-productive time for agents. NOTE: Please enter time as minutes/span/td/tr tr td valign=top table class=content cellpadding=5 cellspacing=5 trtd colspan=3 height=10/td/tr trtdstrongAGENT/strong/tdtdstrongREASON CODE/strong/tdtdstrongMINUTES/strong/td/tr cfloop query=users cfif users.roleID NEQ 1 tr tdinput name=user#employeeID# type=checkbox value=#users.employeeID# #users.firstname# #users.lastname#/td td CFSELECT NAME=code#employeeID# OPTION value=/option OPTION value=PersonalPersonal/option OPTION value=Gone HomeGone Home/option /CFSELECT /td tdinput name=minutes#employeeID# value= size=5/td /tr /cfif /cfloop trtd colspan=3 height=20/td/tr trtd colspan=3 align=centerinput name=submit type=submit value=submit/td/tr /table /td /tr /table /cfform When the form is submitted, I need to be able to insert the variables in the db: I have the following code that I am able to get the values of the form vars with but I don't know where to go from here: cfoutput cfloop item=fname collection=#form# cfset response = evaluate(form.#fname#) cfif response NEQ AND response NEQ submit AND #fname# NEQ FIELDNAMES #fname# - #form[fname]# /cfif cfquery datasource=alere INSERT INTO nonproductivetime ( employeeID, code, minutes) VALUES ( cfqueryparam cfsqltype=CF_SQL_CHAR value=#form[fname]#, cfqueryparam cfsqltype=CF_SQL_CHAR value=#form[fname]#, cfqueryparam cfsqltype=CF_SQL_CHAR value=#form[fname]# ) /cfquery /cfloop /cfoutput ~| 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:341683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Grid like form with multiple inserts
Hello All I have a form which is design like an excel spreadsheet with about 60 input rows. The user may enter values for some and not the others. I am stuck on entering the values into the database. I use the following code to loop through the forms vars but don't know where to go after this. cfloop list=#StructKeyList(form)# index=key cfif #form[key]# NEQ Submit AND #form[key]# NEQ FIELDNAMES cfoutput#key# = #form[key]#br/cfoutput /cfif /cfloop Any suggestions? P.S. Thank you guys for all of your help. It is appreciated. ~| 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:341588 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Extracting a date from a string
Hello All. How would you go about extracting the date from this string: *Department Summary by Employee 10/27/2010 - 10/27/2010* ~| 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:341401 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Extracting a date from a string
The first one is fine and not a range but it won't be the same all of the time. On Wed, Jan 26, 2011 at 1:43 PM, Kelly webd...@gmail.com wrote: which date? will both dates always be identical? Or will it sometimes be a range? Would you need to extract one or both? On 1/26/2011 1:41 PM, Monique Boea wrote: Hello All. How would you go about extracting the date from this string: *Department Summary by Employee 10/27/2010 - 10/27/2010* ~| 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:341405 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Extracting a date from a string
Yes. On Wed, Jan 26, 2011 at 1:44 PM, Alan Rother alan.rot...@gmail.com wrote: How consistent is the first part of the string? *Department Summary by Employee Is it ALWAYS that exact string? On Wed, Jan 26, 2011 at 11:43 AM, Kelly webd...@gmail.com wrote: which date? will both dates always be identical? Or will it sometimes be a range? Would you need to extract one or both? On 1/26/2011 1:41 PM, Monique Boea wrote: Hello All. How would you go about extracting the date from this string: *Department Summary by Employee 10/27/2010 - 10/27/2010* ~| 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:341406 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Extracting a date from a string
This give me the value of 32 cfset string=Department Summary by Employee 10/27/2010 - 10/27/2010 cfset dates=REFind([0-1][0-9]/[0-3][0-9]/[0-9]{4}, string) cfoutput#dates#/cfoutput On Wed, Jan 26, 2011 at 1:54 PM, Ben Forta b...@forta.com wrote: Assuming that the dates are always in mm/dd/ format, I'd use a regular expression, something like this: cfset string=*Department Summary by Employee 10/27/2010 - 10/27/2010* cfset dates=REFind([0-1][0-9]/[0-3][0-9]/[0-9]{4}, string) disclaimer Code written on the fly with no testing ;-) /disclaimer Dates will then be an array, and in your example dates[1] will be the start date and dates[2] the second date. --- Ben -Original Message- From: Monique Boea [mailto:moniqueb...@gmail.com] Sent: Wednesday, January 26, 2011 1:42 PM To: cf-talk Subject: Extracting a date from a string Hello All. How would you go about extracting the date from this string: *Department Summary by Employee 10/27/2010 - 10/27/2010* ~| 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:341413 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Extracting a date from a string
This worked for me :) cfset string=Department Summary by Employee 10/27/2010 - 10/27/2010 cfoutput#ListGetAt(string, 5, ' ')#/cfoutput On Wed, Jan 26, 2011 at 2:01 PM, Monique Boea moniqueb...@gmail.com wrote: This give me the value of 32 cfset string=Department Summary by Employee 10/27/2010 - 10/27/2010 cfset dates=REFind([0-1][0-9]/[0-3][0-9]/[0-9]{4}, string) cfoutput#dates#/cfoutput On Wed, Jan 26, 2011 at 1:54 PM, Ben Forta b...@forta.com wrote: Assuming that the dates are always in mm/dd/ format, I'd use a regular expression, something like this: cfset string=*Department Summary by Employee 10/27/2010 - 10/27/2010* cfset dates=REFind([0-1][0-9]/[0-3][0-9]/[0-9]{4}, string) disclaimer Code written on the fly with no testing ;-) /disclaimer Dates will then be an array, and in your example dates[1] will be the start date and dates[2] the second date. --- Ben -Original Message- From: Monique Boea [mailto:moniqueb...@gmail.com] Sent: Wednesday, January 26, 2011 1:42 PM To: cf-talk Subject: Extracting a date from a string Hello All. How would you go about extracting the date from this string: *Department Summary by Employee 10/27/2010 - 10/27/2010* ~| 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:341417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Extracting a date from a string
No prob. Will try it. On Wed, Jan 26, 2011 at 2:06 PM, Ben Forta b...@forta.com wrote: Oops, meant REMatch(), not REFind(). Use REMatch() and it'll do exactly what you want. Just be sure to check the length of the returned array before using it. --- Ben -Original Message- From: Monique Boea [mailto:moniqueb...@gmail.com] Sent: Wednesday, January 26, 2011 2:02 PM To: cf-talk Subject: Re: Extracting a date from a string This give me the value of 32 cfset string=Department Summary by Employee 10/27/2010 - 10/27/2010 cfset dates=REFind([0-1][0-9]/[0-3][0-9]/[0-9]{4}, string) cfoutput#dates#/cfoutput On Wed, Jan 26, 2011 at 1:54 PM, Ben Forta b...@forta.com wrote: Assuming that the dates are always in mm/dd/ format, I'd use a regular expression, something like this: cfset string=*Department Summary by Employee 10/27/2010 - 10/27/2010* cfset dates=REFind([0-1][0-9]/[0-3][0-9]/[0-9]{4}, string) disclaimer Code written on the fly with no testing ;-) /disclaimer Dates will then be an array, and in your example dates[1] will be the start date and dates[2] the second date. --- Ben -Original Message- From: Monique Boea [mailto:moniqueb...@gmail.com] Sent: Wednesday, January 26, 2011 1:42 PM To: cf-talk Subject: Extracting a date from a string Hello All. How would you go about extracting the date from this string: *Department Summary by Employee 10/27/2010 - 10/27/2010* ~| 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:341420 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Reading a text file then saving to excel
Hello All. I am reading a text file and saving it in excel. I am using the following code: cfoutput cfset filePath = #ExpandPath( \)# cfheader name=Content-Disposition value=filename=agentDaily.xls cfcontent type=application/vnd.ms-excel file=#filePath#\user\dailyreports\agentDaily.txt deletefile=no /cfoutput My problem is I want to save it to a directory and the files keep opening in the browser. How can I save it to directory? This link doesn't help: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_c_11.html ~| 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:341477 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Decimals
Hello All. Does decimalFormat have any kind of making? I need this number 78.57 to be converted to the .79 Thank you. ~| 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:341491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Script tags and fckEditor
Is there ANY way to allow script tags in the fckEditor? When I add them, it bombs. 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:341090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: mySQL Error
I tried DECIMAL(2,1) and still get the same thing. - Original Message - From: Azadi Saryev To: cf-talk Sent: Monday, December 27, 2010 9:25 PM Subject: Re: mySQL Error DECIMAL(4,4) is a bit strange - the (4,4) part means your column can store a value with 4 digits, 4 of which are decimal points - effectively means you can only store a range of values between -. and . in your column. the first 4 in (4,4) denotes total number of digits allowed - integers and decimals - not the length of integer part of column value. Azadi On 28/12/2010 08:46 , Monique Boea wrote: I have created a table that needed decimal columns. Here is my script: CREATE TABLE `goals` ( `enrollments` DECIMAL(4,4) DEFAULT NULL , `followups` DECIMAL(4,4) DEFAULT NULL , `outcomes` DECIMAL(4,4) DEFAULT NULL , `productivityPoints` DECIMAL(4,4) DEFAULT NULL , `hoursWorked` DECIMAL(4,4) DEFAULT NULL , `extrabreakACW` DECIMAL(4,4) DEFAULT NULL , `productiveHours` DECIMAL(4,4) DEFAULT NULL , `totalCalls` DECIMAL(4,4) DEFAULT NULL , `callsPerhour` DECIMAL(4,4) DEFAULT NULL , `datelastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP, `lastUpdatedBy` varchar(200)); When I try to insert a record I get the following error: 1264: Out of range value adjusted for column 'enrollments' at row 1i've googled the error and most resources say that the occurs when INSERT query makes try to insert an empty value into a NOT NULL field, but I know this is not the case here.Any suggestions?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:340293 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: mySQL Error
I used UNSIGNED DECIMAL (10,2) as suggested by this page http://forums.digitalpoint.com/showthread.php?t=274332 (see very last comment) and it worked! - Original Message - From: Azadi Saryev To: cf-talk Sent: Monday, December 27, 2010 9:25 PM Subject: Re: mySQL Error DECIMAL(4,4) is a bit strange - the (4,4) part means your column can store a value with 4 digits, 4 of which are decimal points - effectively means you can only store a range of values between -. and . in your column. the first 4 in (4,4) denotes total number of digits allowed - integers and decimals - not the length of integer part of column value. Azadi On 28/12/2010 08:46 , Monique Boea wrote: I have created a table that needed decimal columns. Here is my script: CREATE TABLE `goals` ( `enrollments` DECIMAL(4,4) DEFAULT NULL , `followups` DECIMAL(4,4) DEFAULT NULL , `outcomes` DECIMAL(4,4) DEFAULT NULL , `productivityPoints` DECIMAL(4,4) DEFAULT NULL , `hoursWorked` DECIMAL(4,4) DEFAULT NULL , `extrabreakACW` DECIMAL(4,4) DEFAULT NULL , `productiveHours` DECIMAL(4,4) DEFAULT NULL , `totalCalls` DECIMAL(4,4) DEFAULT NULL , `callsPerhour` DECIMAL(4,4) DEFAULT NULL , `datelastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP, `lastUpdatedBy` varchar(200)); When I try to insert a record I get the following error: 1264: Out of range value adjusted for column 'enrollments' at row 1i've googled the error and most resources say that the occurs when INSERT query makes try to insert an empty value into a NOT NULL field, but I know this is not the case here.Any suggestions?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:340294 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
mySQL Error
I have created a table that needed decimal columns. Here is my script: CREATE TABLE `goals` ( `enrollments` DECIMAL(4,4) DEFAULT NULL , `followups` DECIMAL(4,4) DEFAULT NULL , `outcomes` DECIMAL(4,4) DEFAULT NULL , `productivityPoints` DECIMAL(4,4) DEFAULT NULL , `hoursWorked` DECIMAL(4,4) DEFAULT NULL , `extrabreakACW` DECIMAL(4,4) DEFAULT NULL , `productiveHours` DECIMAL(4,4) DEFAULT NULL , `totalCalls` DECIMAL(4,4) DEFAULT NULL , `callsPerhour` DECIMAL(4,4) DEFAULT NULL , `datelastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP, `lastUpdatedBy` varchar(200)); When I try to insert a record I get the following error: 1264: Out of range value adjusted for column 'enrollments' at row 1i've googled the error and most resources say that the occurs when INSERT query makes try to insert an empty value into a NOT NULL field, but I know this is not the case here.Any suggestions?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:340287 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: mySQL Error
I am inserting it on the back end. - Original Message - From: Justin Scott To: cf-talk Sent: Monday, December 27, 2010 8:09 PM Subject: RE: mySQL Error When I try to insert a record I get the following error: What's the insert query look like? -Justin ~| 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:340289 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: mySQL Error
Oh sorry :) just simple number and decimals: `enrollments` DECIMAL(4,4) DEFAULT NULL , `followups` DECIMAL(4,4) DEFAULT NULL , `outcomes` DECIMAL(4,4) DEFAULT NULL , `productivityPoints` DECIMAL(4,4) DEFAULT NULL , `hoursWorked` DECIMAL(4,4) DEFAULT NULL , `extrabreakACW` DECIMAL(4,4) DEFAULT NULL , `productiveHours` DECIMAL(4,4) DEFAULT NULL , `totalCalls` DECIMAL(4,4) DEFAULT NULL , `callsPerhour` DECIMAL(4,4) DEFAULT NULL , `datelastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP, `lastUpdatedBy` varchar(200)); here are the values I was inserting enrollments - 33 followup - 25 outcomes - 21.3 and so on. Some were decimals some whole numbers. - Original Message - From: Justin Scott To: cf-talk Sent: Monday, December 27, 2010 8:33 PM Subject: RE: mySQL Error I am inserting it on the back end. Ok, what is the value you're trying to insert? The more info you can volunteer up front, the easier it will be to help you. :) -Justin ~| 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:340292 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
The INSERT statement conflicted with the FOREIGN KEY constraint
Hello All. I have a stored proc that when I execute it from SQL server mgmt studio, it works fine. But when I try to execute it in CF, I get the following error: *Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The INSERT statement conflicted with the FOREIGN KEY constraint* Here is my code: cfstoredproc procedure=spmembersII_savegroups datasource=#request.dsn# returncode=yes cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=intInstitutionID value=541 cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=intMemberID value=10008 cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=strStages value= cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=intMemberIDUpdate value=0 cfprocresult name=enrollmentquestions /cfstoredproc Any suggestions? ~| 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:340096 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFDOCUMENT and Images
Hi All. There is an issue with CFDOCUMENT timing out on a PDF if there are images. The request times out. I googled it and most people said the image has to have an absolute path. I tried that but it's still timing out. When I remove the link to the image, it works fine. Any suggestions? ~| 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:339932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Moving from MSSQL to mySQL
Hello All. Is there a utility that will allow me to copy the tables and structure from an MS SQL database to a mySQL one? 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:339689 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving from MSSQL to mySQL
It's not up to me :( The company is switching because the hosting company convinced the previous developer that it was a good idea. On Wed, Dec 1, 2010 at 1:26 PM, Russ Michaels r...@michaels.me.uk wrote: here: http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html unless you are migrating from windows to linux though I wouldn't recommend doing this. SQL Server is the far superior solution, easier to use, easier to manage, better client tools, better backup options, generally more reliable. This opinion is based on 10 years hosting both in a shared hosting environment by the way, hundreds of databases for hundreds of customers. -- Russ Michaels www.cfmldeveloper.com - Supporting the CF community since 1999 FREE ColdFusion/Railo hosting for developers. blog: www.michaels.me.uk ~| 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:339701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving from MSSQL to mySQL
What's the link? there are a million Intelligent Solutions out there :) On Wed, Dec 1, 2010 at 1:39 PM, mac.jordan mac.jor...@gmail.com wrote: Check out Intelligent Solutions - we have utility software from them to do Access and mySQL. -- mac jordan On 1 Dec 2010, at 18:07, Monique Boea moniqueb...@gmail.com wrote: Hello All. Is there a utility that will allow me to copy the tables and structure from an MS SQL database to a mySQL one? 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:339702 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Javascript in fckEditor
Hello all. I am added content to my database via fckEditor and everytime I add a page with javascript on it, the editor acts up when I view try to edit it. The text field disappears and the content is actually displayed on the page. Any suggestions? Thanks and hope everyone enjoyed your holiday! ~| 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:339543 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Making check box values separate variables
Hello All. I'm pretty sure that this is something very simple and I am over thinking it but here is my issue: I have a form with dynamically created input boxes one of which can be a checkbox. When the user submits the form, of course the checkbox field is submited as one, but with 2 values (see fields/value below) (The blue text is the form fields, the red is values). 4454 16829 4455 27788 4456 16699,16700 8436 52246,52247 When I insert these recods into the DB, they must be inserted as integers, so of course the comma causes an error. How can I separate these values and have them inserted as two seperate columns? So the above would look like this: 4454 16829 4455 27788 4456 16699 4456 16700 8436 52246 8436 52247 ~| 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:339166 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFFILE ERROR
I found it: maxContentID is the name of the query #ExpandPath('/contentFiles/#*maxContentID*#_#language#.cfm')# This works #ExpandPath('/contentFiles/#*maxContentID**.contentID*#_#language#.cfm')# On Tue, Nov 9, 2010 at 8:47 PM, Dave Watts dwa...@figleaf.com wrote: I have a file that is creating a CF template using the following code: cfloop Query=languages cffile action = write *file = #ExpandPath('/contentFiles/#maxContentID#_#language#.cfm')# * output = #Evaluate( #language#TEXT )# nameconflict=overwrite /cfloop It used to work fine but all of a sudden the red line is causing the following error: *Complex object types cannot be converted to simple values. The expression has requested a variable or an intermediate expression result as a simple value. However, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you tried to use a complex value as a simple one. For example, you tried to use a query variable in a cfif tag. * Any suggestions? First, I'd suggest that you not use nested hashes. Instead of this: #ExpandPath('/contentFiles/#maxContentID#_#language#.cfm')# use this: #ExpandPath('/contentFiles/' maxContentID '_' language '.cfm')# However, I don't think that's the cause of your problem. Instead, I suspect that one of your variables contains something other than what you think it does. Use CFDUMP to see what's in those variables. 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 tr ~| 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:339073 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFFILE ERROR
I have a file that is creating a CF template using the following code: cfloop Query=languages cffile action = write *file = #ExpandPath('/contentFiles/#maxContentID#_#language#.cfm')# * output = #Evaluate( #language#TEXT )# nameconflict=overwrite /cfloop It used to work fine but all of a sudden the red line is causing the following error: *Complex object types cannot be converted to simple values. The expression has requested a variable or an intermediate expression result as a simple value. However, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you tried to use a complex value as a simple one. For example, you tried to use a query variable in a cfif tag. * Any suggestions? Thank you ~| 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:339061 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFFILE ERROR
Ok thanks Dave, On Tue, Nov 9, 2010 at 8:47 PM, Dave Watts dwa...@figleaf.com wrote: I have a file that is creating a CF template using the following code: cfloop Query=languages cffile action = write *file = #ExpandPath('/contentFiles/#maxContentID#_#language#.cfm')# * output = #Evaluate( #language#TEXT )# nameconflict=overwrite /cfloop It used to work fine but all of a sudden the red line is causing the following error: *Complex object types cannot be converted to simple values. The expression has requested a variable or an intermediate expression result as a simple value. However, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you tried to use a complex value as a simple one. For example, you tried to use a query variable in a cfif tag. * Any suggestions? First, I'd suggest that you not use nested hashes. Instead of this: #ExpandPath('/contentFiles/#maxContentID#_#language#.cfm')# use this: #ExpandPath('/contentFiles/' maxContentID '_' language '.cfm')# However, I don't think that's the cause of your problem. Instead, I suspect that one of your variables contains something other than what you think it does. Use CFDUMP to see what's in those variables. 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 tr ~| 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:339065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jquery
But the jquery code uses a seperate style sheet doesn't it? - Original Message - From: Charlie Griefer To: cf-talk Sent: Friday, November 05, 2010 11:55 PM Subject: Re: jquery Maybe because you recently changed your style sheet? Can you view source and verify that the style you expect to be applied (which I assume is an external .css file) is being included with the correct path? On Fri, Nov 5, 2010 at 9:23 PM, Monique Boea moniqueb...@gmail.com wrote: why would my jquery validation code styles not show up? I recently changed my style sheet on an app...before I made changes the jquery styling showed up (yellow background...red text). Now I get the This field is required message but with no style. Any suggestions? TIA ~| 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:338924 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Formatting the output of a text datatype
hello I am working on a app where users input their resumes. I am using a TEXT datatype for some of my fields for large areas of text i.e. Career Summary. The problem is when I output the text, there is not formatting to it and it looks like a large jumbled block of text. Some of the user cut and paste from Word, so there are strange characters in the data also. What is the best practice for storing and outputting large bodies of text? Thank you. ~| 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:338902 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Formatting the output of a text datatype
Ok thanks! - Original Message - From: Michael Grant To: cf-talk Sent: Saturday, November 06, 2010 10:16 AM Subject: Re: Formatting the output of a text datatype For display you could try pre/pre which should preserve your line breaks at least. It's been a while since I've used it so I'm unsure of it's limitations. You could also try replacing chr(10) chr(13) with br to create html line breaks. As far as the strange characters it's probably the weird open and close quotes etc that word uses. There's probably a regex out there for doing the reformatting. On Sat, Nov 6, 2010 at 9:40 AM, Monique Boea moniqueb...@gmail.com wrote: hello I am working on a app where users input their resumes. I am using a TEXT datatype for some of my fields for large areas of text i.e. Career Summary. The problem is when I output the text, there is not formatting to it and it looks like a large jumbled block of text. Some of the user cut and paste from Word, so there are strange characters in the data also. What is the best practice for storing and outputting large bodies of text? Thank you. ~| 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:338906 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Formatting the output of a text datatype
Thanks terry. Good tip. I never thought to use the fckeditor. On Sat, Nov 6, 2010 at 12:58 PM, Terry Troxel terry.tro...@gmail.comwrote: You just might try Fckeditor for your text datatype entries as it has Paste from word which strips all the various MS formatting. You can modify the menubar to only include the Controls that are needed. Terry -Original Message- From: Monique Boea [mailto:moniqueb...@gmail.com] Sent: Saturday, November 06, 2010 8:34 AM To: cf-talk Subject: Re: Formatting the output of a text datatype Ok thanks! - Original Message - From: Michael Grant To: cf-talk Sent: Saturday, November 06, 2010 10:16 AM Subject: Re: Formatting the output of a text datatype For display you could try pre/pre which should preserve your line breaks at least. It's been a while since I've used it so I'm unsure of it's limitations. You could also try replacing chr(10) chr(13) with br to create html line breaks. As far as the strange characters it's probably the weird open and close quotes etc that word uses. There's probably a regex out there for doing the reformatting. On Sat, Nov 6, 2010 at 9:40 AM, Monique Boea moniqueb...@gmail.com wrote: hello I am working on a app where users input their resumes. I am using a TEXT datatype for some of my fields for large areas of text i.e. Career Summary. The problem is when I output the text, there is not formatting to it and it looks like a large jumbled block of text. Some of the user cut and paste from Word, so there are strange characters in the data also. What is the best practice for storing and outputting large bodies of text? Thank you. ~| 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:338917 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Closing Browser expires session/cookie
I have done this before. Let me look through my code and get back to you. On Fri, Nov 5, 2010 at 7:26 PM, Tony Bentley cascadefreehee...@gmail.comwrote: So I have an app that uses cflogin, which works great if the user logs in and out from the same browser. Now here is where I am stumped: -User logs in, then closes the browser -System does not allow the same user to be logged in more than once -System logs all logged in users -System removes user from log onSessionEnd() How can I remove the user from the log when they close the browser? Here is my logic: onSessionStart{ cfif not isDefined(cookie.CFID) cfcookie name=CFID value=#SESSION.CFID# expires=NOW/ cfcookie name=CFTOKEN value=#SESSION.CFTOKEN# expires=NOW/ /cfif } onSessionEnd{ delogUser(arguments.SessionScope.userid) } login{ cfloginuser name=#uname# password=#pword# logUser(uname,pword) } logout{ cflogout delogUser(session.userid) } onRequest{ if(isDefined(cookie.cfid) and session.loggedin eq false){ //this is in case the user closes the browser and then opens it again checkCookieAgainstLogAndDelogUser(cookie.cfid) } } So yeah, the user closes the browser but that doesn't fire the logout method or clear the cookie or session. When the user tries to login with another browser without actually hitting logout, they cant log in. The only way is to use the same browser that they originally closed. ~| 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:338895 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
jquery
why would my jquery validation code styles not show up? I recently changed my style sheet on an app...before I made changes the jquery styling showed up (yellow background...red text). Now I get the This field is required message but with no style. Any suggestions? TIA ~| 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:338896 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Group BY
How can I get this query to group by month? select count(intMemberID)as NewMembers, DATENAME(mm, dteAdded) + '-' + DATENAME(, dteAdded) AS Month FROM TABLE GROUP BY Month(dteAdded) When I ask on google everyone says to add: *GROUP BY Year(SomeDate), Month(SomeDate) * but that doesn't work. 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:338802 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Group BY
That was it. I found the solution SELECT DATENAME(mm, article.Created) AS Month, DATENAME(, article.Created) AS Year, COUNT(*) AS Total FROM Articles AS article GROUP BY DATENAME(mm, article.Created), DATENAME(, article.Created) ORDER BY Month, Year DESC At the following link: http://stackoverflow.com/questions/45535/get-month-and-year-from-a-datetime-in-sql-server-2005 Thanks! On Wed, Nov 3, 2010 at 2:28 PM, Jason Fisher ja...@wanax.com wrote: If this is SQL Server, than the GROUP BY has to match the un-aggregated SELECT columns, so it would need to be something like: SELECT COUNT(intMemberID) AS NewMembers, DATENAME(mm, dteAdded) + '-' + DATENAME(, dteAdded) AS Month FROM TABLE GROUP BY DATENAME(mm, dteAdded) + '-' + DATENAME(, dteAdded) Not sure if that's what you're asking. From: Monique Boea moniqueb...@gmail.com Sent: Wednesday, November 03, 2010 2:24 PM To: cf-talk cf-talk@houseoffusion.com Subject: Group BY How can I get this query to group by month? select count(intMemberID)as NewMembers, DATENAME(mm, dteAdded) + '-' + DATENAME(, dteAdded) AS Month FROM TABLE GROUP BY Month(dteAdded) When I ask on google everyone says to add: *GROUP BY Year(SomeDate), Month(SomeDate) * but that doesn't work. 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:338806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Debugging output is not working
Hello. We have a new CF 9 server and the debugging output is set in the administrator but it still doesn't show on the page. I asked the server admin about it and here is his reply: *The debugger had to be turned on, port set (5005), and CF restarted. I have done this and setup redirects in the firewall for the IPs listed in the debugger. Can you test and let me know its working.* * *It's still not working. Any suggestions?* * ~| 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:338746 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging output is not working
Thanks Guys I've tried everything that I normally do and it's not working. I'll trying removing the default. On Tue, Nov 2, 2010 at 9:08 AM, Russ Michaels r...@michaels.me.uk wrote: On CF9 by default there are 2 entries in the debugging IP's You need to remove these if you want debugging to be visible to everyone. Regards -- Russ Michaels www.cfmldeveloper.com - free CFML hosting for developers my blog: http://russ.michaels.me.uk/ skype: russmichaels -Original Message- From: Monique Boea [mailto:moniqueb...@gmail.com] Sent: 02 November 2010 12:25 To: cf-talk Subject: Debugging output is not working Hello. We have a new CF 9 server and the debugging output is set in the administrator but it still doesn't show on the page. I asked the server admin about it and here is his reply: *The debugger had to be turned on, port set (5005), and CF restarted. I have done this and setup redirects in the firewall for the IPs listed in the debugger. Can you test and let me know its working.* * *It's still not working. Any suggestions?* * ~| 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:338758 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Reading and saving data via FTP
Hello Is it possible for CF to read an excel spreadsheet that is in an FTP folder and save the contents of that spreadsheet to a database? ~| 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:338707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Reading and saving data via FTP
Thanks! - Original Message - From: John M Bliss To: cf-talk Sent: Sunday, October 31, 2010 9:18 AM Subject: Re: Reading and saving data via FTP Sure. Check out cfftp and http://cflib.org/udf/parseExcel On Sun, Oct 31, 2010 at 8:15 AM, Monique Boea moniqueb...@gmail.com wrote: Hello Is it possible for CF to read an excel spreadsheet that is in an FTP folder and save the contents of that spreadsheet to a database? ~| 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:338709 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: StructAppend Creating an Error
I can output the value of the session vars like so: cfloop query=memberInfoFields cfoutput#session.memberRegister[STRFIELDNAME]#br/cfoutput but this is not working correctly: cfloop query=memberInfoFields input type=text name=#STRFIELDNAME# value=#session.memberRegister[STRFIELDNAME]# size=30 the value of the field is blank. what am I doing wrong? On Fri, Oct 29, 2010 at 1:06 PM, Leigh cfsearch...@yahoo.com wrote: Now, how do I check for the existance of and use these dynamic variables to set my form values? The same way as before. Use array notation. No need for the extra # signs. ie cfif session.memberRegister[ STRFIELDNAME ] eq someValue something here... /cfif BTW: Most scopes in CF are structures. So associative array notation will work with most variables. ~| 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:338691 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: StructAppend Creating an Error
I get the results when I user your code Debug value of strInstUsername = Debug value of strLanguage = Debug value of strInstEmail = m...@aol.com Debug value of strGender = Female Debug value of strDegrees = Associate Degree Debug value of strEmployeeNum = Debug value of strDepartment = Debug value of strResearchRole = Interviewer Debug value of strAddress1 = Debug value of strAddress2 = Debug value of strAddress3 = Debug value of strCity = Decatur Debug value of strState = Debug value of strZip = Debug value of strCountry = USA Debug value of strPhone = 5678887666 Debug value of strCustom1 = Debug value of strCustom2 = Debug value of strCustom3 = lkln Debug value of strCustom4 = Debug value of strCustom5 = On Sat, Oct 30, 2010 at 1:51 PM, Leigh cfsearch...@yahoo.com wrote: Is it possible the value of those keys is actually blank? In previous code you were setting the default value to . Output the value before the inputs. What do you see? cfoutput cfloop query=memberInfoFields Debug value of #STRFIELDNAME# = #session.memberRegister[STRFIELDNAME]# input type=text name=#STRFIELDNAME# value=#session.memberRegister[STRFIELDNAME]# size=30br /cfloop /cfoutput ~| 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:338693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: StructAppend Creating an Error
I figured it out: I had code that was resetting the values: cfif NOT isDefined(session.memberRegister.STRFIELDNAME) cfset session.memberRegister.#STRFIELDNAME# = /cfif On Sat, Oct 30, 2010 at 3:24 PM, Monique Boea moniqueb...@gmail.com wrote: I get the results when I user your code Debug value of strInstUsername = Debug value of strLanguage = Debug value of strInstEmail = m...@aol.com Debug value of strGender = Female Debug value of strDegrees = Associate Degree Debug value of strEmployeeNum = Debug value of strDepartment = Debug value of strResearchRole = Interviewer Debug value of strAddress1 = Debug value of strAddress2 = Debug value of strAddress3 = Debug value of strCity = Decatur Debug value of strState = Debug value of strZip = Debug value of strCountry = USA Debug value of strPhone = 5678887666 Debug value of strCustom1 = Debug value of strCustom2 = Debug value of strCustom3 = lkln Debug value of strCustom4 = Debug value of strCustom5 = On Sat, Oct 30, 2010 at 1:51 PM, Leigh cfsearch...@yahoo.com wrote: Is it possible the value of those keys is actually blank? In previous code you were setting the default value to . Output the value before the inputs. What do you see? cfoutput cfloop query=memberInfoFields Debug value of #STRFIELDNAME# = #session.memberRegister[STRFIELDNAME]# input type=text name=#STRFIELDNAME# value=#session.memberRegister[STRFIELDNAME]# size=30br /cfloop /cfoutput ~| 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:338695 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
StructAppend Creating an Error
Hello I have a multi step form that is being submitted to itself. I create a structure session.memberRegister and then append to the structure as each form is submitted like so: cfscript session.memberRegister = structnew(); /cfscript cfset StructAppend(session['memberRegister'],form) On one of the steps, I retrieve data and create dynamic form fields which I need to append to the session structure. I added a loop and I am appending the query results to the structure like so: cfloop query=memberInfoFields !--- create dynamic session vars --- cfset StructAppend(session['memberRegister'],STRFIELDNAME) The session vars are created but I get the following error: You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members. 42 : 43 : !--- create dynamic session vars ---*44 : cfset StructAppend(session['memberRegister'],STRFIELDNAME)* Any suggestions? Thank you! ~| 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:338667 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: StructAppend Creating an Error
I got this to work. DUH!! cfloop query=memberInfoFields !--- create dynamic session vars --- cfif NOT isDefined(session.memberRegister.STRFIELDNAME) cfset session.memberRegister.#STRFIELDNAME# = /cfif On Fri, Oct 29, 2010 at 9:38 AM, Monique Boea moniqueb...@gmail.com wrote: Hello I have a multi step form that is being submitted to itself. I create a structure session.memberRegister and then append to the structure as each form is submitted like so: cfscript session.memberRegister = structnew(); /cfscript cfset StructAppend(session['memberRegister'],form) On one of the steps, I retrieve data and create dynamic form fields which I need to append to the session structure. I added a loop and I am appending the query results to the structure like so: cfloop query=memberInfoFields !--- create dynamic session vars --- cfset StructAppend(session['memberRegister'],STRFIELDNAME) The session vars are created but I get the following error: You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members. 42 : 43 : !--- create dynamic session vars ---*44 : cfset StructAppend(session['memberRegister'],STRFIELDNAME)* Any suggestions? Thank you! ~| 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:338672 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: StructAppend Creating an Error
Thanks Leigh. Now, how do I check for the existance of and use these dynamic variables to set my form values? Like so: cfif #session.memberRegister.strCME# EQ medicalselected=selected/cfif But I need to use dynamic variable names. I am trying to use this but it is not working: value=#Evaluate(session.memberRegister.#STRFIELDNAME#)# On Fri, Oct 29, 2010 at 11:41 AM, Leigh cfsearch...@yahoo.com wrote: cfset StructAppend(session['memberRegister'],STRFIELDNAME) StructAppend, appends the contents of one structure onto another. STRFIELDNAME looks like a simple value. If you are trying to create a dynamic key, just use array notation ie cfset session.memberRegister[STRFIELDNAME] = ~| 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:338677 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Need assistance with hashbytes (kinda urgently..been at this since 6AM)
Would appreciate it if some on could help: Here goes. I am encrypting a password column (without salt). Here is how I changed the existing column: 1. I saved the value of the password column (VARCHAR 200) to a new column for safe keeping 2. I created a new column called hashedPassword (varbinary MAX) 3. I saved the hashed value of the password column into this new hashedPassword column like so: UPDATE [prod].[dbo].[users] SET hashedPassword = HashBytes('MD5', password) 4. I rename the hashedPassword column to password to create the newly encrypted password column ---When a user REGISTERS, I enter the password value like so: HashBytes('MD5', @strPassword), ---When a user logs in, I check the password like so: AND strPasswordII= HashBytes('MD5',CONVERT(nvarchar,@strPassword) Here is my dilemma: For a new user nvarchar works on the log in (AND strPasswordII= HashBytes('MD5',CONVERT(nvarchar,@strPassword)) but on existing users, only varchar works. I have not been able to figure this out. Any suggestions would be greatly appreciated! 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:338513 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need assistance with hashbytes (kinda urgently..been at this since 6AM)
I insert the password like this: VALUES (@strUsername, HashBytes('MD5', @strPassword), I retrieve it on the log in like this: AND password= HashBytes('MD5',CONVERT(nvarchar,@strPassword)) the password column in a varbinary type On Sun, Oct 24, 2010 at 1:37 PM, Jochem van Dieten joch...@gmail.comwrote: On Sun, Oct 24, 2010 at 9:50 AM, Monique Boea wrote: 1. I saved the value of the password column (VARCHAR 200) to a new column for safe keeping 3. I saved the hashed value of the password column into this new hashedPassword column like so: UPDATE [prod].[dbo].[users] SET hashedPassword = HashBytes('MD5', password) So for your old users you have fed your HashBytes() function a varchar. ---When a user REGISTERS, I enter the password value like so: HashBytes('MD5', @strPassword), How is @strPassword defined? varchar or nvarchar? Are you using parameters in your call? Do you have string parameters as unicode enaled or not? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| 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:338515 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need assistance with hashbytes (kinda urgently..been at this since 6AM)
Oh sorry. I am using ASP for this one. But everything is done with a stored proc so I guess this is a SQL post. On Sun, Oct 24, 2010 at 2:09 PM, Jochem van Dieten joch...@gmail.comwrote: On Sun, Oct 24, 2010 at 10:52 AM, Monique Boea wrote: I insert the password like this: VALUES (@strUsername, HashBytes('MD5', @strPassword), I retrieve it on the log in like this: AND password= HashBytes('MD5',CONVERT(nvarchar,@strPassword)) That was in your previous post already. What is missing in your post is how you pass the variable from ColdFusion to the database and how your datasource is configured. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| 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:338519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Javascript and CF flash forms
Can javascript be used with CF flash forms? ~| 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:338506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Jr CF Developer needed for small company in Norcross (Atlanta)
Jr CF programmer needed for small, fast paced company in Norcross, GA to assist with QA, fixing errors and other tasks. Please send resumes and salary requirements to [EMAIL PROTECTED] Thank you. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3955 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Help with Custom Error Messages
I would like to display a custom error when a user's session expires? Any suggestions? Cancferrorbe used for this? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Help with Custom Error Messages
To display a custom error message? -Original Message- From: joe velez [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 8:10 AM To: CF-Talk Subject: Re: Help with Custom Error Messages maybe cfabort _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Help
Hey All, First, I'm posting this for a friend, so my knowledge is a bit limited. My colleague is trying to gauge how much interest there is in a ColdFusion and Crystal Enterprise Integration widget/web service/consulting. What he's explained is, that if you can do it in ePortfolio or the Crystal Management Console, it can be seamlessly integrated into your ColdFusion apps. No need for ASP or CSP. He also claims to be able to do this from CF4+ integrating with CE8+. I believe he is also working on a FuseBox implementation as well. I've gotten some tips from him on one of the projects I'm currently working on so I am completely confident in his ability to do what he claims. Is there anyone needing/wanting these functions/capabilities? Thanks in advance for the responses. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Immediate need for CF developer in Atlanta area...
Please respond if you're interested. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Help with accessing PDF files in DB
What is the best way to display a list of PDFs and allow a user to click on the link and open the PDF? Here is the current code: a href="" > openFile('#variables.sponsorreports_url#liability/#htmleditformat(qGetReport List.tFilename)#')#htmleditformat(qGetReportList.tFilename)#/a And it doesn't work. I get a page not found error... _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Help with accessing PDF files in DB
Here is the open file function...and this doesn't work either a href=""> #htmleditformat(qGetReportList.tFilename)#/a SCRIPT LANGUAGE=_javascript_ TYPE=text/_javascript_ !-- function openFile(URL) { leftpos = screen.width - 560 toppos = 20 open_window = window.open(URL,file,width=510,height=310,resizable=1,menubar=1,toolbar=1 ,screenX=+leftpos+,screenY=+toppos+,scrollbars=1,left=+leftpos+,top=+ toppos+); } function doDelete(URL1, URL2) { if(confirm(Do you want to download this file?)) { openFile2(URL2); } else { if(confirm(Delete file?)) { window.location=URL1; } } } function openFile2(URL) { leftpos = screen.width - 560 toppos = 20 open_window = window.open(URL,file,width=400,height=200); } function openProcWin(n,msg) { leftpos = screen.width - (screen.width*.6) toppos = screen.height - (screen.height*.75) ProcWin = window.open(_ProcessingRequest.cfm?PassedURL= + n + RequestName= + msg,ProcWin,width=325,height=150,resizable=0,menubar=0,toolbar=0,screenX= +leftpos+,screenY=+toppos+,scrollbars=0,left=+leftpos+,top=+toppos+ ); } //-- /SCRIPT I can't really say what is going wrong, as the openFile function is not in your code. Why don't you just put the url in the href and add target=_blank to see what happens. If you try to put the generated link directly in the browser, does it work? Pascal What is the best way to display a list of PDFs and allow a user to click on the link and open the PDF? Here is the current code: a href="" openFile('#variables.sponsorreports_url#liability/#htmleditformat(qGetReport List.tFilename)#')#htmleditformat(qGetReportList.tFilename)#/a And it doesn't work. I get a page not found error... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Help
Does anyone know what this error means? ByteArray objects cannot be converted to strings. Here is the code that generates it: cfif variables.action is add input type=radio name=bShow_General value=1 checked Yes input type=radio name=bShow_General value=0 No cfelse cfif variables.bShow_GeneralEQ 1or variables.bShow_General EQ input type=radio name=bShow_General value=1 checkedYes cfelse input type=radio name=bShow_General value=1Yes /cfif cfif variables.bShow_General EQ 0 input type=radio name=bShow_General value=0 checkedNo cfelse input type=radio name=bShow_General value=0No /cfif /cfif [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [OT] SQL help
what is OT? -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 4:22 PM To: CF-Talk Subject: [OT] SQL help Hi I have an table were our client save your dob(mm/dd/) in My$QL DB. By now I need to aggrupate that table queries like this: Group 1: = 16 years Group 2: =17 E = 25 Group 3: =26 E = 40 Group 4: =41 years My$SQL give the ages but how to aggrupate in that groups? Thanx for your time. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [OT] SQL help
Thanks :) -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Thursday, May 27, 2004 8:13 AM To: CF-Talk Subject: RE: [OT] SQL help Off Topic -Original Message- From: Monique Boea [mailto:[EMAIL PROTECTED] Sent: Thursday, May 27, 2004 8:11 AM To: CF-Talk Subject: RE: [OT] SQL help what is OT? -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 4:22 PM To: CF-Talk Subject: [OT] SQL help Hi I have an table were our client save your dob(mm/dd/) in My$QL DB. By now I need to aggrupate that table queries like this: Group 1: = 16 years Group 2: =17 E = 25 Group 3: =26 E = 40 Group 4: =41 years My$SQL give the ages but how to aggrupate in that groups? Thanx for your time. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFFILE
I have a CFFILE question: I have a form which allows a user to upload three different images at the same time I have three different cffile action="" tags on the processing page. The problem is it only uploads the very first image... Any suggestions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
It will upload one file at a time and not two or three together -Original Message- From: Monique Boea [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 10:03 AM To: CF-Talk Subject: CFFILE I have a CFFILE question: I have a form which allows a user to upload three different images at the same time I have three different cffile action="" tags on the processing page. The problem is it only uploads the very first image... Any suggestions? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
Combing the three into one cffile with a loop? -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 10:12 AM To: CF-Talk Subject: Re: CFFILE On May 26, 2004, at 10:06 AM, Monique Boea wrote: It will upload one file at a time and not two or three together Try doing a cfloop or cfoutput with cffile as the query name.I haven't tried it yet but it might work. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
cftry !--- upload new file --- cffile action="" filefield=form.tLogoFilename destination=#variables.home_dir#media\images\clientlogos\#variables.tLogoFi lename# nameconflict=overwrite cfcatch SCRIPT LANGUAGE=_javascript_ TYPE=text/_javascript_ alert(Error uploading Logo file.Please try again.); history.go(-1); /SCRIPT cfexit /cfcatch /cftry There is one for each image (3) -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 10:25 AM To: CF-Talk Subject: RE: CFFILE Can you post the code for the submission form? George At 10:20 AM 5/26/2004, Monique Boea wrote: Combing the three into one cffile with a loop? -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 10:12 AM To: CF-Talk Subject: Re: CFFILE On May 26, 2004, at 10:06 AM, Monique Boea wrote: It will upload one file at a time and not two or three together Try doing a cfloop or cfoutput with cffile as the query name.I haven't tried it yet but it might work. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
sorry, it's long form action="" method=post enctype=multipart/form-data validateform(); table width=600 cellpadding=0 cellspacing=0 border=0 tr td width=100 align=leftnbsp;/td td width=500 align=rightnbsp;/td /tr tr tdbLabel:/b/td tdcfoutputinput type=text name=tScreenLabel maxlength=100 size=50 value=#htmlEditFormat(variables.tScreenLabel)#/cfoutput/td /tr tr tdbLogo:/b /td tdcfoutputinput type=file name=tLogoFilename maxlength=50 size=50/cfoutput/td /tr tr td height=5 colspan=2nbsp;/td /tr trtd/td tdb class=mepImage size must be 187 X 62 (W x H) pixels /b /td /tr tr td height=10 colspan=2nbsp;/td /tr cfif variables.tLogoFilename is not '' tr td a href="" - /a /td td align=leftcfoutputimg src=""> /tr /cfif tr td colspan=2nbsp;/td /tr tr tdbHeader Background Image:br /b/td tdcfoutputinput type=file name=tHeaderBGFilename maxlength=50 size=50/cfoutput/td /tr trtd/td tdb class=mepImage size must be 36 pixels high (MAX) /b /td /tr tr td height=10 colspan=2nbsp;/td /tr cfif variables.tHeaderBGFilename is not '' tr td a href="" - /a /td td align=center height=36 cfoutput table border=0 cellpadding=0 cellspacing=0 width=300 tr td width=5img src=""> td width=20 valign=middle align=center = /td td width=* background=""> /tr /table /cfoutput /td /tr /cfif tr td height=20 colspan=2nbsp;/td /tr tr td colspan=2bHeader Color Code (EX: #12250P):/b cfoutput input type=text name=tHeaderBGColor value=#variables.tHeaderBGColor# maxlength=50 size=10/cfoutput /td /tr tr td colspan=3a href="" here to open color chooser./a/td /tr tr td height=20 colspan=2nbsp;/td /tr cfif variables.tHeaderBGColor is not '' tr td colspan=2 cfoutputbgcolor=#variables.tHeaderBGColor#/cfoutput width=10nbsp;/td /tr /cfif tr td colspan=2nbsp;/td /tr tr tdbHeader Foreground Image:/b/td tdcfoutputinput type=file name=tHeaderFGFilename maxlength=50 size=50/cfoutput/td /tr trtd/td tdb class=mepImage size must be 36 pixels high (MAX) /b /td /tr tr td height=10 colspan=2nbsp;/td /tr cfif variables.tHeaderFGFilename is not '' tr td a href="" - /a /td td align=centercfoutputimg src=""> /tr /cfif tr td colspan=2nbsp;/td /tr tr tdLink 1 Label:/td tdcfoutputinput type=text name=tURL1label maxlength=100 size=50 value=#htmlEditFormat(variables.tURL1Label)#/cfoutput/td /tr tr tdLink 1:/td tdcfoutputinput type=text name=tURL1 maxlength=200 size=30 value=#htmlEditFormat(variables.tURL1)#/cfoutput http://www.balser.com /td /tr tr td colspan=2nbsp;/td /tr tr tdLink 2 Label:/td tdcfoutputinput type=text name=tURL2label maxlength=100 size=50 value=#htmlEditFormat(variables.tURL2Label)#/cfoutput/td /tr tr tdLink 2:/td tdcfoutputinput type=text name=tURL2 maxlength=200 size=30 value=#htmlEditFormat(variables.tURL2)#/cfoutput http://www.balser.com /td /tr tr td colspan=2nbsp;/td /tr tr tdLink 3 Label:/td tdcfoutputinput type=text name=tURL3Label maxlength=100 size=50 value=#htmlEditFormat(variables.tURL3Label)#/cfoutput/td /tr tr tdLink:/td tdcfoutputinput type=text name=tURL3 maxlength=200 size=30 value=#htmlEditFormat(variables.tURL3)#/cfoutput http://www.balser.com td /tr tr td colspan=2nbsp;/td /tr tr td colspan=2 align=center brbrinput type=submit value=Submitnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; input type=button value=Cancel > cfoutput input type=hidden name=action value=add_edit input type=hiddenname=editflag value=#variables.editflag# input type=hidden name=textension value= input type=hidden name=tBGextension value= input type=hidden name=tFGextension value= /cfoutput /td /tr /table /form [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
My CFFILE issue is resolved. The previous developer defined the file extensions as hidden values and passed them as and it was not recognizing the other two file extensions. So my images were being uploaded without the .gif or .jpg Why he'she wouldn't just upload the file name, I don't know... But I resolved it with the following: cfset variables.textension = Right(form.tLogoFilename,3) -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 2:25 PM To: CF-Talk Subject: RE: CFFILE http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p35.htm#wp35 40091 I am not at all saying you are wrong. As I said, I haven't tried it with a filename. Pascal Wierd.I'm looking at the MX reference, as well --BenD _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
YIKES!! -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 3:30 PM To: CF-Talk Subject: RE: CFFILE From: Monique Boea cfset variables.textension = Right(form.tLogoFilename,3) Be careful about this - some people save images as .jpeg _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
So what's the alternative? -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 3:30 PM To: CF-Talk Subject: RE: CFFILE From: Monique Boea cfset variables.textension = Right(form.tLogoFilename,3) Be careful about this - some people save images as .jpeg _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
ACtually, there is _javascript_ on the previous page that forces a three digit file extension. (BOOYAH!!) :) -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 3:30 PM To: CF-Talk Subject: RE: CFFILE From: Monique Boea cfset variables.textension = Right(form.tLogoFilename,3) Be careful about this - some people save images as .jpeg _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
full-stops? -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 3:45 PM To: CF-Talk Subject: RE: CFFILE From: Tony Weeg yeah, you might want to to a cfset variables.textension = listFirst(form.tLogoFilename ,'.') or some variation of those arguments inside the function.. Don't you mean ListLast()? Some lovely people put full-stops in their file names as well _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: sorry. cfmx exam guy.
That's cool Vishnu, pay it forward! -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 10:35 AM To: CF-Talk Subject: sorry. cfmx exam guy. hey, one last email, thank you everyone for helping vishnu. he now owns a fully legal, licensed copy of cfmx exam buster. cheers. good karma, it sure goes a long way ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Can anyone answer this?
Hello everyone, I have been in business a little over two years now, and by the grace of God and much hard work, our client base has grown beyond metro Atlanta.I deal with a lot of email attachments of accounting software files, excel files, and word files.But the attachments are starting to clog my email system and I'm thinking about setting up an area on my website for my clients to login and upload/download/view their files. Can anyone tell me the pros and cons to this option (security, corruption of files, etc.)?Are their better options available? Thanks a mil! -Original Message- From: Rob [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 10:25 AM To: CF-Talk Subject: Re: Java CFX tag not found Hi Greg, On Mon, 2004-05-24 at 07:00, Greg Bullough wrote: I have a Java custom tag CFX_ImageSize The one I wrote or a different one? which I'm trying to get to work on an MX 6.1 Enterprise system (Linux) If the one I wrote, make sure XWindows is installed or the tag will probably fail I have dutifully copied the ImageSize.class file into /opt/coldfusionmx/cfx/java directory and then registered the tag into the Java database I don't think /opt/coldfusionmx/cfx/java is in the classpath by default you can try to add the path (in administrator under java there should be like an additional class path put the full path to the jar there), or you can add it to a path already used by cf. I can't recall the path off hand... /opt/coldfusionmx/wwwroot/WEB-INF/classes? Someone here knows... paying careful attention to case. I've made sure that the class that implements the function is ImageSize. I tried adding that directory path to the ClassPath in the CF administrator. Ok never mind that last suggestion :-/ (unless you didn't go all the way to the .jar - /blarg/booga/yadda/super.jar) No matter, when I call either CFX_ImageSize or cfx_ImageSize, I always get the response: The CFX custom tag CFX_ImageSize was not found in the custom tag database. Please be sure to add custom tags to the database before using them. If you have added your tag to the database then you should check the spelling of the tag within your template to insure that it matches the database entry. I assume you did all these (this is for non-enterprise) http://www.rohanclan.com/library/cfxImageSize.cfm Because it really sounds like it's not being loaded. Just so you know, if it is indeed the one I wrote, it's not supported on linux (but it should work if Xwindows is installed), if it's not the one I wrote... figure it out yourself ;) Has anybody had any success with solving this problem? MM is characteristically silent to the cries of the poor users on this issue. I think it's just a matter of getting it in the right place -- Rob [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: an Idea
:) -Original Message- From: G [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 12:07 PM To: CF-Talk Subject: Re: an Idea Thats a good idea. At the same time, i'd also like to give to the fund set up for the thousands of US IT professionals who are out of work because their jobs were shipped to India. Can someone point me to that fund? Thanks! - Original Message - From: Tony Weeg To: CF-Talk Sent: Monday, May 24, 2004 10:48 AM Subject: an Idea was: (RE: CFMX Certification) Ive got an idea, lets set up a fund, to get him the exam? sound like a plan? ill kick a coupla bucks. if you want to, and we can somehow get him the exam, send donations to [EMAIL PROTECTED], paypal, and ill buy it for him and email him the program and the keys to unlock. tony snip _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX Certification
Just a thought - If I borrowed a book or a CD from someone, is that stealing? -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 1:12 PM To: CF-Talk Subject: RE: CFMX Certification Allan, F off! The guy was trying to steal. Is it OK to steal if you're poor? OK to rape someone if you haven't had sex in a long time? Where do you draw the line? Greg -Original Message- From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 11:14 AM To: CF-Talk Subject: Re: CFMX Certification There are certain people on the list that replied earlier that need to realise that not everyone can pay for software. Some countries pay peanuts to their programmers. Hence Linux and other free programs. They showed no respect to Vishnu and should ethically have NOT written to the list and politely replied to him in private. Personally I think it is disgusting the way he was treated. And I demand an apology on his behalf. Allan - Original Message - From: Massimo Foti To: CF-Talk Sent: Monday, May 24, 2004 4:15 PM Subject: [cftalk] Re: CFMX Certification But regardless of your salary, this is certainly not the place to come and ask for someone to pirate software! The authors of CFMX Exam Buster participate in this list I believe. I am not condoning any kind of piracy (here or anywhere else). I just tried to explain that my reply was born out of the understanding that there are people out there who have to think twice before investing an amount of money that seems trivial to most of us. Ence why I suggested a different, legal and honest approach to Vishnu. Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX Certification
It seems to be OK to steal from others depending on who it is and what you're taking Let's no go back in the history of the world and talk about stealing, which is maybe why the salaries are so low in India anyway. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 1:16 PM To: CF-Talk Subject: RE: CFMX Certification napster.kazaa. some schtuff different media. its ok, but not ok. right? -Original Message- From: Monique Boea [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 1:14 PM To: CF-Talk Subject: RE: CFMX Certification Just a thought - If I borrowed a book or a CD from someone, is that stealing? -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 1:12 PM To: CF-Talk Subject: RE: CFMX Certification Allan, F off! The guy was trying to steal. Is it OK to steal if you're poor? OK to rape someone if you haven't had sex in a long time? Where do you draw the line? Greg -Original Message- From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 11:14 AM To: CF-Talk Subject: Re: CFMX Certification There are certain people on the list that replied earlier that need to realise that not everyone can pay for software. Some countries pay peanuts to their programmers. Hence Linux and other free programs. They showed no respect to Vishnu and should ethically have NOT written to the list and politely replied to him in private. Personally I think it is disgusting the way he was treated. And I demand an apology on his behalf. Allan - Original Message - From: Massimo Foti To: CF-Talk Sent: Monday, May 24, 2004 4:15 PM Subject: [cftalk] Re: CFMX Certification But regardless of your salary, this is certainly not the place to come and ask for someone to pirate software! The authors of CFMX Exam Buster participate in this list I believe. I am not condoning any kind of piracy (here or anywhere else). I just tried to explain that my reply was born out of the understanding that there are people out there who have to think twice before investing an amount of money that seems trivial to most of us. Ence why I suggested a different, legal and honest approach to Vishnu. Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: new member: web fetching
More specifically please... :) -Original Message- From: Whittingham, P [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:45 AM To: CF-Talk Subject: RE: new member: web fetching cfhttp. Pat -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 8:39 AM To: CF-Talk Subject: new member: web fetching Hello all, I'm new to the group and coldfusion in general.I've been tinkering around with server side scripting for awhile but coldfusion is all new to me.My employer got me involved with some free classes, and I'm very intrigued at how easy this is to learn. Anyway, now my question.How would one fetch content from another webpage on the server. For example, grab a weather map from weather.com and cache it on my server.I can figure out the display and updating part.Just not sure how to grab the file to save it in the first place. I'm running MX 6 if it makes any difference. -mike _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX Hosting Providers
www.adonaihosting.com They don't charge extra for CF 5 or MX hosting and have very reasonable pricing. -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 9:32 AM To: CF-Talk Subject: CFMX Hosting Providers Looking to change shared hostswho do you recommend and why? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX Hosting Providers
www.adonaihosting.com good service, good pricing, good support -Original Message- From: Jeff Britts [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 11:11 AM To: CF-Talk Subject: Re: CFMX Hosting Providers Looking to change shared hostswho do you recommend and why? Any one using a reseller package they are happy with? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Spam and Viruses
This is off the subject of CF but maybe someone has a solution. I get TONS of spam and viruses in my mailbox on a daily basis...so much that I am thinking of changing my email address. Is there ANY way to stop this? Do people target specific email addresses to send viruses to? (Don't worry, it not this email address) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Spam and Viruses
No I don't mean on this email address...I mean another one... Nothing to do with this email list -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 11:56 AM To: CF-Talk Subject: RE: Spam and Viruses One of the reasons you are being spammed is the way the list broadcasts emails FULLY on the webtry searching for someones in Google and you will see that you get loads of houseoffusion results with full emails to be hived off ready for spamming... No real way to stop them bar hunting down the retards who spend time setting them up etc.you could get aspamcatching engine to sit in front of your mail server (if on exchange etc) which will reduce it dramaticallyas I used to get around 200-300 per day, now you wil be lucky if I get 10 a week... _ From: Monique Boea [mailto:[EMAIL PROTECTED] Sent: 18 May 2004 16:53 To: CF-Talk Subject: Spam and Viruses This is off the subject of CF but maybe someone has a solution. I get TONS of spam and viruses in my mailbox on a daily basis...so much that I am thinking of changing my email address. Is there ANY way to stop this? Do people target specific email addresses to send viruses to? (Don't worry, it not this email address) _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Spam and Viruses
the address is [EMAIL PROTECTED] -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 1:28 PM To: CF-Talk Subject: RE: Spam and Viruses At 02:25 PM 5/18/2004, Thane Sherrington wrote: I just tried that - [EMAIL PROTECTED] comes up with no hits on Google.Nor does [EMAIL PROTECTED]I don't think she's getting spam that way. I take it back - [EMAIL PROTECTED] comes up with a lot of hits.So maybe some spam is coming through that way. T _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]