+ Reply to Thread
Results 1 to 2 of 2

Thread: Getting stale, inaccurate results from a Select query?

  1. #1
    g.xfire is offline Junior Member
    Join Date
    Jun 2009
    Location
    NY
    Posts
    2

    Default Getting stale, inaccurate results from a Select query?

    We're using ZF 1.7.7 on our current project, and we've got a big query that joins a number of tables together. The problem is that one field is returning old results that aren't in the database anymore. I've tried writing select statements to get the field itself, and that reflects the current database values. And if I run the big query in PHPMyAdmin (I'm using $select->assemble() ) it also shows the correct values. It's only on the one big query, and only for that one field. If I change one of the other fields, the big query shows it properly.

    We're not using cacheing or anything, and I've tried flushing the tables and all that.

    So.. has anyone seen this before? Any idea how to resolve this?

    Thanks!

  2. #2
    g.xfire is offline Junior Member
    Join Date
    Jun 2009
    Location
    NY
    Posts
    2

    Default

    Urgh, stupid mistake. It wasn't pulling old results, it was pulling from a different table that had the same field name.

    nevermind...

+ Reply to Thread

Similar Threads

  1. Replies: 2
    Last Post: 05-06-2010, 02:16 PM
  2. Problems displaying query results.
    By knightdriver in forum Databases
    Replies: 2
    Last Post: 11-21-2009, 05:48 PM
  3. Weird query results in Zend_Lucene (foreign chars)
    By Znarkus in forum Mail, Formats & Search
    Replies: 0
    Last Post: 07-20-2009, 12:08 PM
  4. select query
    By ganesh in forum General Q&A on Zend Framework
    Replies: 0
    Last Post: 03-03-2009, 12:33 PM
  5. Populate select with database results
    By AceWebDesign in forum General Q&A on Zend Framework
    Replies: 3
    Last Post: 11-03-2008, 11:32 AM

Posting Permissions

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