This site uses cookies and similar technologies.

If you don't change browser settings, you agree to it.

I understand
223 Posts
Giuse
17 days ago
4
Topic

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

Get a VIP membership
4196 Posts
Kadministrator
16 days ago
1
Level 1

Hi, how did you set storage for this field? Probably storage None would be the right one. 

4196 Posts
Kadministrator
16 days ago
0
Level 2

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

223 Posts
Giuse
15 days ago
1
Level 1

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

223 Posts
Giuse
12 days ago
0
Level 2

Hi Klas, do you have any further feedback on this?

thanks a lot

best regards

Giuse

Get a VIP membership