p2p.wrox.com: Archives - asptoday

asptoday_discuss thread: About the Asp Problem

Message #1 by "Leung Chi Hin" <hintel01@n...> on Fri, 30 Nov 2001 02:14:25

<%

Dim Conn, Nid, Pwd



Nid = Request("Nid")

Pwd = Request("Pwd")



SQLstr = "Select * From Client Where Nid = '"&Request("Nid")&"' And Pwd 

= '"&Request("Pwd")&"'"

Set Conn = Server.CreateObject("ADODB.Connection")

Conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath

("db3.mdb")

Set rs = Conn.Execute( SQLstr )



%>



<%







If rs.EOF Then

   

   response.redirect "wrong.asp"

   rs.close : set rs = Nothing	

Else

   rs.close : set rs = Nothing

   Response.Redirect "pass.asp"

End If



%>



This is my check login name and passwrod ASP program, When me processing 

this, the IE show this message "The page cannot be displayed" , is this 

program have any problem pls help me.



Use MS Access 97 for database , win98 and IE 5.0 ver



Thx, 

AlexLeung

Message #2 by "Luy" <bfluy@y...> on Fri, 30 Nov 2001 10:13:29 +0800

This is a multi-part message in MIME format.



------=_NextPart_000_002F_01C17987.A856EF20

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: 7bit



pls c the highlighted string...





note: try to put in the space in between...

clement...



-----Original Message-----

From: Leung Chi Hin [mailto:hintel01@n...]

Sent: Friday, November 30, 2001 2:14 AM

To: ASPToday Discuss

Subject: [asptoday_discuss] About the Asp Problem





<%

Dim Conn, Nid, Pwd



Nid = Request("Nid")

Pwd = Request("Pwd")



SQLstr = "Select * From Client Where Nid = '" & Request("Nid") & "' And Pwd

= '" & Request("Pwd") & "'"

Set Conn = Server.CreateObject("ADODB.Connection")

Conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath

("db3.mdb")

Set rs = Conn.Execute( SQLstr )



%>



<%







If rs.EOF Then



   response.redirect "wrong.asp"

   rs.close : set rs = Nothing

Else

   rs.close : set rs = Nothing

   Response.Redirect "pass.asp"

End If



%>



This is my check login name and passwrod ASP program, When me processing

this, the IE show this message "The page cannot be displayed" , is this

program have any problem pls help me.



Use MS Access 97 for database , win98 and IE 5.0 ver



Thx,

AlexLeung








$subst('Email.Unsub')

Read the future with ebooks at B&N

http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid

=rn_ebooks












_________________________________________________________



Do You Yahoo!?



Get your free @yahoo.com address at http://mail.yahoo.com

Message #3 by "Alex" <hintel01@n...> on Fri, 30 Nov 2001 10:37:07 +0800

This is a multi-part message in MIME format.



------=_NextPart_000_01BC_01C1798A.F58EAAA0

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



Thx for help , Luy

  ----- Original Message -----

  From: Luy

  To: ASPToday Discuss

  Sent: Friday, November 30, 2001 10:13 AM

  Subject: [asptoday_discuss] RE: About the Asp Problem





  pls c the highlighted string...





  note: try to put in the space in between...

  clement...



  -----Original Message-----

  From: Leung Chi Hin [mailto:hintel01@n...]

  Sent: Friday, November 30, 2001 2:14 AM

  To: ASPToday Discuss

  Subject: [asptoday_discuss] About the Asp Problem





  <%

  Dim Conn, Nid, Pwd



  Nid =3D Request("Nid")

  Pwd =3D Request("Pwd")



  SQLstr =3D "Select * From Client Where Nid =3D '" & Request("Nid") & 

"' And Pwd

  =3D '" & Request("Pwd") & "'"

  Set Conn =3D Server.CreateObject("ADODB.Connection")

  Conn.Open "Driver=3D{Microsoft Access Driver (*.mdb)};DBQ=3D" & 

Server.MapPath

  ("db3.mdb")

  Set rs =3D Conn.Execute( SQLstr )



  %>



  <%







  If rs.EOF Then

   

     response.redirect "wrong.asp"

     rs.close : set rs =3D Nothing

  Else

     rs.close : set rs =3D Nothing

     Response.Redirect "pass.asp"

  End If



  %>



  This is my check login name and passwrod ASP program, When me 

processing

  this, the IE show this message "The page cannot be displayed" , is 

this

  program have any problem pls help me.



  Use MS Access 97 for database , win98 and IE 5.0 ver



  Thx,

  AlexLeung








$subst('Email.Unsub')

  Read the future with ebooks at B&N

  

