Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 18th, 2006, 11:00 PM
Authorized User
Points: 245, Level: 4
Points: 245, Level: 4 Points: 245, Level: 4 Points: 245, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2006
Location: Houston, TX, USA.
Posts: 55
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ricespn
Default pound sign and querystring

Hi,

I trying to use LINK to send values from one ASP page to another one collecting the values with request querystring to perform a query to a SQL SERVER 2000 database, but I found out that one of the values is #ALL# and every time that I try to search for a record with a pound sing value it renders the rest of my values blank.

Have someone had this problem before?

This is the link:

<TD ALIGN="CENTER" TITLE="DELETE or EDIT RECORD">
        <A href="mfworkpartrefview.asp?partno=06-22-78&refpartno=89-225-06&refqty=200&factoryid=MMPG&skuno=#ALL#&createdby =10/18/2006&createddt=10/18/2006">DELETE</A></TD>

__________________
=======================
Strange and crazy, but everything is possible
 
Old October 19th, 2006, 07:35 AM
Wrox Author
Points: 13,255, Level: 49
Points: 13,255, Level: 49 Points: 13,255, Level: 49 Points: 13,255, Level: 49
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

The answer to your problem is to use URLEncode or HTMLEncode but Redmond, in all its wisdom, did not supply a Decode method for either of the Encode methods!! (In .NET things are a little different) In any case this page shows you how to write a URL and HTML Decode function.

http://www.aspnut.com/reference/encoding.asp

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature
 
Old October 19th, 2006, 08:58 AM
Authorized User
Points: 245, Level: 4
Points: 245, Level: 4 Points: 245, Level: 4 Points: 245, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2006
Location: Houston, TX, USA.
Posts: 55
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ricespn
Default

:D Thanks man!

You are a very knowledgeable guy..

Quote:
quote:Originally posted by dparsons
 The answer to your problem is to use URLEncode or HTMLEncode but Redmond, in all its wisdom, did not supply a Decode method for either of the Encode methods!! (In .NET things are a little different) In any case this page shows you how to write a URL and HTML Decode function.

http://www.aspnut.com/reference/encoding.asp

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature
Strange and crazy, but everything is possible
 
Old October 19th, 2006, 09:24 AM
Wrox Author
Points: 13,255, Level: 49
Points: 13,255, Level: 49 Points: 13,255, Level: 49 Points: 13,255, Level: 49
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

Thanks, glad it worked out for you.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature




Similar Threads
Thread Thread Starter Forum Replies Last Post
entering £ (pound sign) into MySQL database - PHP crmpicco PHP Databases 1 November 14th, 2007 02:02 AM
How use plus sign ajabbabahalmigiriha C# 1 December 19th, 2006 01:04 AM
pound symbol in XSL Velissarios XSLT 15 January 19th, 2006 02:16 PM
The little "plus" sign janise Access 8 January 6th, 2005 10:10 AM
How do you know which page to go to after sign up bekim Classic ASP Basics 8 August 22nd, 2004 07:53 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.