Jump to content

fenway

Staff Alumni
  • Posts

    16,168
  • Joined

  • Last visited

  • Days Won

    4

Everything posted by fenway

  1. Assuming you only want (a) a single category per item, and (b) no subcategories, then yes.
  2. Of course there's an easier way -- use a DB wrapper to write the queries for you, and pass it a hash.
  3. I don't know what a "large query" is, and why it's a problem.
  4. Sorry -- never worked with NDB.
  5. fenway

    Easy question!

    First, you can change the auto-increment starting value. Second, you really don't need to change UIDs -- ever.
  6. There could be thousands of matching rows -- don't get data just to throw it out.
  7. Are you sure it's using that my.ini file?
  8. Browsers need to be told about UTF-8, as well as your import.
  9. What are you trying to do? That looks like it should be a JOIN.
  10. So you have 0, 1, or 2 files?
  11. If you want all the rows _and_ an aggregate expression, you'll need a subquery.
  12. You have dozens of queries -- find the one that causes the error, and tell us.
  13. Don't post your DB credentials to the world -- and I don't know what "offline" means, anyway.
  14. Sounds like the OP is talking about fields, not records.
  15. Do this in 2 parts -- grab the top 10 scores, and then join back to grab anyone with said scores.
  16. If your DB equalities are case-sensitive, that means you're working with a binary collation.
  17. First, it gives you a line number. Second, "$end" doesn't show up the code you posted.
  18. I figured as much -- but I've seen 80kb attachements recently. As mentioned above, that string isn't quoted at all.
  19. You need to be able to debug code yourself -- not with someone else's tools.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.