Re: zipping and unzipping a string
I'm not 100% sure, but SQL server 6 or 7 (I think, from memory) has a max record size of 8000 bytes or something weird. We had a couple of varchar 4000 fields and all the normal fields on top of that (PK, FKs, etc etc). It was fine till it started truncating info. Much research later and it turned out that the max record length was being exceeded. Hence the text field type and its data pointer goodness... One confirmation here: http://west-wind.com/weblog/posts/207.aspx If your wddx access does not need to be lightning fast, another option is to store it on the HDD and just store a reference to the file in your database table. HTH Aaron Jim Davis wrote: -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, October 16, 2005 12:06 AM To: CF-Talk Subject: RE: zipping and unzipping a string From: John Blayter [mailto:[EMAIL PROTECTED] I am looking for a way to zip and unzip a string without going to the hard drive to perform I/O operations. I have started hacking away at some code but I don't know enough Java to get it working. I have a WDDX packet that can be between 9 - 14K that we want to store in a SQL server database. The database guy has hatred towards using a text data type and has challenged us to find a way to fit a 14K wddx packet into a varchar(8000) field. Any help would be greatly appreciated. Thanks, I would tell your DBA that large data types exist for a reason... large data! What is his reasoning for not wanting the text data type used? What is the purpose of the field, will it be searched? Indexed? Is the DBA familiar with Text In Row (alleviates the double I/O or text retrieval)... etc... Yeah... I gotta agree. You shouldn't change your data because of a personal hatred towards a perfectly usable feature. Does he have actual reasons? Anything that will offset the development time needed (and they completely lack of flexibility assumed) from hacking large data to fit in a smaller field? Look at the data. Use the data type most appropriate to the data. That's really DB 101 there. If you have problems after that optimize, consider kludges, etc. But not to do the logical thing because of a unsubstantiated personal opinion is just plain silly. Jim Davis ~| 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:221148 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: Offline application
Have you checked out http://www.pcaonline.com/coral/? Aaron Kurt Kaptein wrote: I have a customer who would like an application developed that I would like to do in coldfusion, but they insist that it be built for their local desktop and then the data transferred via disk so that another individual who has no access to the internet can work on it. I do not need to worry about syncing the data as it is a mom or daughter team that work on the app. Is there something like coldfusion I could use for an offline app. I was just going to use acess for data storage. I do not want develop a access front end. This has always been a pain Any direction is much appreciated Sincerely, Kurt Kaptein Kurt Kaptein Spectrum Net Designs, Inc PO Box 806 Grandville, MI 49468 Toll Free: 866-773-2638 Fax: 616-538-5691 Website: www.spectrumnetdesigns.com Email: [EMAIL PROTECTED] ~| 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:215362 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: why we love coldfusion..........
It'd be great if people included some of the post to which they are replying in their reply. Or is that difficult with today's technology? This post by itself seems rather orphaned / random. Aaron Bryan Stevenson wrote: Gee Dave...Sam doesn't look too happy in some of the water shots...I hope she was well paid for the day ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] ~| 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:214113 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: SOT RE:Create SWF from CF
I know and have studied the laszlo examples in depth. I just briefly glanced at the Flex examples today. The functionality looks essentially the same, the syntax is similar but I have not looked too closely at Flex code. Laszlo uses xml as datasets - you can provide these via URLs, service calls or as local files. I too would like to hear how Laszlo is limited - the latest release has some drawing primitives, solo deployment and Flash 6 swf generation. http://www.openlaszlo.org/ Aaron Adam Haskell wrote: Where's a good place to host them. We're making some Proof of Concept stuff in house right now but no way is that able to be public facing. I was thinking about geting a VSP and getting it all on there...Really you can do someting in laszlo with abackend of PHP/Java/ASP and just as easily take the laszlo side and couple it with CF. Laszlo is jut part of a SOA (service oriented Architecture) its a consumer just feed it and it will perform :) Adam H On 7/28/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: I would like to see some CF/Laszlo examples -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: 28 July 2005 14:55 To: CF-Talk Subject: SOT RE:Create SWF from CF How is Laszlo limited? I like to see this one explained further since I think its pretty capable, not quite as easy as flex admittedly but how it is very limited? Adam H On 7/27/05, dave [EMAIL PROTECTED] wrote: sure its free and very limited ~Dave the disruptor~ A criminal is a person with predatory instincts who has not sufficient capital to form a corporation. From: Cary Gordon [EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 6:08 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Create SWF from CF You might want to take a look at OpenLaszlo it is sorta equivalent to the non-actionscript aspect of Flex, only it's free. You might need to adjust your model a bit to make it work. But, did I mention that it is free? Cary Gordon The Cherry Hill Company ~| 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:213101 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: NumberFormat , Help
Cheap and nasty: right( YourValue * 1000, 12) HTH Aaron Aldon Moore wrote: I have a dollar value of ($73.60)thats stored in the database as 73.6. I would like to format this number and display it as a twelve digits (0007360). Similarly if the value is 12 the format shoshould be (0001200) Any help would be appreciated. ~| 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:212800 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 2 Primary Keys
It sounds like you are enforcing a 1 to 1 restriction but storing the link in a 1 to many or many to many db design. If table1 can only ever be linked to 1 table2 record and vice versa, wouldnt it be easier to store the table1ID in the table2 as a field (or vice versa)? All your queries would have 1 less join, etc. Aaron Saturday (Stuart Kidd) wrote: Hi Jordan, Yes, more than one field needs to be a primary key. I'm using MS-SQL (on shared hosting). Stuart On 14 Jul 2005, at 23:07, Jordan Michaels wrote: Saturday (Stuart Kidd) wrote: Hi guys, I want to add a row in a join table which i don't want to be duplicated ever. So i have my tableID, table1ID, table2ID - if table1ID = 24 and table2ID = 35 i don't want there to ever be a reoccurence of them. I guess i have to set both of those fields (table1ID, table2ID) to primary keys, but how can i do that? Do i do it in ms-sql or via Coldfusion somehow? If i do it via MS-SQL then won't it pop an error up in the code if it happens? Thanks, Saturday Are you talking about compound keys? Where more then one field is the primary key? This can be done in most databases - even access if I remember correctly. -JM -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| 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:211933 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: This is crazy this is crazy this is crazy!
This would be an interesting point to pursue - when submitting the form you set a cookie for EVERY form field - may be better off saving it in a session variable?? Live headers / Page info via Netscape / Mozilla etc are very useful when looking at things like this. Aaron - Original Message - From: Micha Schopman [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, June 27, 2005 5:57 PM Subject: RE: This is crazy this is crazy this is crazy! Will, You might check the amount of cookies you are setting. Per domain you are allowed to set a maximum of 20 cookies in browsers, whereas each has a maximum of 4 KB. If you go over these 20 cookies, the FIFO system (First in First Out) is doing the job to remove the oldest cookies automatically. So it might well be, that your session cookie gets removed from the browser because it has reached its maximum amount of cookies. If you really need to set a bigger amount of cookies you must create a wrapper for it. I have created one if you really need it. Micha Schopman Project Manager ~| 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:210581 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: This is crazy this is crazy this is crazy!
Same error in NS 7.2, Will. Aaron - Original Message - From: Will Tomlinson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, June 27, 2005 7:06 AM Subject: Re: This is crazy this is crazy this is crazy! Hell, I just submitted the customer info and it crapped out! Element SHOPPERINFO is undefined in SESSION. Why is it undefined in session? It's there! Well it WAS there. The damn thing was created when they added somethin to the cart. I'm not doing anything to DELETE it! This is really pissin' me off now. ~| 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:210546 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: insert error
Yes, 94 is an integer. Did you try viewing the source of the webpage to make sure it isnt 94 or 94 or other combinations of similar (invisible) things? HTH Aaron - Original Message - From: dave [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, June 17, 2005 5:08 PM Subject: insert error Invalid data 94 for CFSQLTYPE CF_SQL_INTEGER.isnt 94 an integer? ~Dave the disruptor~ A criminal is a person with predatory instincts who has not sufficient capital to form a corporation. ~| 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:209774 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: ColdFusion and Lisp
Hi Dustin 1. will advice be based on a user's questions (what you wrote) or their answers to questions (what I think you meant)? 2. LISP is a whole lot of fun and definitely recommended as part of a uni or TAFE course, but unnecessary for your project 3. Limiting the number of components (ie languages) in your project is a good goal - my opinion. If you have picked CFML, stick with it. A simple DSS or expert system can be modelled using a database structure. Question === QuestionID QuestionText Answer == AnswerID QuestionID AnswerText NextQuestionID AdviceID Advice == AdviceID AdviceText Problem solved (based on your posted requirements). HTH Aaron - Original Message - From: Dustin Smith [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, June 17, 2005 4:10 AM Subject: ColdFusion and Lisp Hello everyone, This is my first post to the list. I appreciate any replies in advance. I'm working on a ColdFusion project that requires an interactive 'expert system' that will allow users to receive advice based on the questions they provide. It's not as simple as static quiz, because the questions themselves will change based on earlier answers. I figured LISP is a good language to work with for this, but I don't have any idea how I could make it interact with a web application. Does anyone know if this is possible? Or, if not, any suggestions for alternatives would help. Thank you! Dustin ~| 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:209751 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: Appending variable names to CFSET
That's because the list in example 2 is simply linkItems. It would work if you had cfloop index=linkIndex list=#linkItems# HTH Aaron - Original Message - From: Mark Henderson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, June 14, 2005 2:02 PM Subject: RE: Appending variable names to CFSET Thanks Ricardo. I got it working and it wasn't the variable causing my trouble. If I do this: cfloop index=linkIndex list=Drivers,Security,Search,Partner,Admin Instead of this: cfset linkItems = Drivers,Security,Search,Partner,Admin / cfloop index=linkIndex list=linkItems It works. Go figure. Adieu Mark ~| 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:209375 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: jar launcher crashes randomly
xmlol It really depends on the trajectory you are planning and the type of condiment in the jar. Here in Australia we use Vegemite jars, although the Nutella jar is also popular. The majority of jar launcher crashes occur when the release mechanism is triggered but the jar is too firmly (or not firmly enough) attached to the device. The key is to make sure the lid is tight, and the bottom of the jar is wiped clean of all and any stickiness. A loose lid can lead to instability as the jar approaches escape velocity, causing havoc with the jar launcher's jar release mechanism. Sticky jar bottoms cause a similar problem. Having the correct density of condiment (eg Vegemite or Nutella) also play a major part in successful launches, where as the jams (jelly) and other toppings tend to be either too light or too dense, causing misfires and consequent launcher crashes. A secondary problem occurs when the jar launcher trajectory is too ambitious: any launch really needs to be between 27.5 and 67.5 degrees to the horizon, or the force vectors at the moment of release tend to reach a level of dissonanace that leads to a dirty jar release and subsequent launcher crash. Make sure you have the jar launcher tripod firmly locked into position on a firm, stable surface; have a fresh jar of suitably dense condiment, with the lid screwed on firmly and bottom surface wiped perfectly clean; remember to keep the trajectory angle reasonable and you should be fine. Good luck! /xmlol - Original Message - From: stylo stylo [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, June 12, 2005 5:14 PM Subject: jar launcher crashes randomly No one has ever heard of this? ~| 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:209246 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: cffile without path
I read in the docs (for action=upload) that relative paths are calculated relative to some directory (windows temp or something??) but you can look that up. What does #ExpandPath(Presentations.txt)# return? Aaron - Original Message - From: Joshua OConnor-Rose [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 24, 2005 5:48 AM Subject: cffile without path my cffile tag isn't bombing when written this way cffile action=append file=Presentations.txt output=blah any thoughts what file is being updated? (access to server is restricted to me so I want to communicate clearly with sysadmin) -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? Yahoo! Small Business - Try our new Resources site http://smallbusiness.yahoo.com/resources/ ~| 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:207480 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: transparent png for ie hack
Could you have the following in your cfml page: img src=somePHPpage.php?image=SomeImageName ? - Original Message - From: Ewok [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, May 15, 2005 12:32 PM Subject: RE: transparent png for ie hack I didn't. I tried it out in a php page -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 8:34 PM To: CF-Talk Subject: RE: transparent png for ie hack the php one? how did you call that in the cfm template? ~Dave the disruptor~ From: Ewok [EMAIL PROTECTED] Sent: Saturday, May 14, 2005 8:28 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: transparent png for ie hack That thing works great Dave! If I didn't suck so bad at regex's I'd give it a go in CF :/ Has the RegEx Ninja wrote a book yet? hint hint (Where is Ben anyway?) Okay, okay, gotta go... just hope they have more beer wherever it is that I'm dragged to... -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 6:06 PM To: CF-Talk Subject: RE: transparent png for ie hack I have a few i am gunna try, this one looks interesting, written in php, if it works maybe we could rewrite it in cfm. http://koivi.com/ie-png-transparency/ ~Dave the disruptor~ From: Ewok Sent: Saturday, May 14, 2005 5:38 PM To: CF-Talk Subject: RE: transparent png for ie hack Simply put... HAH! Do let me know if you find one! I am so tired of hacking up alternate styles and images to get a site looking the same in IE as it does in FF! A lot of the time, I've been able to use style filters to get what I'm looking for maybe you could try some of those? Opacity maybe? Just a thought. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 4:54 PM To: CF-Talk Subject: ot: transparent png for ie hack anyone know of one that actually works? ~Dave the disruptor~ ~| 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:206725 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: transparent png for ie hack
Couldnt agree more, Dave. - Original Message - From: dave [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, May 15, 2005 1:05 PM Subject: Re: transparent png for ie hack ~Dave the disruptor~ From: Aaron DC [EMAIL PROTECTED] Sent: Saturday, May 14, 2005 10:49 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: transparent png for ie hack Could you have the following in your cfml page: ? - Original Message - From: Ewok To: CF-Talk Sent: Sunday, May 15, 2005 12:32 PM Subject: RE: transparent png for ie hack I didn't. I tried it out in a php page -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 8:34 PM To: CF-Talk Subject: RE: transparent png for ie hack the php one? how did you call that in the cfm template? ~Dave the disruptor~ From: Ewok Sent: Saturday, May 14, 2005 8:28 PM To: CF-Talk Subject: RE: transparent png for ie hack That thing works great Dave! If I didn't suck so bad at regex's I'd give it a go in CF :/ Has the RegEx Ninja wrote a book yet? hint hint (Where is Ben anyway?) Okay, okay, gotta go... just hope they have more beer wherever it is that I'm dragged to... -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 6:06 PM To: CF-Talk Subject: RE: transparent png for ie hack I have a few i am gunna try, this one looks interesting, written in php, if it works maybe we could rewrite it in cfm. http://koivi.com/ie-png-transparency/ ~Dave the disruptor~ From: Ewok Sent: Saturday, May 14, 2005 5:38 PM To: CF-Talk Subject: RE: transparent png for ie hack Simply put... HAH! Do let me know if you find one! I am so tired of hacking up alternate styles and images to get a site looking the same in IE as it does in FF! A lot of the time, I've been able to use style filters to get what I'm looking for maybe you could try some of those? Opacity maybe? Just a thought. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 4:54 PM To: CF-Talk Subject: ot: transparent png for ie hack anyone know of one that actually works? ~Dave the disruptor~ ~| 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:206729 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: BlueDragon 6.2/.NET Released!
The price is listed as 1,2599. It looks better as 12,599. Aaron - Original Message - From: Vince Bonfanti [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, March 24, 2005 12:28 PM Subject: RE: BlueDragon 6.2/.NET Released! Thanks, but that price is correct. BlueDragon.NET is considered an enterprise level product, and is priced the same as BlueDragon/J2EE at $8,999.00 for a 4-CPU server. For reference, a 4-CPU license for CFMX 7 Enterprise is $11,998.00 (about 33% more expensive than the equivalent BlueDragon editions). BlueDragon Server JX (Java-based) is $899.00 per server, regardless of the number of CPUs. Maybe that's what you were thinking of? Vince -Original Message- From: Jeff Fleitz [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 8:15 PM To: CF-Talk Subject: Re: BlueDragon 6.2/.NET Released! Hi Vince, Congrats! Looks like you have a comma in the wrong place for the price of the 4-cpu .NET server product. v/r, Jeff On Wed, 23 Mar 2005 18:27:18 -0500, Vince Bonfanti [EMAIL PROTECTED] wrote: New Atlanta is pleased to announce the final release of BlueDragon 6.2, which is available for immediate download: http://www.newatlanta.com/products/bluedragon/index.cfm ~| 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:199851 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: How to Browse and Choose Directory...
Primarily because the input type=file... tag is a FILE input tag, not a select a directory tag. Aaron - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, March 10, 2005 7:57 AM Subject: RE: How to Browse and Choose Directory... Oh, yeah, yeah...I see what you're saying...I'm not thinking straight. I can't pull files off the client's machine... But, wait...if I set up a CFFILE upload function that loops through the directory that the client specifies...why wouldn't that work? I'm not accessing the client's machine (as Bryan mentioned), the client has simply specified a directory for the CFFILE to look in. I would have the code loop through the directory that is specified, C:\Photos compile the list, the use CFFILE to upload each photo to my server one at a time... Why wouldn't that work? Rick -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 3:27 PM To: CF-Talk Subject: RE: How to Browse and Choose Directory... The Cold Fusion server cannot see the client's machine, not even for the one file. The file is actually sent to the server by the client's browser as part of a form. The browser is the software that finds the file and uploads it. The server cannot see any files on the client's hard drive. Let's say you did as intended and had the browser send the folder name to the server as a form variable. The server would receive something like C:\My photos\ The server would try to look in that folder, and not find any photos, since it would only have access to it's own C: drive, not the client's. Does this make sense? Jerry Johnson Web Developer Dolan Media Company [EMAIL PROTECTED] 03/09/05 03:26PM It will be a folder somewhere on the client's machine...I have no access to it. Just figured there was a way for a user to designate a directory in CF by browsing their machine... ~| 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:198029 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: CF demo apps on a CD?
CFEverywhere will pretty much do what you want, I believe. I think the BD implementation is being worked on and proven, with database and everything. No links sorry, although google.com may turn something up. HTH Aaron - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, February 07, 2005 4:14 PM Subject: Re: CF demo apps on a CD? Thanks Sean. not good news for us though - it means the new version goes close, but not close enough to be able to just hand people CDs and have the apps work. Not in CF anyway. Guess we're going to have to go to some other technology after all. BUGGER! I was hoping not to have to have any other technology hanging around. ~| 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:193278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Homesite
Or me saying I wish we could return to the old days when people used english to communicate in english. l337 speaking script kiddies would be proud. Aaron Hey! It's Friday, I'm allowed one gripe a week. - Original Message - From: dave [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, January 14, 2005 1:06 PM Subject: RE: Homesite thats like saying u wish ie would adhere to the w3c standards but its not gunna, so know reason to hope 4 it 2 happen u know ~| Find out how to get a fax number that sends and receives faxes using your current email address http://www.houseoffusion.com/banners/view.cfm?bannerid=64 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190363 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: House of Fusion - Cannot Sign In
Now that you mention it, I too tried to retrieve my HoF password and received no emails. Aaron - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, January 06, 2005 8:51 PM Subject: House of Fusion - Cannot Sign In Hey Michael, is it just my link or is the functionality to sign in/request password down? It just seems to submit and do nothing. Neil ~| 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:189492 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: Typesafe enum design pattern (another go)
Sounds like Taco is reading and learning about patterns and trying to implement / translate them into CF purely for the exercise or sake of doing so. Hence he would like to discuss the implementation / code at a purely theoretical point of view, rather than a specific implementation point of view. Respondents to date seem to indicate that a pattern is basically useless without the associated problem it was intended to solve being present. In a brain-storm session, Stage 1 is every idea is good - I think this is the space Taco is occupying. Once all the ideas are written down, Stage 2 involves picking the best / most doable ideas - looks to me like this is the space occupied by his respondents. I think the pattern porting exercise would be interesting and potentially valuable. This value could be greatly enhanced if a common CF or web-based programming scenario was also invented, for which the pattern provides a solution. Without this scenario, it would be like Mach-II or FB3/4 having base code and documentation, but no example apps. My gut feeling is that there are only a handful of other developers here who would be able to discuss pattern templates or implementations. It may be that another list is better suited, or a new CF-patterns / CF-hardcore list would at least show you through its subscription how many others are interested. Good luck, Taco, I hope you find others that share your passion. Aaron - Original Message - From: Spike [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, January 04, 2005 12:59 PM Subject: Re: Typesafe enum design pattern (another go) That's pretty much all we can discuss unless you lay out the problem that you're trying to solve. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189200 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Typesafe enum design pattern (another go)
Could you use a struct? 1. It's a built-in CF class 2. Public cant modify data unless you provide a mechanism for them to do so 3. Loop using any CF looping construct Aaron - Original Message - From: Taco Fleur [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, January 04, 2005 1:06 PM Subject: RE: Typesafe enum design pattern (another go) The problem: I need a class that represents constants I don't want the public to be able to modify any data I need to be able to loop over the constants easily Basically quoting what problems the pattern solves.. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189202 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: (ot - admin) advertisers
This would suit me to the ground as I gear up for a big year and new website design etc. Great idea! Aaron - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, January 03, 2005 3:23 PM Subject: Re: (ot - admin) advertisers Actually, based on the interest people have brought up, I've got a general question for people here. If there was a list that handled SEO, Advertising ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189124 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: Beating a .net horse! Job interview confirms suspicions...
I know enough languages - my new year's resolution is learning to sell stuff. Aaron - Original Message - From: Sean Corfield [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Saturday, December 25, 2004 8:38 AM Subject: Re: Beating a .net horse! Job interview confirms suspicions... Make it your New Year's resolution to learn a new language. Make it your New Year's resolution to embrace OO. Make it your New Year's resolution to expand your programming knowledge - learn about generic programming, learn about inversion of control and dependency injection, learn about generative programming, learn UML, learn a new framework... There's always lots to learn! ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188767 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: In One?
I think Oracle OO or object relational was supposed to do this natively, but as far as i know, it is not possible to do an arbitrary number of dynamic self-joins in native SQL. You could always cheat and have a dynamically-sized text field containing a comma separated list of the parentCategoryID hierarchy :) Aaron - Original Message - From: Ian Buzer [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, December 23, 2004 8:03 PM Subject: In One? Hi, This has been bugging me for about 3 years now, and I've finally decided to see if I can beat it (er... well see if I can find someone else that can beat it :) I've got a db table with a typical category heirachy structure: categoryId, parentCategoryId, categoryName, etc.. Given a particular categoryId, is it possible to get the path back to the root category in only one db query? (given that the depth of the category in the structure is unknown). Ian ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188613 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: In One?
Is varchar fixed in size? If so the field would not satisfy an arbitrary depth of hierarchy. By dynamically-sized text field I mean any field type that allows an unlimited dynamic length of text, like the memo field in MS Access or DBISAM and is a generic description of what I meant. Apply as you see fit to your db of choice! Varchar in MySQL (255 chars max) is very different to Varchar in MS SQL Server (4000 chars max). I guess more than anything I'm struggling with someone saying that they dont understand what I'm suggesting then telling me here's how to make it better. Ah well. Hope your cough clears up, and Merry Christmas :-) Aaron - Original Message - From: Micha Schopman [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, December 23, 2004 9:24 PM Subject: RE: In One? You could always cheat and have a dynamically-sized text field containing a comma separated list of the parentCategoryID hierarchy :) *cough* I think I misunderstood this suggestion ;) Even then, varchar would be a better choice :P Micha Schopman Software Engineer ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188625 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: In One?
H I was not too serious - hence my use of the word cheat. You did understand my suggestion, but wanted to make it better, by using VarChar. I still fail to see how using varchar would make it better. Having developed a number of databases in my time I am well aware of the improperness of storing lists of id's. The customer wanted to: [store an arbitrary length hierarchy in one table] and [retrieve the path to the root parent] [in one query]. I believe my solution works based on these requirements/deliverables. Heck, I'm going to suggest storing both the ID and the Category name for display purposes :p Didn't say it was elegant, valid, correct or the right shade of blue. No mention was made by the customer of modifying the hierarchy nodes or anything. I can come up with solutions for that too, but it'll cost them extra :) The customer wanted a solution and that's all I was offering. And it's definitely cheating. :-) I've seen many properly designed database projects fail to complete and many home grown syntactically incorrect nightmare RDBMS (MS Access!) designs survive for years in both large and small organisations. Aaron - Original Message - From: Micha Schopman [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, December 24, 2004 12:18 AM Subject: RE: In One? I thought you were making a joke.. :) One of the principles of a good database design is not to use lists of id's. You could better if you really want to do such thing, create a seperate table to store the path. The disadvantage of using lists is, you cannot use constraints to force existing relationships and you cannot index the data in a optimal form. You'd be better off with two tables like: Table 1: Path ID = Identity ObjectID = Int (object for which the path is stored, so this could also be ArticleID for example) Table 2: PathData ID = Identity PathID = Int (Contains ID from the Path table) Priority = TinyInt (Contains an order) Target = Int (contains the result of a path, can be ID, anything you want to) So with this data Path table: ID = 1 ObjectID = 138475384047 PathData ID = 1 PathID = 1 Priority = 1 Target = 3567242 ID = 1 PathID = 1 Priority = 2 Target = 3453456 ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188630 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: In One?
We don't know (and I won't assume) that the customer is using SQL Server. Aaron - Original Message - From: Micha Schopman [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, December 24, 2004 1:07 AM Subject: RE: In One? Columns of the type text are stored in a different way than varchar columns. Varchar columns have a much lesser effect on performance, and the amount of characters is more than enough to store paths from new york to tokio. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188633 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: In One?
With none of the previous message in your post I have no idea what you are replying to here. Please include some of the previous post to which you are replying, to maintain context. Thanks Aaron - Original Message - From: Micha Schopman [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, December 24, 2004 1:40 AM Subject: RE: In One? And that is why I suggested the table approach instead of a list approach. Constraints are a important part of good design, and cannot be achieved with lists. Micha Schopman Project Manager ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188642 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Beating a .net horse! Job interview confirms suspicions...
0. Not having a job and not seeing any / many advertised with your particular skillset is frustrating and decidedly scary. 1. A sample size of 1 does not provide sufficient degrees of freedom to reliably predict a trend. 2. If you don't know .NET, and they don't use CF, you did very well (imo) to get a job interview there. Well done! 3. Learn .NET and get a job using it. Then once entrenched, show them how much quicker and easier you can do stuff in CF and convert them. Or maybe you'll have so much fun using and learning .NET, earning money, with an extra -framework- and/or language in your quiver, that it won't matter. 4. .NET is a framework, not a language. It's like saying do you use CF, and having them reply Nah we use Fusebox. 5. Bluedragon has a CFML engine for .NET. So you could easily show them the coolness of CF whilst maintaining their .NET focus. Will, I wish you all the best in finding employment at this time of year. Aaron - Original Message - From: Will Tomlinson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, December 24, 2004 7:26 AM Subject: Beating a .net horse! Job interview confirms suspicions... apps. I asked her, Are most of your apps CF or .NET?. It took her 1/2 second to answer, .NET. DOT friggin NET! She went on about how they don't do much CF. It's a trend fellas! And I'll guarantdamnteeya it's indicitave of the market! I rest my case, Thank you! Will ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188709 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: Comma's in select Lists
Suggestion: Use the company id as the value in the SELECT list and use company name as a display value only. SELECT NAME= etc OPTION VALUE=#CompanyID##CompanyName# etc /SELECT then process the list of selected CompanyIDs, which will make your subsequent queries and processing far simpler. HTH Aaron - Original Message - From: jonese [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, December 17, 2004 9:56 AM Subject: Comma's in select Lists Ok we have a table of company names. Some of these company names have a comma in them ( , ). We use CF to build the form Select Menu which allows a users to select multiple companies. The problem is CF returns this list like MySelect = value1, value2, value3 and if value2 = mycompany, inc we can't loop over this list properlly. Any idea how to work with this so we minimize the impact on our data etc??? lost in atlanta. ERJ ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187962 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: trying again - update one table fr another
Something like this? UPDATE contact_detail SET state = (SELECT state FROM davids_excel WHERE davids_excel.companyname = contact_detail.companyname) Aaron - Original Message - From: Tim Laureska [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 16, 2004 8:49 AM Subject: trying again - update one table fr another OK, going on 2.5 hrs with no luck trying to update one table's state field from another table (only matching field is company name).. any pointesr would be appreciated: cfquery name=david datasource=#SalesPerson_DB# SELECT state, companyname FROM davids_excel where companyname=companyname /cfquery cfquery name=contact_detail datasource=#SalesPerson_DB# SELECT state, company_name FROM contact_detail where company_name=company_name /cfquery CFLOOP Query=contact_detail CFQUERY NAME=david DATASOURCE=#SalesPerson_DB# UPDATE contact_detail SET state=#state# where '#contact_detail.company_name#'='#david.companyname#' /cfquery /CFLOOP Tim ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187802 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: Pause running code
I think BlueDragon has a pause tag, an incomaptibility/enhancement with/to Coldfusion. Aaron - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 15, 2004 6:28 PM Subject: Pause running code Is there a simple way to pause a CF page for a set time at some point in the code then continue running it. I seem to remember seeing how to do this on a forum once - but can't find any reference. any help much appreciated. Mike NZERN ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187709 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: (Admin) Please test
I clicked the Message link ( Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187331 below) and it returns: No messages found for this thread ID. The URL was translated to http://www.houseoffusion.com/cf_lists/messages.cfm/threadid:187331/forumid:4 Netscape, Win2K Aaron - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 13, 2004 7:48 PM Subject: (Admin) Please test All HoF resources are now 100% Blackstone. If you can do me a favor and test out various links and sections, I'd appreciate it. I think I've done them all, but there may be something I've missed. Thanks ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187338 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
Mambo CMS server
Has anyone had any experience extending / embedding CF or PHP in Mambo? Wondering really if it's possible to do so. I'll look at the site but if someone already has some experience... Thanks Aaron Atomic Software http://www.atomic-software.com.au phone: +61 409 430 231 email: [EMAIL PROTECTED] ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186551 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: Licensing a CF app
A suggestion: depends how open that client's network is, but you could include a couple of well-placed CFC calls to your own server that validate the license information you also incorporate into the code. If they remove the CFC calls, the app can bomb out - ie make the CFC do some action/return some result that is useful. You could also deploy a CFX tag (hence compiled) that processes the result, allowing you to hide any decryption / processing logic from prying eyes. Aaron - Original Message - From: Tom McNeer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 5:05 AM Subject: Licensing a CF app Hi, I have a client whose application we have developed over the past three years. It operates as a web-based services for his customers, taking data entry and displaying calculated analysis of the data. He now has a customer who, for security reasons, wishes to have a private installation of the application running on the customer's own network. My client has asked me if there is any way we can secure his application, meaning Can we make it like a compiled desktop app that can't work without a license key, and can be timed out after a year -- both so it cannot be copied and so, if the customer does not pay his yearly licensing fee, the application could be disabled. Since this a ColdFusion app, I know that there is no way to truly secure it in the manner he wishes. But I wondered if anyone on the list had any similar experiences, or any thoughts on securing it to some extent. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185563 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: CFML vs PHP/ASP functionality [Was: Macromedia gives up on the server market in Australia and walks away.]
Maybe it's a small thing, but implementing CFOUTPUT GROUP= was pretty involved when developing in PHP. I had 3 levels of equivalent CFOUTPUT to deal with, all grouped. Maybe I missed some u-beaut PHP function as I learnt it for one project. If the web is primarliy about displaying information, the CFQUERY + CFOUTPUT tags vs query building in PHP or (I'm guessing) ASP.NET, jsp etc make CF a no brainer choice for me over any competing language. Aaron - Original Message - From: Micha Schopman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 8:14 PM Subject: RE: Macromedia gives up on the server market in Australia and walks away. Euhmm.. ASP.NET? PHP? Name one thing that cannot be done on these platforms and can be done with ColdFusion. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184646 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: Primary Key Justification
This sounds familiar - strictly speaking, 3rd normal form databases are typically sufficiently normalised for everyday use. I do not remember all the terminology (dependencies, etc), but 4th/5th/Boyce-Codd (spelling?) normal form would lead to an entity/table design not unlike the one you are describing - each tuple/record can only be described uniquely by the combination of 1 or more fields and no other way. This theory is something we learnt at university, and imo, for 99% of cases in the real world, the theory should be left there. The co-worker is designing a fully normalised database table, but this does not mean it is programmer / web / etc friendly. It is quite possible a throw-back to AS400 / IBM development mentality where things are done the right way. The AS400 hardware is a case in point, they are as old as the hills and still going strong. I have no experience in AS400 development so this is pure conjecture. Neither of you are wrong per se. You have an opportunity to learn elite db design and configuration. In return you can teach your AS400 co-worker about web development and some nifty short-cuts (identity/sequences) that may make his life at work a little easier. Just some thoughts. HTH Aaron - Original Message - From: Dawson, Michael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 10, 2004 1:01 AM Subject: Primary Key Justification I'm well aware of the need for a primary key, in addition to a sound table design, however, I'd like someone else to word a response for me. A co-worker built a data file (a data table on an AS400) with six fields. The only unique key of the record is the entire record, itself. The combination of all six fields must be used to identify the exact record. This is how it's done, is the reply I get. (I've been building web-based apps using relational DBs for 8 years. I have never used an entire record as the primary key.) I'm not passing an entire record through a URL or in hidden form fields. Imagine the nightmare of maintaining this application... A discussion of the existence of Oracle's sequences and SQL's identity fields did little to sway this person's opinion. This person's entire development background is AS400 with a history of bad database design. Now, I'm creating the table myself to do it right. ;-) Any thoughts? Thanks M!ke ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183723 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: cached Queries
When you use the cached* attributes of cfquery, i think it displays the fact that it was cached in the space in debug where the query time is usually shown. Aaron - Original Message - From: Andy Jarrett [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 25, 2004 8:56 AM Subject: cached Queries Hi there, Is there away of telling if a query was generated from a cached query without setting a variable or anything?? Cheers Andy www.andyjarrett.co.uk ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182464 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: Field Naming
Hi Andrew Based purely on ituition / gut feel / experience, I never name a table as its plural, always singular form, so Project table, not Projects table. Sorry I know of no published field naming standard, but do something similar to what you have suggested. Aaron - Original Message - From: Andrew Dixon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 9:30 PM Subject: OT: Field Naming Hi Everyone. I'm just starting a major project for a government client and the first job is to design the database. Is there any recongnised convention on the naming of database fields. In the past I have always named them [table_name_field_name] for example: projects_id where the table is called 'projects' and the field is called 'id'. ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181820 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: dtSearch
Hi Charlie If it's a .dll that is called as a URL then you should be able to 1. grab your form vars 2. call the .dll using CFHTTP (or variants), passing the form vars to the .dll (as if the form had been submitted as per usual) 3. receive the results 4. display results or parse and massage the results, outputting them how you please. HTH Aaron - Original Message - From: Charlie Griefer To: CF-Talk Sent: Friday, October 08, 2004 2:40 AM Subject: OT: dtSearch Hi all: A while back, somebody here recommended dtSearch as an alternative to Verity.We've purchased the product, and in a nutshell, we're pretty happy with it. However, dtSearch builds its search form (automatically) inside of a frameset.left frame is search form/results, right frame is target for search results (click a search result in the left frame, document is displayed in the right). We're trying to do away with the frames and embed the search and results directly into our pages...primarily to maintain our look and feel. I can do the search form itself...but the action attribute of the form is a .dll file (/dtSearch/dtisapi6.dll).This currently presents me the search results (a la Google) on its own page.Problem is I want to embed this into our current page.If I change the action attribute of the search form to 'page2.cfm' (for example), I'm not quite sure how to go about getting the form data to the .dll and embedding the results into the .cfm page. I've got an email into dtSearch (who, FWIW, have been very responsive), but I'm not quite sure how far they'll go to support my desire to use CF and maintain our own look and feel. Hoping somebody else might have done this already...or might know how I can more effectively use/manipulate the .dll file (instead of using it as the form's action page...somehow passing it attributes and doing a cfinclude-type deal on it. ? Thx! -- Charlie Griefer Marta was watching the football game with me when she said, You know, most of these sports are based on the idea of one group protecting its territory from invasion by another group. Yeah, I said, trying not to laugh. Girls are funny. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: installing Apache for Windows...
Same here. Apache works well on Windows despite the warnings on the website. The Test Configuration shortcut works well also. Aaron - Original Message - From: Bob Haroche To: CF-Talk Sent: Tuesday, September 14, 2004 7:44 AM Subject: Re: installing Apache for Windows... Don't install it as a service.You'll have to start/stop it manually, but it'll run in a MS-DOS window, so you can see any error messages it generates.Particularly helpful for debugging invalid httpd.conf files. Yet even when installed as a service, there's a DOS shortcut created called Test Configuration which lets you...well, you can figure that out. I've had no trouble debugging my httpd conf file using Apache 1.3.29 as a service. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
Hi Greg Have you heard of Coral? It's a CFML clone and looks like it might do what you want. Access only version looks inexpensive and no deployment fees. I am waiting for my free time to be delivered so that I can download and play with it some. http://www.pcaonline.com/coral/index.cfm HTH, Aaron - Original Message - From: Greg Morphis To: CF-Talk Sent: Thursday, September 09, 2004 4:54 AM Subject: OT: (I guess) Local App I've been tasked with building an app for engineers on the road to report how cell phones function. Unfortunately they wont be connected to the internet while on the road. So I'm guessing my only option would be to build something in Java, VB, ASP or something to record the data in an Access DB to upload at a later time to an Oracle DB. The Admin section would be in CF tieing to the Oracle DB. Does anyone have any other options, ideas or comments.. Anything is appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Exactly *how* smart are we?
EQ IQ :) Aaron - Original Message - From: Matt Liotta To: CF-Talk Sent: Monday, August 23, 2004 6:47 AM Subject: RE: Exactly *how* smart are we? Surely it would be interesting to know how one stands against their peers. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Document Version Comparison
Wow, impressive, Micha. Did you do the coding using CFML or Java? Aaron - Original Message - From: Micha Schopman To: CF-Talk Sent: Tuesday, August 17, 2004 7:52 PM Subject: RE: Document Version Comparison I came up with the algorithm because I have some experience with this subject, I haven't found any custom tags being able to compare documents, so I had to create one for a client last week. I don't have the tag by hand, unfortunately. What you have to do is split the strings create a matrix, and loop through the matrix to find the highest cost. Compare this cost to the minimal, diagonal and horizontal cost and you are able to find whether the string is added, modified or removed from the version. The process is very cpu intensive when running on ColdFusion, especially creating the matrix which is len(chars) * len(chars) in length. I also made a PHP implementation which was way more faster than ColdFusion did. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Great Job opportunity... DFW Area
Would you sponsor a green card application? Aaron Dreaming in technicolor - Original Message - From: Bailey, Neal To: CF-Talk Sent: Saturday, August 14, 2004 7:30 AM Subject: Great Job opportunity... DFW Area Hello fellow CFers... The company I work for is looking to fill a CF .NET fulltime position with benefits and all the good stuff. We need someone who is local to the Dallas / Fort Worth area. The requirements are: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF 5.0 and XP
This any use? http://www.macromedia.com/support/coldfusion/ts/documents/tn17834.htm Aaron - Original Message - From: E C list To: CF-Talk Sent: Friday, August 06, 2004 12:43 AM Subject: RE: CF 5.0 and XP Dave, or anyone, Do you have any other clues for me on this.IIS can show me .htm pages, but when I try to view a ColdFusion .CFM file, I just get a 500 error.When I checked on the HOME DIRECTORY CONFIGURATION APPLICATION CONFIGURATION tab in IIS settings for the default site, I do see .cfm mapped to c:\cfusion\bin\iscf.dll... I am not sure what else to look at though. Thanks! -Original Message- From: E C list[mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 8:46PM To: CF-Talk Subject: RE: CF 5.0 andXP Thanks Dave. The problem is that I am getting a500 error when I try to navigate to the Administrator. I thought thiscould be an IIS 5.1 issue, but all the settings seemed to be right. I'lltry the ISAPI extension idea. -Original Message- From:Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 20047:56 PM To: CF-Talk Subject: RE: CF 5.0 and XP Can someoneconfirm that ColdFusion 5.0 works alright on WindowsXP?I am having some trouble getting it going and I amwondering if it just doesn't work. It should work fine. However, ifyou're using IIS, you may have to configure it yourself rather thanletting the CF install do it. Basically, you'll want to create an ISAPIextension within IIS that maps the .cfm file extensionto \cfusion\bin\iscf.dll. Dave Watts, CTO, Fig LeafSoftware http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [mysql] alter column command...
Orderby would indicate a number/integer? Why not alter the table and make it a numeric field type instead? Aaron - Original Message - From: Daniel Farmer To: CF-Talk Sent: Friday, August 06, 2004 8:05 AM Subject: Re: [mysql] alter column command... The problem I was having is in ordering the orderby column. since it places the order like this...eg... Order By orderby asc 10 11 12 2 21 22 When I want it to be like so... 2 10 11 12 21 22 - Original Message - From: Barney Boisvert To: CF-Talk Sent: Thursday, August 05, 2004 5:43 PM Subject: Re: [mysql] alter column command... MySQL will never use CHAR columns if the table uses any variable-length columns (such as VARCHAR or TEXT).In general, it's irrelevant.From the application perspective, there's no difference between VARCHAR and CHAR, so just let the database do it's thing. The reasoning is that if a table has entirely fixed-length columns, the table can be operated on more efficiently, because you can do simple offset arithmetic to locate rows, rather than having to maintain a lookup table of where each row starts.However, fixed-length columns, particularly character data, are usually wasteful.Say you've got CHAR(20) for a firstname.That's 12 wasted bytes to store 'barney'. The tradeoff is for efficiency of execution versus efficiency of storage.Since the execution speed is reduced as soon as there's a single variable-length column, MySQL knows that the only think it can optimize is storage space, so it autoconverts all CHAR columns to VARCHAR. If you have multiple VARCHAR columns and it's possible to convert them all to CHAR, and not have any variable-length columns (keeping in mind that TEXT is also variable-length), you can do it, but you have to do it as a single statement: ALTER TABLE myTable MODIFY col1 CHAR(10), MODIFY col2 CHAR(20) rather than a series of single statements, because after each statement, MySQL will look and see if it should convert CHAR columns to VARCHAR, undoing the work. cheers, barneyb On Thu, 5 Aug 2004 17:17:08 -0400, Daniel Farmer [EMAIL PROTECTED] wrote: I have the following column orderbyvarchar(5) I want to change it to... orderby char(5) I've tried this sql but no luck ALTER TABLE slideshow ALTER COLUMN orderby char(5) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [mysql] alter column command...
I haven't had much experience with MySQL, but I'm guessing VarChar and Char are similar, character based fields, and even if you could change it to Char, it would make no difference to your output order. What I am suggesting is you change the field to an Int: ALTER TABLE slideshow ALTER COLUMN orderby smallint (or similar) Int/smallint is a numeric type: http://dev.mysql.com/doc/mysql/en/Numeric_types.html Char is a string type: http://dev.mysql.com/doc/mysql/en/String_types.html HTH Aaron - Original Message - From: Daniel Farmer To: CF-Talk Sent: Friday, August 06, 2004 8:36 AM Subject: Re: [mysql] alter column command... that's what I was trying to do in changing the varchar to char ( see early on in this thread ) but it's not taking the command - Original Message - From: Aaron DC To: CF-Talk Sent: Thursday, August 05, 2004 6:19 PM Subject: Re: [mysql] alter column command... Orderby would indicate a number/integer? Why not alter the table and make it a numeric field type instead? Aaron [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: The search is killing the server. Please help!
Have a look at the help for CFQUERY and CFOUTPUT. In particular: CFOUTPUT - StartRow and Maxrows attribues. CFQUERY - CachedWithin attribute I would either cache the query or store it in a scope. Then output the records you require using startrow (= (page num -1) * 100) and maxrows (= 100). Aaron - Original Message - From: cf coder To: CF-Talk Sent: Thursday, July 29, 2004 8:25 PM Subject: The search is killing the server. Please help! Hello everybody, I'm working on a logging system. The site search as you can imagine is very complicated and a lot depends on it. I have written a stored procedure for the search to make the search quicker with a lot of inner and outer joins (the usual). The seach is very quick most of the times, but if the search returns say for ex 5000 + records, it takes a while for it to display the results in the browser. I have impletemented paging, the search displays 100 records per page and then you have the prev and next links to choose from. I'll give you an example to hopefully give you a better understanding. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Text Input Field Data not recognized with use of Enter key
Really? Google works fine when you hit enter, with the cursor still in the textbox. A quick check locally... works fine for me too FORM ACTION="" METHOD=POSTINPUT NAME=lalal/FORM I type lalala in the textbox and hit enter and form.lalal = lalala The plot thickens! It may be time for you to share some code! Aaron - Original Message - From: Rick Faircloth To: CF-Talk Sent: Wednesday, July 28, 2004 4:23 PM Subject: RE: Text Input Field Data not recognized with use of Enter key That is true when the cursor is not in the text field at the time the Enter key is hit, but if the cursor is still in the text field, the value of the field is not passed on...at least that's what's happening in this case. Rick -Original Message----- From: Aaron DC [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 28, 2004 12:15 AM To: CF-Talk Subject: Re: Text Input Field Data not recognized with use of Enter key Without seeing your code I cant say 100%, but when a form is submitted (either through clicking submit or hitting the enter key), the textbox form field should always be present. Aaron - Original Message - From: Rick Faircloth To: CF-Talk Sent: Wednesday, July 28, 2004 2:08 PM Subject: RE: Text Input Field Data not recognized with use of Enter key Hi, Aaron... So you're saying that the textbox field value is not being passed and the Search button value is?That makes sense, because if the Search button value was not being passed, the form and none of its fields would be processed. That still leaves a problem...if a user fills in the textbox field, and doesn't click out of the field before hitting the Enter key, then the textbox value isn't passed...at least that's what happened when I tested. It seems they'll just have to be instructed to use the Search button for submitting the form and not the Enter key... Rick -Original Message----- From: Aaron DC [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 27, 2004 11:40 PM To: CF-Talk Subject: Re: Text Input Field Data not recognized with use of Enter key You dont have to - just check for the existence of the textbox field. Aaron - Original Message - From: Rick Faircloth To: CF-Talk Sent: Wednesday, July 28, 2004 1:41 PM Subject: RE: Text Input Field Data not recognized with use of Enter key Hi, Matthew, and thanks for the reply... You're right...the action is dependent upon the Search button value being passed. I guess the solution is to pass another value that will be passed if the Search button is clicked or the Enter key is hit.I guess a hidden field would do the trick... Thanks, again... Rick -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 27, 2004 6:07 PM To: CF-Talk Subject: RE: Text Input Field Data not recognized with use of Enter key When the button is clicked, the associated button value is passed to the form handler. When enter is hit, the button value is not passed. Apparently, your handler page is relying on that button value. _ From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, 28 July 2004 7:22 a.m. To: CF-Talk Subject: Text Input Field Data not recognized with use of Enter key Why would a form which has a Text Input field for keywords not put the keywords into play on the action if the Enter key is used to submit the form instead of the Submit (in this case Search) button is clicked? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Text Input Field Data not recognized with use of Enter key
So you're saying that the textbox field value is not being passed and the Search button value is?That makes sense, because No, I'm saying the textbox will always be submitted, regardless of how the form is submitted. The search button will only be passed if you click it. CFIF IsDefined(Form.Search) This is not the name of the textbox. I checked for the presence of Form.Search when the Enter key is hit while the cursor is in the Keyword Text Input Field and it was not present. This is not the name of the textbox. I said (twice now), check for the presence of the textbox. When the form is submitted by hitting the Enter key, the Search button value is not passed.But the hidden field is passed As is the textbox, as I said the first time I responded to your post. You do not need to add any hidden fields, simply check for the existence of the textbox. So now I've learned something new...don't use the submit button value or presence as a trigger, use the value or presence of a hidden field... And I'm telling you that you don't need to add an unecessary hidden fields, just use the field(s) you already have in the form - eg. the search textbox. Aaron - Original Message - From: Rick Faircloth To: CF-Talk Sent: Wednesday, July 28, 2004 5:42 PM Subject: RE: Text Input Field Data not recognized with use of Enter key Alright, I give... The code for the form and the text input field of concern: Form Name=PropertySearchForm Action="" Method=POST CFIF IsDefined(Form.Search) INPUT Name=Keyword Type=Text Value=CFOUTPUT#Form.Keyword#/CFOUTPUT Size=30 MaxLength=30 Class=TextInput01 CFELSE INPUT Name=Keyword Type=Text Value= Size=30 MaxLength=30 Class=TextInput01 /CFIF /Form I checked for the presence of Form.Search when the Enter key is hit while the cursor is in the Keyword Text Input Field and it was not present. Click outside the Keyword Text Input Field and hit the Enter key and Form.Search is present. The form is submitting back to the page which it's on, if that matters...everything works fine except when the cursor is in the Keyword field when the Enter key is hit. The cursor can be in the Keyword field when the Search button is clicked and everything works fine...go figure... HmmmI just check something else, also.When I select a city for the search (this is a real estate application) and put the cursor in the Keyword field and hit the Enter key, the value for the city is passed by the form, but the value for Form.Search (The Search Button) is not present... (Pause...trying out an idea...) Well, the trick is to have a hidden field in the form and to check for its presence instead of checking for the presence of the value of the Search button.When the form is submitted by hitting the Enter key, the Search button value is not passed.But the hidden field is passed and can be used to trigger the search action involving the Keyword field.You can see from the code above that the Keyword field value was not factored in if the Form.Search field was not defined. So now I've learned something new...don't use the submit button value or presence as a trigger, use the value or presence of a hidden field... Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Text Input Field Data not recognized with use of Enter key
Yeah :) I was trying to help and not being understood, forgive my frustration. You got it working and in the end that's the important thing, well done. Aaron - Original Message - From: Rick Faircloth To: CF-Talk Sent: Wednesday, July 28, 2004 10:59 PM Subject: RE: Text Input Field Data not recognized with use of Enter key Aaron wrote: This is not the name of the textbox. I said (twice now), check for the presence of the textbox. I realize that Form.Search is not the textbox... I also realize that you're saying that I can check to see whether or not any of the formfields in the form are defined for triggering search action based on parameters in the form, rather than adding an extra hidden field. We're both getting to the same place, I'm just taking a longer route to get there. The hidden field method does work, it's just not necessary... I can check for Form.Keyword or Form.PropertyType or whatever, instead... Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Text Input Field Data not recognized with use of Enter key
You dont have to - just check for the existence of the textbox field. Aaron - Original Message - From: Rick Faircloth To: CF-Talk Sent: Wednesday, July 28, 2004 1:41 PM Subject: RE: Text Input Field Data not recognized with use of Enter key Hi, Matthew, and thanks for the reply... You're right...the action is dependent upon the Search button value being passed. I guess the solution is to pass another value that will be passed if the Search button is clicked or the Enter key is hit.I guess a hidden field would do the trick... Thanks, again... Rick -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 27, 2004 6:07 PM To: CF-Talk Subject: RE: Text Input Field Data not recognized with use of Enter key When the button is clicked, the associated button value is passed to the form handler. When enter is hit, the button value is not passed. Apparently, your handler page is relying on that button value. _ From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, 28 July 2004 7:22 a.m. To: CF-Talk Subject: Text Input Field Data not recognized with use of Enter key Why would a form which has a Text Input field for keywords not put the keywords into play on the action if the Enter key is used to submit the form instead of the Submit (in this case Search) button is clicked? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Text Input Field Data not recognized with use of Enter key
Without seeing your code I cant say 100%, but when a form is submitted (either through clicking submit or hitting the enter key), the textbox form field should always be present. Aaron - Original Message - From: Rick Faircloth To: CF-Talk Sent: Wednesday, July 28, 2004 2:08 PM Subject: RE: Text Input Field Data not recognized with use of Enter key Hi, Aaron... So you're saying that the textbox field value is not being passed and the Search button value is?That makes sense, because if the Search button value was not being passed, the form and none of its fields would be processed. That still leaves a problem...if a user fills in the textbox field, and doesn't click out of the field before hitting the Enter key, then the textbox value isn't passed...at least that's what happened when I tested. It seems they'll just have to be instructed to use the Search button for submitting the form and not the Enter key... Rick -Original Message- From: Aaron DC [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 27, 2004 11:40 PM To: CF-Talk Subject: Re: Text Input Field Data not recognized with use of Enter key You dont have to - just check for the existence of the textbox field. Aaron - Original Message - From: Rick Faircloth To: CF-Talk Sent: Wednesday, July 28, 2004 1:41 PM Subject: RE: Text Input Field Data not recognized with use of Enter key Hi, Matthew, and thanks for the reply... You're right...the action is dependent upon the Search button value being passed. I guess the solution is to pass another value that will be passed if the Search button is clicked or the Enter key is hit.I guess a hidden field would do the trick... Thanks, again... Rick -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 27, 2004 6:07 PM To: CF-Talk Subject: RE: Text Input Field Data not recognized with use of Enter key When the button is clicked, the associated button value is passed to the form handler. When enter is hit, the button value is not passed. Apparently, your handler page is relying on that button value. _ From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, 28 July 2004 7:22 a.m. To: CF-Talk Subject: Text Input Field Data not recognized with use of Enter key Why would a form which has a Text Input field for keywords not put the keywords into play on the action if the Enter key is used to submit the form instead of the Submit (in this case Search) button is clicked? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Help! - Dynamically Generate Forms from SQL DB - Bad Idea?
So every time a form is displayed, you are going to dynamically generate it from the database? How often does the form change? Aaron - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: CF-Talk Sent: Wednesday, July 28, 2004 11:24 AM Subject: Help! - Dynamically Generate Forms from SQL DB - Bad Idea? Hello List - I am looking to store information about variables nad form fields in a db to conditionally build html forms - Has anyone stored the variable name, and the form type in a database - and built the form dynamically on the fly? I can't seem to find any references to it and am thinking because it must be a bad idea. Basically - store name| type| state LastName text LastName text HowToContactradiochecked Then build components that write the html form- ie -if it's a radio button - cfoutputinput type=#type# name=#VarName# #state#/cfoutput Another purpose is - if I decide to do forms in Flash - perhaps I can have the database spit out an XML document to use to build the flash interface. Perhaps have the DB spit out XML/ or another format to build PDF forms etc Too complex? Bad Idea - Any products already allowing this (NOT Hosted servies) Thanks! Jason [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: HELP. CF and JavaScript question
Do you know how to do _javascript_ arrays? Wrap your _javascript_ array creation code in a CFOUTPUT and create them in CF, the browser will load the page and create the _javascript_ array. rough example: script // create your _javascript_ array CFOUTPUT QUERY=your query somejsarray[#currentrow#] = '#somefieldname#'; /CFOUTPUT /script HTH Aaron - Original Message - From: Kevin To: CF-Talk Sent: Monday, July 26, 2004 7:35 PM Subject: RE: HELP. CF and _javascript_ question Hi Dick, What I am doing is this. I am creating an Order Entry form and when the user selects the customer from the list created from the query the address and other customer information is then filled in automatically. I am talking about a total of 5 fields that need to be filled in. I had figured that if I placed empty text input boxes where the data was to go, I could then use _javascript_ to change their values to match the customer id selected. I was going to call the function using the onChange property of the dropdown list. Being very new to ColdFusion programming I am not sure if I am making this harder then it needs to be. :-( HELP please. I am begging here. ;-) Thanks, Kevin _ Kevin 1) Are you talking about populating something like 3 selects related 2) do you want populate it in CF then change it in _javascript_ 3) How much data are we talking about 4) Why do you think you need it in a _javascript_ array The reason I ask, is that there are several alternatives, that, based on your answers. Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: HELP. CF and JavaScript question
Yes Kevin, that is exactly the way you would do it... I think. Do a google on 2 dimensional _javascript_ array to get the syntax just right. As a suggestion, give it a go anyway, and see what happens :) the worst that can happen is you get errors and we'll help you with them. You cant break anything or commmit any gross crimes playing with this stuff, cut loose and give it a go :) HTH Aaron - Original Message - From: Kevin To: CF-Talk Sent: Monday, July 26, 2004 7:59 PM Subject: RE: HELP. CF and _javascript_ question Hi Aaron, Up to this point I had only worked in a one dimensional array. (i.e. bannerImg[0] = somebanner1.gif, bannerImg[1] = somabanner2.gif etc.) Now I need to capture 6 fields for each row. I had thought to do what you outlined but got lost with the multi-dimensional array. Would the code for the 2 dimensional array be like this? CFOUTPUT QUERY=your query customerInfo[#currentrow#][ID] = '#customerID#'; customerInfo[#currentrow#][Name] = '#customerName#'; etc.. /CFOUTPUT I truly appreciate all the help and your patients with me. Thanks, Kevin _ Do you know how to do _javascript_ arrays? Wrap your _javascript_ array creation code in a CFOUTPUT and create them in CF, the browser will load the page and create the _javascript_ array. rough example: script // create your _javascript_ array CFOUTPUT QUERY=your query somejsarray[#currentrow#] = '#somefieldname#'; /CFOUTPUT /script HTH Aaron [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: HELP. CF and JavaScript question
I'm curious how cfwddx is easier than the cfoutput junk code sample i submitted. Aaron - Original Message - From: Dick Applebaum To: CF-Talk Sent: Monday, July 26, 2004 8:42 PM Subject: Re: HELP. CF and _javascript_ question OK You could do it with WDDX -- CF has a tag, cfwddx, that converts/transmits CF arrays on the server to _javascript_ arrays on the client. CFWDDX is the easiest way to go if you have a small number of users and a small amount of data. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hackers and Painters - Applied to Cold Fusion
In my opinion, the idea and the implementation are far more important than the language used, when looking at developing a killer app. Plus I did Lisp at uni half a life-time ago and you don't want to go there :) Aaron - Original Message - From: Chuck Mason To: CF-Talk Sent: Monday, July 26, 2004 11:57 PM Subject: Hackers and Painters - Applied to Cold Fusion Was undecided about posting this here versus CF-Jobs-Talk but since it involves a technical question versus being job-related, decided to post to CF-Talk. I've recently read the book Hackers and Painters (by Paul Graham) and it was a very exciting book to read for those of us involved in programming who one day dream of building the next best software product.As Paul Graham speaks of superior programming languages and targets LISP as being the one, this book got me thinking about CF. I've been a CF / Visual Basic guy for the past 6-8 years and know nothing of LISP and/or whether it would be reasonable to study it in terms of designing a Web software product (Viaweb, which sold to Yahoo as their shopping card builder, was programmed in LISP).So to the bottom line ... for those of you Web software developers planning on designing the next best application - one which outperforms all others in it's class (shopping cart builder, lead gen app, etc.), - is Cold Fusion truly the language to focus on?Other contenders are of course Asp.net, PHP, Python, Perl, (and Lisp?).I have found programming Cold Fusion to provide rapid application development over the years but have recently been directed into the dark side (Asp.net) and ... using VisualStudio.net to program Asp.net apps is quite nice impressive, though I miss programming in Cold Fusion. Chuck [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Forums onTap - check 'em out! :)
The page you have requested has generated an error. The system administrator has been notified via email of the problem and will attempt to resolve the issue as quickly as possible Aaron - Original Message - From: S. Isaac Dealey To: CF-Talk Sent: Sunday, July 25, 2004 3:06 PM Subject: Forums onTap - check 'em out! :) Hi All, I just wanted to announce to the list that I've recently launched some new forums for the onTap framework. You can all check them out at: http://www.turnkey.to/ontap/forum They'll be available soon for a nominal fee of $20-25 just to help cover the cost of hosting for the framework. For right now I just want to make people aware of them and get some noise on them so I can identify any more bugs that need to be fixed before anyone buys them and to identify any other ways I can improve the interface. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Forums onTap - check 'em out! :)
working now - i tried plain /ontap/ as well as /ontap/forum and both returned a table cell with an exclamation mark and the error message below. Gremlins, I tells ya! Aaron - Original Message - From: S. Isaac Dealey To: CF-Talk Sent: Monday, July 26, 2004 1:55 AM Subject: Re: Forums onTap - check 'em out! :) Could you try it again? I can't reproduce the error. The page you have requested has generated an error. The system administrator has been notified via email of the problem and will attempt to resolve the issue as quickly as possible Aaron - Original Message - From: S. Isaac Dealey To: CF-Talk Sent: Sunday, July 25, 2004 3:06 PM Subject: Forums onTap - check 'em out! :) Hi All, I just wanted to announce to the list that I've recently launched some new forums for the onTap framework. You can all check them out at: http://www.turnkey.to/ontap/forum They'll be available soon for a nominal fee of $20-25 just to help cover the cost of hosting for the framework. For right now I just want to make people aware of them and get some noise on them so I can identify any more bugs that need to be fixed before anyone buys them and to identify any other ways I can improve the interface. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.turnkey.to/ontap [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Forums onTap - check 'em out! :)
ok oops. Tried again, clicked on the plugins topic and the following page was returned: -- html head titleOoops!There was an error./title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body bgcolor=#ff div align=center table width=349 border=2 bordercolor=#00 cellpadding=10 cellspacing=0tr align=centertdimg src="" border=0 alt=brfont face=arial,helvetica,sans-serif size=2 color=#00bThe page you have requested has generated an error./bbr The system administrator has been notified via email of the problem and will attempt to resolve the issue as quickly as possible.brbr /font/td/tr/table /div /body /html -- In fact clicking on any of the topics results in that page appearing. Clicking on items in the nav tree on the left also causes the same effect. HTH Aaron - Original Message - From: S. Isaac Dealey To: CF-Talk Sent: Monday, July 26, 2004 1:55 AM Subject: Re: Forums onTap - check 'em out! :) Could you try it again? I can't reproduce the error. The page you have requested has generated an error. The system administrator has been notified via email of the problem and will attempt to resolve the issue as quickly as possible Aaron - Original Message - From: S. Isaac Dealey To: CF-Talk Sent: Sunday, July 25, 2004 3:06 PM Subject: Forums onTap - check 'em out! :) Hi All, I just wanted to announce to the list that I've recently launched some new forums for the onTap framework. You can all check them out at: http://www.turnkey.to/ontap/forum They'll be available soon for a nominal fee of $20-25 just to help cover the cost of hosting for the framework. For right now I just want to make people aware of them and get some noise on them so I can identify any more bugs that need to be fixed before anyone buys them and to identify any other ways I can improve the interface. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.turnkey.to/ontap [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
onTap
H While I'm looking through the site - is there a zip/download of the doco for onTap that I can read offline at my leisure? Had a quick look and could not see anything. There are different plugins and components, I guess I'm looking for an offline copy/version of all the supporting notes etc. Would be very keen to wrap my head around its workings. Thanks Aaron - Original Message - From: Aaron DC To: CF-Talk Sent: Monday, July 26, 2004 2:12 AM Subject: Re: Forums onTap - check 'em out! :) working now - i tried plain /ontap/ as well as /ontap/forum and both returned a table cell with an exclamation mark and the error message below. Gremlins, I tells ya! Aaron - Original Message - From: S. Isaac Dealey To: CF-Talk Sent: Monday, July 26, 2004 1:55 AM Subject: Re: Forums onTap - check 'em out! :) Could you try it again? I can't reproduce the error. The page you have requested has generated an error. The system administrator has been notified via email of the problem and will attempt to resolve the issue as quickly as possible Aaron - Original Message - From: S. Isaac Dealey To: CF-Talk Sent: Sunday, July 25, 2004 3:06 PM Subject: Forums onTap - check 'em out! :) Hi All, I just wanted to announce to the list that I've recently launched some new forums for the onTap framework. You can all check them out at: http://www.turnkey.to/ontap/forum They'll be available soon for a nominal fee of $20-25 just to help cover the cost of hosting for the framework. For right now I just want to make people aware of them and get some noise on them so I can identify any more bugs that need to be fixed before anyone buys them and to identify any other ways I can improve the interface. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.turnkey.to/ontap [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: VMWare was Re: Best choice for ColdFusion Studio IDE...
Hey thanks for the feedback, Kay. I'm about to embark on setting up a multi-OS dev box for testing purposes and this helps immensely. If anyone else has any war stories, I'd love to hear them Aaron - Original Message - From: Kay Smoljak To: CF-Talk Sent: Sunday, July 18, 2004 4:48 PM Subject: Re: VMWare was Re: Best choice for ColdFusion Studio IDE... On Sat, 17 Jul 2004 23:11:48 -0400, Jim Davis [EMAIL PROTECTED] wrote: From what I could tell there's very little real difference in how well they work: they both (VMWare and VPC) do a damn, damn fine job. I've used both quite a bit too, and the main differences I've found are: - Virtual PC VM's run quite a bit faster than VMWare VM's (Athlon 1800, 1GB RAM) - Virtual PC's networking seems to work much better - setting up a VM as a computer on your network and getting internet access etc seems to work almost automatically. VMWare installs a networking driver on the host machine for this which I've found sometimes interferes with other network settings, plus getting a VMWare VM to work on a local network can be a major PITA. -Virtual PC VM's are very, very, VERY slow to install. VMWare formats virtual hard drives so fast you hardly see the progress bar. Virtual PC takes longer than a real hard drive to do the same thing, and then Windows takes nearly twice as long to install as it would on a real machine. - I've had problems running out of virtual hard drive space on Virtual PC, even though the drive was set to expand automatically. I never had that problem with VMWare. Given the price difference (and the fact that we got 10 Virtual PC licences with our last Action Pack) we now use Virtual PC, but if you disregarded that and weighed them on their individual merits, it's hard to pick between them. -- Kay Smoljak http://kay.smoljak.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Best choice for ColdFusion Studio IDE...
- Original Message - From: Matt Liotta To: CF-Talk Sent: Friday, July 16, 2004 10:30 AM Subject: RE: Best choice for ColdFusion Studio IDE... SNIP Anyway, I was hoping the days of platform specific software for developers was over. --- I am very curious as to your meaning here. Aaron [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot Button - English pedantry (was: cfmail suddenly not working...very wierd
Now than, that's enough of that! :) Aaron - Original Message - From: Rob To: CF-Talk Sent: Tuesday, July 13, 2004 5:19 PM Subject: Re: Hot Button - English pedantry (was: cfmail suddenly not working...very wierd Sean, Your comments infer that missused grammer bothers you. I think its just the affect of perhaps a couple beers? But of course thats a mute point - excetra. :) On Mon, 12 Jul 2004 21:59:25 -0700, Sean Corfield [EMAIL PROTECTED] wrote: But the error message infers that the login is not being accepted. hot button *implies* You might *infer* from the error message that the login is not being accepted. The error message might well *imply* that the login is not being accepted. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmail suddenly not working...very wierd
Even though server is thisdomain.com and from is [EMAIL PROTECTED] Aaron - Original Message - From: Josh To: CF-Talk Sent: Tuesday, July 13, 2004 1:43 PM Subject: Re: cfmail suddenly not working...very wierd I agree, it appears that way, but it is not so... Howie Hamlin wrote: But the error message infers that the login is not being accepted. Regards, Howie - Original Message - From: Josh To: CF-Talk Sent: Monday, July 12, 2004 9:46 PM Subject: Re: cfmail suddenly not working...very wierd No, the login is correct.I have tested it with a couple different accounts that I know are correct...still no luck! Howie Hamlin wrote: It looks like you are not authenticating to the email server.Maybe the login changed on the server? Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Josh To: CF-Talk Sent: Monday, July 12, 2004 9:05 PM Subject: cfmail suddenly not working...very wierd on one of our servers, cfmail is not working all of the sudden. Here is the code: cfmail to=[EMAIL PROTECTED] cc=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=TESTING123 server=mail.thisdomain.com username=me password=mypassword testing... /cfmail the server is set up not to relay, and requires authentification to be able to send mail.we are supplying the correct user/password and the from address really exists... here is the error in the mail.log: Error,scheduler-3,07/12/04,18:58:40,,Invalid Addresses; nested exception is:javax.mail.SendFailedException: 550 not local host mydomain.com, not a gateway ;nested exception is: javax.mail.SendFailedException: 550 not local host thisdomain.net, not a gateway Any ideas? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmail suddenly not working...very wierd
Nod nod, understood, but was curious as to the TLD (.net == .com) change even when using place holders. Aaron - Original Message - From: Josh To: CF-Talk Sent: Tuesday, July 13, 2004 2:42 PM Subject: Re: cfmail suddenly not working...very wierd those were just place holders...didn't want to publish the domains/emails here. Aaron DC wrote: Even though server is thisdomain.com and from is [EMAIL PROTECTED] Aaron - Original Message - From: Josh To: CF-Talk Sent: Tuesday, July 13, 2004 1:43 PM Subject: Re: cfmail suddenly not working...very wierd I agree, it appears that way, but it is not so... Howie Hamlin wrote: But the error message infers that the login is not being accepted. Regards, Howie - Original Message - From: Josh To: CF-Talk Sent: Monday, July 12, 2004 9:46 PM Subject: Re: cfmail suddenly not working...very wierd No, the login is correct.I have tested it with a couple different accounts that I know are correct...still no luck! Howie Hamlin wrote: It looks like you are not authenticating to the email server.Maybe the login changed on the server? Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Josh To: CF-Talk Sent: Monday, July 12, 2004 9:05 PM Subject: cfmail suddenly not working...very wierd on one of our servers, cfmail is not working all of the sudden. Here is the code: cfmail to=[EMAIL PROTECTED] cc=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=TESTING123 server=mail.thisdomain.com username=me password=mypassword testing... /cfmail the server is set up not to relay, and requires authentification to be able to send mail.we are supplying the correct user/password and the from address really exists... here is the error in the mail.log: Error,scheduler-3,07/12/04,18:58:40,,Invalid Addresses; nested exception is:javax.mail.SendFailedException: 550 not local host mydomain.com, not a gateway ;nested exception is: javax.mail.SendFailedException: 550 not local host thisdomain.net, not a gateway Any ideas? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: keyword 'Where' error
Yes, you cannot specify a where clause in an insert. If you are updating a row then use update not insert. You can't have a where clause on an insert statement. Firstyl, you can't insert using a where clause are you wanting to do an UPDATE??? :) It's late and I feel mischievous, so I will respond to these assertions. You can do inserts using a where if you select values from a table, as follows (MS SQL Server-specific, possibly other DBs also): INSERT INTO TABLE (FIELD LIST) SELECT FIELD LIST FOR VALUES FROM 2.TABLE WHERE WHERE CLAUSE Clearly the syntax of the original post is incorrectly using the WHERE clause, I just wanted to point out that it CAN be used in the right circumstances. In the hope it may help someone down the track! The syntax above will potentially insert multiple records based on the SELECT. HTH Aaron Christiansen and the Prisoner of Micro$oft (Can you tell I've just been to the movies?) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Variable variables?
Yes, I have done this often, using evaluate. Don't tell anyone tho, as Evaluate is hated on for some reason, personally I love it. An equivalent for your PHP code would be: CFSCRIPT i = 123; j = i; writeoutput(Evaluate(j)); // output is 123 /CFSCRIPT NB: As structures are by-reference variables (pointers!), you do not need to do this. Simply do: circuitlang = Application.language.circuitname; // circuitlang.stringname is now the equivalent ofApplication.language.circuitname.stringname assuming language and circuitname are structures... HTH Aaron - Original Message - From: Damien McKenna To: CF-Talk Sent: Saturday, July 10, 2004 12:24 AM Subject: Variable variables? Does CFML support variable variables? In PHP you can define a variable and then define another variable to point to it, e.g.: $i = 123; $j = $$i; print $j; // output is 123 Is there something similar in CFML?At a cursory glance of the books I have looks like it isn't possible. In my situation I've got variables with pretty long names, e.g. #Application.language.circuitname.stringname# and would like to be able to reference it by a shorter method, e.g. circuitlang.stringname, while still retaining the Application scope. Thanks. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: What can I do..
SNIP DEFANGED_cfinput name=txtLogin1 type=text size=15 tabindex=1 required=yes message=Para autenticarse usted necesita de un nombre de usuario. passthrough=class=LetraForm /SNIP SNIP cfset UserId=MyUser.GetUserId(form.txtLogin, form.txtPass) /SNIP SNIP Element TXTLOGIN is undefined in FORM.it's not true. /SNIP SNIP A) Check that your form fields are spelled correctly. /SNIP Looking at your form code, the cfinput is named txtLogin1, but you use form.txtLogin for the GetUserID call. Aaron [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Evaluate?
Although CF is all too happy to display the form fields submitted on a page, I do not think you can have variables names with - in them? Aaron - Original Message - From: Shahzad.Butt To: CF-Talk Sent: Thursday, June 24, 2004 7:48 PM Subject: Evaluate? Hello - can you please check the code below CFSet GetAllContactTypes.PK_ContactType_ID = CAA07070-CD2A-46D6-951F-653630BFD539 cfoutput CFSet a = #Evaluate(Form.#GetAllContactTypes.PK_ContactType_ID#)# /cfoutput Its giving error though from the previous page value of form variable named CAA07070-CD2A-46D6-951F-653630BFD539 is passed to this page. Error Diagnostic Information An error occurred while evaluating the _expression_: a = #Evaluate(Form.#GetAllContactTypes.PK_ContactType_ID#)# Error near line 10, column 18. _ An error has occurred while processing the _expression_: Form.CAA07070-CD2A-46D6-951F-653630BFD539 Invalid parser construct found on line 1 at position 22. ColdFusion was looking at the following text: D6 Form Fields: 02E4F04B-4893-442D-AEAB-859F607B52B1= 02F2DF44-7063-4217-9052-C5E4179CBC73= CAA07070-CD2A-46D6-951F-653630BFD539=fdf ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion Blogging Tool
Ironically, the support forum for this CF blogger is written in ASP? http://www.countersinkdg.com/forum/default.asp On the flip side, I can understand the way you feel when advertising a product and the list responds by pointing out alternatives that are free Did you do much market research before developing this product? Did you perceive a market need or simply decide to sell something you had already written? I am in the process of developing some software for intended developer purchase also. It is fascinating and a learning experience seeing people do a similar thing. I wish you all the best in your endeavours. Regards, Aaron - Original Message - From: Jake To: CF-Talk Sent: Monday, June 21, 2004 12:53 AM Subject: ColdFusion Blogging Tool All, I've noticed that quite a few ColdFusion bloggers have been using PHP and other non-ColdFusion solutions. Seems a bit. odd. (Like CFopen.org being run off PHP!) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: dynamic query names
For this I was thinking I need something like #(#query#).recordcount# - but I can't get the syntax right --- Hi Brian You have the right idea. To get the record count do something like: CFSET RC = Evaluate(#query#.recordcount) which is the equivalent of the old (and I believe deprecated) CFSET RC = ##query#.recordcount# HTH Aaron [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: RDS support (was Re: CFEclipse release - beta
By crikey. Back in my day we had pedals under the desk hooked up to a generator to generate sufficient electrickery to power the hooziwatsits that read punch cards that we had to manually create with a pair of sharp scissors. Our database was a sturdy box holding the punch cards in correct order, and filtering or sorting was all done by hand. User output was handled by copying the cards and posting them to all our users... Ancient Aaron (With even more apologies to Mr Python) - Original Message - From: Howard Fore To: CF-Talk Sent: Thursday, June 17, 2004 11:14 AM Subject: Re: RDS support (was Re: CFEclipse release - beta Access? You were lucky. At work we used to have three Mindspring shared hosting accounts and had to store everything in flat files and string everything together with server-side includes and Perl! You try to tell today's young programmers that and they won't believe you. (With apologies to Monty Python) -- Howard Fore, [EMAIL PROTECTED] On Jun 16, 2004, at 11:21 AM, Paul Kenney wrote: Just think of those poor developers that are forced to work off of shared hosting accounts with no WebDav, a single FTP account, an Access database and no RDS access.Oh, the humanity!They could all be saved! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Help with string manipulation please
name like Jerry Van Morrisonso I want to strip off the characters remaining after the last space and call that lastname. (If they don't have any spaces in their input I'm going to consider the whole thing to be their firstname.) -- How about: CFSET LastName = Trim(ListLast(form.name, )) CFIF LastName EQ CFSET FirstName = Form.Name /CFIF [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: IDX Real Estate
Hi Jeff Never heard of idx before, but using the info you provided, I did the following: www.google.com.au Enter: idx listings explained Click search 3rd result link: IDX QA (well worth looking at imo) At the bottom of that page, it mentions www.car.org At www.car.org enter idx in their search and click provides links titled IDX implementation guide etc etc HTH Aaron - Original Message - From: Jeff Fongemie To: CF-Talk Sent: Tuesday, June 15, 2004 8:53 AM Subject: IDX Real Estate Hey everyone, I've got a client that wants to use IDX information (listings) in thier real estate site. I know almost nothing about IDX. Anyone here use CF to pull IDX listings into a site?? Any tips? There is so much info (junk ads) on this on the web, I can't see anywhere how it is done. Thanks for any info. Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Argh! Ram upgrade killed CF!
Suggestions: 1. make sure the BIOS updated itself to reflect the new RAM 2. turn ON the full RAM check / POSTs in the BIOS just in case you have some bad RAM HTH Aaron - Original Message - From: Jack Dalaa To: CF-Talk Sent: Tuesday, June 15, 2004 7:42 AM Subject: Argh! Ram upgrade killed CF! I'm going totally crazy. Have a Windows 2000 Server with CFMX 6.1. Upgraded the RAM from 512 MB to 1024 MB, and ever since, the server has just died constantly. CF fails to start with error code 2, then when it sometimes start, it terminates quicly, and often won't restart. Haven't touched anything CF-wise, but did try to update jvm.config max heap from 512 to 1024 to see if that made a diff, but not at all, it's still failing! I need help, this is driving me crazy. Jack [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Force Download?
You are linking to an image. Change the link to point to a cold fusion page that does the CFCONTENT tag to suck the image into it. Aaron - Original Message - From: Les Mizzell To: CF-Talk Sent: Thursday, June 10, 2004 11:07 PM Subject: Re: Force Download? Adkins, Randy wrote: Check out CFCONTENT and use the mime type of unknown How would I do that as a link, specifically like: Click [here] to download file. I don't think I can do it directly from the link, which is what the client wants - I'll have to open another page with the cfcontent... tag on it, right? Page in question is here: http://ww2.nmrs.com/lawyers/nelson-mullins-attorneys-bio.cfm?id=11 They want it to work directly from the Photo Download link without opening another page... -- Les Mizzell --- Do geeks die when exposed to sunlight? --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Uploading large files
Morning all I have a client who would like to upload very large files ( 2 MB) into a system developed over a number of years now. The connection between sites is not always the best in terms of speed. I find the page times out regardless of the requesttimeout setting, these files are videos and presentation files/pps/pdf etc. Has anyone had experience in solutions for this? They are using bog-standadrd IIS/IE. Your help would be greatly appreciated Aaron Atomic Software http://www.atomic-software.com.au phone: +61 409 430 231 email: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Uploading large files
- Original Message - From: Philip Arnold To: CF-Talk Sent: Thursday, June 10, 2004 9:04 AM Subject: Re: Uploading large files On Thu, 10 Jun 2004 08:45:08 +1000, Aaron DC wrote: Has anyone had experience in solutions for this? They are using bog-standadrd IIS/IE. Use FTP? Is this something you have done? ie the application is a project tracking/management system with a public and a private documents section. If a file is uploaded then CF is in control so to speak, and saving the document against a project is a straightforward task. Retrieving the document and displaying it as part of a project are also simple tasks. Saving the document as a private/public one is easy, as is moving documents between the two categories. Once we step outside the CFML realm (eg using FTP), the process for linking documents to projects, nominating destination directories, indicating private or public status on the document are all things that need to happen. And we are not necessarily dealing with tech-savvy or computer literate people, so as simple a process as possible is preferable. The majority would not have a clue what FTP is, for example. I have considered developing a purpose-built (desktop) application with FTP built in, that will do all the project linking, directory selection etc etc transparent to the user. This would allow me to do resume uploads etc also and make it all quite functional. This application would have a browser built-in (IE COM), so they could use it for all system access. I would appreciate a little more information on your proposed solution. My preference would be a soution through CFML/browser. Any other takers? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: variable as a string
DateFormat(yourvar, mm-dd-) Aaron - Original Message - From: JT To: CF-Talk Sent: Tuesday, June 01, 2004 9:32 AM Subject: variable as a string Hi Gang, I have a variable as a string Tuesday, June 1, 2004 What I am Trying to figure out is how can I change it to 06-01-2004 Any one can tell me if it can be done and how? JT [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: parsing help for a slow learner
Hi Seamus You have a few people helping you already, but I thought I would share how I would do this for a different perspective: basically, I ask myself how would I do this manually, then map the process to code. I guess it helps to be able to think like a computer, but I digress. An alternative to the dynamic SQL generation is provided using [ ] instad of . Step 0: Get access to the file CFFILE ACTION="" VARIABLE=inFile etc etc Step 1: process each line This step includes recognizing that each piece of information is on a separate line (Chr(13)Chr(10)), and that on each line we have the metadata (BOOS, ANAM, TNAM, etc), separated from the data with a | character. NB: I treat things (everything!) as a list. I don't/can't do regex in my head, I do lists. [CFSET Record = StructNew()] CFLOOP LIST=#inFile# DELIMITERS=#chr(10)# INDEX=aLine Step 2: recognize records: This step includes grabbing the metadata for subsequent use Start = BOOS| End = BOOE| CFSET Meta = ListFirst(aLine, |) Just for fun (to handle a simple potential problem of missing fields/data), we will dynamically create the insert SQL statement as we go. To do this we will need 2 strings - the field list and the value list. We may as well initialize them at the start of a record. NB: to keep it simple, we are also going to treat all fields as string. You can modify this process as you see fit. CFIF Meta EQ BOOS CFSET FieldList = CFSET ValueList = [CFSET junk = StructClear(Record)] If it's the end of the record, we should insert it into the database... CFELSEIF Meta EQ BOOE CFQUERY DATASOURCE=etc etc INSERT INTO Books (#FieldLIst#) VALUES (#ValueLIst#) /CFQUERY [Do your data insert here, using the key/value data from the Record struct] Step 3: recognize fields We have tested for start and end of record, everything else is assumed to be a field: build up the field and value lists accordingly... CFELSE CFSET FieldData = Trim(ListRest(aLine, |)) CFSET FieldList = ListAppend(FieldList, Meta) CFSET ValueList = ListAppend(ValueList, '#FieldData#') [CFSET junk = StructInsert(Record, Meta, FieldData)] /CFIF /CFLOOP That will pretty much do want you want. HTH Aaron - Original Message - From: Seamus Campbell To: CF-Talk Sent: Monday, May 31, 2004 1:46 AM Subject: parsing help for a slow learner Hi I'm hoping some-one can help me. I have to parse a file to insert data into a database, and I'm stuck on the initial parsing. (I have some sort of mental block when it comes to this sort of stuff) A sample of the file is at the bottom of this email. each record is starts with BOOS| and ends with BOOE| At the moment I am reading the file, then replacing the BOOS| with a ~ and looping thru the file using the new delimiter (~) This way I can get each record but I can't seem to then get each field. I have tried: CFFILE file=#myFile# action="" variable=myData cfset myDelim = BOOS| cfset myData = Replace(myData,myDelim,~,ALL) cfloop index=myLine list=#myData# delimiters=~ cfloop index=myRecord list=#myLine# delimiters=#Chr(10)##Chr(13)# cfset Field = left(Trim(myLine),4) cfset Data = "" |)) !--- Input data here --- /cfloop hr /cfloop But this seems to get BOOK and then the rest of the record ie doesn't see a new line Any help at all would be greatly appreciated Seamus BOOS| BOOK|04 TRAN|D ANAM|ROTH, WALTER E. TNAM|NORTH QUEENSLAND ETHNOGRAPHY Bulletin No.4 : GAMES, SPORTS AND AMUSEMENTS PBLS|Home Secretary's Department Brisbane, 1902 SUB1|ABORIGINAL CULTURE, AUSTRALIA HISTORY, NATIVE MONOGRAPHS, 19TH CENTURY SPORTS DESC|Good. 1st. 13.25 x 8.25. a Monograph of 39pp, illustrated by photograph and drawings, the endpapers have browned and the exceedingly plain covers have surface tarnish but a bright interior on superior paper. Walter E.Roth was Queensland's Northern Protector of Aboriginals previously he was Demy of Magdalen College, Oxford. PRIC|35 UPDT|10/05/2004 UPTM|12:44:38 PM BCAT|Sold ABLE|1 UBID|1 STAT|Sold PPRC|0 PDSC|QLD BOOE| BOOS| BOOK|15 TRAN|A ANAM|Paul De Nooijer TNAM|Magie in De Vleeshal : De Fotografie Van Paul De Nooijer PBLS|Middleburg: Deze Publikatie, 1987 SUB1|PAUL DE NOOJIER, NETHERLANDS PHOTOGRAPHER, DUTCH PHOTOGRAPHY , DRAMATIC VISUAL ART DESC|Illustrated Card. Very Good. 1st. Softcover. 8.5 x 9.25. 50pp with triple expanding heart 111 Kleurprints. A major art work by an icon Dutch photgrapher, covers a little rubbed. In all my work I have wanted to involve the framework in the representation so as to suggest what is taking place behind it. PRIC|25 UPDT|8/05/2004 UPTM|1:36:35 PM BCAT|Art ABLE|1 UBID|3 STAT|For Sale PPRC|0 PDSC|art BOOE| BOOS| BOOK|18 TRAN|A ANAM|A H Archibald Henry Rea, Illustrated by Max Cowper TNAM|LINDORES ABBEY and It's Historic Associations PBLS|Dundee: James P. Mathew, 1902 SUB1|LINDORES ABBEY, ECCLESIASTICAL ARCHITECTURE, SCOTTISH PILES MAX COWPER DESC|Illustrated Boards. Good. 1st. Travel and Historic Guide.
Re: Text file problem
[Non-cf suggestions] Not sure what database you are using but 77k record parsing/insert sounds like a prime candidate for Stored Procedure processing - take it to the database and let the database server do its magic. CF is obviously not built for / handling that kind of processing. Hmmm if memory serves, some databases also have the ability to do inserts directly from a CSV file. The details escape me for now [maybe something like INSERT into TABLENAME (#fieldlist#) VALUES (SELECT * FROM 'PATH TO CSV FILE')] but your database may have specific help regarding this ability. Another possibility is to treat the uploaded CSV file as an ODBC datasource (Microsoft Text Driver (*.txt, *.csv)). Again, your O/S is not mentioned, but if you're on windows, this would allow you to do the INSERT mentioned above treating the file as a second datasource - do a QoQ (do they let you do inserts?) and the O/S ODBC driver handles the file access for you... HTH Aaron - Original Message - From: Pete Ruckelshaus - CFList To: CF-Talk Sent: Friday, May 21, 2004 12:36 AM Subject: Text file problem Hi, I'm writing an application that allows our client support reps to import customer files of a predefined format into our database.The CSR uploads (form via CFFILE) the tab-delimited text file to the server, and then I loop through the file contents and insert the data into the database.So far, it has worked great. Well, we're getting bigger clients and we just got a 77,000 record file to import, and my import script died at about 52k records.In debugging it, what I found was that I was bumping against the max JVM heap size (we have it set at 512MB for all of our servers, and we came to this number after a long and painful period of performance and reliability testing of our application); if I bumped up the max heap size on my development workstation, the import script worked fine.Unfortunately, that's not an option for our production servers, and I also expect that our import files will keep getting larger. So, my thinking is to split the really big import file into a number of smaller files, probably 40-50k records per tab-delimited file.However, I'm trying to figure out what the most elegant way is to split these big files into smaller ones, and do it without killing performance.Has anyone done this? Thanks, Pete [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]