My objRec.Filter does not work

Results 1 to 3 of 3

Thread: My objRec.Filter does not work

  1. #1
    Dani Guest

    Default My objRec.Filter does not work

    I have connected to a Access Database and would like to display<BR>the data for the logged-in users<BR>&#060;%=Session("client")&#037;&#062; returns Dani (for example, works)<BR><BR>objRec.Filter = "username = &#039dani&#039" would work as well but<BR><BR>objRec.Filter = "username = " & Session("client") won&#039t work.<BR><BR>Thanks for any help

  2. #2
    Join Date
    Dec 1969
    Posts
    244

    Default RE: My objRec.Filter does not work

    The single quotes are missing<BR>You have to do:<BR><BR>objRec.Filter = "username = &#039" & Session("client") & "&#039 "<BR><BR>So that when you <BR>Response.write objFilter <BR>it will return a line that is exactly the same as the one that works.

  3. #3
    Dani Guest

    Default RE: My objRec.Filter does not work

    Lisa,<BR>finally.......yahoooo<BR><BR>after some trying, it works.<BR><BR>Thanks, Lisa.

Posting Permissions

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