M
Mike
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.
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.