SQL construction using a variable

5 years 11 months ago #1022 by jochen
Replied by jochen on topic SQL construction using a variable
hi,

look at www.jschmidt-systemberatung.de/index.php...0&lang=en#parameters
(select "Variables Replacement")

Please Log in or Create an account to join the conversation.

5 years 11 months ago #1021 by Menno Swaak
Replied by Menno Swaak on topic SQL construction using a variable
Hi Jochen

where can I find these docs 'Replacements of variables"?

thanks
menno

Please Log in or Create an account to join the conversation.

6 years 6 months ago - 6 years 6 months ago #995 by jochen
Replied by jochen on topic SQL construction using a variable
hi,

use: "#datesql#"
sql="Select time, temperature From ghs_log Where date = '#datesql#'

also see me docs about "Replacement of variables"

Please Log in or Create an account to join the conversation.

6 years 6 months ago #994 by Bill Walker
SQL construction using a variable was created by Bill Walker
My sql command contains a 'WHERE' to filter the data. I want the filter to be a variable (date in my case). How do I implement this? e.g. sql="Select time, temperature From ghs_log Where date = whatdate"
(I'm using flashchart in Joomla 3).
Thank you

Please Log in or Create an account to join the conversation.

Time to create page: 0.104 seconds
Powered by Kunena Forum

Visitors

Today: 3
Yesterday: 45
This Week: 560
Last Week: 849
This Month: 2,575
Last Month: 2,574
0183689
United States 28.1% USA
Germany 22.7% Germany
Russia 4.2% Russia
France 3.2% France
Italy 2.7% Italy
Indonesia 2.5% Indonesia
Poland 2.1% Poland

Total:

205

countries

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.