Hi, I need to put a message in the Search Form, not just a fixed text but something that includes some data from the DB.
So I created a new text field and put the text and the retrieval of values from DB in the live value with SQL query.
It works but.. after the user press the button "Search" of the form, the value of this field (the message that is displayed) ends up in the URL of the page like a normal field to be searched: the problem is that if the message contains some characters like quotes ("), this confuses Seblod that cannot interpret correctly the query (it takes part of the message with initial quotes like it was another search field).
How is it possible to avoid this? Is it possible to define a dynamic text field in the search form that does not finish in the URL or to protect the query URL from this problem?
thanks
Giuse
Hi, how did you set storage for this field? Probably storage None would be the right one.
Otherwise in the SQL pack there is a SQL field (not live vlaue field..real field), you can use this one to display a vaue from db https://www.seblod.com/resources/extensions/plug-ins/sql-pack
Hi Klas and thanks. The storage was already None (and match is None) but this does not prevent the field to end up in the URL.
The SQL query field works in the List View (for the returned results), here I am looking for the Search Form where this field is not executed from my understanding and tests.
cheers
Giuse
Hi Klas, do you have any further feedback on this?
thanks a lot
best regards
Giuse