Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

InterDev DTC---grid

Posted on 1999-01-08
12
Medium Priority
?
339 Views
Last Modified: 2013-12-25
I am using InterDevs dtc grid on an asp. Is there anyway to make the information displayed in the grid into a hyperlink. ie clicking on John Smith's name takes you to his page?
0
Comment
Question by:Crit
[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
  • 6
  • 6
12 Comments
 
LVL 9

Accepted Solution

by:
david_levine earned 800 total points
ID: 1857828
Right-click on the grid DTC, select Properties, select the Data tab, click on "Add Unbound Column". Name the new column as you wish by putting say "A Computed HyperLink" into the "Header:" field. Put an expression similar to the one below into the "Field/Expression:" field:

='<A HREF="ABC.ASP?ID=' + [CustomerID] + '">' + [CustomerID] + '</A>'

In this case you're building a URL from the Recordset's CustomerID field.

You can also look in the following MS KB Article and go to the section '9) Add the PageObject'
http://support.microsoft.com/support/kb/articles/q192/6/65.asp
0
 

Author Comment

by:Crit
ID: 1857829
Points up for ya. That worked well, but can you tell me this:
What I am doing is showing a preview table based on a sql statement built with a query according to their criteria. Let's say the customer's name is the link in the grid. How do I use the Id in the url to paste back into the sql statement and show only that record?. Right now what I have is a drop down combo box at the bottom of the grid that houses all the Customer's names, they browse thru the grid find the order they would like to see and then select the customers name from the dropdown, and then click another button to view that record.
0
 
LVL 9

Expert Comment

by:david_levine
ID: 1857830
Crit,

I don't understand what you want to do. Can you give a simple example as a comment that illustrates what you need.


0
Looking for a new Web Host?

Lunarpages' assortment of hosting products and solutions ensure a perfect fit for anyone looking to get their vision or products to market. Our award winning customer support and 30-day money back guarantee show the pride we take in being the industry's premier MSP.

 

Author Comment

by:Crit
ID: 1857831
When you click hyperlink I need to make the page post a hidden sql statement to the next page, I also need to be able to use the ?id=blah as a variable on the next page.


0
 
LVL 9

Expert Comment

by:david_levine
ID: 1857832
I'm confused. The hyperlink on the first page would be something like HREF=detail.asp?cust_id=1023 and detail.asp would use cust_id=1023 to build it's page.

What am I missing?
0
 

Author Comment

by:Crit
ID: 1857833
by the time I am through with this I shall gladly hand over all points. Let's say I use details.asp?Cust_id=12301. After clicking on the hyperlink, and going to details.asp?Cust_id=12301
How would I use the 12301 as a variable on the that page. Example
Select * from blah where cust_id = variable(12301)
0
 
LVL 9

Expert Comment

by:david_levine
ID: 1857834
In the ASP VB script (details.asp) you would have a line like:

<% set variable = request.querystring("variablename") %>

or in your example

<% set cust_id = request.querystring("cust_id") %>

and then your select would look something like:

select * from blah where cust_id = :cust_id


Is that what you're looking for? Try it out and let me know.


0
 

Author Comment

by:Crit
ID: 1857835
I tried that but for the life of me I couldn't get the variable.
Thing is  one page one user is allowed to search by several options (query returns about 50 fields). Page two is only a preview with a grid showing only 5 fields (allowing them to narrow their search even more)When they click on the hyperlink int the grid, they need to be taken to page three (which shows all 50 fields for that record)

The way I have it now: Page two shows preview records. Dropdown box shows order_no. They pick which order_no they wish to view, and then submit. This post's the index number of the drop down box to the next page. moving the recordset to the absolute position indicated by the drop down index. And from hear they can also click on the recordset navbar to view next previous records with same criteria. (the sql statment is built on the first page and passed through all three pages so that I have the variables from the first page)

In the hyperlink version I am working on now when a user clicks on the hyperlink, all the hidden information needs to also be posted to (ex: details.asp?Order_no=10121) then using the sql statement built on the first page I need to be able to pull the order_no variable into the sql statment.

I might not be explaining properly enough, as it is definitely easier to show than to explain. your help is/has been greatly appreciated.
Crit
0
 
LVL 9

Expert Comment

by:david_levine
ID: 1857836
What's your question now? From your last comment, I'm not sure if you are saying that your script can't read the variable(s) passed along via the URL or something else.

Here's some URLs to check out which seem to have some decent examples of ASP and QueryString...

http://msdn.microsoft.com/developer/enterprise/zdjournals/sqlweb.htm
http://asp.ausweb.net.au/getstarted/ms/guide/asgget.htm
http://search.zdnet.com/pcmag/pctech/content/16/22/it1622.005.html

Let me know.

David
0
 

Author Comment

by:Crit
ID: 1857837
Hey Dave,
Here's your points thanks for the help, I think I should be able to figure out the problem from your help and the links you have provided. Thanks again,
Critter
0
 

Author Comment

by:Crit
ID: 1857838
Hey Dave,
I got it working. Thanks for all your help
Crit
0
 
LVL 9

Expert Comment

by:david_levine
ID: 1857839
Cool! Glad to have helped.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article was originally published on Monitis Blog, you can check it here . Today it’s fairly well known that high-performing websites and applications bring in more visitors, higher SEO, and ultimately more sales. By the same token, downtime…
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Suggested Courses

636 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