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

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 passing dates as variables
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

sogoth
New Member

United Kingdom
73 Posts

Posted - 06 August 2001 :  09:36:14  Show Profile  Visit sogoth's Homepage
I'm using SQL server 2000 to store my info in and two of the fields are set to datetime.

I need to pass these as variables from a form, but whenever they are passed it changes the / into %2F instead which completely invalidates the point of passing them as variables as they are no longer the correct values.

HELP!!

Paul -
Complete Muppet, Borderline Feeble!

Kat
Advanced Member

United Kingdom
3065 Posts

Posted - 06 August 2001 :  09:53:19  Show Profile  Visit Kat's Homepage
Have you tried using this on the form requesting the field:

request.form(server.htmlencode("variablename"))?

This might get around your problem as it should (hopefully cos I haven't tried it) force it back to proper values. Try it?

KatsKorner


Edited by - kat on 06 August 2001 09:53:53
Go to Top of Page

mrWize
deleted

119 Posts

Posted - 06 August 2001 :  11:57:33  Show Profile
Could You show sample of the code where You send it to sql2000 server.

cya,
PatrikB a.k.a mrWize http://www.mrwize.nu
Go to Top of Page

sogoth
New Member

United Kingdom
73 Posts

Posted - 22 August 2001 :  10:36:37  Show Profile  Visit sogoth's Homepage
oops!

sorry it took so long to get back with the results... the HTML.encode thing worked wonderfully. Thank you!!



Paul -
Complete Muppet, Borderline Feeble!
Go to Top of Page

Kat
Advanced Member

United Kingdom
3065 Posts

Posted - 22 August 2001 :  10:56:22  Show Profile  Visit Kat's Homepage
Thought it might

KatsKorner
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000 Version 3.4.07