some records not showing up - SQL server

Results 1 to 3 of 3

Thread: some records not showing up - SQL server

  1. #1
    Join Date
    Dec 1969

    Default some records not showing up - SQL server

    database SQL server. All reocrds shows up but not the last two records. There are 150 records, it shows upto 148. Now all records were exported from access database. Last two records were added using web itnerface. Its been added to the table but these records are not showing up. What could be the reason?<BR><BR>tesstatus = 1<BR>set rst=Conn.execute("select * from Testimonial where tstatus = " & tesstatus & " order by tdate desc")<BR><BR>tstatus is binary datatype. Even if I take that out from the SQL it does not show last two records.<BR><BR>I&#039;m clueless<BR>thanks in advance

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Whadaya mean does not show

    as in when you loop you can see them...what happens when you execute it in the back end?<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default Why do you assume...

    ...that the "last two records" *WERE* successfully added???<BR><BR>I&#039;d tend to believe that they really and truly are not there.<BR><BR>

Posting Permissions

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