Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2003-11-19
2
Medium Priority
?
172 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 23

Accepted Solution

by:
Saqib Khan earned 600 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
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…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

670 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