Query Problem

Results 1 to 2 of 2

Thread: Query Problem

  1. #1
    Join Date
    Dec 1969

    Default Query Problem

    HI All,<BR><BR>I am facing a problem actually i had developed timesheet module and now i want to use query for administrator use depending on the start date and end date it should show the relevant information from that table and for that i am using one asp page from where i am selecting dates and in other page collecting values but i don&#039t know how to proceed i am placing the code below so could somebody look at it and give me some idea.<BR><BR>&#060;%<BR>str = CDate(request.form("ma")& "/" &request.form("mb") & "/" & request.form("mc"))<BR>strTemps = CDate(request.form("b1")& "/" &request.form("b2") & "/" & request.form("b3"))<BR>response.write str<BR>response.write strTemps<BR>Set Con=Server.CreateObject("ADODB.Connection")<BR>Con .Open("Driver={SQL Server}; Server=webservernew;uid=sa;pwd=;DATABASE=timesheet ")<BR>Set RS = Server.CreateObject("ADODB.Recordset")<BR>RS.Curso rType = adOpenStatic<BR>RS.Open "SELECT EmpTrans.User_Name, EmpTrans.sDate, EmpTrans.Activity, EmpTrans.Duration, EmpTrans.Process_id, EmpTrans.Reviewed FROM EmpTrans" WHERE ((("sdate")&#062;="str" Or ("sdate")&#060;="strtemps"))"con<BR><BR><BR>ORD ER BY EmpTrans.User_Name;<BR>if RS.EOF then<BR> Response.Write "No records"<BR>else<BR> Response.Write "Records Retrieved"<BR>end if<BR>%&#062;

  2. #2
    Bruce willis Guest

    Default RE: Query Problem

    Ashish,<BR>There is an old language called ENGLISH which is not your cup of tea. You have no idea how annoying and irritating you are..!<BR>I urge you to stay away from this message board for god sake..<BR>Bye (for ever)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts