Lucifer Posts - Answer Overflow

Lucifer

•Created by Lucifer on 10/7/2024 in #help

$with is not taking an Insert with a return

example const chatId = db.$with("chatIdQ").as( db.insert(chats).values({ receiverId: 21, userId: 20, }), ); // using the with clause this errors out like this getTableData was not found is there a way to get around this? i tried writing raw sql but got the same error but i dont know if i did this correct. would appreciate the help

1 replies

DTDrizzle Team

•Created by Lucifer on 9/18/2024 in #help

Getting an object instead of an array.

im using Query syntax to get a an array of things based on a relations. the problem is one of the coloums is being sent like this which is wired.

    postsPicture: {
      "0": {
        postId: "352aaabb-8402-4771-829f-f68d563cf275",
        url: "test",
      },
      "1": {
        postId: "352aaabb-8402-4771-829f-f68d563cf275",
        url: "123",
      },
    },

19 replies

Gaming

Programming