Solved

Making a navigation button call a mysql query instead of a link

Posted on 2003-11-19
2
166 Views
Last Modified: 2011-08-18
Hi everyone,
I am new to DW and web design in general. I have started to get comfortable with connecting to mysql queries and all while using the form as the source and creating a Server behaviour.

What I would like to do more importantly is to have 3 navigation buttons creating a query and displaying the results of the query on the same page. For example, NEW, OLD, DEL nav buttons, I want the NEW button to run a query that will ONLY select the NEW records, and the OLD nav button to select ONLY the OLD records and so on to be displayed in a table.
I was wondering if anyone can point me to the right direction of doing that.
I hope the explanation of my problem is clear. I am using DW MX 2004.

Thank you
0
Comment
Question by:clekkas
2 Comments
 
LVL 23

Accepted Solution

by:
adilkhan earned 150 total points
ID: 9788285
clekkas You need to Create a Variable AND pass it to the same page to test the value.
For example lets say we have a variable called "actions"

when you click on NEW button pass its value to the same page

a href="this_page.asp?actions=NEW"

now in your page detect the value of actions variable

if request.QueryString("actions")="NEW" then
'sql here
elseif request.QueryString("actions")="OLD" then
'Sql for OLD here
else
' Default SQL
end if


Lemme know if you have any questions.
0
 

Author Comment

by:clekkas
ID: 9790265
Thank you very much for your quick and easy answer

Seems so simple now.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now