Replies: 5 comments 4 replies
-
You probably want to do a concatenation instead: CONCAT('member-event.sql#', $memberid) or 'member-event.sql#' || $memberid or format('member-event.sql#%s', $memberid) |
Beta Was this translation helpful? Give feedback.
-
Thank you for such a fast helpful reply.
I don't actually know how to do this. I will try to find out but it's likely to take me a while. |
Beta Was this translation helpful? Give feedback.
-
Perfect - thank you |
Beta Was this translation helpful? Give feedback.
-
@lovasoa - I tried the updated sqlpage table component software but the behaviour is unexpected. My sqlpage file (example: ...member-event.sql) renders the table correctly with rows correctly identified with the _sqlpage_id parameter.
If I manually append a #rowid to the url (example: ...member-event.sql#416188) the browser scrolls correctly to the target row. However if the exact same url with appended #rowid is generated using this redirect component, the browser does not scroll.
If I then manually edit the url and refresh it does scroll. |
Beta Was this translation helpful? Give feedback.
-
I have created a minimal sqlpage site (using postgresql) that has clarified the problem. If the table component includes the search parameter, then scroll to #id does not work. The minimal site uses a database with a single table: The sqlpage.bin is the latest version (SQLPage v0.26.0), the table component is the latest available on the website (includes recent _sqlpage_id ) |
Beta Was this translation helpful? Give feedback.
-
Background
I populate a table component with rows from a database. Each row is identified using unique column id. Using markdown a column in each row provides a link to another sqlpage page with id as a parameter. This second page updates the database and returns back to the table. I want to return to the row used in the call identified by id. I intended to use an html anchor but I can't make it work.
There seems to be two problems
Table component definition (cut down) from member-event.sql
The update-member-event.sql file definition is
I was expecting the redirect to return a url something like member-event.sql#441963 but it actually returns verbatim (ie with no substitution of the parameter value) member-event.sql#$memberid
Beta Was this translation helpful? Give feedback.
All reactions