Query result (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


Fabrizio Domiziani -> Query result (3/24/2001 20:03:00)

In Frontpage, I created an asp page and with the Database Results Wizard,
and got the results using a search form.

My problem is that: Now the search comes executed (the SQL query)
not only when I click the SUBMIT button, but to every load (and reload) of
this page.

Can I to avoid this?


Thanks!!





Spooky -> RE: Query result (3/25/2001 20:30:00)

The best way, is to not specify the search on the same page as the input box.

Post from another page instead, set your options at step 3 and dont include a search form at step 5

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!





Fabrizio Domiziani -> RE: Query result (3/26/2001 20:11:00)

Optimal! But how is possible to set the criteria option to an other page (sql)?

thanks


quote:
Originally posted by Spooky:
The best way, is to not specify the search on the same page as the input box.

Post from another page instead, set your options at step 3 and dont include a search form at step 5






Spooky -> RE: Query result (3/26/2001 20:27:00)

Sorry? you lost me! explain a little more




Fabrizio Domiziani -> RE: Query result (3/26/2001 20:23:00)

If the best way, is to not specify the search on the same page as the input box, how I can to specify in the Result Wizard this other page for the form?

Please..





Spooky -> RE: Query result (3/26/2001 23:21:00)

Search page:
Insert form > submit to script > page2.asp
1 form box named "search"

Page2.asp
Insert DRW.
At step 3 > more options > Criteria
In the top box, select the database field you are searching against.
In the 3rd box type "search" (or whatever your form box name was)
Tick the box "Use this search form field"

At step 5 of the DRW, dont select the search option

http://www.outfront.net/spooky/step3.htm

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!





Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
6.201172E-02