Recently Viewed...
To help you navigate to pages you most recently visited, select from the links below.
Product Forums
Sharepoint Forums
Newsletter
Dynamic Forms Demonstrations
Page Tags
DNN Modules
SnowCovered Top Sellers

Opt In Email 4.0

'Relationship Building' and 'Communication' are two essential nuts and bolts for a business to prosper. This module allows you to bridge both of these and easily generate continuous awareness of your web site, products and services. Your prospects and customers will greatly appreciate this featur

Ultra Flash Player 6.1(16-in-1)

A 16-in-1 dnn module.Powerful yet easy to use. Capable of producing a multitude of functions including:Image rotator/Numeric rotator/ Mp3 player/Wmv player/ Flash video player /YouTube video player/Multimedia player / Text-to-speech podcast / Flipping book player/Banner topic player/Silverlight albu

XMod 5.1

Version 5 of the perennial best-selling tool for creating data-based solutions in DNN without custom programming. This version focuses on greater flexibility, expandability, and ease-of-use.

Ultra Video Gallery 2.4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to add videos in various format and automatically convert them to flv format, you also can add videos from embed code and play them in our integrated flash video player.

Active Forums

The award winning discussion forum and community solution for DotNetNuke is now even better. When you need to build the best community site, you need the best module, Active Forums!

Gloss // ALL COLORS! skin // XML Flash // W3C CSS XHTML1.0

Gloss is the first ALL COLORS! skin, featuring a powerful XML-based flash and being 100% W3C CSS XHMTL1.0 compliant. Tune it yourself on the fly, changing colors, backgrounds, containers, text color and size, width and more! Brilliant!Available for DNN4 and DNN5

Open-DocumentLibrary v3.0

Powerful, Ajax Enabled, Easy to Use. Document Management has never been better. Open-DocumentLibrary allows DotNetNuke users to share and manage documents in a flexible, intelligent way, offering granular control over Folder and Document access.

Minimalist by Evan O'Neil - ALL NEW !

ALL NEW ! - Minimalist includes skin packs in 12 great colors. Each color has Flat, Gradient and Glass versions. Feature rich XML Flash header, perfect for just about any purpose. 9 Different menu options in each skin pack; 3 horizontal menus, 3 vertical menus and 3 all-new Twin level menus . . .

Live Content v1.6.1 :: Web 2.0

Live Content uses Web 2.0 approach to provide a Rich User Interface and streamlines content presentation by overlaying content on current page. Overlay images, videos, audio, text/html content, flash, dotnetnuke modules, and external content. Experience the demo...

Ultra Media Gallery 5.4

Ultra Media Gallery is the most popular photo gallery and media gallery solution for DotNetNuke, UMG offers 10 different flash player to browse your gallery with completely different user interface experience.
    |   Register   |   Thursday, January 08, 2009   
Data Springs Product Forums...
Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration
Subject: SQL - Expiry Date Confusion
Prev Next
You are not authorized to post a reply.

Author Messages
Kelly
Posts:36
paddling down the creek
paddling down the creek
01/05/2009 11:55 AM  

I have two completetion events firing after (PayPal) registration, one to add the new user to a role, then one to set the expiry date using sql.

 

Everything works fine except I get an expiry date that is way out ... my SQL completetion event is ...

 

Update UserRoles Set ExpiryDate = '15/8/2009' where UserID = $(UserID) and RoleID = 33

 

I've also tried 8/15/2009, and in both cases I get an expiry date of 9/14/2022 ??? Can't figure out why.

 

I understand that Add Role events happen before SQL events, and in the Role Event I do not specify an expiry date .. blank.

 

Kelly
Kelly
Posts:36
paddling down the creek
paddling down the creek
01/05/2009 12:59 PM  
more info ... I tried the query directly in my SQL tool and it worked fine. So then I tried another date in the SQL completion event of 06/31/2009 and the result that got saved with the user record is 2/4/2009 ????


Can't figure out where these new dates are coming from.


