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

Microsoft MVP

 

RE: Issues pulling a correct date.

 
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 >> RE: Issues pulling a correct date. 		Page: <<   < prev  1 [2]
 
rdouglass

 

Posts: 9167
From: Biddeford, ME USA
Status: offline

  		RE: Issues pulling a correct date. - 10/18/2005 16:39:41   
quote:

my problem is that how would I make it return nothing when nothing is selected and still store all of the ones chosen to a session so that I can return it later?


You may want to consider using null and 0 the way they originally intended. That way you could easily put some identifyers to know when you're moving to one record or the next. I'd try to make the session look something like so:

|10/17/2005~1~2|10/18/2005~3~4

See, I'm trying to separate each record by one special char (|) and separate each field with another char (~). That's just one way to do it.

_____________________________

Don't take you're eye off your final destination.

ASP Checkbox Function Tutorial.

(in reply to fearnosurf)
fearnosurf

 

Posts: 149
Joined: 8/15/2005
Status: offline

  		RE: Issues pulling a correct date. - 10/21/2005 15:36:11   
He did seperate his code with a |

here is part of the data that he is populating the form with

dim lsArrDt(140)
lsArrDt(1) = "3/12/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 3/12/2006"
lsArrDt(2) = "3/15/2006 | 4/11 | BC/HH/HS | 3/15/2006 (4, 11 night only)"
lsArrDt(3) = "3/16/2006 | 3/10 | BC/HH/HS | 3/16/2006 (3, 10 night only)"
lsArrDt(4) = "3/19/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 3/19/2006"
lsArrDt(5) = "3/22/2006 | 4/11 | BC/HH/HS | 3/22/2006 (4, 11 night only)"
lsArrDt(6) = "3/23/2006 | 3/10 | BC/HH/HS | 3/23/2006 (3, 10 night only)"
lsArrDt(7) = "3/26/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 3/26/2006"
lsArrDt(8) = "3/29/2006 | 4/11 | BC/HH/HS | 3/29/2006 (4, 11 night only)"
lsArrDt(9) = "3/30/2006 | 3/10 | BC/HH/HS | 3/30/2006 (3, 10 night only)"
lsArrDt(10) = "4/2/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 4/2/2006"
lsArrDt(11) = "4/5/2006 | 4/11 | BC/HH/HS | 4/5/2006 (4, 11 night only)"
lsArrDt(12) = "4/6/2006 | 3/10 | BC/HH/HS | 4/6/2006 (3, 10 night only)"
lsArrDt(13) = "4/9/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 4/9/2006"
lsArrDt(14) = "4/12/2006 | 4/11 | BC/HH/HS | 4/12/2006 (4, 11 night only)"
lsArrDt(15) = "4/13/2006 | 3/10 | BC/HH/HS | 4/13/2006 (3, 10 night only)"
lsArrDt(16) = "4/16/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 4/16/2006"
lsArrDt(17) = "4/19/2006 | 4/11 | BC/HH/HS | 4/19/2006 (4, 11 night only)"
lsArrDt(18) = "4/20/2006 | 3/10 | BC/HH/HS | 4/20/2006 (3, 10 night only)"
lsArrDt(19) = "4/23/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 4/23/2006"
lsArrDt(20) = "4/26/2006 | 4/11 | BC/HH/HS | 4/26/2006 (4, 11 night only)"
lsArrDt(21) = "4/27/2006 | 3/10 | BC/HH/HS | 4/27/2006 (3, 10 night only)"
lsArrDt(22) = "4/30/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 4/30/2006"

(in reply to rdouglass)
rdouglass

 

Posts: 9167
From: Biddeford, ME USA
Status: offline

  		RE: Issues pulling a correct date. - 10/21/2005 15:55:10   
quote:

He did seperate his code with a |


I'm confused now. :)

What you gave me was full of tildes (~).

Can you post *exactly* a record, field, or variable that you will pass to be disected?

_____________________________

Don't take you're eye off your final destination.

ASP Checkbox Function Tutorial.

(in reply to fearnosurf)
fearnosurf

 

