Fixing a small piece of code

[Toby King]

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:325510
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4