Title before edit: I hate programming, why did i choose this field

TL;DR: Stupid mistake, made by hours waste.

Basically, I was extracting date from the SQL db, and it was not displaying. I tried everything, heck I even went to chatgpt, and copilot. Two and half hours of trying every single thing under the sun, you know what was the issue?

SELECT task, status, id FROM mainWorkSpace WHERE user_id = @user_id

I FUCKING FORGOT TO ADD ‘date’ TO THE DAMN QUERY. TWO AND HALF HOURS. I was like, “Ain’t no way.” as I scrolled up to the query and there it was, a slap in the face, and you know what was the fix?

SELECT task, status, date, id FROM mainWorkSpace WHERE user_id = @user_id

Moral of the story, don’t become a programmer, become a professional cat herder instead.

    • @[email protected]
      link
      fedilink
      26 months ago

      Of course. I would not recommend using it.

      More like giving hints or a rough frame to work with.

    • @[email protected]
      link
      fedilink
      English
      1
      edit-2
      6 months ago

      Umn. No. It told you it was making that inference since it didn’t know the table schema.

      For example, if you have a column named “created_at” ordatein your mainWorkSpace table, you can add it to your SELECT statement
      

      Otherwise it was exactly right about the problem.

      • @[email protected]
        link
        fedilink
        English
        1
        edit-2
        6 months ago

        It’s partially right but led OP down the wrong lines of thinking because it interpreted the prompt as a date field being missing rather than the field named date being missing.

        Tbh I don’t blame it too much here as there is kind of a base level of understanding requred to use it successfully.