navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

Query result

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Query result
Page: [1]
 
Fabrizio Domiziani

 

Posts: 3
From: Rome, Italy
Status: offline

 
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

 

Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
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!


(in reply to Fabrizio Domiziani)
Fabrizio Domiziani

 

Posts: 3
From: Rome, Italy
Status: offline

 
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



(in reply to Fabrizio Domiziani)
Spooky

 

Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: Query result - 3/26/2001 20:27:00   
Sorry? you lost me! explain a little more

(in reply to Fabrizio Domiziani)
Fabrizio Domiziani

 

Posts: 3
From: Rome, Italy
Status: offline

 
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..


(in reply to Fabrizio Domiziani)
Spooky

 

Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
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!


(in reply to Fabrizio Domiziani)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Query result
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts