User Eric Belair - User Experience Stack Exchange

I just posted a small open source CFML project here db.cfc is a standalone CFC with 472 lines of code. Here is the execute function in db.cfc. This is just a partial example pulled from the 400+ ... When I pass my values to the CFC and DO NOT use CFQUERYPARAM, I get the exact results as described above. When I pass my values to the CFC uses CFQUERYPARAM, I do not get what I expect. When I drop in a number like 1.2 or 5.5, the value gets rounded to 1.0 or 6.0. UPDATE TableName SET Points = <cfqueryparam type="CF_SQL_DECIMAL" value="#Points#"> Although entirely unavoidable, SQL injection can be prevented through the use of CfQueryParam in your SQL queries. Remember to always keep your guard up. Remain vigilant. Social Engineering. The next way hackers get into your system is through social engineering. This is caused by somebody convincing you to give out your passwords. This may seem like a no-brainer, but don’t give your ... 13 How should I use maxlength in CFQUERYPARAM list="true"? 12 How should I secure a contact form that appears on every page of a website? 11 How can I add jquery ui autocomplete to a dynamically created element? View more network posts → Top tags (7) forms. Score 3. Posts 4. Posts % 100. addresses. Score 1. Posts 1. input. Score 0. Posts 1. dates. Score 0. Posts 1. validation. Score 0. Posts ... sql coldfusion cfquery cfqueryparam asked May 20 '09 at 17:41 7 votes How to solve “Cannot connect to server” message with wireless app distribution on iPhone iOS 4 iphone xcode ios4 asked Jul 6 '10 at 22:52 ...

[index] [47051] [43550] [1298] [23220] [15805] [44982] [40937] [16423] [7265] [38654]