´ç½Å¿¡°Ô·Î ¶°³ª´Â ²Þ¼Ó¿©Çà - ²Þ¼Ó³ª¶ó(http://www.inyourdream.net) ÀÔ±¹Çϱâ | ¿µÁÖ±Ç ½Åû
  • ¸öºÎ¸² °ñ¶ó°ñ¶ó
  • ¼Ò±Ù¼Ò±Ù
  • µµ¶õµµ¶õ
  • ³«¼­¸¶´ç
  • Âø°¢ÇѾÆÀÌ
  • ¼ýÀÚ¸ÂÃß±â
  • ¼Ò¿øºô±â
  • ÈçÀû³²±â±â
  • ²Þ¼Ó¿©Çà
  • Ä£±¸Áý ³î·¯°¡±â
  • ¸ðµÎµå¸²´ÔÀÇ È¨
  • î¤éÞ´ÔÀÇ È¨
  • Çö¿ì´ÔÀÇ È¨
  • º°¾ÆÇØ´ÔÀÇ È¨
  • ÇÞ»ì´ÔÀÇ È¨
  • À̳ª´Ï´ÔÀÇ È¨
  • À¯¸®¾Ë´ÔÀÇ È¨
  • ³È³ÈÀÌ´ÔÀÇ È¨
  • ²ÀÁö´ÔÀÇ È¨
  • ´ë¼º´ÔÀÇ È¨
  • ¼ÒÇÇ¾Æ / 2002-01-24 / ¿ÀÈÄ 6:39:39 / 211.237.95.214
    Á¶È¸¼ö : 144
    [Áú¹®] ÀúÀåÇÁ·Î½ÃÀú¸¦ sql¹®À¸·Î (¹ö±× ³Ñ¾î ¹ö±×)
    [¹ú·¹]
    Login failed for user '????????'.
    ????? <----UIDÀ̸§ÀÔ´Ï´Ù.

    [SP]
    SELECT_1: -- ȨÆäÀÌÁö °è¾àÀÚ Ã¼Å©
    DECLARE @NAME CHAR(10)

    SELECT @NAME = CLINAME
    FROM BCACNTB0
    WHERE CDSITE = @CDSITE
    AND DONG = @DONG
    AND HO = @HO
    AND CLIJUMIN = @JUMIN

    SELECT CASE WHEN @NAME IS NULL THEN 'N' ELSE @NAME END
    RETURN


    [ASP]
    <% Option Explicit %>
    <%
    '°³Ã¼ »ý¼º
    Dim cn
    Dim strConnection



    Set cn = Server.CreateObject("ADODB.Connection")
    strConnection="Provider=SQLOLEDB;Data Source=***.***.***.**;Initial Catalog=*******;UID=*******;Password=******;"
    cn.Open strConnection



    Set com = Server.CreateObject("ADODB.Command")

    With com
    .ActiveConnection = cn
    .CommandText = "user_paysearch"
    .CommandType = adCmdStoredProc

    .Parameters.Append .CreateParameter ("@TYPE", adChar, adParamInput, 4, "SEL1")
    .Parameters.Append .CreateParameter ("@SITENAME", adVarChar, adParamInput, 30, "°¥¿ùµ¿¿ÀÇǽºÅÚ")
    .Parameters.Append .CreateParameter ("@DONG", adChar, adParamInput, 4, "508")
    .Parameters.Append .CreateParameter ("@HO", adSmallInt, adParamInput, 0, "bu1032")
    .Parameters.Append .CreateParameter ("@JUMIN", adChar, adParamInput, 14, "******-*******") <---Áֹεî·Ï¹øÈ£
    .Parameters.Append .CreateParameter ("@PAYDATE", adChar, adParamInput, 8, "bu1032")
    .Parameters.Append .CreateParameter ("@SIDO", adChar, adParamInput, 1, "bu1032")



    End With

    Set rs = Server.CreateObject ("ADODB.Recordset")
    rs.Open com,, adOpenStatic, adLockReadOnly, adCmdStoredProc



    %>¾î¼±¸ Àú¼±¸...

    SP¿¡¼­ SQLÀ» ÷À¸·Î Âï¾îº¸´Âµ¥ ÀÌ·± ¿¡·¯°¡
    ³ª³×¿ä..
    SQL2000°èÁ¤¹®Á¦ °°Àºµ¥ Ȥ½Ã Àú°¡ À߸ø ¼±¾ðÇÑ
    °ÍÀÌ ÀÖ³ª¿ä...
    µµ¿ÍÁÖ¼¼¿ä...»ì·ÁÁÖ¼¼¿ä...(^^)

    Byte * 200 Byte À̳»·Î ÀÔ·ÂÇϼ¼¿ä À̸§ : Æнº¿öµå :