Posts: 149
Joined: 8/15/2005
Status: offline

  		RE: Issues pulling a correct date. - 10/21/2005 16:01:05   
Sorry, I didn't mean to confuse you...or myself for that matter lol.

He listed the info that I just posted to populate the Fields in the form. Once those are selected he then combines it into the tilde mess.

here is the chunk of code that lists all of teh data that populates the fields, as well as him calling it and combining it all when the form posts to itself. 

<%
'lsStartDate = "3/12/2006"
'lsEndDate = "12/2/2006"
'lsStartDate = "12/24/2006"
'lsEndDate = "1/6/2007"


dim lsArrDt(140)
lsArrDt(1) = "3/12/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 3/12/2006"
lsArrDt(2) = "3/15/2006 | 4/11 | BC/HH/HS | 3/15/2006 (4, 11 night only)"
lsArrDt(3) = "3/16/2006 | 3/10 | BC/HH/HS | 3/16/2006 (3, 10 night only)"
lsArrDt(4) = "3/19/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 3/19/2006"
lsArrDt(5) = "3/22/2006 | 4/11 | BC/HH/HS | 3/22/2006 (4, 11 night only)"
lsArrDt(6) = "3/23/2006 | 3/10 | BC/HH/HS | 3/23/2006 (3, 10 night only)"
lsArrDt(7) = "3/26/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 3/26/2006"
lsArrDt(8) = "3/29/2006 | 4/11 | BC/HH/HS | 3/29/2006 (4, 11 night only)"
lsArrDt(9) = "3/30/2006 | 3/10 | BC/HH/HS | 3/30/2006 (3, 10 night only)"
lsArrDt(10) = "4/2/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 4/2/2006"
lsArrDt(11) = "4/5/2006 | 4/11 | BC/HH/HS | 4/5/2006 (4, 11 night only)"
lsArrDt(12) = "4/6/2006 | 3/10 | BC/HH/HS | 4/6/2006 (3, 10 night only)"
lsArrDt(13) = "4/9/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 4/9/2006"
lsArrDt(14) = "4/12/2006 | 4/11 | BC/HH/HS | 4/12/2006 (4, 11 night only)"
lsArrDt(15) = "4/13/2006 | 3/10 | BC/HH/HS | 4/13/2006 (3, 10 night only)"
lsArrDt(16) = "4/16/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 4/16/2006"
lsArrDt(17) = "4/19/2006 | 4/11 | BC/HH/HS | 4/19/2006 (4, 11 night only)"
lsArrDt(18) = "4/20/2006 | 3/10 | BC/HH/HS | 4/20/2006 (3, 10 night only)"
lsArrDt(19) = "4/23/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 4/23/2006"
lsArrDt(20) = "4/26/2006 | 4/11 | BC/HH/HS | 4/26/2006 (4, 11 night only)"
lsArrDt(21) = "4/27/2006 | 3/10 | BC/HH/HS | 4/27/2006 (3, 10 night only)"
lsArrDt(22) = "4/30/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 4/30/2006"
lsArrDt(23) = "5/3/2006 | 4/11 | BC/HH/HS | 5/3/2006 (4, 11 night only)"
lsArrDt(24) = "5/4/2006 | 3/10 | BC/HH/HS | 5/4/2006 (3, 10 night only)"
lsArrDt(25) = "5/7/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 5/7/2006"
lsArrDt(26) = "5/10/2006 | 4/11 | BC/HH/HS | 5/10/2006 (4, 11 night only)"
lsArrDt(27) = "5/11/2006 | 3/10 | BC/HH/HS | 5/11/2006 (3, 10 night only)"
lsArrDt(28) = "5/14/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 5/14/2006"
lsArrDt(29) = "5/17/2006 | 4/11 | BC/HH/HS | 5/17/2006 (4, 11 night only)"
lsArrDt(30) = "5/18/2006 | 3/10 | BC/HH/HS | 5/18/2006 (3, 10 night only)"
lsArrDt(31) = "5/21/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 5/21/2006"
lsArrDt(32) = "5/24/2006 | 4/11 | BC/HH/HS | 5/24/2006 (4, 11 night only)"
lsArrDt(33) = "5/25/2006 | 3/10 | BC/HH/HS | 5/25/2006 (3, 10 night only)"
lsArrDt(34) = "5/28/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 5/28/2006"
lsArrDt(35) = "5/31/2006 | 4/11 | BC/HH/HS | 5/31/2006 (4, 11 night only)"
lsArrDt(36) = "6/1/2006 | 3/10 | BC/HH/HS | 6/1/2006 (3, 10 night only)"
lsArrDt(37) = "6/4/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 6/4/2006"
lsArrDt(38) = "6/7/2006 | 4/11 | BC/HH/HS | 6/7/2006 (4, 11 night only)"
lsArrDt(39) = "6/8/2006 | 3/10 | BC/HH/HS | 6/8/2006 (3, 10 night only)"
lsArrDt(40) = "6/11/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 6/11/2006"
lsArrDt(41) = "6/14/2006 | 4/11 | BC/HH/HS | 6/14/2006 (4, 11 night only)"
lsArrDt(42) = "6/15/2006 | 3/10 | BC/HH/HS | 6/15/2006 (3, 10 night only)"
lsArrDt(43) = "6/18/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 6/18/2006"
lsArrDt(44) = "6/21/2006 | 4/11 | BC/HH/HS | 6/21/2006 (4, 11 night only)"
lsArrDt(45) = "6/22/2006 | 3/10 | BC/HH/HS | 6/22/2006 (3, 10 night only)"
lsArrDt(46) = "6/25/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 6/25/2006"
lsArrDt(47) = "6/28/2006 | 4/11 | BC/HH/HS | 6/28/2006 (4, 11 night only)"
lsArrDt(48) = "6/29/2006 | 3/10 | BC/HH/HS | 6/29/2006 (3, 10 night only)"
lsArrDt(49) = "7/2/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 7/2/2006"
lsArrDt(50) = "7/5/2006 | 4/11 | BC/HH/HS | 7/5/2006 (4, 11 night only)"
lsArrDt(51) = "7/6/2006 | 3/10 | BC/HH/HS | 7/6/2006 (3, 10 night only)"
lsArrDt(52) = "7/9/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 7/9/2006"
lsArrDt(53) = "7/12/2006 | 4/11 | BC/HH/HS | 7/12/2006 (4, 11 night only)"
lsArrDt(54) = "7/13/2006 | 3/10 | BC/HH/HS | 7/13/2006 (3, 10 night only)"
lsArrDt(55) = "7/16/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 7/16/2006"
lsArrDt(56) = "7/19/2006 | 4/11 | BC/HH/HS | 7/19/2006 (4, 11 night only)"
lsArrDt(57) = "7/20/2006 | 3/10 | BC/HH/HS | 7/20/2006 (3, 10 night only)"
lsArrDt(58) = "7/23/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 7/23/2006"
lsArrDt(59) = "7/26/2006 | 4/11 | BC/HH/HS | 7/26/2006 (4, 11 night only)"
lsArrDt(60) = "7/27/2006 | 3/10 | BC/HH/HS | 7/27/2006 (3, 10 night only)"
lsArrDt(61) = "7/30/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 7/30/2006"
lsArrDt(62) = "8/2/2006 | 4/11 | BC/HH/HS | 8/2/2006 (4, 11 night only)"
lsArrDt(63) = "8/3/2006 | 3/10 | BC/HH/HS | 8/3/2006 (3, 10 night only)"
lsArrDt(64) = "8/6/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 8/6/2006"
lsArrDt(65) = "8/9/2006 | 4/11 | BC/HH/HS | 8/9/2006 (4, 11 night only)"
lsArrDt(66) = "8/10/2006 | 3/10 | BC/HH/HS | 8/10/2006 (3, 10 night only)"
lsArrDt(67) = "8/13/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 8/13/2006"
lsArrDt(68) = "8/16/2006 | 4/11 | BC/HH/HS | 8/16/2006 (4, 11 night only)"
lsArrDt(69) = "8/17/2006 | 3/10 | BC/HH/HS | 8/17/2006 (3, 10 night only)"
lsArrDt(70) = "8/20/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 8/20/2006"
lsArrDt(71) = "8/23/2006 | 4/11 | BC/HH/HS | 8/23/2006 (4, 11 night only)"
lsArrDt(72) = "8/24/2006 | 3/10 | BC/HH/HS | 8/24/2006 (3, 10 night only)"
lsArrDt(73) = "8/27/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 8/27/2006"
lsArrDt(74) = "8/30/2006 | 4/11 | BC/HH/HS | 8/30/2006 (4, 11 night only)"
lsArrDt(75) = "8/31/2006 | 3/10 | BC/HH/HS | 8/31/2006 (3, 10 night only)"
lsArrDt(76) = "9/3/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 9/3/2006"
lsArrDt(77) = "9/6/2006 | 4/11 | BC/HH/HS | 9/6/2006 (4, 11 night only)"
lsArrDt(78) = "9/7/2006 | 3/10 | BC/HH/HS | 9/7/2006 (3, 10 night only)"
lsArrDt(79) = "9/10/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 9/10/2006"
lsArrDt(80) = "9/13/2006 | 4/11 | BC/HH/HS | 9/13/2006 (4, 11 night only)"
lsArrDt(81) = "9/14/2006 | 3/10 | BC/HH/HS | 9/14/2006 (3, 10 night only)"
lsArrDt(82) = "9/17/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 9/17/2006"
lsArrDt(83) = "9/20/2006 | 4/11 | BC/HH/HS | 9/20/2006 (4, 11 night only)"
lsArrDt(84) = "9/21/2006 | 3/10 | BC/HH/HS | 9/21/2006 (3, 10 night only)"
lsArrDt(85) = "9/24/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 9/24/2006"
lsArrDt(86) = "9/27/2006 | 4/11 | BC/HH/HS | 9/27/2006 (4, 11 night only)"
lsArrDt(87) = "9/28/2006 | 3/10 | BC/HH/HS | 9/28/2006 (3, 10 night only)"
lsArrDt(88) = "10/1/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 10/1/2006"
lsArrDt(89) = "10/4/2006 | 4/11 | BC/HH/HS | 10/4/2006 (4, 11 night only)"
lsArrDt(90) = "10/5/2006 | 3/10 | BC/HH/HS | 10/5/2006 (3, 10 night only)"
lsArrDt(91) = "10/8/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 10/8/2006"
lsArrDt(92) = "10/11/2006 | 4/11 | BC/HH/HS | 10/11/2006 (4, 11 night only)"
lsArrDt(93) = "10/12/2006 | 3/10 | BC/HH/HS | 10/12/2006 (3, 10 night only)"
lsArrDt(94) = "10/15/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 10/15/2006"
lsArrDt(95) = "10/18/2006 | 4/11 | BC/HH/HS | 10/18/2006 (4, 11 night only)"
lsArrDt(96) = "10/19/2006 | 3/10 | BC/HH/HS | 10/19/2006 (3, 10 night only)"
lsArrDt(97) = "10/22/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 10/22/2006"
lsArrDt(98) = "10/25/2006 | 4/11 | BC/HH/HS | 10/25/2006 (4, 11 night only)"
lsArrDt(99) = "10/26/2006 | 3/10 | BC/HH/HS | 10/26/2006 (3, 10 night only)"
lsArrDt(100) = "10/29/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 10/29/2006"
lsArrDt(101) = "11/1/2006 | 4/11 | BC/HH/HS | 11/1/2006 (4, 11 night only)"
lsArrDt(102) = "11/2/2006 | 3/10 | BC/HH/HS | 11/2/2006 (3, 10 night only)"
lsArrDt(103) = "11/5/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 11/5/2006"
lsArrDt(104) = "11/8/2006 | 4/11 | BC/HH/HS | 11/8/2006 (4, 11 night only)"
lsArrDt(105) = "11/9/2006 | 3/10 | BC/HH/HS | 11/9/2006 (3, 10 night only)"
lsArrDt(106) = "11/12/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 11/12/2006"
lsArrDt(107) = "11/15/2006 | 4/11 | BC/HH/HS | 11/15/2006 (4, 11 night only)"
lsArrDt(108) = "11/16/2006 | 3/10 | BC/HH/HS | 11/16/2006 (3, 10 night only)"
'
'	Limits due to end of period.
'
lsArrDt(109) = "11/19/2006 | 3/4/7/10/11/14 | BC/HH/HS | 11/19/2006 (3, 4, 7, 10, 11, 14 night only)"
lsArrDt(110) = "11/22/2006 | 4/11 | BC/HH/HS | 11/22/2006 (4, 11 night only)"
lsArrDt(111) = "11/23/2006 | 3/10 | BC/HH/HS | 11/23/2006 (3, 10 night only)"
lsArrDt(112) = "11/26/2006 | 3/4/7 | BC/HH/HS | 11/26/2006 (3, 4, 7 night only)"
lsArrDt(113) = "11/29/2006 | 4 | BC/HH/HS | 11/29/2006 (4 night only)"
lsArrDt(114) = "11/30/2006 | 3 | BC/HH/HS | 11/30/2006 (3 night only)"
'
'	Christmas
'
'
'	Limits due to end of period.
'
lsArrDt(115) = "12/24/2006 | 3/4/7/10/11/14 | BC/HH/HS | 12/24/2006 (3, 4, 7, 10, 11, 14 night only)"
lsArrDt(116) = "12/27/2006 | 4 | BC/HH/HS | 12/27/2006 (4, 11 night only)"
lsArrDt(117) = "12/28/2006 | 3 | BC/HH/HS | 12/28/2006 (3, 10 night only)"
lsArrDt(118) = "12/31/2006 | 3/4/7 | BC/HH/HS | 12/31/2006 (3, 4, 7 night only)"
lsArrDt(119) = "1/3/2007 | 4/11 | BC/HH/HS | 1/3/2007 (4, 11 night only)"
lsArrDt(120) = "1/4/2007 | 3/10 | BC/HH/HS | 1/4/2007 (3, 10 night only)"

