Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajveerg22
Starting Member
4 Posts |
 Posted - 2007-11-03 : 02:22:15
|
| Query:insert into aaaa values(',�'&\',',�'&\');BUJJI. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-11-03 : 02:29:58
|
quote:
Originally posted by rajveerg22
Query:insert into aaaa values(',�'&\',',�'&\');BUJJI.
It should beinsert into aaaa values(',�''&\',',�''&\');MadhivananFailing to plan is Planning to fail |
 |
|
|
rajveerg22
Starting Member
4 Posts |
Posted - 2007-11-03 : 02:38:13
|
| but this decrypted value of password...how can i change in that way....BUJJI. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-11-03 : 02:42:20
|
quote:
Originally posted by rajveerg22
but this decrypted value of password...how can i change in that way....BUJJI.
No worries. It would be stored as you wishedRun select query and seeMadhivananFailing to plan is Planning to fail |
|
|
|
arorarahul.0688
Posting Yak Master
125 Posts |
Posted - 2007-11-03 : 05:35:30
|
quote:
Originally posted by rajveerg22
Query:insert into aaaa values(',�'&\',',�'&\');BUJJI.
no problem even if is encrypted passwordit wil be stored as it is and can be selected for comparisonRahul Arora MCA 07 BatchNCCE Israna, PanipatHRY, INDIA######################IMPOSSIBLE = I+M+POSSIBLE |
|
|
|
rajveerg22
Starting Member
4 Posts |
Posted - 2007-11-03 : 06:43:35
|
| Sir.....If the encrypted value comes in the string format... suppose if the field value is like ",�'&\" coming dynamically from the form and how can i change it to ",�''&\".Is there any way to ignore such type of characters...BUJJI. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-11-03 : 08:45:45
|
| You need to double the single quotesMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
|
|
Can u just Explain....