vercel sql record example does not return "rows"

Unanswered

Spectacled Caiman posted this in #help-forum

Spectacled CaimanOP

2024-01-01T19:44:46.000Z

import { sql } from '@vercel/postgres';
import { redirect } from 'next/navigation';

async function create(formData: FormData) {
'use server';
const { rows } = await sql

INSERT INTO products (name)
    VALUES (${formData.get('name')})

;
redirect(/product/${rows[0].slug});
}

export default function Page() {
return (
<form action={create}>
<input type="text" name="name" />
<button type="submit">Submit</button>
</form>
);
}

2 Replies

Spectacled CaimanOP

2024-01-01T19:46:38.000Z

It returns "undefined"

@Spectacled Caiman import { sql } from '@vercel/postgres'; import { redirect } from 'next/navigation'; async function create(formData: FormData) { 'use server'; const { rows } = await sql` INSERT INTO products (name) VALUES (${formData.get('name')}) `; redirect(`/product/${rows[0].slug}`); } export default function Page() { return ( <form action={create}> <input type="text" name="name" /> <button type="submit">Submit</button> </form> ); }

Ray

2024-01-01T22:33:06.000Z

try

 const { rows } = await sql
    INSERT INTO products (name)
    VALUES (${formData.get('name')})
    RETURNING *
  ;