I know there is a simple answer and that I am forgetting something simple, but any help would be appreciated. I am performing a simple query on a table with ids, account numbers and passwords in it.
These passwords were inserted directly into SQL server and are all strong, but they have random special characters in them (for example, a password could be D=aE#45wxy).
I am running a query via ColdFusion to pull the passwords and encrypt them. When I run a simple query to select all from the table, some passwords are truncated (for example, they will just show a part of the password).
I talked to the database guy and he assured me that all the passwords are strong and have the right amount of characters. I'm thinking the truncation is due to certain conflicting special characters (maybe quotes or pound signs - I don't know - it is strange because there are passwords displaying that have a pound sign in them, or a greater than or less than sign).
Can anyone think of the obvious thing I'm missing here to return the text in the SQL server database?
<cfquery name="getPass" datasource="dbName">
select * from tableName
order by id asc
#id# #password# <br>