http://service.bfast.com/bfast/click?bfmid=3D2181&sourceid=3D38934667&cat

egoryid=3Drn_ebooks





hintel01@n...


$subst('Email.Unsub') Read the future with ebooks 

at B&N

  

http://service.bfast.com/bfast/click?bfmid=3D2181&sourceid=3D38934667&cat

egoryid=3Drn_ebooks

Message #4 by "asame" <asame00@y...> on Fri, 30 Nov 2001 04:01:29 -0000

This is a multi-part message in MIME format.



------=_NextPart_000_0017_01C17953.B0877B80

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



I can't see any problems with your code (except the use of "Pwd" - 

reserved names cause tears and hair tearing). You should also check the 

permissions of your folder and files. Please post the error message.

  ----- Original Message -----

  From: Alex

  To: ASPToday Discuss

  Sent: Friday, November 30, 2001 2:37 AM

  Subject: [asptoday_discuss] RE: About the Asp Problem





  Thx for help , Luy

    ----- Original Message -----

    From: Luy

    To: ASPToday Discuss

    Sent: Friday, November 30, 2001 10:13 AM

    Subject: [asptoday_discuss] RE: About the Asp Problem





    pls c the highlighted string...





    note: try to put in the space in between...

    clement...



    -----Original Message-----

    From: Leung Chi Hin [mailto:hintel01@n...]

    Sent: Friday, November 30, 2001 2:14 AM

    To: ASPToday Discuss

    Subject: [asptoday_discuss] About the Asp Problem





    <%

    Dim Conn, Nid, Pwd



    Nid =3D Request("Nid")

    Pwd =3D Request("Pwd")



    SQLstr =3D "Select * From Client Where Nid =3D '" & Request("Nid") & 

"' And Pwd

    =3D '" & Request("Pwd") & "'"

    Set Conn =3D Server.CreateObject("ADODB.Connection")

    Conn.Open "Driver=3D{Microsoft Access Driver (*.mdb)};DBQ=3D" & 

Server.MapPath

    ("db3.mdb")

    Set rs =3D Conn.Execute( SQLstr )



    %>



    <%







    If rs.EOF Then

     

       response.redirect "wrong.asp"

       rs.close : set rs =3D Nothing

    Else

       rs.close : set rs =3D Nothing

       Response.Redirect "pass.asp"

    End If



    %>



    This is my check login name and passwrod ASP program, When me 

processing

    this, the IE show this message "The page cannot be displayed" , is 

this

    program have any problem pls help me.



    Use MS Access 97 for database , win98 and IE 5.0 ver



    Thx,

    AlexLeung








$subst('Email.Unsub')

    Read the future with ebooks at B&N

    

http://service.bfast.com/bfast/click?bfmid=3D2181&sourceid=3D38934667&cat

egoryid=3Drn_ebooks





hintel01@n...


$subst('Email.Unsub') Read the future with ebooks 

at B&N

    

http://service.bfast.com/bfast/click?bfmid=3D2181&sourceid=3D38934667&cat

egoryid=3Drn_ebooks




$subst('Email.Unsub') Read the future with ebooks 

at B&N

  

http://service.bfast.com/bfast/click?bfmid=3D2181&sourceid=3D38934667&cat

egoryid=3Drn_ebooks










_________________________________________________________



Do You Yahoo!?



Get your free @yahoo.com address at http://mail.yahoo.com

Message #5 by "Leung Chi Hin" <hintel01@n...> on Fri, 30 Nov 2001 04:11:12

<HTML>

<HEAD>

<TITLE>ABC BANK</TITLE>

</HEAD>





	





<FORM Method=POST Action="login1.asp">

<CENTER>LOGIN ID : <INPUT TYPE=TEXT NAME="Nid" Size=20></CENTER><BR><BR>

<CENTER>PASSWORD : <INPUT TYPE=Password NAME="Pwd" 

Size=20></CENTER><BR><BR>

<CENTER><INPUT TYPE=SUBMIT Name="Sent" Value="GO">

<INPUT TYPE=RESET Name="Clear" Value="CLEAR"></CENTER>

</FROM>







</HTML>



This is my Login page html, after enter the Login ID & PASSWORD then go to 

the check password page.After that the IE only show this error message 

(The page cannot be displayed), so me dont know what happen in the check 

password Asp page.









> This is a multi-part message in MIME format.

> 

> ------=_NextPart_000_0017_01C17953.B0877B80

> Content-Type: text/plain;

> 	charset="iso-8859-1"

> Content-Transfer-Encoding: quoted-printable

> 

> I can't see any problems with your code (except the use of "Pwd" - 

> reserved names cause tears and hair tearing). You should also check the 

> permissions of your folder and files. Please post the error message.

