Ask a Question related to Coldfusion Database Access, Design and Development.
-
CF_starter #1
Encrypt data fields
Do I need to encrpypt my text fields to prevent someone from witing malious code into the database (MS_SQL)? If so, what is the best approach?
thanks
CF_starter Guest
-
How do I Use DPAPI to Encrypt and Decrypt Data (C#/VB.NET)?
How To: Use DPAPI to Encrypt and Decrypt Data (C#/VB.NET) The code below demonstrates how to call Data Protection API (DPAPI) functions... -
<asp:Hypercolumn> 2 Data Fields.
<ASP:HyperlinkColumn DataNavigateUrlField="DataSourceField" DataNavigateUrlFormatString="FormatExpression" DataTextField="DataSourceField"... -
Encrypt in Perl, De-encrypt in Javascript
I got a javascript off the net which encrypt and de-encrypt HTML code so that nobody can read the public html file. here is the code of... -
Fields.value other data types help
Thanks for the answers to my other post. You nailed it, not char data types. How can I iterate through the fields when the fields are int,... -
Raw Column Data to Fields
Here is the situation: Table1 col1 ------------------------------------------- FirstNameLastNameMiddleNameStateCode First 9 chars are... -
alang686 #2 Re: Encrypt data fields
If you are talking about text fields that are used in your sql of your cfquery.
I would suggest using <cfqueryparam>. That way the values are passed as bind
variables and not concatenated to your existing sql. Example below.
Don't do:
<cfquery>
select column from table where column = '#textfield#'
</cfquery>
Do:
<cfquery>
select column from table where column = <cfqueryparam value="#textfield#">
</cfquery>
alang686 Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
