Dynamically creating multiple pages/rows of images from a query
Would like to create a preview page(s) of results froma search function from an image catalog. Displaying 1 image per row seems easy enough, but we would like to display 3 images per row and either 3 or 4 rows per page. Is a loop or multiple loops within a loop the only way to output 3 results per row as well as multiple rows? Or am I approaching this from a wrong-headed point of view. My mind tells me it should be much easier than what I'm thinking, but for the life of me I can't see how. Thanks, Charles Nahm ~| 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:189663 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: Dynamically creating multiple pages/rows of images from a query
I've done something similar in the past. You just have to be strategic with your tags. SELECT image_name FROM images Simple (and untested) but that should give you the idea. On Fri, 7 Jan 2005 12:11:46 -0500, Charles Nahm <[EMAIL PROTECTED]> wrote: > Would like to create a preview page(s) of results froma search function from > an image catalog. Displaying 1 image per row seems easy enough, but we > would like to display 3 images per row and either 3 or 4 rows per page. > > Is a loop or multiple loops within a loop the only way to output 3 results > per row as well as multiple rows? Or am I approaching this from a > wrong-headed point of view. My mind tells me it should be much easier than > what I'm thinking, but for the life of me I can't see how. > > Thanks, > Charles Nahm > > ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189665 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: Dynamically creating multiple pages/rows of images from a query
Hiya - The way I do it is to "simply" loop through the query once, but what you need to do is know first of all how many columns you want to display. This is pseudo code (i.e. it wont work :) and would need you to write it properly yourself of course... Something like that OR (probably easier) If you're using CSS for formatting and quite hot on how to make stuff align you could use divs to display xx columns rather than table cells. You could then use the myQuery.currentrow to decide wether to open a new DIV or close an existing one. I'm in a rush to get out so I'm sorry if it doesn't make sense immediately. Please ask if your unsure. Martin Parry Macromedia Certified Developer http://www.BeetrootStreet.co.uk -Original Message- From: Charles Nahm [mailto:[EMAIL PROTECTED] Sent: 07 January 2005 17:12 To: CF-Talk Subject: Dynamically creating multiple pages/rows of images from a query Would like to create a preview page(s) of results froma search function from an image catalog. Displaying 1 image per row seems easy enough, but we would like to display 3 images per row and either 3 or 4 rows per page. ~| 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:189666 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: Dynamically creating multiple pages/rows of images from a query
Something along these lines might get you started. #query.column# Off the top of my head, AKA debugging no doutedly necessary. This could also be very easily modified to create other structures to display the output. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning ...-Original Message- ...From: Charles Nahm [mailto:[EMAIL PROTECTED] ...Sent: Friday, January 07, 2005 9:12 AM ...To: CF-Talk ...Subject: Dynamically creating multiple pages/rows of images from a query ... ...Would like to create a preview page(s) of results froma search function ...from ...an image catalog. Displaying 1 image per row seems easy enough, but we ...would like to display 3 images per row and either 3 or 4 rows per page. ... ...Is a loop or multiple loops within a loop the only way to output 3 ...results ...per row as well as multiple rows? Or am I approaching this from a ...wrong-headed point of view. My mind tells me it should be much easier ...than ...what I'm thinking, but for the life of me I can't see how. ... ...Thanks, ...Charles Nahm ... ... ... ~| 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:189667 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: Dynamically creating multiple pages/rows of images from a query
Thank you very much Ian, Martin and Al. Your way is much better than my way of thinking for sure. I appreciate the virtual smack upside the head. Charles > -Original Message- > From: Ian Skinner [mailto:[EMAIL PROTECTED] > Sent: Friday, January 07, 2005 12:25 PM > To: CF-Talk > Subject: RE: Dynamically creating multiple pages/rows of images from a > query > > > Something along these lines might get you started. > > > > > > > > #query.column# > > > > > > > > > > > > Off the top of my head, AKA debugging no doutedly necessary. > This could also be very easily modified to create other > structures to display the output. > > -- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > > > ...-Original Message- > ...From: Charles Nahm [mailto:[EMAIL PROTECTED] > ...Sent: Friday, January 07, 2005 9:12 AM > ...To: CF-Talk > ...Subject: Dynamically creating multiple pages/rows of images > from a query > ... > ...Would like to create a preview page(s) of results froma search function > ...from > ...an image catalog. Displaying 1 image per row seems easy enough, but we > ...would like to display 3 images per row and either 3 or 4 rows per page. > ... > ...Is a loop or multiple loops within a loop the only way to output 3 > ...results > ...per row as well as multiple rows? Or am I approaching this from a > ...wrong-headed point of view. My mind tells me it should be much easier > ...than > ...what I'm thinking, but for the life of me I can't see how. > ... > ...Thanks, > ...Charles Nahm > ... > ... > ... > > ~| 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:189671 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: Dynamically creating multiple pages/rows of images from a query
Instead of using tables for your layout, you might want to consider using CSS instead, and avoid the issue of figuring out columns and rows. For a helpful example/tutorial, see http://www.alistapart.com/articles/practicalcss/ ~| 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:189677 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