Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


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
1904 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-CART 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-CART 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-CART 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-CART 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
0 Item(s)
$0.00
  • Your Cart Is Empty