Not logged in. · Lost password · Register
Forum: General Help and Support Features and Functionality RSS
Create a page with sql query results (query created with form)
Avatar
uklatt #1
Member for 3 months · 2 posts
Group memberships: Members
Show profile · Link to this post
Subject: Create a page with sql query results (query created with form)
Hello,

can somebody help me to solve a problem whith database query.

I use "SQL query plugin" and "Bureaucracy Plugin" with "pagemod".

I have created a page with a form:

<form>
action pagemod sql-table database
textbox searchtext
submit
</form>

After entering the searchtext, pagemod modifies the page "sql-table" which lokks like:

<pagemod database output_after>
<sql>SELECT * FROM mydatabase WHERE col-1 LIKE @@searchtext@@ LIMIT 100</sql>
</pagemod>

The query works and a new table with query results is added to the page "sql-table".

My problem:

After every new query the resulting table is added to the result page.
But I need a new clean page with only the last result.

How can I achive this?

Uwe
Avatar
Tony Steward #2
Member for 3 months · 4 posts
Group memberships: Members
Show profile · Link to this post
I can't help with your problem but would love to see how you got as far as you have.
I need to create something similar but am struggling.
Avatar
uklatt #3
Member for 3 months · 2 posts
Group memberships: Members
Show profile · Link to this post
Hi Tony,

I have already posted the important text fragments of the two wiki pages.
Do you need more information?

Uwe
Avatar
Tony Steward #4
Member for 3 months · 4 posts
Group memberships: Members
Show profile · Link to this post
No I have now gotten as far as you have. Frustrating trying to find a way to get pagemod to replace a section of the page instead of creating a new table.

Anyone please how can we replace the last table with a new table on each submit. Instead of creating a new table every time???
Close Smaller – Larger + Reply to this post:
Verification code: VeriCode Please enter the word from the image into the text field below. (Type the letters only, lower case is okay.)
Smileys: :-) ;-) :-D :-p :blush: :cool: :rolleyes: :huh: :-/ <_< :-( :'( :#: :scared: 8-( :nuts: :-O
Special characters:
Go to forum
Imprint
This board is powered by the Unclassified NewsBoard software, 20150713-dev, © 2003-2015 by Yves Goergen
Current time: 2018-10-23, 20:39:24 (UTC +02:00)