Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Translog filling fast - attack on SQL?

    You need to look at your websites log files and search for keywords like DECLARE or CAST or <script

    You may find an entry that has an html script tag with...

  • RE: syntax error while converting varchar value to int

    You can also use the CHARINDEX function. Like so:

    select ques.catid,ques.question,ques.qid,ques.subcatid,sub.subcategory from ada_question ques,ata_subcat sub where

    ques.subcatid=sub.subcatid and ques.catid=1 and ques.status=1 and CHARINDEX(cast(ques.qid as varchar(50)), @qid) > 0

    order by sub.subcatid,ques.qid asc

Viewing 2 posts - 1 through 2 (of 2 total)