navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

 

Database passing %20 instead of spaces!

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Database passing %20 instead of spaces!
Page: [1]
 
jonance

 

Posts: 298
From: Louisville KY USA
Status: offline

 
Database passing %20 instead of spaces! - 2/18/2001 21:56:00   
Hi,
I am having a peculiar problem with passing product titles to a shopping cart program. I am using a database to dynamically create a form that allows a user to add an item to a shopping cart. I am using hidden fields for product name and price. I can get the price to pass the value fine but the shopping cart shows the product name with "%20" instead of space between the words. For example:

Radio/Alarm%20Clock%20with%20hidden%20video%20camera

This is obviously unprofessional looking. Is there anyway to pass the value without the %20 showing up? Thanks in advance for your help and let me know if you need more info.

Thanks,
John

Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: Database passing %20 instead of spaces! - 2/18/2001 22:26:00   
Can you use POST instead of GET ?

I assume you are seeing this in the URL?

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!


(in reply to jonance)
jonance

 

Posts: 298
From: Louisville KY USA
Status: offline

 
RE: Database passing %20 instead of spaces! - 2/18/2001 22:49:00   
I believe it is post. Thats what is says anyway. you can look at it at

http://www.theprospy.com/itemdescription.asp?ID=2

this is an item that you can add to cart and see the prob.

I am pulling the product name and price from the database and using in a hidden field.

Thanks,
John


(in reply to jonance)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: Database passing %20 instead of spaces! - 2/19/2001 14:49:00   
The result you have there, is already in the form hidden data.

How did it get there originally?
It will be the page that passes the info to your link above that causes the problem and not the link above.

This page is operating correctly, as it is passing the info (via POST) that already exists.

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!


(in reply to jonance)
Guest


 
RE: Database passing %20 instead of spaces! - 2/19/2001 15:29:00   
It is coming straight from the database. Only in the database there are just spaces, obviously not the %20's. I am using a parameter, i think:

<%=FP_FieldURL(fp_rs,"product_name")%>

This is what i have in the hidden field. When it received the product name it is inserting %20 in all the spaces. Hope you can help now.

Thanks,
John


(in reply to jonance)
Guest


 
RE: Database passing %20 instead of spaces! - 4/3/2001 16:45:00   
I am having the same problem - did you get anywhere with a solution?

(in reply to jonance)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: Database passing %20 instead of spaces! - 4/3/2001 17:08:00   
The normal solution is to use :

FP_FieldVal

And not :

FP_FieldURL

So that it doesnt get url encoded.


(in reply to jonance)
KeithG

 

Posts: 92
From: Irving TX Irving, Texas, USA
Status: offline

 
RE: Database passing %20 instead of spaces! - 4/4/2001 16:51:00   
Spaces are always replaced with a %20, it does not seem to have any effect on the results though.

(in reply to jonance)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Database passing %20 instead of spaces!
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts