Re: restricting cfoutput character length
Saturday (Stuart Kidd) wrote: >Hi, > >I'm trying to do something which i can imagine is very simple but >can't find the function. When i display a title >#myTitle# i'd like to just display the first 15 >characters and if more then put three dots (periods). I know the LEN >function but i can't work out how to replace the text with dots after >the 15th character. > > #IIF(Len(fieldname) GT 15, DE(Left(fieldname, 15) & "..."), DE(fieldname))# ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219565 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Every once in a while, I feel smart. A story of displaying a single random image.
I guess in the end it comes down to personal opinion and experience. In my opinion it is really not worth caching a query like this, lets say we are dealing with 10.000 records, and you want a random record, no way that it would be cost efficient to cache it, unless memory management is not a worry. Even when dealing with only a few records the hassle of 'caching and purging when needed' to me is not worth it, a trip to db and the query itself on MS SQL means nothing. But like I said, it's a matter of personal opinion ;-) Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Jim Davis [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 2:56 PM > To: CF-Talk > Subject: RE: Every once in a while, I feel smart. A story of > displaying a single random image. > > > > -Original Message- > > From: Taco Fleur [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 11:47 PM > > To: CF-Talk > > Subject: RE: Every once in a while, I feel smart. A story of > > displaying a single random image. > > > > Hmm, sorry to break your bubbles but both solutions are very > > inefficient. > > > > The best thing to do is (in MS SQL) > > > > SELECT TOP 1 * > > FROM yourTable > > ORDER BY NEWID() > > > > That will give you a random record every time and you are not > > transferring a whole record set over the network. > > Well... it's not really a random value (but close enough for > practical purposes). ;^) > > But forgetting that I think we're both making assumptions > about the usage. I was under the impression from the original > poster that this random image would be displayed a lot - so > using a cached query and doing what I (or the original > poster) suggested would be faster by far than forcing the > database to generate and sort GUIDS for every image every > time you want an image. > > It's really the old argument of "where" - do you do this in > CF or in the database. All the solutions presented will work > - but some work better depending on how often you use them > and how much you can cache. > > I was under the assumption that the album application would > be making use of the query information quite a bit. It would > probably be on hand cached some place. If that's the case > it's silly to make a round trip to the database to fetch > random record when you have the data already. > > But if the data's not be used elsewhere on the page or is not > cached and you're really only doing the query for a single > random image then your solution makes more sense. > > Jim Davis > > > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219564 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Every once in a while, I feel smart. A story of displaying a single random image.
> -Original Message- > From: Taco Fleur [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 11:47 PM > To: CF-Talk > Subject: RE: Every once in a while, I feel smart. A story of displaying a > single random image. > > Hmm, sorry to break your bubbles but both solutions are very inefficient. > > The best thing to do is (in MS SQL) > > SELECT TOP 1 * > FROM yourTable > ORDER BY NEWID() > > That will give you a random record every time and you are not transferring > a > whole record set over the network. Well... it's not really a random value (but close enough for practical purposes). ;^) But forgetting that I think we're both making assumptions about the usage. I was under the impression from the original poster that this random image would be displayed a lot - so using a cached query and doing what I (or the original poster) suggested would be faster by far than forcing the database to generate and sort GUIDS for every image every time you want an image. It's really the old argument of "where" - do you do this in CF or in the database. All the solutions presented will work - but some work better depending on how often you use them and how much you can cache. I was under the assumption that the album application would be making use of the query information quite a bit. It would probably be on hand cached some place. If that's the case it's silly to make a round trip to the database to fetch random record when you have the data already. But if the data's not be used elsewhere on the page or is not cached and you're really only doing the query for a single random image then your solution makes more sense. Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219563 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: getAdminHash ???
I had this before where I had actually upgraded the CFIDE to a different location. When accessing it through the browser IIS was still looking at an older version's CFIDE (The one that I should have updated). Consequently some functionality was broken. So just check that you're accessing the most up-to-date version of CFIDE. Martin Parry Macromedia Certified Developer http://www.BeetrootStreet.com";>http://www.BeetrootStreet.com -Original Message- From: Ken Ketsdever [mailto:[EMAIL PROTECTED] Sent: 28 September 2005 22:26 To: CF-Talk Subject: getAdminHash ??? The selected method getAdminHash was not found. I just ran the ms 7.01 updater and the JRun updater 6. Now when I try to get to my cf administrator I get this error. The selected method getAdminHash was not found. Either there are no methods with the specified method name and argument types, or the method getAdminHash is overloaded with arguments types that ColdFusion can't decipher reliably. If this is a Java object and you verified that the method exists, you may need to use the javacast function to reduce ambiguity. The error occurred in Application.cfm: line 128 -1 : Unable to display error's location in a CFML template. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219562 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Every once in a while, I feel smart. A story of displaying a single random image.
NEWID() creates a unique ID for every record, since its unique everytime you call it and you are ordering by this field/function, the record returned is random. Make sense? Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 2:00 PM > To: CF-Talk > Subject: RE: Every once in a while, I feel smart. A story of > displaying a single random image. > > > Being lazy and not fishing out my sql ref's - how does the > newID() work? I think this could reduce some of my code dramatically!! > > mike > > -Original Message- > From: Taco Fleur [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 3:47 p.m. > To: CF-Talk > Subject: RE: Every once in a while, I feel smart. A story of > displaying a single random image. > > > Hmm, sorry to break your bubbles but both solutions are very > inefficient. > > The best thing to do is (in MS SQL) > > SELECT TOP 1 * > FROM yourTable > ORDER BY NEWID() > > That will give you a random record every time and you are not > transferring a whole record set over the network. > > Have fun ;-) > > Taco Fleur - Pacific Fox > an industry leader with commercial IT experience since 1994 . > http://www.pacificfox.com - Web Design and Development > > > > > -Original Message- > > From: Jim Davis [mailto:[EMAIL PROTECTED] > > Sent: Thursday, 29 September 2005 1:29 PM > > To: CF-Talk > > Subject: RE: Every once in a while, I feel smart. A story of > > displaying a single random image. > > > > > > > -Original Message- > > > From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, September 28, 2005 11:11 PM > > > To: CF-Talk > > > Subject: Every once in a while, I feel smart. A story of > > displaying a > > > single random image. > > > > > > I thought I'd share this simple solution that I came up with. > > > > Great idea - nothing like some brain fuel. ;^) > > > > > I'm building a site that has a photo album as part of it. > > The image > > > data (caption, description, filename, etc.) is stored in a > > SQL Server > > > database and the image is on the server file system. > > > > > > > > > > > > Finally, and here's where the dead-simple beauty of all > > this comes in, > > > display the random image using cfloop's startrow and endrow > > using the > > > randImgRow value: > > > > > > > > endrow="#randImgRow#"> > > href="/album/default.cfm?albumid=#getrandimage.album_id#"> > > src="/images/album/#getRandImage.thumbnail#" > > > alt="#getRandImage.caption#" > > > class="thumbnail"> > > > > Just to be a jerk however... > > > > You don't actually need the loop at all. Remember that you > can access > > a query using indexed notation - so the above could be written as: > > > > > > > href="/album/default.cfm?albumid=#getrandimage.album_id[randIm > > gRow]#"> src="/images/album/#getRandImage.thumbnail[randImgRow]#" > > alt="#getRandImage.caption[randImgRow]#" > > class="thumbnail"> > > > > Of course both solutions do the exact same thing and both > access the > > query... I wouldn't be surprised to find them both about the same > > performance-wise as well. Mine is really just a little less code. > > > > I cover this in more details in my "Guide to CFML Variables" here: > > > http://www.depressedpress.com/Content/Development/ColdFusion/G uides/Vari able s/NotationIndexed.cfm Don't get me wrong tho' - I agree completely about "informational" posts like this. I wish more people would throw up snippets when they get something to work. ;^) Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219561 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Google Degrading
hmmm... i guess if i had to have the actual place's url, then i would be bothered, but as long as i get the info, i dont care the link placement nor the number as long as its easy and kinda on the first screen no scrolling. guess im just easy to please :) anyway, back to your regularly scheduled program, btw, this is WAYYY off topic. tw On 9/28/05, Lee <[EMAIL PROTECTED]> wrote: > On Wed, 28 Sep 2005 23:41:18 -0400 > Tony <[EMAIL PROTECTED]> wrote: > > not to mention this link... > > > > http://www.google.com/search?q=ruth%27s+chris+scottsdale&sourceid=mozilla-search&start=0&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official > > > > It's highly likely they are paying. Try The Lookout > Maple Grove which is a dive bar in Maple Grove MN. It's > the sixth or so down which is better than average. > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219560 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Every once in a while, I feel smart. A story of displaying a single random image.
Being lazy and not fishing out my sql ref's - how does the newID() work? I think this could reduce some of my code dramatically!! mike -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Thursday, 29 September 2005 3:47 p.m. To: CF-Talk Subject: RE: Every once in a while, I feel smart. A story of displaying a single random image. Hmm, sorry to break your bubbles but both solutions are very inefficient. The best thing to do is (in MS SQL) SELECT TOP 1 * FROM yourTable ORDER BY NEWID() That will give you a random record every time and you are not transferring a whole record set over the network. Have fun ;-) Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Jim Davis [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 1:29 PM > To: CF-Talk > Subject: RE: Every once in a while, I feel smart. A story of > displaying a single random image. > > > > -Original Message- > > From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 11:11 PM > > To: CF-Talk > > Subject: Every once in a while, I feel smart. A story of > displaying a > > single random image. > > > > I thought I'd share this simple solution that I came up with. > > Great idea - nothing like some brain fuel. ;^) > > > I'm building a site that has a photo album as part of it. > The image > > data (caption, description, filename, etc.) is stored in a > SQL Server > > database and the image is on the server file system. > > > > > > > > Finally, and here's where the dead-simple beauty of all > this comes in, > > display the random image using cfloop's startrow and endrow > using the > > randImgRow value: > > > > > endrow="#randImgRow#"> > href="/album/default.cfm?albumid=#getrandimage.album_id#"> > src="/images/album/#getRandImage.thumbnail#" > > alt="#getRandImage.caption#" > > class="thumbnail"> > > Just to be a jerk however... > > You don't actually need the loop at all. Remember that you > can access a query using indexed notation - so the above > could be written as: > > > href="/album/default.cfm?albumid=#getrandimage.album_id[randIm > gRow]#"> src="/images/album/#getRandImage.thumbnail[randImgRow]#" > alt="#getRandImage.caption[randImgRow]#" > class="thumbnail"> > > Of course both solutions do the exact same thing and both > access the query... I wouldn't be surprised to find them both > about the same performance-wise as well. Mine is really just > a little less code. > > I cover this in more details in my "Guide to CFML Variables" here: > http://www.depressedpress.com/Content/Development/ColdFusion/Guides/Vari able s/NotationIndexed.cfm Don't get me wrong tho' - I agree completely about "informational" posts like this. I wish more people would throw up snippets when they get something to work. ;^) Jim Davis ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219559 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Google Degrading
On Wed, 28 Sep 2005 23:41:18 -0400 Tony <[EMAIL PROTECTED]> wrote: > not to mention this link... > > http://www.google.com/search?q=ruth%27s+chris+scottsdale&sourceid=mozilla-search&start=0&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official > It's highly likely they are paying. Try The Lookout Maple Grove which is a dive bar in Maple Grove MN. It's the sixth or so down which is better than average. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219558 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Every once in a while, I feel smart. A story of displaying a single random image.
Hmm, sorry to break your bubbles but both solutions are very inefficient. The best thing to do is (in MS SQL) SELECT TOP 1 * FROM yourTable ORDER BY NEWID() That will give you a random record every time and you are not transferring a whole record set over the network. Have fun ;-) Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Jim Davis [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 1:29 PM > To: CF-Talk > Subject: RE: Every once in a while, I feel smart. A story of > displaying a single random image. > > > > -Original Message- > > From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 11:11 PM > > To: CF-Talk > > Subject: Every once in a while, I feel smart. A story of > displaying a > > single random image. > > > > I thought I'd share this simple solution that I came up with. > > Great idea - nothing like some brain fuel. ;^) > > > I'm building a site that has a photo album as part of it. > The image > > data (caption, description, filename, etc.) is stored in a > SQL Server > > database and the image is on the server file system. > > > > > > > > Finally, and here's where the dead-simple beauty of all > this comes in, > > display the random image using cfloop's startrow and endrow > using the > > randImgRow value: > > > > > endrow="#randImgRow#"> > href="/album/default.cfm?albumid=#getrandimage.album_id#"> > src="/images/album/#getRandImage.thumbnail#" > > alt="#getRandImage.caption#" > > class="thumbnail"> > > Just to be a jerk however... > > You don't actually need the loop at all. Remember that you > can access a query using indexed notation - so the above > could be written as: > > > href="/album/default.cfm?albumid=#getrandimage.album_id[randIm > gRow]#"> src="/images/album/#getRandImage.thumbnail[randImgRow]#" > alt="#getRandImage.caption[randImgRow]#" > class="thumbnail"> > > Of course both solutions do the exact same thing and both > access the query... I wouldn't be surprised to find them both > about the same performance-wise as well. Mine is really just > a little less code. > > I cover this in more details in my "Guide to CFML Variables" here: > http://www.depressedpress.com/Content/Development/ColdFusion/Guides/Variable s/NotationIndexed.cfm Don't get me wrong tho' - I agree completely about "informational" posts like this. I wish more people would throw up snippets when they get something to work. ;^) Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219557 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Google Degrading
not to mention this link... http://www.google.com/search?q=ruth%27s+chris+scottsdale&sourceid=mozilla-search&start=0&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official or http://www.antiwrap.com/?727 was simply "ruth's chris scottsdale" and it takes me to a perfect page, on result one.. for all the information i could need. whats wrong with that? tw On 9/28/05, Lee <[EMAIL PROTECTED]> wrote: > Never mind. I just finally clicked on the More button and > selected Directory and it worked. I guess things are > getting a bit more refined. > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219556 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Google Degrading
Never mind. I just finally clicked on the More button and selected Directory and it worked. I guess things are getting a bit more refined. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219555 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Every once in a while, I feel smart. A story of displaying a single random image.
> -Original Message- > From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 11:11 PM > To: CF-Talk > Subject: Every once in a while, I feel smart. A story of displaying a > single random image. > > I thought I'd share this simple solution that I came up with. Great idea - nothing like some brain fuel. ;^) > I'm building a site that has a photo album as part of it. The image > data (caption, description, filename, etc.) is stored in a SQL Server > database and the image is on the server file system. > > > > Finally, and here's where the dead-simple beauty of all this comes in, > display the random image using cfloop's startrow and endrow using the > randImgRow value: > > endrow="#randImgRow#"> href="/album/default.cfm?albumid=#getrandimage.album_id#"> src="/images/album/#getRandImage.thumbnail#" > alt="#getRandImage.caption#" > class="thumbnail"> Just to be a jerk however... You don't actually need the loop at all. Remember that you can access a query using indexed notation - so the above could be written as: Of course both solutions do the exact same thing and both access the query... I wouldn't be surprised to find them both about the same performance-wise as well. Mine is really just a little less code. I cover this in more details in my "Guide to CFML Variables" here: http://www.depressedpress.com/Content/Development/ColdFusion/Guides/Variable s/NotationIndexed.cfm Don't get me wrong tho' - I agree completely about "informational" posts like this. I wish more people would throw up snippets when they get something to work. ;^) Jim Davis ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219554 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Google Degrading
Didn't those die around the same time as VCR's? !k - Original Message - From: "Emmet McGovern" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, September 28, 2005 8:43 PM Subject: RE: Google Degrading >I think it's called Phone Book. I've personally never seen one though. > > Emmet > > -Original Message- > From: Lee [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 10:34 PM > To: CF-Talk > Subject: OT: Google Degrading > > Has anyone else noticed that Google is become less > effective? If you type in a say a restaurant hoping to get > their home page you get get dozens of restaurant listing > pages and no main page even though it exists. This is > unforgivable. Is there a service out there that is better > for the basics? > > Lee > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219553 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Every once in a while, I feel smart. A story of displaying a single random image.
I thought I'd share this simple solution that I came up with (though I'm sure someone else has done it beforejust as I'm sure there are better ways of doing this). I'm building a site that has a photo album as part of it. The image data (caption, description, filename, etc.) is stored in a SQL Server database and the image is on the server file system. On the front page I wanted to display a single random image. The problem is, how to grab a truly random image? What I did was first run a query that grabbed all of the active images in the database: SELECT P.caption, P.album_id, P.thumbnail FROMtblPhotos P WHERE P.active = 1 Next, by using randRange, the number 1, and the recordcount of the above query, I generate a random number: Finally, and here's where the dead-simple beauty of all this comes in, display the random image using cfloop's startrow and endrow using the randImgRow value: That's it. There's a tendancy for people to bring problems seeking answers to this list, I thought just once I'd share a solution waiting for a problem. Pete ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219552 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Google Degrading
> -Original Message- > From: Lee [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 10:34 PM > To: CF-Talk > Subject: OT: Google Degrading > > Has anyone else noticed that Google is become less > effective? If you type in a say a restaurant hoping to get > their home page you get get dozens of restaurant listing > pages and no main page even though it exists. This is > unforgivable. Is there a service out there that is better > for the basics? It sounds like you're lamenting the difference between a search service and a directory service. Yahoo.com is still the best directory, in my opinion. Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219551 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Google Degrading
I think it's called Phone Book. I've personally never seen one though. Emmet -Original Message- From: Lee [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 10:34 PM To: CF-Talk Subject: OT: Google Degrading Has anyone else noticed that Google is become less effective? If you type in a say a restaurant hoping to get their home page you get get dozens of restaurant listing pages and no main page even though it exists. This is unforgivable. Is there a service out there that is better for the basics? Lee ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219550 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Google Degrading
Has anyone else noticed that Google is become less effective? If you type in a say a restaurant hoping to get their home page you get get dozens of restaurant listing pages and no main page even though it exists. This is unforgivable. Is there a service out there that is better for the basics? Lee ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219549 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Idea for better hosting
The original post is set in some bizarre dream world. Clustering bad code just means bad code running on 3 servers. Let's look at the costs anyway. We'll cut corners when we can and look at sticky sessions on standard cf licenses too. ---WINDOWS--- Servers x 3 $4200 - $6600 Windows Server 2003, Standard Edition x3$2,997 CF Enterprise x3$17,997 --- TOTAL: $25,194 - $27,594 Servers x 3 $4200 - $6600 Windows Server 2003, Web Edition x3 $1,200 CF Standard x3 $3,897 --- TOTAL: $9,297 - $11,697 ---LINUX--- Servers x 3 $4200 - $6600 Redhat Linux ES x3 $1,047 CF Enterprise x3$17,997 --- TOTAL: $23,244 - $25,644 Servers x 3 $4200 - $6600 FEDORA x3 $FREE CF Standard x3 $3,897 --- TOTAL: $8,097 - $10,497 So you can budget for $8,097 - $27,594 With 400 clients at $15-$30 a month you get $6,000 - $12,000 a month. I'm frickin RICH BIATCH! Lease me a BMW! except... Now you need a way to load balance. Hardware - $3000-$1 Software NLB - $FREE Damn... Your rack is filling up fast. $1200-2000 per month per rack. Holy crap! We're out of room on the switch again. $600 File replication shut down again. Wheres Larry the tech? - $30-$80k salary $%#&! CRC errors on the NLB!!! Where's Larry's brother Larry? $30-$80k yr Sally from Sallysellsseashells.com can't get her mail. Support - $24-$35 yr These expenses are killing us. Where's Rich the sales guy? - $24k base YAY!!! Were growing! We need to hire some more people. Shit. I just missed the lease payment on my BMW. DAMN YOU COLDFUSION Takin the bus to the office (if I could afford the office), Emmet ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219548 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFPOP errors
Cedric Villat wrote: > Any ideas on the encoding issue? Is there something to test with or debug on > this one? first see if Big5 is part of your JDK. http://www.sustainablegis.com/projects/i18n/charsetTB.cfm did you change the JDK that cf uses? did you upgrade from 6.0? if so search the cf install dir for an i18n.jar, stop cfserver service, copy the i18n jar out, restart the cfserver service. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219547 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Verity Collections after Updater 7.0.1
Nevermind... apparently I can't create collections unless Clearcase can phone home to its license server. Even though it has nothing to do with Verity... Weird... Jeff -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 5:31 PM To: CF-Talk Subject: Verity Collections after Updater 7.0.1 Anyone tried creating a verity collection after installing the updater? Mine is apparently quite broken now. Error Reading Collection information: com.verity.api.administration. Configuration Exception: java.io.IOException: Read timed out Even re-installed ColdFusion and re-applied the Updater. Getting the same error. Jeff Garza ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219546 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Verity Collections after Updater 7.0.1
Anyone tried creating a verity collection after installing the updater? Mine is apparently quite broken now. Error Reading Collection information: com.verity.api.administration. Configuration Exception: java.io.IOException: Read timed out Even re-installed ColdFusion and re-applied the Updater. Getting the same error. Jeff Garza ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219545 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Idea for better hosting
Mark A Kruger wrote: >In addition, the margins on hosting are >very small - and you just added extra admin :) > >-Mark > > This would be my comment as well. Hosting is a tough, tough market. It could take up to 2 years for a hosting company to see ROI on it's server investments. The last thing we need is additional hardware costs to push that ROI point even farther back. Instead of load balancing, Vivio chose the VPS route. That way one account doesn't effect the other. They're all separated at the core level. Combine that with the liberal license and power of Linux, and you have yourself an affordable, stable, and secure place to develop and run your sites. As a developer, I firmly believe that Vivio's hosting accounts are the best available. I might be slightly biased though... ;) -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219544 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Idea for better hosting
Mark, I know where the jrun message comes from, thanks but thats irrelevant. Clients dont care why theres a jrun message. They just are pissed that there is one and that there isnt a site. Its an extremely competitive market and any differentiation can be the difference between breaking even and making profit. Just an idea. DRE On 9/28/05, Mark A Kruger <[EMAIL PROTECTED]> wrote: > > Plus - some of the code I have seen would have the potential of bringing > down 2 servers for the price of 1. In addition, the margins on hosting are > very small - and you just added extra admin :) > > -Mark > > P.S. When you get that JRUN message, don't blame the messenger - Usually > it > is either underdeveloped database programming or other poorly written > code. > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219543 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can CF interact with mainframe?
We just finished a project that interfaced with an HP3000 using a 3rd party driver that "mimicked" ODBC calls to the HP. -mk On Sep 28, 2005, at 3:49 PM, Maloy wrote: > I have a basic question: Is there any way to run Cold Fusion on > mainframe > like MVS or OS/390 operating system. > if not, is there a way in which these can interact even when > Coldfusion runs > on a Windows or Unix server? > > Please let me know. > TIA > Maloy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219542 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can CF interact with mainframe?
Have a look at Mitem http://www.mitem.com/solutions/default.asp It's been years since I looked at their stuff-- but they specialize in interfaceware-- software solutions that allow incompatible systems to communicate and exchange data. I am sure its come a long way, but in the mid-80's they had a software program running on a PC or Mac that interfaced legacy apps on an IBM mainframe running CICS & DL/I by appearing as a very fast & unlimited storage 3270 terminal. No changes were required to the mainframe or software. Now, this interface software was programmable at a high level (similar to RPG) and at a low level. The interface program could talk to any of the software (databases, spreadsheets, etc) available on the PC & Macs. And/or, it could talk other mainframes running other unmodified mainframe systems. I had a 16 plus year background at IBM, specializing in mainframe database & data communication and migration from DOS to MVS. I was blown away when I saw this software running on a Mac, interfacing multiple mainframes and passing data between them. This was before the web, web services, XML, etc. Dick On Sep 28, 2005, at 3:49 PM, Maloy wrote: > I have a basic question: Is there any way to run Cold Fusion on > mainframe > like MVS or OS/390 operating system. > if not, is there a way in which these can interact even when > Coldfusion runs > on a Windows or Unix server? > > Please let me know. > TIA > Maloy ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219541 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFPOP errors
Paul, I thought I was locking, but I just checked and it was commented out. Doh. I'll see if adding it back makes the RemovedException error go away. Any ideas on the encoding issue? Is there something to test with or debug on this one? Cedric >Are you using CFLOCK to make each account access single threaded? > >Something like > > > > > > > > > > > >That way if a user requests the page twice, the getheaders and delete calls >won't tread on each others toes... That should fix your issue with the >MessageRemovedException errors you're getting. > >Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219540 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Can CF interact with mainframe?
I have a basic question: Is there any way to run Cold Fusion on mainframe like MVS or OS/390 operating system. if not, is there a way in which these can interact even when Coldfusion runs on a Windows or Unix server? Please let me know. TIA Maloy ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219539 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Idea for better hosting
Russ, Certainly its not a good solution for access but by far the greatest point of failure for most shared hosting sites I've seen is coldfusion running out of resources. If we could stamp that out for everything but access and filebased state managment, we'd be ahead. Or at least those of us who sometimes develop sites that go on overextended shared hosts would be. Any host that would do this would be at an instant competitive advantage with minimal additional cost. Taco, Not aimed at you. I randomly used one of your messages and changed the subject. DRE On 9/28/05, Russ <[EMAIL PROTECTED]> wrote: > > The problem with that would be where to put the database. If the database > is an msaccess, or any other database running on the local machine, this > could prove difficult. If it's a shared database on a different server, > then that becomes the single point of failure. > > -Original Message- > From: DRE [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 5:33 PM > To: CF-Talk > Subject: Idea for better hosting > > Hey, I just had an idea for you guys working at hosting companies. > > Instead of just running each site on one server where its depenedent on > all > the other sites workign well, why not load balance between 2 or 3 servers. > If you think about it, it shouldnt cost more because you'd be able to put > twice as many sites on each machine because the load would be that > proportion smaller(other than the loadbalancer). If one goes south, then > the > load balancing would work while you reboot the machine. All you'd have to > do > is setup some sort of directory watching so that the user would only have > to > maintain files on one machine. Presto, no more stupid "the jrun service is > unavailable" messages. > > DRE > > On 9/28/05, Taco Fleur <[EMAIL PROTECTED]> wrote: > > > > The idea works, I have it implemented in several places. > > Any more details as why it didn't work for you? > > > > Taco Fleur - Pacific Fox > > an industry leader with commercial IT experience since 1994 . > > http://www.pacificfox.com - Web Design and Development > > > > > > > > > -Original Message- > > > From: Matthew Small [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, 29 September 2005 6:58 AM > > > To: CF-Talk > > > Subject: RE: SQL row select? > > > > > > > > > Not only the IN method work, but yours did not, at least on > > > MSSQL. I tried it. > > > > > > Now that's not necessarily the most efficient solution > > > around, but if you have millions and millions of records to > > > parse through with CF, then you need a DBA to ensure proper > > > indexing and all that jazz, so you can let him write it. > > > > > > > > > Matthew Small > > > Web Developer > > > American City Business Journals > > > 704-973-1045 > > > [EMAIL PROTECTED] > > > > > > > > > -Original Message- > > > From: Taco Fleur [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, September 28, 2005 4:24 PM > > > To: CF-Talk > > > Subject: RE: SQL row select? > > > > > > I would not expect an answer like that from a proper DBA. > > > > > > Not sure if we are talking about MS SQL or MySQL, but the > > > idea is to work with subqueries. > > > > > > SELECT * > > > FROM ( > > > SELECT * TOP 20 > > > FROM (SELECT TOP (200 + 20) yourColumn1, yourColumn2 > > > FROM yourTable C > > > ORDER BY C.yourOrderColumn ASC) B > > > ORDER BY B.yourOrderColumn DESC ) A > > > ORDER BY A.yourOrderColumn ASC > > > > > > Where 200 is for example the current row you are on and 20 is > > > the number of records you want to retrieve. The idea is to > > > first get TOP currentRow + numberOfRowToRetrieve Then order > > > descending and get the top 20 Then order ascending and select all > > > > > > This way you only transfer from the DB over the network what > > > you need to, and the query is not inefficient, especially if > > > you got the right indexes. > > > > > > Now, its early here, so I might have made a mistake, but you > > > get the general idea. I think the previous sample with IN > > > does not work, especially not efficient. > > > > > > > > > Taco Fleur - Pacific Fox > > > an industry leader with commercial IT experience since 1994 . > > > http://www.pacificfox.com - Web Design and Development > > > > > > > > > > > > > -Original Message- > > > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > > > Sent: Thursday, 29 September 2005 2:25 AM > > > > To: CF-Talk > > > > Subject: RE: SQL row select? > > > > > > > > > > > > Here's a post from a DBA I'm friends with: > > > > > > > > > > > > Just pull the entire query over to CF and use query of > > > > queries, to grab > > > > your "paged" row sets. I work with record sets of millions > > > > and it works > > > > very nicely. > > > > > > > > > > > > > > > andy matthews > > > > web developer > > > > ICGLink, Inc. > > > > [EMAIL PROTECTED] > > > > 615.370.1530 x737 > > > > --//-> > > > > > > > > -Original Message- > > > > From: Greg Morphis [mailto:[EMAIL
RE: SQL row select?
> There were a couple typos, but it works rather nicely. Try > > SELECT * > FROM ( > SELECT TOP 20 * > FROM (SELECT TOP 220 * > FROM table C > ORDER BY C.column ASC) B > ORDER BY B.column DESC ) A > ORDER BY A.column ASC Ahh I see, I put the * infront of TOP Also, you probably want to put this as a stored procedure and pass in the parameters @curentPage INT, @rowPerPage INT SELECT * FROM ( SELECT TOP 20 * FROM (SELECT TOP ( ( @rowPerPage * @curentPage ) + @rowPerPage ) yourColumn1, yourColumn2 FROM yourTable C ORDER BY C.yourOrderColumn ASC) B ORDER BY B.yourOrderColumn DESC ) A ORDER BY A.yourOrderColumn ASC Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219537 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Order by number of articles (count?)
Hi Robert, When i tried your one I had this error coming up: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Column 'tbl_020authorDetails.authorID' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause. Thanks, Stuart On 28 Sep 2005, at 23:20, Robert Munn wrote: > > SELECT SELECT COUNT > (tbl_020articleDetails.articleID) AS totalArticles, > tbl_020authorDetails.authorID, > authorPhotograph, authorFirstName, authorSurname, authorAboutMe, > tbl_020articleDetails.articleID, tbl_020articleDetails.authorID, > articleTitle, articleDatePublishedLast > FROM tbl_020authorDetails, tbl_020articleDetails > WHERE authorPhotograph <> ' ' AND > tbl_020articleDetails.authorID = tbl_020authorDetails.authorID AND > tbl_020articleDetails.articleAuthenticated = 1 AND > tbl_020articleDetails.articleSubTypeID <> 55 AND > tbl_020articleDetails.articleSubTypeID <> 68 > ORDER BY COUNT(tbl_020articleDetails.articleID), > tbl_020authorDetails.authorFirstName, > articleDatePublishedLast DESC > Stu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219536 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Idea for better hosting
Plus - some of the code I have seen would have the potential of bringing down 2 servers for the price of 1. In addition, the margins on hosting are very small - and you just added extra admin :) -Mark P.S. When you get that JRUN message, don't blame the messenger - Usually it is either underdeveloped database programming or other poorly written code. -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 5:16 PM To: CF-Talk Subject: RE: Idea for better hosting The problem with that would be where to put the database. If the database is an msaccess, or any other database running on the local machine, this could prove difficult. If it's a shared database on a different server, then that becomes the single point of failure. -Original Message- From: DRE [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 5:33 PM To: CF-Talk Subject: Idea for better hosting Hey, I just had an idea for you guys working at hosting companies. Instead of just running each site on one server where its depenedent on all the other sites workign well, why not load balance between 2 or 3 servers. If you think about it, it shouldnt cost more because you'd be able to put twice as many sites on each machine because the load would be that proportion smaller(other than the loadbalancer). If one goes south, then the load balancing would work while you reboot the machine. All you'd have to do is setup some sort of directory watching so that the user would only have to maintain files on one machine. Presto, no more stupid "the jrun service is unavailable" messages. DRE On 9/28/05, Taco Fleur <[EMAIL PROTECTED]> wrote: > > The idea works, I have it implemented in several places. > Any more details as why it didn't work for you? > > Taco Fleur - Pacific Fox > an industry leader with commercial IT experience since 1994 . > http://www.pacificfox.com - Web Design and Development > > > > > -Original Message- > > From: Matthew Small [mailto:[EMAIL PROTECTED] > > Sent: Thursday, 29 September 2005 6:58 AM > > To: CF-Talk > > Subject: RE: SQL row select? > > > > > > Not only the IN method work, but yours did not, at least on > > MSSQL. I tried it. > > > > Now that's not necessarily the most efficient solution > > around, but if you have millions and millions of records to > > parse through with CF, then you need a DBA to ensure proper > > indexing and all that jazz, so you can let him write it. > > > > > > Matthew Small > > Web Developer > > American City Business Journals > > 704-973-1045 > > [EMAIL PROTECTED] > > > > > > -Original Message- > > From: Taco Fleur [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 4:24 PM > > To: CF-Talk > > Subject: RE: SQL row select? > > > > I would not expect an answer like that from a proper DBA. > > > > Not sure if we are talking about MS SQL or MySQL, but the > > idea is to work with subqueries. > > > > SELECT * > > FROM ( > > SELECT * TOP 20 > > FROM (SELECT TOP (200 + 20) yourColumn1, yourColumn2 > > FROM yourTable C > > ORDER BY C.yourOrderColumn ASC) B > > ORDER BY B.yourOrderColumn DESC ) A > > ORDER BY A.yourOrderColumn ASC > > > > Where 200 is for example the current row you are on and 20 is > > the number of records you want to retrieve. The idea is to > > first get TOP currentRow + numberOfRowToRetrieve Then order > > descending and get the top 20 Then order ascending and select all > > > > This way you only transfer from the DB over the network what > > you need to, and the query is not inefficient, especially if > > you got the right indexes. > > > > Now, its early here, so I might have made a mistake, but you > > get the general idea. I think the previous sample with IN > > does not work, especially not efficient. > > > > > > Taco Fleur - Pacific Fox > > an industry leader with commercial IT experience since 1994 . > > http://www.pacificfox.com - Web Design and Development > > > > > > > > > -Original Message- > > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, 29 September 2005 2:25 AM > > > To: CF-Talk > > > Subject: RE: SQL row select? > > > > > > > > > Here's a post from a DBA I'm friends with: > > > > > > > > > Just pull the entire query over to CF and use query of > > > queries, to grab > > > your "paged" row sets. I work with record sets of millions > > > and it works > > > very nicely. > > > > > > > > > > > andy matthews > > > web developer > > > ICGLink, Inc. > > > [EMAIL PROTECTED] > > > 615.370.1530 x737 > > > --//-> > > > > > > -Original Message- > > > From: Greg Morphis [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, September 28, 2005 10:59 AM > > > To: CF-Talk > > > Subject: Re: SQL row select? > > > > > > > > > Select top 50 * from table > > > Where id not in > > > > > > ( select top 199 id from table > > > order by date, alpha) > > > > > > order by date, alpha > > > > > > that works but what if you are paging through a mil
Re: Order by number of articles (count?)
You have to use COUNT() in SELECT and ORDER BY. Try this: SELECT SELECT COUNT(tbl_020articleDetails.articleID) AS totalArticles, tbl_020authorDetails.authorID, authorPhotograph, authorFirstName, authorSurname, authorAboutMe, tbl_020articleDetails.articleID, tbl_020articleDetails.authorID, articleTitle, articleDatePublishedLast FROM tbl_020authorDetails, tbl_020articleDetails WHERE authorPhotograph <> ' ' AND tbl_020articleDetails.authorID = tbl_020authorDetails.authorID AND tbl_020articleDetails.articleAuthenticated = 1 AND tbl_020articleDetails.articleSubTypeID <> 55 AND tbl_020articleDetails.articleSubTypeID <> 68 ORDER BY COUNT(tbl_020articleDetails.articleID), tbl_020authorDetails.authorFirstName, articleDatePublishedLast DESC ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219534 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Idea for better hosting
The problem with that would be where to put the database. If the database is an msaccess, or any other database running on the local machine, this could prove difficult. If it's a shared database on a different server, then that becomes the single point of failure. -Original Message- From: DRE [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 5:33 PM To: CF-Talk Subject: Idea for better hosting Hey, I just had an idea for you guys working at hosting companies. Instead of just running each site on one server where its depenedent on all the other sites workign well, why not load balance between 2 or 3 servers. If you think about it, it shouldnt cost more because you'd be able to put twice as many sites on each machine because the load would be that proportion smaller(other than the loadbalancer). If one goes south, then the load balancing would work while you reboot the machine. All you'd have to do is setup some sort of directory watching so that the user would only have to maintain files on one machine. Presto, no more stupid "the jrun service is unavailable" messages. DRE On 9/28/05, Taco Fleur <[EMAIL PROTECTED]> wrote: > > The idea works, I have it implemented in several places. > Any more details as why it didn't work for you? > > Taco Fleur - Pacific Fox > an industry leader with commercial IT experience since 1994 . > http://www.pacificfox.com - Web Design and Development > > > > > -Original Message- > > From: Matthew Small [mailto:[EMAIL PROTECTED] > > Sent: Thursday, 29 September 2005 6:58 AM > > To: CF-Talk > > Subject: RE: SQL row select? > > > > > > Not only the IN method work, but yours did not, at least on > > MSSQL. I tried it. > > > > Now that's not necessarily the most efficient solution > > around, but if you have millions and millions of records to > > parse through with CF, then you need a DBA to ensure proper > > indexing and all that jazz, so you can let him write it. > > > > > > Matthew Small > > Web Developer > > American City Business Journals > > 704-973-1045 > > [EMAIL PROTECTED] > > > > > > -Original Message- > > From: Taco Fleur [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 4:24 PM > > To: CF-Talk > > Subject: RE: SQL row select? > > > > I would not expect an answer like that from a proper DBA. > > > > Not sure if we are talking about MS SQL or MySQL, but the > > idea is to work with subqueries. > > > > SELECT * > > FROM ( > > SELECT * TOP 20 > > FROM (SELECT TOP (200 + 20) yourColumn1, yourColumn2 > > FROM yourTable C > > ORDER BY C.yourOrderColumn ASC) B > > ORDER BY B.yourOrderColumn DESC ) A > > ORDER BY A.yourOrderColumn ASC > > > > Where 200 is for example the current row you are on and 20 is > > the number of records you want to retrieve. The idea is to > > first get TOP currentRow + numberOfRowToRetrieve Then order > > descending and get the top 20 Then order ascending and select all > > > > This way you only transfer from the DB over the network what > > you need to, and the query is not inefficient, especially if > > you got the right indexes. > > > > Now, its early here, so I might have made a mistake, but you > > get the general idea. I think the previous sample with IN > > does not work, especially not efficient. > > > > > > Taco Fleur - Pacific Fox > > an industry leader with commercial IT experience since 1994 . > > http://www.pacificfox.com - Web Design and Development > > > > > > > > > -Original Message- > > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, 29 September 2005 2:25 AM > > > To: CF-Talk > > > Subject: RE: SQL row select? > > > > > > > > > Here's a post from a DBA I'm friends with: > > > > > > > > > Just pull the entire query over to CF and use query of > > > queries, to grab > > > your "paged" row sets. I work with record sets of millions > > > and it works > > > very nicely. > > > > > > > > > > > andy matthews > > > web developer > > > ICGLink, Inc. > > > [EMAIL PROTECTED] > > > 615.370.1530 x737 > > > --//-> > > > > > > -Original Message- > > > From: Greg Morphis [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, September 28, 2005 10:59 AM > > > To: CF-Talk > > > Subject: Re: SQL row select? > > > > > > > > > Select top 50 * from table > > > Where id not in > > > > > > ( select top 199 id from table > > > order by date, alpha) > > > > > > order by date, alpha > > > > > > that works but what if you are paging through a million > > > records as suggested before? wouldnt the inner query select > > > the top 999,999 rows? IE > > > > > > Select top 50 * from table > > > Where id not in > > > ( > > > select top 99 id from table > > > order by date, alpha > > > ) > > > order by date, alpha > > > > > > > > > I think thats what Mike K was talking about. > > > > > > > > > > > > On 9/28/05, Andy Matthews <[EMAIL PROTECTED]> wrote: > > > > Did no one see this post? After reading, and re-reading the > > > original > > > > post, it lo
RE: CFPOP errors
Are you using CFLOCK to make each account access single threaded? Something like That way if a user requests the page twice, the getheaders and delete calls won't tread on each others toes... That should fix your issue with the MessageRemovedException errors you're getting. Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219532 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL row select?
There were a couple typos, but it works rather nicely. Try SELECT * FROM ( SELECT TOP 20 * FROM (SELECT TOP 220 * FROM table C ORDER BY C.column ASC) B ORDER BY B.column DESC ) A ORDER BY A.column ASC Mike -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 4:09 PM To: CF-Talk Subject: RE: SQL row select? Yup, tested it, works like a charm here mate. So unless you provide any more input as to why you think it doesn't work I won't be able to help you out. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Matthew Small [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 6:58 AM > To: CF-Talk > Subject: RE: SQL row select? > > > Not only the IN method work, but yours did not, at least on > MSSQL. I tried it. > > Now that's not necessarily the most efficient solution > around, but if you have millions and millions of records to > parse through with CF, then you need a DBA to ensure proper > indexing and all that jazz, so you can let him write it. > > > Matthew Small > Web Developer > American City Business Journals > 704-973-1045 > [EMAIL PROTECTED] > > > -Original Message- > From: Taco Fleur [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 4:24 PM > To: CF-Talk > Subject: RE: SQL row select? > > I would not expect an answer like that from a proper DBA. > > Not sure if we are talking about MS SQL or MySQL, but the > idea is to work with subqueries. > > SELECT * > FROM ( > SELECT * TOP 20 > FROM (SELECT TOP (200 + 20) yourColumn1, yourColumn2 > FROM yourTable C > ORDER BY C.yourOrderColumn ASC) B > ORDER BY B.yourOrderColumn DESC ) A > ORDER BY A.yourOrderColumn ASC > > Where 200 is for example the current row you are on and 20 is > the number of records you want to retrieve. The idea is to > first get TOP currentRow + numberOfRowToRetrieve Then order > descending and get the top 20 Then order ascending and select all > > This way you only transfer from the DB over the network what > you need to, and the query is not inefficient, especially if > you got the right indexes. > > Now, its early here, so I might have made a mistake, but you > get the general idea. I think the previous sample with IN > does not work, especially not efficient. > > > Taco Fleur - Pacific Fox > an industry leader with commercial IT experience since 1994 . > http://www.pacificfox.com - Web Design and Development > > > > > -Original Message- > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > Sent: Thursday, 29 September 2005 2:25 AM > > To: CF-Talk > > Subject: RE: SQL row select? > > > > > > Here's a post from a DBA I'm friends with: > > > > > > Just pull the entire query over to CF and use query of > > queries, to grab > > your "paged" row sets. I work with record sets of millions > > and it works > > very nicely. > > > > > > > andy matthews > > web developer > > ICGLink, Inc. > > [EMAIL PROTECTED] > > 615.370.1530 x737 > > --//-> > > > > -Original Message- > > From: Greg Morphis [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 10:59 AM > > To: CF-Talk > > Subject: Re: SQL row select? > > > > > > Select top 50 * from table > > Where id not in > > > > ( select top 199 id from table > >order by date, alpha) > > > > order by date, alpha > > > > that works but what if you are paging through a million > > records as suggested before? wouldnt the inner query select > > the top 999,999 rows? IE > > > > Select top 50 * from table > > Where id not in > > ( > >select top 99 id from table > >order by date, alpha > > ) > > order by date, alpha > > > > > > I think thats what Mike K was talking about. > > > > > > > > On 9/28/05, Andy Matthews <[EMAIL PROTECTED]> wrote: > > > Did no one see this post? After reading, and re-reading the > > original > > > post, it looks like this simple SQL statement is the answer > > (assuming > > > that MSSQL supports the LIMIT clause: > > > > > > SELECT * > > > FROM tablename > > > LIMIT #startrow#, #totalrecords# > > > > > > or > > > > > > SELECT * > > > FROM tablename > > > LIMIT 200, 50 > > > > > > > > andy matthews > > > web developer > > > ICGLink, Inc. > > > [EMAIL PROTECTED] > > > 615.370.1530 x737 > > > --//-> > > > > > > -Original Message- > > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, September 28, 2005 8:57 AM > > > To: CF-Talk > > > Subject: RE: SQL row select? > > > > > > > > > I don't use MS SQL but doesn't it support the LIMIT keyword in the > > > SELECT statement? > > > > > > SELECT * > > > FROM tablename > > > LIMIT #startrow#, #totalrecords# > > > > > > or > > > > > > SELECT * > > > FROM tablename > > > LIMIT 200, 50 > > > > > > > > andy matthews > > > web developer > > > ICGLink, Inc. > > > [EMAIL PROTECTED] > > > 615.37
Undocumented Coldfusion MX7 Issue - Database Isolation Level Changed!
The default isolation level for CFMX7 after applying the client variable patch is "serializeable". Macromedia expresses that serializeable transactions are not optimal for data access (see ) yet that is the new default. Read Macromedia's text on the subject: "serializable: places an exclusive lock on every data table in use for the duration of the transaction. Causes access to the database to be single-threaded and is therefore not recommended for normal database access." Prior to the client variable fix, the default was "read-committed". Can I reset a datasource to be "read_committed" (via neo-query.xml or otherwise) or is my only option to wrap each query in a and punt. I have added neo-query.xml to the connectionprops element the following: READ_COMMITTED to no avail. Is there a workaround for MX7? I will be greatly appreciative for a reply. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219530 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Idea for better hosting
Just curious, is this post in any way directed to us? Just asking because it seems you replied to a post I wrote. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: DRE [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 7:33 AM > To: CF-Talk > Subject: Idea for better hosting > > > Hey, I just had an idea for you guys working at hosting companies. > > Instead of just running each site on one server where its > depenedent on all the other sites workign well, why not load > balance between 2 or 3 servers. If you think about it, it > shouldnt cost more because you'd be able to put twice as many > sites on each machine because the load would be that > proportion smaller(other than the loadbalancer). If one goes > south, then the load balancing would work while you reboot > the machine. All you'd have to do is setup some sort of > directory watching so that the user would only have to > maintain files on one machine. Presto, no more stupid "the > jrun service is unavailable" messages. > > DRE > > On 9/28/05, Taco Fleur <[EMAIL PROTECTED]> wrote: > > > > The idea works, I have it implemented in several places. > > Any more details as why it didn't work for you? > > > > Taco Fleur - Pacific Fox > > an industry leader with commercial IT experience since 1994 . > > http://www.pacificfox.com - Web Design and Development > > > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219529 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Order by number of articles (count?)
"INNER tbl_020articleDetails b" should be: "INNER JOIN tbl_020articleDetails b" -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: 28 September 2005 22:30 To: CF-Talk Subject: Re: Order by number of articles (count?) Hi Andy, I tried this option out but it was coming up with an error saying that the query doesn't have a GROUP AS statement. i then tried going back to your code from yesterday when i was getting help on the actual cfquery but still couldn't manage to get it to work. At the moment i have it as: SELECT a.authorID, a.authorPhotograph, a.authorFirstName, a.authorSurname, a.authorAboutMe, b.articleID, b.authorID, b.articleTitle, a.articleDatePublishedLast FROM tbl_020authorDetails a INNER tbl_020articleDetails b WHERE authorPhotograph <> ' ' AND a.authorID = a.authorID AND b.articleAuthenticated = 1 AND b.articleSubTypeID <> 55 AND b.articleSubTypeID <> 68 The error i am getting is: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]'tbl_020articleDetails' is not a recognized join option. Any help would be great, Thanks. On 28 Sep 2005, at 21:13, Andy Matthews wrote: > The Count function goes in the SELECT portion of your statement. > > SELECT COUNT(tbl_020articleDetails.articleID) AS totalArticles > > andy matthews > web developer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --//-> > > -Original Message- > From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 2:34 PM > To: CF-Talk > Subject: Order by number of articles (count?) > > > Hi guys, > > I'm trying to work out how to order my query by the amount of > articles. > > > SELECT tbl_020authorDetails.authorID, > authorPhotograph, authorFirstName, authorSurname, authorAboutMe, > tbl_020articleDetails.articleID, tbl_020articleDetails.authorID, > articleTitle, articleDatePublishedLast > FROM tbl_020authorDetails, tbl_020articleDetails > WHERE authorPhotograph <> ' ' AND > tbl_020articleDetails.authorID = tbl_020authorDetails.authorID AND > tbl_020articleDetails.articleAuthenticated = 1 AND > tbl_020articleDetails.articleSubTypeID <> 55 AND > tbl_020articleDetails.articleSubTypeID <> 68 > ORDER BY tbl_020authorDetails.authorFirstName, > articleDatePublishedLast DESC > > > How do I count how many articles there are, ie something like ORDER > BY tbl_020articleDetails.articleID(Count as) or something? > > Thanks for any help, > > Saturday > > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219528 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Idea for better hosting
Hey, I just had an idea for you guys working at hosting companies. Instead of just running each site on one server where its depenedent on all the other sites workign well, why not load balance between 2 or 3 servers. If you think about it, it shouldnt cost more because you'd be able to put twice as many sites on each machine because the load would be that proportion smaller(other than the loadbalancer). If one goes south, then the load balancing would work while you reboot the machine. All you'd have to do is setup some sort of directory watching so that the user would only have to maintain files on one machine. Presto, no more stupid "the jrun service is unavailable" messages. DRE On 9/28/05, Taco Fleur <[EMAIL PROTECTED]> wrote: > > The idea works, I have it implemented in several places. > Any more details as why it didn't work for you? > > Taco Fleur - Pacific Fox > an industry leader with commercial IT experience since 1994 . > http://www.pacificfox.com - Web Design and Development > > > > > -Original Message- > > From: Matthew Small [mailto:[EMAIL PROTECTED] > > Sent: Thursday, 29 September 2005 6:58 AM > > To: CF-Talk > > Subject: RE: SQL row select? > > > > > > Not only the IN method work, but yours did not, at least on > > MSSQL. I tried it. > > > > Now that's not necessarily the most efficient solution > > around, but if you have millions and millions of records to > > parse through with CF, then you need a DBA to ensure proper > > indexing and all that jazz, so you can let him write it. > > > > > > Matthew Small > > Web Developer > > American City Business Journals > > 704-973-1045 > > [EMAIL PROTECTED] > > > > > > -Original Message- > > From: Taco Fleur [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 4:24 PM > > To: CF-Talk > > Subject: RE: SQL row select? > > > > I would not expect an answer like that from a proper DBA. > > > > Not sure if we are talking about MS SQL or MySQL, but the > > idea is to work with subqueries. > > > > SELECT * > > FROM ( > > SELECT * TOP 20 > > FROM (SELECT TOP (200 + 20) yourColumn1, yourColumn2 > > FROM yourTable C > > ORDER BY C.yourOrderColumn ASC) B > > ORDER BY B.yourOrderColumn DESC ) A > > ORDER BY A.yourOrderColumn ASC > > > > Where 200 is for example the current row you are on and 20 is > > the number of records you want to retrieve. The idea is to > > first get TOP currentRow + numberOfRowToRetrieve Then order > > descending and get the top 20 Then order ascending and select all > > > > This way you only transfer from the DB over the network what > > you need to, and the query is not inefficient, especially if > > you got the right indexes. > > > > Now, its early here, so I might have made a mistake, but you > > get the general idea. I think the previous sample with IN > > does not work, especially not efficient. > > > > > > Taco Fleur - Pacific Fox > > an industry leader with commercial IT experience since 1994 . > > http://www.pacificfox.com - Web Design and Development > > > > > > > > > -Original Message- > > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, 29 September 2005 2:25 AM > > > To: CF-Talk > > > Subject: RE: SQL row select? > > > > > > > > > Here's a post from a DBA I'm friends with: > > > > > > > > > Just pull the entire query over to CF and use query of > > > queries, to grab > > > your "paged" row sets. I work with record sets of millions > > > and it works > > > very nicely. > > > > > > > > > > > andy matthews > > > web developer > > > ICGLink, Inc. > > > [EMAIL PROTECTED] > > > 615.370.1530 x737 > > > --//-> > > > > > > -Original Message- > > > From: Greg Morphis [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, September 28, 2005 10:59 AM > > > To: CF-Talk > > > Subject: Re: SQL row select? > > > > > > > > > Select top 50 * from table > > > Where id not in > > > > > > ( select top 199 id from table > > > order by date, alpha) > > > > > > order by date, alpha > > > > > > that works but what if you are paging through a million > > > records as suggested before? wouldnt the inner query select > > > the top 999,999 rows? IE > > > > > > Select top 50 * from table > > > Where id not in > > > ( > > > select top 99 id from table > > > order by date, alpha > > > ) > > > order by date, alpha > > > > > > > > > I think thats what Mike K was talking about. > > > > > > > > > > > > On 9/28/05, Andy Matthews <[EMAIL PROTECTED]> wrote: > > > > Did no one see this post? After reading, and re-reading the > > > original > > > > post, it looks like this simple SQL statement is the answer > > > (assuming > > > > that MSSQL supports the LIMIT clause: > > > > > > > > SELECT * > > > > FROM tablename > > > > LIMIT #startrow#, #totalrecords# > > > > > > > > or > > > > > > > > SELECT * > > > > FROM tablename > > > > LIMIT 200, 50 > > > > > > > > > > > andy matthews > > > > web developer > > > > ICGLink, Inc. > > > > [EMAIL PROTECTED] > > > > 615.370.1530 x737 > >
Re: Order by number of articles (count?)
Hi Andy, I tried this option out but it was coming up with an error saying that the query doesn't have a GROUP AS statement. i then tried going back to your code from yesterday when i was getting help on the actual cfquery but still couldn't manage to get it to work. At the moment i have it as: SELECT a.authorID, a.authorPhotograph, a.authorFirstName, a.authorSurname, a.authorAboutMe, b.articleID, b.authorID, b.articleTitle, a.articleDatePublishedLast FROM tbl_020authorDetails a INNER tbl_020articleDetails b WHERE authorPhotograph <> ' ' AND a.authorID = a.authorID AND b.articleAuthenticated = 1 AND b.articleSubTypeID <> 55 AND b.articleSubTypeID <> 68 The error i am getting is: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]'tbl_020articleDetails' is not a recognized join option. Any help would be great, Thanks. On 28 Sep 2005, at 21:13, Andy Matthews wrote: > The Count function goes in the SELECT portion of your statement. > > SELECT COUNT(tbl_020articleDetails.articleID) AS totalArticles > > andy matthews > web developer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --//-> > > -Original Message- > From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 2:34 PM > To: CF-Talk > Subject: Order by number of articles (count?) > > > Hi guys, > > I'm trying to work out how to order my query by the amount of > articles. > > > SELECT tbl_020authorDetails.authorID, > authorPhotograph, authorFirstName, authorSurname, authorAboutMe, > tbl_020articleDetails.articleID, tbl_020articleDetails.authorID, > articleTitle, articleDatePublishedLast > FROM tbl_020authorDetails, tbl_020articleDetails > WHERE authorPhotograph <> ' ' AND > tbl_020articleDetails.authorID = tbl_020authorDetails.authorID AND > tbl_020articleDetails.articleAuthenticated = 1 AND > tbl_020articleDetails.articleSubTypeID <> 55 AND > tbl_020articleDetails.articleSubTypeID <> 68 > ORDER BY tbl_020authorDetails.authorFirstName, > articleDatePublishedLast DESC > > > How do I count how many articles there are, ie something like ORDER > BY tbl_020articleDetails.articleID(Count as) or something? > > Thanks for any help, > > Saturday > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219526 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: XML Signature and CF
Have you got a key that you need to sign with etc.? I should have a java class somewhere that allows you to create signatures. You can easily call it from CF or wrap it in a CFC. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Rolf Kvamme [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 7:18 AM > To: CF-Talk > Subject: XML Signature and CF > > > We have used xml for a few years now and suddenly have a > requirment for using a digital signature with a new partner. > > Are there any toolkits etc, that play well with CF that I can > use pretty readilly to sign our xml? > > Rolf Kvamme > Director of Development > ADTEL INTL > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219525 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: getAdminHash ???
So you need to run out and get some hash for the admin and all's well Sometimes I wonder about naming conventions ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219524 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
getAdminHash ???
The selected method getAdminHash was not found. I just ran the ms 7.01 updater and the JRun updater 6. Now when I try to get to my cf administrator I get this error. The selected method getAdminHash was not found. Either there are no methods with the specified method name and argument types, or the method getAdminHash is overloaded with arguments types that ColdFusion can't decipher reliably. If this is a Java object and you verified that the method exists, you may need to use the javacast function to reduce ambiguity. The error occurred in Application.cfm: line 128 -1 : Unable to display error's location in a CFML template. Any ideas?? Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219523 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
XML Signature and CF
We have used xml for a few years now and suddenly have a requirment for using a digital signature with a new partner. Are there any toolkits etc, that play well with CF that I can use pretty readilly to sign our xml? Rolf Kvamme Director of Development ADTEL INTL ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219522 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: null value
Null does not exist in coldfusion, you can test for len() as you have, or Another thing you could do if you wanted to really know if a column is null instead of an empty string, you could use COALESCE in your select, i.e. SELECT COALESCE( yourColumn, 'null' ) AS myColumn In CF It's not pretty, but it depends on what you are looking for. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 6:29 AM > To: CF-Talk > Subject: null value > > > hi there, > > i have the following query ... > > password="#Request.app.DBpassword#" > username="#Request.app.DBusername#"> > SELECT orders.order_id, orders.dCreated, > orders.billing_fname, orders.billing_lname, > orders.billing_country, orders.currency, > orders.currency_value, orders.order_status, > payment_authority.success, payment_authority.responseText > FROM orders LEFT OUTER JOIN payment_authority > ON orders.order_id = payment_authority.order_id > WHERE order_receipt_sent = cfsqltype="cf_sql_bit" value="0"> ORDER BY orders.dCreated > DESC > > i am using an outer join as i wish to display all orders > whether they have an associated entry in the > payment_authority table or not. with each row of the query i > display the #payment_authority.responseText# value. the > payment_authority.responseText data is variable. > > now if the row does not have any associated entries in the > payment_authority table, how do i reference the > [empty-string] value returned? > > eg. does not > seem to recognise the null value. > > > Kind Regards > > Mike Little > [ Designer ] > > Graphic Impact Ltd > 40 College Hill, Ponsonby, Auckland > DDI +64 9 376 7622 > Fax +64 9 376 7360 > > _ > > CAUTION: This e-mail message and accompanying data may > contain information that is confidential. If you are not the > intended recipient you are notified that any use, > dissemination, distribution or copying of this message or > data is prohibited. All content is to be treated as > confidential unless otherwise specified, and is not to be > forwarded to third parties without the prior permission of > the author. To do so may breach the New Zealand Privacy Act > 1993. If you have received this > e-mail message in error please delete it and notify me. Thank you. > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219521 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL row select?
Yup, tested it, works like a charm here mate. So unless you provide any more input as to why you think it doesn't work I won't be able to help you out. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Matthew Small [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 6:58 AM > To: CF-Talk > Subject: RE: SQL row select? > > > Not only the IN method work, but yours did not, at least on > MSSQL. I tried it. > > Now that's not necessarily the most efficient solution > around, but if you have millions and millions of records to > parse through with CF, then you need a DBA to ensure proper > indexing and all that jazz, so you can let him write it. > > > Matthew Small > Web Developer > American City Business Journals > 704-973-1045 > [EMAIL PROTECTED] > > > -Original Message- > From: Taco Fleur [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 4:24 PM > To: CF-Talk > Subject: RE: SQL row select? > > I would not expect an answer like that from a proper DBA. > > Not sure if we are talking about MS SQL or MySQL, but the > idea is to work with subqueries. > > SELECT * > FROM ( > SELECT * TOP 20 > FROM (SELECT TOP (200 + 20) yourColumn1, yourColumn2 > FROM yourTable C > ORDER BY C.yourOrderColumn ASC) B > ORDER BY B.yourOrderColumn DESC ) A > ORDER BY A.yourOrderColumn ASC > > Where 200 is for example the current row you are on and 20 is > the number of records you want to retrieve. The idea is to > first get TOP currentRow + numberOfRowToRetrieve Then order > descending and get the top 20 Then order ascending and select all > > This way you only transfer from the DB over the network what > you need to, and the query is not inefficient, especially if > you got the right indexes. > > Now, its early here, so I might have made a mistake, but you > get the general idea. I think the previous sample with IN > does not work, especially not efficient. > > > Taco Fleur - Pacific Fox > an industry leader with commercial IT experience since 1994 . > http://www.pacificfox.com - Web Design and Development > > > > > -Original Message- > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > Sent: Thursday, 29 September 2005 2:25 AM > > To: CF-Talk > > Subject: RE: SQL row select? > > > > > > Here's a post from a DBA I'm friends with: > > > > > > Just pull the entire query over to CF and use query of > > queries, to grab > > your "paged" row sets. I work with record sets of millions > > and it works > > very nicely. > > > > > > > andy matthews > > web developer > > ICGLink, Inc. > > [EMAIL PROTECTED] > > 615.370.1530 x737 > > --//-> > > > > -Original Message- > > From: Greg Morphis [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 10:59 AM > > To: CF-Talk > > Subject: Re: SQL row select? > > > > > > Select top 50 * from table > > Where id not in > > > > ( select top 199 id from table > >order by date, alpha) > > > > order by date, alpha > > > > that works but what if you are paging through a million > > records as suggested before? wouldnt the inner query select > > the top 999,999 rows? IE > > > > Select top 50 * from table > > Where id not in > > ( > >select top 99 id from table > >order by date, alpha > > ) > > order by date, alpha > > > > > > I think thats what Mike K was talking about. > > > > > > > > On 9/28/05, Andy Matthews <[EMAIL PROTECTED]> wrote: > > > Did no one see this post? After reading, and re-reading the > > original > > > post, it looks like this simple SQL statement is the answer > > (assuming > > > that MSSQL supports the LIMIT clause: > > > > > > SELECT * > > > FROM tablename > > > LIMIT #startrow#, #totalrecords# > > > > > > or > > > > > > SELECT * > > > FROM tablename > > > LIMIT 200, 50 > > > > > > > > andy matthews > > > web developer > > > ICGLink, Inc. > > > [EMAIL PROTECTED] > > > 615.370.1530 x737 > > > --//-> > > > > > > -Original Message- > > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, September 28, 2005 8:57 AM > > > To: CF-Talk > > > Subject: RE: SQL row select? > > > > > > > > > I don't use MS SQL but doesn't it support the LIMIT keyword in the > > > SELECT statement? > > > > > > SELECT * > > > FROM tablename > > > LIMIT #startrow#, #totalrecords# > > > > > > or > > > > > > SELECT * > > > FROM tablename > > > LIMIT 200, 50 > > > > > > > > andy matthews > > > web developer > > > ICGLink, Inc. > > > [EMAIL PROTECTED] > > > 615.370.1530 x737 > > > --//-> > > > > > > -Original Message- > > > > > > >Ok, I feel like this should be something simple but my brain just > > > >isn't working this morning. Besides using CFOUTPUT with > > the startrow > > > >and maxrows attributes, is there a way in my SQL itself > to sp
CFPOP errors
I am getting some errors when using CFPOP to retrieve email. The errors seem to happen even when I only get the headers. The errors are like: javax.mail.MessageRemovedException. or sun.io.ByteToCharBig5.getIndex1()[S I tried wrapping the CFPOP in a try/catch block in an attempt to find which email is causing the problem and delete it, but I just get the regular ColdFusion error instead of my cfcatch executing. Anyone else every have these errors? They are occuring very frequently, and are usually because of a malformed auto-response, or some strange Chinese encodings/emails. Anyone have any ideas, other than using something other than CFPOP? Yes, I have the latest JDK installed to, as I followed the instructions from http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:42282 to no avail. Cedric ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219519 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL row select?
The idea works, I have it implemented in several places. Any more details as why it didn't work for you? Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Matthew Small [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 6:58 AM > To: CF-Talk > Subject: RE: SQL row select? > > > Not only the IN method work, but yours did not, at least on > MSSQL. I tried it. > > Now that's not necessarily the most efficient solution > around, but if you have millions and millions of records to > parse through with CF, then you need a DBA to ensure proper > indexing and all that jazz, so you can let him write it. > > > Matthew Small > Web Developer > American City Business Journals > 704-973-1045 > [EMAIL PROTECTED] > > > -Original Message- > From: Taco Fleur [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 4:24 PM > To: CF-Talk > Subject: RE: SQL row select? > > I would not expect an answer like that from a proper DBA. > > Not sure if we are talking about MS SQL or MySQL, but the > idea is to work with subqueries. > > SELECT * > FROM ( > SELECT * TOP 20 > FROM (SELECT TOP (200 + 20) yourColumn1, yourColumn2 > FROM yourTable C > ORDER BY C.yourOrderColumn ASC) B > ORDER BY B.yourOrderColumn DESC ) A > ORDER BY A.yourOrderColumn ASC > > Where 200 is for example the current row you are on and 20 is > the number of records you want to retrieve. The idea is to > first get TOP currentRow + numberOfRowToRetrieve Then order > descending and get the top 20 Then order ascending and select all > > This way you only transfer from the DB over the network what > you need to, and the query is not inefficient, especially if > you got the right indexes. > > Now, its early here, so I might have made a mistake, but you > get the general idea. I think the previous sample with IN > does not work, especially not efficient. > > > Taco Fleur - Pacific Fox > an industry leader with commercial IT experience since 1994 . > http://www.pacificfox.com - Web Design and Development > > > > > -Original Message- > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > Sent: Thursday, 29 September 2005 2:25 AM > > To: CF-Talk > > Subject: RE: SQL row select? > > > > > > Here's a post from a DBA I'm friends with: > > > > > > Just pull the entire query over to CF and use query of > > queries, to grab > > your "paged" row sets. I work with record sets of millions > > and it works > > very nicely. > > > > > > > andy matthews > > web developer > > ICGLink, Inc. > > [EMAIL PROTECTED] > > 615.370.1530 x737 > > --//-> > > > > -Original Message- > > From: Greg Morphis [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 10:59 AM > > To: CF-Talk > > Subject: Re: SQL row select? > > > > > > Select top 50 * from table > > Where id not in > > > > ( select top 199 id from table > >order by date, alpha) > > > > order by date, alpha > > > > that works but what if you are paging through a million > > records as suggested before? wouldnt the inner query select > > the top 999,999 rows? IE > > > > Select top 50 * from table > > Where id not in > > ( > >select top 99 id from table > >order by date, alpha > > ) > > order by date, alpha > > > > > > I think thats what Mike K was talking about. > > > > > > > > On 9/28/05, Andy Matthews <[EMAIL PROTECTED]> wrote: > > > Did no one see this post? After reading, and re-reading the > > original > > > post, it looks like this simple SQL statement is the answer > > (assuming > > > that MSSQL supports the LIMIT clause: > > > > > > SELECT * > > > FROM tablename > > > LIMIT #startrow#, #totalrecords# > > > > > > or > > > > > > SELECT * > > > FROM tablename > > > LIMIT 200, 50 > > > > > > > > andy matthews > > > web developer > > > ICGLink, Inc. > > > [EMAIL PROTECTED] > > > 615.370.1530 x737 > > > --//-> > > > > > > -Original Message- > > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, September 28, 2005 8:57 AM > > > To: CF-Talk > > > Subject: RE: SQL row select? > > > > > > > > > I don't use MS SQL but doesn't it support the LIMIT keyword in the > > > SELECT statement? > > > > > > SELECT * > > > FROM tablename > > > LIMIT #startrow#, #totalrecords# > > > > > > or > > > > > > SELECT * > > > FROM tablename > > > LIMIT 200, 50 > > > > > > > > andy matthews > > > web developer > > > ICGLink, Inc. > > > [EMAIL PROTECTED] > > > 615.370.1530 x737 > > > --//-> > > > > > > -Original Message- > > > > > > >Ok, I feel like this should be something simple but my brain just > > > >isn't working this morning. Besides using CFOUTPUT with > > the startrow > > > >and maxrows attributes, is there a way in my SQL itself > to specify > > > >that I want it to grab 50 rows sta
Re: Positive Press For CFMX
On 9/28/05, Dick Applebaum wrote: > Bruce: Oh, One more thing... The next release of ColdFusion MX, > available in September, will fully support the Mac and OS X as a > production platform (and all the good words) > Considering the merger isn't final and could still fall through, I'm not sure Adobe is ready to plug upcoming Macromedia products. Scott -- - Scott Brady http://www.scottbrady.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219517 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL row select?
Not only the IN method work, but yours did not, at least on MSSQL. I tried it. Now that's not necessarily the most efficient solution around, but if you have millions and millions of records to parse through with CF, then you need a DBA to ensure proper indexing and all that jazz, so you can let him write it. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 4:24 PM To: CF-Talk Subject: RE: SQL row select? I would not expect an answer like that from a proper DBA. Not sure if we are talking about MS SQL or MySQL, but the idea is to work with subqueries. SELECT * FROM ( SELECT * TOP 20 FROM (SELECT TOP (200 + 20) yourColumn1, yourColumn2 FROM yourTable C ORDER BY C.yourOrderColumn ASC) B ORDER BY B.yourOrderColumn DESC ) A ORDER BY A.yourOrderColumn ASC Where 200 is for example the current row you are on and 20 is the number of records you want to retrieve. The idea is to first get TOP currentRow + numberOfRowToRetrieve Then order descending and get the top 20 Then order ascending and select all This way you only transfer from the DB over the network what you need to, and the query is not inefficient, especially if you got the right indexes. Now, its early here, so I might have made a mistake, but you get the general idea. I think the previous sample with IN does not work, especially not efficient. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Andy Matthews [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 2:25 AM > To: CF-Talk > Subject: RE: SQL row select? > > > Here's a post from a DBA I'm friends with: > > > Just pull the entire query over to CF and use query of > queries, to grab > your "paged" row sets. I work with record sets of millions > and it works > very nicely. > > > andy matthews > web developer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --//-> > > -Original Message- > From: Greg Morphis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 10:59 AM > To: CF-Talk > Subject: Re: SQL row select? > > > Select top 50 * from table > Where id not in > > ( select top 199 id from table >order by date, alpha) > > order by date, alpha > > that works but what if you are paging through a million > records as suggested before? wouldnt the inner query select > the top 999,999 rows? IE > > Select top 50 * from table > Where id not in > ( >select top 99 id from table >order by date, alpha > ) > order by date, alpha > > > I think thats what Mike K was talking about. > > > > On 9/28/05, Andy Matthews <[EMAIL PROTECTED]> wrote: > > Did no one see this post? After reading, and re-reading the > original > > post, it looks like this simple SQL statement is the answer > (assuming > > that MSSQL supports the LIMIT clause: > > > > SELECT * > > FROM tablename > > LIMIT #startrow#, #totalrecords# > > > > or > > > > SELECT * > > FROM tablename > > LIMIT 200, 50 > > > > > andy matthews > > web developer > > ICGLink, Inc. > > [EMAIL PROTECTED] > > 615.370.1530 x737 > > --//-> > > > > -Original Message- > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 8:57 AM > > To: CF-Talk > > Subject: RE: SQL row select? > > > > > > I don't use MS SQL but doesn't it support the LIMIT keyword in the > > SELECT statement? > > > > SELECT * > > FROM tablename > > LIMIT #startrow#, #totalrecords# > > > > or > > > > SELECT * > > FROM tablename > > LIMIT 200, 50 > > > > > andy matthews > > web developer > > ICGLink, Inc. > > [EMAIL PROTECTED] > > 615.370.1530 x737 > > --//-> > > > > -Original Message- > > > > >Ok, I feel like this should be something simple but my brain just > > >isn't working this morning. Besides using CFOUTPUT with > the startrow > > >and maxrows attributes, is there a way in my SQL itself to specify > > >that I want it to grab 50 rows starting at the 200th row. > I'm trying > > >to make a paged approach to a query that could potentially > have about > > >20,000 records returned. I'd much rather just have MS SQL > return 50 > > >rows at a time by telling it which row to start at rather > than having > > >it return a 20,000 recordset to CF and then only output 50. I'm > > >hoping this is something easy and my brain just hasn't > woken up yet. > > >Any thoughts would be appreciated. > > > > > >John Burns > > >Certified Advanced ColdFusion MX Developer > > >Wyle Laboratories, Inc. | Web Developer > > > > > > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start trackin
re: CF-based mailing list manager?
intouch is killer! only problem is that its on an access db, if anyone wants to help port it to mysql lemme know! It's on y list to do...somewhere... ~Dave the disruptor~ "Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time." From: Rick Root <[EMAIL PROTECTED]> Sent: Wednesday, September 28, 2005 9:07 AM To: CF-Talk Subject: CF-based mailing list manager? Anyone out there know of a cf based mailing list manager? Something that supports moderated and non-moderated lists, announcement lists, subscribe/unsubscsribe, etc... I've been looking at a program called "dolist" (software.dolist.net) that has a web-based interface written in ASP, but I've been having trouble getting it to work and the support seems limited. Basically, I want something that will retrieve messages from a POP3 account, process each message, and act appropriately (store for moderation, reject, distribute, etc) Basically, I'm looking for majordomo for CF - that uses an external POP3 account for incoming list traffic and uses coldfusion to distribute messages. Thanks. Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219515 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Suggestions wanted
>>To the best of my knowledge, all email addresses will be contained in <>'s. In that case, CF_REextract will do it pretty straightforward for you: Go to the test page: http://www.contentbox.com/claude/customtags/REextract/testingREextract.cfm Enter "<" for RE1 and "> for RE2, - Enter "Rick Root" <[EMAIL PROTECTED]> or "Rick Root" <[EMAIL PROTECTED]>,"Root, Rick" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> in the sample text area and click the Test button. Tou'll get all your addresses in one query. If ever the syntax around the addresses is a bit more complex, ajust the regEx in consequence. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219514 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
null value
hi there, i have the following query ... SELECT orders.order_id, orders.dCreated, orders.billing_fname, orders.billing_lname, orders.billing_country, orders.currency, orders.currency_value, orders.order_status, payment_authority.success, payment_authority.responseText FROM orders LEFT OUTER JOIN payment_authority ON orders.order_id = payment_authority.order_id WHERE order_receipt_sent = ORDER BY orders.dCreated DESC i am using an outer join as i wish to display all orders whether they have an associated entry in the payment_authority table or not. with each row of the query i display the #payment_authority.responseText# value. the payment_authority.responseText data is variable. now if the row does not have any associated entries in the payment_authority table, how do i reference the [empty-string] value returned? eg. does not seem to recognise the null value. Kind Regards Mike Little [ Designer ] Graphic Impact Ltd 40 College Hill, Ponsonby, Auckland DDI +64 9 376 7622 Fax +64 9 376 7360 _ CAUTION: This e-mail message and accompanying data may contain information that is confidential. If you are not the intended recipient you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. All content is to be treated as confidential unless otherwise specified, and is not to be forwarded to third parties without the prior permission of the author. To do so may breach the New Zealand Privacy Act 1993. If you have received this e-mail message in error please delete it and notify me. Thank you. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219513 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL row select?
I would not expect an answer like that from a proper DBA. Not sure if we are talking about MS SQL or MySQL, but the idea is to work with subqueries. SELECT * FROM ( SELECT * TOP 20 FROM (SELECT TOP (200 + 20) yourColumn1, yourColumn2 FROM yourTable C ORDER BY C.yourOrderColumn ASC) B ORDER BY B.yourOrderColumn DESC ) A ORDER BY A.yourOrderColumn ASC Where 200 is for example the current row you are on and 20 is the number of records you want to retrieve. The idea is to first get TOP currentRow + numberOfRowToRetrieve Then order descending and get the top 20 Then order ascending and select all This way you only transfer from the DB over the network what you need to, and the query is not inefficient, especially if you got the right indexes. Now, its early here, so I might have made a mistake, but you get the general idea. I think the previous sample with IN does not work, especially not efficient. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Andy Matthews [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 2:25 AM > To: CF-Talk > Subject: RE: SQL row select? > > > Here's a post from a DBA I'm friends with: > > > Just pull the entire query over to CF and use query of > queries, to grab > your "paged" row sets. I work with record sets of millions > and it works > very nicely. > > > andy matthews > web developer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --//-> > > -Original Message- > From: Greg Morphis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 10:59 AM > To: CF-Talk > Subject: Re: SQL row select? > > > Select top 50 * from table > Where id not in > > ( select top 199 id from table >order by date, alpha) > > order by date, alpha > > that works but what if you are paging through a million > records as suggested before? wouldnt the inner query select > the top 999,999 rows? IE > > Select top 50 * from table > Where id not in > ( >select top 99 id from table >order by date, alpha > ) > order by date, alpha > > > I think thats what Mike K was talking about. > > > > On 9/28/05, Andy Matthews <[EMAIL PROTECTED]> wrote: > > Did no one see this post? After reading, and re-reading the > original > > post, it looks like this simple SQL statement is the answer > (assuming > > that MSSQL supports the LIMIT clause: > > > > SELECT * > > FROM tablename > > LIMIT #startrow#, #totalrecords# > > > > or > > > > SELECT * > > FROM tablename > > LIMIT 200, 50 > > > > > andy matthews > > web developer > > ICGLink, Inc. > > [EMAIL PROTECTED] > > 615.370.1530 x737 > > --//-> > > > > -Original Message- > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 8:57 AM > > To: CF-Talk > > Subject: RE: SQL row select? > > > > > > I don't use MS SQL but doesn't it support the LIMIT keyword in the > > SELECT statement? > > > > SELECT * > > FROM tablename > > LIMIT #startrow#, #totalrecords# > > > > or > > > > SELECT * > > FROM tablename > > LIMIT 200, 50 > > > > > andy matthews > > web developer > > ICGLink, Inc. > > [EMAIL PROTECTED] > > 615.370.1530 x737 > > --//-> > > > > -Original Message- > > > > >Ok, I feel like this should be something simple but my brain just > > >isn't working this morning. Besides using CFOUTPUT with > the startrow > > >and maxrows attributes, is there a way in my SQL itself to specify > > >that I want it to grab 50 rows starting at the 200th row. > I'm trying > > >to make a paged approach to a query that could potentially > have about > > >20,000 records returned. I'd much rather just have MS SQL > return 50 > > >rows at a time by telling it which row to start at rather > than having > > >it return a 20,000 recordset to CF and then only output 50. I'm > > >hoping this is something easy and my brain just hasn't > woken up yet. > > >Any thoughts would be appreciated. > > > > > >John Burns > > >Certified Advanced ColdFusion MX Developer > > >Wyle Laboratories, Inc. | Web Developer > > > > > > > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219512 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: [QUARRANTINE] IMAP webmail app?
Cold fusion based...but I have heard good things about squirrel name. -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 3:10 PM To: CF-Talk Subject: Re: [QUARRANTINE] IMAP webmail app? If PHP is an option, SquirrelMail seems to work pretty well. --Ben Eric Hoffman wrote: > Does anyone know of a good IMAP based webmail application? > > I purchased one from AdvancedWebmail.com, but got screwed. They won't > return any communications nor ever sent the serial number to activate > the product. BEWARE. > > This has left me pretty hosed, this portion of the larger app is due > in a few days and we had always figured on using an prewritten-app to > fulfill the needs. All I see are POP based ones in my searches, though. > > Any ideas welcome! > > Thanks! > > Eric Hoffman > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219511 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Order by number of articles (count?)
The Count function goes in the SELECT portion of your statement. SELECT COUNT(tbl_020articleDetails.articleID) AS totalArticles -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 2:34 PM To: CF-Talk Subject: Order by number of articles (count?) Hi guys, I'm trying to work out how to order my query by the amount of articles. SELECT tbl_020authorDetails.authorID, authorPhotograph, authorFirstName, authorSurname, authorAboutMe, tbl_020articleDetails.articleID, tbl_020articleDetails.authorID, articleTitle, articleDatePublishedLast FROM tbl_020authorDetails, tbl_020articleDetails WHERE authorPhotograph <> ' ' AND tbl_020articleDetails.authorID = tbl_020authorDetails.authorID AND tbl_020articleDetails.articleAuthenticated = 1 AND tbl_020articleDetails.articleSubTypeID <> 55 AND tbl_020articleDetails.articleSubTypeID <> 68 ORDER BY tbl_020authorDetails.authorFirstName, articleDatePublishedLast DESC How do I count how many articles there are, ie something like ORDER BY tbl_020articleDetails.articleID(Count as) or something? Thanks for any help, Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219510 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Suggestions wanted
Throw a regex over it, maybe something like
{?=<)[\^](?=>)
It's early, no time to test, but give it a go.
I hope I haven't contributed to a spamming scheme ;-)
Taco Fleur - Pacific Fox
an industry leader with commercial IT experience since 1994 .
http://www.pacificfox.com - Web Design and Development
> -Original Message-
> From: Rick Root [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 29 September 2005 5:26 AM
> To: CF-Talk
> Subject: Suggestions wanted
>
>
> I'm looking for some suggestions on the best way to get email
> addresses
> from a string that looks like this:
>
> "Rick Root" <[EMAIL PROTECTED]>
>
> or
>
> "Rick Root" <[EMAIL PROTECTED]>,"Root, Rick"
> <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
>
> Ultimately, the latter should return an array or email addresses.
>
> To the best of my knowledge, all email addresses will be
> contained in <>'s.
>
> Rick
>
>
>
>
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219509
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [QUARRANTINE] IMAP webmail app?
If PHP is an option, SquirrelMail seems to work pretty well. --Ben Eric Hoffman wrote: > Does anyone know of a good IMAP based webmail application? > > I purchased one from AdvancedWebmail.com, but got screwed. They won't > return any communications nor ever sent the serial number to activate the > product. BEWARE. > > This has left me pretty hosed, this portion of the larger app is due in a > few days and we had always figured on using an prewritten-app to fulfill the > needs. All I see are POP based ones in my searches, though. > > Any ideas welcome! > > Thanks! > > Eric Hoffman > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219508 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IMAP webmail app?
http://magicwinmail.net Solid app, I have been using if for over 3 years now, hasn't failed me yet. It may be more than you are looking for but none the less, solid app.. Brian Polackoff -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 3:47 PM To: CF-Talk Subject: IMAP webmail app? Does anyone know of a good IMAP based webmail application? I purchased one from AdvancedWebmail.com, but got screwed. They won't return any communications nor ever sent the serial number to activate the product. BEWARE. This has left me pretty hosed, this portion of the larger app is due in a few days and we had always figured on using an prewritten-app to fulfill the needs. All I see are POP based ones in my searches, though. Any ideas welcome! Thanks! Eric Hoffman ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219507 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Suggestions wanted
This expression returns only the email address in Rick's sample string: When I said ignore the brackets, I just meant forget using them as a delimiter. He stated "To the best of my knowledge" that all emails would be in brackets. But what if you come across one that isn't in brackets. Better to get JUST the email based on spaces. I'm trying to figure out the best way to pull all the emails from that string using that regex. More to come hopefully. -Original Message- From: Steve Milburn [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 2:57 PM To: CF-Talk Subject: RE: Suggestions wanted If you forget about the brackets and go until you encounter a space, and the brackets are there, you will be an incorrect email. You would have <[EMAIL PROTECTED]> instead of [EMAIL PROTECTED] Good idea, Andy, but if you don't count for the brackets, your results will probably be wrong. The best way might be to proceed in both directions until you encounter a space OR a bracket, and stop at either one. Steve -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 3:44 PM To: CF-Talk Subject: RE: Suggestions wanted I'd actually forget the brackets (just in case). Work backwards from the knowledge that no email address can have a space in it, and ALL emails MUST have an @ symbol. Then return anything on either side of the @ symbol until you encounter a space. I'll see if I can come up with something for you. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 2:26 PM To: CF-Talk Subject: Suggestions wanted I'm looking for some suggestions on the best way to get email addresses from a string that looks like this: "Rick Root" <[EMAIL PROTECTED]> or "Rick Root" <[EMAIL PROTECTED]>,"Root, Rick" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> Ultimately, the latter should return an array or email addresses. To the best of my knowledge, all email addresses will be contained in <>'s. Rick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219506 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Order by number of articles (count?)
Hi guys, I'm trying to work out how to order my query by the amount of articles. SELECT tbl_020authorDetails.authorID, authorPhotograph, authorFirstName, authorSurname, authorAboutMe, tbl_020articleDetails.articleID, tbl_020articleDetails.authorID, articleTitle, articleDatePublishedLast FROM tbl_020authorDetails, tbl_020articleDetails WHERE authorPhotograph <> ' ' AND tbl_020articleDetails.authorID = tbl_020authorDetails.authorID AND tbl_020articleDetails.articleAuthenticated = 1 AND tbl_020articleDetails.articleSubTypeID <> 55 AND tbl_020articleDetails.articleSubTypeID <> 68 ORDER BY tbl_020authorDetails.authorFirstName, articleDatePublishedLast DESC How do I count how many articles there are, ie something like ORDER BY tbl_020articleDetails.articleID(Count as) or something? Thanks for any help, Saturday ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219505 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Suggestions wanted
If you forget about the brackets and go until you encounter a space, and the brackets are there, you will be an incorrect email. You would have <[EMAIL PROTECTED]> instead of [EMAIL PROTECTED] Good idea, Andy, but if you don't count for the brackets, your results will probably be wrong. The best way might be to proceed in both directions until you encounter a space OR a bracket, and stop at either one. Steve -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 3:44 PM To: CF-Talk Subject: RE: Suggestions wanted I'd actually forget the brackets (just in case). Work backwards from the knowledge that no email address can have a space in it, and ALL emails MUST have an @ symbol. Then return anything on either side of the @ symbol until you encounter a space. I'll see if I can come up with something for you. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 2:26 PM To: CF-Talk Subject: Suggestions wanted I'm looking for some suggestions on the best way to get email addresses from a string that looks like this: "Rick Root" <[EMAIL PROTECTED]> or "Rick Root" <[EMAIL PROTECTED]>,"Root, Rick" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> Ultimately, the latter should return an array or email addresses. To the best of my knowledge, all email addresses will be contained in <>'s. Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219504 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
IMAP webmail app?
Does anyone know of a good IMAP based webmail application? I purchased one from AdvancedWebmail.com, but got screwed. They won't return any communications nor ever sent the serial number to activate the product. BEWARE. This has left me pretty hosed, this portion of the larger app is due in a few days and we had always figured on using an prewritten-app to fulfill the needs. All I see are POP based ones in my searches, though. Any ideas welcome! Thanks! Eric Hoffman ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219503 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Suggestions wanted
I'd actually forget the brackets (just in case). Work backwards from the knowledge that no email address can have a space in it, and ALL emails MUST have an @ symbol. Then return anything on either side of the @ symbol until you encounter a space. I'll see if I can come up with something for you. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 2:26 PM To: CF-Talk Subject: Suggestions wanted I'm looking for some suggestions on the best way to get email addresses from a string that looks like this: "Rick Root" <[EMAIL PROTECTED]> or "Rick Root" <[EMAIL PROTECTED]>,"Root, Rick" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> Ultimately, the latter should return an array or email addresses. To the best of my knowledge, all email addresses will be contained in <>'s. Rick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219502 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 7.0.1 Updater
My "Powerbook" install was perfect. On 9/28/05, Steve Brownlee <[EMAIL PROTECTED]> wrote: > > Anyone been having problems installing the 7.0.1 updater EXE? I can't get > it > to install because it appears to only support people who are running JRun > as > their application server. Seems kind of silly to put out an updater that > only support one of the three ways that CF7 can be deployed. > > If I'm way off base here and it's possible to get this to run for those > running on another J2EE server, please let me know. > > - Steve > > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219501 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Suggestions wanted
I'm looking for some suggestions on the best way to get email addresses from a string that looks like this: "Rick Root" <[EMAIL PROTECTED]> or "Rick Root" <[EMAIL PROTECTED]>,"Root, Rick" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> Ultimately, the latter should return an array or email addresses. To the best of my knowledge, all email addresses will be contained in <>'s. Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219500 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX 7.01 on OSX dev only or production?
I ran the installation and it *IS* flawless victory on my PowerBook! It was up and running within 15 minutes (including re-adding DSN names). On 9/28/05, Dick Applebaum <[EMAIL PROTECTED]> wrote: > > According to the web site > > http://www.macromedia.com/software/coldfusion/productinfo/systemreqs/ > > The Enterprise and developer editions are available-- that means > prodo CFMX on OS X! > > Yea! > > Dick > > On Sep 28, 2005, at 8:21 AM, Mark W. Breneman wrote: > > > Does any one know if CFMX 7.01 for OSX is for development only? Can it > > run in production? > > > > If so, then Blue Dragon is not the only CFM server for OSX. > > > > Damon said: > > > > I'd like to especially extend a special "Welcome!" to Apple Mac OS > > X customers! Sorry it took so long, but I think this ColdFusion > > release is truly the perfect combination of Power, Productivity and > > Polish you've come to love and expect from this excellent platform. > > > > > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219499 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Calling CFC via URL not working
Just to be sure, it the method access set to "remote"? On 9/28/05, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > I'm tearing my hair out. > > This URL: > > http://dev/cfc/verity.cfc?method=indexCollection&collectionName=coll_datacards > > is not working, but this call using CFINVOKE: > > returnvariable="responseMessage" collectionname="coll_datacards"> > > Works fine. I don't need a returnvariable since I'm just running this > as a scheduled task (I haven't scheduled the task yet, I'm testing to > make sure I can call the cfc directly via URL). > > Any help? MX7 on Windows. > > Pete > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219498 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: New multiserver MX 7 installation is about to make my head explode.
On 9/28/05, Ian Skinner <[EMAIL PROTECTED]> wrote: > I've been reading Macromedia documentation for 5 days now and I still don't > have a clear picture of how all these new pieces fit together. > > We are moving up from MX Standard-Standalone to MX7 Enterprise-multiserver. > As one may imagine there are a lot of new concepts involved in this endeavor. > It would be so nice if somebody could point me to a resource that gives a > nice one-two-three guide on installing CF, creating new server instances and > connecting them to different IIS websites using different IP addresses, I > think. And where does a "default" website fit into all of this. > > I think I've recently goofed up, because the Enterprise Instance Manager is > no longer showing up in the CF admin options. > Ian, This phenomenal blog post should be a hub from which you can find all the info, and then some, that you need: http://devnulled.com/content/2005/09/coldfusion-mx-tuning-and-clustering-roundup/ Regards, Dave. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219497 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
New multiserver MX 7 installation is about to make my head explode.
I've been reading Macromedia documentation for 5 days now and I still don't have a clear picture of how all these new pieces fit together. We are moving up from MX Standard-Standalone to MX7 Enterprise-multiserver. As one may imagine there are a lot of new concepts involved in this endeavor. It would be so nice if somebody could point me to a resource that gives a nice one-two-three guide on installing CF, creating new server instances and connecting them to different IIS websites using different IP addresses, I think. And where does a "default" website fit into all of this. I think I've recently goofed up, because the Enterprise Instance Manager is no longer showing up in the CF admin options. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219496 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: query problem
In case the default value returned by the db is an empty string, you may need the belt and the suspenders: where NOT (publication_type IS NULL OR publication_type = '') -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219495 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: query problem
> From: Daniel Kessler [mailto:[EMAIL PROTECTED] > > select publication_type > from publications > where publication_type !='' > group by publication_type > If the field is NOT NULL try, where LEN(TRIM(publication_type)) == 0 *note... those are SQL Functions NOT CF ones. If the field is NULL try, where publication_type IS NULL HTH, Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219494 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Calculate monthly payment with CF
Never mind. Right after I sent the email I found a function on CFLib.com http://www.cflib.org/udf.cfm?ID=140 On 9/28/05, Phill B <[EMAIL PROTECTED]> wrote: > I need to calculate the monthly payment for a loan. I am horrible with > math and cant seem to find any good references on how to do it. Can > some one give me a bit of help? > > -- > Phil > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219493 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: query problem
not equals in sql is <>, that may help On 9/28/05, Daniel Kessler <[EMAIL PROTECTED]> wrote: > I can't seem to see what is wrong with this query. I added the WHERE > line and it comes up with no records returned. Without the WHERE, it > comes up with two records, but one of them has publication_type as an > empty field. I know there are records that aren't empty. Here's the > query: > > > select publication_type > from publications > where publication_type !='' > group by publication_type > > > Here's a dump of the db: > http://hhp.umd.edu/dbf/publications/db_display.cfm > > > thanks! > > -- > Daniel Kessler > > Department of Public and Community Health > University of Maryland > Suite 2387 Valley Drive > College Park, MD 20742-2611 > 301-405-2545 Phone > www.phi.umd.edu > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219492 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ot: checksum?
what about on win xp? On 9/28/05, Barney Boisvert <[EMAIL PROTECTED]> wrote: > on *nix, use 'md5sum FILE' for an MD5 checksum. > > cheers, > barneyb > > On 9/28/05, Ryan Guill <[EMAIL PROTECTED]> wrote: > > Can someone tell me how to do a checksum on a file that I download so > > that can compare it? Ive had trouble with corruption in macromedia > > downloads before and with them providing checksums now its a perfect > > opportunity to learn this. > > > > Thanks, > > -- > > Ryan Guill > > BlueEyesDevelopment > > [EMAIL PROTECTED] > > www.ryanguill.com > > (270) 217.2399 > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/ > > Got Gmail? I have 100 invites. > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219491 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: query problem
[empty string] is CF's way of saying NULL, since ColdFusion has not native NULL value. Thus your where clause should be WHERE Publication_Type IS NOT NULL -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219490 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: checksum?
Wouldn't it be cool if macromedia provided a small par or par2 file that would let you check the download and repair any small errors at the same time? -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 2:37 PM To: CF-Talk Subject: ot: checksum? Can someone tell me how to do a checksum on a file that I download so that can compare it? Ive had trouble with corruption in macromedia downloads before and with them providing checksums now its a perfect opportunity to learn this. Thanks, -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219489 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: checksum?
And on windows per Macromedia's instructions "Google for 'MD5 checksum tool windows" download, install and learn. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219488 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Calculate monthly payment with CF
I'm no math whiz, but it should be straightforward. If you're working with a company, get them to give you the formula they use to calculate the value and plug in the numbers. What sort of loanb is it? Simple interest? Compound? -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 1:36 PM To: CF-Talk Subject: Calculate monthly payment with CF I need to calculate the monthly payment for a loan. I am horrible with math and cant seem to find any good references on how to do it. Can some one give me a bit of help? -- Phil ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219487 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
query problem
I can't seem to see what is wrong with this query. I added the WHERE line and it comes up with no records returned. Without the WHERE, it comes up with two records, but one of them has publication_type as an empty field. I know there are records that aren't empty. Here's the query: select publication_type from publications where publication_type !='' group by publication_type Here's a dump of the db: http://hhp.umd.edu/dbf/publications/db_display.cfm thanks! -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219486 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ot: checksum?
on *nix, use 'md5sum FILE' for an MD5 checksum. cheers, barneyb On 9/28/05, Ryan Guill <[EMAIL PROTECTED]> wrote: > Can someone tell me how to do a checksum on a file that I download so > that can compare it? Ive had trouble with corruption in macromedia > downloads before and with them providing checksums now its a perfect > opportunity to learn this. > > Thanks, > -- > Ryan Guill > BlueEyesDevelopment > [EMAIL PROTECTED] > www.ryanguill.com > (270) 217.2399 -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219485 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Calculate monthly payment with CF
Monthly Payment = (rate + rate / ((1 + rate)^months) - 1 ) * principal Where rate = Annual Percentage Rate divided by 1200 For example, an 8 % annual rate becomes .0066... Let's suppose we want to borrow $150,000 for 30 years at 8 per cent annual percentage rate. What is the monthly payment? 1) The rate would be .00... 2) The months would be 12 × 30 = 360. 3) So the monthly Payment would be: .00 / .00 + ((1.00 ^360)-1) × $150,000 4) The middle section of the equation is the most difficult to solve so we will calculate that first. (.00) ÷ ((1.00 ^360)-1) = (.00) ÷ (10.935729397036 -1) = (.00) ÷ 9.935729397036 = 0.0006709790897 5) "Plugging" this into the rest of the equation we have: (.00 + 0.0006709790897) × $150,000 = (0.007337645756) × $150,000 = $ 1,100.65 http://www.1728.com/loanform.htm -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219484 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
ot: checksum?
Can someone tell me how to do a checksum on a file that I download so that can compare it? Ive had trouble with corruption in macromedia downloads before and with them providing checksums now its a perfect opportunity to learn this. Thanks, -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219483 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Cookie & ASP Cookie?
Yeah I wish that was an option... but it would require changing too many pages. Neal Bailey Internet Marketing Manager -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 1:04 PM To: CF-Talk Subject: Re: CF Cookie & ASP Cookie? So look on the ASP side for a function to decode the cookie value ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219482 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Calculate monthly payment with CF
I need to calculate the monthly payment for a loan. I am horrible with math and cant seem to find any good references on how to do it. Can some one give me a bit of help? -- Phil ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219481 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Cookie & ASP Cookie?
So look on the ASP side for a function to decode the cookie value ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219480 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Cookie & ASP Cookie?
Yeah I recalled the file because it said it was too long... was not sure what to do. Anyway... yes I know it gets decoded correctly if I dump it using CFDump... But I need ASP and .Net to be able to read this same cookie. The problem is that ASP when inserting the Cookie does not encode the URl string like CF does. So when ASP tries to read the Cookie it gets all confused because it's looking for the "&" as the delimiter but instead gets hung up on all the encoded values. Hope this makes sense... I was hoping I could find a UDF or some how have it not encode the string when save to the cookie. Neal Bailey Internet Marketing Manager -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 12:34 PM To: CF-Talk Subject: Re: CF Cookie & ASP Cookie? Oh yeah...and when you say "look at the cookie value" I assume you have actually opened the cookie file?? Try and see if all the encoding goes away ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219479 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Positive Press For CFMX
This is a good article! I wish that MACR would have announced this at some Apple function (Such as Apple's Developer's Conference, a couple of months ago) to take advantage of the additional publicity. The CEOs of Adobe and intel were both on stage with Steve Jobs... In fact, Bruce Chizen, appeared after the announcement of the switch to MacTel & chided Steve Ideally, it could have gone like this: Steve: Now, Here's Bruce Chizen, CEO of Adobe... Bruce: .Steve, What took you so long (Bruce actually said this) Audience: Laughter & cheers Bruce: Adobe's long relationship & support for Apple, yadda, yadda, yadda, Bruce: Oh, One more thing... The next release of ColdFusion MX, available in September, will fully support the Mac and OS X as a production platform (and all the good words) Audience: cheers Steve: ...Bruce, what took YOU so long Audience: Laughter & cheers Now, that would have been great PR! --- BTW, CFMX already runs natively on the MacTel It would be interesting to know if it is practical to run CF Report Builder could be made to run native on the MacTel without requiring the windows OS. Anyone know? Dick On Sep 28, 2005, at 10:09 AM, Todd Mathews wrote: > This was just released: > > http://www.eweek.com/article2/0,1895,1864586,00.asp > > > It's nice to finally see CFMX get the positive press it has > deserved for > quite a while. > > Hats off to the Merrimack team for a job done extraordinarily well! > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219478 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: FTP & Subversion
I finally got an answer froj Ipswitch. They said, "I doubt you would be able to do that with a regular transfer. However with synchronized transfers, you have an option to add exclusion rules for files and folders." I was able to easily add and exclusion rules for .svn folders and it works perfectly. >Before anyone tells me to search the archives, please read my thread I just >posted under "Source Control" >http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:42443# >219461 > > > >I am having a hard time setting up a filter for WS_FTP Pro to not upload a >Subversion directory. How do others use Subversion and WS_FTP Pro? I thought >of exporting from Subversion to get a clean copy, and then ftping the clean >copy, but that would be a pain as changes to the site occur. What I would >like to do is just filter .svn directories so WS_FTP Pro ignores them. I've >posted to the Ipswitch forum, but that forum is useless! > > > >I also thought about asking the web host to setup Subversion on the web >sever, though I doubt that is going to happen. > > > >Any help or comments would be appreciated! > > > >Thank you, > >Aftershock Web Design, Inc. > >by: Stan Winchester > >President/Developer > >[EMAIL PROTECTED] > >http://www.aftershockweb.com/ > >Phone 503-244-3440 > >Fax 503-244-3454 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219477 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Cookie & ASP Cookie?
Oh yeah...and when you say "look at the cookie value" I assume you have actually opened the cookie file?? Try and see if all the encoding goes away ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219476 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Recall: CF Cookie & ASP Cookie?
LOL...too late ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: "Bailey, Neal" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, September 28, 2005 10:30 AM Subject: Recall: CF Cookie & ASP Cookie? > Bailey, Neal would like to recall the message, "CF Cookie & ASP Cookie?". > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219475 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Cookie & ASP Cookie?
> --
> NeedUpdate%3D0%26Recognition%3DSupport%26EntityID%3D09%26AgentName%3
> DNeal%2BBailey%26Region%3D%26Rank%3D80%26AgentNumber%3D%2540%254009%2B
> --
That's just the value which gets encoded for URL travel (just like URLs
dosame applies to cookies).
There should be no need to "stop it" because when you do access the value,
the encoding shold be decoded automatically. If not I beleive there is
URLDecode() you can use.
HTH
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
- Original Message -
From: "Bailey, Neal" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Wednesday, September 28, 2005 10:24 AM
Subject: RE: CF Cookie & ASP Cookie?
> OK guys... I think I have my Cookie kind of figured out now...
>
> It seems ASP does not actually store the cookie as complex variables but
> instead it's more of a comma delimited format using "&" as the delimiter.
>
> Anyway now that I figure out that problem I have another...
>
> I am storing the values in the cookie like this:
> -
> "NeedUpdate=0&Recognition=Support&EntityID=09&AgentName=Neal+Bailey&
> Region=&Rank=80&AgentNumber=%40%4009+">
>
> --
>
>
> But when I look at the cookie value it looks like this:
> --
> NeedUpdate%3D0%26Recognition%3DSupport%26EntityID%3D09%26AgentName%3
> DNeal%2BBailey%26Region%3D%26Rank%3D80%26AgentNumber%3D%2540%254009%2B
> --
>
> For some reason its converting the =,&,+ and % characters to another
> format.
> Any idea how I can fix this?
>
> Man what a mess...
>
> Thanks again..
>
> Neal Bailey
> Internet Marketing Manager
>
> -Original Message-
> From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 28, 2005 10:46 AM
> To: CF-Talk
> Subject: RE: CF Cookie & ASP Cookie?
>
> Neal:
>
> ASP supports something it calls a "Cookie Dictionaries." This is,
> essentially an associative array (or structure) of values all referenced
> by
> the same variable name. So, just like with ColdFusion structures you can
> do
> something like:
>
> myStructure.myKey
>
> in ASP, you can do something like:
>
> Response.Cookies("myStructure")("myKey")
>
> In order to support this, ASP creates a cookie named "myStructure" (or
> whatever you specify as the name) and sets the cookie value to something
> like:
>
> key1=value1&key2=value2
>
> So, to duplicate your ASP code in ColdFusion, you'll need code like the
> following:
>
>
>
>
>
>
>
>
> Note that when you retrieve this Cookie via CF, you'll have to parse the
> string and break it up into its original pieces. You could use code like
> the following:
>
>
>
>
>
>
>
> And then access each piece via code like:
>
> RSHold["AgentNumber"]
>
> Note, none of this code is tested so there might be some minor issues.
> But
> the logic should be pretty sound.
>
> HTH
>
> --
> Mosh Teitelbaum
> evoch, LLC
> Tel: (301) 942-5378
> Fax: (301) 933-3651
> Email: [EMAIL PROTECTED]
> WWW: http://www.evoch.com/
>
>
>> -Original Message-
>> From: Bailey, Neal [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, September 27, 2005 5:43 PM
>> To: CF-Talk
>> Subject: CF Cookie & ASP Cookie?
>>
>>
>> Hey Guys I have been searching everywhere on this and I can't
>> seem to figure
>> this out. I am only familiar with using CF Cookies in the
>> standard way but I
>> have this asp site that I am having to port over to CF and I need to
>> write
>> cookies in CF much the same way we did using ASP. But it seems
>> that with ASP
>> you can give the Cookie a general name to refer to it by. But I
>> am having a
>> hard time figuring this out in CF or if it's even possible.
>>
>> Here is an example of our ASP Cookie...
>>
>> Response.Cookies("RSHold")("AgentNumber") = RSAgent("AgentNumber")
>> Response.Cookies("RSHold")("AgentName") =
>> RTrim(RSAgent("AgentFirst"))+ "
>> " + RTrim(RSAgent("AgentLast"))
>> Response.Cookies("RSHold")("Rank") = RSAgent("CurrentRank")
>> Response.Cookies("RSHold")("EntityID") = RSAgent("EntityID")
>> Response.Cookies("RSHold").Path="/"
>>
>> I need to build this same Cookie using CF but cant figure it out. Am I
>> missing something?
>>
>> This is what I have so far for CF but it's not the same...
>>
>> > path="/">
>> > path="/">
>> > path="/">
>>
>> Any help on this would be grateful thanks.
>>
>> Neal Bailey
>> Internet Marketing Manager
>>
>>
>>
>>
>
>
>
>
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.
RE: CF Cookie & ASP Cookie?
OK guys... I think I have my Cookie kind of figured out now... It seems ASP does not actually store the cookie as complex variables but instead it's more of a comma delimited format using "&" as the delimiter. Anyway now that I figure out that problem I have another... I am storing the values in the cookie like this: - -- But when I look at the cookie value it looks like this: -- NeedUpdate%3D0%26Recognition%3DSupport%26EntityID%3D09%26AgentName%3 DNeal%2BBailey%26Region%3D%26Rank%3D80%26AgentNumber%3D%2540%254009%2B -- For some reason its converting the =,&,+ and % characters to another format. Any idea how I can fix this? Man what a mess... Thanks again.. Neal Bailey Internet Marketing Manager ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219473 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Recall: CF Cookie & ASP Cookie?
Bailey, Neal would like to recall the message, "CF Cookie & ASP Cookie?". ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219472 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: To Jrun update or not to Jrun update?
You should install CF MX 7.01 Updater, and then JRun Updater 6, since Merrimack (CF 7.01) contains only JRun Updater 5 components. -- Fabio Terracini Ian Skinner wrote: >Is there are JRun updater that should be applied after installing a fresh MX7 >multi-server system? Should this be done before the MX7.01 updater is applied? > > >-- >Ian Skinner >Web Programmer >BloodSource >www.BloodSource.org >Sacramento, CA > >"C code. C code run. Run code run. Please!" >- Cynthia Dunning > >Confidentiality Notice: This message including any >attachments is for the sole use of the intended >recipient(s) and may contain confidential and privileged >information. Any unauthorized review, use, disclosure or >distribution is prohibited. If you are not the >intended recipient, please contact the sender and >delete any copies of this message. > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219471 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Cookie & ASP Cookie?
OK guys... I think I have my Cookie kind of figured out now...
It seems ASP does not actually store the cookie as complex variables but
instead it's more of a comma delimited format using "&" as the delimiter.
Anyway now that I figure out that problem I have another...
I am storing the values in the cookie like this:
-
--
But when I look at the cookie value it looks like this:
--
NeedUpdate%3D0%26Recognition%3DSupport%26EntityID%3D09%26AgentName%3
DNeal%2BBailey%26Region%3D%26Rank%3D80%26AgentNumber%3D%2540%254009%2B
--
For some reason its converting the =,&,+ and % characters to another format.
Any idea how I can fix this?
Man what a mess...
Thanks again..
Neal Bailey
Internet Marketing Manager
-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 28, 2005 10:46 AM
To: CF-Talk
Subject: RE: CF Cookie & ASP Cookie?
Neal:
ASP supports something it calls a "Cookie Dictionaries." This is,
essentially an associative array (or structure) of values all referenced by
the same variable name. So, just like with ColdFusion structures you can do
something like:
myStructure.myKey
in ASP, you can do something like:
Response.Cookies("myStructure")("myKey")
In order to support this, ASP creates a cookie named "myStructure" (or
whatever you specify as the name) and sets the cookie value to something
like:
key1=value1&key2=value2
So, to duplicate your ASP code in ColdFusion, you'll need code like the
following:
Note that when you retrieve this Cookie via CF, you'll have to parse the
string and break it up into its original pieces. You could use code like
the following:
And then access each piece via code like:
RSHold["AgentNumber"]
Note, none of this code is tested so there might be some minor issues. But
the logic should be pretty sound.
HTH
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
> -Original Message-
> From: Bailey, Neal [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 27, 2005 5:43 PM
> To: CF-Talk
> Subject: CF Cookie & ASP Cookie?
>
>
> Hey Guys I have been searching everywhere on this and I can't
> seem to figure
> this out. I am only familiar with using CF Cookies in the
> standard way but I
> have this asp site that I am having to port over to CF and I need to write
> cookies in CF much the same way we did using ASP. But it seems
> that with ASP
> you can give the Cookie a general name to refer to it by. But I
> am having a
> hard time figuring this out in CF or if it's even possible.
>
> Here is an example of our ASP Cookie...
>
> Response.Cookies("RSHold")("AgentNumber") = RSAgent("AgentNumber")
> Response.Cookies("RSHold")("AgentName") =
> RTrim(RSAgent("AgentFirst"))+ "
> " + RTrim(RSAgent("AgentLast"))
> Response.Cookies("RSHold")("Rank") = RSAgent("CurrentRank")
> Response.Cookies("RSHold")("EntityID") = RSAgent("EntityID")
> Response.Cookies("RSHold").Path="/"
>
> I need to build this same Cookie using CF but cant figure it out. Am I
> missing something?
>
> This is what I have so far for CF but it's not the same...
>
>
> path="/">
> path="/">
>
> Any help on this would be grateful thanks.
>
> Neal Bailey
> Internet Marketing Manager
>
>
>
>
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219470
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Need Advice- Form Posting to an Outside Server and Dealing with the Response
CFHTTP returns a string of XML in the variable CFTTP.filecontent. You can then interact with it using the cfxml tag: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b21.htm -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 10:39 AM To: CF-Talk Subject: Need Advice- Form Posting to an Outside Server and Dealing with the Response I've not had to deal with this one before, so I'm not 100% sure how to implement this... Basically, here's what I've got: 1. www.mysite.com/My-Form.cfm submits to 2. www.SomeOtherSite.com/form-process.aspx and returns 3. www.SomeOtherSite.com/results.xml I know how to use an XML data source, but I don't know exactly how to go about getting the stuff from "results.xml" back into my application on www.mysite.com. I don't want folks to actually see "results.xml" either, it's just an unformatted page of XML data... CFHTTP? But, I'm still not 100% sure how to implement. I'm googling now and have a CF Reference on my lap, but ain't seeing exactly what I think I need to know yet. Pointers? -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219469 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Positive Press For CFMX
This was just released: http://www.eweek.com/article2/0,1895,1864586,00.asp It's nice to finally see CFMX get the positive press it has deserved for quite a while. Hats off to the Merrimack team for a job done extraordinarily well! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219468 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL row select?
Sure it works nicely, but if you have 1000 users pulling millions of rows each, that's going to put a large load on your server that really doesn't need to be there, not to mention network traffic if the DB server and CF server are separate. That's what I'm trying to avoid. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 12:25 PM To: CF-Talk Subject: RE: SQL row select? Here's a post from a DBA I'm friends with: Just pull the entire query over to CF and use query of queries, to grab your "paged" row sets. I work with record sets of millions and it works very nicely. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219467 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL row select?
Sure it works nicely, but if you have 1000 users pulling millions of rows each, that's going to put a large load on your server that really doesn't need to be there, not to mention network traffic if the DB server and CF server are separate. That's what I'm trying to avoid. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 12:25 PM To: CF-Talk Subject: RE: SQL row select? Here's a post from a DBA I'm friends with: Just pull the entire query over to CF and use query of queries, to grab your "paged" row sets. I work with record sets of millions and it works very nicely. -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 10:59 AM To: CF-Talk Subject: Re: SQL row select? Select top 50 * from table Where id not in ( select top 199 id from table order by date, alpha) order by date, alpha that works but what if you are paging through a million records as suggested before? wouldnt the inner query select the top 999,999 rows? IE Select top 50 * from table Where id not in ( select top 99 id from table order by date, alpha ) order by date, alpha I think thats what Mike K was talking about. On 9/28/05, Andy Matthews <[EMAIL PROTECTED]> wrote: > Did no one see this post? After reading, and re-reading the original > post, it looks like this simple SQL statement is the answer (assuming > that MSSQL supports the LIMIT clause: > > SELECT * > FROM tablename > LIMIT #startrow#, #totalrecords# > > or > > SELECT * > FROM tablename > LIMIT 200, 50 > > andy matthews > web developer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --//-> > > -Original Message- > From: Andy Matthews [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 8:57 AM > To: CF-Talk > Subject: RE: SQL row select? > > > I don't use MS SQL but doesn't it support the LIMIT keyword in the > SELECT statement? > > SELECT * > FROM tablename > LIMIT #startrow#, #totalrecords# > > or > > SELECT * > FROM tablename > LIMIT 200, 50 > > andy matthews > web developer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --//-> > > -Original Message- > > >Ok, I feel like this should be something simple but my brain just > >isn't working this morning. Besides using CFOUTPUT with the startrow > >and maxrows attributes, is there a way in my SQL itself to specify > >that I want it to grab 50 rows starting at the 200th row. I'm trying > >to make a paged approach to a query that could potentially have about > >20,000 records returned. I'd much rather just have MS SQL return 50 > >rows at a time by telling it which row to start at rather than having > >it return a 20,000 recordset to CF and then only output 50. I'm > >hoping this is something easy and my brain just hasn't woken up yet. > >Any thoughts would be appreciated. > > > >John Burns > >Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | > >Web Developer > > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219466 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
