Solved

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

Posted on 2003-11-19
2
168 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:
Saqib Khan 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

785 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