SOLR config in CF10
The Adobe docs say that in order to configure SOLR (as in upping the memory available to it) in CF10 one needs to edit the solr.lax file. Problem is, I don't have a solr.lax file anywhere on the server. Does anyone know the name/location of the actual file to do configurations? Thanks in advance, Les ~| 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:360304 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Hotfix 16, CF10
Just applied hotfix 16 to CF10, now the application service won't start. The event log reveals this info Can't start ColdFusion Application Service. The description for Event ID 259 from source ColdFusion 10 Application Server cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. Any insight on this? Thanks in advance for any help. Les ~| 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:360266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFthread
Let's say I declare a series of CFthreads on a single page. These will process serially, not concurrently, right? What if one fails? Do the subsequent threads die with it, or do they continue to process after the failed one craps out? And, is there a way to control/choose either of these behaviors? Thanks in advance, Les ~| 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:359901 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Running Command line stuff...
I've searched and found a dozen ways to run a command line application via ColdFusion, none of which seem to work. Can anyone show me the right way? I want to run a program called ffmpeg.exe from the command line. The code I need to execute is something like this: ffmpeg -i input.jpg -vf scale=iw*min(1200/iw\,800/ih):ih*min(1200/iw\,800/ih),pad=1200:800:(1200-iw)/2:(800-ih)/2 img010.jpg How can I do this within CF? Thanks in advance for any help! Les ~| 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:359899 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Picasa and CF
I'm trying to write a CF script to automate the creation of a photo slideshow video in Picasa. I want to programatically take, say, a folder of JPGs, convert them to a slideshow video, and upload the result to YouTube - without any human intervention. Has anyone had any experience with the Picasa api to know if this is possible? Thanks in advance for any help, Les ~| 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:359858 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
FileExists() stops working
Weird. Last night I did the latest hot fix update to Cold Fusion on the server and now all my FileExists() tags are failing. Could be totally unrelated, of course, but does anyone know what file the FileExists() code resides in (I assume somewhere in CFIDE)? Perhaps that particular file got corrupted during the hot fix. Thanks in advance, Les ~| 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:355736 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
strange error message
Got this error when trying to pull up the CF Administrator. Any ideas what's up? HTTP Error 500.0 - coldfusion.server.SecurityService.removeAuthenticated()V Thanks, Les ~| 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:355529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
JSON to CF variable?
Taking this JSON result from Google: http://maps.googleapis.com/maps/api/geocode/json?address=34.172684,-104.604794sensor=false How would I address the formatted_address result as a CF variable? I've gotten this far: cfhttp method=Get url= http://maps.googleapis.com/maps/api/geocode/json?address=34.172684,-104.604794sensor=false; cfset theData=DeserializeJSON(cfhttp.FileContent) cfdump var=#theData# ...but then I'm stuck. I need #whatevergoeshere# = County Road 1-11, Yeso, NM 88136, USA Many thanks in advance for the help, Les ~| 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:354527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
debugging output
I just recently moved to a dedicated server after years of slumming in a shared environment. Relatively painless so far except for the debugging stuff. I'm used to the Error Executing Database Query.You have an error in your SQL syntax...blah blah type messages coming up on errors, but now all I get is a blank 500 - Internal server error page, despite trying any/every debugging combination known to mankind in the CF Administrator. Any idea what I may be doing wrong? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354216 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Convert JS variable to URL variable for AJAX function
I know this isn't technically a CF question (even though I'm using CF), but I need some help putting a JS variable into a URL string to perform an Ajax hit. It will probably take someone smarter than me about 2 minutes to figure out, please contact me off-list if you think you can help. I'll make a Paypal donation to the one who solves it for me. Thanks, Les ~| 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:353800 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Converting JS variable to CF variable
I don't know diddly squat about javascript. But I want to take a JS variable, such as those addressed in this alert: alert(Your coordinates are + position.coords.latitude + , + position.coords.longitude); and use it as a CF variable elsewhere on the page, like #position.coords.latitude# (of course this doesn't work). Can anyone shed some light for me? Thanks, Les ~| 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:353486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
High school algebra problem
Not exactly a CF question per se, sorry... but... I'm trying to write a formula in CF and my algebra skills are rusty. I'm working with a real estate MLS system that divides their online photos, sequentially, into 256 different directories - numbered 1 through 256. When they get up to directory 256, they start back again at 1. When I asked for a reference table, they explained we don't have one, it just happens automatically. Trouble is, I need to automatically find the photos armed only with the property number. For example (actual data): property #794622 is placed in directory 254. property #794623 is placed in directory 255. property #794624 is placed in directory 256. property #794625 is placed in directory 1. property #794626 is placed in directory 2. property #794627 is placed in directory 3. ...and on and on sequentially... What formula can I use that will allow me to take any property number (say 45 or 1023465 or 332495845745, etc, etc...) and find its corresponding directory number? Thanks in advance for indulging me on this one... Les ~| 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:351138 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: High school algebra problem
Problem is, I don't have access to the server other than to reference it. They have a server that hosts the photographs, and another server that hosts the html. So I can only reference the photos using a full URL from another server entirely. On Mon, May 14, 2012 at 2:10 PM, Christopher Watson skyg...@gmail.com wrote: Hmmm... would it possible to just use the cfdirectory tag's list action on the root directory, with recurse=yes, type=file, and filter attribute? If all of the file names are of a consistent format, you could probably just find the right file with that one tag, knowing the property number. -Christopher Not exactly a CF question per se, sorry... but... I'm trying to write a formula in CF and my algebra skills are rusty. I'm working with a real estate MLS system that divides their online photos, sequentially, into 256 different directories - numbered 1 through 256. When they get up to directory 256, they start back again at 1. When I asked for a reference table, they explained we don't have one, it just happens automatically. Trouble is, I need to automatically find the photos armed only with the property number. For example (actual data): property #794622 is placed in directory 254. property #794623 is placed in directory 255. property #794624 is placed in directory 256. property #794625 is placed in directory 1. property #794626 is placed in directory 2. property #794627 is placed in directory 3. ...and on and on sequentially... What formula can I use that will allow me to take any property number (say 45 or 1023465 or 332495845745, etc, etc...) and find its corresponding directory number? Thanks in advance for indulging me on this one... Les ~| 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:351143 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: High school algebra problem
Cool, the MOD thing sounds promising! I'll give it a shot. On Mon, May 14, 2012 at 2:19 PM, Les Irvin les.cft...@gmail.com wrote: Problem is, I don't have access to the server other than to reference it. They have a server that hosts the photographs, and another server that hosts the html. So I can only reference the photos using a full URL from another server entirely. On Mon, May 14, 2012 at 2:10 PM, Christopher Watson skyg...@gmail.com wrote: Hmmm... would it possible to just use the cfdirectory tag's list action on the root directory, with recurse=yes, type=file, and filter attribute? If all of the file names are of a consistent format, you could probably just find the right file with that one tag, knowing the property number. -Christopher Not exactly a CF question per se, sorry... but... I'm trying to write a formula in CF and my algebra skills are rusty. I'm working with a real estate MLS system that divides their online photos, sequentially, into 256 different directories - numbered 1 through 256. When they get up to directory 256, they start back again at 1. When I asked for a reference table, they explained we don't have one, it just happens automatically. Trouble is, I need to automatically find the photos armed only with the property number. For example (actual data): property #794622 is placed in directory 254. property #794623 is placed in directory 255. property #794624 is placed in directory 256. property #794625 is placed in directory 1. property #794626 is placed in directory 2. property #794627 is placed in directory 3. ...and on and on sequentially... What formula can I use that will allow me to take any property number (say 45 or 1023465 or 332495845745, etc, etc...) and find its corresponding directory number? Thanks in advance for indulging me on this one... Les ~| 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:351144 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: High school algebra problem
right... sorry to be unclear on that. On Mon, May 14, 2012 at 2:22 PM, Wil Genovese jugg...@trunkful.com wrote: Ah, so you're accessing the MLS's Photo server? Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On May 14, 2012, at 3:19 PM, Les Irvin wrote: Problem is, I don't have access to the server other than to reference it. They have a server that hosts the photographs, and another server that hosts the html. So I can only reference the photos using a full URL from another server entirely. On Mon, May 14, 2012 at 2:10 PM, Christopher Watson skyg...@gmail.com wrote: Hmmm... would it possible to just use the cfdirectory tag's list action on the root directory, with recurse=yes, type=file, and filter attribute? If all of the file names are of a consistent format, you could probably just find the right file with that one tag, knowing the property number. -Christopher Not exactly a CF question per se, sorry... but... I'm trying to write a formula in CF and my algebra skills are rusty. I'm working with a real estate MLS system that divides their online photos, sequentially, into 256 different directories - numbered 1 through 256. When they get up to directory 256, they start back again at 1. When I asked for a reference table, they explained we don't have one, it just happens automatically. Trouble is, I need to automatically find the photos armed only with the property number. For example (actual data): property #794622 is placed in directory 254. property #794623 is placed in directory 255. property #794624 is placed in directory 256. property #794625 is placed in directory 1. property #794626 is placed in directory 2. property #794627 is placed in directory 3. ...and on and on sequentially... What formula can I use that will allow me to take any property number (say 45 or 1023465 or 332495845745, etc, etc...) and find its corresponding directory number? Thanks in advance for indulging me on this one... Les ~| 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:351147 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
XML and unicode: 0x1a
Apparently, after a billion hours of trying to figure out why I couldn't successfully output some xml data, it seems that the unicode: 0x1a character is contained in a text string and making it fail. #xmlformat(thestring)# does not successfully strip it from the string. How can I get rid of that character? Must be some sort of replace(thestring,'0x1a','','all') thing but i can't figure out how to reference it. Thanks in advance for any help, Les ~| 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:350072 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
emailing a cfchart?
Is it possible to have cfchart code (format=png or jpg) within a cfmail tag and have the graphic actually show up in the email? I can't seem to manage it... Thanks in advance for any help, Les ~| 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:349981 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Replace double quotations
I'm trying to use replace() to edit a string with double quotation marks in it. For example, I want to change: this is fubar to this is fubar But I can't seem to figure out how to escape the quotes. Thanks in advance for any help, Les ~| 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:349292 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Event gateway, cfmail?
I am familiar with those, but how could I use them to effectively create an immediate dynamic autoresponder? Wouldn't I have to set something up to initiate the polling of the mailbox? On Sat, Oct 15, 2011 at 1:42 AM, Mike Chabot mcha...@gmail.com wrote: Are you familiar with the cfpop and cfimap tags? These are probably the easier route to a solution that using the event gateway feature. I will assume you are already familiar with cfmail to send mail. -Mike Chabot On Sat, Oct 15, 2011 at 1:26 AM, Les Irvin les.cft...@gmail.com wrote: I want to be able to receive an email, immediately do a database hit to retrieve info, then auto-respond to the email (in real time) with some results of the db query. Possible? I know basically nothing about gateways but perhaps therein lies my solution? If anyone could point me in the right direction I would be very grateful. Thanks, Les ~| 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:348188 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Event gateway, cfmail?
I want to be able to receive an email, immediately do a database hit to retrieve info, then auto-respond to the email (in real time) with some results of the db query. Possible? I know basically nothing about gateways but perhaps therein lies my solution? If anyone could point me in the right direction I would be very grateful. Thanks, Les ~| 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:348175 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
left, right, mid? (no political content)
Let's say I have a number of strings as such: xx123_23 xx37465_2345 xx2_12 xx21_4374837438 xx4655_432 all have xx at the beginning and then an underscore somewhere beyond that. With such random and varied lengths, how do I return the following strings: 1) only the digits between the xx and the _ 2) only the digits after the _ Thanks in advance for your help! Les ~| 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:346526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
replace function
How can I convert this string: bob,carol,ted,alice to this: bob,carol,ted,alice my replace() skills are not up to snuff... many thanks, Les ~| 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:343625 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Removing duplicates from a value list
What's the easiest way to remove dupes from a value list? I want to turn, say, this: History,Recreation,History,Music,Architecture,History,Recreation,Music into this: History,Recreation,Music,Architecture Thanks in advance for your help, Les ~| 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:343617 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
html to pdf... again.
This should be easy. I'm working on a site to allow real estate agents to tweak a brochure on-line, then save it as a PDF. All I want to do is take the resulting page of html, convert it exactly as it looks in the browser to a PDF file (including colors, backgrounds, images, formating, etc.), then print the sucker using the PDF they've created. CFdocument and all its children are producing horrible results and causing me to pull out what little hair I have left. Is there anyway to do this within CF, or do I need to look elsewhere? Thanks, Les ~| 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:340888 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: html to pdf... again.
Are there innumerable options and settings needed within the CFdocument tag, or it just simply wrapping that sucker within the simple tag and going for it? Background colors and css is all preserved? On Fri, Jan 14, 2011 at 1:33 PM, Robert Harrison rob...@austin-williams.com wrote: We've done this a few times. If you're using advanced CSS and divs in the HTML layout, the results when you go to CFPDF can be tricky. We've found if you generate more rigid old style HTML tables the results on going to PDF are more predictable. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340894 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Gmail/Facebook Style jQuery Chat
Does anyone know if there is there any CF-based version of something like this available? http://anantgarg.com/2009/05/13/gmail-facebook-style-jquery-chat/ Thanks, Les ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334635 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Convert image to its negative
Does anyone know of a CF custom tag that will convert an image to its negative? For example, converting a medical x-ray image to its positive, etc. Thanks in advance for any help, Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:08 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Joni Mitchell and Cold Fusion
Help me, I think I'm falling... here's an odd request for a certain individual. Joni's official site is hosted on a GoDaddy server (don't ask) running CF8. They keep shutting it down for overloading the server - asking me to streamline the code to avoid continued violations. I'm sure my code sucks, but it's been on other servers without issue from those hosts. Would anyone out there, perhaps a Joni fan, volunteer to take a look at some code, shake their head in disgust at the awfulness of it, and help me rewrite inefficient sections? This feels a bit like walking naked through a crowd, but hey In return, I'll put a link to whatever site you want in the footer of every page, and of course you'll have the satisfaction of helping out all the Joni fans across the globe. The site gets about 2500 unique visitors a day. http://jonimitchell.com Thanks in advance, Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Ajax, Json, and two clueless programmers
I'm doing a project with another guy. He knows ajax and json and is clueless about Cold Fusion. I claim to know CF and probably don't even know what ajax and json stand for. We, needless to say, are having problems communicating. So here's the problem. I hit the database and give him some data that plots a couple properties on a google map. When any of those mapped properties are clicked, his code (json?) uses this (example) bit of database info to display info about the property on the same page without a refresh: houseDetails = {address : 1970 ST CHESTER AURORA, 80010, price : 45000,listingNum : 833553, office : 303-487-0777 }; Clicking another property on the map grabs the above info on the clicked property and again - without refresh - displays it, replacing the old info. The returned info (price, for example) displays great with ID numbers in a table as such: td id=price/td or like this p id=price/p... but how the heck do I use it in a URL and (most importantly) pass other variables with it, for example: a href=?from=doitprice=PRICEVARIABLEHERE and have that link info change without refresh right along with the rest of the page? We both thank you in advance and owe you a beer. Or two. Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332395 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
listgetat problem...
Hi all - I'm trying to (unsuccessfully) import a comma delimited text file (from an MLS service) into a MySQL db and looping over the file using listgetat in this manner: ... '#listgetAt('#index#',4, ',')#', '#listgetAt('#index#',5, ',')#', '#listgetAt('#index#',6, ',')#' ... I'm suspecting that the format of the text file is breaking my code. Here's a sample of the text file. RES,A,AUN,776082,877,,ST,RACINE,HOFFMAN TOWN,80011,3,2,RES,1051,,,KELLER WILLIAMS REALTY LLC,CHARMING RANCH STYLE HOME, 3 BEDROOMS, 2 FULL BATHS, CONCRETE EXTENDED DRIVEWAY (ISSUES), NO FHA !!,5AURO,1681, Note that text items have quotes around them and number items don't. Also, text items can and do include commas within. Am I improperly using the listgetat function? If so, how can I rewrite it to get around these issues? Many thanks in advance, Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331764 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Random question
How would I come up with a 4-character random string consisting of any letter or number? 1k3d, e4rf, 69e4, dfje, 3967, etc... Thanks in advance for your help, Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330551 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Parsing a geocode response
I'm rather lousy at the whole string parsing thing... how would I separate this example response from the google geocoder api into two values? Problem (for me) is that one cannot count on a set number of digits returned after the decimal. (38.780144, -104.815308) Any help would be greatly appreciated. Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330163 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
meta tag location
I usually put a few meta tags in the application.cfm file, and a few more on the individual pages. Is there any danger to not keeping all the meta tags in one place? A client claims their google ranking has fallen since this has been done. Thanks, Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329446 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Form validation question
I'm working on a site where people register and choose their own username. In the registration form I'd like to, onBlur from the username field, immediately check to see if that username is already in use and if so, trigger an alert that returns them to the field. What's the best way to do this? Thanks in advance for any help. Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327258 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Adnin question, or The GoDaddy Hosting Blues
GoDaddy recently installed CF8 on some of their servers, and a few things have changed. Now, validity checks are not working on cfform tags on their aliased domains. If the URL is http://AliasedDomain.com/PageWithTagOnIt.cfm, all validity checks fail. If the URL (to the identical file) is http://TopDomain.com/AliasedDomain/PageWithTagOnIt.cfm, all validity checks work. This error never occurred on GoDaddy's previous CF installations. So, isn't this a path setting they have misconfigured in the CF Admin on their new installations? Tech support tells me that I need to correctly reference my scripts. I tell them, no, THEY need to correctly reference their scripts. I'm not referencing scripts, I'm using tags. Their CF installation is doing the referencing. Does anyone know of the solution to this? What needs to be changed in their CFAdmin configurations (I know little about the administrator)? Or am I the idiot here? Thanks in advance, Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Form field auto-fill, auto-eliminate from query
Can CF do this? I have a database of, say, 1000 song titles. I want a user to be able to input one of those song titles into a form. A select box with 1000 options is pretty unwieldy. Can CF eliminate irrelevant songs as the user types? For example: User types B, only those titles starting with B now show in the dropdown. User types o, only those titles starting with Bo now show in the dropdown. User types t, only those titles starting with Bot now show in the dropdown. etc, etc, etc... I'm trying to prevent the user having to type the whole title AND force the title to be spelled/cased exactly as it already is in the database. Thanks in advance for any help, Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326075 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
return current page?
What function would I use to call the current page? I want to return index.cfm from an include on the index.cfm page. Thanks, Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325309 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfinput question
I'm using the cfinput type=file tag to upload pdfs to the server. Is there a way in Cold Fusion to, when the file upload / browse dialog comes up, restrict it to only show pdf files? Or is that an operating system / java / something else function? Thanks in advance, Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324130 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfinput question
At the risk of exposing my ignorance, isn't cffile a server-side operation? I'm needing a client side filter, basically. On Wed, Jul 1, 2009 at 2:27 PM, sam Detweilersdetw...@gmail.com wrote: how about cffile action=upload accept = application/pdf ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324132 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFInvoke question
The server I'm working on has the 'CreateObject' function disabled. I was told to use cfinvoke instead. What would the following code look like, then, if wrapped in a cfinvoke statement?: cfscript imgObj=CreateObject(component, tmt_img); imgObj.resize(#cffile.serverFile#, #form.id#.jpg, 250); /cfscript Many thanks, Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324022 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
GoDaddy, Access DBs, and cfinsert/cfupdate
I'm porting a website for a client over to GoDaddy from another server. Using cfinsert/cfupdate tags to manipulate Access databases. When trying to insert/edit more than a few sentences of data into a memo field, it causes an error on the GoDaddy server: Error Executing Database Query. Application uses a value of the wrong type for the current operation. GoDaddy, of course, will not enable Robust Exception Information so that's all I get. What works perfectly on the other server fails on GoDaddy. Both are CF7. Any ideas? Thanks in advance, Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324012 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Sorting cfsearch results
Is it possible to sort cfsearch results by one of the custom fields specified in the cfindex tag? Or can the results only be ordered by relevancy? How would one go about sort on a custom field? Thanks in advance, Les ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319911 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Writing xml
I'm trying to have CF write a painfully simple xml file, basically just a list of sequentially numbered image tags. I keep getting this error: The markup in the document following the root element must be well-formed. Can anyone help? Thanks, Les cfxml variable=GalDoc ?xml version=1.0 ? cfloop index=LC from=1 to=20 cfoutput img src=../160_#z#.jpg width=540 height=360 / cfset z=z+1 /cfoutput /cfloop /cfxml cffile action=write file=#directory#gallery.xml output=#ToString(GalDoc)# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318120 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Passing client file name in a form?
Probably something simple I'm overlooking here... but I'm trying to pass the actual client location of a file through a form. For example, the user browses for a photo: cfinput type=file name=g1 input value=submit photo type=submit Then submits the form. The variable #form.g1# ends up being something like C:\CFusionMX7\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp47723.tmp rather than, say, C:\users\bob\documents\photo.jpg like I want it to be. How can I pass the physical client location of the file through the form? Thanks in advance for any help. Les ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310040 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Passing client file name in a form? one more thing
I failed to mention that I do not want to upload the file to the server, but only to grab the location so I can use it as an attachment in a cfmail tag. Probably something simple I'm overlooking here... but I'm trying to pass the actual client location of a file through a form. For example, the user browses for a photo: cfinput type=file name=g1 input value=submit photo type=submit Then submits the form. The variable #form.g1# ends up being something like C:\CFusionMX7\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp47723.tmp rather than, say, C:\users\bob\documents\photo.jpg like I want it to be. How can I pass the physical client location of the file through the form? Thanks in advance for any help. Les ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310041 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Generating unique random numbers
Is there a slick way to do this in CF? Let's say I have a set of records - one field of which is for a unique and random 6 digit number. When adding a new record, what the best way to assign its random number that's not already assigned to another record? Thanks in advance, Les ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298747 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFFORM problem
Today I moved a site from one CF8 server to another CF8 server. Suddenly, all the cfform validity checks that were working on the previous server now fail on the new server. Is there some setting in Adminstrator that may possibly be making this happen? Anything else that it could be? It's the exact same page that it was on the other server. http://71.5.111.207/register.cfm Thanks in advance for your help. Les ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298684 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Catching referring domain in CF?
Is there a way to pass a variable with the domain name only from the referring page to a target page using CF? For example, how can I pass (or extract) just houseoffusion.com to the target page when coming from http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm; Thanks in advance for your help, Les ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291156 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: weather module
I'm looking for a weather module to display on a real estate website. Must be compatible with CF query data such as a zip code. Weather.com's module is not flexible enough. Has any one found any such animal? Thanks in advance, Les ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272416 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Querying a delimited text field
Novice question here. I need to write a query to find a single integer in a field of delimited integers, say 23,25,27,29. How is this done in Cold Fusion? FindOneOf? FindNoCase? Can anyone advise? Thanks in advance for any help, Les ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267834 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Querying a delimited text field
I'm trying to find it using sql within a cfquery tag, that's why I'm stumped. On 1/27/07, Jim Wright [EMAIL PROTECTED] wrote: Les Irvin wrote: Novice question here. I need to write a query to find a single integer in a field of delimited integers, say 23,25,27,29. How is this done in Cold Fusion? FindOneOf? FindNoCase? Can anyone advise? In CF, you would probably use ListFind...but are you trying to find this on the CF side, or in your database query? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267837 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Querying a delimited text field
Yes, querying an Access DB to find it. This is my current (lousy and failing) code for attempting it: CFQUERY NAME=names DATASOURCE=#DB_redwood# SELECT distinct lname, fname, artist_id FROM photos, photographers WHERE #find(themes.id,[photos.theme_id])# 0 and photographers.id = photos.artist_id order by lname /CFQUERY photos.theme_id is the delimited field. On 1/27/07, Dave Phillips [EMAIL PROTECTED] wrote: Les, Are you writing a query to find this in a database? If so, what db are you using? Or, are you just trying to use CF code to find it in text? Dave -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 12:11 PM To: CF-Talk Subject: Querying a delimited text field Novice question here. I need to write a query to find a single integer in a field of delimited integers, say 23,25,27,29. How is this done in Cold Fusion? FindOneOf? FindNoCase? Can anyone advise? Thanks in advance for any help, Les ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267838 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Querying a delimited text field
With one small tweak it works perfect. (I failed to mention that sometimes there is just a single integer in the field). SELECT distinct lname, fname, artist_id FROM photos, photographers WHERE photos.theme_id = '#themes.id#' OR photos.theme_id LIKE '%,#themes.id#,%' OR photos.theme_id LIKE '#themes.id#,%' OR photos.theme_id LIKE '%,#themes.id#' AND photographers.id = photos.artist_id order by lname Thanks for all your help guys! I think this list is the only reason I still have a job. :-) Les On 1/27/07, Dave Phillips [EMAIL PROTECTED] wrote: Les, Try this: CFQUERY NAME=names DATASOURCE=#DB_redwood# SELECT distinct lname, fname, artist_id FROM photos, photographers WHERE photographers.id = photos.artist_id AND photos.theme_id LIKE '%,#themes.id#,%' OR photos.theme_id LIKE '#themes.id#,%' OR photos.theme_id LIKE '%,#themes.id#' order by lname /CFQUERY Let me know if it works. Dave -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 12:26 PM To: CF-Talk Subject: Re: Querying a delimited text field Yes, querying an Access DB to find it. This is my current (lousy and failing) code for attempting it: CFQUERY NAME=names DATASOURCE=#DB_redwood# SELECT distinct lname, fname, artist_id FROM photos, photographers WHERE #find(themes.id,[photos.theme_id])# 0 and photographers.id = photos.artist_id order by lname /CFQUERY photos.theme_id is the delimited field. On 1/27/07, Dave Phillips [EMAIL PROTECTED] wrote: Les, Are you writing a query to find this in a database? If so, what db are you using? Or, are you just trying to use CF code to find it in text? Dave -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 12:11 PM To: CF-Talk Subject: Querying a delimited text field Novice question here. I need to write a query to find a single integer in a field of delimited integers, say 23,25,27,29. How is this done in Cold Fusion? FindOneOf? FindNoCase? Can anyone advise? Thanks in advance for any help, Les ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267848 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Querying a delimited text field
Yes, Themes.id is actually a variable - a result of an earlier query. On 1/27/07, Dave Phillips [EMAIL PROTECTED] wrote: I think that his 'themes_id' is a coldfusion variable. Les, can you please confirm this or not? It makes a big difference in how things might work. Dave -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 12:46 PM To: CF-Talk Subject: Re: Querying a delimited text field Ok, well maybe an IN statement. I may be way off base though. IE: CFQUERY NAME=names DATASOURCE=#DB_redwood# SELECT distinct lname, fname, artist_id FROM photos, photographers WHERE photos.theme_id IN (SELECT themes.id FROM photos) and photographers.id = photos.artist_id order by lname /CFQUERY ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Querying a delimited text field
OK, have at it! I'll be confirming my novice status by revealing this code, but at least you won't be able to see me blush. I am first listing info on a database of photos by theme, then allowing the user to pick the specific photographer he/she wants to see. This is the tough page for me: http://redwood.jmdl.com/themes.cfm http://redwood.jmdl.com/themes_code.cfm (code) The combination of a loop over the initial query and the delimited field (example, Henry Gilpin's same photo appears under Iconic and Landscape) are what is kicking my butt. It works the way I have it now, but it's ugly, ugly, ugly and certainly wastes unnecessary resources. Thanks to anyone who can school me. Les On 1/27/07, Dave Phillips [EMAIL PROTECTED] wrote: Les, if that variable is the result of another query, then you can accomplish what you want MUCH MUCH faster using an in clause. Can you post this whole section of code and we can optimize it for you. We need to see the query that is getting you the values for theme_id variable, plus any other code where you are manipulating info from that query. When your tables get larger, the LIKE and OR solution we had is going to get very slow for you. The IN clause would be a bit faster for sure. Dave -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 1:17 PM To: CF-Talk Subject: Re: Querying a delimited text field Yes, Themes.id is actually a variable - a result of an earlier query. On 1/27/07, Dave Phillips [EMAIL PROTECTED] wrote: I think that his 'themes_id' is a coldfusion variable. Les, can you please confirm this or not? It makes a big difference in how things might work. Dave -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 12:46 PM To: CF-Talk Subject: Re: Querying a delimited text field Ok, well maybe an IN statement. I may be way off base though. IE: CFQUERY NAME=names DATASOURCE=#DB_redwood# SELECT distinct lname, fname, artist_id FROM photos, photographers WHERE photos.theme_id IN (SELECT themes.id FROM photos) and photographers.id = photos.artist_id order by lname /CFQUERY ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267855 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Querying a delimited text field
Wow guys, thanks for all the help. I've definately got a valuable lesson in both Cold Fusion and DB design today. Many thanks to all! On 1/27/07, Dave Phillips [EMAIL PROTECTED] wrote: Les, Without changing your table structure significantly, you will probably have to leave it as is. Jim Wright had the right idea (no pun intended) :) It would be a better design if you have a 'relation' table that all it has is 'photoid' column and 'themeid' column. Then that table would have one record representing each relationship, so for your photos that belonged to two different themes, there would be two records, each one with the same photoid, but a different themeid. Then you would remove the theme_id column altogether from your photos table. Then you can use the code Jim Wright wrote for you (again, no pun intended!) :) Hope this helps. Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfupdate/cfinsert tags - changed from CF5 to CF7?
Not sure I've nailed it down completely, but CF7 is strict on the conventions for naming fields in a db table (at least in an Access db. I know, I know...). The error was coming not from a textarea field as originally thought, but from fields named as what CF7 may interpret as reserved words. Fields named text and date and time and top were throwing the errors. I renamed those, it works fine now. Thanks for the help, Les On 10/31/06, Josh Nathanson [EMAIL PROTECTED] wrote: I recently tried to mess around with cfinsert and cfupdate in CF7 and couldn't get either of them to work as intended. I don't know if they're being deprecated or what's going on with those tags. I ended up giving up and just using cfquery tags. Let the list know if you find a solution. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfupdate/cfinsert tags - changed from CF5 to CF7?
I'm porting an application from CF5 to CF7. The exact same code is now throwing syntax errors when trying to pass textarea info from a form to the cfupdate and cfinsert tags. When I remove the field that is passed from a textarea it works fine. Is there some new twist to passing textarea information from a form to these tags that I'm not aware of? Thanks in advnace for any help! Les ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258590 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
REReplaceNoCase
Dang, I'm confused. Will this function strip all the html code from a document, including that in between the brackets? REReplaceNoCase(context,[^]*,,ALL) It doesn't seem to be working. Or I've screwed up the code. Is there a better way? Thanks in advance, Les ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258194 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Verity ContextHighlight issue
Coming late to the table, but finally upgrading to CF MX7. I like the new features of Verity, especially ContextHighlight, and have a question regarding that. The collection in question indexes a bunch of html pages. In the resulting context summary I'd prefer, of course, that no html code be included. I framed the output with this tag to strip the html... HTMLEditFormat(REReplaceNoCase(context,[^]*,,ALL)) but that also strips the ContextHighlight. Any ideas on a better approach to this? Thanks in advance, Les ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Tracking changes to a database
What's the preferred concept in tracking database changes? For example, let's say there are 3 fields in a database. A user can go in and edit one, two, three, or none of the fields. How can I track what was changed and what was not? Thanks in advance, Les ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241480 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Removing access db lock...
How can one programmatically remove an Access db lock using CFMX7? CFUSION_DBCONNECTIONS_FLUSH() does not seem to work. Thanks, Les ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241318 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Basic Verity question
I'm confused about the types of Verity query options: Simple, Explicit, Natural, Internet or Internet_basic. If I want to create an engine that would interpret search criteria such as, say, latest college basketball scores not as a literal phrase but intuitively... What type would I use? Thanks in advance. Les ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235544 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Basic Verity question
I'm confused about the types of Verity query options: Simple, Explicit, Natural, Internet or Internet_basic. If I want to create an engine that would interpret search criteria such as, say, latest college basketball scores not as a literal phrase but intuitively... What type would I use? Thanks in advance. Les ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235487 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Email into database
Can anyone give me an idea how to programmatically insert email into a database using cold fusion? I'd like to take a daily digest post from a mailing list and have it automatically inserted into a database. Possible? Thanks in advance, Les ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232477 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Email to database
Can anyone give me an idea how to programmatically insert email into a database using cold fusion? I'd like to take a daily digest post from a mailing list and have it automatically inserted into a database. Possible? Thanks in advance, Les ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232527 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Email into database
Many thanks Andy, but the email I want to insert is sent from an external majordomo server halfway across the country. It's not originated by me. Any ideas on that? Thanks again, Les -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, February 16, 2006 11:37 AM To: CF-Talk Subject: RE: Email into database Your FORM page form action=addemail.cfm method=POST name=myForm input type=text name=email input type=submit value=insert email /form email.cfm INSERT INTO table_name (email) VALUES ('#FORM.email#') This method has no error checking or email validation but this is the skeleton of what you'll need. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED] Sent: Thursday, February 16, 2006 11:27 AM To: CF-Talk Subject: Email into database Can anyone give me an idea how to programmatically insert email into a database using cold fusion? I'd like to take a daily digest post from a mailing list and have it automatically inserted into a database. Possible? Thanks in advance, Les ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232558 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
VdkAdminPurge
Anyone know what this error means? Error occurred in tag CFINDEX Error # -23 [ffe9] VdkAdminPurge Thanks, Les ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230264 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: VdkAdminPurge
While trying to index a verity collection. Thanks, Les -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 2:35 PM To: CF-Talk Subject: RE: VdkAdminPurge In what context? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 3:15 PM To: CF-Talk Subject: VdkAdminPurge Anyone know what this error means? Error occurred in tag CFINDEX Error # -23 [ffe9] VdkAdminPurge Thanks, Les ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230277 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Search results help?
I have created a search page which may return, for example, 20 records referenced by ID numbers. I'd like the user to be able to browse through the result set one at a time - a page for each record in the set. How do I maintain and reference that set of ID numbers as the user browses across many html pages? I've put the result set into an array but can't figure out how to reference the array across the pages. Am I way off base in my approach? Thanks in advance, Les ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224111 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Gmail highlighting
Those with Gmail will notice the interesting turn on/off highlighting feature after doing a text search of the mail. Has anyone come up with an effective way to highlight a search term in a result set using Cold Fusion? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198430 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Stopping endlessly looping query on remote server?
How does one stop an endlessly looping query on a remote server in MX6.1? I guess the function CFUSION_DBCONNECTIONS_FLUSH is not supported in MX. Ideas? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193202 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Cfupdate tag changes in MX?
A client just upgraded from CF5 to MX6.1 and now some simple cfupdate tags are failing on their site. Such as: cfupdate DATASOURCE=#DB_Org# tablename=Cust Resulting error message: Syntax error in INSERT INTO statement. VENDORERRORCODE -3502 SQLSTATE 42000 Was there some change in syntax of the cfupdate tag between 5 and MX that I'm not aware of? Can't seem to find any conclusive information in the documentation. Thanks in advance for any suggestions. Les ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192788 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
XML referencing
Can someone help an XML novice with a question? I've taken an XML document, parsed it with XMLParse and called it XMLContent. Now I'm trying to output it. Elements output fine as #XMLContent.rss.channel.elementname.xmlText#. No problem there. However, since the records in this document do not all contain identical elements, the code breaks when looping over a record with a missing (for example) date element. The question is - how do I test for the existance of the date element (or any other element) within each loop of the query? Thanks in advance for the help. Les ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192197 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Encrypting URLs
What's the best way to encrypt URL variables?For example, I'm passing an ID number but do not want it recognizable in the URL The encrypt function doesn't seem to work as it creates reserved url characters. Thanks in advance for any help, Les [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Cached queries
I would like to carry query results across a number of pages as users move through the site without having to perform the query on each page. I understand persistant queries with the cachewithin attribute but that's not possible with this query as it includes an embedded CFQUERYPARAM tag. What's the best, least CPU-intensive solution to this problem? Thanks in advance for the help, Les [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
TranslateRSSItems problem
Does anyone have any experience with the TranslateRSSItems UDF? (http://www.cflib.org/udf.cfm?ID=813) It hangs for me as soon as the script function is called.Using CF 5.0. Thanks in advance for the help, Les [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Identical query fails on form.text vs form.select
My database contains a field ('EmpName') containing records with comma delimited lists such as Bob,Carol,Ted,Alice.My query contains a line to find all records that contain, for example, Ted: SELECT * FROM Emps WHERE ',' + EmpName + ',' LIKE cfqueryparam cfsqltype=CF_SQL_VARCHAR value=%,#form.EmpName#,% (thanks to Pascal for the sql) This query works perfectly when form.EmpName is passed as a select name=EmpName but fails when passed as an input type=text name=EmpName. I've verified that the passed variable is identical, the only difference is the form element passing it. What the heck is up?Any clues? Thanks in advance, Les [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Add spaces to a text string
How can I add a space after every comma in a list? I'd like to change this: Dog,Cat,Horse,Cow to this: Dog, Cat, Horse, Cow Thanks in advance for your help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Carrying query results across many pages
I have built a form that calls a complex query and outputs 10 records at a time, allowing the user to page through them at will. What's the most efficient way to retain that query data across the different pages without having to rerun the query every time a new set of records is asked for?Am I looking at setting up an array? Thanks in advance or any help. Les [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Passing form variables
I have a from that outputs a query that can have 100 or more records.I display them 10 records at a time using next page and previous page links at the bottom.The problem is passing the form variables to subsequent pages after the form has already been submitted. Is it possible to pass from variables across multiple pages?How? Thanks in advance, Les [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Ordering a query by a dynamic field
Is it possible to order a query by a field produced within that same query? This query fails at the Order by statement: CFQUERY NAME=Result DATASOURCE=foo SELECT City, State, Username, Longitude, (69.1*(longitude - 104.825814) as distance FROM personal ORDER BY distance /cfquery The distance field is (obviously) not a field in the table being queried. Thanks in advance for the help, Les [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMail problem
http://www.houseoffusion.com/banners/view.cfm?bannerid=11 CFMail is acting up on me.The same exact tag works only sporadically.I know this is a vastly general question, but does anyone have any experience with the idiosyncracies of the CFMail tag?Is there a list of things that could possibly make the CFMail tag act up? Using CF5. Thanks, Les [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Verity hassles
Can anyone point me to a comprehensive reference to setting up a Verity search page? I'm trying to index a database memo field so it's searchable by keyword. The entries in this field contain much text with html tags scattered throughout and I want to show summary output on the results page. Problem is, displaying results using the HTMLEditFormat() function still returns unprocessed html tags in the summary text. When the HTMLEditFormat() function is not used, however, all the html is processed and displayed in the summary. Should I be handling this problem at the indexing stage rather than at the output stage? If so, how? Thanks for any help you can give. Les ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Stripping HTML from a string
Is there a way to strip all the HTML tags from a string? For example... I want a string such as this: img src=pix/9412a.jpg align=right border=0 alt=Photo by ???But the woman is bstill/b making music of great authority, still writing songs full of ibeguiling/i beauty. To output like this: But the woman is still making music of great authority, still writing songs full of beguiling beauty. Thanks for your help, Les ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
sql for creating access memo field?
Can anyone tell me the sql for creating a memo field in a table (Access database)? This obviously does not work: CFQUERY NAME=create DATASOURCE=#ds# CREATE TABLE temp (tapeid number PRIMARY KEY, Title char(255), Desc memo) /cfquery Thanks, Les ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Variables within variables
I am trying to store a variable within a variable. For example, I query a variable out of the database and display it on the page using this tag: cfoutput#ParagraphFormat(Q1.blurb)#/cfoutput The variable is this text string: We have located #Q2.recordcount# songs that may now browse The Q2 variable does not evaluate, but ends up on the page as the exact text above. Surrounding it with cfoutput tags within the text string does not work either. How do I store a variable within another variable and have it evaluated? Thanks in advance Les __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Server Beta2 question.
I tested the CFServer 5.0 beta on one machine with no problem. I installed it on another machine and now get the message "This copy of Allaire ColdFusion is licensed for use by a single user only" when trying to call pages from another IP address. Is this a configuration error or is the beta only a single-user app? Thanks, Les ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Two functions with a single onClick?
Can more than one javascript function be performed with a single onClick? If so, how would it be written? Thanks, Les ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Two functions with a single onClick?
Can more than one javascript function be performed with a single onClick? If so, how would it be written? Thanks, Les ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Multiple submit buttons on a form
How would one put multiple submit buttons on a single form, each calling a different page upon submit? Thanks, Les ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Changing form names
In my application, users are updating a database via a form. Is it possible to dynamically change a form field name - say from "order1" to "order" - after the form is submitted but before the cfupdate tag is processed? If so, how could it be done? Thanks in advance, Les ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Looping over form data?
I need to pull a number of records at once from a database, edit them on one page, then send the data back to the database. Looping over the query, I've been able to place the data correctly on the page. However, I'm at a loss as to how to update the edited records back into the database. I'm currently trying to post them as form data but it fails because each record's input fields have the same name. Is there a way to loop over form data or to dynamically rename form fields? And/or is there a better way to edit multiple records at once than by using a form? Thanks for any help, Les ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Network Scenario
I need some advice... I'd like to use Cold Fusion in the following way: - 8 people with laptops networked together. - One laptop acting as the Cold Fusion server. - All 8 people simultaneously querying/updating/editing the database on the server through their browsers. Is it possible? What restrictions would I have? What sort of problems should I expect? Thanks in advance for any input. Les ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Strings without spaces
Pardon the entry-level question, but how can I take a string and evaluate whether or not it has a space anywhere in the middle of it? In other words, my only acceptable string would be one "word" - without spaces. Thanks, Les ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Evaluating height/width of a JPG?
Is it possible to dynamically evaluate the width and/or height of a JPG or GIF that a client uploads to a site? I want to take action based upon those parameters of a graphics file. Thanks, Les ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Web servers
I've recently upgraded to Windows 2000 and am having a hard time finding a web server to run Cold Fusion. Microsoft's IIS won't install over Win2000. Any suggestions on a web server that will work? Am I destined to configure Apache for the job? Thanks, Les -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.