Access to the variable $query

[eisefr]

Hello together..



does someone haves a little hint how i can change the $query-variable ?

I would like to define a query like this:

$datum=substr(val(tod(), 2), 1, 10)



I did try to set the $query-variable in the formatcontrol.. but it seems not to work. the $query is everytime=true. :-/



Maybe there is a easier way to define a query?

I dont know so much about that yet... :-/



Thanks for your help

Frank

[tommy]

Assuming that the date is formatted like this:



07/12/01 try



$datum=substr(str(tod()),1,2)

[eisefr]

The date format is like this:

07/12/2001 13:52:13



the expression datum=substr(str(tod()),1,10)

gives me that what i want to have:

07/12/2001



but how can i build a query on a table like

$query="datum=$datum"

?

[tommy]

Btw a tip for You to test if an expression evaluates to the result You expekt is to use the debugger.

[tommy]

eisefr wrote:

but how can i build a query on a table like

$query="datum=$datum"

?

Ok then. What You need to do is to escape the "



Try something like this



$query=""datum=$datum""

[eisefr]

I got it..

its working now..



THANK YOU :smile:

[jeppegotha]

If you want to create a query like this:



$L.query="time="12:00:00""



you can type it like this:



$L.query="time=\"12:00:00\""