Can I read IDENTD with CF ?
Hi Gang Just a little security type question .. was wondering if its possible to grab the identip from a user logging onto a webpage. I can get the ip .. i just need the ident part. I know i need to send a ident request to port 113 (identd) but i was just wondering if anything exists to do this (CFX / custom tag / trained monkey). Would be greatful for any help on the matter. Regards Stephen Pope ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
forums software request
Does anyone know of a forums ColdFusion program that has the new thread/not new thread and new message/not new message function database driven and not cookies or session variable based? I have the fusetalk software which bases the new/not new on cookies. If you leave and return from the forum and have not read any of the new topics when you return they are shown as being not new and read. The users of the fusetalk software find this confusing. Sebastian ~| 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
calling a dll from an sql stored proc
Greetings, Has anyone called a dll from a stored procedure, I am aware you can create custom stored procs that are dll's but the sql API only understands dll's in c or c++, I want to write it in VB. The problem is with a trigger, that when an update occurrs I need it to create a recordset and loop throug it performing calculations from the recordset then inserting the results into a new table, this can be done with a Cursor, but is very slow and I have been told is very resource intensive on sql server. We don't want to do this as the trigger will be called often. An alternative would be if a stored proc could call a flat file, i.e. a cfm or asp page and then do the maipulation here. We have thought of a third alternative which will work, send an email to an INBOX via sgl server and have the inbox agent call the dll, but the result has a latency due to the email request. Would appreciate any thoughts, Respectfully, J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Resend: MX and Oracle
(Hmmm...this doesn't seem to have made it the first time.) Anybody have any tips, gotchas or other helpful nuggets for using CFMX with Oracle 8i or 9i? Have you been successful in using Stored Procedures, specifically those that return cursors? ~| 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: calling a dll from an sql stored proc
Hi John, I've just spoken with our MS SQL Guru and hes not aware of any way of accesing a VB created Dll through MS SQL. The only way he intimated it could be done was by writing an xp_ wrapper in c++ for the VB library. Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: John McCosker [mailto:J.McCosker;andronics.co.uk] Sent: 15 November 2002 13:17 To: CF-Talk Subject: calling a dll from an sql stored proc Greetings, Has anyone called a dll from a stored procedure, I am aware you can create custom stored procs that are dll's but the sql API only understands dll's in c or c++, I want to write it in VB. The problem is with a trigger, that when an update occurrs I need it to create a recordset and loop throug it performing calculations from the recordset then inserting the results into a new table, this can be done with a Cursor, but is very slow and I have been told is very resource intensive on sql server. We don't want to do this as the trigger will be called often. An alternative would be if a stored proc could call a flat file, i.e. a cfm or asp page and then do the maipulation here. We have thought of a third alternative which will work, send an email to an INBOX via sgl server and have the inbox agent call the dll, but the result has a latency due to the email request. Would appreciate any thoughts, Respectfully, J ~| 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
RE: Verity index of a query
I'm assuming you're running CF5 with the out of the box Verity engine? Just curious. Thanks for the feedback, Jason -Original Message- From: Everett, Al [mailto:AEverett;askallied.com] Sent: Thursday, November 14, 2002 3:58 PM To: CF-Talk Subject: RE: Verity index of a query Heck no. We reindex a database of 290,000 products weekly. The collection is stored on disk. -Original Message- From: Angel Stewart [mailto:gel;silkcotton.com] Sent: Thursday, November 14, 2002 3:39 PM To: CF-Talk Subject: RE: Verity index of a query I believe it is stored in coldfusion/verity/collections on the server. I don't think you are required to re-index a database verity collection everytime you reboot your server... -Gel -Original Message- From: Dowdell, Jason G [mailto:DowdelJG;usano.ksc.nasa.gov] Does anyone know how/where a Verity index of a query is stored on the box? I'm wondering if the server is restarted whether or not the indexed query will remain or if it's stored in the CFServer's memory until that box shuts down... At which point the index would need to be recreated. Points to note: I am calling a query that gets stored by verity an index. I'm not sure if I should use the word collection here since it's not a collection of docs. When I say index I'm not referring to the primary or foreign key nature of the database. (just wanted to clarify) Thanks, Jason ~| 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: Verity index of a query
Yeppers. CF4.5 before that. -Original Message- From: Dowdell, Jason G [mailto:DowdelJG;usano.ksc.nasa.gov] Sent: Friday, November 15, 2002 8:35 AM To: CF-Talk Subject: RE: Verity index of a query I'm assuming you're running CF5 with the out of the box Verity engine? Just curious. Thanks for the feedback, Jason -Original Message- From: Everett, Al [mailto:AEverett;askallied.com] Sent: Thursday, November 14, 2002 3:58 PM To: CF-Talk Subject: RE: Verity index of a query Heck no. We reindex a database of 290,000 products weekly. The collection is stored on disk. -Original Message- From: Angel Stewart [mailto:gel;silkcotton.com] Sent: Thursday, November 14, 2002 3:39 PM To: CF-Talk Subject: RE: Verity index of a query I believe it is stored in coldfusion/verity/collections on the server. I don't think you are required to re-index a database verity collection everytime you reboot your server... -Gel -Original Message- From: Dowdell, Jason G [mailto:DowdelJG;usano.ksc.nasa.gov] Does anyone know how/where a Verity index of a query is stored on the box? I'm wondering if the server is restarted whether or not the indexed query will remain or if it's stored in the CFServer's memory until that box shuts down... At which point the index would need to be recreated. Points to note: I am calling a query that gets stored by verity an index. I'm not sure if I should use the word collection here since it's not a collection of docs. When I say index I'm not referring to the primary or foreign key nature of the database. (just wanted to clarify) Thanks, Jason ~| 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
RE: calling a dll from an sql stored proc
To call a VB dll you will have to do it via COM, im pretty sure that you can call a stored proc that will initiate a COM object but not sure which one... HTH -Original Message- From: John McCosker [mailto:J.McCosker;andronics.co.uk] Sent: Friday, November 15, 2002 13:17 To: CF-Talk Subject: calling a dll from an sql stored proc Greetings, Has anyone called a dll from a stored procedure, I am aware you can create custom stored procs that are dll's but the sql API only understands dll's in c or c++, I want to write it in VB. The problem is with a trigger, that when an update occurrs I need it to create a recordset and loop throug it performing calculations from the recordset then inserting the results into a new table, this can be done with a Cursor, but is very slow and I have been told is very resource intensive on sql server. We don't want to do this as the trigger will be called often. An alternative would be if a stored proc could call a flat file, i.e. a cfm or asp page and then do the maipulation here. We have thought of a third alternative which will work, send an email to an INBOX via sgl server and have the inbox agent call the dll, but the result has a latency due to the email request. Would appreciate any thoughts, Respectfully, J ~| 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: DWMX - Brainfart..
Click on the file/folder icon to the right of the link property. You set it in the dialog that comes up. -Original Message- From: Lee Fuller [mailto:leelistnew;primedna.net] Sent: Wednesday, November 13, 2002 5:34 PM To: CF-Talk Subject: OT: DWMX - Brainfart.. Sorry.. Having a.. well you know. How does one, site-wide, set all links to be document/site-relative? I can't seem to find it. TTAIA ~| 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: Verity index of a query
What kind of query response time are you experiencing under heavy load? I'm just now getting into the verity side of things because I am building a search engine for a client and am curious as to how much of an increase in speed the collection makes over just making a query that hits the sqlserver db. I know it's better but I don't know how much. If you have any pointers or pitfalls to avoid I'd appreciate that as well. Thanks, Jason -Original Message- From: Everett, Al [mailto:AEverett;askallied.com] Sent: Friday, November 15, 2002 8:36 AM To: CF-Talk Subject: RE: Verity index of a query Yeppers. CF4.5 before that. -Original Message- From: Dowdell, Jason G [mailto:DowdelJG;usano.ksc.nasa.gov] Sent: Friday, November 15, 2002 8:35 AM To: CF-Talk Subject: RE: Verity index of a query I'm assuming you're running CF5 with the out of the box Verity engine? Just curious. Thanks for the feedback, Jason -Original Message- From: Everett, Al [mailto:AEverett;askallied.com] Sent: Thursday, November 14, 2002 3:58 PM To: CF-Talk Subject: RE: Verity index of a query Heck no. We reindex a database of 290,000 products weekly. The collection is stored on disk. -Original Message- From: Angel Stewart [mailto:gel;silkcotton.com] Sent: Thursday, November 14, 2002 3:39 PM To: CF-Talk Subject: RE: Verity index of a query I believe it is stored in coldfusion/verity/collections on the server. I don't think you are required to re-index a database verity collection everytime you reboot your server... -Gel -Original Message- From: Dowdell, Jason G [mailto:DowdelJG;usano.ksc.nasa.gov] Does anyone know how/where a Verity index of a query is stored on the box? I'm wondering if the server is restarted whether or not the indexed query will remain or if it's stored in the CFServer's memory until that box shuts down... At which point the index would need to be recreated. Points to note: I am calling a query that gets stored by verity an index. I'm not sure if I should use the word collection here since it's not a collection of docs. When I say index I'm not referring to the primary or foreign key nature of the database. (just wanted to clarify) Thanks, Jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Verity index of a query
Response time is okay. It would be better if we could get all the information back that we need in one swell foop, but due to some unique data needs we simply use the collection to return product IDs that we then use in a subsequent DB query. For that fact, mostly, we're looking to go to Oracle's full-text searching instead. It does take upwards of fifteen minutes to refresh each collection, and it pretty much pegs the CPU gauge while we're doing it, which is why we only do it weekly, and in the wee hours of Saturday morning when we have no load. -Original Message- From: Dowdell, Jason G [mailto:DowdelJG;usano.ksc.nasa.gov] Sent: Friday, November 15, 2002 8:49 AM To: CF-Talk Subject: RE: Verity index of a query What kind of query response time are you experiencing under heavy load? I'm just now getting into the verity side of things because I am building a search engine for a client and am curious as to how much of an increase in speed the collection makes over just making a query that hits the sqlserver db. I know it's better but I don't know how much. If you have any pointers or pitfalls to avoid I'd appreciate that as well. Thanks, Jason -Original Message- From: Everett, Al [mailto:AEverett;askallied.com] Sent: Friday, November 15, 2002 8:36 AM To: CF-Talk Subject: RE: Verity index of a query Yeppers. CF4.5 before that. -Original Message- From: Dowdell, Jason G [mailto:DowdelJG;usano.ksc.nasa.gov] Sent: Friday, November 15, 2002 8:35 AM To: CF-Talk Subject: RE: Verity index of a query I'm assuming you're running CF5 with the out of the box Verity engine? Just curious. Thanks for the feedback, Jason -Original Message- From: Everett, Al [mailto:AEverett;askallied.com] Sent: Thursday, November 14, 2002 3:58 PM To: CF-Talk Subject: RE: Verity index of a query Heck no. We reindex a database of 290,000 products weekly. The collection is stored on disk. -Original Message- From: Angel Stewart [mailto:gel;silkcotton.com] Sent: Thursday, November 14, 2002 3:39 PM To: CF-Talk Subject: RE: Verity index of a query I believe it is stored in coldfusion/verity/collections on the server. I don't think you are required to re-index a database verity collection everytime you reboot your server... -Gel -Original Message- From: Dowdell, Jason G [mailto:DowdelJG;usano.ksc.nasa.gov] Does anyone know how/where a Verity index of a query is stored on the box? I'm wondering if the server is restarted whether or not the indexed query will remain or if it's stored in the CFServer's memory until that box shuts down... At which point the index would need to be recreated. Points to note: I am calling a query that gets stored by verity an index. I'm not sure if I should use the word collection here since it's not a collection of docs. When I say index I'm not referring to the primary or foreign key nature of the database. (just wanted to clarify) Thanks, Jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: cfexecute under Unix?
Thanks, I tried that and got the same response: it runs fine from the command line but I get no response when I run it with cfexecute. (su - nobody, nobody owns the file and has full rights, directory has write permissions. cfexecute is enabled in CFadmin) Any other ideas? This is CF4.5 SP2 on Solaris 8. Many thanks, Chris Norloff -- Original Message -- from: Rob Rohan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 14 Nov 2002 13:06:25 -0800 I don't have access to a unix box at work so this is just a guess, but you could make a script file: +===+ #!/bin/sh cfstat output.txt 21 +===+ save it in the /opt/coldfusion/bin directory $chmod u+x [filename] then in cf load in the output file after executing. cfexecute name=/opt/coldfusion/bin/[filename] timeout=5 / cfinclude template=/opt/coldfusion/bin/output.txt/ Shot in the dark. -Original Message- From: Chris Norloff [mailto:cnorloff;norloff.com] Sent: Thursday, November 14, 2002 12:53 PM To: CF-Talk Subject: Re: cfexecute under Unix? This is what cfstat outputs. The call with cfexecute is not even writing the cfstat.txt file, so something basic must be wrong. I even tried just to get the machine to ping an IP address ... no joy. I think this might be related to shells, of which I know very little. thanks, Chris Norloff Pg/Sec DB/Sec CP/Sec Reqs Reqs Reqs AvgQ AvgReq AvgDB Bytes Bytes Now Hi Now Hi Now Hi Q'ed Run'g TO'ed Time Time Time In/Sec Out/Sec 0 0 0 0 0 0 00 300 8164070 0 -- Original Message -- from: William Wheatley [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 14 Nov 2002 15:24:03 -0500 what output are you trying to get? you dont get any output from it on the screen but are you saying you're not getting the output into the cfstat.txt file? What are you expecting to see? What do you see when you go in from the command prompt - Original Message - From: Chris Norloff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 14, 2002 3:20 PM Subject: cfexecute under Unix? I can't get cfexecute to run under Unix. I can get it to not error but I can't get any output. The commands work okay when I su to userid nobody, and permissions are okay on the directories. Any ideas? thanks, Chris Norloff cfexecute name=/opt/coldfusion/bin/cfstat outputfile=/opt/coldfusion/log/cfstat.txt timeout=5 /cfexecute ~| 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: Verity index of a query
Jason, You shouldn't need to reindex your collections on a weekly basis. Adding/Updating/deleting a key in your collection should be done at the time that the data is updated. The insert/update to verity takes very little time. Deleting a key takes a little more time, but not significantly so. Its always worth providing an option to kick off a one time full re-index of the data/collection, for those times when something becomes corrupt, but this doesn't occur that often. BTW : 15 minutes for 290k records is pretty quick... Selecting the records from a DB won't take too long (long enough though), but think about how many words have to be indexed for 290K records... 15 minutes is going some (333 records a second!) Regards Stephen - Original Message - From: Dowdell, Jason G [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 2:23 PM Subject: RE: Verity index of a query Very interesting. I'll make sure to rebuild the query when there is no load as well. I appreciate your feedback. ~Jason -Original Message- From: Everett, Al [mailto:AEverett;askallied.com] Sent: Friday, November 15, 2002 9:00 AM To: CF-Talk Subject: RE: Verity index of a query Response time is okay. It would be better if we could get all the information back that we need in one swell foop, but due to some unique data needs we simply use the collection to return product IDs that we then use in a subsequent DB query. For that fact, mostly, we're looking to go to Oracle's full-text searching instead. It does take upwards of fifteen minutes to refresh each collection, and it pretty much pegs the CPU gauge while we're doing it, which is why we only do it weekly, and in the wee hours of Saturday morning when we have no load. -Original Message- From: Dowdell, Jason G [mailto:DowdelJG;usano.ksc.nasa.gov] Sent: Friday, November 15, 2002 8:49 AM To: CF-Talk Subject: RE: Verity index of a query What kind of query response time are you experiencing under heavy load? I'm just now getting into the verity side of things because I am building a search engine for a client and am curious as to how much of an increase in speed the collection makes over just making a query that hits the sqlserver db. I know it's better but I don't know how much. If you have any pointers or pitfalls to avoid I'd appreciate that as well. Thanks, Jason -Original Message- From: Everett, Al [mailto:AEverett;askallied.com] Sent: Friday, November 15, 2002 8:36 AM To: CF-Talk Subject: RE: Verity index of a query Yeppers. CF4.5 before that. -Original Message- From: Dowdell, Jason G [mailto:DowdelJG;usano.ksc.nasa.gov] Sent: Friday, November 15, 2002 8:35 AM To: CF-Talk Subject: RE: Verity index of a query I'm assuming you're running CF5 with the out of the box Verity engine? Just curious. Thanks for the feedback, Jason -Original Message- From: Everett, Al [mailto:AEverett;askallied.com] Sent: Thursday, November 14, 2002 3:58 PM To: CF-Talk Subject: RE: Verity index of a query Heck no. We reindex a database of 290,000 products weekly. The collection is stored on disk. -Original Message- From: Angel Stewart [mailto:gel;silkcotton.com] Sent: Thursday, November 14, 2002 3:39 PM To: CF-Talk Subject: RE: Verity index of a query I believe it is stored in coldfusion/verity/collections on the server. I don't think you are required to re-index a database verity collection everytime you reboot your server... -Gel -Original Message- From: Dowdell, Jason G [mailto:DowdelJG;usano.ksc.nasa.gov] Does anyone know how/where a Verity index of a query is stored on the box? I'm wondering if the server is restarted whether or not the indexed query will remain or if it's stored in the CFServer's memory until that box shuts down... At which point the index would need to be recreated. Points to note: I am calling a query that gets stored by verity an index. I'm not sure if I should use the word collection here since it's not a collection of docs. When I say index I'm not referring to the primary or foreign key nature of the database. (just wanted to clarify) Thanks, Jason ~| 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: Verity index of a query
My application is basically a search engine. So whenever new sites are added I'm assuming that I won't have to recreate or update the verity index since it's based on a query... I just want to make sure that when they search the index they're getting everything back from the db as it currently stands. Let me know if I'm off base here. Thanks, Jason -Original Message- From: Stephen Moretti [mailto:stephen;cfmaster.co.uk] Sent: Friday, November 15, 2002 9:43 AM To: CF-Talk Subject: Re: Verity index of a query Jason, You shouldn't need to reindex your collections on a weekly basis. Adding/Updating/deleting a key in your collection should be done at the time that the data is updated. The insert/update to verity takes very little time. Deleting a key takes a little more time, but not significantly so. Its always worth providing an option to kick off a one time full re-index of the data/collection, for those times when something becomes corrupt, but this doesn't occur that often. BTW : 15 minutes for 290k records is pretty quick... Selecting the records from a DB won't take too long (long enough though), but think about how many words have to be indexed for 290K records... 15 minutes is going some (333 records a second!) Regards Stephen - Original Message - From: Dowdell, Jason G [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 2:23 PM Subject: RE: Verity index of a query Very interesting. I'll make sure to rebuild the query when there is no load as well. I appreciate your feedback. ~Jason -Original Message- From: Everett, Al [mailto:AEverett;askallied.com] Sent: Friday, November 15, 2002 9:00 AM To: CF-Talk Subject: RE: Verity index of a query Response time is okay. It would be better if we could get all the information back that we need in one swell foop, but due to some unique data needs we simply use the collection to return product IDs that we then use in a subsequent DB query. For that fact, mostly, we're looking to go to Oracle's full-text searching instead. It does take upwards of fifteen minutes to refresh each collection, and it pretty much pegs the CPU gauge while we're doing it, which is why we only do it weekly, and in the wee hours of Saturday morning when we have no load. -Original Message- From: Dowdell, Jason G [mailto:DowdelJG;usano.ksc.nasa.gov] Sent: Friday, November 15, 2002 8:49 AM To: CF-Talk Subject: RE: Verity index of a query What kind of query response time are you experiencing under heavy load? I'm just now getting into the verity side of things because I am building a search engine for a client and am curious as to how much of an increase in speed the collection makes over just making a query that hits the sqlserver db. I know it's better but I don't know how much. If you have any pointers or pitfalls to avoid I'd appreciate that as well. Thanks, Jason -Original Message- From: Everett, Al [mailto:AEverett;askallied.com] Sent: Friday, November 15, 2002 8:36 AM To: CF-Talk Subject: RE: Verity index of a query Yeppers. CF4.5 before that. -Original Message- From: Dowdell, Jason G [mailto:DowdelJG;usano.ksc.nasa.gov] Sent: Friday, November 15, 2002 8:35 AM To: CF-Talk Subject: RE: Verity index of a query I'm assuming you're running CF5 with the out of the box Verity engine? Just curious. Thanks for the feedback, Jason -Original Message- From: Everett, Al [mailto:AEverett;askallied.com] Sent: Thursday, November 14, 2002 3:58 PM To: CF-Talk Subject: RE: Verity index of a query Heck no. We reindex a database of 290,000 products weekly. The collection is stored on disk. -Original Message- From: Angel Stewart [mailto:gel;silkcotton.com] Sent: Thursday, November 14, 2002 3:39 PM To: CF-Talk Subject: RE: Verity index of a query I believe it is stored in coldfusion/verity/collections on the server. I don't think you are required to re-index a database verity collection everytime you reboot your server... -Gel -Original Message- From: Dowdell, Jason G [mailto:DowdelJG;usano.ksc.nasa.gov] Does anyone know how/where a Verity index of a query is stored on the box? I'm wondering if the server is restarted whether or not the indexed query will remain or if it's stored in the CFServer's memory until that box shuts down... At which point the index would need to be recreated. Points to note: I am calling a query that gets stored by verity an index. I'm not sure if I should use the word collection here since it's not a collection of docs. When I say index I'm not referring to the primary or foreign key nature of the database. (just wanted to clarify) Thanks, Jason
RE: calling a dll from an sql stored proc
Thanks a lot guys for your time. -Original Message- From: Adrocknaphobia Jones [mailto:adrocknatalk;hotmail.com] Sent: 15 November 2002 14:23 To: CF-Talk Subject: RE: calling a dll from an sql stored proc If this is going to be a popular .dll, you may just want to bite the bullet and write it in C. Any VB workarounds will take a performance hit. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: John McCosker [mailto:J.McCosker;andronics.co.uk] Sent: Friday, November 15, 2002 8:17 AM To: CF-Talk Subject: calling a dll from an sql stored proc Greetings, Has anyone called a dll from a stored procedure, I am aware you can create custom stored procs that are dll's but the sql API only understands dll's in c or c++, I want to write it in VB. The problem is with a trigger, that when an update occurrs I need it to create a recordset and loop throug it performing calculations from the recordset then inserting the results into a new table, this can be done with a Cursor, but is very slow and I have been told is very resource intensive on sql server. We don't want to do this as the trigger will be called often. An alternative would be if a stored proc could call a flat file, i.e. a cfm or asp page and then do the maipulation here. We have thought of a third alternative which will work, send an email to an INBOX via sgl server and have the inbox agent call the dll, but the result has a latency due to the email request. Would appreciate any thoughts, Respectfully, J ~| 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: Can I read IDENTD with CF ?
I don't know that I'd expect to get an identd response from the ip address from an http request... I know that IRC clients (mIRC) have configuration options to enable and disable identd repsonses which gives me the impression they have an internal identd client to listen and send on that port, which a browser likely wouldn't have. So the odds are good that you'd only get an identd response if they happened to have something like mIRC running at the time they hit the page and likely only if they weren't yet connected to an IRC server (because at least mIRC disables identd after connecting by default)... Beyond that, you'd probably need a cfx tag written in C++ or Java in order to send the request and get the response, though I'm not aware of any for identd. Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 Hi Gang Just a little security type question .. was wondering if its possible to grab the identip from a user logging onto a webpage. I can get the ip .. i just need the ident part. I know i need to send a ident request to port 113 (identd) but i was just wondering if anything exists to do this (CFX / custom tag / trained monkey). Would be greatful for any help on the matter. Regards Stephen Pope ~| 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
CF FileMaker Question
Hi All, Does anyone know if it is possible to connect to a Filemaker database. Please do not rib me for using Filemaker - not my choice to make right now. Will be upgrading it to Oracle, next year. If it is possible could someone post the steps that are required to connect. I can use either CF4.5, 5.0 or MX. The version of Filemaker will be 6.0, along with FileMaker Mobile 2.1 on a Pocket PC. Thanks for the help in advance. Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| 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: Verity index of a query
True enough. In our case, we get data imported from a legacy system and it isn't feasible to do incremental adding/updating/deleting. I wish we COULD do without the bulk insert, but this application rides the small bus to school. Thought there had to be a good reason ;o) Regards Stephen ~| 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
RE: CF FileMaker Question
Well I remember back in the day Allaire had an ODBC driver for ColdFusion v4. Filemaker still supports ODBC so it should still be feasible: http://www.filemaker.com/products/odbc_backgrounder.html Hope this helps. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Ciliotta, Mario [mailto:mario.ciliotta;csfb.com] Sent: Friday, November 15, 2002 10:06 AM To: CF-Talk Subject: CF FileMaker Question Hi All, Does anyone know if it is possible to connect to a Filemaker database. Please do not rib me for using Filemaker - not my choice to make right now. Will be upgrading it to Oracle, next year. If it is possible could someone post the steps that are required to connect. I can use either CF4.5, 5.0 or MX. The version of Filemaker will be 6.0, along with FileMaker Mobile 2.1 on a Pocket PC. Thanks for the help in advance. Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| 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: Can I read IDENTD with CF ?
I found that 'fsockopen' in PHP does what i need .. ie fsockopen ($ip,113, $errno, $errstr, 10); Does anyone know if there is a tool similar to this for ColdFusion ? Regards Stephen Pope - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 3:09 PM Subject: Re: Can I read IDENTD with CF ? I don't know that I'd expect to get an identd response from the ip address from an http request... I know that IRC clients (mIRC) have configuration options to enable and disable identd repsonses which gives me the impression they have an internal identd client to listen and send on that port, which a browser likely wouldn't have. So the odds are good that you'd only get an identd response if they happened to have something like mIRC running at the time they hit the page and likely only if they weren't yet connected to an IRC server (because at least mIRC disables identd after connecting by default)... Beyond that, you'd probably need a cfx tag written in C++ or Java in order to send the request and get the response, though I'm not aware of any for identd. Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 Hi Gang Just a little security type question .. was wondering if its possible to grab the ident@ip from a user logging onto a webpage. I can get the ip .. i just need the ident part. I know i need to send a ident request to port 113 (identd) but i was just wondering if anything exists to do this (CFX / custom tag / trained monkey). Would be greatful for any help on the matter. Regards Stephen Pope ~| 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: CF FileMaker Question
Mario I have interfaced FileMaker Pro 6 with CFMX, both running on Mac OS X 10.2. So you can do it. I got quite busy at the time neglected to document the process. Later, when I had time, my trial license for FileMaker had expired. When I have some time, I plan to reinstall on another system and, this time, document the steps. I'll see what I can dig up, and send it offline. DIck On Friday, November 15, 2002, at 07:06 AM, Ciliotta, Mario wrote: Hi All, Does anyone know if it is possible to connect to a Filemaker database. Please do not rib me for using Filemaker - not my choice to make right now. Will be upgrading it to Oracle, next year. If it is possible could someone post the steps that are required to connect. I can use either CF4.5, 5.0 or MX. The version of Filemaker will be 6.0, along with FileMaker Mobile 2.1 on a Pocket PC. Thanks for the help in advance. Mario ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
MX and UPS XML
OK correct me if I am wrong. To use the UPS XML I need to use the following to connect to the UPS server: cfhttp url=https://www.ups.com/ups.app/xml/Track; method=POST port=443 I also need the following to post the XML to the UPS server: cfhttpparam type=FORMFIELD name=XML value=#variables.xml# Then to return the results I just use: #cfhttp.filecontent# OK if I am right so far. How should I prep the XML to send to UPS? Should I use cfxml? Here is the code I have so far for a custom tag, but I keep getting this error from UPS: 0 Failure Hard 10002 The XML document is well formed but the document is not valid TrackRequest cfparam name=Attributes.Licensenumber default= cfparam name=Attributes.UserId default= cfparam name=Attributes.Password default= cfparam name=Attributes.TrackingNumber default= cfxml variable=xml AccessRequest xml:lang = en-US AccessLicenseNumbercfoutput#Attributes.licensenumber#/cfoutput/Ac cessLicenseNumber UserIdcfoutput#Attributes.UserId#/cfoutput/UserId Passwordcfoutput#Attributes.Password#/cfoutput/Password /AccessRequest /cfxml cfxml variable=xml2 TrackRequest xml:lang=en-US Request TransactionReference CustomerContext/CustomerContext XpciVersion1.0001/XpciVersion /TransactionReference RequestActionTrack/RequestAction RequestOption/RequestOption /Request ShipmentIdentificationNumbercfoutput#Attributes.TrackingNumber#/cfo utput/ShipmentIdentificationNumber /TrackRequest /cfxml cfhttp url=https://www.ups.com/ups.app/xml/Track; method=POST port=443 resolveurl=false cfhttpparam type=FORMFIELD name=XML value=#variables.xml# cfhttpparam type=FORMFIELD name=XML value=#variables.xml2# /cfhttp cfset caller.response = #cfhttp.filecontent# ~| 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: OT? SQL type 'decimal' = what in MS Access?
Howdy Peter, Tuesday, November 12, 2002, 9:44:16 PM, Tilbrook, Peter wrote: Interesting thing to note, after reading through the Microsoft SQL Server 2000 Introduction documentation is that Access 2000 does not upsize to SQL Server 2000 - you will need Access XP for that. Not true. I just recently upsized an Access 2000 database to MS SQL Server 2000 database just fine. If you plan to upsize to SQL Server 2000, install the Office 2000 SR-1 Update and the Access 2000 and SQL Server 2000 Readiness Update before you start. See the following knowledge base article for more info: http://support.microsoft.com/default.aspx?scid=kb;[LN];325017 -- Chris Montgomerymonty airtightweb.com Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: MX and UPS XML
Chad, CFHTTP will encode the form field and UPS will not read it correctly. There is a type xml in CFMX instead of formfield. -mk -Original Message- From: Chad [mailto:cgray;careyweb.com] Sent: Friday, November 15, 2002 9:41 AM To: CF-Talk Subject: MX and UPS XML OK correct me if I am wrong. To use the UPS XML I need to use the following to connect to the UPS server: cfhttp url=https://www.ups.com/ups.app/xml/Track; method=POST port=443 I also need the following to post the XML to the UPS server: cfhttpparam type=FORMFIELD name=XML value=#variables.xml# Then to return the results I just use: #cfhttp.filecontent# OK if I am right so far. How should I prep the XML to send to UPS? Should I use cfxml? Here is the code I have so far for a custom tag, but I keep getting this error from UPS: 0 Failure Hard 10002 The XML document is well formed but the document is not valid TrackRequest cfparam name=Attributes.Licensenumber default= cfparam name=Attributes.UserId default= cfparam name=Attributes.Password default= cfparam name=Attributes.TrackingNumber default= cfxml variable=xml AccessRequest xml:lang = en-US AccessLicenseNumbercfoutput#Attributes.licensenumber#/cfoutput/Ac cessLicenseNumber UserIdcfoutput#Attributes.UserId#/cfoutput/UserId Passwordcfoutput#Attributes.Password#/cfoutput/Password /AccessRequest /cfxml cfxml variable=xml2 TrackRequest xml:lang=en-US Request TransactionReference CustomerContext/CustomerContext XpciVersion1.0001/XpciVersion /TransactionReference RequestActionTrack/RequestAction RequestOption/RequestOption /Request ShipmentIdentificationNumbercfoutput#Attributes.TrackingNumber#/cfo utput/ShipmentIdentificationNumber /TrackRequest /cfxml cfhttp url=https://www.ups.com/ups.app/xml/Track; method=POST port=443 resolveurl=false cfhttpparam type=FORMFIELD name=XML value=#variables.xml# cfhttpparam type=FORMFIELD name=XML value=#variables.xml2# /cfhttp cfset caller.response = #cfhttp.filecontent# ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CF FileMaker Question
It's been years since I've used FM. Have they gotten to the point of actually storing more than one table in a file? As I recall, a major problem was that the relational DB capability was handled by pointing one file/table to another file/table. When setting up the datasource in CF, I could only see pointing it to one of the files which at that time didn't have all the tables. Not really an answer, just a memory of a wall I ran into years ago. - Kevin -Original Message- From: Ciliotta, Mario [mailto:mario.ciliotta;csfb.com] Sent: Friday, November 15, 2002 9:06 AM To: CF-Talk Subject: CF FileMaker Question Hi All, Does anyone know if it is possible to connect to a Filemaker database. Please do not rib me for using Filemaker - not my choice to make right now. Will be upgrading it to Oracle, next year. If it is possible could someone post the steps that are required to connect. I can use either CF4.5, 5.0 or MX. The version of Filemaker will be 6.0, along with FileMaker Mobile 2.1 on a Pocket PC. Thanks for the help in advance. Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| 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
Re: CF 5.0 certification(MM Web Interface)
Thanks Sean for making the info clear. I would like to comment on MM's web Interface to Certified Developers(CF or Other). http://www.macromedia.com/v1/handlers/index.cfm?Id=19865method=full The current interface is useless..You could NOT even search for developers by CITY/STATE/COUNTRY/Region etc.. I dont think Letters of last names have any relevance. There no total numbers.. What does everybody else here think? Joe On Thu, 14 Nov 2002 16:38:05 -0800 Sean A Corfield [EMAIL PROTECTED] wrote: On Thursday, Nov 14, 2002, at 12:59 US/Pacific, Jeffry Houser wrote: Beats me, but that is what is happening. All the CF5 names will be taken off the site in December. This has been said on this list (or the CFDJ list) in the past, but I don't know if that information is available anywhere on the MM site. The current CF5 certifications - and anyone who takes the CF5 certification exam up until the end of December - will remain valid through 12/31/2003, i.e., until the end of the NEXT calendar year. The CF5 certification exam itself will cease to be available at the end of THIS year (12/31/2002). After that date, CF certification will be on MX only. We hope that CFers will take the MX challenge prior to 12/31/2003 so that their certifications will remain up to date. Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute ~| 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
RE: CF 5.0 certification(MM Web Interface)
Joe check this link out. http://www.daemon.com.au/index.cfm?objectid=06BA83A1-D0B7-4CD6-F95BDE3F0AB10 4FF It will allow you to search by company, but City and State you can not. Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Joe Eugene [mailto:jebmail;earthlink.net] Sent: Friday, November 15, 2002 11:10 AM To: CF-Talk Subject: Re: CF 5.0 certification(MM Web Interface) Thanks Sean for making the info clear. I would like to comment on MM's web Interface to Certified Developers(CF or Other). http://www.macromedia.com/v1/handlers/index.cfm?Id=19865method=full The current interface is useless..You could NOT even search for developers by CITY/STATE/COUNTRY/Region etc.. I dont think Letters of last names have any relevance. There no total numbers.. What does everybody else here think? Joe On Thu, 14 Nov 2002 16:38:05 -0800 Sean A Corfield [EMAIL PROTECTED] wrote: On Thursday, Nov 14, 2002, at 12:59 US/Pacific, Jeffry Houser wrote: Beats me, but that is what is happening. All the CF5 names will be taken off the site in December. This has been said on this list (or the CFDJ list) in the past, but I don't know if that information is available anywhere on the MM site. The current CF5 certifications - and anyone who takes the CF5 certification exam up until the end of December - will remain valid through 12/31/2003, i.e., until the end of the NEXT calendar year. The CF5 certification exam itself will cease to be available at the end of THIS year (12/31/2002). After that date, CF certification will be on MX only. We hope that CFers will take the MX challenge prior to 12/31/2003 so that their certifications will remain up to date. Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
MXDC 03 Call for Speakers!
Want to be a speaker at the next MXDC conference in Washington DC on May 12-13 2003 (date tentative)??? Amaze your friends and coworkers! Share your hard-won knowledge! Hang out with other Macromedia enthusiasts! Simply fill out the form at the URL below. What are you waiting for? http://mxdc.figleaf.com/mxdc/schedule.cfm Regards, Steve Drucker CEO Fig Leaf Software w. www.figleaf.com p. (877) FIG-LEAF ~| 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
Re: OT:: FTP notification...without CF...etc.
Che Vilnonis wrote: I currently use War FTPD for FTP transfers. Do any of you gurus out there know how to automatically alert someone when a file has successfully been uploaded? I am looking for a War FTPD/Win 2K solution. Define Alert... you'll probably need SOME kind of programming language to do it.. Perl, CF, whatever.. and a scheduled job that that runs every minute that checks the file date and compares it with the last recorded filedate, alerts if the filedate is newer, then records the filedate somewhere. - Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CF 5.0 certification(MM Web Interface)
I would certainly agree that an enhanced search interface would be a great asset. For example, list all developers within a specified radius of a certain zip code, or search by last name (regardless of level or version). For certified developers, it would also be very nice to be able to see what percentile you're in (not your percentage score, but what percentage of other certified developers did better/worse then you on the exam). I've been told the reason they don't provide this at testing time is because the percentile is always changing (i.e., the first person to take the exam is always in the 100 percentile, and if that person scores a 97 and the second person scores a 95, then person with a 95 is in the 50 percentile, even though they have a very high score). If the percentile were available online, then the current percentile can be obtained. My $0.02 Sam At 08:10 AM 11/15/2002, you wrote: Thanks Sean for making the info clear. I would like to comment on MM's web Interface to Certified Developers(CF or Other). http://www.macromedia.com/v1/handlers/index.cfm?Id=19865method=full The current interface is useless..You could NOT even search for developers by CITY/STATE/COUNTRY/Region etc.. I dont think Letters of last names have any relevance. There no total numbers.. What does everybody else here think? Joe ~| 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: Verity index of a query
I have two tables I'm pulling together in a query result set. I need to know what I have to do in order to make sure that the current results of the query are the same as is in the collection. I think I have to update the collection but that's my question. ~Jason -Original Message- From: Stephen Moretti [mailto:stephen;cfmaster.co.uk] Sent: Friday, November 15, 2002 10:24 AM To: CF-Talk Subject: Re: Verity index of a query My application is basically a search engine. So whenever new sites are added I'm assuming that I won't have to recreate or update the verity index since it's based on a query... I just want to make sure that when they search the index they're getting everything back from the db as it currently stands. Let me know if I'm off base here. Ummm... Yeah you are a little off base... What is it that you actual want to index and to allow people to search? Stephen ~| 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
RE: OT:: FTP notification...without CF...etc.
A simple email notification would be great. ~Ché -Original Message- From: Rick Root [mailto:rroot;wakeinternet.com] Sent: Friday, November 15, 2002 11:19 AM To: CF-Talk Subject: Re: OT:: FTP notification...without CF...etc. Che Vilnonis wrote: I currently use War FTPD for FTP transfers. Do any of you gurus out there know how to automatically alert someone when a file has successfully been uploaded? I am looking for a War FTPD/Win 2K solution. Define Alert... you'll probably need SOME kind of programming language to do it.. Perl, CF, whatever.. and a scheduled job that that runs every minute that checks the file date and compares it with the last recorded filedate, alerts if the filedate is newer, then records the filedate somewhere. - Rick ~| 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.
Dynamically Build CFHTTP Param Tags?
Is there a way to dynamically generate CFHTTP Param tags for a CFHTTP call? I need to pass form fields through a CFHTTP call, but there may be different fields for each submission ... is there a way to do this? Thanks, Joshua Miller [EMAIL PROTECTED] ~| 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
RE: CF 5.0 certification(MM Web Interface)
Bryan, Thanks for the link. The graphs are really interesting, but can be a bit misleading. For example, in Finland, all developers are Advanced certified. That sounds impressive that for all the CF developers in the country, not a single one scored below 80 on the test. It sounds less impressive when you realize that there are only two certified developers in Finland. Ditto for all countries that have all advanced certified developers--Japan has 2, Maldova has 1, and Ukraine has 1. Sam At 11:14 AM 11/15/2002, you wrote: Joe check this link out. http://www.daemon.com.au/index.cfm?objectid=06BA83A1-D0B7-4CD6-F95BDE3F0AB10 4FF It will allow you to search by company, but City and State you can not. ~| 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
RE: CF 5.0 certification(MM Web Interface)
Bryan, Thanks.. daemon.com has a really cool interface.. Good Stats..eventhough u cant search by city/state.. u can order the listing by State.. its cool.. City would be nice. maybe MM should buy this interface from daemon.com. I emailed MM a while ago about this. No Response. Thanks to daemon.com for the good work. Joe On Fri, 15 Nov 2002 11:14:34 -0500 Bryan F. Hogan [EMAIL PROTECTED] wrote: Joe check this link out. http://www.daemon.com.au/index.cfm?objectid=06BA83A1-D0B7-4CD6-F95BDE3F0AB10 4FF It will allow you to search by company, but City and State you can not. Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Joe Eugene [mailto:jebmail;earthlink.net] Sent: Friday, November 15, 2002 11:10 AM To: CF-Talk Subject: Re: CF 5.0 certification(MM Web Interface) Thanks Sean for making the info clear. I would like to comment on MM's web Interface to Certified Developers(CF or Other). http://www.macromedia.com/v1/handlers/index.cfm?Id=19865method=full The current interface is useless..You could NOT even search for developers by CITY/STATE/COUNTRY/Region etc.. I dont think Letters of last names have any relevance. There no total numbers.. What does everybody else here think? Joe On Thu, 14 Nov 2002 16:38:05 -0800 Sean A Corfield wrote: On Thursday, Nov 14, 2002, at 12:59 US/Pacific, Jeffry Houser wrote: Beats me, but that is what is happening. All the CF5 names will be taken off the site in December. This has been said on this list (or the CFDJ list) in the past, but I don't know if that information is available anywhere on the MM site. The current CF5 certifications - and anyone who takes the CF5 certification exam up until the end of December - will remain valid through 12/31/2003, i.e., until the end of the NEXT calendar year. The CF5 certification exam itself will cease to be available at the end of THIS year (12/31/2002). After that date, CF certification will be on MX only. We hope that CFers will take the MX challenge prior to 12/31/2003 so that their certifications will remain up to date. Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Dynamically Build CFHTTP Param Tags?
Is there a way to dynamically generate CFHTTP Param tags for a CFHTTP call? I need to pass form fields through a CFHTTP call, but there may be different fields for each submission ... is there a way to do this? Thanks, Joshua Miller [EMAIL PROTECTED] I'd expect you should be able to use cfif inside your cfhttp call... cfhttp cfif ... cfhttpparam ... /cfif /cfhttp Does this not work? S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| 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
CFMX Web Services Help
Is there a guide.. 101 or what ever that walks you through building a CFMX web service? I have a couple small apps in CF5 that I need to translate into web services.. ~| 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
Re: Verity index of a query
~scratches head~ Right. I suspect that you don't actually need to JOIN your queries together for indexing into a collection. There is probably one or two text fields in one of the queries right? When you add a new record to that table (or when the record is marked as visible to the outside world) then you need to use CFINDEX to add it to the verity collection. When you delete (or mark it invisible) a record then you need to use CFINDEX to delete it from the collection. When you change the content of those text fields then you need to use CFINDEX to update your verity collection. quick example using a news article as an example !--- Previously insert and get the new ID for a News Story, then get all the details gathered in a query --- cfquery name=myNewStory datasource=myDSN SELECT NewsID,Headline,BodyText,ImageCaption FROM NewsStory WHERE NewID = #MyNewNewsID# /cfquery !--- Now Insert/Update the verity collection from the query --- cfindex action=UPDATE collection=NewsCollection key=NewsID type=CUSTOM title=Headline query=myNewStory body=Headline,BodyText,ImageCaption When you do a CFSEARCH one of the items that is returned as part of the query object is the key that you used in the cfindex. With this information and the other stuff you get back from a CFSEARCH (RTM) you'll be able to produce a list of all the record that match the users search criteria and provide links to the full display. I suggest you have a good read through the docs on verity in CFStudio, the books/online docs that came with CF Server or any good CF book. (Mastering CF 5 is a very good book I would highly recommend it... Haven't looked at Mastering CFMX yet...) Hope that helps to get you started. Regards Stephen - Original Message - From: Dowdell, Jason G [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 4:36 PM Subject: RE: Verity index of a query I have two tables I'm pulling together in a query result set. I need to know what I have to do in order to make sure that the current results of the query are the same as is in the collection. I think I have to update the collection but that's my question. ~Jason -Original Message- From: Stephen Moretti [mailto:stephen;cfmaster.co.uk] Sent: Friday, November 15, 2002 10:24 AM To: CF-Talk Subject: Re: Verity index of a query My application is basically a search engine. So whenever new sites are added I'm assuming that I won't have to recreate or update the verity index since it's based on a query... I just want to make sure that when they search the index they're getting everything back from the db as it currently stands. Let me know if I'm off base here. Ummm... Yeah you are a little off base... What is it that you actual want to index and to allow people to search? Stephen ~| 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
RE: CFMX Web Services Help
Look for the example in the docs. That will get you started. Ade -Original Message- From: SMR [mailto:info;smrenterprises.com] Sent: 15 November 2002 17:23 To: CF-Talk Subject: CFMX Web Services Help Is there a guide.. 101 or what ever that walks you through building a CFMX web service? I have a couple small apps in CF5 that I need to translate into web services.. ~| 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
Re: CFMX Web Services Help
The CFMX docs from MM ? - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 12:27 PM Subject: RE: CFMX Web Services Help Look for the example in the docs. That will get you started. Ade -Original Message- From: SMR [mailto:info;smrenterprises.com] Sent: 15 November 2002 17:23 To: CF-Talk Subject: CFMX Web Services Help Is there a guide.. 101 or what ever that walks you through building a CFMX web service? I have a couple small apps in CF5 that I need to translate into web services.. ~| 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: CFMX Web Services Help
Here you go, really quick basic: 1) Make web component. A page like the following (call it fakeservice.cfc) cfcomponent name=firstcomponent !--- the main function --- cffunction access=remote name=fakeservice output=false returntype=struct !--- mandatory parameter --- cfargument name=myNum type=numeric required=true !--- the return type is a struct --- cfset response.groovy = groovy cfset response.yourNum = myNum + 1 cfset temp = structAppend( response , arguments ) !--- what to send back --- cfreturn response /cffunction /cfcomponent 2) Make a page that calls the web service like so (pagename.cfm) h1Web Service/h1 !--- remote way --- cfinvoke method=fakeservice returnvariable=responseFromService webservice=http://forge/test/fakewebservice.cfc?WSDL; cfinvokeargument name=myNum value=3 /cfinvoke cfdump var=#responseFromService# 3) Then in your browser bring up the pagename.cfm. If all went well then the service will be in your cfmx administrator, and - of course - you should see some data. -Original Message- From: SMR [mailto:info;smrenterprises.com] Sent: Friday, November 15, 2002 9:23 AM To: CF-Talk Subject: CFMX Web Services Help Is there a guide.. 101 or what ever that walks you through building a CFMX web service? I have a couple small apps in CF5 that I need to translate into web services.. ~| 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
FW: ColdFusion or ColdFusionMX on a Sun Coblat RaQ4??
Is anyone running ColdFusion on a Sun Cobalt RaQ4?? Thanks, Chris White ~| 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: CFMX Web Services Help
some tutorials about ColdFusion Components (CFCs) from Macromedia site should help http://www.macromedia.com/desdev/mx/coldfusion/ -Original Message- From: SMR [mailto:info;smrenterprises.com] Sent: Saturday, November 16, 2002 1:31 AM To: CF-Talk Subject: Re: CFMX Web Services Help The CFMX docs from MM ? - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 12:27 PM Subject: RE: CFMX Web Services Help Look for the example in the docs. That will get you started. Ade -Original Message- From: SMR [mailto:info;smrenterprises.com] Sent: 15 November 2002 17:23 To: CF-Talk Subject: CFMX Web Services Help Is there a guide.. 101 or what ever that walks you through building a CFMX web service? I have a couple small apps in CF5 that I need to translate into web services.. ~| 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
RE: CFMX Web Services Help
Hi, Here is a direct link to Creating a Web Service in ColdFusion MX by Stacy Young: http://www.macromedia.com/desdev/mx/coldfusion/articles/webservices.pdf. Also check out Developing ColdFusion MX Applications with CFML--Chapter 31--Using Web Services http://livedocs.macromedia.com/cfmxdocs/Developing_ColdFusion_MX_Applications_with_CFML/webservices.jsp Lastly, be sure to visit our designer developer center for ColdFusion http://www.macromedia.com/desdev/mx/coldfusion/, there are all sorts of articles and tutorials on CFMX. Regards. Christine Lawson Macromedia -Original Message- From: SMR [mailto:info;smrenterprises.com] Sent: Friday, November 15, 2002 12:31 PM To: CF-Talk Subject: Re: CFMX Web Services Help The CFMX docs from MM ? - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 12:27 PM Subject: RE: CFMX Web Services Help Look for the example in the docs. That will get you started. Ade -Original Message- From: SMR [mailto:info;smrenterprises.com] Sent: 15 November 2002 17:23 To: CF-Talk Subject: CFMX Web Services Help Is there a guide.. 101 or what ever that walks you through building a CFMX web service? I have a couple small apps in CF5 that I need to translate into web services.. ~| 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
Locking pages in CF
I have an application in which techs can click to edit a ticket in the ticketing application. I would like to know what the best way is to prevent Tech B from getting into a ticket that Tech A is already in and currently modifying. I am thinking of using cflock, but where do I put it? Thanks, Aimee' Clark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFMX Web Services Help
thanks Christine.. I was out there looking and didn't see the quick and dirty guide that I was looking for.. I was hoping someone would have one... which they do.. I got the 5 step process email... I will read up on some of the other things out there to get some robustness out of the web service.. - Original Message - From: Christine Lawson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 1:01 PM Subject: RE: CFMX Web Services Help Hi, Here is a direct link to Creating a Web Service in ColdFusion MX by Stacy Young: http://www.macromedia.com/desdev/mx/coldfusion/articles/webservices.pdf. Also check out Developing ColdFusion MX Applications with CFML--Chapter 31--Using Web Services http://livedocs.macromedia.com/cfmxdocs/Developing_ColdFusion_MX_Application s_with_CFML/webservices.jsp Lastly, be sure to visit our designer developer center for ColdFusion http://www.macromedia.com/desdev/mx/coldfusion/, there are all sorts of articles and tutorials on CFMX. Regards. Christine Lawson Macromedia -Original Message- From: SMR [mailto:info;smrenterprises.com] Sent: Friday, November 15, 2002 12:31 PM To: CF-Talk Subject: Re: CFMX Web Services Help The CFMX docs from MM ? - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 12:27 PM Subject: RE: CFMX Web Services Help Look for the example in the docs. That will get you started. Ade -Original Message- From: SMR [mailto:info;smrenterprises.com] Sent: 15 November 2002 17:23 To: CF-Talk Subject: CFMX Web Services Help Is there a guide.. 101 or what ever that walks you through building a CFMX web service? I have a couple small apps in CF5 that I need to translate into web services.. ~| 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
RE: Locking pages in CF
CFLOCK has nothing to do with what you are needing. Assuming you are using a DB to store these 'tickets'...you could 1) add a field called INOUT, when a ticket is checked out, update inout to OUT. When the ticket is saved update inout to in. Now when someone tries to open a ticket in edit mode, check this field first. 2) a more relational way, perhaps, is to create a table say CHECKEDOUT that stores only checkout tickets. When a ticket is being edited, add the ticket number to this table, once saved remove it. If an edit is requested check this table, if the ticket id is in the table, open in read only mode. HTH Doug -Original Message- From: Clark, Aimee [mailto:aclark;stinsonmoheck.com] Sent: Friday, November 15, 2002 1:00 PM To: CF-Talk Subject: Locking pages in CF I have an application in which techs can click to edit a ticket in the ticketing application. I would like to know what the best way is to prevent Tech B from getting into a ticket that Tech A is already in and currently modifying. I am thinking of using cflock, but where do I put it? Thanks, Aimee' Clark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Locking pages in CF
To build on that idea, you are probably going to want to build a timeout function in there too. That way if someone pulls up the page for editing a ticket, then goes to lunch; the tickets are checked out 4ever. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: [EMAIL PROTECTED] [mailto:Douglas.Knudsen;alltel.com] Sent: Friday, November 15, 2002 1:09 PM To: CF-Talk Subject: RE: Locking pages in CF CFLOCK has nothing to do with what you are needing. Assuming you are using a DB to store these 'tickets'...you could 1) add a field called INOUT, when a ticket is checked out, update inout to OUT. When the ticket is saved update inout to in. Now when someone tries to open a ticket in edit mode, check this field first. 2) a more relational way, perhaps, is to create a table say CHECKEDOUT that stores only checkout tickets. When a ticket is being edited, add the ticket number to this table, once saved remove it. If an edit is requested check this table, if the ticket id is in the table, open in read only mode. HTH Doug -Original Message- From: Clark, Aimee [mailto:aclark;stinsonmoheck.com] Sent: Friday, November 15, 2002 1:00 PM To: CF-Talk Subject: Locking pages in CF I have an application in which techs can click to edit a ticket in the ticketing application. I would like to know what the best way is to prevent Tech B from getting into a ticket that Tech A is already in and currently modifying. I am thinking of using cflock, but where do I put it? Thanks, Aimee' Clark ~| 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: Locking pages in CF
we did this at my previous company, we pretty much did it exactly as you guys mentioned. we also built an admin page that could monitor locked tickets and delete them, just in case of an emergency, helps in testing as well. if you want the source let me know, the company won't mind since it died :( -Original Message- From: Adrocknaphobia Jones [mailto:adrocknatalk;hotmail.com] Sent: Friday, November 15, 2002 1:46 PM To: CF-Talk Subject: RE: Locking pages in CF To build on that idea, you are probably going to want to build a timeout function in there too. That way if someone pulls up the page for editing a ticket, then goes to lunch; the tickets are checked out 4ever. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: [EMAIL PROTECTED] [mailto:Douglas.Knudsen;alltel.com] Sent: Friday, November 15, 2002 1:09 PM To: CF-Talk Subject: RE: Locking pages in CF CFLOCK has nothing to do with what you are needing. Assuming you are using a DB to store these 'tickets'...you could 1) add a field called INOUT, when a ticket is checked out, update inout to OUT. When the ticket is saved update inout to in. Now when someone tries to open a ticket in edit mode, check this field first. 2) a more relational way, perhaps, is to create a table say CHECKEDOUT that stores only checkout tickets. When a ticket is being edited, add the ticket number to this table, once saved remove it. If an edit is requested check this table, if the ticket id is in the table, open in read only mode. HTH Doug -Original Message- From: Clark, Aimee [mailto:aclark;stinsonmoheck.com] Sent: Friday, November 15, 2002 1:00 PM To: CF-Talk Subject: Locking pages in CF I have an application in which techs can click to edit a ticket in the ticketing application. I would like to know what the best way is to prevent Tech B from getting into a ticket that Tech A is already in and currently modifying. I am thinking of using cflock, but where do I put it? Thanks, Aimee' Clark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: : FTP notification...without CF...etc.
We use sitescope (http://www.sitescope.com) to monitor the number of files in number of different directories and alert us there is a change. Actually, we use it to monitor the whole production environment to make sure everything is running smoothly... Justin -Original Message- From: Che Vilnonis [mailto:chevy;asitv.com] Sent: Friday, November 15, 2002 10:37 AM To: CF-Talk Subject: OT:: FTP notification...without CF...etc. I currently use War FTPD for FTP transfers. Do any of you gurus out there know how to automatically alert someone when a file has successfully been uploaded? I am looking for a War FTPD/Win 2K solution. Thanks... Ché Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| 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: Dynamically Build CFHTTP Param Tags?
That would work, but I don't know the names of the form fields coming in. I'm using CFHTTP to generate reports in different mime-types. Each report has a template for each mime-type and each report has different data, what I'm wanting to do is build one template that handles retrieving the template, saving the content as a variable then writing the file in the appropriate mime type and returning a response to the user. It's working thus far with URL parameters, but a couple of the forms have too many fields to pass on the URL string - IE returned an error that the query string was too long, so I have to use POST. To use POST I need CFPARAM tags and thus my problem. I think I'll do it with INCLUDE files instead of CFHTTP, although I wanted the ability to query remote templates on other servers - guess that's not going to happen just yet. Joshua Miller [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:info;turnkey.to] Sent: Friday, November 15, 2002 12:09 PM To: CF-Talk Subject: Re: Dynamically Build CFHTTP Param Tags? Is there a way to dynamically generate CFHTTP Param tags for a CFHTTP call? I need to pass form fields through a CFHTTP call, but there may be different fields for each submission ... is there a way to do this? Thanks, Joshua Miller [EMAIL PROTECTED] I'd expect you should be able to use cfif inside your cfhttp call... cfhttp cfif ... cfhttpparam ... /cfif /cfhttp Does this not work? S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| 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
RE: Locking pages in CF
On a different note than the db-based approach, I use two application variables per lock to do the job. Tracks who owns the locks so the lock owner can keep editing after they place the lock themselves (or whatever), expires them etc. In looking at this code now I bet lock status and ownership can be done with a single app var that's a structure rather than with two that store simple values. The code is below. I just chopped it out of a working app, so there may be some vars in there not explained immediately below. Replace my vars with yours, of course. The code is commented inline and should explain whats going on pretty well. Call inc_lockcheck with a cfinclude at the point you want to check if record X is locked or not. The returned result will be either LOCKED or UNLOCKED. If UNLOCKED that means the current user just put a lock on it which they themselves own. Cheers, -- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - retail stuff http://foohbar.org - CF tools -- Externally set variables: - Client.EditMarker: ID num of the record someone is trying to lock Client.Producer: ID num of the curr user's user record Settings.SessionLasts: Numeric value (minutes) !--- My name is inc_lockcheck.cfm returns: variables.LockStatus = LOCKED or UNLOCKED --- cfparam name=variables.LockStatus default=UNLOCKED type=string cflock scope=APPLICATION type=EXCLUSIVE timeout=10 cfif not StructKeyExists(application, RECORD#client.EditMarker#) cfmodule template=tag_lockmake.cfm editmarker=#client.EditMarker# owner=#client.Producer# cfelse !--- if its already locked, is it someone else's lock? --- cfif CompareNoCase(Evaluate(application.RECORD#client.EditMarker#Owner),cli ent.Producer) !--- This page is subject to an unexpired lock belonging to someone else. Has the lock expired? --- cfif DateDiff(n,Evaluate(application.RECORD#client.EditMarker#), now()) LT Settings.SessionLasts !--- It has not expired. --- cfset variables.LockStatus=LOCKED cfelse !-- max allowed lock time exceeded. Break the lock and let me lock it for myself. --- cfinclude template=inc_lockbreak.cfm cfmodule template=tag_lockmake.cfm editmarker=#client.EditMarker# owner=#client.Producer# /cfif cfelse !--- Its my lock. update my last access time --- cfset application.Record#client.EditMarker# = now() /cfif /cfif /cflock !--- My name is tag_lockmake.cfm A cflock was already placed around me by the calling template --- cfset application.Record#attributes.EditMarker# = now() cfset application.Record#attributes.EditMarker#Owner=attributes.owner ~| 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
Ramdomizing elements in a LIST
I'm trying to randomize the output of a list within a CFLOOP. Any help would be great. Her's what I have so far. cfloop INDEX=ListElement LIST=John,Paul,Ringo,George CFOUTPUT#ListElement#/CFOUTPUTBR /cfloop D ~| 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
Re: Dynamically Build CFHTTP Param Tags?
Why don't you just CFLOOP .../CFLOOP over the Form structure to include CFHTTPPARAM ... tags for each form field? - Rick ~| 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: Ramdomizing elements in a LIST
How about: cfset list=John,Paul,Ringo,George cfoutput#getToken( list,randrange(1,listlen(list)),',' )#/cfoutput -Original Message- From: [EMAIL PROTECTED] [mailto:coldfusion.developer;att.net] Sent: Friday, November 15, 2002 11:19 AM To: CF-Talk Subject: Ramdomizing elements in a LIST I'm trying to randomize the output of a list within a CFLOOP. Any help would be great. Her's what I have so far. cfloop INDEX=ListElement LIST=John,Paul,Ringo,George CFOUTPUT#ListElement#/CFOUTPUTBR /cfloop D ~| 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: Ramdomizing elements in a LIST
Oops I read that wrong sorry -Original Message- From: [EMAIL PROTECTED] [mailto:coldfusion.developer;att.net] Sent: Friday, November 15, 2002 11:19 AM To: CF-Talk Subject: Ramdomizing elements in a LIST I'm trying to randomize the output of a list within a CFLOOP. Any help would be great. Her's what I have so far. cfloop INDEX=ListElement LIST=John,Paul,Ringo,George CFOUTPUT#ListElement#/CFOUTPUTBR /cfloop D ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Ramdomizing elements in a LIST
cfloop condition=listlen(mylist) cfset target = randRange(1,listLen(myList)) cfoutput#listGetAt(mylist,target)#br/cfoutput cfset myList = listDeleteAt(myList,target) /cfloop === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:coldfusion.developer;att.net] Sent: Friday, November 15, 2002 2:19 PM To: CF-Talk Subject: Ramdomizing elements in a LIST I'm trying to randomize the output of a list within a CFLOOP. Any help would be great. Her's what I have so far. cfloop INDEX=ListElement LIST=John,Paul,Ringo,George CFOUTPUT#ListElement#/CFOUTPUTBR /cfloop D ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Dynamically Build CFHTTP Param Tags?
Maybe I'm not fully understanding the issue -- if you forward some of the code you've got for using URL variables to the list (or to me personally, whichever), maybe I'll have some better suggestions. Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 That would work, but I don't know the names of the form fields coming in. I'm using CFHTTP to generate reports in different mime-types. Each report has a template for each mime-type and each report has different data, what I'm wanting to do is build one template that handles retrieving the template, saving the content as a variable then writing the file in the appropriate mime type and returning a response to the user. It's working thus far with URL parameters, but a couple of the forms have too many fields to pass on the URL string - IE returned an error that the query string was too long, so I have to use POST. To use POST I need CFPARAM tags and thus my problem. I think I'll do it with INCLUDE files instead of CFHTTP, although I wanted the ability to query remote templates on other servers - guess that's not going to happen just yet. Joshua Miller [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:info;turnkey.to] Sent: Friday, November 15, 2002 12:09 PM To: CF-Talk Subject: Re: Dynamically Build CFHTTP Param Tags? Is there a way to dynamically generate CFHTTP Param tags for a CFHTTP call? I need to pass form fields through a CFHTTP call, but there may be different fields for each submission ... is there a way to do this? Thanks, Joshua Miller [EMAIL PROTECTED] I'd expect you should be able to use cfif inside your cfhttp call... cfhttp cfif ... cfhttpparam ... /cfif /cfhttp Does this not work? S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| 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
Ramdomizing output of elements in a LIST
I'm trying to randomize the output of elements a list. Any help would be great. Her's what I have so far. I have a three cell table that I want to insert a random element from the list, one element into each list without repeating an element. table tr td/td td/td td/td /tr /table and ... cfloop INDEX=ListElement LIST=John,Paul,Ringo,George CFOUTPUT#ListElement#/CFOUTPUTBR /cfloop D ~| 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: Dynamically Build CFHTTP Param Tags?
CFLOOP INDEX=Field LIST=#FORM.FieldNames# CFHTTPPARAM TYPE=FormField NAME=#FORM['Field']# VALUE=#FORM[Field]# /CFLOOP Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Joshua Miller [mailto:josh;joshuasmiller.com] Sent: Friday, November 15, 2002 2:07 PM To: CF-Talk Subject: RE: Dynamically Build CFHTTP Param Tags? That would work, but I don't know the names of the form fields coming in. I'm using CFHTTP to generate reports in different mime-types. Each report has a template for each mime-type and each report has different data, what I'm wanting to do is build one template that handles retrieving the template, saving the content as a variable then writing the file in the appropriate mime type and returning a response to the user. It's working thus far with URL parameters, but a couple of the forms have too many fields to pass on the URL string - IE returned an error that the query string was too long, so I have to use POST. To use POST I need CFPARAM tags and thus my problem. I think I'll do it with INCLUDE files instead of CFHTTP, although I wanted the ability to query remote templates on other servers - guess that's not going to happen just yet. Joshua Miller [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:info;turnkey.to] Sent: Friday, November 15, 2002 12:09 PM To: CF-Talk Subject: Re: Dynamically Build CFHTTP Param Tags? Is there a way to dynamically generate CFHTTP Param tags for a CFHTTP call? I need to pass form fields through a CFHTTP call, but there may be different fields for each submission ... is there a way to do this? Thanks, Joshua Miller [EMAIL PROTECTED] I'd expect you should be able to use cfif inside your cfhttp call... cfhttp cfif ... cfhttpparam ... /cfif /cfhttp Does this not work? S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Ramdomizing elements in a LIST
Thank you. This might work for my application. How about: cfset list=John,Paul,Ringo,George cfoutput#getToken( list,randrange(1,listlen(list)),',' )#/cfoutput -Original Message- From: [EMAIL PROTECTED] [mailto:coldfusion.developer;att.net] Sent: Friday, November 15, 2002 11:19 AM To: CF-Talk Subject: Ramdomizing elements in a LIST I'm trying to randomize the output of a list within a CFLOOP. Any help would be great. Her's what I have so far. cfloop INDEX=ListElement LIST=John,Paul,Ringo,George CFOUTPUT#ListElement#/CFOUTPUTBR /cfloop D ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Ramdomizing elements in a LIST
I think this is what you were asking for cfscript list=John,Paul,Ringo,George; for(x=listLen(list); x gte 1; x=x-1){ theone = randrange(1,x); writeOutput( getToken(list,theone,',') ); list = listDeleteAt(list,theone,','); } /cfscript -Original Message- From: [EMAIL PROTECTED] [mailto:coldfusion.developer;att.net] Sent: Friday, November 15, 2002 11:19 AM To: CF-Talk Subject: Ramdomizing elements in a LIST I'm trying to randomize the output of a list within a CFLOOP. Any help would be great. Her's what I have so far. cfloop INDEX=ListElement LIST=John,Paul,Ringo,George CFOUTPUT#ListElement#/CFOUTPUTBR /cfloop D ~| 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: MX and UPS XML
The MX documentation mentions nothing about a cfhttpparam type=XML... Are you sure this exists? -Original Message- From: Mark A. Kruger - CFG [mailto:mkruger;cfwebtools.com] Sent: Friday, November 15, 2002 11:00 AM To: CF-Talk Subject: RE: MX and UPS XML Chad, CFHTTP will encode the form field and UPS will not read it correctly. There is a type xml in CFMX instead of formfield. -mk -Original Message- From: Chad [mailto:cgray;careyweb.com] Sent: Friday, November 15, 2002 9:41 AM To: CF-Talk Subject: MX and UPS XML OK correct me if I am wrong. To use the UPS XML I need to use the following to connect to the UPS server: cfhttp url=https://www.ups.com/ups.app/xml/Track; method=POST port=443 I also need the following to post the XML to the UPS server: cfhttpparam type=FORMFIELD name=XML value=#variables.xml# Then to return the results I just use: #cfhttp.filecontent# OK if I am right so far. How should I prep the XML to send to UPS? Should I use cfxml? Here is the code I have so far for a custom tag, but I keep getting this error from UPS: 0 Failure Hard 10002 The XML document is well formed but the document is not valid TrackRequest cfparam name=Attributes.Licensenumber default= cfparam name=Attributes.UserId default= cfparam name=Attributes.Password default= cfparam name=Attributes.TrackingNumber default= cfxml variable=xml AccessRequest xml:lang = en-US AccessLicenseNumbercfoutput#Attributes.licensenumber#/cfoutput/Ac cessLicenseNumber UserIdcfoutput#Attributes.UserId#/cfoutput/UserId Passwordcfoutput#Attributes.Password#/cfoutput/Password /AccessRequest /cfxml cfxml variable=xml2 TrackRequest xml:lang=en-US Request TransactionReference CustomerContext/CustomerContext XpciVersion1.0001/XpciVersion /TransactionReference RequestActionTrack/RequestAction RequestOption/RequestOption /Request ShipmentIdentificationNumbercfoutput#Attributes.TrackingNumber#/cfo utput/ShipmentIdentificationNumber /TrackRequest /cfxml cfhttp url=https://www.ups.com/ups.app/xml/Track; method=POST port=443 resolveurl=false cfhttpparam type=FORMFIELD name=XML value=#variables.xml# cfhttpparam type=FORMFIELD name=XML value=#variables.xml2# /cfhttp cfset caller.response = #cfhttp.filecontent# ~| 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.
[OT] Zip Code Lookup
Hey List: I'm building an application where i need to do the 'search within x miles of zip code 12345' Can anybody make a recommendation? The client would like something that offers updates fairly regularly. Maybe even some sort of XML feed direct from the (a) source? Any leads would be greatly appreciated. Oh, and would be nice if it integrated easily with CF (to kinda bring this question a little bit on topic) :) Thx, charlie ~| 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
FW: CF 5.0 certification - according to MMCP!
I really didnt think this subject would spark such controversy.. so, to bring it to a clean and proper conclusion, i emailed MMCP [[EMAIL PROTECTED]] Their response appears below. Thanks to everyone! Andres Leon -Original Message- From: MMCP [mailto:mmcp;macromedia.com] Sent: Friday, November 15, 2002 1:40 PM To: Andres Subject: RE: CF 5.0 certification Dear Andres, Thank you for your email. Your certification for the Coldfusion 5.0 exam will be valid until December 31, 2003. You can at this time upgrade to the Coldfusion MX certification by passing that exam. Thanks again for your interest in Macromedia. MMCP -Original Message- From: Andres [mailto:Andres;vitacost.com] Sent: Thursday, November 14, 2002 4:06 PM To: [EMAIL PROTECTED] Subject: CF 5.0 certification To whom it may concern, I recently took the CF5.0 certification exam. My question is: Will my certification expire after 12/31/2002? Or will it just be that in order to be a certificed developer one must take the MX exam? Thank you for your time. Andres Leon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Dynamically Build CFHTTP Param Tags?
CFLOOP INDEX=Field LIST=#FORM.FieldNames# CFHTTPPARAM TYPE=FormField NAME=#FORM['Field']# VALUE=#FORM[Field]# /CFLOOP Almost... CFLOOP INDEX=Field LIST=#FORM.FieldNames# CFHTTPPARAM TYPE=FormField NAME=#Field# VALUE=#FORM[Field]# /CFLOOP Just a typo, I know. :) Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Joshua Miller [mailto:josh;joshuasmiller.com] Sent: Friday, November 15, 2002 2:07 PM To: CF-Talk Subject: RE: Dynamically Build CFHTTP Param Tags? That would work, but I don't know the names of the form fields coming in. I'm using CFHTTP to generate reports in different mime-types. Each report has a template for each mime-type and each report has different data, what I'm wanting to do is build one template that handles retrieving the template, saving the content as a variable then writing the file in the appropriate mime type and returning a response to the user. It's working thus far with URL parameters, but a couple of the forms have too many fields to pass on the URL string - IE returned an error that the query string was too long, so I have to use POST. To use POST I need CFPARAM tags and thus my problem. I think I'll do it with INCLUDE files instead of CFHTTP, although I wanted the ability to query remote templates on other servers - guess that's not going to happen just yet. Joshua Miller [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:info;turnkey.to] Sent: Friday, November 15, 2002 12:09 PM To: CF-Talk Subject: Re: Dynamically Build CFHTTP Param Tags? Is there a way to dynamically generate CFHTTP Param tags for a CFHTTP call? I need to pass form fields through a CFHTTP call, but there may be different fields for each submission ... is there a way to do this? Thanks, Joshua Miller [EMAIL PROTECTED] I'd expect you should be able to use cfif inside your cfhttp call... cfhttp cfif ... cfhttpparam ... /cfif /cfhttp Does this not work? S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| 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
Re: Ramdomizing output of elements in a LIST
I ran this on my server, it worked great. - Rick CFSET TheList = John,Paul,Ringo,George TABLE TR CFLOOP FROM=1 TO=3 STEP=1 INDEX=temp CFSET Position = RandRange(1,ListLen(TheList)) TDCFOUTPUT#ListGetAt(TheList,Position)#/CFOUTPUT/TD CFSET TheList = ListDeleteAt(TheList,Position) /CFLOOP /TR /TABLE [EMAIL PROTECTED] wrote: I'm trying to randomize the output of elements a list. Any help would be great. Her's what I have so far. I have a three cell table that I want to insert a random element from the list, one element into each list without repeating an element. table tr td/td td/td td/td /tr /table and ... cfloop INDEX=ListElement LIST=John,Paul,Ringo,George CFOUTPUT#ListElement#/CFOUTPUTBR /cfloop D ~| 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
cfmx and .exe downloading.
has anyone else seen odd behavior when someone clicks on an exe file to download from your cfmx/iis5 server using ie6 and ie6 not putting the .exe file extension in the file type box, but it puts a type of document in the file type box? its a real pain in the arse, trying to explain to people to just hit the end key and type .exe at the endsame behavior does not happen with mozilla only ie6 thanks! ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: [OT] Zip Code Lookup
I'm pretty sure there is a UDF at www.cflib.org that will do the calculations for you. You'll need the data behind it all of course. If you search for zip code databases on Google I'm sure you'll find lots (some site called Zap and another called Bullseye come to mind...but don't quote me on that). HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: charlie griefer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 11:52 AM Subject: [OT] Zip Code Lookup Hey List: I'm building an application where i need to do the 'search within x miles of zip code 12345' Can anybody make a recommendation? The client would like something that offers updates fairly regularly. Maybe even some sort of XML feed direct from the (a) source? Any leads would be greatly appreciated. Oh, and would be nice if it integrated easily with CF (to kinda bring this question a little bit on topic) :) Thx, charlie ~| 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
RE: MX and UPS XML
The updated docs mention this as a new type. Mark -Original Message- From: Chad [mailto:cgray;careyweb.com] Sent: Friday, November 15, 2002 11:41 AM To: CF-Talk Subject: RE: MX and UPS XML The MX documentation mentions nothing about a cfhttpparam type=XML... Are you sure this exists? -Original Message- From: Mark A. Kruger - CFG [mailto:mkruger;cfwebtools.com] Sent: Friday, November 15, 2002 11:00 AM To: CF-Talk Subject: RE: MX and UPS XML Chad, CFHTTP will encode the form field and UPS will not read it correctly. There is a type xml in CFMX instead of formfield. -mk -Original Message- From: Chad [mailto:cgray;careyweb.com] Sent: Friday, November 15, 2002 9:41 AM To: CF-Talk Subject: MX and UPS XML OK correct me if I am wrong. To use the UPS XML I need to use the following to connect to the UPS server: cfhttp url=https://www.ups.com/ups.app/xml/Track; method=POST port=443 I also need the following to post the XML to the UPS server: cfhttpparam type=FORMFIELD name=XML value=#variables.xml# Then to return the results I just use: #cfhttp.filecontent# OK if I am right so far. How should I prep the XML to send to UPS? Should I use cfxml? Here is the code I have so far for a custom tag, but I keep getting this error from UPS: 0 Failure Hard 10002 The XML document is well formed but the document is not valid TrackRequest cfparam name=Attributes.Licensenumber default= cfparam name=Attributes.UserId default= cfparam name=Attributes.Password default= cfparam name=Attributes.TrackingNumber default= cfxml variable=xml AccessRequest xml:lang = en-US AccessLicenseNumbercfoutput#Attributes.licensenumber#/cfoutput/Ac cessLicenseNumber UserIdcfoutput#Attributes.UserId#/cfoutput/UserId Passwordcfoutput#Attributes.Password#/cfoutput/Password /AccessRequest /cfxml cfxml variable=xml2 TrackRequest xml:lang=en-US Request TransactionReference CustomerContext/CustomerContext XpciVersion1.0001/XpciVersion /TransactionReference RequestActionTrack/RequestAction RequestOption/RequestOption /Request ShipmentIdentificationNumbercfoutput#Attributes.TrackingNumber#/cfo utput/ShipmentIdentificationNumber /TrackRequest /cfxml cfhttp url=https://www.ups.com/ups.app/xml/Track; method=POST port=443 resolveurl=false cfhttpparam type=FORMFIELD name=XML value=#variables.xml# cfhttpparam type=FORMFIELD name=XML value=#variables.xml2# /cfhttp cfset caller.response = #cfhttp.filecontent# ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
SSL Post
Hello List: Company i work for is ready to start accepting credit cards online. I know very little of e-commerce and ssl and all that good stuff. the bank said there were java and php modules that existed to do ssl posts, so he's sure there must be a cf one as well. first question is...what is an ssl post? sounds to me like just posting a form to an https address instead of an http address. is that incorrect? do i, in fact, need any special cf tags/code to do this? thanks, charlie ~| 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: SQL vs PL/SQL
If you're just converting queries into Oracle stored procedures, I think it would be fair to estimate a weekend to a week to get up to speed (depending on your experience with SQL and the time you put in to it). But to get good at what you're doing will take a longer... I'd just like to point out that, while closely related, PL/SQL and SQL are two very different languages. PL/SQL is more of a regular procedural programming language and the things you do with it are different than the things you do with straight SQL. PL/SQL is used more for the things you do with CF, Java or any other regular programming language. PL/SQL was just designed for a particular niche, the Oracle database, so it has db specific features, too. SQL is a (fairly) standard way to interact with databases and is more of a functional language. When you write PL/SQL you'll use SQL. I you can download Oracle from their web site (or at least you used to be able to) and play around with it. That and the docs should be a good start... Jeff Polaski The cow is of the bovine ilk; One end is moo, the other, milk. -- Ogden Nash -Original Message- From: Casey C Cook [mailto:ccook22;csc.com] Sent: Thursday, November 14, 2002 8:34 AM To: CF-Talk Subject: OT: SQL vs PL/SQL If someone came to you and said we need someone to work with Oracle and PL/SQL to write some queries, but all you knew was SQL, how much of PL/SQL would you say you already knew, knowing there are some syntax differences between the two query writing languages? Im just trying to gauge how much work I will have to do to to pick up PL/SQL, a weekenda week...a month? Thanks, Casey Cook ~| 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
RE: SSL Post
no charlie you don't. not to my knowledge. you can just change the posting address to an https page, and that should do it for ya! ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: charlie griefer [mailto:charlie;griefer.com] Sent: Friday, November 15, 2002 3:44 PM To: CF-Talk Subject: SSL Post Hello List: Company i work for is ready to start accepting credit cards online. I know very little of e-commerce and ssl and all that good stuff. the bank said there were java and php modules that existed to do ssl posts, so he's sure there must be a cf one as well. first question is...what is an ssl post? sounds to me like just posting a form to an https address instead of an http address. is that incorrect? do i, in fact, need any special cf tags/code to do this? thanks, charlie ~| 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: SSL Post
Sounds to me like they may be talking about a Payment gateway which allows you do charge credit cards in real time. PayFlow Pro from Verisign has a ColdFusion java tag that will work with your existing pages. -Original Message- From: charlie griefer [mailto:charlie;griefer.com] Sent: Friday, November 15, 2002 3:44 PM To: CF-Talk Subject: SSL Post Hello List: Company i work for is ready to start accepting credit cards online. I know very little of e-commerce and ssl and all that good stuff. the bank said there were java and php modules that existed to do ssl posts, so he's sure there must be a cf one as well. first question is...what is an ssl post? sounds to me like just posting a form to an https address instead of an http address. is that incorrect? do i, in fact, need any special cf tags/code to do this? thanks, charlie ~| 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
SOT: cookies / WDDX
I'm trying to build some multi-part forms that are supposed to store all the form data in cookies, so people can leave bits unfinished, come back at a later date and finish the form off. The forms aren't *massive*, but they're not small either - not entirely sure how much data could be stored, but I'm trying to find out some limits to plan the project. It says in O'Reilly's JS Bible that web browsers don't store more than 20 cookies per domain and each cookie can't be more than 4 KB in size. Now, 4 KB is probably not enough to store ALL potential data - but 20 is not enough if I tried to store each *field* in a separate cookie. I've heard about WDDX being used to interact between CF and JS, but I've not used it before, and I can't think how it could overcome the above cookie limitations. I'd be grateful if anyone had any more info on cookie limitations, or ideas about how to handle this situation (without a DB!). Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| 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: [OT] Zip Code Lookup
Search the archives. This has been discussed a couple of times. Andy -Original Message- From: charlie griefer [mailto:charlie;griefer.com] Sent: Friday, November 15, 2002 1:53 PM To: CF-Talk Subject: [OT] Zip Code Lookup Hey List: I'm building an application where i need to do the 'search within x miles of zip code 12345' Can anybody make a recommendation? The client would like something that offers updates fairly regularly. Maybe even some sort of XML feed direct from the (a) source? Any leads would be greatly appreciated. Oh, and would be nice if it integrated easily with CF (to kinda bring this question a little bit on topic) :) Thx, charlie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: cookies / WDDX
complex data cannot be stored in a cookie. the best way to handle itclient variables, that are stored in a db or in the registry. I think you can store in the registry like you store in a db. either way, I solved the same problem you have by using a structure full of vars that are stored in session variables while the user is active, and in client variables, while the user is gone. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Gyrus [mailto:gyrus;rooted.freeuk.com] Sent: Friday, November 15, 2002 3:57 PM To: CF-Talk Subject: SOT: cookies / WDDX I'm trying to build some multi-part forms that are supposed to store all the form data in cookies, so people can leave bits unfinished, come back at a later date and finish the form off. The forms aren't *massive*, but they're not small either - not entirely sure how much data could be stored, but I'm trying to find out some limits to plan the project. It says in O'Reilly's JS Bible that web browsers don't store more than 20 cookies per domain and each cookie can't be more than 4 KB in size. Now, 4 KB is probably not enough to store ALL potential data - but 20 is not enough if I tried to store each *field* in a separate cookie. I've heard about WDDX being used to interact between CF and JS, but I've not used it before, and I can't think how it could overcome the above cookie limitations. I'd be grateful if anyone had any more info on cookie limitations, or ideas about how to handle this situation (without a DB!). Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| 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
Re: SSL Post
charlie griefer wrote: Hello List: do i, in fact, need any special cf tags/code to do this? That entirely depends on the payment gateway. With Authorize.net you don't need a special tag, though they are available. All you need to do is use the CFHTTP tag to do the post, and if the URL starts with https:// it'll be an ssl post. I did this recently and it was actually pretty easy. Some other payment gateways, like Card Services International's LinkPoint (LinkPort?) use custom CFX tags. - Rick ~| 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
Re: cookies / WDDX
I'm doing just what you are right now. Follow these steps: 1) form is posted 2) create a new query using QueryNew() 3) add a row to the query using QueryAddRow() 4) add all the form data to the row in the query usingh QuerySetCell() 5) serialize the query into a WDDX packet using CFWDDX 6) set a cookie with the value of the WDDX packet using CFCOOKIE Then wherever you need the data. 1) deserialze the WDDX packet in the cookie 2) voila you have a query with all form data in it 3) do whatever ya need to to re-create your form as it was left HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 12:57 PM Subject: SOT: cookies / WDDX I'm trying to build some multi-part forms that are supposed to store all the form data in cookies, so people can leave bits unfinished, come back at a later date and finish the form off. The forms aren't *massive*, but they're not small either - not entirely sure how much data could be stored, but I'm trying to find out some limits to plan the project. It says in O'Reilly's JS Bible that web browsers don't store more than 20 cookies per domain and each cookie can't be more than 4 KB in size. Now, 4 KB is probably not enough to store ALL potential data - but 20 is not enough if I tried to store each *field* in a separate cookie. I've heard about WDDX being used to interact between CF and JS, but I've not used it before, and I can't think how it could overcome the above cookie limitations. I'd be grateful if anyone had any more info on cookie limitations, or ideas about how to handle this situation (without a DB!). Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| 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: [OT] Zip Code Lookup
shameless_plug Check out http://www.dbactive.com and look at the CF_ZipRad custom tag. /shameless_plug -Original Message- From: charlie griefer [mailto:charlie;griefer.com] Sent: Friday, November 15, 2002 2:53 PM To: CF-Talk Subject: [OT] Zip Code Lookup Hey List: I'm building an application where i need to do the 'search within x miles of zip code 12345' Can anybody make a recommendation? The client would like something that offers updates fairly regularly. Maybe even some sort of XML feed direct from the (a) source? Any leads would be greatly appreciated. Oh, and would be nice if it integrated easily with CF (to kinda bring this question a little bit on topic) :) Thx, charlie ~| 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
Re: SSL Post
On a related note: When doing a secure post from a non-secure page, a new cfid and cftoken could wind up being generated if you are visiting with a Netscape browser (i.e. you lose state). On your form submission page, unless you take steps to solve the problem, NN users could have a new session. The form post works fine in IE. I just had this happen to me yesterday. Hacked out a solution that passed the urltoken via the form post, and then reset cfid and cftoken to the original values on the post page. I think part of the problem lies with NN thinking cookies for 'abc.com' and 'www.abc.com' don't apply to one another. Not sure about that, though. I haven't fully researched this yet. If anyone has specifics please pass 'em along. --- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail http://foohbar.org - ColdFusion Tools --- -- Original Message -- from: charlie griefer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 15 Nov 2002 13:44:01 -0700 Hello List: Company i work for is ready to start accepting credit cards online. I know very little of e-commerce and ssl and all that good stuff. the bank said there were java and php modules that existed to do ssl posts, so he's sure there must be a cf one as well. first question is...what is an ssl post? sounds to me like just posting a form to an https address instead of an http address. is that incorrect? do i, in fact, need any special cf tags/code to do this? thanks, charlie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: : FTP notification...without CF...etc.
It's been a while since I last used WAR, but I'm fairly certain it allows you to write a custom DLL to respond to file uploads. You could write a quick and dirty extension to do whatever you want it to do. Check out www.jgaa.com for more info on it. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Che Vilnonis [mailto:chevy;asitv.com] Sent: Friday, November 15, 2002 10:37 AM To: CF-Talk Subject: OT:: FTP notification...without CF...etc. I currently use War FTPD for FTP transfers. Do any of you gurus out there know how to automatically alert someone when a file has successfully been uploaded? I am looking for a War FTPD/Win 2K solution. Thanks... Ché Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: cookies / WDDX
bryan, I thought for sure I read that you couldn't store complex vars in a cookie.but I guess a wddx packet can really be percieved as a string, and if the length works, then it will be okbut not really the best way to do it...huh? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Bryan Stevenson [mailto:bryan;electricedgesystems.com] Sent: Friday, November 15, 2002 4:15 PM To: CF-Talk Subject: Re: cookies / WDDX I'm doing just what you are right now. Follow these steps: 1) form is posted 2) create a new query using QueryNew() 3) add a row to the query using QueryAddRow() 4) add all the form data to the row in the query usingh QuerySetCell() 5) serialize the query into a WDDX packet using CFWDDX 6) set a cookie with the value of the WDDX packet using CFCOOKIE Then wherever you need the data. 1) deserialze the WDDX packet in the cookie 2) voila you have a query with all form data in it 3) do whatever ya need to to re-create your form as it was left HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 12:57 PM Subject: SOT: cookies / WDDX I'm trying to build some multi-part forms that are supposed to store all the form data in cookies, so people can leave bits unfinished, come back at a later date and finish the form off. The forms aren't *massive*, but they're not small either - not entirely sure how much data could be stored, but I'm trying to find out some limits to plan the project. It says in O'Reilly's JS Bible that web browsers don't store more than 20 cookies per domain and each cookie can't be more than 4 KB in size. Now, 4 KB is probably not enough to store ALL potential data - but 20 is not enough if I tried to store each *field* in a separate cookie. I've heard about WDDX being used to interact between CF and JS, but I've not used it before, and I can't think how it could overcome the above cookie limitations. I'd be grateful if anyone had any more info on cookie limitations, or ideas about how to handle this situation (without a DB!). Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
web service / cfc caching
I have a CFC/Web Service and no matter what I change it does not update. I deleted the reference in the cfadmin, the class files and restarted the CFMX server. What the heck is going on here! bd ~| 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
Re: cookies / WDDX
6) set a cookie with the value of the WDDX packet using CFCOOKIE I'm worried about cookie limitations. I'm having to replicate another form, which seems quite large (well, 22 smallish parts). Also, there's a system for attaching text reminders to each part, plus info to store on whether each part is completed or not. This is for one form - there'll be at least one more in the near future. How much can cookies handle?! I would plump for a datasource or session/client variables, but you know how it is, I've not been provided with information as to the set-up on the destination site (the bit I'm doing is a small part of a large site), and I'm finding it really difficult to contact any with info! Groan. Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| 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
Re: cookies / WDDX
Ah yes Tony...but a WDDX packet containing a query object is just a string ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 1:08 PM Subject: RE: cookies / WDDX complex data cannot be stored in a cookie. the best way to handle itclient variables, that are stored in a db or in the registry. I think you can store in the registry like you store in a db. either way, I solved the same problem you have by using a structure full of vars that are stored in session variables while the user is active, and in client variables, while the user is gone. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Gyrus [mailto:gyrus;rooted.freeuk.com] Sent: Friday, November 15, 2002 3:57 PM To: CF-Talk Subject: SOT: cookies / WDDX I'm trying to build some multi-part forms that are supposed to store all the form data in cookies, so people can leave bits unfinished, come back at a later date and finish the form off. The forms aren't *massive*, but they're not small either - not entirely sure how much data could be stored, but I'm trying to find out some limits to plan the project. It says in O'Reilly's JS Bible that web browsers don't store more than 20 cookies per domain and each cookie can't be more than 4 KB in size. Now, 4 KB is probably not enough to store ALL potential data - but 20 is not enough if I tried to store each *field* in a separate cookie. I've heard about WDDX being used to interact between CF and JS, but I've not used it before, and I can't think how it could overcome the above cookie limitations. I'd be grateful if anyone had any more info on cookie limitations, or ideas about how to handle this situation (without a DB!). Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: cookies / WDDX
cookie files have a limit of around 4K. No you can't put a complex var in a cookie (it's just a text file - you can only write a string to a text file) and yes, WDDX is just a string. Due to it's verbosity, if you're running CFMX I definitely recommend creating an XML packet and storing that in the cookie - not a WDDX packet. You're going to find that WDDX packets will become real big real fast and then you can't stuff them into cookies. Just a heads-up for you... have a good weekend ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Tony Weeg [mailto:tony;navtrak.net] Sent: Friday, 15 November, 2002 4:30 PM To: CF-Talk Subject: RE: cookies / WDDX bryan, I thought for sure I read that you couldn't store complex vars in a cookie.but I guess a wddx packet can really be percieved as a string, and if the length works, then it will be okbut not really the best way to do it...huh? .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Bryan Stevenson [mailto:bryan;electricedgesystems.com] Sent: Friday, November 15, 2002 4:15 PM To: CF-Talk Subject: Re: cookies / WDDX I'm doing just what you are right now. Follow these steps: 1) form is posted 2) create a new query using QueryNew() 3) add a row to the query using QueryAddRow() 4) add all the form data to the row in the query usingh QuerySetCell() 5) serialize the query into a WDDX packet using CFWDDX 6) set a cookie with the value of the WDDX packet using CFCOOKIE Then wherever you need the data. 1) deserialze the WDDX packet in the cookie 2) voila you have a query with all form data in it 3) do whatever ya need to to re-create your form as it was left HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 12:57 PM Subject: SOT: cookies / WDDX I'm trying to build some multi-part forms that are supposed to store all the form data in cookies, so people can leave bits unfinished, come back at a later date and finish the form off. The forms aren't *massive*, but they're not small either - not entirely sure how much data could be stored, but I'm trying to find out some limits to plan the project. It says in O'Reilly's JS Bible that web browsers don't store more than 20 cookies per domain and each cookie can't be more than 4 KB in size. Now, 4 KB is probably not enough to store ALL potential data - but 20 is not enough if I tried to store each *field* in a separate cookie. I've heard about WDDX being used to interact between CF and JS, but I've not used it before, and I can't think how it could overcome the above cookie limitations. I'd be grateful if anyone had any more info on cookie limitations, or ideas about how to handle this situation (without a DB!). Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| 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: cookies / WDDX
Actually Tony it works like a dream and allows me to avoid using SESSION vars keeping the system 100% scalable to a clustered environment if required. ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 1:29 PM Subject: RE: cookies / WDDX bryan, I thought for sure I read that you couldn't store complex vars in a cookie.but I guess a wddx packet can really be percieved as a string, and if the length works, then it will be okbut not really the best way to do it...huh? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Bryan Stevenson [mailto:bryan;electricedgesystems.com] Sent: Friday, November 15, 2002 4:15 PM To: CF-Talk Subject: Re: cookies / WDDX I'm doing just what you are right now. Follow these steps: 1) form is posted 2) create a new query using QueryNew() 3) add a row to the query using QueryAddRow() 4) add all the form data to the row in the query usingh QuerySetCell() 5) serialize the query into a WDDX packet using CFWDDX 6) set a cookie with the value of the WDDX packet using CFCOOKIE Then wherever you need the data. 1) deserialze the WDDX packet in the cookie 2) voila you have a query with all form data in it 3) do whatever ya need to to re-create your form as it was left HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 12:57 PM Subject: SOT: cookies / WDDX I'm trying to build some multi-part forms that are supposed to store all the form data in cookies, so people can leave bits unfinished, come back at a later date and finish the form off. The forms aren't *massive*, but they're not small either - not entirely sure how much data could be stored, but I'm trying to find out some limits to plan the project. It says in O'Reilly's JS Bible that web browsers don't store more than 20 cookies per domain and each cookie can't be more than 4 KB in size. Now, 4 KB is probably not enough to store ALL potential data - but 20 is not enough if I tried to store each *field* in a separate cookie. I've heard about WDDX being used to interact between CF and JS, but I've not used it before, and I can't think how it could overcome the above cookie limitations. I'd be grateful if anyone had any more info on cookie limitations, or ideas about how to handle this situation (without a DB!). Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: cookies / WDDX
Yes you do have to watch the upper cookie limits, but for what I'm doing (maintaining a 15 or so field reg form and the contents of a small shopping cart), it works great. You could have 1 cookie for each part of the form. Unless your forms are HUGE, I don't see a problem. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 1:34 PM Subject: Re: cookies / WDDX 6) set a cookie with the value of the WDDX packet using CFCOOKIE I'm worried about cookie limitations. I'm having to replicate another form, which seems quite large (well, 22 smallish parts). Also, there's a system for attaching text reminders to each part, plus info to store on whether each part is completed or not. This is for one form - there'll be at least one more in the near future. How much can cookies handle?! I would plump for a datasource or session/client variables, but you know how it is, I've not been provided with information as to the set-up on the destination site (the bit I'm doing is a small part of a large site), and I'm finding it really difficult to contact any with info! Groan. Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| 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: cookies / WDDX
Still on CF 5, but ya..if in CFMX I'd use XML for sure...thanks for the heads up Simon Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Simon Horwith [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 1:50 PM Subject: RE: cookies / WDDX cookie files have a limit of around 4K. No you can't put a complex var in a cookie (it's just a text file - you can only write a string to a text file) and yes, WDDX is just a string. Due to it's verbosity, if you're running CFMX I definitely recommend creating an XML packet and storing that in the cookie - not a WDDX packet. You're going to find that WDDX packets will become real big real fast and then you can't stuff them into cookies. Just a heads-up for you... have a good weekend ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Tony Weeg [mailto:tony;navtrak.net] Sent: Friday, 15 November, 2002 4:30 PM To: CF-Talk Subject: RE: cookies / WDDX bryan, I thought for sure I read that you couldn't store complex vars in a cookie.but I guess a wddx packet can really be percieved as a string, and if the length works, then it will be okbut not really the best way to do it...huh? .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Bryan Stevenson [mailto:bryan;electricedgesystems.com] Sent: Friday, November 15, 2002 4:15 PM To: CF-Talk Subject: Re: cookies / WDDX I'm doing just what you are right now. Follow these steps: 1) form is posted 2) create a new query using QueryNew() 3) add a row to the query using QueryAddRow() 4) add all the form data to the row in the query usingh QuerySetCell() 5) serialize the query into a WDDX packet using CFWDDX 6) set a cookie with the value of the WDDX packet using CFCOOKIE Then wherever you need the data. 1) deserialze the WDDX packet in the cookie 2) voila you have a query with all form data in it 3) do whatever ya need to to re-create your form as it was left HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 12:57 PM Subject: SOT: cookies / WDDX I'm trying to build some multi-part forms that are supposed to store all the form data in cookies, so people can leave bits unfinished, come back at a later date and finish the form off. The forms aren't *massive*, but they're not small either - not entirely sure how much data could be stored, but I'm trying to find out some limits to plan the project. It says in O'Reilly's JS Bible that web browsers don't store more than 20 cookies per domain and each cookie can't be more than 4 KB in size. Now, 4 KB is probably not enough to store ALL potential data - but 20 is not enough if I tried to store each *field* in a separate cookie. I've heard about WDDX being used to interact between CF and JS, but I've not used it before, and I can't think how it could overcome the above cookie limitations. I'd be grateful if anyone had any more info on cookie limitations, or ideas about how to handle this situation (without a DB!). Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| 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: cookies / WDDX
How are you going to test byte length before adding it to the cookie? Come on, every way you cut it a cookie solutions is a bad idea. One character too many and the cookie is corrupted. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Simon Horwith [mailto:shorwith;figleaf.com] Sent: Friday, November 15, 2002 4:51 PM To: CF-Talk Subject: RE: cookies / WDDX cookie files have a limit of around 4K. No you can't put a complex var in a cookie (it's just a text file - you can only write a string to a text file) and yes, WDDX is just a string. Due to it's verbosity, if you're running CFMX I definitely recommend creating an XML packet and storing that in the cookie - not a WDDX packet. You're going to find that WDDX packets will become real big real fast and then you can't stuff them into cookies. Just a heads-up for you... have a good weekend ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Tony Weeg [mailto:tony;navtrak.net] Sent: Friday, 15 November, 2002 4:30 PM To: CF-Talk Subject: RE: cookies / WDDX bryan, I thought for sure I read that you couldn't store complex vars in a cookie.but I guess a wddx packet can really be percieved as a string, and if the length works, then it will be okbut not really the best way to do it...huh? tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Bryan Stevenson [mailto:bryan;electricedgesystems.com] Sent: Friday, November 15, 2002 4:15 PM To: CF-Talk Subject: Re: cookies / WDDX I'm doing just what you are right now. Follow these steps: 1) form is posted 2) create a new query using QueryNew() 3) add a row to the query using QueryAddRow() 4) add all the form data to the row in the query usingh QuerySetCell() 5) serialize the query into a WDDX packet using CFWDDX 6) set a cookie with the value of the WDDX packet using CFCOOKIE Then wherever you need the data. 1) deserialze the WDDX packet in the cookie 2) voila you have a query with all form data in it 3) do whatever ya need to to re-create your form as it was left HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 12:57 PM Subject: SOT: cookies / WDDX I'm trying to build some multi-part forms that are supposed to store all the form data in cookies, so people can leave bits unfinished, come back at a later date and finish the form off. The forms aren't *massive*, but they're not small either - not entirely sure how much data could be stored, but I'm trying to find out some limits to plan the project. It says in O'Reilly's JS Bible that web browsers don't store more than 20 cookies per domain and each cookie can't be more than 4 KB in size. Now, 4 KB is probably not enough to store ALL potential data - but 20 is not enough if I tried to store each *field* in a separate cookie. I've heard about WDDX being used to interact between CF and JS, but I've not used it before, and I can't think how it could overcome the above cookie limitations. I'd be grateful if anyone had any more info on cookie limitations, or ideas about how to handle this situation (without a DB!). Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| 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
RE: cookies / WDDX
Gyrus, Don't put it in a cookie. If you corrupt a user's cookie, they will hate you forever. Every time they come back, the server will see it exists, but it won't be able to get any data out of it. Which really sucks. You really don't want to have to post detailed instructions on how to delete a cookie either. The database CLIENT/SESSION variables are the best way to do it. However, if you are coding blind, maybe you can just create some temporary XML files, and store them on the server. It's not going to be as responsive as the database, but it shouldn't be too bad. Good luck. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Gyrus [mailto:gyrus;rooted.freeuk.com] Sent: Friday, November 15, 2002 4:34 PM To: CF-Talk Subject: Re: cookies / WDDX 6) set a cookie with the value of the WDDX packet using CFCOOKIE I'm worried about cookie limitations. I'm having to replicate another form, which seems quite large (well, 22 smallish parts). Also, there's a system for attaching text reminders to each part, plus info to store on whether each part is completed or not. This is for one form - there'll be at least one more in the near future. How much can cookies handle?! I would plump for a datasource or session/client variables, but you know how it is, I've not been provided with information as to the set-up on the destination site (the bit I'm doing is a small part of a large site), and I'm finding it really difficult to contact any with info! Groan. Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| 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: [OT] Zip Code Lookup
charlie griefer wrote: I'm building an application where i need to do the 'search within x miles of zip code 12345' Can anybody make a recommendation? The client would like something that offers updates fairly regularly. Maybe even some sort of XML feed direct from the (a) source? Any leads would be greatly appreciated. Oh, and would be nice if it integrated easily with CF (to kinda bring this question a little bit on topic) :) Strategy and options depends quite a bit on the usage pattern and the financial room. I will just presume it is for nearest outlet matching for now. If it is for the occasional lookup, I am sure there are webservices where you can pay per hit. Easy and all the database maintenance is done for you by the remote partner. But it might be a bit clumsy if you get back a long list of ZIP codes that you then have to match against your own database of outlets. And if you get a lot of hits, paying per hit might not be the best model. Another option would be to buy a ZIP database with subscriptions for updates and a bunch of tags for running queries on them. But again, it might be a bit clumsy if you want to match those results with another database of outlets. The last option is to buy the ZIP database and built your own search system for it. It really isn't that hard to make the database do distance calculations based on lat/lon pairs, and unless you have a very special set of datapoints using a smart algorithm and some indexing will make it very fast, especially since you can do the outlet matching in the database as well. I would probably go for option 3, unless there is a business reason for doing number 1. Let me know if you want some code for option 3. Jochem ~| 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
OT: Serverwide SSL's
Does anyone have any experience with server wide SSL's? We have one client, who is going to be bringing up 15 or so domains to this server, and I am thinking that a globabl cert may be cheaper... I thought I had seen something about a global server certificate on Verisign or Thawte's site once, but the information I am finding is sparse or may be old. Anyone have any pointers? -- jon mailto:jonhall;ozline.net ~| 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
Re: cookies / WDDX
Yes but my upper limits are well below the cookie upper limits ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Adrocknaphobia Jones [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 1:58 PM Subject: RE: cookies / WDDX How are you going to test byte length before adding it to the cookie? Come on, every way you cut it a cookie solutions is a bad idea. One character too many and the cookie is corrupted. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Simon Horwith [mailto:shorwith;figleaf.com] Sent: Friday, November 15, 2002 4:51 PM To: CF-Talk Subject: RE: cookies / WDDX cookie files have a limit of around 4K. No you can't put a complex var in a cookie (it's just a text file - you can only write a string to a text file) and yes, WDDX is just a string. Due to it's verbosity, if you're running CFMX I definitely recommend creating an XML packet and storing that in the cookie - not a WDDX packet. You're going to find that WDDX packets will become real big real fast and then you can't stuff them into cookies. Just a heads-up for you... have a good weekend ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Tony Weeg [mailto:tony;navtrak.net] Sent: Friday, 15 November, 2002 4:30 PM To: CF-Talk Subject: RE: cookies / WDDX bryan, I thought for sure I read that you couldn't store complex vars in a cookie.but I guess a wddx packet can really be percieved as a string, and if the length works, then it will be okbut not really the best way to do it...huh? tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Bryan Stevenson [mailto:bryan;electricedgesystems.com] Sent: Friday, November 15, 2002 4:15 PM To: CF-Talk Subject: Re: cookies / WDDX I'm doing just what you are right now. Follow these steps: 1) form is posted 2) create a new query using QueryNew() 3) add a row to the query using QueryAddRow() 4) add all the form data to the row in the query usingh QuerySetCell() 5) serialize the query into a WDDX packet using CFWDDX 6) set a cookie with the value of the WDDX packet using CFCOOKIE Then wherever you need the data. 1) deserialze the WDDX packet in the cookie 2) voila you have a query with all form data in it 3) do whatever ya need to to re-create your form as it was left HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 12:57 PM Subject: SOT: cookies / WDDX I'm trying to build some multi-part forms that are supposed to store all the form data in cookies, so people can leave bits unfinished, come back at a later date and finish the form off. The forms aren't *massive*, but they're not small either - not entirely sure how much data could be stored, but I'm trying to find out some limits to plan the project. It says in O'Reilly's JS Bible that web browsers don't store more than 20 cookies per domain and each cookie can't be more than 4 KB in size. Now, 4 KB is probably not enough to store ALL potential data - but 20 is not enough if I tried to store each *field* in a separate cookie. I've heard about WDDX being used to interact between CF and JS, but I've not used it before, and I can't think how it could overcome the above cookie limitations. I'd be grateful if anyone had any more info on cookie limitations, or ideas about how to handle this situation (without a DB!). Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:
Re: cookies / WDDX
The database CLIENT/SESSION variables are the best way to do it. However, if you are coding blind, maybe you can just create some temporary XML files, and store them on the server. It's not going to be as responsive as the database, but it shouldn't be too bad. Ah, but I don't know if CFFILE is running... Or what version of CF it is! So much for me swearing a while ago that I'd never start a job again without this sort of info and a signed-off scope doc :-| But this is a sub-contract for someone I know, and he knows his stuff. Well, maybe not as well as I thought... Many thanks for the advice - thoughts still welcome, but it does look like I'm in quandary with this one. I'll just plough ahead with all the HTML I can do until I can get word on this from the horse's mouth. Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| 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
web services and included templates
I don't know if this is by design, or if I'm doing something wrong, but when calling a CFC/Web Service that has an included file, the arguments scope is not available to the included template. I tested this with a standard call to a component and it worked fine, the arguments scope IS available to included templates. Does any one know if this is by design? \Brook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: cookies / WDDX
I didn't mention this, but it's a non-persistent cookie and is gone when the browser is closed. So no need to worry about corrupting a cookie and it still being there next time the user logs in ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Adrocknaphobia Jones [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 15, 2002 1:58 PM Subject: RE: cookies / WDDX Gyrus, Don't put it in a cookie. If you corrupt a user's cookie, they will hate you forever. Every time they come back, the server will see it exists, but it won't be able to get any data out of it. Which really sucks. You really don't want to have to post detailed instructions on how to delete a cookie either. The database CLIENT/SESSION variables are the best way to do it. However, if you are coding blind, maybe you can just create some temporary XML files, and store them on the server. It's not going to be as responsive as the database, but it shouldn't be too bad. Good luck. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Gyrus [mailto:gyrus;rooted.freeuk.com] Sent: Friday, November 15, 2002 4:34 PM To: CF-Talk Subject: Re: cookies / WDDX 6) set a cookie with the value of the WDDX packet using CFCOOKIE I'm worried about cookie limitations. I'm having to replicate another form, which seems quite large (well, 22 smallish parts). Also, there's a system for attaching text reminders to each part, plus info to store on whether each part is completed or not. This is for one form - there'll be at least one more in the near future. How much can cookies handle?! I would plump for a datasource or session/client variables, but you know how it is, I've not been provided with information as to the set-up on the destination site (the bit I'm doing is a small part of a large site), and I'm finding it really difficult to contact any with info! Groan. Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Dynamically Build CFHTTP Param Tags?
Duh. I can't believe I didn't try that. I just assumed you couldn't loop over a CF tag to be included inside CFHTTP. That's what I get for assuming huh? LOL, thanks everyone. Joshua Miller [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:info;turnkey.to] Sent: Friday, November 15, 2002 2:58 PM To: CF-Talk Subject: RE: Dynamically Build CFHTTP Param Tags? CFLOOP INDEX=Field LIST=#FORM.FieldNames# CFHTTPPARAM TYPE=FormField NAME=#FORM['Field']# VALUE=#FORM[Field]# /CFLOOP Almost... CFLOOP INDEX=Field LIST=#FORM.FieldNames# CFHTTPPARAM TYPE=FormField NAME=#Field# VALUE=#FORM[Field]# /CFLOOP Just a typo, I know. :) Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Joshua Miller [mailto:josh;joshuasmiller.com] Sent: Friday, November 15, 2002 2:07 PM To: CF-Talk Subject: RE: Dynamically Build CFHTTP Param Tags? That would work, but I don't know the names of the form fields coming in. I'm using CFHTTP to generate reports in different mime-types. Each report has a template for each mime-type and each report has different data, what I'm wanting to do is build one template that handles retrieving the template, saving the content as a variable then writing the file in the appropriate mime type and returning a response to the user. It's working thus far with URL parameters, but a couple of the forms have too many fields to pass on the URL string - IE returned an error that the query string was too long, so I have to use POST. To use POST I need CFPARAM tags and thus my problem. I think I'll do it with INCLUDE files instead of CFHTTP, although I wanted the ability to query remote templates on other servers - guess that's not going to happen just yet. Joshua Miller [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:info;turnkey.to] Sent: Friday, November 15, 2002 12:09 PM To: CF-Talk Subject: Re: Dynamically Build CFHTTP Param Tags? Is there a way to dynamically generate CFHTTP Param tags for a CFHTTP call? I need to pass form fields through a CFHTTP call, but there may be different fields for each submission ... is there a way to do this? Thanks, Joshua Miller [EMAIL PROTECTED] I'd expect you should be able to use cfif inside your cfhttp call... cfhttp cfif ... cfhttpparam ... /cfif /cfhttp Does this not work? S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| 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.
Follow Up: web services and included templates
An easy way around this is to dump the arguments struct into the variables or request scope, which IS available to the calling template. Note, I received errors when I tried to copy a var from the argument scope to the local scope like this: cfset var MyID=arguments.campaignID But doing this works: cfset variables=duplicate(arguments) Brook ~| 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