Kelly
Kelly
Posts:36
paddling down the creek
paddling down the creek
01/05/2009 1:06 PM  
still more info ... my purchase form was created by exporting a similar page on the site with some of the same completion event names ... could that be an issue .. I assumed they were distinct by module ID. Although only this particular DR module instance I'm having trouble with uses SQL completion events.


Kelly
Kelly
Posts:36
paddling down the creek
paddling down the creek
01/05/2009 1:09 PM  
Sorry for so many post on the same thing ... thought I should mention this is DR 03.20.65 on DNN 4.8.4


Kelly
Chad
Posts:2387
river guide
river guide
01/05/2009 3:57 PM  
Kelly,

Hi!

Role events to process before SQL events, however this is assuming they had the same sort order (actually until 4.0 is released the sort order feature is not an option in the completion events right now). I think the sort order is based on the event name in ascending order, so try naming the role event something like AAA and the SQL event something like ZZZ. A few other things...

1. Try disabling PayPal or your payment gateway initially, this will help to determine if your SQL Events are firing and will make testing easier.

2. It shouldn't matter what you name the event name (except for the sort order of the event) so I wouldn't worry about that.

I would setup the module to be in debug mode, adding &Debug=True to the querystring when the page loads. Whenever you submit the form you will see the exact events that are fired along with the exact SQL query that is being fired etc...

-Chad
Kelly
Posts:36
paddling down the creek
paddling down the creek
01/05/2009 4:12 PM  
Hi Chad, thanks.

I'm pretty sure all the events are firing fine, an expiry date does get set by the SQL completion event .... just not the right date. Somehow it's getting changed in the process. weird! 8/15/2009 = 9/14/2022 and 9/14/2009 = 2/4/2009

Is there something that parses the SQL in a completion event that could change dates? a replace delimiter or character?

I've added debug to the paypal string, and will try the other suggestions ... It doesn't appear there is any order to the completion events list certainly not alpha betical ... when I add one it appears anywhere in the list arbitrarly.


Kelly
Chad
Posts:2387
river guide
river guide
01/05/2009 4:36 PM  
Hmmm... Your query is using '15/8/2009', maybe you nee to be using '08/15/2009'? I would maybe even try casting the string as a date in SQL etc...

-Chad
Kelly
Posts:36
paddling down the creek
paddling down the creek
01/05/2009 4:36 PM  
K, correction to my earlier statement, it seems that there is no order to the way completion events fire. They do not follow the order in the dropdown list, nor do they fire in order by type ... Role events do not fire first (I had read in another post that they do), SQL events fire in any sequence with role events.


With debug on I can see that my SQL set expiry date event is happening before the add role event .. so there's the problem


How to fix? if role events went first that would work. If events fired by alpha name I could make that work ... if there were a sort order I could set in the db that would work too.


Thoughts?


Thanks


Kelly
Chad
Posts:2387
river guide
river guide
01/05/2009 4:42 PM  
There is a stored procedure I think called DynamicRegistration_GetDynamicEvents I think, you could modify this stored procedure to order by the event name probably. We are adding a feature in the 4.0 release (it already exists in Dynamic Forms) that allows you to set the sort order via a number (i.e. 0 comes before 1 etc...) so you might go with modifying this stored procedure as a work around for now.

-Chad
Kelly
Posts:36
paddling down the creek
paddling down the creek
01/05/2009 4:50 PM  
Thanks Chad .. that will work for now, I'll give it a try .. and thanks for the quick reply!



DR 3.20.65 is really nice .. i like the dashboard idea with the images. A little more AJAX would be on my wishlist!


Best to you in 2009


Kelly
Kelly
Posts:36
paddling down the creek
paddling down the creek
01/05/2009 4:51 PM  
Sorry, I was refering to Opt-in email dashboard .... I'm a little scattered today getting back into the swing of things!


Kelly
You are not authorized to post a reply.
Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration > SQL - Expiry Date Confusion


ActiveForums 3.7

Copyright 2005 - 2009 by Data Springs, Inc.
Terms Of Use | Privacy Statement