Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...

Or... now make it easy with Facebook Integration
Connect via Facebook

Top Sellers

Dynamic Registration 4.0

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery 4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

XMod Pro 2.7 - Forms and Views for Databases

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

Smith Shopping Cart v3.88

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

Event Calendar and Registration 4.0

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

DNN Modules

Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
Question about SQL completion event
Last Post 10-06-2008 01:02 PM by Chad Nash. 5 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Jim EvansUser is Offline
going with the flow
going with the flow
Posts:30
Avatar

--
10-06-2008 08:03 AM

    I have a from that, when submitted, does a SQL insert into a custom table. The table has an Identity column which is the new Order number.

    I then have an email compl. event that sends the details of the order to an office email account.

    The problem I have is the Identity column value. Is it possible, perhaps in the SQL event, to lookup the value after the insert and assign it to a token so that it can be used in the email event? The office personnel need this Order number to complete the processing of the order and the Installer needs this Order number when he completes the install so that the new customer can be added to the database.

    Jim

     
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    10-06-2008 09:22 AM

    Jim,

    Currently this feature does not exist. We will review adding it, possibly allowing the SQL Event to return a value and if present used as a token based on the SQL Event Name. For now though the recommended way to handle this would be to use the token available $(UniqueCompletionID). This is a global unique identifier (GUID) and is actually recommended over a standard auto number identity column etc... If this is a new implementation this would be easier to handle, but either way you can then reference this within the email event and also use it as a primary key?

    -Chad
    Jim EvansUser is Offline
    going with the flow
    going with the flow
    Posts:30
    Avatar

    --
    10-06-2008 09:38 AM
    Thanks, Chad but their entire system uses this ID field and it is a 10 digit numeric field.

    Any idea yet when 2.7.1 will be released?

    Jim
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    10-06-2008 09:57 AM
    Hi. Actually it will be 2.7.2 as we had a few minor fixes going in and it should be released by the end of the week. The fixes relate to drag and drop issue if there are no other fields on the form currently, and a fix for the settings relating to hiding a field by role saving correctly but not getting set back if you edit a field. This won't offer anything for your specific situation though. Are there many users submitting these forms? You could default a hidden field to the next item in the list (CurrentCount +1 as a SQL default) but this wouldn't work if two users went to the form at the same time etc...
    Jim EvansUser is Offline
    going with the flow
    going with the flow
    Posts:30
    Avatar

    --
    10-06-2008 10:11 AM
    No, I am looking forward to the hidden fields being used to trigger events feature

    I have thought of using your solution, Max(OrderNumber)+1 but, with my luck another person in the office will submit an order first...might get messy since this Order number follows the order through the entire process.

    Jim
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    10-06-2008 01:02 PM
    Hi. Yes I have been following Sean and your threads related to this. I am not sure the enhancement will make the 2.7.2 release but hopefully (right now its just these two patch fixes for drag/drop and hide by role). We have added the features to create a question event based on a hidden field, and although this does work it does not currently work based upon no postback/querystring value. We are reviewing this as it should/this would be the ideal scenario for this feature however question events were originally set to be based on a postback so we are reviewing this code.

    -Chad
    You are not authorized to post a reply.

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
     
     

    Join our mailing list...

    Get current news and events the easy way
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi