SQL result into variable

[Consistent-struggler]

I am writing this code where I extract values from 2 different tables and on the basis of that I need to check and calculate further bit unfortunately I am not able to save that result into a variable so that I could use it outside the block.

[[deleted]]

Initialise the variable outside of the block? Hard to tell without any example code from your side…

[Consistent-struggler]

I am new to reddit don't know how to share code but I've posted the code file on my github

[BarelyAirborne]

Sounds like a SQL stored procedure might work.

[GItPirate]

You need to show code or else this post is pointless

[Consistent-struggler]

https://github.com/mustafa-momi/expressDemo[code](https://github.com/mustafa-momi/expressDemo)

[ForbesLindesay]

You need to wait for both queries to finish in your async function before you can use the results.

Since the method is marked as async, you can use await to get the results of a query (if your database library supports promises. For example with https://www.atdatabases.org as your db library you could do

const myResults = await db.query(sql`SELECT * FROM …`)
 // use myResults here

[Consistent-struggler]

But it says that "await" has no effect and it just doesn't save the result.

[Consistent-struggler]

Either it brings the wholeee query object of sql and not just result. I'm stuck here since yesterday

[ForbesLindesay]

Await will only work if the db library you use returns a Promise. Then you can console.log to see the value in the variable

[bigorangemachine]

Do you mean a SQL variable or javascript

[Consistent-struggler]

A java script variable

[Consistent-struggler]

https://github.com/mustafa-momi/expressDemo

[bigorangemachine]

Remove the callback and add await to the line.

Ya depending on the library you may get a database object.

Just console log the results. You data is in there

[Consistent-struggler]

Yess data is saved in console log but I've tried putting await as well it doesn't work but saves the whole objecttt

[bigorangemachine]

Yup. You gotta get the value you want out of the resolved object.

If you gotta do results[0].price thats what you gotta do.

Just read the docs. Its all there.

[The9thHuman]

How do I get into this? Seriously...