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
Expert: Srini Nagarajan
Date: 1/30/2008
Subject: asp code for diplay multi page break
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
|
|
