$(DSParam1) = $(UniqueCompletionID)

Error: DSParam1 is not defined
Source File: http://192.168.0.44/ATM/js/dnncore.js
Line: 23

if (sLoadHandlers != null)
   eval(sLoadHandlers);

alert($(DSParam1))

Error: DSParam1 is not defined
Source File: http://192.168.0.44/ATM/js/dnncore.js
Line: 23

if (sLoadHandlers != null)
   eval(sLoadHandlers);

alert($DSParam1)

Error: $DSParam1 is not defined
Source File: http://192.168.0.44/ATM/js/dnncore.js
Line: 23

if (sLoadHandlers != null)
   eval(sLoadHandlers);

// Thanks to broofa over at
// http://stackoverflow.com/questions/...javascript
function getGUID() {
   return 'xxxxxxxx-xxxx-yxxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function (c) {
      var r = Math.random() * 16 | 0, v = c == 'x' ? r : (r & 0x3 | 0x8);
      return v.toString(16);
   }).toUpperCase();
}

// Thanks to Steven Levithan
// http://blog.stevenlevithan.com/arch...javascript
function trim10(str) {
   var whitespace = ' \n\r\t\f\x0b\xa0\u2000\u2001\u2002\u2003\u2004\u2005\u2006\u2007\u2008\u2009\u200a\u200b\u2028\u2029\u3000';
   for (var i = 0; i < str.length; i++) {
      if (whitespace.indexOf(str.charAt(i)) === -1) {
         str = str.substring(i);
         break;
      }
   }
   for (i = str.length - 1; i >= 0; i--) {
      if (whitespace.indexOf(str.charAt(i)) === -1) {
         str = str.substring(0, i + 1);
         break;
      }
   }
   return whitespace.indexOf(str.charAt(0)) === -1 ? str : '';
}

// Our code starts here:
var UCID = null;
if (UCID == null) {
   UCID = getGUID();
} else {
   UCID = trim10(UCID);
   if (UCID.length == 0) {
      UCID = getGUID();
   }
}
alert("UCID == " + UCID);
document.getElementById("dnn_ctr404_DynamicForms_Responses_89d41257-36e1-49be-8d35-f04af8a8f6e7DSParam1").value = UCID;
document.getElementById("dnn_ctr404_DynamicForms_Responses_e463cc33-0200-4018-8360-19b0f9a82b08UniqueCompletionID").value = UCID;

alert("dnn_ctr404_DynamicForms_Responses_89d41257-36e1-49be-8d35-f04af8a8f6e7DSParam1 = " + document.getElementById("dnn_ctr404_DynamicForms_Responses_89d41257-36e1-49be-8d35-f04af8a8f6e7DSParam1").value);
alert("dnn_ctr404_DynamicForms_Responses_e463cc33-0200-4018-8360-19b0f9a82b08UniqueCompletionID = " + document.getElementById("dnn_ctr404_DynamicForms_Responses_e463cc33-0200-4018-8360-19b0f9a82b08UniqueCompletionID").value);

1. We created a hidden field that is SQL Driven called "InitGUID" that retrieves and passes it's value via querystring. Default value: "SELECT NEWID()) AS DefaultValue;"
   
2. We submitted page one of our form, and got an error saying that SQL Server couldn't convert "" into a GUID. It turns out that the field was not populated.
   
3. We made InitGUID visible so that we could see if it was being populated or not without having to submit our form.
   
4. We fired up SQL Server Profiler to check if the code was actually being executed and found that it was actually being executed on the database server.
   
5. We then tried the following query: "Select count(*) As DefaultValue from users" This failed to execute because we (obviously, seeing as it was just an example that you gave) don't have a "users" table in our database. So we then tried "SELECT COUNT(*) AS DefaultValue FROM dbo.ATM_DynamicForms_Question"  which successfully populated the textbox.
   

6. We then tried the following (the SELECT statements were tried on the server before being inputted as the query for InitGUID) as we weren't sure if the program was parsing our SQL Statement incorrectly:
   

   -- Let's try selecting from a table
   CREATE TABLE ATM_Tables_BobbyTables
   (
      MyStupidGUIDWorkaround UNIQUEIDENTIFIER NOT NULL
   )
   INSERT INTO dbo.ATM_Tables_BobbyTables (MyStupidGUIDWorkaround) VALUES (NEWID())
   
   -- Including indentation!
   SELECT
       atbt.MyStupidGUIDWorkaround AS DefaultValue
   FROM
       dbo.ATM_Tables_BobbyTables AS atbt
   
   -- Without the table alias, including indentation
   SELECT
       MyStupidGUIDWorkaround AS DefaultValue
   FROM
       dbo.ATM_Tables_BobbyTables
   
   -- Without the table alias and without indentation
   SELECT MyStupidGUIDWorkaround AS DefaultValue FROM dbo.ATM_Tables_BobbyTables
   
   -- Let's try not aliasing the column
   DROP TABLE ATM_Tables_BobbyTables
   CREATE TABLE ATM_Tables_BobbyTables
   (
      DefaultValue UNIQUEIDENTIFIER NOT NULL
   )
   INSERT INTO dbo.ATM_Tables_BobbyTables (DefaultValue) VALUES (NEWID())
   
   -- Without the table alias and without indentation
   SELECT DefaultValue FROM dbo.ATM_Tables_BobbyTables

7. Nothing worked.
   
8. Then it struck me that an INT was successfully populated as a value for the textbox, so the textbox should *SURELY* be able to handle a string. Sooooo.....
   

   DROP TABLE ATM_Tables_BobbyTables
   CREATE TABLE ATM_Tables_BobbyTables
   (
      DefaultValue CHAR(36) NOT NULL
   )
   INSERT INTO dbo.ATM_Tables_BobbyTables (DefaultValue) VALUES (NEWID())
   
   SELECT DefaultValue FROM dbo.ATM_Tables_BobbyTables

9. That worked!
   
10. My query is now "SELECT CONVERT(CHAR(36),NEWID()) AS DefaultValue;"
    

Posted By Ryan Bakerink on 02-24-2011 08:37 AM
Hello LordWhiteboard,

Why wouldn't you use this SQL for your SQL default:

Select Cast(NewID() as nvarchar(36)) as DefaultValue

If you have any questions please let me know.

Thanks,

Ryan

Posted By LordWhiteboard on 02-24-2011 04:07 AM

10. My query is now "SELECT CONVERT(CHAR(36),NEWID()) AS DefaultValue;"