s
Contact Login Register
h M

Data Springs Modules Community Questions & Answers

generate GUID for text box

I am using  dynamic registration and i want to generate a GUID for each user. I have  tried using SELECT NewID() As FieldName in the SQL default value box but this does not work.

Please help

asked 1/24/2014
David Amm41
David Amm

1 Answer

Hi. This has come up a few times and there are a couple threads related to this... Can you please try and cast your New(D) as nvarchar (36)? I think this is what you need to do before you can properly return the value as a SQL Default.

Thanks,

Chad
answered 1/25/2014 Chad Nash 55
Chad Nash
  • Hi Chad
    I tried adding this in the Default value field in advanced field options tab.
    select CAST(NewId() AS nvarchar(36)) as Token.
    It doesn't give me a value in the token field of my form. - David Amm 1/27/2014

Your Answer

In order to provide an answer to this question, you must Login

I am flagging this question because...

10 inform moderator flags remaining

I am deleting this question because...

I am flagging this answer because...

10 inform moderator flags remaining

Flagging a Post

You have already flagged this post. Clicking "Remove Flag" below will remove your flag, thus reducing the count by one as well.

I am deleting this answer because...

Looking for a DNN Module?

If you’ve used Data Springs modules before, you know how easy they are to install and use. We have built each individual module in our collection with integration in mind, so when you opt for Collection 7.0 you’ll be able to install our entire toolbox quickly and start putting it to work for your business today.Yes, in the blink of an eye you will arrive on the scene like a Superhero!

Data Springs has long been recognized as a leader in the DotNetNuke (DNN) community through hard work, integrity, and commitment. We’ve helped thousands of people POWER UP their website and our Collection 7.0 will do the same for you.

You deserve more than just an average website. You deserve a MACHINE!

Enter your email below AND grab your spot in our big giveaway!

The winner will receive the entire Data Springs Collection 7.0 - Designed to get your website up and running like a DNN superhero (spandex not included).

Subscribe