SQL and variable
Quote from dglojnar on June 13, 2022, 5:01 pmHi to all :-)
I have one question - how can I SQL result assing to variable?
SQL Query is:
Select Count(*) from USERS where USERNAME=[name] and KEY=[key]
Executing SQL Query result is number, mostly 1.
I want value from Count(*) assign to variable.
Is it possible, and if, how?
Is it any other way?
Cheers!
Hi to all :-)
I have one question - how can I SQL result assing to variable?
SQL Query is:
Select Count(*) from USERS where USERNAME=[name] and KEY=[key]
Executing SQL Query result is number, mostly 1.
I want value from Count(*) assign to variable.
Is it possible, and if, how?
Is it any other way?
Cheers!
Quote from luishp on June 13, 2022, 6:39 pm@dglojnar yes of ocurse, just use neoPhpExecSql it will return a JSON object with the result that you can get in the callback subroutine.
Regards.
@dglojnar yes of ocurse, just use neoPhpExecSql it will return a JSON object with the result that you can get in the callback subroutine.
Regards.
Quote from dglojnar on June 13, 2022, 8:52 pm@luishp
Thank You for answer !
"it will return a JSON object with the result ..." - I don't understand this part...
If I'm correct, VisualNeo WEB don't have a debugger or something similar as VisualNeo WIN?
So how can I see return JSON object?
It's a string?
Or something else?
Where I can see or find return JSON object?
Can I found any example?
All this WEB stuff is very confusing for me, I can't figured out, the whole concept is kinda incomprehensible....
Sorry for being annoying with questions....
Thank You for answer !
"it will return a JSON object with the result ..." - I don't understand this part...
If I'm correct, VisualNeo WEB don't have a debugger or something similar as VisualNeo WIN?
So how can I see return JSON object?
It's a string?
Or something else?
Where I can see or find return JSON object?
Can I found any example?
All this WEB stuff is very confusing for me, I can't figured out, the whole concept is kinda incomprehensible....
Sorry for being annoying with questions....
Quote from luishp on June 14, 2022, 7:24 am@dglojnar
If I'm correct, VisualNeo WEB don't have a debugger or something similar as VisualNeo WIN?
No, you are not. Just press F12 while running your app within a Web Browser (I prefer FireFox for this). It will open up the "Console" where you can see what's happening.
ConsoleLog and ConsoleTable commands allow you to print information into the Console to see variables, arrays and JSON data.So how can I see return JSON object?
It's a string?
Or something else?
Where I can see or find return JSON object?
Can I found any example?Please take a look at this video tutorial series. I'm sure it will clarify a lot of things:
https://www.youtube.com/watch?v=jIAN5B2dSl0&list=PL0I-4WLYvbmg0uBSo6jabSg034o8_lbfxJSON is a way to store structured data. It's like an array with named variables.
VisualNEO Web includes many samples you can explore. Take a look at the neoTable tutorial for example (source code included)All this WEB stuff is very confusing for me, I can't figured out, the whole concept is kinda incomprehensible...
I'm prety sure this will change very soon. But I think we can help each other...
What would be a good VisualNEO Web course index for you?I'm thinking about creating a complete course and having an "expected index" would help me a lot.
Thank you!
If I'm correct, VisualNeo WEB don't have a debugger or something similar as VisualNeo WIN?
No, you are not. Just press F12 while running your app within a Web Browser (I prefer FireFox for this). It will open up the "Console" where you can see what's happening.
ConsoleLog and ConsoleTable commands allow you to print information into the Console to see variables, arrays and JSON data.
So how can I see return JSON object?
It's a string?
Or something else?
Where I can see or find return JSON object?
Can I found any example?
Please take a look at this video tutorial series. I'm sure it will clarify a lot of things:
https://www.youtube.com/watch?v=jIAN5B2dSl0&list=PL0I-4WLYvbmg0uBSo6jabSg034o8_lbfx
JSON is a way to store structured data. It's like an array with named variables.
VisualNEO Web includes many samples you can explore. Take a look at the neoTable tutorial for example (source code included)
All this WEB stuff is very confusing for me, I can't figured out, the whole concept is kinda incomprehensible...
I'm prety sure this will change very soon. But I think we can help each other...
What would be a good VisualNEO Web course index for you?
I'm thinking about creating a complete course and having an "expected index" would help me a lot.
Thank you!
Quote from dglojnar on June 14, 2022, 9:17 am@luishp
No, thank YOU for your time and effort to explain me and other novice in web programming fundamental stufff :-)
Thank you for your support!
Cheers!
No, thank YOU for your time and effort to explain me and other novice in web programming fundamental stufff :-)
Thank you for your support!
Cheers!