I have a table listing invoices that I would like to filter based on a dollar amount that is entered on an input field. I have my query set-up with the condition “amount equals $_GET.amout”. On my webpage I have added the server connect action that has the amount variable pointed to my input field. However, the table is not being filtered when I enter any amount (which I know exists) in the input field. I use similar filtering of my tables with text inputs using “contains” conditions on my query and those work fine. Is there a different way to treat numbers with the “equal” condition?
Hi,
did you check if you set the variable $_GET.amount as number? What kind of field is the amount field in the db? decimal, integer or what ?
Hello,
The database field is decimal (10,2) and the $_GET is a number variable and the input field is a number field.
I had same problem with equal and contains… the first not filtering the second doing the job.
Let me see tomorrow morning (sorry it is late in italy now) to see what was the problem, I left a note if I remember and will write you back.