'lsStartDate = "3/12/2006"
'lsEndDate = "12/2/2006"
'lsStartDate = "12/24/2006"
'lsEndDate = "1/6/2007"

dim ArrDtMax
ArrDtMax = 120

dim ArrDtIx
%>

<%
dim lsNights(7)
lsNights(1) = 3
lsNights(2) = 4
lsNights(3) = 7
lsNights(4) = 10
lsNights(5) = 11
lsNights(6) = 14
lsNights(7) = 21

dim NightsMax
NightsMax = 7

dim NightsIx
%>

<%
dim lsHomes(7)
lsHomes(1) = 1
lsHomes(2) = 2
lsHomes(3) = 3
lsHomes(4) = 4
lsHomes(5) = 5

dim HomesMax
HomesMax = 5

dim HomesIx
%>

<%
dim lsAffClub(8)
lsAffClub(1) = "BC"
lsAffClub(2) = "HH"
lsAffClub(3) = "HS"
lsAffClub(4) = "PV"

dim AffClubMax
AffClubMax = 3

dim AffClubIx
%>

<%
dim lsReservationException
lsReservationException = ""

if session("resBookingHeader") = "" then
  msbInitBookingVariables
else
  msbParseBookingVariables
end if

if Request.Form("MM_dangit") = "homehigh_non_pv" then
		x1 = CStr(Request.ServerVariables("SCRIPT_NAME"))
		j1 = mfnInstrRev(x1, "/")
		if j1 > 0 then
		  x1 = mid(x1, j1 + 1)
		end if
		session("resBookingHeader") = x1 & "~" & _
		                              lsToday & "~" & _
		                              replace(request.form("MemberName"), "~", "-") & "~" & _
		                              replace(request.form("daytimePhones"), "~", "-") & "~" & _
		                              replace(request.form("emailAddress"), "~", "-") & "~" & _
		                              replace(request.form("homeClub"), "~", "-") & "~" & _
		                              replace(request.form("nightCount"), "~", "-") & "~" & _
		                              replace(request.form("specialReqs"), "~", "-") & "~" & _
		                              "One_Bedroom" & "~" & _
		                              "Two_Bedroom" & "~" & _
		                              "Three_Bedroom" & "~" & _
		                              "Four_Bedroom" & "~" & _
		                              "Flex_Bedroom" & "~" & _
		                              "Season_To_Use"
		session("resBookingDetail") = Request.Form("arrDt11") & "~" & _
		                       Request.Form("nights11") & "~" & _
		                       Request.Form("homes11") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt12") & "~" & _
		                       Request.Form("nights12") & "~" & _
		                       Request.Form("homes12") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt13") & "~" & _
		                       Request.Form("nights13") & "~" & _
		                       Request.Form("homes13") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt21") & "~" & _
		                       Request.Form("nights21") & "~" & _
		                       Request.Form("homes21") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt22") & "~" & _
		                       Request.Form("nights22") & "~" & _
		                       Request.Form("homes22") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt23") & "~" & _
		                       Request.Form("nights23") & "~" & _
		                       Request.Form("homes23") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt31") & "~" & _
		                       Request.Form("nights31") & "~" & _
		                       Request.Form("homes31") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt32") & "~" & _
		                       Request.Form("nights32") & "~" & _
		                       Request.Form("homes32") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt33") & "~" & _
		                       Request.Form("nights33") & "~" & _
		                       Request.Form("homes33") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt41") & "~" & _
		                       Request.Form("nights41") & "~" & _
		                       Request.Form("homes41") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt42") & "~" & _
		                       Request.Form("nights42") & "~" & _
		                       Request.Form("homes42") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt43") & "~" & _
		                       Request.Form("nights43") & "~" & _
		                       Request.Form("homes43") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt51") & "~" & _
		                       Request.Form("nights51") & "~" & _
		                       Request.Form("homes51") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt52") & "~" & _
		                       Request.Form("nights52") & "~" & _
		                       Request.Form("homes52") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt53") & "~" & _
		                       Request.Form("nights53") & "~" & _
		                       Request.Form("homes53") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt61") & "~" & _
		                       Request.Form("nights61") & "~" & _
		                       Request.Form("homes61") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt62") & "~" & _
		                       Request.Form("nights62") & "~" & _
		                       Request.Form("homes62") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt63") & "~" & _
		                       Request.Form("nights63") & "~" & _
		                       Request.Form("homes63") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt71") & "~" & _
		                       Request.Form("nights71") & "~" & _
		                       Request.Form("homes71") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt72") & "~" & _
		                       Request.Form("nights72") & "~" & _
		                       Request.Form("homes72") & "~" & _
		                       "NULL" & "~" & _
		                       Request.Form("arrDt73") & "~" & _
		                       Request.Form("nights73") & "~" & _
		                       Request.Form("homes73") & "~" & _
		                       "NULL" & "~"
	msbParseBookingVariables
	lsReservationException = EditReservationFields()
	if lsReservationException = "" then
		response.redirect("homehigh_res_finish.asp")
	else
        session("resBookingHeader") = ""
        session("resBookingDetail") = ""
		lsReservationException = lsReservationException & "</ul>Please correct and resubmit." 
	end if
