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 |
|
karthickbabu
Posting Yak Master
151 Posts |
 Posted - 2011-01-12 : 23:45:25
|
| I know this is very simple query and little bit i confused also.SELECT * FROM TABLENAME WHERE USERNAME = 'STEVE' AND PASSWORD = '***************'The password column is encrypted, done through vb 6.0 code. For all cases its working properly. Only one case its not fetching any records. Sorry i cant provide a code here, its confidential.I checked encryption methodology for both cases, its same.Any idead about this...!==================================================== you realize you've made a mistake, take immediate steps to correct it. |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-13 : 07:32:20
|
Since it is an equality condition, make sure the condition which returns no records actually exists in the table (check case sensitivity perhaps)
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-13 : 11:06:13
|
| make sure you dont have any unprintable characters included in string by mistake------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Simple Query but Not working