>   ----- Original Message -----

>   From: Alex

>   To: ASPToday Discuss

>   Sent: Friday, November 30, 2001 2:37 AM

>   Subject: [asptoday_discuss] RE: About the Asp Problem

> 

> 

>   Thx for help , Luy

>     ----- Original Message -----

>     From: Luy

>     To: ASPToday Discuss

>     Sent: Friday, November 30, 2001 10:13 AM

>     Subject: [asptoday_discuss] RE: About the Asp Problem

> 

> 

>     pls c the highlighted string...

> 

> 

>     note: try to put in the space in between...

>     clement...

> 

>     -----Original Message-----

>     From: Leung Chi Hin [mailto:hintel01@n...]

>     Sent: Friday, November 30, 2001 2:14 AM

>     To: ASPToday Discuss

>     Subject: [asptoday_discuss] About the Asp Problem

> 

> 

>     <%

>     Dim Conn, Nid, Pwd

> 

>     Nid =3D Request("Nid")

>     Pwd =3D Request("Pwd")

> 

>     SQLstr =3D "Select * From Client Where Nid =3D '" & Request("Nid") & 



> "' And Pwd

>     =3D '" & Request("Pwd") & "'"

>     Set Conn =3D Server.CreateObject("ADODB.Connection")

>     Conn.Open "Driver=3D{Microsoft Access Driver (*.mdb)};DBQ=3D" & 

> Server.MapPath

>     ("db3.mdb")

>     Set rs =3D Conn.Execute( SQLstr )

> 

>     %>

> 

>     <%

> 

> 

> 

>     If rs.EOF Then

>      

>        response.redirect "wrong.asp"

>        rs.close : set rs =3D Nothing

>     Else

>        rs.close : set rs =3D Nothing

>        Response.Redirect "pass.asp"

>     End If

> 

>     %>

> 

>     This is my check login name and passwrod ASP program, When me 

> processing

>     this, the IE show this message "The page cannot be displayed" , is 

> this

>     program have any problem pls help me.

> 

>     Use MS Access 97 for database , win98 and IE 5.0 ver

> 

>     Thx,

>     AlexLeung

> 

> 




> $subst('Email.Unsub')

>     Read the future with ebooks at B&N

>     

> http://service.bfast.com/bfast/click?

bfmid=3D2181&sourceid=3D38934667&cat

> egoryid=3Drn_ebooks

> 



> hintel01@n...


> $subst('Email.Unsub') Read the future with ebooks 

> at B&N

>     

> http://service.bfast.com/bfast/click?

bfmid=3D2181&sourceid=3D38934667&cat

> egoryid=3Drn_ebooks




> $subst('Email.Unsub') Read the future with ebooks 

> at B&N

>   

> http://service.bfast.com/bfast/click?

bfmid=3D2181&sourceid=3D38934667&cat

> egoryid=3Drn_ebooks

> 

> ------=_NextPart_000_0017_01C17953.B0877B80

> Content-Type: text/html;

> 	charset="iso-8859-1"

> Content-Transfer-Encoding: quoted-printable

> 

> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

> <HTML><HEAD><TITLE></TITLE>

> <META http-equiv=3DContent-Type content=3D"text/html; 

> charset=3Diso-8859-1">

> <META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>

> <STYLE></STYLE>

> </HEAD>

> <BODY bgColor=3D#ffffff>

> <DIV><FONT face=3DArial color=3D#000000 size=3D2><FONT face=3DVerdana>I 

> can't see any

> problems with your code (except the use of "Pwd" - reserved names cause 

> tears

> and hair tearing). You should also check the permissions of your folder 

> and

> files.</FONT> <FONT face=3DVerdana>Please post the error

> message.</FONT></FONT></DIV>

> <BLOCKQUOTE

> style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; 

> BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

>   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>

>   <DIV

>   style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: 

> black"><B>From:</B>

>   <A title=3Dhintel01@n...

>   href=3D"mailto:hintel01@n...">Alex</A> </DIV>

>   <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A

>   title=3Dasptoday_discuss@p...

>   href=3D"mailto:asptoday_discuss@p...">ASPToday Discuss</A> 

> </DIV>

>   <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, November 30, 2001 



> 2:37

>   AM</DIV>

>   <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [asptoday_discuss] RE: 



> About the

>   Asp Problem</DIV>

>   <DIV><BR></DIV>

>   <DIV>Thx for help , Luy </DIV>

>   <BLOCKQUOTE

>   style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; 

> BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

>     <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>

>     <DIV

>     style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: 

> black"><B>From:</B>

>     <A title=3Dbfluy@y... href=3D"mailto:bfluy@y...">Luy</A> 

