Skip to main content
April 9, 2008
Question

Breaking out of coldfusion code

  • April 9, 2008
  • 4 replies
  • 582 views
Hi i have have issues in the past with asp sql injections, mainly on form entry, by entring a sql string and breaking out of the asp code. is this an issue with coldfusion, if so what is the best way to stop this and what would be the way to break out of coldfusion code?

i do use sql stored procedures is this totally safe from sql injections?

many thanks
This topic has been closed for replies.

4 replies

Inspiring
April 10, 2008
<script>window.alert("Like This");</script>
Inspiring
April 9, 2008
Dan Bracuk wrote:
> Personnally I find js injections to be more of a threat than sql injections. I
> have tested both, and the only time I could get sql to execute was with MS SQL
> and a numeric datatype. The other dbs I tested were Oracle and Redbrick.
>

I just want to say, I have no trouble doing SQL injection on Oracle with
numeric data types as well.

String data types are much more difficult thanks to ColdFusion's habit
of automatically escaping single quotes, unless one has turned this off
with the preserveSingleQuotes() function.

But, I trust the rule of thumb that hackers have much more time then I
do to find obscure combinations of characters, escapes and|or commands.
Thus I just <queryParam...> so that the database knows to never ever
treat this piece of data as code.
April 10, 2008
ok many thanks.

so is it possible to break out of coldfusion code, how is js injection caused?
Inspiring
April 9, 2008
Personnally I find js injections to be more of a threat than sql injections. I have tested both, and the only time I could get sql to execute was with MS SQL and a numeric datatype. The other dbs I tested were Oracle and Redbrick.

Inspiring
April 9, 2008
craiglaw98 wrote:
> issue with coldfusion, if so what is the best way to stop this and what would
> be the way to break out of coldfusion code?

use cfqueryparam religiously.