Problem in query

Results 1 to 3 of 3

Thread: Problem in query

  1. #1
    Join Date
    Dec 1969

    Default Problem in query

    Hi All,<BR><BR>I want to use query but don&#039t know how to do it because i am new to asp but i had developed timesheet module now if the administrator want to see the details od particular employee or enter the start and end date then it should pick up only those record from the database table it show in a good format so for that firstly i am taking dates funda and for that i am using first asp to collect dates values and then in second asp i want to query but my statement is not working so could somebody look at it and sugguest me what to do. I am placing the code for second asp below...<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>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 User_Name, sDate, Activity, Duration, Process_id, Reviewed FROM EmpTrans WHERE sdate &#062;=&#039"& str &"&#039 & sdate &#060;="&#039 & strtemps & "&#039 ORDER BY User_Name"Con<BR>if RS.EOF then<BR> Response.Write "No records"<BR>else<BR> Response.Write "Records Retrieved"<BR>end if<BR>%&#062;

  2. #2
    Join Date
    Dec 1969

    Default CROSS POSTER

    don&#039t cross post, it wastes everyone&#039s time and makes people pretty annoyed<BR><BR>j

  3. #3
    Join Date
    Dec 1969

    Default RE: CROSS POSTER

    Atrax,<BR>I agree with you, people like him are like filth in this part of technology. Can we throw this garbage out of this message board.<BR>Everything else is perfectly OK.<BR>Best Regards

Posting Permissions

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