end if
%>

(in reply to rdouglass)
rdouglass

 

Posts: 9167
From: Biddeford, ME USA
Status: offline

  		RE: Issues pulling a correct date. - 10/21/2005 16:12:02   
That's fine but it really doesn't help me much.

What I would like to have to help you is the *exact* variable that you want to extract the information from, the info itself, and what you want it to look like.

For instance:

lsArrDt(1)
"3/12/2006 | 3/4/7/10/11/14/21 | BC/HH/HS | 3/12/2006"
3/12/2006
3
4
7


If you can get me that we can get moving again.

I apologize but I just do not know enough about your project to start throwing more code at you. What I have provided has done what you asked (at least I think it has) but it doesn't seem to be what you need.

My suggestion would be to:

1. Run the code.
2. Find out the *first* spot it breaks.
3. Collect the variables, values, and expected data from that point and *no others*.

Let's try not to confuse each other again and take 1 problem at a time.

_____________________________

Don't take you're eye off your final destination.

ASP Checkbox Function Tutorial.

(in reply to fearnosurf)
fearnosurf

 

Posts: 149
Joined: 8/15/2005
Status: offline

  		RE: Issues pulling a correct date. - 10/21/2005 16:22:57   
The variables I'm trying to pull are:
arrDt11, nights11, homes11
arrDt12, nights12, homes12
arrDt13, nights13, homes12
arrDt21, nights21, homes21
arrDt22, nights22, homes22
arrDt23, nights23, homes23
arrDt31, nights31, homes31
arrDt32, nights32, homes32
arrDt33, nights33, homes33
arrDt41, nights41, homes41
arrDt42, nights42, homes42
arrDt43, nights43, homes43
arrDt51, nights51, homes51
arrDt52, nights52, homes52
arrDt53, nights53, homes53
arrDt61, nights61, homes61
arrDt62, nights62, homes62
arrDt63, nights63, homes63
arrDt71, nights71, homes71
arrDt72, nights72, homes72
arrDt73, nights73, homes73


