Solved

ASP/VB script page - SP help

Posted on 2014-01-02
4
514 Views
Last Modified: 2014-01-02
I am using ASP/VB script and MS SQL 2008

There is a SP in my page that inserts data in my DB.

---

Dim SPInsertPassword__Password
SPInsertPassword__Password = "0"
if(EncrytPswd("demo") <> "") then SPInsertPassword__Password = EncrytPswd("demo")

----

The above will insert the word "demo" into a database field, when it is inserted it is also enctrypted.  That is what the "Encrypt" part is for, so far so good.

I have to replace the word "demo" for a random password.  I already have the script below to generate a random password. What I need help with is to save the random password in a variable and then use it to insert it instead of the word 'demo' using the code above.

This is my script:

<script language="vbscript" runat="server">

Sub StrRandomize(strSeed)
        Dim i, nSeed
        nSeed = CLng(0)
        For i = 1 To Len(strSeed)
                nSeed = nSeed Xor ((256 * ((i - 1) Mod 4) * AscB(Mid(strSeed, i, 1))))
        Next
        'Randomiser
        Randomize nSeed
End Sub
'--GeneratePassword(nLength)
'--Generates friendly passwords for remembering and pronounciation
Function GeneratePassword(nLength)
        Dim i, bMadeConsonant, c, nRnd
            'You may adjust the below constants to include local,
            'eg. scandinavian characters. This way your passwords
            'will not be limited to latin characters.
        Const strDoubleConsonants = "bdfglmnpst"
        Const strConsonants = "bcdfghklmnpqrstv"
        Const strVocal = "aeiou"
        GeneratePassword = ""
        bMadeConsonant = False
        For i = 0 To nLength
                'Get a random number number between 0 and 1
                nRnd = Rnd
                'Simple or double consonant, or a new vocal?
                'Does not start with a double consonant
                        '15% or less chance for the next letter being a double consonant
                If GeneratePassword <> "" AND (bMadeConsonant <> True) AND (nRnd < 0.15) Then
                        'double consonant
                        c = Mid(strDoubleConsonants, Int(Len(strDoubleConsonants) * Rnd + 1), 1)
                                    'response.write int(Len(strDoubleConsonants) * Rnd + 1)
                                    'response.write "<br>"
                        c = c & c
                                    i = i + 1
                        bMadeConsonant = True
                Else
                                    '80% or less chance for the next letter being a consonant,
                                    'depending on wether the last letter was a consonant or not.
                        If (bMadeConsonant <> True) And (nRnd < 0.95) Then
                                'Simple consonant
                                c = Mid(strConsonants, Int(Len(strConsonants) * Rnd + 1), 1)
                                bMadeConsonant = True
                                    '5% or more chance for the next letter being a vocal. 100% if last
                                    'letter was a consonant - theoreticaly speaking...
                        Else
                                'If last one was a consonant, make vocal
                                c = Mid(strVocal,Int(Len(strVocal) * Rnd + 1), 1)
                                bMadeConsonant = False
                        End If
                End If
                'Add letter
                GeneratePassword = GeneratePassword & c
        Next
        'Is the password long enough, or perhaps too long?
        If Len(GeneratePassword) > nLength Then
                GeneratePassword = Left(GeneratePassword, nLength)
        End If
End Function

StrRandomize CStr(Now) & CStr(Rnd)

</script>
0
Comment
Question by:amucinobluedot
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 33

Accepted Solution

by:
Big Monty earned 500 total points
ID: 39752732
to put the newly created 10 char password into a variable, just do:

SPInsertPassword__Password = EncrytPswd( GeneratePassword( 10 ) )

do you also need help saving it?
0
 

Author Comment

by:amucinobluedot
ID: 39752750
let me try the above first.
0
 

Author Comment

by:amucinobluedot
ID: 39752759
Great, thanks !
0
 

Author Closing Comment

by:amucinobluedot
ID: 39752760
:)
0

Featured Post

Monthly Recap

May was a big month for new releases from Linux Academy! Take a look at what our team built recently in our blog. You can access the newest releases from our blog.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question