Help !!!
Just been asked about 40mins ago to set up an offer on the web - and we have hardly
read the documentation let alone got our collective heads around this BUT so far I have managed to set it all up following the documentation and our website now recognises
the promotion code but will not take me to the performance. If enter our website and
ignore the promotion code I can proceed to buy tickets. Whether I login or not, if I use the
promotion code i get the message "although ... is on sale, the performance is not currently available ..." or words to this effect. I checked all the dates, appeals, source codes pricetype_MOS etc and the price type is available in security - any other suggestions please
Darrell
DOH !!!
just found that the promo code works with the source code ID number but NOT with the name of the promo code !! any simple way to reverse that?
source_no is int type. you cannot do anything.
web api WP_GET_SOURCE_NO
ALTER PROCEDURE [dbo].[WP_GET_SOURCE_NO] @sessionKey varchar(64) = null,@promo_code varchar(80) = null,@source_no int = null
You need to confirm @promo_code get the value, not the @source_no.
ben