DNN Hosting Register Login
 
Latest Discussions Minimize
UMG 5.2.2 by facuseh01
Hello,I have two questions:1. Does UMG 5.2.2 work with Presentation Pack 3.1? 2....
Comments by userID by daviking
Thank you for a great product! I am really enjoying working with the new UMG5 ga...
users add albums by OKCChopper
I want my users to be able to add there own albums but not delete others.. can t...
UVG Videos to play in Smart Phones by Ibbs
HiIs it possible for UVG videos to be played on Smart phones. e.g black berry or...
Copy to another page by OKCChopper
I want to copy the module to another page and also have access to the same album...
How to add a link to view all videos? by anthonyar
Sorry this is a newbie question...i want to add a link to the menu to VIEW ALL t...
Personal vs Profile mode by coolvibe
I carefully read the description for both modes. but, I'm not exactly sure which...
Permission Check Failed by tbredweb
I am getting the message: The binary pack is not installed, or ASPNET/Network_Se...
Furniture Showroom major crash by myearwood
Hi PengstenI sent you an email via service@bizmodules.net. It concerns the furni...
Top photos windows size restriction by OKCChopper
I have it so that i can restrict the size of the photos. However since some arn...
Our Partnership Minimize
If you are looking for good DNN hosting, then PowerDNN is the best DNN host around!
Support Forum Minimize
Forums > Ultra Media Gallery > Suggestions and Ideas
Subject: Default price
Prev Next
You are not authorized to post a reply.

Author Messages
John Endean
Posts:13
Silver Member
01/30/2008 4:19 AM  
Hi,

I think it would be really useful to have a default price for items added to an album, so that when multiple items are synchronized or uploaded, they are automatically available for sale at this default price.  At the moment, if you upload 200 pix you have to go through and edit the price manually - takes too long!

Thanks,
John
Pengtsen R
Posts:5191
01/30/2008 7:08 AM  
you can write a sql trigger to do this job. if the price is zero then the trigger applys a default price.
Pengtsen R
http://www.bizmodules.net
John Endean
Posts:13
Silver Member
01/30/2008 7:17 AM  

Thanks for that, any chance of an example script?

John
Pengtsen R
Posts:5191
01/30/2008 7:39 AM  
I remember some one have an example, if anybody have this script please post it here.

if you didn't get it I'll write it for you when I get back - I'm going for a short travel 8 hours later.

thanks.
Pengtsen R
http://www.bizmodules.net
John Endean
Posts:13
Silver Member
02/05/2008 4:12 AM  
Hi,

Could you please post the SQL script for this trigger?

Many thanks,
John
Pengtsen R
Posts:5191
02/06/2008 7:18 PM  
I didn't write trigger for years, I use sql server help to write this simple trigger:

CREATE trigger UMG_ApplyDefaultPrice
on BizModules_UPG_Download
after insert
as

declare @price money
declare @itemid int
select @itemid=i.Itemid, @price = isnull(i.Price, 0) from inserted i inner join BizModules_UPG_Download D on I.ItemId=D.ItemId
if @price = 0
update BizModules_UPG_Download set price = YOUR_DEFAULT_PRICE_GOES_HERE where itemid=@itemid
Pengtsen R
http://www.bizmodules.net
John Endean
Posts:13
Silver Member
02/07/2008 12:51 PM  
That worked a treat, thanks!
Pengtsen R
Posts:5191
02/07/2008 6:23 PM  
great.
Pengtsen R
http://www.bizmodules.net
You are not authorized to post a reply.
Forums > Ultra Media Gallery > Suggestions and Ideas > Default price
Enterprise level DotNetNuke Solutions Copyright © 2005-2008 BizModules   |  Contact Us  |  Terms Of Use  |  Privacy Statement