Advance option: WHERE

Hi!

First of all, FANTASTIC EXTENSION... thanx!!

Second, I'm a musician, not a programmer, so my mistakes are probably for ignorance, but
my problem is on WHERE section:

I have a column named "organico" and in it are written some records like "Lirico".

I need to show a grid where there are all the composition that match with "Lirico".

I tried to write in the inputbox:

WHERE `organico`=`Lirico` or
WHERE organico=Lirico or
`organico`=`Lirico` or
organico=Lirico

Ok, I really don't know how to write this... please show me how...

Thanks in advance

Hi,

hope you are not a gambler Non of your choices are correct...

Please try:

WHERE organico = 'Lirico'

I tried, but anything again...

i put in the inputbox

WHERE repertorio = `Lirico`

(repertorio is the new name of the field in the DB)

but nothing happens...

Well, if I don't use that advance condition the grid shows me correctly the columns I need; with the WHERE conditions it doesn't show anything... WHY?

Can you suggest me some particular configuration?

I can't upload the image I did... I fill diot..

Sorry!!

Hi,

be careful when you are using this

`

'

Thank you viljem for your reply,

I tried your way, right copying your code directly to the inputbox...

It still not working, and I don't know what to do...

Well, I'm learning how Table JX works, and I hope during this time I'll understand what I'm doing wrong...

Thanx in advance for any suggestion!

Stefano

SOLVED!!!!

trying and trying...

WHERE has not to be repeated in the inputbox!

in the inputox I've written repertorio = 'lirico' and now it works

It works also with `repertorio` = 'lirico'

yes I did 2 mistakes:

put WHERE inside the inputbox, and using the

`

'