How to horizontal loop with a grouped output
I'm using a horizontal looper with grouped output, but it's being thrown off BY the grouped output. It runs off the recordcount which of course can be greater than the actual amount of items *shown*. What would be a work around for this? Here's a page where it's up and running. (no comments on the girl please! :) ) http://209.200.101.151/itemdetail.cfm?MODEL=3003 Thanks, Will #colorname#
use RandRange for rotating banner image?
Question: Why couldn't I use RandRange in a query to rotate a banner image? I usually use JS buit it looks like a bunch of crap code. *This* would be simple. I have a tblbannerimages with ID# as PK, imagename is like image1.jpg or whatever. ID's would be 1, 2, 3, 4, 5 let's say Now I run a query to retrieve one to output it to the banner everytime the page loads. SELECT ID, imagename FROM tblbannerimages WHERE ID = #RandRange(1,5)# Then it goes in the banner. ~| 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:197187 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
I got it! Output grouped query horizontal loop thingamajig.
Here's my final code that worked in case it may help someone else in the future. Is nothing fancy, but here it is anyway! Thanks Charlie and Ade, Will #getprodsbycategory.prodmodeltitle# $#getprodsbycategory.prodsellprice# ~| 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:197233 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
CF/programming experience from the list?
I just wanted to try and gauge where I'm at right now in terms of programming prowess by having everyone offer their experience with programming in general and CF. What most of you do is pretty amazing to me, so I'd like to know where I stand and what I need to do to get more like you guys! Me - 2 years programming - 2 years CF Thanks, Will ~| 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:197335 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
A toughie Inline frame question
On my clothing site, I'm using an inline frame to display details about a given item. You can see it here: Select a color and size. http://209.200.101.151/itemdetail.cfm?MODEL=3003 Everything works great, except ONE thing. It' like going into a black hole with that inline frame, once you go in you can't come back out. lol! I'm using a remote cart, Mal's, and having to use target=blank because the cart page won't fit inside the iframe. The thing is, Mal's offers a feature where you can append cart contents, totals, item count BACK to your site with a continue shopping button. But I can't think of a way to link back to the model page with iframe without it being in the *new* window. Hmm I guess the best option would be do away with the iframe thing altogether, and when they select a color and size, it takes them to the new buy.cfm page as a whole page itself. But I like the way this works, it seems really easy and smooth. Any suggestions would be appreciated! Thanks, Will ~| 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:197574 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: A toughie Inline frame question
Very very interesting. I'm having a look at it now. Thanks, Will ~| 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:197596 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
RandRange() with a structure
I'm creating a structure of two images. Then I want them to rotate when the page reloads. I've been doing this fine with my db and using randrange in the WHERE, but how would I make it work with my structure? Thanks, Will ~| 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:198006 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: RandRange() with a structure
Excellent guys! Thanks a ton! Will ~| 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:198035 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
Problems at CrystalTech have gotten ugly!
Ok, we're on our 3rd week I think with the session invalid errors at CT. Tim U., CEO, seems to have fanned the flames, at least in MY mind. Question: Is ANYone out there experiencing the same problem with their shared server hosts? Anyone??? Especially read the last 2-3 posts. I'd like to know myself if anyone else is experiencing this! http://www.crystaltech.com/forum/topic.asp?TOPIC_ID=10597 Thanks, Will ~| 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:198038 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: Problems at CrystalTech have gotten ugly!
They're saying it's a CF7 problem, which I think is BS! I agree though, switching sounds logical, it's just tough when you have so much tied up in one host. Moving makes me wanna toss my cfcookies! Will ~| 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:198042 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: Problems at CrystalTech have gotten ugly!
good one Tango! cfdump...lol! They way you and dave talk about hostmysite, it must be a good one. I had a look at their hosting and it *does* look nice. I'm still on the fence here. This is the only realy problem I've had at CT in two years, other than the three times they haven't had a cfx installed they said they supported. :) Will ~| 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:198048 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: Problems at CrystalTech have gotten ugly!
>why don't you try to fix it on your end? yes it's a problem, don't stop >bothering them about it, but please spare us. I just had to backspace what I had typed...sorry about that. :) I asked a simple question. Is anyone else experiencing these problems? Will ~| 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:198049 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
Anyone used these tools?
http://www.smartsurfonline.com/cfpowertools/ And PLEASE don't post with, "cf-community please". SHEESH! Will ~| 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:198051 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: Problems at CrystalTech have gotten ugly!
> It seems they are the only ones having the problem (and they are > clearly trying to blame Macromedia). I'm glad I left them about 3 > years ago. No hard feelings (because it wasn't that bad), but I > couldn't take the lack of transparency when dealing with problems. In > other words, when everything works fine, Crystaltech is a joy to work > with, but when there are bumps on the road, Mr Jekyll takes over... You're exactly right! This is what I'm seeing. And there's a certain arrogance... ~| 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:198053 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: Problems at CrystalTech have gotten ugly!
> That being said, can we move talk about how good or bad crystaltech is > to one of the other lists and post on the technical problem and > solutions here? Thanks for the info. If you'll read my original post, here was the original question. "Question: Is ANYone out there experiencing the same problem with their shared server hosts? Anyone???" I'm wondering if this would be considered technical? Will ~| 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:198114 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: testing....is this thing on?
Sorry, not laughing at you. I sincerely appreciate the insane amount of >work you provide for free for us! DITTO!! > >Have a good weekend all, I am off to down a few beers! Yee-ha, it is the >WEEKEND! Beer? what's that?? Off for a few long islands and codin' for me! cfset mydrinkofchoice["longislandicedtea"]> Willeroo! (.netwill) p.s. I already had a few! ~| 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:201239 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: testing....is this thing on?
>Better yet, some Mike's Hard Lemonade! C'mon connieplease! We're talkin' TJ Toad's Long island Iced tea. 37% alchohol...crap, you should see all the backspaces and corrections I just did here...lmao! I even opened up some window I never knew existed!! Anyway, Mike's ain't bad, but *this* stuff is wicked! What's so bad is I think my codin' is better!! ICK! Willerooni (.netwill, aspwill, willtheinstigationist) How'd I just do that??? ~| 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:201247 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: testing....is this thing on?
>Hell, that does sound, good, pass me one! Sorry, too late, it's gone! And so am I... gnight everyone! POOF! ~| 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:201250 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: testing....is this thing on?
>Please leave declarations regarding your personal preferences to the >CF-Community list ;-) Sorry about that guys. I shouldn't post that late on a friday evening! Will ~| 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:201263 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
Can we pitch in to send one of the goodguys to CFUNITED?
Hey all, As you know, Jared R-H posts quite a bit here. He's helped me out a ton, and probably has helped many of you as well. He's an exceptional CF'er, JS'er, blogger and provides plenty of great code for us to use. As of right now Jared will not be able to attend CFUNITED do to some unfortunate personal events, so I'd like to ask everyone on the list if they could chip in to help him make it to CFU. I'm not going to be able to make it myself, but if I can chip in to help someone else go I will. And I can't think of anyone better than him for the trip! If you feel the urge to help another CF'er get to CFU, maybe you can think about visiting his blog and making a small donation. http://www.web-relevant.com/blogs/cfobjective/ I'll be donating $25 myself. If only 30 of us were to donate that amount, it'd go a long way to get him there. Thanks much, Will ~| 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:201437 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
Built a dirty word checker, testing please?
Hey, I've built a cool little tool I'm callin' nodirtywords. It's just what the name implies, code that check to make sure a dirty word hasn't been submitted via form data. Iset it up as a web service, but also built a custom tag AND just a plain ol' CFC. For now I wanted to see if some of you could test out the web service and give me some feedback/suggestions. I know WS isn't the way to implement this, but it's just plain fun to use it that way! :) dave l., please don't test it out, my cf server probably can't handle it! :) Thanks to Jared for his help! Test it out right here: http://www.wtomlinson.com/checkcussform.cfm Here's some explanation and example code I've been using. Setup a text input named "text". A structure named "finalresult" will return a variable named finalresult.theresult with a value of either "pass" or "fail". There's also a variable named finalresult.wordcount that returns the word count of text submitted. This could be used for a server side check that ensures text didn't exceed the max specified. Use the values to do whatever processing you'd like. Example: Run an insert query with the clean text Then output it like this. Verdict on text is: #finalresult.theresult# - word count is: #finalresult.thewordcount# Or just cfdump it. Thanks, Will ~| 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:202074 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