Those are the fields on the form page that I need to collect. Nights & homes are easy to collect, it's arrDt that is the hard part. When I grab arrDt it returns the full selection of data from the drop down list which looks like this:

8/30/2006 | 4/11 | BC/HH/HS | 8/30/2006 (4, 11 night only)

So I will need to trim this to include only the 8/30/2006

That we accompished with your code (thanks).

Now the issue I am having is that if one of the fields above are blank, I need it to return a ""
right now arrdt is returning a (none) and nights & homes are returning a 0

My idea of late, is to set a session, format this code how I want it and store it in the session, but either way I'm having tons of issues getting it to return a "" instead of (none) or 0

And thanks for all your help and patience.

(in reply to rdouglass)
rdouglass

 

Posts: 9167
From: Biddeford, ME USA
Status: offline

  		RE: Issues pulling a correct date. - 10/21/2005 18:39:30   
quote:

right now arrdt is returning a (none)


Can you post an example arrDt that has a "(none)" in it?

Is there more text in arrDt than just (none)? If so, that's what wrong witht the other issue as well.

_____________________________

Don't take you're eye off your final destination.

ASP Checkbox Function Tutorial.

(in reply to fearnosurf)
fearnosurf

 

Posts: 149
Joined: 8/15/2005
Status: offline

  		RE: Issues pulling a correct date. - 10/24/2005 16:27:54   
I fixed it, or have it working. But to answer your question, here is all the data for arrDt

<%
if psArrDt11 = "" then
%>
<option value="(none)" SELECTED> </option>
<%
else
%>
<option value="(none)"> </option>
<%
end if

for ArrDtIx = 1 to ArrDtMax
j1 = mfnInstrRev(lsArrDt(ArrDtIx),"|")
x1 = trim(mid(lsArrDt(ArrDtIx), j1 + 1))
if lsArrDt(ArrDtIx) = psArrDt11 then
%>
<option value="<%=lsArrDt(ArrDtIx)%>" SELECTED><%=x1%></option>
<%
else
%>
<option value="<%=lsArrDt(ArrDtIx)%>"><%=x1%></option>
<%
end if
next
%>

(in reply to rdouglass)
Page:   <<   < prev  1 [2]

All Forums >> Web Development >> ASP and Database >> RE: Issues pulling a correct date. 		Page: <<   < prev  1 [2]
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


Back to top

  Microsoft Corporation in no way endorses or is affiliated with "OutFront."
  OutFront is published and edited by Thomas Brunt.
  440 Great Circle Dr., St. Matthews, SC 29135.
  © 2008 All Rights Reserved
  Click here to view our privacy statement.