SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2007
    Location
    bangalore
    Posts
    32
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    help me to write replace function for date

    dear all
    iam new for ASP
    i need to retrive record form database for a particular DATE and particular name
    i have to pass date and name thro "form" then i have to display that particular record


    please anybody tell me the query how to proceed

    thanks in advance
    sona..............

  2. #2
    SitePoint Guru SSJ's Avatar
    Join Date
    Jan 2007
    Posts
    828
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Use Following Query to retrive the record:
    SQL="SELECT dDate FROM tblDate WHERE dDate=#" & Date() & "# AND name=' " &name&" ' "

    You can use the hidden fields of form to pass these values.

    -SSJ

  3. #3
    SitePoint Enthusiast
    Join Date
    Jan 2007
    Location
    bangalore
    Posts
    32
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    thanks

    u r answer helped me to retrive that row

    thanks


Bookmarks

Posting Permissions

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