comments to blogpost

[wy85-bit]

Hi Everyone:

I stole/copied code from @lovasoa's github page for blog posts. I thought it'd be cool to enable replies to those blog post. I'm however stuck as I can't seem to input the blogpost id into my create_comment_blog_post.sql file. Does anyone have an idea of how to solve this? What am I doing wrong?
I pasted my code below for reference

Kind regards,
Winnie

create_comment_blog_post.sql:

insert into comments_blog_posts (id, content)
values ($id,:content)
returning 
  'redirect' as component,
  'post?id=' || $id as link;

02_comment_blog_post.sql:

create table comments_blog_posts (
    comment_id integer primary key autoincrement,
    id not null,
    content text not null
);

post.sql :

select 'shell' as component,
    title
from blog_posts
where id = $id;

select 'text' as component,
    true as article,
    bp.content as contents_md,
    cbp.content as contents_md
    from blog_posts bp
left join comments_blog_posts cbp on cbp.id  = bp.id
where bp.id = $id;

select 'list' as component;
select
    'Edit' as title,
    'pencil' as icon,
    'edit?id=' || $id as link;


select 'form' as component,
    'Create a comment' as title,
    'create_comment_blog_post' as action,
    'Create' as validate;
select  'content' as name, 'textarea' as type, 'Your comment here' as label, 'Your comment here' as value, true as required, $disabled is not null as disabled;

[lovasoa]

You can use

sqlpage.link('create_comment_blog_post', json_object('id', $id)) as action,

You could alternatively use a field in the form with 'hidden' as type.

[wy85-bit]

Hi Lovasoa,
Thanks for your quick reply. It worked!