> </DIV>

>     <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A

>     title=3Dasptoday_discuss@p...

>     href=3D"mailto:asptoday_discuss@p...">ASPToday Discuss</A> 

> </DIV>

>     <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, November 30, 

> 2001 10:13

>     AM</DIV>

>     <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [asptoday_discuss] 

> RE: About

>     the Asp Problem</DIV>

>     <DIV><BR></DIV>

>     <P><FONT size=3D2>pls c the highlighted string...</FONT></P>

>     <DIV><FONT size=3D2></FONT>&nbsp;</DIV>

>     <DIV><FONT size=3D2>note: try to put in the space in 

> between...</DIV>

>     <P><FONT face=3DArial 

> color=3D#0000ff>clement...</FONT><BR><BR>-----Original

>     Message-----<BR>From: Leung Chi Hin [<A

>     

> 

href=3D"mailto:hintel01@n...">mailto:hintel01@n...</A

> >]<BR>Sent:

>     Friday, November 30, 2001 2:14 AM<BR>To: ASPToday 

> Discuss<BR>Subject:

>     [asptoday_discuss] About the Asp Problem<BR><BR><BR>&lt;%<BR>Dim 

> Conn, Nid,

>     Pwd<BR><BR>Nid =3D Request("Nid")<BR>Pwd =3D 

> Request("Pwd")<BR><BR>SQLstr =3D

>     "Select * From Client Where Nid =3D<FONT color=3D#ff0000> '" &amp;

>     Request("Nid") &amp; "'</FONT> And Pwd<BR>=3D <FONT 

> color=3D#ff0000>'" &amp;

>     Request("Pwd") &amp; "'"</FONT><BR>Set Conn =3D

>     Server.CreateObject("ADODB.Connection")<BR>Conn.Open 

> "Driver=3D{Microsoft

>     Access Driver (*.mdb)};DBQ=3D" &amp; 

> Server.MapPath<BR>("db3.mdb")<BR>Set rs =3D

>     Conn.Execute( SQLstr )<BR><BR>%&gt;<BR><BR>&lt;%<BR><BR><BR><BR>If 

> rs.EOF

>     Then<BR>&nbsp;&nbsp;<BR>&nbsp;&nbsp; response.redirect

>     "wrong.asp"<BR>&nbsp;&nbsp; rs.close : set rs =3D

>     Nothing&nbsp;<BR>Else<BR>&nbsp;&nbsp; rs.close : set rs =3D

>     Nothing<BR>&nbsp;&nbsp; Response.Redirect "pass.asp"<BR>End

>     If<BR><BR>%&gt;<BR><BR>This is my check login name and passwrod ASP 

> program,

>     When me processing<BR>this, the IE show this message "The page 

> cannot be

>     displayed" , is this<BR>program have any problem pls help 

> me.<BR><BR>Use MS

>     Access 97 for database , win98 and IE 5.0

>     ver<BR><BR>Thx,<BR>AlexLeung<BR><BR><BR>---<BR>You are currently 

> subscribed

>     to asptoday_discuss as: bfluy@y...<BR>To unsubscribe send a 

> blank email

>     to $subst('Email.Unsub')<BR>Read the future 

> with

>     ebooks at B&amp;N<BR><A

>     

> href=3D"http://service.bfast.com/bfast/click?

bfmid=3D2181&amp;sourceid=3D

> 38934667&amp;categoryid=3Drn_ebooks"

>     

> target=3D_blank>http://service.bfast.com/bfast/click?

bfmid=3D2181&amp;sou

> rceid=3D38934667&amp;categoryid=3Drn_ebooks</A></FONT>

>     </P>---<BR>

>     hintel01@n...<BR>

>     $subst('Email.Unsub') Read the future with 

> ebooks at

>     

> B&amp;N<BR>http://service.bfast.com/bfast/click?

bfmid=3D2181&amp;sourceid

> =3D38934667&amp;categoryid=3Drn_ebooks

>   </BLOCKQUOTE>---<BR>You are currently subscribed to asptoday_discuss 

> as:

>   asame00@y...<BR>

>   $subst('Email.Unsub') Read the future with 

> ebooks at

>   

> B&amp;N<BR>http://service.bfast.com/bfast/click?

bfmid=3D2181&amp;sourceid

> =3D38934667&amp;categoryid=3Drn_ebooks

> </BLOCKQUOTE></BODY></HTML>

> 

> ------=_NextPart_000_0017_01C17953.B0877B80--

> 

> 

> 

> _________________________________________________________

> 

> Do You Yahoo!?

> 

> Get your free @yahoo.com address at http://mail.yahoo.com

> 

> 

>

Return to Index

P2P Archives