like operator not works on return view

[bashgaa]

my login.ejs has

  <% license_users.forEach((user2) => { %>
<%= user2.license_key %>
  <% }) %>

    <script>
      $("#addUser_license").blur(function () {
        var myTxt = $(this).val();
        var formData = {
          "license_key": myTxt,
        };
        $.ajax({
          type: "POST",
          dataType: "JSON",
          url: "/license",
          data: formData,
        })
          .done(function (response) {
            console.log("Success: " + response.msg);
          })
          .fail(function (ts) {
            alert(ts.responseStatus);
          });
      });
    </script>

and my app.js has post method

fastify.post("/license", async (request, reply) => {
  const client = await fastify.pg.connect();
  const { license_key } = request.body;
  try {
    const result = await client.query(
      "SELECT * FROM license WHERE license_key LIKE $1",
      [license_key]
    );
    console.log(result.rows);
    console.log({ license_key });
    // Pass the search results to the EJS template
    return reply.view("/login.ejs", { license_users: result.rows });
  } catch (err) {
    console.error(err);
    return reply.view("error.ejs");
  } finally {
    client.release();
  }
});

when i write "good" on input form then in terminal window console.log(result.rows);
console.log({ license_key }); result is [ { id: 28, license_key: 'good' } ]
{ license_key: 'good' } but nothing to show in console window only "Error: undefined" occured in browser console window
i think return reply.view("/login.ejs", { license_users: result.rows }); not works. Input data not pass to login.ejs code

<% license_users.forEach((user2) => { %>
     <li><%= user2.license_key %></li>
     <% }) %>

maybe like operator not pass to template file.

[jsumners]

https://github.com/fastify/point-of-view/blob/5e9f24d4e8127fe08aae3fe6eb7818e2eb6d176e/README.md?plain=1#L57-L76

[mcollina]

Thanks for reporting!

Can you provide steps to reproduce? We often need a reproducible example, e.g. some code that allows someone else to recreate your problem by just copying and pasting it. If it involves more than a couple of different file, create a new repository on GitHub and add a link to that.

[bashgaa]

hello sorry again i uploaded to github and respository is https://github.com/bashgaa/example_like_operator

…

On Thursday, October 26, 2023, Matteo Collina ***@***.***> wrote: Thanks for reporting! Can you provide steps to reproduce? We often need a reproducible example <https://stackoverflow.com/help/minimal-reproducible-example>, e.g. some code that allows someone else to recreate your problem by just copying and pasting it. If it involves more than a couple of different file, create a new repository on GitHub and add a link to that. — Reply to this email directly, view it on GitHub <#952 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AKJFBLGMSL3TB4CN4Y5PYHDYBFAULAVCNFSM6AAAAAA6N4DOO6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONZZGY4TGNZXGI> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[bashgaa]

Any update of my project issue? Do you checked my github project?

[Uzlopak]

Your github repo was not useful. I would need to setup a postgresql server. So I stopped there.

[bashgaa]

If i use my database to supabase then no need install postgresql server. can you check my github repo if i setup supabase?

[Eomm]

This is not minimal:

https://github.com/bashgaa/example_like_operator/blob/main/package.json#L21-L36
You are asking to debug your code.

We request minimal code because developers often identify the issue by replicating the code themselves. The most effective approach is to follow the "divide and conquer" strategy, where you break down the code into smaller pieces and examine them one by one until you locate the problem.
For example, if you remove the query and the server returns static data, does it work?
If it works, the issue is on the SQL query.
etc..

I would suggest starting from this comment: #952 (comment)
Did you ignore it?

That example in the readme works.
Then add postgres
Then add helmet
Then add ... you get the point...

[simoneb]

This issue can probably be closed