Hello again
Not sure if I explained myself properly. Basically I there are 3 photo
galleries on the website. I want a website visitor to be able to select which
gallery to view (or they can view all the photos).
I have a drop down selection to let them select which gallery to view.
Once they have selected a gallery and pressed view gallery the images should
appear below. I am including the images through an include.
The problem is at present that the images are not displaying.
Any ideas as to why.
Thanks in advance.
> Hi there
>
> I have 2 small CF programs and cant understand why the code is not
> working.
>
> Basically what I am trying to do can be seen on the website:
>
>
> This is the code from the first program gallery.cfm
>
>
> <CFIF IsDefined("form.submit")>
> <cfinclude template="inc_photo_gallery.cfm">
> <br />
> <br />
> <cfelse>
> <cfquery name="qGetGallery" datasource="#request.db_dsn#"
> username="#request.db_login#" password="#request.db_pwd#">
> SELECT *
> FROM galleries
> </cfquery>
> <form name="photogallery">
> <select name="GalleryID">
> <option value="Please Select an Image Gallery" selected>Please Select
> an Image Gallery</option>
> <cfoutput query="qGetGallery">
> <option value="#qGetGallery.GalleryID#">#qGetGallery.
> galleryname#</option>
> </cfoutput>
> </select>
> <br />
> <br />
> <input type="submit" name="Submit" value="Display Gallery">
> </form>
> <br />
> <br />
> <br />
> </p>
> </cfif>
>
>
> The next piece of code is from the include program
>
>
>
> <cfquery name="qgetpics" datasource="#request.db_dsn#"
> username="#request.db_login#" password="#request.db_pwd#">
> select *
> from photoadmin
> <cfif form.galleryid eq '1'>
> where galleryid = '1' and onweb = '1'
> </cfif>
> <cfif form.galleryid eq '2'>
> where galleryid = '2' and onweb = '1'
> </cfif>
> <cfif form.galleryid eq '3'>
> where galleryid = '3' and onweb = '1'
> </cfif>
> <cfif form.galleryid eq '4'>
> where onweb = '1'
> </cfif>
> </cfquery>
>
> <p><div class="gallery"><cfoutput query="qgetpics"><a
> href="data/images/#pic_large#" rel="lightbox[sample]" title="Yeng Tan
> Floral design"><img src="data/thumbnails/#pic_thumbnail#" border="0"
> /></a></cfoutput><!--[if lte IE 6]><script src="engine/js/pngfix_vlb.
> js" type="text/javascript"></script><![endif]-->
> </div></p>
>
>
> www.yengtanfloraldesigner.com.au/gallery.cfm
>
>
> Thanks in advance for feedback - I expect its probably just something
> dumb that I have forgotten as I havent been doing much coding lately.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325511
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
