Help, I am using an encryption routine that occasionally will encrypt a
string using some extended ASCII characters (ASCII code > 128)
I am wondering if there is a reserved character in VB that signifies
the end of a string of characters.
Here is what happens: I am encrypting certain fields before adding
them to a SQL string. On occassion, the SQL string will simply end in
the middle of the encrypted value.
Example code
sSQL = "EXEC SaveDetails " & _
" @iDetailID = " & iDetailID & ", " & _
" @sEncryptedText = '" & _
replace(EncryptText(sText),"'","''") & "', " & _
" @iOtherValue = 6"
Normally Response.Write would print something like this:
using Response.Write(Server.HTMLEncode(sSQL)):
EXEC SaveDetails @iDetailID = 3, @sEncryptedText = 'aw@##@QASV@#AV (!',
@iOtherValue = 6
Occasionally on certain inputs for sEncryptedText it will print:
EXEC SaveDetails @iDetailID = 3, @sEncryptedText = '@#DFVIDXZI
Is my encryption algorithm possible generating a reserved character
that signifies the end of a string? Does such a character exist in
VBscript? Any help would be appreciated.
FYI, I'd rather not post my encryption routine. Please let me know if
you feel it would be necessary.