cumironin Comments - Answer Overflow

cumironin

Posts Comments

DTDrizzle Team

•Created by cumironin on 10/19/2023 in #help

Unable to use db.query but able to use reqular db.select

thanks for this

3 replies

DTDrizzle Team

•Created by king.edwards on 9/13/2023 in #help

Help with improving database query

can we use inArray or in on manual query for deleted row ? case

pickDeleteUsers: async ({ url }) => {
        const id = url.searchParams.get('id');
        const urlId = String(id);
        await db.delete(userTable).where(inArray(userTable.id, [urlId]));
    }

pickDeleteUsers: async ({ url }) => {
        const id = url.searchParams.get('id');
        const urlId = String(id);
        await db.delete(userTable).where(inArray(userTable.id, [urlId]));
    }

urlId is an array uuid of string. This will reproduce error: invalid input syntax for type uuid, btw i use sveltekit form & checkbox to do so.

50 replies

Gaming

Programming