248 Posts
Giuse
5 years 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 Book for SEBLOD
4229 Posts
Kadministrator
5 years ago
1
Level 1

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

4229 Posts
Kadministrator
5 years 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

248 Posts
Giuse
5 years 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

248 Posts
Giuse
5 years ago
0
Level 2

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

thanks a lot

best regards

Giuse

Get a VIP membership