Thanks for the update.  I was able to see what you were talking about.  I think a simpler method would be for me to edit the underlying stored procedure that is being used by dg.aspx.  I could simply pass in a fake module id and process the query differently in those special cases.  Otherwise I would have to create a lot of fake module settings records.

I looked at various stored procedures but I'm not sure which one is doing the looking up that ultimately takes in a module id and returns the server directory or list of photo files that are being returned by dg.aspx

Can you tell me what stored procedures are being called by dg.aspx.  I assume it passes in the module id to a stored procedure that returns the server path for file list.

Thanks.

Else
SELECT
 SettingName,
 CASE WHEN LEFT(LOWER(ModuleSettings.SettingValue), 6) = 'fileid'
  THEN
   (SELECT Folder + FileName 
    FROM Files
    WHERE 'fileid=' + convert(varchar,Files.FileID) = ModuleSettings.SettingValue
   )
  ELSE
   ModuleSettings.SettingValue 
  END
 AS SettingValue
FROM ModuleSettings
WHERE  ModuleId = @ModuleId

I ran the stored procedure in sql server and go the expected result.  I then constructed the URL that the object tag is using that calls dg.aspx (I copied it below) and looked at the result after these stored procedures have been changed.

http://www.buckheadpreserveatl.com/DesktopModules/BizModules%20-%20UltraPhotoGallery/DG.aspx?ModuleId=640&alias=www.buckheadpreserveatl.com&configuration=/Portals/6/UltraPhotoGallery/640/UMGClasssicCfg.xml&resourceFile=/DesktopModules/BizModules%20-%20UltraPhotoGallery/Swf_Resource/UltraPhotoGallery.swf.xml&alias=www.buckheadpreserveatl.com&baseUrl=/DesktopModules/BizModules%20-%20UltraPhotoGallery/&myEmailAddress=thayer@silverelm.com&galleryUrl=http://www.buckheadpreserveatl.com/PlansAvailableHomes/HomeDetails/tabid/210/Default.aspx?PhotoId=[PHOTOID]

and this is the result I got back from that call:


-
-
 
 
 
 
 
 
 

You'll notice that the imagepath should have been been 'test' but instead it was the same value it was before I made the stored procedure change.  I don't know how that could possibly return that value if it is in fact calling GetModuleSetting.  As a side note I made a similar change to the GetModuleSettings stored proc as well in case it was using that one.

Are you sure it uses the GetModuleSetting stored procedure to get that value?  If so what am I missing?  If I can just get the right procedure I think this will be an easy and effective way to do what I need.

Thanks for the help.  I feel like we are close but need the right procedure call and I can't follow the flow behind the scenes without seeing the source code behind dg.aspx.