VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Customization
 Display by Manufacture/Artist dropdown
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

devshb
Senior Member

United Kingdom
1898 Posts

Posted - March 02 2004 :  17:11:44  Show Profile  Visit devshb's Homepage  Reply with Quote
Server.URLEncode is used all over the place in vp-asp, so if it doesn't work for this customised code, then a lot of your other vp-asp stuff (searches etc) won't work either.
Rather than finding an alternative to Server.URLEncode, I think you'd be better off trying to get Server.URLEncode to work.
Not sure what you're using; i'm guessing you're running it from a pc rather than a "proper" server; if you post the file to the web or set your pc up with the relevant server-type config options, then it should work fine.

Go to Top of Page

siraj
VP-ASP New User

USA
194 Posts

Posted - March 02 2004 :  20:16:53  Show Profile  Visit siraj's Homepage  Reply with Quote
As I said I never tested this code for Access and I dont have access database running clients either. If you can email me, I am more than happy to help you out.
Thanks,
SJ.

[email protected]
Go to Top of Page

bmw000
VP-ASP New User

137 Posts

Posted - April 21 2006 :  23:05:54  Show Profile  Visit bmw000's Homepage  Reply with Quote
I am on MS SQL 2000 and this code works. I am testing it with version 6.08.

I have run into a small problem. I need to remove null records from the query becuase the list stops where there are null records (nothing entered in the mfg field). Also, I would like it sorted ascending.

So how would you write the query to remove nulls and to sort ascending?

Thanks in advance,
Brian Weber

Brian Weber
Variety Solutions, LLC
http://www.varietysolutions.com
Go to Top of Page

rustytec
VP-ASP New User

Australia
113 Posts

Posted - April 29 2006 :  01:29:50  Show Profile  Reply with Quote
quote:
Originally posted by bmw000

I am on MS SQL 2000 and this code works. I am testing it with version 6.08.

I have run into a small problem. I need to remove null records from the query becuase the list stops where there are null records (nothing entered in the mfg field). Also, I would like it sorted ascending.

So how would you write the query to remove nulls and to sort ascending?

Thanks in advance,
Brian Weber

Brian Weber
Variety Solutions, LLC
http://www.varietysolutions.com



Hi BMW000,

I use the following query string and it all works ok.

sqlstr= "select distinct ucase(mfg) as mfg from products where mfg > ' ' "


You might be able to build it into yours.

cheers

rustytec
Go to Top of Page

bmw000
VP-ASP New User

137 Posts

Posted - April 29 2006 :  14:25:01  Show Profile  Visit bmw000's Homepage  Reply with Quote
Thanks for the reply.

I had some help from another source and got working a few days ago.

Thanks,
Brian Weber

Brian Weber
Variety Solutions, LLC
http://www.varietysolutions.com
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000