RE: Internet Slow???
Yeah, isn't MSDE part of OfficeXP also? I thought it was making use of the Desktop Engine for storage now ... that's a pretty wide-ranging user base. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 1:24 AM To: CF-Talk Subject: Re: Internet Slow??? > SQL WORM is likely the culprit. There will inevitably be a few days of > sluggishness while the slower folks apply the patches :) yes but considering that MSDE is also effected and its embedded in several things like visio, it could be a long long while. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Paging
I wrote a custom tag some time back to handle this sort of thing ... I cut out the necessary code for what you're looking for and pasted it below so you can create a "lite" version of the tag. If you have any more questions let me know, I'd be glad to help you implement this. Take the code at the bottom of this message and copy into a file called NEXTX.cfm Then do this: SELECT * FROM tblName ... Your output here ... BEGIN CUSTOM TAG BELOW ...
RE: ColdFusion and Javascript - pushing browser windows
Yeah, I'd like to see how you handle that. That same type of thing is on the radar for our Support Staff and guess who will get to create it :) Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 2:52 AM To: CF-Talk Subject: Re: ColdFusion and Javascript - pushing browser windows I agree - I already was toying around with a "toolbar" type look and interface - trying to get fancy - but it will grow and expand depending on if there is data there or not - it stays open as a communication tool until the user closes it - so if the admin needs to push back 3 urls after a few minutes it simply explands the window - accomadates the URL and user can close it and the "toolbar" will shrink back. I will be sure to share the URL when it's developed enough. Thanks! jay Joshua Miller wrote: >Actually I think the idea is that the hidden frame does nothing but >look for data and then make the OTHER large browser frame do all the >work. Cookies, sessions, etc. should be intact because all you'd be >doing is something like: >parent.frame.document.location.href="#pushed_url#" so if it was in the >same site the cookies, sessions, etc would still be there just like >clicking any other link. I wouldn't see any need to popup in a new >window. If you don't want to make a site-wide hidden frame, then just >popup a small window that says "Retrieving Data" or something and then >when it finds what you're after have it change the calling page >(opener.document.location.href="#pushed_url#") to the URL in question >and then close the remote (self.close() or window.close()) and all is >good. Alternatively you could make a small data collection frame appear >when they click the "Help" button that would perform all the actions >from that point on. Make it look like a toolbar or something with a >close button so they could get rid of it when they want to. > >There are probably a hundred ways it could be done to avoid using a >hidden frame across the entire site. I wouldn't want to do that either. > >Good luck! > >Joshua Miller >Head Programmer / IT Manager >Garrison Enterprises Inc. >www.garrisonenterprises.net [EMAIL PROTECTED] >(704) 569-9044 ext. 254 > >*** >* >* >Any views expressed in this message are those of the individual sender, >except where the sender states them to be the views of >Garrison Enterprises Inc. > >This e-mail is intended only for the individual or entity to which it >is addressed and contains information that is private and confidential. >If you are not the intended recipient you are hereby notified that any >dissemination, distribution or copying is strictly prohibited. If you >have received this e-mail in error please delete it immediately and >advise us by return e-mail to [EMAIL PROTECTED] >*** >* >* > > >-Original Message- >From: Jason Miller [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, January 29, 2003 11:45 PM >To: CF-Talk >Subject: Re: ColdFusion and Javascript - pushing browser windows > > >Between you and Joshua - I think you gave some good ideas - not how I >intended it to work - but definately a way to make it work. > >With a little js and css - If a page comes back to this invisible frame >-I could have it resize so they can see what I am sending - while not >losing their page - The only issue I guess I will have to overcome is >how my cookies will act - I will have to set a new function to read >and get their cookie and cart info - so that anything clicked on from >the "pushed" page will be recorded properly into their cart. > >The only thing is - I definately am a bit reserved in having to >implement an invisible frame - especially site wide. Thanks though - >gave me some interesting solutions guys! jay > >Scott Weikert wrote: > > >Well this is something I hatched in my brain in about ten seconds, so >it > > >may need some work. > > > >One thing you can do is set up, if you're able (i.e.
Re: Internet Slow???
> SQL WORM is likely the culprit. There will inevitably be a few days of > sluggishness while the slower folks apply the patches :) yes but considering that MSDE is also effected and its embedded in several things like visio, it could be a long long while. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Internet Slow???
SQL WORM is likely the culprit. There will inevitably be a few days of sluggishness while the slower folks apply the patches :) Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Pablo Varando [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 11:36 PM To: CF-Talk Subject: Re: Internet Slow??? I've been experiencing slowness for about 3 days now not sure what's going on.. but been experiencing slowness and drop-off with the cable connection... Pablo - Original Message - From: "Andy Ousterhout" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 10:03 PM Subject: Internet Slow??? > The internet has seemed awful slow today. Are others experiencing the same > issue or just me? > > Andy > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Paging
1. I'd like to display one result per page 2. I'd like to display the proper recordCount and currentRow 3. I'd like to understand how to have my previous and next point to the previous record and next record, respectively, taking into account that if it's BOF or EOF that the link is no longer active or is referencing a dead anchor. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 11:48 PM > To: CF-Talk > Subject: RE: Paging > > > What exactly are you looking for??? > > Christian > > -Original Message- > From: Russ [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 11:26 PM > To: CF-Talk > Subject: Paging > > > All, > > I know this has been posted before--in fact I checked the > archives and found > an answer to an older question, but it's utilizing a few > things that I'm not > too familiar with. > > I've got a page at > http://12.251.119.254/ricsoens/imagery2.cfm?collectionID=1 > > If you're looking at it, you can tell that I'm displaying > both of the test > images in this collection. I don't want to do that; I just > want to display > one, display the record number I'm on out of the total number > of records > associated, and then apply appropriate next and previous URLs (while > accounting for EOF and BOF). > > In theory, I think I understand HOW to do it, I just need > some assistance > with how to implement. Anyone up late enough to throw me a bone? > > Thanks! > > Russ UngerAIM: Roughy > Managing Partner > blueChrome design, LLC > www.bluechromedesign.com > 312.593.4260 :office > 877.433.8427 :pager > 312.873.4033 :fax > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: QUERY Help
You may have to put Select Max(ThreadID) AS Tid...I didn't put in the as. or Since you are using CF, you can do the same thing, just in two steps... Select Max(ThreadID) as Tid From Threads Group By TicketID SELECT Th.sentBy,T.ticketID,T.subject FROM Tickets as T INNER JOIN Threads as Th ON T.ticketID = Th.ticketID Where TH.ThreadID in (#QuotedValueList(GetThreads.Tid)#) ORDER BY T.priority desc, T.ticketID Let me know if you this does it for you, or if it was just the "AS". -Original Message- From: Cedric Villat [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 09:20 PM To: CF-Talk Subject: Re: QUERY Help Thanks for the help, but I'm getting an error. [MySQL][ODBC 3.51 Driver][mysqld-3.23.49-log]You have an error in your SQL syntax near 'SELECT Max(threadID) AS threadID FROM Threads GROUP BY TicketID)' at line 4 As you can see, I'm using MySQL. Does this mean it doesn't suooprt Query of Queries? Any other ideas? Cedric - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 6:39 PM Subject: RE: QUERY Help > This got cut out...sorry! > > SELECT Th.sentBy,T.ticketID,T.subject > FROM Tickets T INNER JOIN Threads Th > ON T.ticketID = Th.ticketID > Where TH.ThreadID in (Select Max(ThreadID) Tid > From Threads > Group By TicketID) > ORDER BY T.priority desc, T.ticketID > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 08:35 PM > To: CF-Talk > Subject: RE: QUERY Help > > > Why are you doing a max on the sentby table as well? > You also may try doing an inner join as well. > Also, If subject and priority could be different, you may want to get > rid of > them otherwise you are not going to get what you want. > > The easiest for this may be another approach if you must have those > other fields (which I can totally understand), try this: > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
HELP with Authorize.net - SIM or AIM?? Safeset?
Soon authorize.net will end the weblink connect to their gateway Anyone attempted this migration yet? What is the best method? I know that cf_authorize now uses AIM but requires you to have your username and password reside on the server, while there is cfx_sim_fingerprint that calculates only the fingerprint, but would require another tag to impliment. The tag itself is encripted with your user name and password. I am up for suggestions, help and any other information that I can get from anyone about this. I just signed on to authorize.net and figure instead of implimenting weblink I would program for their new accepted methods.. Thanks, Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Paging
What exactly are you looking for??? Christian -Original Message- From: Russ [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 11:26 PM To: CF-Talk Subject: Paging All, I know this has been posted before--in fact I checked the archives and found an answer to an older question, but it's utilizing a few things that I'm not too familiar with. I've got a page at http://12.251.119.254/ricsoens/imagery2.cfm?collectionID=1 If you're looking at it, you can tell that I'm displaying both of the test images in this collection. I don't want to do that; I just want to display one, display the record number I'm on out of the total number of records associated, and then apply appropriate next and previous URLs (while accounting for EOF and BOF). In theory, I think I understand HOW to do it, I just need some assistance with how to implement. Anyone up late enough to throw me a bone? Thanks! Russ UngerAIM: Roughy Managing Partner blueChrome design, LLC www.bluechromedesign.com 312.593.4260 :office 877.433.8427 :pager 312.873.4033 :fax ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Paging
All, I know this has been posted before--in fact I checked the archives and found an answer to an older question, but it's utilizing a few things that I'm not too familiar with. I've got a page at http://12.251.119.254/ricsoens/imagery2.cfm?collectionID=1 If you're looking at it, you can tell that I'm displaying both of the test images in this collection. I don't want to do that; I just want to display one, display the record number I'm on out of the total number of records associated, and then apply appropriate next and previous URLs (while accounting for EOF and BOF). In theory, I think I understand HOW to do it, I just need some assistance with how to implement. Anyone up late enough to throw me a bone? Thanks! Russ UngerAIM: Roughy Managing Partner blueChrome design, LLC www.bluechromedesign.com 312.593.4260 :office 877.433.8427 :pager 312.873.4033 :fax ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How do I access Functions that I've written???
This is an interesting technique for using ColdFusion tags (indirectly) in cfscript: http://www.macromedia.com/desdev/mx/coldfusion/extreme/ cftags_cfscript.html The article is written by Kevin Towes. Christian On Wednesday, January 29, 2003, at 07:20 PM, Matthew Walker wrote: > If you are using CFMX you can use the tag which lets you > used regular CF tags, otherwise no. > > Also, check out cflib.org . > >> -Original Message- >> From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, 30 January 2003 1:17 p.m. >> To: CF-Talk >> Subject: RE: How do I access Functions that I've written??? >> >> >> Thanks. >> >> Can you have other then CFSCript commands in a function? >> >> -Original Message- >> From: Barney Boisvert [mailto:[EMAIL PROTECTED]] >> Sent: Wednesday, January 29, 2003 6:09 PM >> To: CF-Talk >> Subject: RE: How do I access Functions that I've written??? >> >> >> 1) You can have multiple functions in the same file. >> >> 2) To access a function, it must be defined in the same file >> that you want >> to use it in, OR be CFINCLUDEd before you use it. Obviously >> you don't have >> to include the function directly into the file you want to >> use it in, so if >> you have a template like this: >> >> >> >> >> You'll be able to use any functions defined in 'myfunc.cfm' within >> 'other.cfm'. Just make sure the function files are incldued >> before you try >> to use them and you'll be set. >> >> Application.cfm can be a good place to include functions that >> are used in a >> lot of templates, just keep in mind that every function you >> include has to >> be parsed and compiled by CF every request, even if it's not >> used. CFMX >> doesn't have that problem, because it precompiles, but you >> said you were on >> CF5, so it's worth mentioning. >> >> barneyb >> >>> -Original Message- >>> From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] >>> Sent: Wednesday, January 29, 2003 3:59 PM >>> To: CF-Talk >>> Subject: How do I access Functions that I've written??? >>> >>> >>> Ok, really rookie question. I have no clue how to use >> functions. Could >>> someone take a second and either point me to the reading or >> answer the >>> following 2 questions: >>> >>> 1. Can I save multiple functions in a single file? >>> >>> >>> 2. How do I set up the CF5.0 server so that functions are found? >>> >>> >>> Thanks, >>> Andy >>> >>> >>> >> >> > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion and Javascript - pushing browser windows
I agree - I already was toying around with a "toolbar" type look and interface - trying to get fancy - but it will grow and expand depending on if there is data there or not - it stays open as a communication tool until the user closes it - so if the admin needs to push back 3 urls after a few minutes it simply explands the window - accomadates the URL and user can close it and the "toolbar" will shrink back. I will be sure to share the URL when it's developed enough. Thanks! jay Joshua Miller wrote: >Actually I think the idea is that the hidden frame does nothing but look >for data and then make the OTHER large browser frame do all the work. >Cookies, sessions, etc. should be intact because all you'd be doing is >something like: parent.frame.document.location.href="#pushed_url#" so if >it was in the same site the cookies, sessions, etc would still be there >just like clicking any other link. I wouldn't see any need to popup in a >new window. If you don't want to make a site-wide hidden frame, then >just popup a small window that says "Retrieving Data" or something and >then when it finds what you're after have it change the calling page >(opener.document.location.href="#pushed_url#") to the URL in question >and then close the remote (self.close() or window.close()) and all is >good. Alternatively you could make a small data collection frame appear >when they click the "Help" button that would perform all the actions >from that point on. Make it look like a toolbar or something with a >close button so they could get rid of it when they want to. > >There are probably a hundred ways it could be done to avoid using a >hidden frame across the entire site. I wouldn't want to do that either. > >Good luck! > >Joshua Miller >Head Programmer / IT Manager >Garrison Enterprises Inc. >www.garrisonenterprises.net >[EMAIL PROTECTED] >(704) 569-9044 ext. 254 > > >* >Any views expressed in this message are those of the individual sender, >except where the sender states them to be the views of >Garrison Enterprises Inc. > >This e-mail is intended only for the individual or entity to which it is >addressed and contains information that is private and confidential. If >you are not the intended recipient you are hereby notified that any >dissemination, distribution or copying is strictly prohibited. If you >have received this e-mail in error please delete it immediately and >advise us by return e-mail to [EMAIL PROTECTED] > >* > > >-Original Message- >From: Jason Miller [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, January 29, 2003 11:45 PM >To: CF-Talk >Subject: Re: ColdFusion and Javascript - pushing browser windows > > >Between you and Joshua - I think you gave some good ideas - not how I >intended it to work - but definately a way to make it work. > >With a little js and css - If a page comes back to this invisible frame >-I could have it resize so they can see what I am sending - while not >losing their page - The only issue I guess I will have to overcome is >how my cookies will act - I will have to set a new function to read and >get their cookie and cart info - so that anything clicked on from the >"pushed" page will be recorded properly into their cart. > >The only thing is - I definately am a bit reserved in having to >implement an invisible frame - especially site wide. Thanks though - >gave me some interesting solutions guys! jay > >Scott Weikert wrote: > > >Well this is something I hatched in my brain in about ten seconds, so it > > >may need some work. > > > >One thing you can do is set up, if you're able (i.e. no proclamations >about > >being frameless) an "invisible frame" - i.e. you do 'rows="100%,*"'. Put > > >your main content in the visible frame, and set up the second, invisible > > >frame, to be on a timed refresh. > > > >When a user can't find something, and clicks the "send a 'help!' to the > >admin" button, you store the particulars of that request in your >database. > >Tag it with some identifier for the user - i.e. some UUID that you store >in > >a cookie, IP number, whatever. > > > >Admin does his surfing, and updates the database record with the proper >link. > > > >Remember the second, invisible frame, with the page that's refreshing >from > >time to time? That page always looks in the database for a record with >the > >user's identifier, AND that has an admin-supplied solution. If it finds > >one, then it executes a JS popup that displays the info the admin >supplied, > >in whatever form. > > > >Maybe set up this page to autorefresh every minute. If it finds nothing >(no > >requests for help that have been answered), this page should execute > >super-super-fast and not be a burden on your server/bandwidth. > > > >At 05:50 PM 1/29/2003 -0800, you wrote: > > > >Okay - to clarify push - > >I think ex
Re: Struct Sort
I'll pass this along to the documentation folks. Christian On Wednesday, January 29, 2003, at 05:14 PM, Barney Boisvert wrote: > I've used that exact code for getting an ordered list of keys, but the > first > comment user comment says structKeyList() doesn't return in insert > order, > and I agree. Running this code (linux/apache/cfmx) results in '1,2' > being > displayed. Reversing the structInsert calls has no effect. > > > > s = structNew(); > structInsert(s, "2", ""); > structInsert(s, "1", ""); > > #structKeyList(s)# > > > >> -Original Message- >> From: Dave Carabetta [mailto:[EMAIL PROTECTED]] >> Sent: Wednesday, January 29, 2003 2:05 PM >> To: CF-Talk >> Subject: RE: Struct Sort >> >> >>> Where does it say that struct keys are returned in insertion order? >>> The >>> docs for structKeyList() and structKeyArray() say they are unordered. >> >> In the LiveDocs on MM's site under Migrate ColdFusion 5 >> Applications, if you >> scroll to the very bottom, you'll see that StructKeyList() now >> returns the >> keys in the order that they are created. Also, if you scroll down >> and read >> the user comments on that particular page, you'll see a bit of >> code to loop >> over the key alphabetically. Here's the link to the page: >> >> http://livedocs.macromedia.com/cfmxdocs/Migrating_ColdFusion_5_App > lications/cf_migration_guide7.jsp#1201936 >> >> Regards, >> Dave. > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.449 / Virus Database: 251 - Release Date: 1/27/2003 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFFlush error
This is an intranet system and JS is always on, so we will try that. Thanks! Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 9:26 PM To: CF-Talk Subject: Re: CFFlush error > A long running page (5 seconds) has a little processing banner going > on, and when done, bam goes to next page automatically appending a > specific number to the url string. That is the requirement...and so > this cfflush, cflocate cannot work...I have tried with cfheader as > well. > > We see these kind of things on travel sites...does anyone have any > examples, lessons in CF that work in this manner, or are we missing > something? The problem you're running into is that when you use , you flush out the HTML headers with the data, so they're no longer available after it's first called. Since is just CF manually changing the HTML header information to point to the template specified in the "url" attribute, and the HTML headers have already been sent back to the browser, you're seeing your error because the headers don't exist to CF anymore. One suggestion would be to use JavaScript at the bottom of the template to redirect the user instead of . This is what I think Orbitz and other sites use (though they might also user server-side redirects, which is available in other languages like ASP and JSP -- and CFMX). Since you're not modifying HTML headers, you can continue to use and in the same template. Here's a sample of the JS you would use: document.location.href = 'temple_to_redirect_to.cfm'; Alternatively, you can link the calling page to your waiting page, and then use an onLoad() command in the body tag of the waiting page to call the processing template. This way you can display a waiting page for your user while the processing takes place in the background. You'll note that both of these suggestions rely on the use of JavaScript, so if users don't have JS enabled, these would not be viable options. Regards, Dave. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: XML and CF
I'm currently finishing up a set of custom XML tags for CF 5.0. These are specifically designed for reading and writing queries to and from xml for CF 5. Wile we all know these tools already exist in CFMX, but sometimes you have to work with what you have. If anyone has use for these, email me directly for copies of the source. Trey Rouse Data Application Architect Rice University > -Original Message- > From: Owens, Howard [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 06, 2003 5:37 PM > To: CF-Talk > Subject: RE: XML and CF > > Too bad ... it's a great little tool. > > H. > > > > -Original Message- > > From: Robert Bailey [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, January 06, 2003 2:58 PM > > To: CF-Talk > > Subject:RE: XML and CF > > > > They no longer develop or support SoXML, tried to DL it from their page > > > > > > Robert Bailey > > > > > > > > -Original Message- > > From: Owens, Howard [mailto:[EMAIL PROTECTED]] > > Sent: Monday, January 06, 2003 2:50 PM > > To: CF-Talk > > Subject: RE: XML and CF > > > > http://www.torchbox.com/xml/ > > > > Also, check out the cf_soxml tag in the tag gallery. > > > > H. > > > > > > > -Original Message- > > > From: Robert Bailey [SMTP:[EMAIL PROTECTED]] > > > Sent: Monday, January 06, 2003 2:22 PM > > > To: CF-Talk > > > Subject: XML and CF > > > > > > Anyone know any good sites or articles dealing with XML and CF? > > > > > > Robert Bailey > > > [EMAIL PROTECTED] > > > "Famous for nothing!" > > > http://www.tinetics.com > > > > > > > > > --- > > > [This E-mail scanned for viruses] > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Internet Slow???
I've been experiencing slowness for about 3 days now not sure what's going on.. but been experiencing slowness and drop-off with the cable connection... Pablo - Original Message - From: "Andy Ousterhout" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 10:03 PM Subject: Internet Slow??? > The internet has seemed awful slow today. Are others experiencing the same > issue or just me? > > Andy > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion and Javascript - pushing browser windows
Actually I think the idea is that the hidden frame does nothing but look for data and then make the OTHER large browser frame do all the work. Cookies, sessions, etc. should be intact because all you'd be doing is something like: parent.frame.document.location.href="#pushed_url#" so if it was in the same site the cookies, sessions, etc would still be there just like clicking any other link. I wouldn't see any need to popup in a new window. If you don't want to make a site-wide hidden frame, then just popup a small window that says "Retrieving Data" or something and then when it finds what you're after have it change the calling page (opener.document.location.href="#pushed_url#") to the URL in question and then close the remote (self.close() or window.close()) and all is good. Alternatively you could make a small data collection frame appear when they click the "Help" button that would perform all the actions from that point on. Make it look like a toolbar or something with a close button so they could get rid of it when they want to. There are probably a hundred ways it could be done to avoid using a hidden frame across the entire site. I wouldn't want to do that either. Good luck! Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 11:45 PM To: CF-Talk Subject: Re: ColdFusion and Javascript - pushing browser windows Between you and Joshua - I think you gave some good ideas - not how I intended it to work - but definately a way to make it work. With a little js and css - If a page comes back to this invisible frame -I could have it resize so they can see what I am sending - while not losing their page - The only issue I guess I will have to overcome is how my cookies will act - I will have to set a new function to read and get their cookie and cart info - so that anything clicked on from the "pushed" page will be recorded properly into their cart. The only thing is - I definately am a bit reserved in having to implement an invisible frame - especially site wide. Thanks though - gave me some interesting solutions guys! jay Scott Weikert wrote: Well this is something I hatched in my brain in about ten seconds, so it may need some work. One thing you can do is set up, if you're able (i.e. no proclamations about being frameless) an "invisible frame" - i.e. you do 'rows="100%,*"'. Put your main content in the visible frame, and set up the second, invisible frame, to be on a timed refresh. When a user can't find something, and clicks the "send a 'help!' to the admin" button, you store the particulars of that request in your database. Tag it with some identifier for the user - i.e. some UUID that you store in a cookie, IP number, whatever. Admin does his surfing, and updates the database record with the proper link. Remember the second, invisible frame, with the page that's refreshing from time to time? That page always looks in the database for a record with the user's identifier, AND that has an admin-supplied solution. If it finds one, then it executes a JS popup that displays the info the admin supplied, in whatever form. Maybe set up this page to autorefresh every minute. If it finds nothing (no requests for help that have been answered), this page should execute super-super-fast and not be a burden on your server/bandwidth. At 05:50 PM 1/29/2003 -0800, you wrote: Okay - to clarify push - I think explanation of the scenario is best - 1) User can't find a product or a piece of information on a large website - 2) User clicks a button and sends a request to the Administrator - ( a whole que or dynamic page would be setup to handle these requests and post multiple ones) 3) Administrator surfs around - finds the piece of information And pushes it back to user. 4) On users computer in the originating browser window - or maybe frame -the file loads up. IN fact thinking it would have to be frames based. ~| Archives: http://www.houseoffusion.com/cf_lists/index.
Internet Slow???
The internet has seemed awful slow today. Are others experiencing the same issue or just me? Andy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PayPal Shopping Cart
When they make their purchase it will create an account automatically. So yes and no :) Yes, because they'll have a PayPal account, but no because they don't actually have to put bank account info, etc... Just remember that your purchase will show up as "unconfirmed" because they haven't put cc and bank account info on their account, but you can still get paid :) BTW if you need a tutorial on implementing the PayPal IPN (Instant Payment Notification) there's one on my site here: http://tutorial23.easycfm.com/ Pablo - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 8:28 PM Subject: PayPal Shopping Cart > When using the PayPal Shopping Cart and IPN, do customers have to set up accounts in order to pay? > > Issac > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
PayPal Shopping Cart
When using the PayPal Shopping Cart and IPN, do customers have to set up accounts in order to pay? Issac ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFFlush error
> A long running page (5 seconds) has a little processing banner going on, > and when done, bam goes to next page automatically appending a specific > number to the url string. That is the requirement...and so this > cfflush, cflocate cannot work...I have tried with cfheader as well. > > We see these kind of things on travel sites...does anyone have any > examples, lessons in CF that work in this manner, or are we missing > something? The problem you're running into is that when you use , you flush out the HTML headers with the data, so they're no longer available after it's first called. Since is just CF manually changing the HTML header information to point to the template specified in the "url" attribute, and the HTML headers have already been sent back to the browser, you're seeing your error because the headers don't exist to CF anymore. One suggestion would be to use JavaScript at the bottom of the template to redirect the user instead of . This is what I think Orbitz and other sites use (though they might also user server-side redirects, which is available in other languages like ASP and JSP -- and CFMX). Since you're not modifying HTML headers, you can continue to use and in the same template. Here's a sample of the JS you would use: document.location.href = 'temple_to_redirect_to.cfm'; Alternatively, you can link the calling page to your waiting page, and then use an onLoad() command in the body tag of the waiting page to call the processing template. This way you can display a waiting page for your user while the processing takes place in the background. You'll note that both of these suggestions rely on the use of JavaScript, so if users don't have JS enabled, these would not be viable options. Regards, Dave. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QUERY Help
Thanks for the help, but I'm getting an error. [MySQL][ODBC 3.51 Driver][mysqld-3.23.49-log]You have an error in your SQL syntax near 'SELECT Max(threadID) AS threadID FROM Threads GROUP BY TicketID)' at line 4 As you can see, I'm using MySQL. Does this mean it doesn't suooprt Query of Queries? Any other ideas? Cedric - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 6:39 PM Subject: RE: QUERY Help > This got cut out...sorry! > > SELECT Th.sentBy,T.ticketID,T.subject > FROM Tickets T INNER JOIN Threads Th > ON T.ticketID = Th.ticketID > Where TH.ThreadID in (Select Max(ThreadID) Tid > From Threads > Group By TicketID) > ORDER BY T.priority desc, T.ticketID > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 08:35 PM > To: CF-Talk > Subject: RE: QUERY Help > > > Why are you doing a max on the sentby table as well? > You also may try doing an inner join as well. > Also, If subject and priority could be different, you may want to get rid of > them otherwise you are not going to get what you want. > > The easiest for this may be another approach if you must have those other > fields (which I can totally understand), try this: > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: ASP Service Pricing Structure
Hi All, I'm planning to launch an ASP Service soon which will allow subscribers to manage content hosted on the New Epoch server or their own site hosted elsewhere. The service launch won't occur until after we've fleshed out some of the details of the next release of our CMS which will include support for multiple languages. In the mean time I need to consider pricing structures for the service. I know a lot of services charge monthly fees per seat or login and I don't have any problem doing this in particular. I also know that it wouldn't be especially difficult for me to automate a pricing structure based on volume of published content in MB's which would offer greater accuracy and eliminate the need or desire for login sharing. I'm not worried about login sharing if I charge per seat -- the client loses some functionality in the process so it's a trade-off. So my question is this: if you're subscribing to an ASP hosting service or to manage content on your web site, would you prefer to pay per seat or per MB, or are there other options I should consider that you'd like to see. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cfpop problem
>Line monster ate your last line Sorry - here it is again... (I must have used the line that Michael uses to check for the start of the footer:) A script that has been working great for years under cf4 then cf5 and MX for a few months, then it just now started throwing the error: . . . . An exception occurred when retrieving mails. The cause of this exception was that: java.security.PrivilegedActionException <>. The error occurred in .cfm: line 18 17 : 18 : . . . . I tried deleting the first few messages in the mailbox (there are about 500 baked up now in the mailbox), ad actually got it to work for about 10 messages, then this error came back. I deleted more messages, but couldn't get it to work again. I can retrieve the messages using a web based email program from the server, so I know it isn't a firewall or virus scanner issue. On macromedias page: http://www.macromedia.com/v1/Handlers/index.cfm?ID=23464&Method=Full it says there is a known issue with: 48798 cfpop produces a java.security.PrivilegedActionException error when retrieving bounced email messages. What is meant by a bounced messages? How does it differ from a regular email? Any work arounds for this? This is a dedicated server, and there are no security restrictions on cfpop (or anything) set in the cf administrator. Al ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: QUERY Help
This got cut out...sorry! SELECT Th.sentBy,T.ticketID,T.subject FROM Tickets T INNER JOIN Threads Th ON T.ticketID = Th.ticketID Where TH.ThreadID in (Select Max(ThreadID) Tid From Threads Group By TicketID) ORDER BY T.priority desc, T.ticketID -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 08:35 PM To: CF-Talk Subject: RE: QUERY Help Why are you doing a max on the sentby table as well? You also may try doing an inner join as well. Also, If subject and priority could be different, you may want to get rid of them otherwise you are not going to get what you want. The easiest for this may be another approach if you must have those other fields (which I can totally understand), try this: ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: QUERY Help
Why are you doing a max on the sentby table as well? You also may try doing an inner join as well. Also, If subject and priority could be different, you may want to get rid of them otherwise you are not going to get what you want. The easiest for this may be another approach if you must have those other fields (which I can totally understand), try this: ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: coldfusion and access 2002
I would suggest you look at webmonkey.com for basic stuff. Good tutorials for a beginner. Alan Wolf MCSE NT 4, MCP NT4, Windows 2000 LAN/Network Specialist III Biopharmaceutical Development Program SAIC Frederick PO Box B Bldg 458 Frederick, Maryland 21702 301-846-5479 (V) 301-846-6886 (F) [EMAIL PROTECTED] Once in a while you get shown the light In the strangest of places if you look at it right - Robert Hunter -Original Message- From: Sangeeta Karmokar [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 7:33 PM To: CF-Talk Subject: coldfusion and access 2002 CAn anyone provide me the list of SQL statements? I need to create verify page with login and password.. Thanks Sangeeta ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Cert. Exam
I've been testing away on CFMX Buster. I like it. I took the 5 exam without (it wasn't done yet) but think I will do even better this time. It's worth the money. Excellent product! J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick. -Original Message- From: Brian Simmons [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 4:55 PM To: CF-Talk Subject: Re: CFMX Cert. Exam Hi Ernie, CFMX Exam Buster has has 11 exams, topic exams, random exams, ability to save/print exams, and over 750 questions to help you study for the real Macromedia ColdFusion MX certification test. You can download a demo, which includes one full test at: http://www.centrasoft.com Thanks, Brian -- Brian Simmons [EMAIL PROTECTED] The ultimate ColdFusion MX Certification Exam testing tool: Check out CFMX Exam Buster at: http://www.centrasoft.com -- Brian Simmons [EMAIL PROTECTED] The ultimate ColdFusion MX Certification Exam testing tool: Check out CFMX Exam Buster at: http://www.centrasoft.com > Subject: CFMX Cert. Exam > From: "Ernie Pena" <[EMAIL PROTECTED]> > Date: Wed, 29 Jan 2003 11:50:10 -0600 > Thread: > http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&th > readid=20987&forumid=4#106001 > > Anyone know of a Brain Dump for CFMX Cert. exam? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
QUERY Help
I'm having a bit of trouble with my query. What I have is a table with Tickets. I want to select all the tickets, which works great. Each Ticket has accompanying Threads, so each Ticket can have multiple threads (like a conversation). What I also need to grab along with the Tickets, is the NEWEST Thread. For example, my tables are as follows: Tickets: ticketID (PK) 1 2 and Threads: threadID (PK) | ticketID | sentBy 1|1 | Rick 2|2 | Mike 3|1 | Joe 4|2 | Bob I would like to select from Tickets, 1 and 2, and from Threads, 3 and 4 since 3 is the latest Thread for ticketID 1. Below is the query I'm using, but using the MAX function seems to select threadID's 1 and 2 from Threads. I MAX is choosing which sentBy column is last alphabetically. SELECT MAX(Th.dateReceived) AS dateReceived, MAX(Th.sentBy) AS sentBy, T.ticketID, T.subject FROM Tickets T LEFT JOIN Threads Th ON T.ticketID = Th.ticketID GROUP BY T.ticketID, T.subject, T.priority ORDER BY T.priority desc, T.ticketID Any ideas? Cedric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New problem with csv... argghhh
wow this is clearly the way to go moving forward - but now I need to ask if I'm so far into this already that I need to bully my way through based on current contract work/payments, or scrap all these hours... At 08:11 PM 1/29/03 -0500, you wrote: >By editing the schema.ini file you can add a text datasource with CF's >ini file functions. That way you can dynamically add dsn's when the >end user uploads the file. Take a look at the format of the schema.ini >file that is created, it's pretty straightforward. > >The fact that these files are very large, would be a reason to not >write a manual parsing routine. Microsoft (or someone they bought :)) >already wrote a very good and fast csv parser into the ODBC Text >driver...no need to recreate the wheel imo. I wrote quite a few csv >imports using CF manually and there is still a indentation the size of >my forehead on my desk because of those sleepless nights :) >If you were working with SQL Server, using DTS to do the import would be a >great way as well. Just wanted to throw some options your way. > >This is a cffunction that takes the filename after is has been >uploaded, and creates the Text DSN, and returns the query. It could be >easily modified it work in previous versions of CF though. > > > > > > "ColNameHeader"))) EQ 0> > arguments.filename, "ColNameHeader", "False")> > arguments.filename, "Format", "CSVDelimited")> > arguments.filename, "MaxScanRows", "0")> > arguments.filename, "CharacterSet", "OEM")> > arguments.filename, "Col1", "CUSTNAME Char Width 255")> > arguments.filename, "Col2", "REPNAME Char Width 255")> > arguments.filename, "Col3", "CUSTEMAIL Char Width 255")> > > > SELECT * > FROM [#arguments.filename#] > > > > > >-- > jon > mailto:[EMAIL PROTECTED] > >Tuesday, January 28, 2003, 7:27:05 PM, you wrote: >RAB> At 06:11 PM 1/29/03 -0500, you wrote: > >>Create a ODBC Text Datasource to the file one the machine and then > >>just use cfquery to turn it into a query...which you can loop over or > >RAB> THe problem is it's a multi-thousand record product table from multiple >RAB> manufacturers and new prices come out all the time - so the client >needs a >RAB> way to batch change specific product records... If I create an ODBC >RAB> connection, wouldn't I need to shut it off for every time the Text >RAB> datasource is changed? > >RAB> > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion and Javascript - pushing browser windows
Between you and Joshua - I think you gave some good ideas - not how I intended it to work - but definately a way to make it work. With a little js and css - If a page comes back to this invisible frame -I could have it resize so they can see what I am sending - while not losing their page - The only issue I guess I will have to overcome is how my cookies will act - I will have to set a new function to read and get their cookie and cart info - so that anything clicked on from the "pushed" page will be recorded properly into their cart. The only thing is - I definately am a bit reserved in having to implement an invisible frame - especially site wide. Thanks though - gave me some interesting solutions guys! jay Scott Weikert wrote: Well this is something I hatched in my brain in about ten seconds, so it may need some work. One thing you can do is set up, if you're able (i.e. no proclamations about being frameless) an "invisible frame" - i.e. you do 'rows="100%,*"'. Put your main content in the visible frame, and set up the second, invisible frame, to be on a timed refresh. When a user can't find something, and clicks the "send a 'help!' to the admin" button, you store the particulars of that request in your database. Tag it with some identifier for the user - i.e. some UUID that you store in a cookie, IP number, whatever. Admin does his surfing, and updates the database record with the proper link. Remember the second, invisible frame, with the page that's refreshing from time to time? That page always looks in the database for a record with the user's identifier, AND that has an admin-supplied solution. If it finds one, then it executes a JS popup that displays the info the admin supplied, in whatever form. Maybe set up this page to autorefresh every minute. If it finds nothing (no requests for help that have been answered), this page should execute super-super-fast and not be a burden on your server/bandwidth. At 05:50 PM 1/29/2003 -0800, you wrote: Okay - to clarify push - I think explanation of the scenario is best - 1) User can't find a product or a piece of information on a large website - 2) User clicks a button and sends a request to the Administrator - ( a whole que or dynamic page would be setup to handle these requests and post multiple ones) 3) Administrator surfs around - finds the piece of information And pushes it back to user. 4) On users computer in the originating browser window - or maybe frame -the file loads up. IN fact thinking it would have to be frames based. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
coldfusion and access 2002
CAn anyone provide me the list of SQL statements? I need to create verify page with login and password.. Thanks Sangeeta ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFFlush error
So we're trying to achieve this: A long running page (5 seconds) has a little processing banner going on, and when done, bam goes to next page automatically appending a specific number to the url string. That is the requirement...and so this cfflush, cflocate cannot work...I have tried with cfheader as well. We see these kind of things on travel sites...does anyone have any examples, lessons in CF that work in this manner, or are we missing something? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 7:13 PM To: CF-Talk Subject: RE: CFFlush error You can not flush information from one page, then tell the server to actually send another. Your two choices are to use cfhttp instead of cflocation and just dump the other page to this one, or drop the cfflush. Christian -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 07:06 PM To: CF-Talk Subject: CFFlush error Here's what I get.. I am just flushing out a piece pieces of info as the page processes..then cflocate. I get this error, on a CF 5 box. Failed to perform redirection on blah.CFM DIAGNOSTIC: Failed to perform redirection ColdFusion was unable to perform the CFLOCATION operation. This is probably because you have already used a CFFLUSH tag in your template,or buffered output is turned off. What does one do in this situation? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFFlush error
You can not flush information from one page, then tell the server to actually send another. Your two choices are to use cfhttp instead of cflocation and just dump the other page to this one, or drop the cfflush. Christian -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 07:06 PM To: CF-Talk Subject: CFFlush error Here's what I get.. I am just flushing out a piece pieces of info as the page processes..then cflocate. I get this error, on a CF 5 box. Failed to perform redirection on blah.CFM DIAGNOSTIC: Failed to perform redirection ColdFusion was unable to perform the CFLOCATION operation. This is probably because you have already used a CFFLUSH tag in your template,or buffered output is turned off. What does one do in this situation? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New problem with csv... argghhh
By editing the schema.ini file you can add a text datasource with CF's ini file functions. That way you can dynamically add dsn's when the end user uploads the file. Take a look at the format of the schema.ini file that is created, it's pretty straightforward. The fact that these files are very large, would be a reason to not write a manual parsing routine. Microsoft (or someone they bought :)) already wrote a very good and fast csv parser into the ODBC Text driver...no need to recreate the wheel imo. I wrote quite a few csv imports using CF manually and there is still a indentation the size of my forehead on my desk because of those sleepless nights :) If you were working with SQL Server, using DTS to do the import would be a great way as well. Just wanted to throw some options your way. This is a cffunction that takes the filename after is has been uploaded, and creates the Text DSN, and returns the query. It could be easily modified it work in previous versions of CF though. SELECT * FROM [#arguments.filename#] -- jon mailto:[EMAIL PROTECTED] Tuesday, January 28, 2003, 7:27:05 PM, you wrote: RAB> At 06:11 PM 1/29/03 -0500, you wrote: >>Create a ODBC Text Datasource to the file one the machine and then >>just use cfquery to turn it into a query...which you can loop over or RAB> THe problem is it's a multi-thousand record product table from multiple RAB> manufacturers and new prices come out all the time - so the client needs a RAB> way to batch change specific product records... If I create an ODBC RAB> connection, wouldn't I need to shut it off for every time the Text RAB> datasource is changed? RAB> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFFlush error
Here's what I get.. I am just flushing out a piece pieces of info as the page processes..then cflocate. I get this error, on a CF 5 box. Failed to perform redirection on blah.CFM DIAGNOSTIC: Failed to perform redirection ColdFusion was unable to perform the CFLOCATION operation. This is probably because you have already used a CFFLUSH tag in your template,or buffered output is turned off. What does one do in this situation? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Cert. Exam
Hi Ernie, CFMX Exam Buster has has 11 exams, topic exams, random exams, ability to save/print exams, and over 750 questions to help you study for the real Macromedia ColdFusion MX certification test. You can download a demo, which includes one full test at: http://www.centrasoft.com Thanks, Brian -- Brian Simmons [EMAIL PROTECTED] The ultimate ColdFusion MX Certification Exam testing tool: Check out CFMX Exam Buster at: http://www.centrasoft.com -- Brian Simmons [EMAIL PROTECTED] The ultimate ColdFusion MX Certification Exam testing tool: Check out CFMX Exam Buster at: http://www.centrasoft.com > Subject: CFMX Cert. Exam > From: "Ernie Pena" <[EMAIL PROTECTED]> > Date: Wed, 29 Jan 2003 11:50:10 -0600 > Thread: > http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&th > readid=20987&forumid=4#106001 > > Anyone know of a Brain Dump for CFMX Cert. exam? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New problem with csv... argghhh
At 06:11 PM 1/29/03 -0500, you wrote: >Create a ODBC Text Datasource to the file one the machine and then >just use cfquery to turn it into a query...which you can loop over or THe problem is it's a multi-thousand record product table from multiple manufacturers and new prices come out all the time - so the client needs a way to batch change specific product records... If I create an ODBC connection, wouldn't I need to shut it off for every time the Text datasource is changed? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: New problem with csv... argghhh
At 04:56 PM 1/29/03 -0600, you wrote: >Is your problem like a typical record looks like this :"a,b,c,d" but when it >is "a,b,c," it error out? Or is your problem when the record is ""? It's like: row 1 a,b,c,d row 2 a,b,c, so it craps out on row 2 (sometimes this is in the middle of the file, othertimes it's the last record.) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How do I access Functions that I've written???
If you are using CFMX you can use the tag which lets you used regular CF tags, otherwise no. Also, check out cflib.org . > -Original Message- > From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 30 January 2003 1:17 p.m. > To: CF-Talk > Subject: RE: How do I access Functions that I've written??? > > > Thanks. > > Can you have other then CFSCript commands in a function? > > -Original Message- > From: Barney Boisvert [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 6:09 PM > To: CF-Talk > Subject: RE: How do I access Functions that I've written??? > > > 1) You can have multiple functions in the same file. > > 2) To access a function, it must be defined in the same file > that you want > to use it in, OR be CFINCLUDEd before you use it. Obviously > you don't have > to include the function directly into the file you want to > use it in, so if > you have a template like this: > > > > > You'll be able to use any functions defined in 'myfunc.cfm' within > 'other.cfm'. Just make sure the function files are incldued > before you try > to use them and you'll be set. > > Application.cfm can be a good place to include functions that > are used in a > lot of templates, just keep in mind that every function you > include has to > be parsed and compiled by CF every request, even if it's not > used. CFMX > doesn't have that problem, because it precompiles, but you > said you were on > CF5, so it's worth mentioning. > > barneyb > > > -Original Message- > > From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, January 29, 2003 3:59 PM > > To: CF-Talk > > Subject: How do I access Functions that I've written??? > > > > > > Ok, really rookie question. I have no clue how to use > functions. Could > > someone take a second and either point me to the reading or > answer the > > following 2 questions: > > > > 1. Can I save multiple functions in a single file? > > > > > > 2. How do I set up the CF5.0 server so that functions are found? > > > > > > Thanks, > > Andy > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How do I access Functions that I've written???
Nope, not with CF5. with CFMX you can make tag-based functions, which is WAY nice, but no such luck with CF5. barneyb > -Original Message- > From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 4:17 PM > To: CF-Talk > Subject: RE: How do I access Functions that I've written??? > > > Thanks. > > Can you have other then CFSCript commands in a function? > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 1/27/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How do I access Functions that I've written???
Thanks. Can you have other then CFSCript commands in a function? -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 6:09 PM To: CF-Talk Subject: RE: How do I access Functions that I've written??? 1) You can have multiple functions in the same file. 2) To access a function, it must be defined in the same file that you want to use it in, OR be CFINCLUDEd before you use it. Obviously you don't have to include the function directly into the file you want to use it in, so if you have a template like this: You'll be able to use any functions defined in 'myfunc.cfm' within 'other.cfm'. Just make sure the function files are incldued before you try to use them and you'll be set. Application.cfm can be a good place to include functions that are used in a lot of templates, just keep in mind that every function you include has to be parsed and compiled by CF every request, even if it's not used. CFMX doesn't have that problem, because it precompiles, but you said you were on CF5, so it's worth mentioning. barneyb > -Original Message- > From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 3:59 PM > To: CF-Talk > Subject: How do I access Functions that I've written??? > > > Ok, really rookie question. I have no clue how to use functions. Could > someone take a second and either point me to the reading or answer the > following 2 questions: > > 1. Can I save multiple functions in a single file? > > > 2. How do I set up the CF5.0 server so that functions are found? > > > Thanks, > Andy > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How do I access Functions that I've written???
> 1. Can I save multiple functions in a single file? Yes. Some people like to create function libraries, with functions listed one after another, and cfinclude them. This is very portable, and doesn't seem to affect speed, but it's hard to know which functions you have unless you make an index. Some prefer to keep each function in its own file then either cfinclude them as needed or write a file that cfincludes them all then cfinclude that. > 2. How do I set up the CF5.0 server so that functions are found? You have to cfinclude the file in your page, e.g. in Application.cfm . One thing to note is that you can shift your fns to another scope like request by using structAppend(). I like to do something like this: Use cfmodule (not cfinclude) to call the function library from say application.cfm . The library contains all the functions. Then write structAppend(request, variables, false); at the bottom of the UDF library. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How do I access Functions that I've written???
1) You can have multiple functions in the same file. 2) To access a function, it must be defined in the same file that you want to use it in, OR be CFINCLUDEd before you use it. Obviously you don't have to include the function directly into the file you want to use it in, so if you have a template like this: You'll be able to use any functions defined in 'myfunc.cfm' within 'other.cfm'. Just make sure the function files are incldued before you try to use them and you'll be set. Application.cfm can be a good place to include functions that are used in a lot of templates, just keep in mind that every function you include has to be parsed and compiled by CF every request, even if it's not used. CFMX doesn't have that problem, because it precompiles, but you said you were on CF5, so it's worth mentioning. barneyb > -Original Message- > From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 3:59 PM > To: CF-Talk > Subject: How do I access Functions that I've written??? > > > Ok, really rookie question. I have no clue how to use functions. Could > someone take a second and either point me to the reading or answer the > following 2 questions: > > 1. Can I save multiple functions in a single file? > > > 2. How do I set up the CF5.0 server so that functions are found? > > > Thanks, > Andy > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: New problem with csv... argghhh
This looks alot easier and faster then what I am doing. I'll have to use this for the next CSV I upload. Thanks. Andy -Original Message- From: jon hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 5:43 PM To: CF-Talk Subject: Re: New problem with csv... argghhh [0401802a.txt] ColNameHeader=False Format=CSVDelimited MaxScanRows=0 CharacterSet=OEM Col1=CUSTNAME Char Width 255 Col2=REPNAME Char Width 255 Col3=CUSTEMAIL Char Width 255 [100402me-1.txt] ColNameHeader=False Format=CSVDelimited MaxScanRows=0 CharacterSet=OEM Col1=CUSTNAME Char Width 255 Col2=REPNAME Char Width 255 Col3=CUSTEMAIL Char Width 255 Etc... When you create the DSN a schema.ini will be created automatically for you. Uncheck "Use Current Directory" and select the directory your csv file is in. Then click Options/Define Format, then definte the fields, etc. After this is done, the schema.ini will be automatically created in the directory you selected. -- jon mailto:[EMAIL PROTECTED] Wednesday, January 29, 2003, 6:36:38 PM, you wrote: AO> Jon, AO> what does a sample INI look like? AO> Andy AO> -Original Message- AO> From: jon hall [mailto:[EMAIL PROTECTED]] AO> Sent: Wednesday, January 29, 2003 5:12 PM AO> To: CF-Talk AO> Subject: Re: New problem with csv... argghhh AO> With all the work you've put into this solution, I hate to even say AO> this, but may I suggest a better way, that will should a lot of headaches? AO> Create a ODBC Text Datasource to the file one the machine and then AO> just use cfquery to turn it into a query...which you can loop over or AO> whatever else you want. AO> The ODBC Text Driver has never thrown an error on me complaining about AO> invalid entries, and it's blazing fast... AO> Just go the the ODBC Control Panel and create a Text DSN, save the AO> schema.ini in the same folder as your app, and run something like the AO> below query. AO> AO> SELECT * AO> FROM [#filename#] AO> AO> voila AO> -- AO> jon AO> mailto:[EMAIL PROTECTED] AO> Wednesday, January 29, 2003, 5:44:13 PM, you wrote: RAB>> OK so shoot me in the foot - if my csv file has x records and any RAB>> of those records have a BLANK field- this won't work... it comes back RAB>> with an error in the loop. Is there any way to force it to fill in a RAB>> field with a null? This is especially important with the last record AO> last RAB>> field position. AO> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How do I access Functions that I've written???
Ok, really rookie question. I have no clue how to use functions. Could someone take a second and either point me to the reading or answer the following 2 questions: 1. Can I save multiple functions in a single file? 2. How do I set up the CF5.0 server so that functions are found? Thanks, Andy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New problem with csv... argghhh
[0401802a.txt] ColNameHeader=False Format=CSVDelimited MaxScanRows=0 CharacterSet=OEM Col1=CUSTNAME Char Width 255 Col2=REPNAME Char Width 255 Col3=CUSTEMAIL Char Width 255 [100402me-1.txt] ColNameHeader=False Format=CSVDelimited MaxScanRows=0 CharacterSet=OEM Col1=CUSTNAME Char Width 255 Col2=REPNAME Char Width 255 Col3=CUSTEMAIL Char Width 255 Etc... When you create the DSN a schema.ini will be created automatically for you. Uncheck "Use Current Directory" and select the directory your csv file is in. Then click Options/Define Format, then definte the fields, etc. After this is done, the schema.ini will be automatically created in the directory you selected. -- jon mailto:[EMAIL PROTECTED] Wednesday, January 29, 2003, 6:36:38 PM, you wrote: AO> Jon, AO> what does a sample INI look like? AO> Andy AO> -Original Message- AO> From: jon hall [mailto:[EMAIL PROTECTED]] AO> Sent: Wednesday, January 29, 2003 5:12 PM AO> To: CF-Talk AO> Subject: Re: New problem with csv... argghhh AO> With all the work you've put into this solution, I hate to even say AO> this, but may I suggest a better way, that will should a lot of headaches? AO> Create a ODBC Text Datasource to the file one the machine and then AO> just use cfquery to turn it into a query...which you can loop over or AO> whatever else you want. AO> The ODBC Text Driver has never thrown an error on me complaining about AO> invalid entries, and it's blazing fast... AO> Just go the the ODBC Control Panel and create a Text DSN, save the AO> schema.ini in the same folder as your app, and run something like the AO> below query. AO> AO> SELECT * AO> FROM [#filename#] AO> AO> voila AO> -- AO> jon AO> mailto:[EMAIL PROTECTED] AO> Wednesday, January 29, 2003, 5:44:13 PM, you wrote: RAB>> OK so shoot me in the foot - if my csv file has x records and any RAB>> of those records have a BLANK field- this won't work... it comes back RAB>> with an error in the loop. Is there any way to force it to fill in a RAB>> field with a null? This is especially important with the last record AO> last RAB>> field position. AO> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: New problem with csv... argghhh
Jon, what does a sample INI look like? Andy -Original Message- From: jon hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 5:12 PM To: CF-Talk Subject: Re: New problem with csv... argghhh With all the work you've put into this solution, I hate to even say this, but may I suggest a better way, that will should a lot of headaches? Create a ODBC Text Datasource to the file one the machine and then just use cfquery to turn it into a query...which you can loop over or whatever else you want. The ODBC Text Driver has never thrown an error on me complaining about invalid entries, and it's blazing fast... Just go the the ODBC Control Panel and create a Text DSN, save the schema.ini in the same folder as your app, and run something like the below query. SELECT * FROM [#filename#] voila -- jon mailto:[EMAIL PROTECTED] Wednesday, January 29, 2003, 5:44:13 PM, you wrote: RAB> OK so shoot me in the foot - if my csv file has x records and any RAB> of those records have a BLANK field- this won't work... it comes back RAB> with an error in the loop. Is there any way to force it to fill in a RAB> field with a null? This is especially important with the last record last RAB> field position. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New problem with csv... argghhh
With all the work you've put into this solution, I hate to even say this, but may I suggest a better way, that will should a lot of headaches? Create a ODBC Text Datasource to the file one the machine and then just use cfquery to turn it into a query...which you can loop over or whatever else you want. The ODBC Text Driver has never thrown an error on me complaining about invalid entries, and it's blazing fast... Just go the the ODBC Control Panel and create a Text DSN, save the schema.ini in the same folder as your app, and run something like the below query. SELECT * FROM [#filename#] voila -- jon mailto:[EMAIL PROTECTED] Wednesday, January 29, 2003, 5:44:13 PM, you wrote: RAB> OK so shoot me in the foot - if my csv file has x records and any RAB> of those records have a BLANK field- this won't work... it comes back RAB> with an error in the loop. Is there any way to force it to fill in a RAB> field with a null? This is especially important with the last record last RAB> field position. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: migrate data stored by cf 4.5 to cfmx (unicode problem?)
mmm perhaps you're right. I'm going to try this http posting thing and see if it works... Wednesday, January 29, 2003, 8:01:18 PM, you wrote: JvD> More likely that earlier versions didn't handle unicode right. Feel free JvD> to copy-paste all the Word stuff you want at http://cfmx.oli.tudelft.nl/ JvD> and it shouldn't break (runs on a unicode PostgreSQL database). --- Life is poetry - write it in your own words. --- Toby Tremayne Technical Team Lead Code Poet and Zen Master of the Heavy Sleep Toll Solutions 154 Moray St Sth Melbourne VIC 3205 +61 3 9697 2317 0416 048 090 ICQ: 13107913 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion and Javascript - pushing browser windows
Well this is something I hatched in my brain in about ten seconds, so it may need some work. One thing you can do is set up, if you're able (i.e. no proclamations about being frameless) an "invisible frame" - i.e. you do 'rows="100%,*"'. Put your main content in the visible frame, and set up the second, invisible frame, to be on a timed refresh. When a user can't find something, and clicks the "send a 'help!' to the admin" button, you store the particulars of that request in your database. Tag it with some identifier for the user - i.e. some UUID that you store in a cookie, IP number, whatever. Admin does his surfing, and updates the database record with the proper link. Remember the second, invisible frame, with the page that's refreshing from time to time? That page always looks in the database for a record with the user's identifier, AND that has an admin-supplied solution. If it finds one, then it executes a JS popup that displays the info the admin supplied, in whatever form. Maybe set up this page to autorefresh every minute. If it finds nothing (no requests for help that have been answered), this page should execute super-super-fast and not be a burden on your server/bandwidth. At 05:50 PM 1/29/2003 -0800, you wrote: >Okay - to clarify push - >I think explanation of the scenario is best - >1) User can't find a product or a piece of information on a large website - >2) User clicks a button and sends a request to the Administrator - ( a >whole que or dynamic page would be setup to handle these requests and >post multiple ones) >3) Administrator surfs around - finds the piece of information And >pushes it back to user. >4) On users computer in the originating browser window - or maybe frame >-the file loads up. IN fact thinking it would have to be frames based. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: New problem with csv... argghhh
Is your problem like a typical record looks like this :"a,b,c,d" but when it is "a,b,c," it error out? Or is your problem when the record is ""? -Original Message- From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 4:44 PM To: CF-Talk Subject: New problem with csv... argghhh OK so shoot me in the foot - if my csv file has x records and any of those records have a BLANK field- this won't work... it comes back with an error in the loop. Is there any way to force it to fill in a field with a null? This is especially important with the last record last field position. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: New problem with csv... argghhh
Are you using list functions? CFML list funcs don't like empty elements - basically it ignores them. Try ListFix, http://www.cflib.org/udf.cfm?ID=507, to change the null entries to something you can catch. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc 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: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 4:44 PM > To: CF-Talk > Subject: New problem with csv... argghhh > > > > > OK so shoot me in the foot - if my csv file has x records and any > of those records have a BLANK field- this won't work... it > comes back > with an error in the loop. Is there any way to force it to > fill in a > field with a null? This is especially important with the > last record last > field position. > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion and Javascript - pushing browser windows
You could use a hidden frame (3rd frame) that scans the last incoming message in the chat for a URL ... if it contains a URL with say the word PUSH in front of it then it loads in the other frame. Just a thought. Wouldn't be all that difficult with a little JavaScript. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 8:51 PM To: CF-Talk Subject: Re: ColdFusion and Javascript - pushing browser windows Okay - to clarify push - I think explanation of the scenario is best - 1) User can't find a product or a piece of information on a large website - 2) User clicks a button and sends a request to the Administrator - ( a whole que or dynamic page would be setup to handle these requests and post multiple ones) 3) Administrator surfs around - finds the piece of information And pushes it back to user. 4) On users computer in the originating browser window - or maybe frame -the file loads up. IN fact thinking it would have to be frames based. Why can't we do this with just sending a link through a chat or something - It can't be that easy. Client wants to push a 2 way communication and sharing of pages between his staff and customers. Again - this particular site is running coldfusion cookies and session variables - they all exist so I can know a little about who someone is when they request. Any page they hit assigns them a cartid and some info is stored in db. jay Ben Doom wrote: >I suppose that it depends on what you mean by 'push'. You can >certainly use javascript to do things like set a timed refresh. > >As far as doing a server-side push of data (for example whenever it >updates) I don't know of a way to do that with pure CF and JavaScript, >but I'm sure there are a number of ways to fake it. > > >-- Ben Doom >Programmer & General Lackey >Moonbow Software, Inc > >: -Original Message- >: From: Jason Miller [mailto:[EMAIL PROTECTED]] >: Sent: Wednesday, January 29, 2003 7:14 PM >: To: CF-Talk >: Subject: ColdFusion and Javascript - pushing browser windows >: >: >: Hello group - >: I am only in proposal stage for one of my clients - but they >requested >: that they be able to push .cfm pages through to clients browsers. I >: searched a bit - but am at a total loss for a starting point. >: >: I am using access databases - lots of cookies and session vars for >: different features and flash 6 player - >: I don't know if anyone knows any tricks or articles on the matter. >: >: I assume it must be done with quite a bit of javascript.. any ideas? >: any leads are greatly appreciated. >: thanks >: jay >: >: > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: flash z-index
no problem - and yes it is quite frustrating - you mention below about "the flash" that appears when page loads - In different cases I have hidden ugly with layers - since that won't work in flashes case - a possibility is loadMovieNum - Create an empty shell - with a pretty background or graphic or block of color - place a wait here type timer script - or a loading pseudo animation - You can time it fairly accurate to delay - and when the rest of the page is loaded - simply load in a new .swf - no one will know - it will chop off most likely serious k at load time - and it will help you control the look a bit. not sure if that is relevant - but when you mentioned that flash -that's what I thought of good luck jay miller Ben Doom wrote: >: No - flash always takes the top layer - what wmode="Transparent" does >: is drops the background color of the flash movie so it is transparent. > >Wierd. Seems, um, fairly useless. > >: The ONLY physical way you can get flash to appear below something is ... >: find another way. > >Yeah. Looks like now we'll use 2 iframes, one on top of the other, and >hide/reveal the one on top to make it "pop in and out." > >: You can get creative wtih layers and CSS and JS with positioning and >: move the flash movie on and off the stage - but you can't have things >: appear above flash in both browsers. >: >: As for the scenario you are talking about -YOU can take a snap shot of >: the Flash movie - embed that behind the iframe or layer - when the >: iframe or layer is supposed to pop up - set teh flash movie's position >: off stage - replace it with teh "snap" shot of the flash movie and it >: will appear as if you have done it. >: >: then when iframe or layer disappears - you reset the falsh movie back to >: it's original position. >: >: hope that helps > >It didn't really help per se, but it gave me more info than I had before. >And it will give me cogent arguments for the client. > >I'm working with developers who don't like the 'flash' they get when pages >get loaded. God help me, art people make my head hurt. > >In any case, thanks for the assist. > >--Ben > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
New problem with csv... argghhh
OK so shoot me in the foot - if my csv file has x records and any of those records have a BLANK field- this won't work... it comes back with an error in the loop. Is there any way to force it to fill in a field with a null? This is especially important with the last record last field position. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV loop
Don't ya just LOVE debugging? Why don't you send us the CFFile statement. -Original Message- From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 3:39 PM To: CF-Talk Subject: RE: CSV loop It turns out that it's not the query crappin out - it's the FILE... Everything I try to display (regular text, Variable outputs) BEFORE the CFFILE tag works, but everything after does not show up at all - so apparently the query isn't even gotten to. At 03:35 PM 1/29/03 -0600, you wrote: >Are you sure the page is being hit? If you don't display anything on the >page, add a single HERE I AM to the page to make sure >that you are actually hitting the code. > >Andy > >-Original Message- >From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, January 29, 2003 3:02 PM >To: CF-Talk >Subject: RE: CSV loop > > >Well, no other debug info shows up on the page where the query is - it's >like everything ceases at that point... CFOUTPUTs work on the page but only >ABOVE the query code. If I put it below the query it doesn't show up. > >I've never done CFDump before... what's that do? > > >At 02:51 PM 1/29/03 -0600, you wrote: > >So every other piece of debug info shows up but the query itself. What > >happens if you cfdump the query? > > > >=== > >Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc > > > >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: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, January 29, 2003 2:19 PM > > > To: CF-Talk > > > Subject: RE: CSV loop > > > > > > > > > At 02:17 PM 1/29/03 -0600, you wrote: > > > >Do you have this: > > > > > > > > > > > > > > > >on your page, or in your Application.cfm file? Do you see > > > _other_ debug > > > >info on the page? > > > > > > > > > This is not set, however no other debug info appears - interestingly > > > enough, when I put a with one of the variables > > > above the query > > > on the page, the end page does show that info, so it's > > > processing code ok, > > > but once it reaches that query, nothing else shows up. > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion and Javascript - pushing browser windows
Okay - to clarify push - I think explanation of the scenario is best - 1) User can't find a product or a piece of information on a large website - 2) User clicks a button and sends a request to the Administrator - ( a whole que or dynamic page would be setup to handle these requests and post multiple ones) 3) Administrator surfs around - finds the piece of information And pushes it back to user. 4) On users computer in the originating browser window - or maybe frame -the file loads up. IN fact thinking it would have to be frames based. Why can't we do this with just sending a link through a chat or something - It can't be that easy. Client wants to push a 2 way communication and sharing of pages between his staff and customers. Again - this particular site is running coldfusion cookies and session variables - they all exist so I can know a little about who someone is when they request. Any page they hit assigns them a cartid and some info is stored in db. jay Ben Doom wrote: >I suppose that it depends on what you mean by 'push'. You can certainly use >javascript to do things like set a timed refresh. > >As far as doing a server-side push of data (for example whenever it updates) >I don't know of a way to do that with pure CF and JavaScript, but I'm sure >there are a number of ways to fake it. > > >-- Ben Doom >Programmer & General Lackey >Moonbow Software, Inc > >: -Original Message- >: From: Jason Miller [mailto:[EMAIL PROTECTED]] >: Sent: Wednesday, January 29, 2003 7:14 PM >: To: CF-Talk >: Subject: ColdFusion and Javascript - pushing browser windows >: >: >: Hello group - >: I am only in proposal stage for one of my clients - but they requested >: that they be able to push .cfm pages through to clients browsers. I >: searched a bit - but am at a total loss for a starting point. >: >: I am using access databases - lots of cookies and session vars for >: different features and flash 6 player - >: I don't know if anyone knows any tricks or articles on the matter. >: >: I assume it must be done with quite a bit of javascript.. any ideas? >: any leads are greatly appreciated. >: thanks >: jay >: >: > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: [Resolved] JS form validation script
Cool, glad you got it fixed.
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of
Garrison Enterprises Inc.
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]
*
-Original Message-
From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 5:15 PM
To: CF-Talk
Subject: [Resolved] JS form validation script
I figured it out. Since I used 'i' for my index of my ValForm() function
I could not also use it in the character loop of the charCheck()
function. "i" would increment far past the number of items in my
fieldnames array, which is why I got null errors when attempting to
access a value. I changed the index in charCheck() to "j" and it works
(well, it required a bit more tweaking, but it came out for the most
part.
Cutter
Joshua Miller wrote:
>A couple things:
>
>1. Is there someplace I can see this online to check it out?
>
>2. Have you tried just popping up the value of Item[4] when you run
>through the validator? A lot of times that will give you a good idea
>what's going on. Just stick an alert(Item[4]); in the function that's
>breaking. Then try an alert with that value - ie: if it's showing the
>value of Item[4] is Item.4 then try to alert(Item.4); and see if it's
>an object or a null value or what.
>
>Something like:
>
>function blValMail(field)
>{
>
> Item = field;
>
> // Debug
> alert(Item);
>
> return Item[4];
>
> // Debug
> alert(Item[4]);
>
> // USING THE VALUE OF THE ITEM ABOVE
> alert(Item.4); //or whatever the value from the alert above is.
It
>will say [object] or [NaN] or "undefined" or something.
>
>}
>
>3. It looks at first glance like the value of Item will be a fieldname
>(I may be way off) but how could there be an array of the fieldname?
>For example if I have a field named "email" using your code I'd be
>looing for email[4]. What would the value of email[4] be?
>
>
>4. It seems like it would be MUCH simpler to include your messages and
>return codes in the individual validation functions instead of inside
>an array inside another array. You'll never need the message for
>invalid email inside another validator - save yourself the headache and
>section the messages and status codes into the individual functions,
>then just pass the fieldname to the validator.
>
>
>5. Here's what I've got: http://66.241.216.34/atomm/test_validation.cfm
>If you're interested I can send you the corresponding CF_RealFormNames
>tag that goes with this. You're more than welcome to take it, tweak it
>and make it do whatever you want.
>
>
>It would help if I could see this online to see how it's laid out - if
>possible. If you want to see my validator let me know and I'll send it
>to you.
>
>
>Thanks,
>
>Joshua Miller
>Head Programmer / IT Manager
>Garrison Enterprises Inc.
>www.garrisonenterprises.net [EMAIL PROTECTED]
>(704) 569-9044 ext. 254
>
>***
>*
>*
>Any views expressed in this message are those of the individual sender,
>except where the sender states them to be the views of
>Garrison Enterprises Inc.
>
>This e-mail is intended only for the individual or entity to which it
>is addressed and contains information that is private and confidential.
>If you are not the intended recipient you are hereby notified that any
>dissemination, distribution or copying is strictly prohibited. If you
>have received this e-mail in error please delete it immediately and
>advise us by return e-mail to [EMAIL PROTECTED]
>***
>*
>*
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV loop
IT'S WORKING
Sam, Raymond, Andy, thanks for the help and guidance...
Ultimately, I honestly don't know why the CFFILE wasn't functioning, which
drives me nuts because that was the biggest mistery of all... never to be
discovered, as so many are not...
Once I resolved that, it was debugging the query loop - and it turned out
that in the query loop there were " marks inside the query so it was
looking for
where (MFGPartNumber = '#listgetAt('#line#',1, ',')#"')
instead of where (MFGPartNumber = '#listgetAt('#line#',1,
',')#') (double quote stuck inside the end of the WHERE clause so as a
result it was appending all of the field content with a " and as a result
there were NO matches!
WOW...
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PayPal Shopping Cart
http://tutorial23.easycfm.com/ - Original Message - From: "Double Down, Inc." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 4:54 PM Subject: PayPal Shopping Cart > Was wondering if anyone has used the PayPal Shopping cart and CFML. If you have, wanted to know how the information is sent back to you, is it all one string, is it sperated by commas or some other delimiter? I need to be able to have this information so I can parse it into my DB. If anyone can point me to some code examples or send me a few it would make my life eaiser. > > TIA > > DDINC > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: flash z-index
At 11:16 AM 1/29/3, Ben Doom wrote: > I understood that the z-index of a flash movie was "infinte" -- > that you couldn't float anything (layer, div, etc) over the movie. > Please someone tell me I'm wrong and that I'm just overlooking something! > If you /can/ change the z-index, how? Search "wmode" in the technotes. (IE/Win had been the only browser to do this, but two months ago other browsers added this... see Release Notes for Player for current list.) jd John Dowdell, Macromedia Developer Support, San Francisco (Best to reply on-list, to avoid my mighty spam filters!) Technotes: http://www.macromedia.com/support/search/ Column: http://www.macromedia.com/desdev/jd_forum/ Technical daily diary: http://jdmx.blogspot.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: [OT] Resizable Flash Ad
At 1:28 PM 1/29/3, Sean McCarthy wrote: > Has anyone seen a tutorial on a resizable flash ad like > the ones that yahoo or msnbc do from time to time > Basically i want it to go from a 225x225 to a 75x125 or so. Search "wmode" in the technotes. The ad actually starts full-page, but with a transparent background. IE/Win has been on the only browser to support such "overlay" ads, but this past autumn Mozilla and Mac OS X browsers had this capability added. I'm not sure how long it will take for advertisers' detection schemes to serve such ads to more than just IE/Win. jd John Dowdell, Macromedia Developer Support, San Francisco (Best to reply on-list, to avoid my mighty spam filters!) Technotes: http://www.macromedia.com/support/search/ Column: http://www.macromedia.com/desdev/jd_forum/ Technical daily diary: http://jdmx.blogspot.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hosting contract
Kev, Thanks - that's about what I was looking for. -Mark -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 4:13 PM To: CF-Talk Subject: RE: Hosting contract Have a hunt around www.cdaa.com.au specifically http://www.cdaahosting.com/tandc.asp ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, 30 January 2003 8:37 AM To: CF-Talk Subject: Hosting contract Does anyone have an example of a good hosting contract (preferrably on-line)? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: [OT] Resizable Flash Ad
I didn't confirm but moock.org I beleive addresses resizing the flash stage object through js. worth a look - again - didn't confirm it -but that would be a route to attempt jay miller Haggerty, Mike wrote: >There is a Stage object in Flash which refers to the size of the movie. I am >not certain if you can resize that or not. > >What I do is make a transparent movie at the maxsize I need and then work >with the movie clips to get them the size I want. > >This may or may not work in your case. > >M > >-Original Message- >From: Sean McCarthy [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, January 29, 2003 4:28 PM >To: CF-Talk >Subject: [OT] Resizable Flash Ad > > >Has anyone seen a tutorial on a resizable flash ad like the ones that yahoo >or msnbc do from time to time > >Basically i want it to go from a 225x225 to a 75x125 or so. > >The ad will sit on a CF site so I guess its not that far off topic... > >Thanks > >Sean > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: XML and CF and SOXML
If you follow enough links you can find this tag... I will save you the pain: http://devex.macromedia.com/developer/gallery/info.cfm?ID=A28467B5-F7B9- 11D6-840E00508B94F85A&method=Download Happy xmling, Trey > -Original Message- > From: Owens, Howard [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 06, 2003 5:37 PM > To: CF-Talk > Subject: RE: XML and CF > > Too bad ... it's a great little tool. > > H. > > > > -Original Message- > > From: Robert Bailey [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, January 06, 2003 2:58 PM > > To: CF-Talk > > Subject:RE: XML and CF > > > > They no longer develop or support SoXML, tried to DL it from their page > > > > > > Robert Bailey > > > > > > > > -Original Message- > > From: Owens, Howard [mailto:[EMAIL PROTECTED]] > > Sent: Monday, January 06, 2003 2:50 PM > > To: CF-Talk > > Subject: RE: XML and CF > > > > http://www.torchbox.com/xml/ > > > > Also, check out the cf_soxml tag in the tag gallery. > > > > H. > > > > > > > -Original Message- > > > From: Robert Bailey [SMTP:[EMAIL PROTECTED]] > > > Sent: Monday, January 06, 2003 2:22 PM > > > To: CF-Talk > > > Subject: XML and CF > > > > > > Anyone know any good sites or articles dealing with XML and CF? > > > > > > Robert Bailey > > > [EMAIL PROTECTED] > > > "Famous for nothing!" > > > http://www.tinetics.com > > > > > > > > > --- > > > [This E-mail scanned for viruses] > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Struct Sort
I've used that exact code for getting an ordered list of keys, but the first comment user comment says structKeyList() doesn't return in insert order, and I agree. Running this code (linux/apache/cfmx) results in '1,2' being displayed. Reversing the structInsert calls has no effect. s = structNew(); structInsert(s, "2", ""); structInsert(s, "1", ""); #structKeyList(s)# > -Original Message- > From: Dave Carabetta [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 2:05 PM > To: CF-Talk > Subject: RE: Struct Sort > > > >Where does it say that struct keys are returned in insertion order? The > >docs for structKeyList() and structKeyArray() say they are unordered. > > In the LiveDocs on MM's site under Migrate ColdFusion 5 > Applications, if you > scroll to the very bottom, you'll see that StructKeyList() now > returns the > keys in the order that they are created. Also, if you scroll down > and read > the user comments on that particular page, you'll see a bit of > code to loop > over the key alphabetically. Here's the link to the page: > > http://livedocs.macromedia.com/cfmxdocs/Migrating_ColdFusion_5_App lications/cf_migration_guide7.jsp#1201936 > > Regards, > Dave. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 1/27/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
[Resolved] JS form validation script
I figured it out. Since I used 'i' for my index of my ValForm() function
I could not also use it in the character loop of the charCheck()
function. "i" would increment far past the number of items in my
fieldnames array, which is why I got null errors when attempting to
access a value. I changed the index in charCheck() to "j" and it works
(well, it required a bit more tweaking, but it came out for the most part.
Cutter
Joshua Miller wrote:
>A couple things:
>
>1. Is there someplace I can see this online to check it out?
>
>2. Have you tried just popping up the value of Item[4] when you run
>through the validator? A lot of times that will give you a good idea
>what's going on. Just stick an alert(Item[4]); in the function that's
>breaking. Then try an alert with that value - ie: if it's showing the
>value of Item[4] is Item.4 then try to alert(Item.4); and see if it's an
>object or a null value or what.
>
>Something like:
>
>function blValMail(field)
>{
>
> Item = field;
>
> // Debug
> alert(Item);
>
> return Item[4];
>
> // Debug
> alert(Item[4]);
>
> // USING THE VALUE OF THE ITEM ABOVE
> alert(Item.4); //or whatever the value from the alert above is.
>It will say [object] or [NaN] or "undefined" or something.
>
>}
>
>3. It looks at first glance like the value of Item will be a fieldname
>(I may be way off) but how could there be an array of the fieldname?
>For example if I have a field named "email" using your code I'd be
>looing for email[4]. What would the value of email[4] be?
>
>
>4. It seems like it would be MUCH simpler to include your messages and
>return codes in the individual validation functions instead of inside an
>array inside another array. You'll never need the message for invalid
>email inside another validator - save yourself the headache and section
>the messages and status codes into the individual functions, then just
>pass the fieldname to the validator.
>
>
>5. Here's what I've got: http://66.241.216.34/atomm/test_validation.cfm
>If you're interested I can send you the corresponding CF_RealFormNames
>tag that goes with this. You're more than welcome to take it, tweak it
>and make it do whatever you want.
>
>
>It would help if I could see this online to see how it's laid out - if
>possible. If you want to see my validator let me know and I'll send it
>to you.
>
>
>Thanks,
>
>Joshua Miller
>Head Programmer / IT Manager
>Garrison Enterprises Inc.
>www.garrisonenterprises.net
>[EMAIL PROTECTED]
>(704) 569-9044 ext. 254
>
>
>*
>Any views expressed in this message are those of the individual sender,
>except where the sender states them to be the views of
>Garrison Enterprises Inc.
>
>This e-mail is intended only for the individual or entity to which it is
>addressed and contains information that is private and confidential. If
>you are not the intended recipient you are hereby notified that any
>dissemination, distribution or copying is strictly prohibited. If you
>have received this e-mail in error please delete it immediately and
>advise us by return e-mail to [EMAIL PROTECTED]
>
>*
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hosting contract
Have a hunt around www.cdaa.com.au specifically http://www.cdaahosting.com/tandc.asp ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, 30 January 2003 8:37 AM To: CF-Talk Subject: Hosting contract Does anyone have an example of a good hosting contract (preferrably on-line)? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: [OT] Resizable Flash Ad
There is a Stage object in Flash which refers to the size of the movie. I am not certain if you can resize that or not. What I do is make a transparent movie at the maxsize I need and then work with the movie clips to get them the size I want. This may or may not work in your case. M -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 4:28 PM To: CF-Talk Subject: [OT] Resizable Flash Ad Has anyone seen a tutorial on a resizable flash ad like the ones that yahoo or msnbc do from time to time Basically i want it to go from a 225x225 to a 75x125 or so. The ad will sit on a CF site so I guess its not that far off topic... Thanks Sean ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV loop
I think I'm onto it... I stripped everything out and now for whatever reason, it's reading the file finally! I think its working now - it's finally giving me loop query errors and cfdump displays the contents of the CSV...which is a GREAT sign At 03:55 PM 1/29/03 -0600, you wrote: >Unless I'm mistaken - something very odd is going on. For code after the >cffile to just ... stop ... without any error thrown to the screen is >not good. Here is another test - right after the cffile, use a >tag to log a test message to the application log. See if it gets added. > >=== >Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc > >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: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, January 29, 2003 3:47 PM > > To: CF-Talk > > Subject: RE: CSV loop > > > > > > At 03:37 PM 1/29/03 -0600, you wrote: > > >Add a bunch of output statements so that you can see what's going on. > > > > I've got CFOUTPUTs all over - before, and after the file tag, > > which comes > > before the cfloop - so it's not the query it's a problem with > > the cffile > > tag... but I scrapped it and used a known good cffile from > > another form... > > and still it dies there with no errors shown. I also checked > > to be sure > > it's a good csv it's reading > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Struct Sort
>Where does it say that struct keys are returned in insertion order? The >docs for structKeyList() and structKeyArray() say they are unordered. In the LiveDocs on MM's site under Migrate ColdFusion 5 Applications, if you scroll to the very bottom, you'll see that StructKeyList() now returns the keys in the order that they are created. Also, if you scroll down and read the user comments on that particular page, you'll see a bit of code to loop over the key alphabetically. Here's the link to the page: http://livedocs.macromedia.com/cfmxdocs/Migrating_ColdFusion_5_Applications/cf_migration_guide7.jsp#1201936 Regards, Dave. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Hosting contract
Does anyone have an example of a good hosting contract (preferrably on-line)? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion and Javascript - pushing browser windows
Like Ben said, we need to know what you mean by 'push'. One example of 'push' that I used and might be helpful (and since you are using Flash) was to set up a Web resource that Flash can check to see if a page needs to be loaded. I used the loadVariables command to check a Web resource at regular intervals to see if an alert needed to be loaded on a user's PC. By Web resource I mean either a Web service or a Web page. In this case, the value returned by the Web resource was a datetime value and a url to the alert page that needed to be loaded. The Flash movie would compare the datetime returned by the Web resource with the datetime the movie was loaded, and, if the one returned by the Web resource was greater, the Flash movie would trigger a javascript that would load a new window and show the alert page. Hopefully, this helps. M -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 7:14 PM To: CF-Talk Subject: ColdFusion and Javascript - pushing browser windows Hello group - I am only in proposal stage for one of my clients - but they requested that they be able to push .cfm pages through to clients browsers. I searched a bit - but am at a total loss for a starting point. I am using access databases - lots of cookies and session vars for different features and flash 6 player - I don't know if anyone knows any tricks or articles on the matter. I assume it must be done with quite a bit of javascript.. any ideas? any leads are greatly appreciated. thanks jay ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query help...
> I have a table with columns named q1,q2,q3, through q19. Each > question can have a value of 1, 2, or 3. How can I generate a > query/cfcode that will tell me how many people answered 1, 2, and 3 > for question 1 through question 19 without having a ton of queries? > I know it needs to loop somehow, but it just hasn't worked out > correctly so far. Another approach you might consider would be to normalize your data so instead of having 19 columns representing answers to specific questions for each respondant, you would have a table with up to 19 rows for each respondant, each with a question ID (1-19) and the answer (1-3) such as: userID, qID, qAnswer For example, assume the following data in such a table: userID qID qAnswer 1 1 1 1 2 2 1 3 3 1 4 3 2 1 3 2 2 3 3 1 1 3 2 1 Than a query like: select qID, qAnswer, count(userID) as QACnt from myTable group by qID, qAnswer would result in: qID qAnswer QACnt 1 1 2 1 3 1 2 2 2 2 3 1 3 3 1 4 3 1 This would show you how may (QACnt) had answered each question with which response (Question 1 had 2 responses for answer 1 and 1 response for answer 3). Regards, Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV loop
Unless I'm mistaken - something very odd is going on. For code after the cffile to just ... stop ... without any error thrown to the screen is not good. Here is another test - right after the cffile, use a tag to log a test message to the application log. See if it gets added. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc 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: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 3:47 PM > To: CF-Talk > Subject: RE: CSV loop > > > At 03:37 PM 1/29/03 -0600, you wrote: > >Add a bunch of output statements so that you can see what's going on. > > I've got CFOUTPUTs all over - before, and after the file tag, > which comes > before the cfloop - so it's not the query it's a problem with > the cffile > tag... but I scrapped it and used a known good cffile from > another form... > and still it dies there with no errors shown. I also checked > to be sure > it's a good csv it's reading > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
PayPal Shopping Cart
Was wondering if anyone has used the PayPal Shopping cart and CFML. If you have, wanted to know how the information is sent back to you, is it all one string, is it sperated by commas or some other delimiter? I need to be able to have this information so I can parse it into my DB. If anyone can point me to some code examples or send me a few it would make my life eaiser. TIA DDINC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV loop
At 03:37 PM 1/29/03 -0600, you wrote: >Add a bunch of output statements so that you can see what's going on. I've got CFOUTPUTs all over - before, and after the file tag, which comes before the cfloop - so it's not the query it's a problem with the cffile tag... but I scrapped it and used a known good cffile from another form... and still it dies there with no errors shown. I also checked to be sure it's a good csv it's reading ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: 2 Selects somewhat related
I haven't see anyone else reply to this so I figured I would. There are several ways to do this but I believe that the DevExchange on the MM website already has one or more examples. Let me know if you can't find it and I'll take a look for you or send you an email off list explaining in more detail what can be done. -Novak - Original Message - From: "Randell B Adkins" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 12:39 PM Subject: 2 Selects somewhat related > Has anyone seen a JS function or CustomTag > that will allow a total of 3 selectboxes to be > dynamically populated based on: > > HERE IS THE KICKER: > > the first selection box (upon selection) > would populate the 2nd and 3rd at the SAME > time with related values. > > Box 2 and Box 3 are not related but are > related to box 1 > > If CustomTag, then I am sure 2 queries > would be needed. > > Thanks!! > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Size of string in Bytes
Supposing there is no goofiness (ie non-ASCII), the length in bytes is the length of the string in characters.. (a character is a byte). len(string) = # of bytes. -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 3:05 PM To: CF-Talk Subject: Size of string in Bytes Anyone know of an easy way to get the size of a string in bytes? TIA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Size of string in Bytes
Gyrus wrote: > > Wouldn't Len(string) do it? Assuming 1 byte per character, of course. The > only common exception I can think of is Unicode I can think of a few more, like most Azian charsets. > but if you're storing in Unicode, Len(string)*2 would do it. Depends on the form of use. It can be anywhere between 1 and 4 bytes, and even different characters in one form of use can have a different number of octets. UTF-8, which is the default in CF MX, is one of the variable length types. Filing an enhancement request for an Octet_Length() function might be a good idea (with exactly that name, that way it is the same as the SQL Octet_Length() function). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV loop
At 03:41 PM 1/29/03 -0600, you wrote: > >Hello > >And you are saying the Hello doesn't show? And it's ABOVE the cfloop? That's correct - and just in case it was some crazy cffile syntax, I deleted it and pasted in a known good cffile tag and just referred to one of my csv files... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Size of string in Bytes
Be careful with Unicode ... it's an all too common misconception that Unicode = double byte ... Taken from the Unicode FAQ section http://www.unicode.org/faq/basic_q.html#19 Q. I understand that all Unicode characters are 16 bits, and that the high byte is used to switch between code blocks. Is that correct? A. Absolutely not! Unicode characters may be encoded at any code point from U+ to U+10. The size of the code unit used for expressing those code points may be 8 bits (for UTF-8), 16 bits (for UTF-16), or 32 bits (for UTF-32) [See UTF & BOM]. Even when Unicode characters are expressed with 16-bit code units, there is no concept of a high byte switching values between "code pages" expressed in the low byte. The entire 16-bit value expresses the entire character, period. [KW] hope that helps ... Mark - Original Message - From: "Gyrus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 30, 2003 8:35 AM Subject: Re: Size of string in Bytes > - Original Message - > From: "Sean Daniels" <[EMAIL PROTECTED]> > > Anyone know of an easy way to get the size of a string in bytes? > > Wouldn't Len(string) do it? Assuming 1 byte per character, of course. The > only common exception I can think of is Unicode - but if you're storing in > Unicode, Len(string)*2 would do it. > > Gyrus > [EMAIL PROTECTED] > work: http://www.tengai.co.uk > play: http://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=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Size of string in Bytes
Sean Daniels wrote: > Anyone know of an easy way to get the size of a string in bytes? Write it to disk and check filesize or send it to a databae and use Octet_Length(). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Struct Sort
Where does it say that struct keys are returned in insertion order? The docs for structKeyList() and structKeyArray() say they are unordered. barneyb > -Original Message- > From: Dave Carabetta [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 1:27 PM > To: CF-Talk > Subject: RE: Struct Sort > > > >The reason there is no rhyme or reason is because structs are > implemented > >as > >HashMaps in CFMX, which by definition don't have an order to the > values. I > >would imagine that you'll get them back in hashCode() order, but > that's not > >guarenteed consistent because of collision resolution. > > According to the CFMX docs, the key are ordered according to the > date/time > that the key was inserted into the structure. I should note that > if you use > and see that the keys are alphabetized in MX, it's becaue the > tag re-orders the keys alphabetically before outputting to the > user. Internally though, it's still by date/time. > > >I'm not sure how they were implemented in CF5 and below, but it wasn't a > >Java HashMap. Probably was still a HashMap, but with a different > >implementation of the getKeyList() method that sorted the key list first. > > As Ray pointed out, structures were ordered alphabetically in CF versions > previous to MX, but that behavior was not promised to remain the same in > future versions -- it was more of a convenience. > > Regards, > Dave. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 1/27/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV loop
It turns out that it's not the query crappin out - it's the FILE... Everything I try to display (regular text, Variable outputs) BEFORE the CFFILE tag works, but everything after does not show up at all - so apparently the query isn't even gotten to. At 03:35 PM 1/29/03 -0600, you wrote: >Are you sure the page is being hit? If you don't display anything on the >page, add a single HERE I AM to the page to make sure >that you are actually hitting the code. > >Andy > >-Original Message- >From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, January 29, 2003 3:02 PM >To: CF-Talk >Subject: RE: CSV loop > > >Well, no other debug info shows up on the page where the query is - it's >like everything ceases at that point... CFOUTPUTs work on the page but only >ABOVE the query code. If I put it below the query it doesn't show up. > >I've never done CFDump before... what's that do? > > >At 02:51 PM 1/29/03 -0600, you wrote: > >So every other piece of debug info shows up but the query itself. What > >happens if you cfdump the query? > > > >=== > >Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc > > > >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: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, January 29, 2003 2:19 PM > > > To: CF-Talk > > > Subject: RE: CSV loop > > > > > > > > > At 02:17 PM 1/29/03 -0600, you wrote: > > > >Do you have this: > > > > > > > > > > > > > > > >on your page, or in your Application.cfm file? Do you see > > > _other_ debug > > > >info on the page? > > > > > > > > > This is not set, however no other debug info appears - interestingly > > > enough, when I put a with one of the variables > > > above the query > > > on the page, the end page does show that info, so it's > > > processing code ok, > > > but once it reaches that query, nothing else shows up. > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CLOB and Incorrect Characters
Kazmierczak, Kevin wrote: > > We are having trouble with some Memo fields in Access after we > upgraded to cfmx. First we enabled CLOB in order to get them to show up, > but now our problem is that some characters are getting replaced by a little > box character, mainly the characters "'", "-", """. Has this happened to > anyone else? Are you using: - cfqueryparamn? - setEncoding()? - cfcontent? - valid HTML? - cfprocessingdirective? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV loop
So right now you have..
Hello
And you are saying the Hello doesn't show? And it's ABOVE the cfloop?
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
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: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 29, 2003 3:32 PM
> To: CF-Talk
> Subject: RE: CSV loop
>
>
> HOLY CANNOLI - CFDUMP on the file - zip, nada, nothin... I
> put the word
> HELLO on the page after the CFFILE, and it doesnt show - put
> it up above,
> and it does! So it's not my query
>
> At 03:28 PM 1/29/03 -0600, you wrote:
> >Ah - you should check and see if read_file is empty first -
> before your
> >cfloop, do a dump on that. Make sure you are actually
> looping. Or you
> >can also add debug statements in your cfloop tags..
> >
> >Going over a line, the line is #line#, enjoy
> >
> >=
> ==
> >Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
> >
> >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: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, January 29, 2003 3:20 PM
> > > To: CF-Talk
> > > Subject: RE: CSV loop
> > >
> > >
> > > Ray,
> > >
> > > Thanks so much for guiding me through all this - it's quite
> > > frustrating...
> > >
> > > OK, so how do I implement it? I tried the code below,
> and again, it
> > > comes up with a blank...
> > >
> > >
> > >
> > > #Delims#
> > >
> > > > > action=read
> > >
> > > file="c:\inetpub\wwwroot\briona\secure\modernstorage\shop\cont
> > > rol\QuantumModify.csv"
> > > variable="read_file">
> > >
> > >
> > >
> > >
> > >
> > > UPDATE Products
> > > SET
> > > JPG = '#listgetAt('#line#',2, ',')#"',
> > > PDF = '#listgetAt('#line#',3, ',')#"'
> > > where (MFGPartNumber = '#listgetAt('#line#',1, ',')#"')
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV loop
Add a bunch of output statements so that you can see what's going on.
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 3:29 PM
To: CF-Talk
Subject: RE: CSV loop
Ah - you should check and see if read_file is empty first - before your
cfloop, do a dump on that. Make sure you are actually looping. Or you
can also add debug statements in your cfloop tags..
Going over a line, the line is #line#, enjoy
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
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: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 29, 2003 3:20 PM
> To: CF-Talk
> Subject: RE: CSV loop
>
>
> Ray,
>
> Thanks so much for guiding me through all this - it's quite
> frustrating...
>
> OK, so how do I implement it? I tried the code below, and
> again, it comes
> up with a blank...
>
>
>
> #Delims#
>
>action=read
>
> file="c:\inetpub\wwwroot\briona\secure\modernstorage\shop\cont
> rol\QuantumModify.csv"
>variable="read_file">
>
>
>
>
>
> UPDATE Products
> SET
> JPG = '#listgetAt('#line#',2, ',')#"',
> PDF = '#listgetAt('#line#',3, ',')#"'
> where (MFGPartNumber = '#listgetAt('#line#',1, ',')#"')
>
>
>
>
>
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dumb question client variables
Depends how you use it. If you want to check if available using StructKeyExists, use StructDelete(structure, key [, indicatenotexisting ]) If you want to check by Len() GT 0, then just empty out with "". Andy -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 2:39 PM To: CF-Talk Subject: dumb question client variables hi there. If I wanted to remove the value of a client variable I have set for a particular user, lets just say, emailAddress, and they check a checkbox that says, Forget my email address, would the best way to do that, be to have this code... to just zero the value out? brain fartage on a stinkin cold rainy Wednesday thanks ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting 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=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV loop
Are you sure the page is being hit? If you don't display anything on the page, add a single HERE I AM to the page to make sure that you are actually hitting the code. Andy -Original Message- From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 3:02 PM To: CF-Talk Subject: RE: CSV loop Well, no other debug info shows up on the page where the query is - it's like everything ceases at that point... CFOUTPUTs work on the page but only ABOVE the query code. If I put it below the query it doesn't show up. I've never done CFDump before... what's that do? At 02:51 PM 1/29/03 -0600, you wrote: >So every other piece of debug info shows up but the query itself. What >happens if you cfdump the query? > >=== >Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc > >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: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, January 29, 2003 2:19 PM > > To: CF-Talk > > Subject: RE: CSV loop > > > > > > At 02:17 PM 1/29/03 -0600, you wrote: > > >Do you have this: > > > > > > > > > > > >on your page, or in your Application.cfm file? Do you see > > _other_ debug > > >info on the page? > > > > > > This is not set, however no other debug info appears - interestingly > > enough, when I put a with one of the variables > > above the query > > on the page, the end page does show that info, so it's > > processing code ok, > > but once it reaches that query, nothing else shows up. > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV loop
HOLY CANNOLI - CFDUMP on the file - zip, nada, nothin... I put the word
HELLO on the page after the CFFILE, and it doesnt show - put it up above,
and it does! So it's not my query
At 03:28 PM 1/29/03 -0600, you wrote:
>Ah - you should check and see if read_file is empty first - before your
>cfloop, do a dump on that. Make sure you are actually looping. Or you
>can also add debug statements in your cfloop tags..
>
>Going over a line, the line is #line#, enjoy
>
>===
>Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
>
>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: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, January 29, 2003 3:20 PM
> > To: CF-Talk
> > Subject: RE: CSV loop
> >
> >
> > Ray,
> >
> > Thanks so much for guiding me through all this - it's quite
> > frustrating...
> >
> > OK, so how do I implement it? I tried the code below, and
> > again, it comes
> > up with a blank...
> >
> >
> >
> > #Delims#
> >
> > > action=read
> >
> > file="c:\inetpub\wwwroot\briona\secure\modernstorage\shop\cont
> > rol\QuantumModify.csv"
> > variable="read_file">
> >
> >
> >
> >
> >
> > UPDATE Products
> > SET
> > JPG = '#listgetAt('#line#',2, ',')#"',
> > PDF = '#listgetAt('#line#',3, ',')#"'
> > where (MFGPartNumber = '#listgetAt('#line#',1, ',')#"')
> >
> >
> >
> >
> >
> >
> >
> >
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Size of string in Bytes
- Original Message - From: "Sean Daniels" <[EMAIL PROTECTED]> > Anyone know of an easy way to get the size of a string in bytes? Wouldn't Len(string) do it? Assuming 1 byte per character, of course. The only common exception I can think of is Unicode - but if you're storing in Unicode, Len(string)*2 would do it. Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://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=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion and Javascript - pushing browser windows
I suppose that it depends on what you mean by 'push'. You can certainly use javascript to do things like set a timed refresh. As far as doing a server-side push of data (for example whenever it updates) I don't know of a way to do that with pure CF and JavaScript, but I'm sure there are a number of ways to fake it. -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -Original Message- : From: Jason Miller [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, January 29, 2003 7:14 PM : To: CF-Talk : Subject: ColdFusion and Javascript - pushing browser windows : : : Hello group - : I am only in proposal stage for one of my clients - but they requested : that they be able to push .cfm pages through to clients browsers. I : searched a bit - but am at a total loss for a starting point. : : I am using access databases - lots of cookies and session vars for : different features and flash 6 player - : I don't know if anyone knows any tricks or articles on the matter. : : I assume it must be done with quite a bit of javascript.. any ideas? : any leads are greatly appreciated. : thanks : jay : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: flash z-index
: No - flash always takes the top layer - what wmode="Transparent" does : is drops the background color of the flash movie so it is transparent. Wierd. Seems, um, fairly useless. : The ONLY physical way you can get flash to appear below something is ... : find another way. Yeah. Looks like now we'll use 2 iframes, one on top of the other, and hide/reveal the one on top to make it "pop in and out." : You can get creative wtih layers and CSS and JS with positioning and : move the flash movie on and off the stage - but you can't have things : appear above flash in both browsers. : : As for the scenario you are talking about -YOU can take a snap shot of : the Flash movie - embed that behind the iframe or layer - when the : iframe or layer is supposed to pop up - set teh flash movie's position : off stage - replace it with teh "snap" shot of the flash movie and it : will appear as if you have done it. : : then when iframe or layer disappears - you reset the falsh movie back to : it's original position. : : hope that helps It didn't really help per se, but it gave me more info than I had before. And it will give me cogent arguments for the client. I'm working with developers who don't like the 'flash' they get when pages get loaded. God help me, art people make my head hurt. In any case, thanks for the assist. --Ben ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dumb question client variables
dave you hit the nail on the head,
however gary houck had already
emailed me off list that function ;)
I just didn't know it even existed!!!
later and thanks!
...tony
Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337
-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 4:22 PM
To: CF-Talk
Subject: Re: dumb question client variables
>hi there.
>
>If I wanted to remove the value of a client variable I have set for a
>particular user, lets just say, emailAddress, and they check a checkbox
>that says, Forget my email address, would the best way to do that, be
>to have this code...
>
>
>
>to just zero the value out?
Not entirely sure what you're trying to do, but why not use
DeleteClientVariable("EmailAddress") to delete that particular client
variable? This has the added benefit (albeit minimal) of one less client
variable CF needs to return with every page request. Then just do an
IsDefined("client.EmailAddress") to check for that particular client
variable when you need to.
Alternatively, you can indeed just do
in
your code to "null" out the value for that client variable, and then
just do
a to check for a value.
>
>brain fartage on a stinkin cold rainy Wednesday
Hey, it could be worse. It's snowing here!! (New York City)
Regards,
Dave.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV loop
Ah - you should check and see if read_file is empty first - before your
cfloop, do a dump on that. Make sure you are actually looping. Or you
can also add debug statements in your cfloop tags..
Going over a line, the line is #line#, enjoy
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
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: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 29, 2003 3:20 PM
> To: CF-Talk
> Subject: RE: CSV loop
>
>
> Ray,
>
> Thanks so much for guiding me through all this - it's quite
> frustrating...
>
> OK, so how do I implement it? I tried the code below, and
> again, it comes
> up with a blank...
>
>
>
> #Delims#
>
>action=read
>
> file="c:\inetpub\wwwroot\briona\secure\modernstorage\shop\cont
> rol\QuantumModify.csv"
>variable="read_file">
>
>
>
>
>
> UPDATE Products
> SET
> JPG = '#listgetAt('#line#',2, ',')#"',
> PDF = '#listgetAt('#line#',3, ',')#"'
> where (MFGPartNumber = '#listgetAt('#line#',1, ',')#"')
>
>
>
>
>
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: coldfusion and access 2002
you may want to ask on the sql list someone there might know - Original Message - From: "Sangeeta Karmokar" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 2:52 PM Subject: coldfusion and access 2002 > Can anyone help me Please?? > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Struct Sort
>The reason there is no rhyme or reason is because structs are implemented >as >HashMaps in CFMX, which by definition don't have an order to the values. I >would imagine that you'll get them back in hashCode() order, but that's not >guarenteed consistent because of collision resolution. According to the CFMX docs, the key are ordered according to the date/time that the key was inserted into the structure. I should note that if you use and see that the keys are alphabetized in MX, it's becaue the tag re-orders the keys alphabetically before outputting to the user. Internally though, it's still by date/time. >I'm not sure how they were implemented in CF5 and below, but it wasn't a >Java HashMap. Probably was still a HashMap, but with a different >implementation of the getKeyList() method that sorted the key list first. As Ray pointed out, structures were ordered alphabetically in CF versions previous to MX, but that behavior was not promised to remain the same in future versions -- it was more of a convenience. Regards, Dave. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
[OT] Resizable Flash Ad
Has anyone seen a tutorial on a resizable flash ad like the ones that yahoo
or msnbc do from time to time
Basically i want it to go from a 225x225 to a 75x125 or so.
The ad will sit on a CF site so I guess its not that far off topic...
Thanks
Sean
-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 4:22 PM
To: CF-Talk
Subject: Re: dumb question client variables
>hi there.
>
>If I wanted to remove the value of a client variable I have set for a
>particular user, lets just say, emailAddress, and they check a checkbox
>that says, Forget my email address, would the best way to do that, be
>to have this code...
>
>
>
>to just zero the value out?
Not entirely sure what you're trying to do, but why not use
DeleteClientVariable("EmailAddress") to delete that particular client
variable? This has the added benefit (albeit minimal) of one less client
variable CF needs to return with every page request. Then just do an
IsDefined("client.EmailAddress") to check for that particular client
variable when you need to.
Alternatively, you can indeed just do in
your code to "null" out the value for that client variable, and then just do
a to check for a value.
>
>brain fartage on a stinkin cold rainy Wednesday
Hey, it could be worse. It's snowing here!! (New York City)
Regards,
Dave.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
