AllExperts > Active Server Pages Programming (ASP) 
Search      
Active Server Pages Programming (ASP)
Volunteer
Answers to thousands of questions
 Home · More Active Server Pages Programming (ASP) Questions · Answer Library  · Encyclopedia ·
More Active Server Pages Programming (ASP) Answers
Question Library

Ask a question about Active Server Pages Programming (ASP)
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Srini Nagarajan
Expertise
I can answer any kind of questions in ASP.NET, C#, VB.NET, SharePoint 2007, ASP, Coldfusion, Powerbuilder 7.00 / 8.00, JAVA servlets, MS SQL 2000 / MSSQL7, Sybase

Experience
Contact me if you need any custom development on ASP.NET, ASP, SharePoint 2007, Coldfusion, Powerbuilder.
 
   

You are here:  Experts > Computing/Technology > Business Software > Active Server Pages Programming (ASP) > asp code for diplay multi page break

Active Server Pages Programming (ASP) - asp code for diplay multi page break


Expert: Srini Nagarajan - 1/30/2008

Question
QUESTION: I try display multi page between start date and end date,while running 1st page diplay record click next page
date error ,how can sort out the error,am using ms access and asp

ANSWER: hi,

sorry for the delay in reply.

you need to convert the string to date format before pass as start date or end date.

-Srini

---------- FOLLOW-UP ----------

QUESTION: I format date string even 2nd page click(error messageMicrosoft JET Database Engine (0x80040E07)
Syntax error in date in query expression 'dep_date >= ## and dep_date <= ##'.)
strSQL = ("Select * From departure Where dep_date >= #" & date1 & "# and dep_date <= #" & date2 & "# order by dep_date")


Answer
hi

where the date1 and date2 to get filled?

in page 2 the date1 and date2 are blank so you are getting this error.

if you are getting the date value from request form or query string, you need to pass the date1 and date2 value when you goto page 2.

so the page 2 link should be like this

<a href="pagename.asp?date1=dd/mm/yyy&date2=dd/mm/yyy">2</a>
<a href="pagename.asp?date1=dd/mm/yyy&date2=dd/mm/yyy">3</a>
etc...

-srini

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.