Re: Changed internal IP addresses on server - cffile breaks?
Michael, It sounds like you have a WINS Server running on your network that isn't getting updated. The computer name and ip address may be statically assigned in the WINS manager. ~Dan -Original Message- From: Patti, Michael Sent: Friday, July 01, 2011 11:35 AM To: cf-talk Subject: Changed internal IP addresses on server - cffile breaks? I recently had to change the internal IP addresses of my Windows 2003 (32 bit) server that is running CF8 standard. The IPs were changed from a 10.0.0.x format to 192.168.31.x format. After the change was made, CF appeared to be running fine; but I'm running into a problem with cffile not writing .htm files to the file system. When I add entries to the server's hosts file to hardcode the mapping to the new internal IP addresses, it works fine, so somewhere in the server's internals, some file isn't picking up on the change. Is there anything that needs to be done in Coldfusion to register the change of the internal IP addresses? Thanks, Michael ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346027 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Changed internal IP addresses on server - cffile breaks?
Q? If you remove the server from host file and in DOS type in nslookup enter and type in {servername}. Does it report back the correct ip address? If not, Your dns server doesn't have the updated ip address for your server. If it does report back correctly. Exit out of NSLOOKUP and while still in DOS ping {servername}. If it reports back wrong, type in ipconfig /all and see where your WINS ip address is pointing to and fix it on that server. This takes CF out of the question and it's a Windows computer resolving issue. -Original Message- From: Russ Michaels Sent: Friday, July 01, 2011 12:57 PM To: cf-talk Subject: Re: Changed internal IP addresses on server - cffile breaks? not likely that just looks like an install file, perhaps it is .net connecting to CF on the old IP ? On Fri, Jul 1, 2011 at 5:21 PM, Patti, Michael mpa...@sherwood-group.comwrote: I am finding entries for the old IP addresses in C:\Coldfusion8\ConnectorInstall0.txt, that look like this: ... Found JRun server coldfusion at 127.0.0.1:2930 this host is TSGIWEB02:10.0.0.2 this host is TSGIWEB02:10.0.0.29 this host is TSGIWEB02:10.0.0.27 ... Would those entries need to be updated? -Original Message- From: Patti, Michael Sent: Friday, July 01, 2011 11:16 AM To: cf-talk Subject: RE: Changed internal IP addresses on server - cffile breaks? The program that's trying to write the file is an ancient CMS that used to be called 'ActiveMatter' and has been re-branded as 'iMIS eContent Manager'. It makes use of a .net-driven publishing service that also lives on the web server. The publishing service basically queries a database server that is located in a different network, and when it finds records that need to be published, it tries to establish a connection with CF, which then attempts to write a static HTML file containing the ntext value stored in the database for the content record that has been created/updated. It's the hand-off between the publishing service and CF where things are breaking down; and the specific error CF is reporting is: Failed to get fused content from http://www.[mydomain].org/AM/Template.cfm?Section=Mission_StatementTemplate=/CM/HTMLDisplay.cfmContentID=3229FuseFlag=1. The underlying connection was closed: Unable to connect to the remote server. System.Net.WebException As I mentioned, hard-coding the new internal IP address mappings into the hosts file corrects the problem; but that doesn't address the underlying cause. Thanks, Michael -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Friday, July 01, 2011 11:05 AM To: cf-talk Subject: Re: Changed internal IP addresses on server - cffile breaks? I presume you are using CFFILE to write files to another server on the network not to the local machine ? do you have any actual error you can give us ? Russ On Fri, Jul 1, 2011 at 4:52 PM, Patti, Michael mpa...@sherwood-group.com wrote: Yeah, I've restarted both CF and the entire server a couple of times since the IP addresses were first updated (Early Sunday evening). When I run ipconfig /all on the server, it's reporting back the correct IP addresses (in the 192.168.31.1-n range), I've updated all of the bindings in IIS6 to the new IPs, and the sites have been responding fine; it's just that one aspect of CF that seems to be off. Is there a way to manually jog CF into clearing its DNS cache? -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Friday, July 01, 2011 10:47 AM To: cf-talk Subject: Re: Changed internal IP addresses on server - cffile breaks? CF caches DNS, have you restarted CF since ? On Fri, Jul 1, 2011 at 4:44 PM, Dan Blickensderfer d...@blickensderfer.comwrote: Michael, It sounds like you have a WINS Server running on your network that isn't getting updated. The computer name and ip address may be statically assigned in the WINS manager. ~Dan -Original Message- From: Patti, Michael Sent: Friday, July 01, 2011 11:35 AM To: cf-talk Subject: Changed internal IP addresses on server - cffile breaks? I recently had to change the internal IP addresses of my Windows 2003 (32 bit) server that is running CF8 standard. The IPs were changed from a 10.0.0.x format to 192.168.31.x format. After the change was made, CF appeared to be running fine; but I'm running into a problem with cffile not writing .htm files to the file system. When I add entries to the server's hosts file to hardcode the mapping to the new internal IP addresses, it works fine, so somewhere in the server's internals, some file isn't picking up on the change. Is there anything that needs to be done in Coldfusion to register the change of the internal IP addresses? Thanks, Michael
Re: Changed internal IP addresses on server - cffile breaks?
Michael, What you are experiencing is correct when it comes to the external dns resolving. The firewall is preforming the translation from your public ip to your internal ip. There may need a change in the firewall to make this work correctly with new ip address. I've seen this exact thing happen when the firewall was missing a translation configuration or a host lookup record. I would contact the network support and have them check the firewall settings to see if they have forgot to change any settings from old ip to the new ip. My 8 servers do exact same thing as your server is doing resolving to public ip and I had to setup an internal dns server to allow my servers to resolve the computer names correctly instead of modifying my lmhost and host files on each server. Good luck. Dan -Original Message- From: Patti, Michael Sent: Friday, July 01, 2011 5:27 PM To: cf-talk Subject: RE: Changed internal IP addresses on server - cffile breaks? When I run 'ipconfig /flushdns' from the web server, it reports back: --- Windows IP Configuration Could not flush the DNS Resolver Cache: Function failed during execution. --- I did 'ipconfig /all' to check whether the web server has WINS proxy enabled. It does not. It might be that the DNS servers used by web server are caching, but the server itself does not have the 'DNS server' service enabled. The web server is located at a data center, so it's entirely possible that the external DNS servers have cached settings, but would that affect communications between to services running on the same machine? That seems to be what's happening here, because the publishing service and Coldfusion are running on the same machine, and the problem occurs when the publishing service tries to contact CF on the (wrong) IP address. Dan Blickensdorfer asked what happened if I removed the server from the hosts file and then did an nslookup for {servername}. The hosts file doesn't have an entry for {servername}, just '127.0.0.1 localhost' and the entries I added to correct the problem. When I do an nslookup for {servername}, it points to the external DNS server, and then reports back: --- C:\Documents and Settings\usernslookup [myservername] Server: cache01.theplanet.com Address: 67.19.0.10 *** cache01.theplanet.com can't find [myservername]: Non-existent domain --- Note that I'm omitting the actual name of my server in this e-mail, so [myservername] is not the literal value I'm doing the nslookup against. When I ping [myservername], it does report back the correct primary internal IP address of the server (192.168.31.2). The entries added to the hosts file force the server to look to the new internal IP addresses assigned to the server, but when I comment out those entries and ping again, it's resolving to the *external* ip addresses for those sites, which might suggest that the publishing service is using the domain name to establish the connection (it's a web service, after all) and when it has to reach out beyond the boundaries of the server, it's going through the external DNS server to find the domain, receives a bad response (10.0.0.x) and fails at that point? Something like this: With host entries in place: Publishing service --- www.[domain].com --- 192.168.31.x --- found it, good, call CF --- publish the record Without the host entries in place: Publishing service --- www.[domain].com --- external DNS server (67.19.0.10) --- www.[mydomain].com --- 10.0.0.x --- can't find it, bad, kablooie. Does that seem to make any sense? -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Friday, July 01, 2011 3:12 PM To: cf-talk Subject: RE: Changed internal IP addresses on server - cffile breaks? Have you flushed DNS on the two machines? ipconfig /flushdns .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Patti, Michael [mailto:mpa...@sherwood-group.com] Sent: Friday, July 01, 2011 11:36 AM To: cf-talk Subject: Changed internal IP addresses on server - cffile breaks? I recently had to change the internal IP addresses of my Windows 2003 (32 bit) server that is running CF8 standard. The IPs were changed from a 10.0.0.x format to 192.168.31.x format. After the change was made, CF appeared to be running fine; but I'm running into a problem with cffile not writing .htm files to the file system. When I add entries to the server's hosts file to hardcode the mapping to the new internal IP addresses, it works fine, so somewhere in the server's internals, some file isn't picking up on the change. Is there anything that needs to be done in Coldfusion to register the change of the internal IP addresses? Thanks, Michael ~| Order the Adobe Coldfusion Anthology now!
Re: How to do this with CF and JS?
Rick, Is this how you want to source code to look on the page? script $.sound.play('soundTrack01.mp3[1]'); $.sound.play('soundTrack02.mp3[2]'); $.sound.play('soundTrack03.mp3[3]'); /script Here is the code that I used to render it. cfset myList = soundTrack01.mp3,soundTrack02.mp3,soundTrack03.mp3 cfset listPosition = 1 / script cfloop list=#myList# index=listElement cfoutput $.sound.play('#listElement#[#listPosition#]'); /cfoutput cfset listPosition = listPosition + 1 / /cfloop /script or like this script $.sound.play('soundTrack01.mp3'); $.sound.play('soundTrack02.mp3'); $.sound.play('soundTrack03.mp3'); /script Here is the code that I used to render it. cfset myList = soundTrack01.mp3,soundTrack02.mp3,soundTrack03.mp3 cfset listPosition = 1 / script cfloop list=#myList# index=listElement cfoutput $.sound.play('#listElement#'); /cfoutput cfset listPosition = listPosition + 1 / /cfloop /script ~Dan -Original Message- From: Rick Faircloth Sent: Wednesday, June 08, 2011 2:03 PM To: cf-talk Subject: RE: How to do this with CF and JS? Hmmm... it didn't like that one either: You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members. The error occurred in E:\inetpub\webroot\html5css3\fadeImages3.cfm: line 20 18 :cfloop list=myList index=listElement 19 : 20 : $.sound.play('#myList.name[listPosition]#'); 21 : cfset listPosition = listPosition + 1 / 22 :/cfloop -Original Message- From: Drew Nathanson [mailto:d...@technicalsynergy.com] Sent: Wednesday, June 08, 2011 1:45 PM To: cf-talk Subject: Re: How to do this with CF and JS? Rick, Try this: cfset myList = soundTrack01.mp3,soundTrack02.mp3,soundTrack03.mp3 cfset listPosition = 1 / cfoutput script cfloop list=myList index=listElement $.sound.play('#myList.name[listPosition]#'); cfset listPosition = listPosition + 1 / /cfloop /script /cfoutput I believe your creating more than 1 script file maybe causing you issues. This is my humble opinion. Drew Nathanson Technical Synergy, Inc. To be clearer, everything works fine, except for the fact that nothing loops. I get the first sound track, soundTrack01.mp3, played once, and then everything stops. Re-writing the JS into the DOM with every iteration is the only other possibility I can think of which will allow the JS to be re-initialized with each loop. this doesn't work? /cfoutput /script cfset listPosition = listPosition + 1 / /cfloop ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345126 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQUERY update Firefox wierdness
I checked and it's turned off. This is happening from multiple computers with Firefox. Any other thoughts? -Original Message- From: Matt Quackenbush Sent: Tuesday, April 19, 2011 12:20 AM To: cf-talk Subject: Re: CFQUERY update Firefox wierdness Wild guess: Firebug is turned on and is adding a second click to the flow. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343840 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQUERY update Firefox wierdness
Kym, I figured out what was causing the page to load twice. Within my page I had an abandon background-image:url(); within one of my style tags. Once I removed it everything is working correctly with Firefox on all machines. I guess Firefox tries to fetch the url() and since it's not referring to a url it reloads the same page. This was driving me crazy. Dan -Original Message- From: Kym Kovan Sent: Tuesday, April 19, 2011 7:23 AM To: cf-talk Subject: Re: CFQUERY update Firefox wierdness On 19/04/2011 8:46 PM, Dan Blickensderfer wrote: I checked and it's turned off. This is happening from multiple computers with Firefox. Any other thoughts? in that case turn it on and look at what the browser is sending... -- Yours, Kym Kovan mbcomms.net.au ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343858 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFQUERY update Firefox wierdness
Hi Everyone, I have a really strange issue that I can not figure out how to fix it. I have a simple shopping cart and everything works exactly the way it should in ie7 ie8 but firefox not so much. This is the issue. When customer clicks on the item to add to cart it first checks to see if the item is already in the cart. If not, insert new record. If found, update the record and add 1 to the qty. Within IE this works just as it should, Firefox runs the update query regardless of new insert or not. example. item ABC new to cart with qty 1 if I look at the database table I see the qty is 2. If the item is already in database with qty 1 and item is added to cart the qty is now 3. I've turned on debug and looked at all queries ran and the the correct queries do show. It's like there is another update query someplace but there isn't. I tested this by removing the query named updatecart and tried the process again and new records do get added and the qty is correct with 1 not 2. With it being removed and item is updated to cart. it doesn't get updated like it should be. This is very very weird! The code that I'm having strange is the following. I just copied the bit that I need to show. Anybody seen this before? Thanks, Dan Blickensderfer cfquery name=lookupcart datasource=#application.datasource# username=#application.username# password=#application.password# select rec_id from order_items where rec_status = 'T' and session_uuid = cfqueryparam cfsqltype=cf_sql_varchar maxlength=36 value=#session.cartid# and products_rec_id = cfqueryparam cfsqltype=cf_sql_integer value=#variables.recid# /cfquery cfif lookupcart.recordcount is 0 cfquery name=addcart datasource=#application.datasource# username=#application.username# password=#application.password# insert into order_items (rec_status, session_uuid, products_rec_id, product_name, qty, orders_rec_id, ip_address) values ('T', cfqueryparam cfsqltype=cf_sql_varchar maxlength=36 value=#session.cartid#, cfqueryparam cfsqltype=cf_sql_integer value=#variables.recid#, cfqueryparam cfsqltype=cf_sql_varchar value=#getproduct.product_name# maxlength=150, cfqueryparam cfsqltype=cf_sql_integer value=1, cfqueryparam cfsqltype=cf_sql_integer value=#lookuporder.rec_id#, cfqueryparam cfsqltype=cf_sql_varchar value=#trim(cgi.REMOTE_ADDR)# maxlength=17) /cfquery cfelse cfquery name=updatecart datasource=#application.datasource# username=#application.username# password=#application.password# update order_items set qty = qty + 1 where rec_status = 'T' and rec_id = cfqueryparam cfsqltype=cf_sql_integer value=#lookupcart.rec_id# /cfquery /cfif Here is the debug info lookupcart (Datasource=XYX, Time=0ms, Records=0) in templates\includes\cart-add.cfm @ 18:50:44.044 select * from order_items where rec_status = 'T' and session_uuid = ? and products_rec_id = ? Query Parameter Value(s) - Parameter #1(cf_sql_varchar) = 69B9132F-943D-2A28-E56878FCFEA4A5B6 Parameter #2(cf_sql_integer) = 17 addcart (Datasource=XYX, Time=0ms, Records=1) in templates\includes\cart-add.cfm @ 18:50:44.044 insert into order_items (rec_status, session_uuid, products_rec_id, product_name, qty, orders_rec_id, ip_address) values ('T', ?, ?, ?, ?, ?, ?) Query Parameter Value(s) - Parameter #1(cf_sql_varchar) = 69B9132F-943D-2A28-E56878FCFEA4A5B6 Parameter #2(cf_sql_integer) = 17 Parameter #3(cf_sql_varchar) = Green, Yellow Orange Parameter #4(cf_sql_integer) = 1 Parameter #5(cf_sql_integer) = 5014 Parameter #6(cf_sql_varchar) = 192.168.10.159 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343833 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Mail Server Software
Dan P, I use hmailserver it has a MySQL database back end and it's free. It's windows only and you can download it from www.hmailserver.com I have some cf apps that I wrote and use that database to make changes. It works quite well. Dan B - Original Message - From: Dan Pacitti d...@aspmedia.co.uk To: cf-talk cf-talk@houseoffusion.com Sent: Monday, May 10, 2010 8:53 AM Subject: Mail Server Software Does anybody know of a good mail server with some sort of SQL or CF integration? A few years back we were looking at IMS mail server. Thanks DanP ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333562 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Where do i find CFGRID Code?
Mike, Make sure you have the virtual directory cfide setup on your sub domain website. That virtual directory needs to be pointing to your cfide directory of your server. I've ran into that as well but just not cfgrid. it was all cfide components. Thanks, Dan - Original Message - From: Mike Kear afpwebwo...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Wednesday, April 21, 2010 1:08 PM Subject: Re: Where do i find CFGRID Code? Can anyone tell me why this happens?? If i run a page in the root of a site, the CFGRID works. If i run the precise same file in the same relative location of a subdomain of that site, it doesnt. Can anyone see what i've got wrong here? Here is the relevant code: ! First collect the data from the database --- cfquery name=qtestquery datasource=#application.dsn# select EmployeeID, GivenName, Surname, Bundyno from dbo.tblEmployee /cfquery ! Do a dump of the data to prove the query object exists and there are records to display cfdump var=#qtestquery# label=TestQuery !--- Open the CFFORM tag, using the ScriptSrc attribute, using an absolute path, not a relative one cfform name=Form1 action=submit.cfm scriptsrc=/cfide/scripts cfinput type=text name=Testfield value=#application.applicationname# label=Test of the cfforms validate=email message=Checking the validation/ cfgrid name=employee_grid query=qtestquery selectmode=single cfgridcolumn name=EmployeeID cfgridcolumn name=GivenName cfgridcolumn name=Surname /cfgrid br cfinput name=submitit type=Submit value=Submit /cfform If you go to the working link: http://adcalpos.net/trygrid.cfm you'll see it works, therefore the CFGRID applet has been installed ok, then if you go to the subdomain version of the exact same file at http://shard.adcalpos.net/trygrid.cfm you'll see now it cant find the CFGRID applet. Any one see what i need to change in the subdomains to make CFGRID work? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Apr 22, 2010 at 2:18 AM, Dave Watts dwa...@figleaf.com wrote: So here's my question: [A] do you think the cause of this problem is that the location of the CFGRID code is non-standard and therefore i need to use the scriptsrc= attibute of the CFFORM tag? Yes, I think that's the cause, although honestly I don't know whether changing SCRIPTSRC works with the Java grid. [B] If yes, where is it to be found? what am i looking for? /CFIDE/classes/* Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or ons ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333064 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: iframe cfscript getting parent form field values SOLVED
I just wanted to give you an update on how I was able to get this to work. On my iframe page, this is all I had to do to get my javascript variable to assign it to a cf variable. Thanks for those to helped. Dan cfscript getdatefield = (' script language=JavaScript !-- document.write(parent.document.eform.part_date.value); //-- /script '); /cfscript cfoutput#getdatefield#/cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330995 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
iframe cfscript getting parent form field values
Hi everyone, I've ran into a problem and do not know if cfscript will allow this. I have a page that has an iframe and a form named eform with a half of dozen fields. I have a javascript function onblur on the last field to call another cf page (page2) through the iframe. I'm trying to get cfscript on the page2 to get the values of the eform of the parent page and set them to cf variables to query data and other logic. Will cfscript allow this and what would the proper syntax be? Thanks, Dan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330987 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: iframe cfscript getting parent form field values
Can I set the form value to a cfset variable? - Original Message - From: Andrew Scott andr...@andyscott.id.au To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, February 20, 2010 10:01 PM Subject: RE: iframe cfscript getting parent form field values No, Cfscript is server side scripting. You need to write javascript to do this using document.all.form[0] -Original Message- From: Dan Blickensderfer [mailto:d...@blickensderfer.com] Sent: Sunday, 21 February 2010 1:40 PM To: cf-talk Subject: iframe cfscript getting parent form field values Hi everyone, I've ran into a problem and do not know if cfscript will allow this. I have a page that has an iframe and a form named eform with a half of dozen fields. I have a javascript function onblur on the last field to call another cf page (page2) through the iframe. I'm trying to get cfscript on the page2 to get the values of the eform of the parent page and set them to cf variables to query data and other logic. Will cfscript allow this and what would the proper syntax be? Thanks, Dan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330989 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: iframe cfscript getting parent form field values
I have what I'm asking working but it passes everything via url variables to the iframe but I'm afraid that I may run into url max length limitation. This is why I was hoping to get the form field values without passing them via the url. Here is what I have. This is the form page. script language=JavaScript function savenewlineitem(fieldname,fieldvalue) { frames['lookupformdata'].location.href = /templates/test-iframe-javascript.cfm?rec_command= + document.lform.rec_command.value + field= + fieldname + fv= + fieldvalue.value + lid= + document.lform.lrecid.value + rid= + document.eform.recid.value + pd= + document.eform.part_date.value + pn= + document.eform.part_no.value + pdes= + document.eform.part_desc.value + pin= + document.eform.parent_item_no.value + qpu= + document.eform.qty_per_unit.value + w= + document.eform.weight.value + n= + document.eform.notes.value; } /script iframe frameborder=0 vspace=0 hspace=0 marginwidth=0 marginheight=0 name=lookupformdata id=lookupformdata align=middle class=mini height=0 width=0/iframe cfform method=post id=eform name=eform textarea name=notes rows=8 tabindex=7 cols=50 class=mini onblur=savenewlineitem()/textarea/td /cfform cfform method=post id=lform name=lform cfinput type=text tabindex=8 class=mini maxlength=6 name=qty size=10 onblur=savenewlineitem('qty',this.form.qty) required=Yes message=You must have a qty. cfinput type=text tabindex=9 class=mini maxlength=255 name=item_desc size=40 required=No onblur=savenewlineitem('item_desc',this.form.item_desc) other input form fields /cfform This is the iframe test-iframe-javascript.cfm page cfif isdefined(url.pd) and isdefined(url.pdes) and isdefined(url.pin) and isdefined(url.pn) and isdefined(url.qpu) and isdefined(url.w) and isdefined(url.n) insert url values to database. other cf logic etc. /cfif results from above logic may or may not clear the parent form fields. parent.document.lform.qty_shipped.value = ; parent.document.lform.qty_backordered.value = ; parent.document.lform.um.value = ; parent.document.lform.item_no.value = ; parent.document.lform.vendor_item_no.value = ; parent.document.lform.item_desc.value = ; parent.document.lform.qty_shipped.focus(); I do not want the parent page to refresh or reload. Do you see any other method that is easier? Dan - Original Message - From: lists li...@commadelimited.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, February 20, 2010 11:49 PM Subject: RE: iframe cfscript getting parent form field values You could make this MUCH easier on yourself and just do a form POST into the iframe. Hekc, you could even use GET if you wanted to. Regardless, just target the iframe using JS then set hidden form fields to get passed in to. andy -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Saturday, February 20, 2010 10:17 PM To: cf-talk Subject: RE: iframe cfscript getting parent form field values No, if you are doing what I think you are trying to do then your best bet is Ajax. Once the server has processed the request, the client (browser) has control of the final request. If you are looking at populating things before the client receives it then you could do something like this cfoutput input value=#form.someValue# / /cfoutput However if you are looking at trying to do this once the user is doing something in the form then no, you need to think about ajax and/or process the form by sending it back to the server to process and return the entire page again. You have to remember that server and client can only talk in a certain manner, and if I am hearing you right you are needing to understand that before continuing with your development. -Original Message- From: Dan Blickensderfer [mailto:d...@blickensderfer.com] Sent: Sunday, 21 February 2010 2:04 PM To: cf-talk Subject: Re: iframe cfscript getting parent form field values Can I set the form value to a cfset variable? - Original Message - From: Andrew Scott andr...@andyscott.id.au To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, February 20, 2010 10:01 PM Subject: RE: iframe cfscript getting parent form field values No, Cfscript is server side scripting. You need to write javascript to do this using document.all.form[0] -Original Message- From: Dan Blickensderfer [mailto:d...@blickensderfer.com] Sent: Sunday, 21 February 2010 1:40 PM To: cf-talk Subject: iframe cfscript getting parent form field values Hi everyone, I've ran into a problem and do not know if cfscript will allow this. I have a page that has an iframe and a form named eform with a half of dozen fields. I have a javascript function onblur on the last field to call another cf page (page2) through the iframe. I'm trying to get cfscript on the page2 to get the values of the eform of the parent page
Re: Random question
Les, I've use the custom tag a random password generator from adobe exchange. You can generate exactly what you are wanting and more. Dan - Original Message - From: Les Irvin les.cft...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Wednesday, February 10, 2010 1:50 PM Subject: Random question How would I come up with a 4-character random string consisting of any letter or number? 1k3d, e4rf, 69e4, dfje, 3967, etc... Thanks in advance for your help, Les ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFIF Pissing me off
Bruce, It seems a lot of work... I have always used the following for selecting an option. select name=Shift option value=B cfif (GetScheduleInfoRet.Shift) IS Bselected/cfifBreakfast/option option value=L cfif (GetScheduleInfoRet.Shift) IS Lselected/cfifLunch/option /select Thanks, Dan - Original Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: August 21, 2007 12:43 PM Subject: CFIF Pissing me off Morning all. I have this select list: select name=Shift cfif (GetScheduleInfoRet.Shift) IS B option value=B selected=selectedBreakfast/option option value=LLunch/option cfelseif (GetScheduleInfoRet.Shift) IS L option value=BBreakfast/option option value=L selected=selectedLunch/option cfelse option value=BBreakfast/option option value=LLunch/option /cfif /select So when I open the form, the elseif portion kicks in because the item in the database is L (and I added identifying letters at the end of each option). However, breakfast is the option that I am seeing selected, not Lunch. Not sure why this is happening. Any ideas? This is a very basic deal that I have done with success in the past but today it does not want to cooperate. Using CF8, Server 2003. Bruce ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286710 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Daylight Savings Time Change (Slightly OT, but relevant)
You can modify the time zone DST within Microsoft Windows on any version using the time zone editor. You can download it from Microsoft and adjust the settings for your time zone and it will allow your OS adjust automatically. I have tested this on XP, Windows 2000, NT 4 and Win 98 and it works correctly. Here is the link http://support.microsoft.com/gp/cp_dst Dan - Original Message - From: Robert Harrison [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: March 09, 2007 10:00 AM Subject: Daylight Savings Time Change (Slightly OT, but relevant) FYI: In case you have not heard the dates on which we change to Daylight Savings Time have changed. It used to be we went on Daylight Savings Time the first Sunday in April and off the last Sunday in October. That has changed as Daylight Savings Time has been extended to help conserve electricity. This year we go on Daylight Savings Time this Sunday, March 11th at 2AM and go off Daylight Savings Time the first Sunday in November. This change was legislated by Congress and was unplanned, so it has not been programmed into may computer systems and may affect computer, as follows: 1. If you are using Windows Vista and have automatic updates turned on you should get an automatic download that will fix this problem. In this case, do nothing. 2. If you are using Windows Vista and do not have automatic updates turned on, you must either manually update your operating system with Microsoft Vista updates or you must manually reset your time as instructed below. To update your computer manually go to: http://windowsupdate.microsoft.com/ http://windowsupdate.microsoft.com/ http://windowsupdate.microsoft.com/ 3. If you are using Windows XP in your office and are connected to a network, your system administrator may have loaded a Windows patch, in which case you do nothing. Check with your system administrator to see how this affects your corporate network and what your should do. 4. If you are using Windows XP at home (THIS APPLIES TO MOST PEOPLE) you will need to manually adjust your computer time. See the instructions below. 5. If you are using a MAC and are on OSX there is a patch you can download at http://www.macupdate.com/info.php/id/24267 to fix this problem. If you are on an older MAC you'll need to manually reset your time. So remember, this Saturday night or Sunday morning (March 11, 2007), set your clocks ahead one hour. If you are on Windows XP and need to manually reset your computer (MOST OF US), follow the instructions below. 1. Open your Control Panel (Start/Control Panel). 2. Double Click on Date and Time. This open the Date/Time dialog box. 3. Select the Time Zone tab and make sure the box that says Automatically Adjust Clock for Daylight Savings Time is NOT CHECKED. If it is checked, UNCHECK it by clicking on the box (if you leave it checked it will adjust your time again later, on the wrong day and mess up you time setting). 4. Now select the Date Time tab. In the time box, set your clock ahead one hour. 5. Press the Apply button. That is all. Hope this was helpful. Robert Harrison ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272233 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Calendar Application
Andrew, I would also like a copy. Thanks, Dan - Original Message - From: Peterson, Andrew S. [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, November 17, 2005 1:48 PM Subject: RE: Calendar Application Jeff, Long lng ago I incorporated a calendar app into a CMS I built. It's not fusebox, and the backend is MS Access. Do you (or anyone) still want it? If so, I'll zip it up and send you a link. Sincerely, Andrew -Original Message- From: Jeff Langevin [mailto:[EMAIL PROTECTED] Sent: Thursday, November 17, 2005 11:13 AM To: CF-Talk Subject: Calendar Application Hey folks, I was wondering if anyone can recommend a calendar app that fits the following criteria. I've searched around including on the exchange. I've found a couple of decent ones, but none of them seem to have built in search functionality. And, while it wouldn't be tough to implement, I'm sure, my boss doesn't want me spending time on doing so due to other higher priorities. Thanks in advance for any suggestions. Event Detail, Day, Week, Month views. Search capability. Fusebox a plus, but not required. Runs on CF6.1 and MSSQL 2K --Jeff ~| 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:224527 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
Strange Issue Appearing....
Hello Everyone, I'm developing a new website for our company and I'm reusing some cf code. On a few new pages I'm getting the following text inserted on the top of the page. It follows the ending /script tag and before the starting html tag. On the old website this never shows and it's been working for years. Does anyone know why I'm getting this and how to solve it from showing. I do know it seems to show up on some cf pages that's being call from cflocation tags. I'm running CF5 on Windows 2003 Server HTTP/1.1 200 OK Connection: close Date: Tue, 02 Aug 2005 17:24:42 GMT Server: Microsoft-IIS/6.0 Content-type: text/html Page-Completion-Status: Normal Page-Completion-Status: Normal Set-Cookie: CFGLOBALS=HITCOUNT%3D1182%23LASTVISIT%3D%7Bts+%272005%2D08%2D02+13%3A24%3A42 %27%7D%23TIMECREATED%3D%7Bts+%272005%2D06%2D08+15%3A55%3A55%27%7D%23; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Thanks, Dan Blickensderfer ~| 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:213495 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: Output in 2 columns
I use the following for our website. cfset max= round(news.recordcount / 2) cfset row2 = max + 1 table cellpadding=2 cellspacing=0 border=0 td valign=toptable cellpadding=2 cellspacing=0 border=0 cfoutput query=news startrow=1 maxrows=#max# trtdColumn1 Results/td/tr /cfoutput /table /td td width=5nbsp;/td td valign=toptable cellpadding=2 cellspacing=0 border=0 cfoutput query=news startrow=#row2# maxrows=#max# trtdColumn2 Results/td/tr /cfoutput /table /td/tr /table Thanks, Dan - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Monday, August 09, 2004 10:40 AM Subject: RE: Output in 2 columns How to divide that news in 2 columns, like this: Again, if I understanding you right (not tested this code but it's thereabouts) cfset noNews = news.recordCount / cfset halfNews = int(news.recordCount/2) / div id=news cfoutput query=news cfif news.currentRow eq 1 div id=news-left /cfif #news.item#br / !--- Output halfway news div's --- cfif news.currentRow eq halfNews /div div id=news-right /cfif !--- Close off div if last record --- cfif news.currentRow eq news.recordCount /div /cfif /cfoutput /div -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT How to prevent someone changing my home page
I use Ad Awarehttp://www.ad-aware.comIt's very good. Dan - Original Message - From: Mike Kear To: CF-Talk Sent: Saturday, May 29, 2004 11:42 AM Subject: OT How to prevent someone changing my home page ( Sorry for the Off Topic post, but you're the guys who will know what I'm looking for ) There's a spyware app or trojan or something changing the home page on my browser all the time and it's giving me a lot of heartburn.Every time I delete the app that changes it, and all references to it in the registry, it finds its way back again. I'll track it down eventually but in the mean time, is there a way to disable the changing of the home page on IE, so while I might not get rid of this damn application, at least it can't keep on altering my home page? (My home page is set to the home page of my intranet, which has a whole screen full of my oft-used links) Cheers Mike Kear AFP Webworks Windsor, NSW, Australia http://afpwebworks.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: output a # ?
According to your source code on the last page. It looks like you forgot to add your cfoutputs around your numberformat without it it's trying to pass the string: #numberformat(total, '_.__')# instead of the dollar amount. Your cf code should look something like this. value=cfoutput#numberformat(total, '_.__')#/cfoutput Dan - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 29, 2003 12:53 AM Subject: RE: output a # ? this is the page http://www.weblofts.com/rr.dvd/index.cfm ok, follow this closely (btw~ insert is disabled right now, so feel free to enter stuff) ok on that main page go to step 1 and enter an email (can be bogus) on the next page, enter a name email make sure paypal is selected and near the bottom choose a few items like usa shipping and insurance this will then take u to a new page where u will see a total on a paypal click here to pay button click on the paypal button and u will see what i get . this is just something i sell from ebay, so just using the paypal extensions. The problem with them is that it wants a static total, gr but there should be no reason why it cant be done dynamically dave...also, what are you using to connect to paypal? i gotta site that immmabout to setup with paypal...and they were wondering what i was going to use...first merchant to use paypal...ideas? bueller...bueller. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 12:33 AM To: CF-Talk Subject: output a # ? ok, i have a form that adds up some form money totals then it should be inserted into a paypal buy button as a dynamic total. the variable for the purchase total is ummm #total# it on its own output the total as a whole #, like 25 then when i need to display it i use dollarformat. and this is what i put into the form to add the total #numberformat(total, '_.__')# hoping that it would input the total as 25.00 and send it to paypal as such but i get this error from paypal Error Detected You have entered an invalid amount. Please make sure that all punctuation marks are in the correct places and that you only include the numeric portion of the amount. For example, if the amount is five U.S. Dollars, you would enter 5.00. any thoughts? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: enabling domain access without www
Clint, In your dns server you should have a A record for your mydomain.com to the ip address. example below. mydomain.comA192.168.0.40 If you want the www to work as well. use below. www CNAMEmydomain.com. If you are housing multiable domains on the same ip address. You will need to make a header change in the Management Console for that domain. Make your host header name mydomain.com port 80 and place your ip address 192.168.0.40 I hope this helps Dan - Original Message - From: Clint [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 13, 2003 11:35 AM Subject: OT: enabling domain access without www I cannot remember if setting http://mydomain.com is a webserver (IIS) or a DNS setting? Can someone verify this for me? Thanks, Clint ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Serv-U?
We use Serv-U as well.. We have a single ftp server handeling 1000 domains and another server for about 800 personal websites. We've been using it since version 2 and we are currently using version 4. We use CF to administrator both servers without any problems. - Original Message - From: Rafael Alan Bleiweiss [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 31, 2003 1:28 AM Subject: RE: SOT: Serv-U? stat: (previously stated) - at ANT Internet/Computer Associates Nethaven Division we hosted over 350 client sites on dozens of servers using FTP ServU exclusively stat: at Briona Net I host over 35 sites using ServU - have been running my own license of it since I left CF in October of 97... Just got the upgrade license two days ago. It's an excellent program from a hosting perspective. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMail question.... Encoding base64, 7bit
Does anyone know how to change the Encoding format within a cfmail sent message. It's currently sending both base64 and 7bit. I would only like to send 7bit. I have an email generated with a picture attached. Here is what I have in my cfmail tag. cfmail to=#toemail# from=#fromemail# subject=Subject Line cfmailparam file=17376-2..jpg #form.message# /cfmail When the email is sent here is the message header that it's sending. top of email message x-cf-version: 4.5.0 x-cf-server: mail.tusco.net x-cf-port: 25 x-cf-timeout: 60 x-cf-from: emailaddress x-cf-to: emailaddress Content-Type: multipart/mixed; boundary=---2e323f522e323f52 Date: Fri, 17 Jan 2003 23:35:27 -0500 From: emailaddress Mime-version: 1.0 Subject: Subject line... To: emailaddress This is a multi-part message in MIME format. -2e323f522e323f52 Content-Type: text/plain Content-Transfer-Encoding: 7bit Test message -2e323f522e323f52 Content-Type: image/jpeg Content-Disposition: attachment; filename=17376-2.jpg Content-Transfer-Encoding: base64 /9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRof -2e323f522e323f52-- bottom of email message ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Grabbing Stock Quotes
Gel, I use CF_StockGrabber, Yahoo just recently changed their address to pull the stock quotes. The correct URL now is: http://finance.yahoo.com/d/quotes.csv?s=#attributes.tickerSymbols#f=snl1d1t 1c1ohgve=.csv modify the stockgrabber.cfm that is located in your custometags folder and look for the old url: http://quote.yahoo.com/d/quotes.csv?S=#Symbol_List#f=sl1d1t1c1ohgve=.csv; or you can contact Rob Brooks-Bilson at ([EMAIL PROTECTED]) and he can send you the updated stockgrabber.cfm file. Thanks, Dan - Original Message - From: Angel Stewart [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 21, 2002 12:16 PM Subject: Grabbing Stock Quotes Hey all, I'm looking for a decent custom tag that grabs stock quotes. I've not been able to find one on the Dev Exchange that works properly :-\ -Gel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Grabbing Stock Quotes
Gel, If Rob does care I will send you the update that he sent me. I'll send it to you off line. Thanks, Dan - Original Message - From: Angel Stewart [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 21, 2002 12:37 PM Subject: RE: Grabbing Stock Quotes Yup..that's one I tried to use. I got this error: Error Diagnostic Information CFHTTP Incorrect number of columns in row. The error occurred while processing an element with a general identifier of (CFHTTP), occupying document position (130:1) to (135:19) - The CFHTTP line from the file is: CFHTTP METHOD=GET URL=http://finance.yahoo.com/d/quotes.csv?s=#attributes.tickerSymbols#; f=snl1d1t1c1ohgve=.csv NAME=#QueryName# COLUMNS=Symbol,Last_Traded_Price,Last_Traded_Date,Last_Traded_Time,Chan ge,Opening_Price,Days_High,Days_Low,Volume DELIMITER=, TEXTQUALIFIER= I guess I need an updated version or something? -Gel -Original Message- From: Dan Blickensderfer [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 1:25 PM To: CF-Talk Subject: Re: Grabbing Stock Quotes Gel, I use CF_StockGrabber, Yahoo just recently changed their address to pull the stock quotes. The correct URL now is: http://finance.yahoo.com/d/quotes.csv?s=#attributes.tickerSymbols#f=snl 1d1t 1c1ohgve=.csv modify the stockgrabber.cfm that is located in your custometags folder and look for the old url: http://quote.yahoo.com/d/quotes.csv?S=#Symbol_List#f=sl1d1t1c1ohgve=.c sv or you can contact Rob Brooks-Bilson at ([EMAIL PROTECTED]) and he can send you the updated stockgrabber.cfm file. Thanks, Dan - Original Message - From: Angel Stewart [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 21, 2002 12:16 PM Subject: Grabbing Stock Quotes Hey all, I'm looking for a decent custom tag that grabs stock quotes. I've not been able to find one on the Dev Exchange that works properly :-\ -Gel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: basic question
You need to place an between your variables and remove your single quotes. Like this: a href=test.cfm?category=5orcategory2=5listing page/a Dan - Original Message - From: Tim Laureska [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 11, 2002 8:09 PM Subject: basic question Is it possible to do something like this to pass multiple variables thru a link, because it doesn't work and I'm wondering if its just an easy syntax Problem: a href=test.cfm?category='5'orcategory2='5'listing page/a Tim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: CFFTP help please .. whats wrong here?
Mike, What version of CF Server is installed on server? Thanks, Dan Blickensderfer - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 8:18 PM Subject: RE: CFFTP help please .. whats wrong here? Thanks, Jim. I did that but the problem didn't go away. I checked usin g a text output that the code you sent me does indeed yield the correct directory and file, so that's correct, sure enough. But I guess that was n't the error. I still get an error in h1tags at the top of the page sayin g : The attribute FileOnServer must contain a filename with a .htm or .html extension.Could this be the ftp server sending this message?If i t was my CF5 server sending the message it would appear in the debugging message at the bottom of the template wouldn't it. I don't get this message when I do it using CuteFTP or the DOS FTP progra m. Any other ideas what could be causing the PUTFILE tag to fall over? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 13, 2002 11:26 AM To: CF-Talk Subject: Re: CFFTP help please .. whats wrong here? Yes, if I recall correctly. If the file is in the same directory as the template, you can use: localfile=#ExpandPath('filetoupload.html')# Jim - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 5:18 PM Subject: RE: CFFTP help please .. whats wrong here? Are you saying that the attribute localfile in the putfile tag should b e something like localfile=C:\inetpub\wwwroot\clientsite\workingfolder\filetoupload.h tm l rather than localfile=filetoupload.html? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 13, 2002 11:11 AM To: CF-Talk Subject: Re: CFFTP help please .. whats wrong here? Are you using a fully qualified path to designate the 'localfile'? Jim - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 4:57 PM Subject: CFFTP help please .. whats wrong here? I'm trying to have a CF template automatically upload a file to a cli en t's site, and I keep getting an error. I don't know what's wrong .. can someone see please? The error I'm getting is: The attribute FileOnServer must contain a filename with a .htm or .html extension 500 Illegal PORT command an d the debugging info says it's to do with the CFFTP tag that's doing the pu tf ile action. I've done all these actions using the DOS window FTP program, so I kn ow I have all the relevant permissions to do this. Here's my code: (servername and password etc changed to protect the innocent) cfftp action=OPEN server=servername.com.au username=username password=password stoponerror=Yes port=21 connection=clientname cfftp action=CHANGEDIR directory=/home/radio/public_html/therightfolder connection=clientname cfftp action=PUTFILE stoponerror=Yes localfile=filetoupload.html remotefile= filetoupload.html transfermode=ASCII connection=clientname cfftp action = close connection=clientname stopOnError = Yes Can you see what's wrong? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFTP help please .. whats wrong here?
Mike, If I can recall correctly. If you are using a form with an enctype=multipart/form-data and using that variable as your remotefile. It usually has a temp variable from windows. like this. C:\WINNT\ACF56.tmp I usually force the extention on the remotefile. Here is an example of code that I use for ftp images to the server. cfset ImageName = lookuprec.rec_id '.jpg' cfftp action=OPEN server=#variables.systemurl# username=#variables.systemftpusername# password=#variables.systemftppassword# stoponerror=Yes connection=ServerConnection retrycount=5 cfftp action=CHANGEDIR stoponerror=Yes directory=images\topstory\ connection=ServerConnection cfftp action=PUTFILE stoponerror=Yes localfile=#form.picturename# remotefile=#Variables.ImageName# transfermode=AUTO connection=ServerConnection cfftp action=CLOSE stoponerror=Yes connection=ServerConnection I don't know if this will help or not. Thanks, Dan - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 8:43 PM Subject: RE: CFFTP help please .. whats wrong here? I have CF5. The reason I have to do this is the client isn't on a CF hos t, so I have to generate static pages and upload them to their old fashioned html host. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Dan Blickensderfer [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 13, 2002 12:38 PM To: CF-Talk Subject: Re: CFFTP help please .. whats wrong here? Mike, What version of CF Server is installed on server? Thanks, Dan Blickensderfer - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 8:18 PM Subject: RE: CFFTP help please .. whats wrong here? Thanks, Jim. I did that but the problem didn't go away. I checked us in g a text output that the code you sent me does indeed yield the correct directory and file, so that's correct, sure enough. But I guess that w as n't the error. I still get an error in h1tags at the top of the page say in g : The attribute FileOnServer must contain a filename with a .htm or .htm l extension.Could this be the ftp server sending this message?If i t was my CF5 server sending the message it would appear in the debugging message at the bottom of the template wouldn't it. I don't get this message when I do it using CuteFTP or the DOS FTP prog ra m. Any other ideas what could be causing the PUTFILE tag to fall over? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 13, 2002 11:26 AM To: CF-Talk Subject: Re: CFFTP help please .. whats wrong here? Yes, if I recall correctly. If the file is in the same directory as th e template, you can use: localfile=#ExpandPath('filetoupload.html')# Jim - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 5:18 PM Subject: RE: CFFTP help please .. whats wrong here? Are you saying that the attribute localfile in the putfile tag shou ld b e something like localfile=C:\inetpub\wwwroot\clientsite\workingfolder\filetoupload h tm l rather than localfile=filetoupload.html? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 13, 2002 11:11 AM To: CF-Talk Subject: Re: CFFTP help please .. whats wrong here? Are you using a fully qualified path to designate the 'localfile'? Jim - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 4:57 PM Subject: CFFTP help please .. whats wrong here? I'm trying to have a CF template automatically upload a file to a c li en t's site, and I keep getting an error. I don't know what's wrong .. c an someone see please? The error I'm getting is: The attribute FileOnServer must contain a filename with a .htm or .html extension 500 Illegal PORT command an d the debugging info says it's to do with the CFFTP tag that's doing the pu tf ile action. I've done all these actions using the DOS window FTP program, so I kn ow I have all the relevant permissions to do this. Here's my code: (servername and password etc changed to protect th e innocent) cfftp action=OPEN server=servername.com.au username=username password=password stoponerror=Yes port=21 connection=clientname cfftp action=CHANGEDIR directory=/home/radio/public_html/therightfolder connection=clientname
ms access joins
I'm having a little trouble joining three tables that are from a Microsoft Access Database. I've created bigger sql statements with SQL Server. Can anybody see if I'm missing something. Here is the error that I'm receiving. [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'games.bowler_rec_id = bowlers.rec_id join Lane_Assignments on games.L_A_Rec_ID = Lane_Assignments.rec_id'. The following is the sql statement. I only receive the error when I try to join the 3rd table (Lane_Assignments) Thanks, Dan cfquery name=getgames datasource=Bowling select Bowlers.BowlerFirstName, Bowlers.BowlerLastName, bowlers.Rec_ID, games.L_A_Rec_ID, games.bowler_rec_id, games.Game1, games.Game2, games.Game3, games.rec_status, games.Game1 + games.Game2 + games.Game3 as series, Lane_Assignments.date from Games left outer join Bowlers on games.bowler_rec_id = bowlers.rec_id join Lane_Assignments on games.L_A_Rec_ID = Lane_Assignments.rec_id where bowlers.Rec_ID = #url.recid# order by Lane_Assignments.date /cfquery ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: Info about the Red Worm Attack
Hello Everyone, I just received this and I thought I would forward it on. Dan Blickensderfer Network Engineer Tusco.Net, Inc. Introduction On Friday July 13th we received packet logs and information from 2 network administrators that were experiencing large amounts of attacks targeting the recent .ida vulnerability that eEye Digital Security discovered (http://www.eeye.com/html/Research/A...AD20010618.html) on June 18, 2001. After reviewing the logs sent to us we determined that in fact someone had released a worm into the Internet that was spreading rapidly through IIS web servers. The full analysis of the .ida Code Red worm has provided numerous new details as to the functionality and method of propagation of this worm. For instance this worms purpose ultimately seems to be to perform a denial of service attack against www.whitehouse.gov. Also it has been found that only US English Windows NT/2000 systems will show the defaced (Hacked by Chinese !) web page. We've designated this the .ida Code Red worm, because part of the worm is designed to deface web pages with the text Hacked by Chinese and also because code red mountain dew was the only thing that kept us awake all last night to be able to disassemble this exploit even further. Explanation === As stated earlier the .ida Code Red worm is spreading throughout IIS web servers on the Internet via the .ida buffer overflow attack that was published weeks ago. The following are the steps that the worm takes once it has infected a vulnerable web server. 1. Setup initial worm environment on infected system. 2. Setup a 100 threads of the worm 3. The first 99 threads are used to spread the worm (infect other web servers). -The worm spreads itself by creating a sequence of random IP addresses. However, the worm's randomization of IP addresses to attack is not all together random. In fact there seems to be a static seed that the worm uses when generating new IP addresses to try to attack. Therefore every computer infected by this worm is going to go through the same list of random IP addresses to try to infect. The problem with that is that the worm is going to end up reinfecting systems and also end up crossing traffic back and forth between hosts to end up creating a denial of service type affect because of the amount of data that will be transferred between all the IP addresses in the sequence of random IP addresses. The worm could have done truly random IP generation and that would have allowed it to infect a lot more systems a lot faster. We are not sure why that was not done but a friend of ours did pose an interesting idea... If the person who wrote this worm owned an IP address that was one of the first hundred or thousand etc... to be scanned then they could setup a sniffer and anytime and IP address tried to connect to port 80 on their IP address they would know that the IP address that connected to them was infected with the worm and they would therefore be able to create a list of the majority of systems that were infected by this worm. 4. The 100th thread checks to see if it is running on a English (US) Windows NT/2000 system. -If the infected system is found to be a English (US) system then the worm will proceed to deface the infected systems website. That means... the local web servers web page will be changed to a message that says Welcome to http://www.worm.com !, Hacked By Chinese!. This hacked web page message will stay live on the web server for 10 hours and then disappear and never appear again unless the infected system is re-infected by another host. -If the system is not a English (US) Windows NT/2000 system then the 100th worm thread is also used to infect other systems. 5. Each worm thread checks for c:\notworm -If the file c:\notworm is found, the worm goes dormant. -If the file is not found then each thread will continue to attempt to infect more systems. 6. Each worm thread will now check the infected computers time. -If the time is between 20:00 UTC and 23:59 UTC then the worm will proceed to use this thread to attack www.whitehouse.gov. The attack consists of the infected system sending 100k bytes of data to port 80 of www.whitehouse.gov therefore potentially performing a denial of service attack against www.whitehouse.gov. -If the time is below 20:00 UTC then this worm thread will try to find and infect new web servers. In testing we have calculated that the worm can attempt to infect roughly half a million IP addresses a day and that was a ruff estimate made from using a very slow network. As of writing this document (July 18 6:49pm) we have had reports from administrators that have been probed by over 12 thousand unique hosts. That basically means at least 12 thousand hosts have been infected by this worm. In testing we have seen that sometimes the worm does not execute correctly and will continue to spawn new threads until the infected machine crashes and has to be rebooted. We have not been
CF 5.0 Client Registry Environments
Hello All, We have a W2K server with CF 5.0 and by default the client variables was stored into the registry. Since then the registry filled up and I switched the client variables to store within a database. I was wondering if there is an easy way to remove all the old client variable registry entries from the server? I tried to purge within 1 day and the entries are still in there. Thanks, Dan Blickensderfer ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: FTP Server
Serv-U FTP http://www.cat-soft.com - Original Message - From: Duane Boudreau [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 24, 2001 2:16 PM Subject: OT: FTP Server All, Can anyone suggest a decent and moderatly priced (~ $250) FTP server that will run as a service unter Win2k? TIA Duane Boudreau, Chief Techical Officer CFExperts, LLC Nashua, NH 603.620.8797 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Here's A Good One...
Robert, It's a Microsoft Issue... One of their solutions to fix it is.. Turn off the daylight savings until April 8th. After that day it will fix itself. It logarithm is over compensating for the daylight savings only if falls on Sunday and if it's April 1. It will last for one week. It has to do with the msvcrt40.dll This will occur in the years of 1973, 1979, 1984, 1990, 2001, 2007, 2012, 2018, 2029, and 2035 Dan - Original Message - From: "Robert Forsyth" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 5:03 PM Subject: Here's A Good One... Since the time change this weekend The server clock says its 5:00pm and #hour(now())# says 16. Any thoughts?? Thanks Robert Forsyth ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: One record query output
Michael, You can use the maxrows="1" in the cfquery statement. example: CFQUERY NAME="queryname" DATASOURCE="datasourcename" maxrows="1" select field1,field2 from table /CFQUERY Dan - Original Message - From: "Michael Gribbin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, March 19, 2001 10:09 PM Subject: One record query output Hi, I'm trying to find out if it's possible to limit the output of a query to one record. I have a database that is sorted in decending order and I only want the top record (the one with the biggest total) to display. I can do a work-a-round by setting a variable to "on" before the query output and turning it "off" after the first record is processed and then cfif skipping the rest of the records, but was hoping to do it in the query it's self. Possible? Thanks in advance. Michael Gribbin Digital Marketing Alliance ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfftp changing directory
Hello everyone, Is anyone having an issue with cfftp changedirectory command with cf server ver 4.5.1 R2? I have the same code in place when CF Ver 4.0 was on the server. Since then we upgraded to Ver 4.5.1 R2 Now the code does not change directories. Here is the code that I'm using. cfftp action="OPEN" server="#systemcontrol.URLAddress#" username="#systemcontrol.username#" password="#systemcontrol.ftppassword#" stoponerror="Yes" connection="ServerConnection" retrycount="1" cfftp action="CHANGEDIR" stoponerror="Yes" directory="images\gallery\" connection="ServerConnection" cfftp action="PUTFILE" stoponerror="Yes" localfile="#form.picturename#" remotefile="#Variables.ImageName#" transfermode="AUTO" connection="ServerConnection" cfftp action="CLOSE" stoponerror="Yes" connection="ServerConnection" Thanks, Dan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfftp changing directory
Never mind. I figured it out. There is a hot fix for the this. http://www.allaire.com/Handlers/index.cfm?ID=18762Method=Full This CFFTP hotfix corrects the SP2 specific issue which could cause CFFTP connections not to be reused (a performance consideration). The issue made the CFFTP tag reopen the connection to the FTP server for every request, even if the CONNECTION attribute is used. Thanks, Dan - Original Message - From: "Dan Blickensderfer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 7:00 PM Subject: cfftp changing directory Hello everyone, Is anyone having an issue with cfftp changedirectory command with cf server ver 4.5.1 R2? I have the same code in place when CF Ver 4.0 was on the server. Since then we upgraded to Ver 4.5.1 R2 Now the code does not change directories. Here is the code that I'm using. cfftp action="OPEN" server="#systemcontrol.URLAddress#" username="#systemcontrol.username#" password="#systemcontrol.ftppassword#" stoponerror="Yes" connection="ServerConnection" retrycount="1" cfftp action="CHANGEDIR" stoponerror="Yes" directory="images\gallery\" connection="ServerConnection" cfftp action="PUTFILE" stoponerror="Yes" localfile="#form.picturename#" remotefile="#Variables.ImageName#" transfermode="AUTO" connection="ServerConnection" cfftp action="CLOSE" stoponerror="Yes" connection="ServerConnection" Thanks, Dan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Who wants a CF-SQL Mailing List?
117,937 messages dated from 96' I should delete some. Dan - Original Message - From: "Jon Hall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 21, 2000 6:02 PM Subject: Re: Who wants a CF-SQL Mailing List? My cf-talk folder has 13,653 messages. The largest database of coldfusion knowledge anywhere, all searchable by any keyword. jon - Original Message - From: "ibtoad" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 21, 2000 2:31 PM Subject: RE: Who wants a CF-SQL Mailing List? Just use Outlook and you can send each email meesage to a different folder. My CFTalk folder currently has 5000 messages, I guess its time to clean up. Rich -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 1:06 PM To: CF-Talk Subject: Re: Who wants a CF-SQL Mailing List? Do what I do; make a new email account called [EMAIL PROTECTED] and you can separate your real email from the list stuff :) Neil aka Neil-list :) - Original Message - From: "Gregory Harris" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 21, 2000 12:06 PM Subject: Re: Who wants a CF-SQL Mailing List? Agreed, plus there is my favorite issue of mailing list glut, attempting manage how many mailing lists? Plus if I take off on vacation and want to unsubscribe for a bit? That could be as many as 6-7 emails, and I still might not be able to get off all the lists. So just leave at the current status with CF-Talk, CF-Community and the other specialist lists such as CF-Wap and CF-Server. Gregory Harris Web Developer Stirling Bridge Group LLC - Original Message - From: "Dick Applebaum" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 21, 2000 8:38 AM Subject: Re: Who wants a CF-SQL Mailing List? Greg I would *not* like to see the CF list subdivide... where does it end: CF-SQL CF-Objects CF-Verity CF-Mail CF-WDDX CF-Javascript One of the major advantages of CF is it's integration of SQL database (and other components). I personally enjoy and benefit from the variety of topics on this list... it is easy to sort/delete/ignore items that are not of interest. MHO Dick At 10:09 AM -0500 12/21/00, Greg Wolfinger wrote: Hey Guys: I e-mail Michael Dinowitz about a week ago and havn't herd back yetbut I think it would be a great idea to start a new mailing list. CF-SQL would be great because you could post all your questions about databasing and sql, because we all run into those problems when working with CF. Hopefully I will get a good enough response from this e-mail so that Michael strongly consiers starting CF-SQL. So what do you guys think? --Greg ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Reverse Look up on IP address
Duane, Within Allaire's Tag Gallery there is a tag named nslookup. I use it all the time. It's pretty straight forward. Dan - Original Message - From: "Duane Boudreau" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 07, 2000 11:44 PM Subject: Reverse Look up on IP address Is there a way to do a reverse look up on an IP address and see who it is registered to? TIA, Duane Boudreau CFExperts.Com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Suppressing Repeating Groups in a Query
Sam, You could do this with groups example below. Dan cfquery name="getstates" datasource="" select * from tablename order by field1, field2, field3 /cfquery table cfoutput group="field1" query="getstates" trtd#field1#/tdtd#field2#/td/tr cfoutput trtd colspan=2#field3#/td/tr /cfoutput /cfoutput - Original Message - From: "sam komolafe" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Cc: "sam komolafe" [EMAIL PROTECTED] Sent: Friday, October 27, 2000 5:06 PM Subject: Suppressing Repeating Groups in a Query Hi guys, How do you suppress repeating groups in a query? e.g. What I Have: 1DN12California 1DN12Oregon 5DQ46Utah 5DQ46New York 9DZ09 Texas What I Want: 1DN12California Oregon 5DQ46 Utah Utah 9DZ09 Texas Thanks -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Access 2000 Databases with CF4.0
You have to use the latest Microsoft Data Access Components (MDAC) - Original Message - From: "Joshua Miller" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, September 26, 2000 3:23 PM Subject: Access 2000 Databases with CF4.0 This may have been answered here before, but I'm not sure. I'll ask anyway. Is there anyway to use Access 2000 Databases with CFServer 4.0??? I get an error every time I try and use Access 2000 dbs. THANKS! Joshua Miller Web Site Development Eagle Technologies Group Business Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Allaire security problem - anyone know solution?
We are running Service Pack 6a and it happen to us. I did notice that when I tried to do it with an encrypted application.cfm. I just got scrambled code. It's definitely an IIS issue. I would agree on removing the .htr out of the IIS mapping. Dan - Original Message - From: "Jonathan Broome" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 03, 2000 3:36 PM Subject: RE: Allaire security problem - anyone know solution? On my sites using SP6a, I couldn't get this to work. On other sites, I could. Unless someone's got a better idea, I recommend the Service Pack. Jonathan -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 03, 2000 12:27 PM To: [EMAIL PROTECTED] Subject: Allaire security problem - anyone know solution? Hi all, One of my hosting clients has just made me aware of this major security problem and I'm wondering if anyone knows how to eliminate it? Try calling the application.cfm template on any CF site with +.htr appended to the end of the url. You'll first see a blank page. Now hit refresh/reload and you'll see the full code of said application.cfm e.g. http://www.support.alllaire.com/application.cfm+.htr Can someone please tell me there is a patch for this. It seems to happen on all CFserver versions 4.x + running IS4.0 with Service pack 5 Dave Dave Wilson Internet Technology Manager, BizNet Solutions Allaire Premier Partner Co-Founder CFUG Ireland http://www.cfug.ie 224, Lisburn Road Belfast BT9 6GE Tel: 02890 225 776 Fax: 02890 223 223 web: http://www.biznet-solutions.com email: [EMAIL PROTECTED] -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Seeking Text Rollover
Richard, Here is what I use. head title/title style type="text/css"!-- a:hover { color: #00 } a:link { text-decoration: none } a:visited { text-decoration: none }-- /style /head body bgcolor="white" link="#b2" vlink="#cd5c5c" - Original Message - From: "Dana Larose" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 11, 2000 1:59 PM Subject: Re: Seeking Text Rollover Your best bet is probably CSSes. However, you will be stuck with the IE or Netscape 6.0. -Original Message- From: Richard Colman [EMAIL PROTECTED] To: Cf-Talk [EMAIL PROTECTED] Date: Tuesday, July 11, 2000 12:55 PM Subject: Seeking Text Rollover (A little off topic, but, this may be a common need and worth repeating.) Seeking JavaScript, DHTML, CF, etc. script/solution that will provide a simple "change-in-color" text rollover (without the need for images) in both IE AND NETSCAPE browsers. Have been looking in the obvious places, but have not found anything. Does anyone know of a source? Richard Colman --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Optimizing Win 2000 (IIS) for Warp speed with Cold Fusion.
Mark, Could you post your results on NT 4, IIS, CF. Thanks, Dan - Original Message - From: "Mark W. Breneman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 03, 2000 11:47 AM Subject: OT: Optimizing Win 2000 (IIS) for Warp speed with Cold Fusion. About 9 months ago I collected and posted a compiled list tips and tricks (thanks for all the info, by the way) for optimizing NT4.0(IIS) and Cold Fusion for max performance. I would like to do the same for Windows 2000 (IIS 5) and CF 4.5. Please also include any gaping security holes and fixes. And / Or any handy tricks like renaming the administrator account in NT. I will post all the tips and tricks compiled in a list with my own in a few days. If you would like to contact me off list [EMAIL PROTECTED] Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: create a date for table
Ellie, In SQL use the getdate() function. Dan - Original Message - From: "Elaine L" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 29, 2000 1:41 AM Subject: RE: create a date for table Hi, I tried to set up the field in Microsoft SQL 7 the datatype as dateime (or shd it be timestamp?) and the default value to Date()+Time() but an error msg came up: - Unable to modify table. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]'date' is not a recognized function name. What's missing Thanks in advance Ellie On Thu, 29 Jun 2000 12:43:18 Parker, Kevin wrote: I just add Date()+Time() as the default value in the table - gets the database to do the work, not your code. Every time a new row is added its date and time stamped. Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 -Original Message- From: Elaine L [mailto:[EMAIL PROTECTED]] Sent: Thursday, 29 June 2000 12:38:PM To: [EMAIL PROTECTED] Subject: create a date for table Hi, Hope I am not repeating an old question. I need to create a field in a table (Microsoft SQL) called DateCreated. The value shd be automatically created and passed as a hidden field every time the submit page is actioned. What is the best way of doing this? Ellie Send FREE Greetings for Father's Day--or any day! Click here: http://www.whowhere.lycos.com/redirects/fathers_day.rdct --- - -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. *** * This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. *** * --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Send FREE Greetings for Father's Day--or any day! Click here: http://www.whowhere.lycos.com/redirects/fathers_day.rdct -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Off The Subject... SQL Question
Sorry for this question that doesn't pertain to the CF Talk List. I have a NT4.0 Box w/SQL 6.5 Server with Dual PII 650's / 512MB Ram. 256MB set aside for SQL. I have a table in one of my Datasources that has apprx 5 million records. I'm trying to think of the best way to purge the records and just keep the last 90 days. I was going to do something like the following in the SQL Query Manager set rowcount 5000 declare @rows int select @rows = 5000 while @rows = 5000 begin delete from calls where date "3/6/2000" end I know this will take a while, I just don't want the transaction log to run out of room compared to just deleting all records at one time. Any suggestions? Thanks, Dan -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Off The Subject... SQL Question
Sorry for this question that doesn't pertain to the CF Talk List. I have a NT4.0 Box w/SQL 6.5 Server with Dual PII 650's / 512MB Ram. 256MB set aside for SQL. I have a table in one of my Datasources that has apprx 5 million records. I'm trying to think of the best way to purge the records and just keep the last 90 days. I was going to do something like the following in the SQL Query Manager set rowcount 5000 declare @rows int select @rows = 5000 while @rows = 5000 begin delete from calls where date "3/6/2000" end I know this will take a while, I just don't want the transaction log to run out of room compared to just deleting all records at one time. Any suggestions? Thanks, Dan -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: help converting varchar to number
Art, You could create a new field "Comb_Date" timedate() data type, and write a utility to take the three separate fields and combined them into one and insert it into the Comb_Date field. Dan -Original Message- From: Art Broussard [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, May 15, 2000 10:43 AM Subject: help converting varchar to number I am rewriting a site that cant lose any of the information in the tables. At one point some one made three fields for the date named Month, Day, and Year. When they did this they set the fields to VARCHAR(40) instead of number.?! :-/ Now when I do an order by month day year it tries to alphabetize: 1/12/99 11/14/99 2/10/99 instead of ordering numerically. 1/12/99 2/10/99 11/14/99 Any one have an idea on how to deal wiht this? I was told the field would have to be empty to change from varchar to number in Oracle. Thanks Art Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Open Sessions
I have a users login screen for a security web site. I have sessionmanagement enabled. I was wondering, Is there a way to find active sessions on a user? Thanks, Dan -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: outlook question
I currently running 4.72 Outlook Express. I have two folders on CF-Archive (69900 messages) and CF-Talk (6000 messages). I've had not problems adding more to the Archive Folder after my CF-Talk folder reaches 1 messages. I have articles dated back to Sept. of 1996. Dan -Original Message- From: John N Westerlund [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, April 03, 2000 11:09 AM Subject: outlook question Whats the max num of messages outlook will hold before it dies? alternatively; has anyone's outlook/computer died from too many cf_talk messages? grin John, who has not deleted any cf_talk messages yet. --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Programmer's font
I would like to request a copy also. Thanks, Dan At 08:51 AM 4/3/00 -0400, you wrote: I use a font called Hells Programmer. It has exactly what you want. Let me know if you want it and I'll send it to you. --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.