-
help!
hi i've posted this question to a few forums and so far no-one has solved it.
i am producing a site for a client and one of the features is a list of trade shows and exhibitions.
When users log on i only want them to be able to view shows that start on or after the current date.
I have a MS database which has a sdate (i.e. start date) field. I have specified this as a "date" field in Access.
The SQL i am using is as follows:
<%ServerDate = date
ServerDate= "#" & ServerDate & "#"
SQL="SELECT * FROM exhibitions where sdate > " & ServerDate
%>
-
Yesssss,
but what is the actual problem or error?
-
sorry, i've written it out that many times...
the problem is that it only displays a couple of records when there are over 60. I guess it is something to do with the way it is resolving the date, however i'm not sure what.
-
Date format
Silly point, but are you sure the dates are in the same format, ie. dd/mm/yyyy as system date, but mm/dd/yyyy as date stored in db?
Last edited by alexcave; 02-20-2003 at 05:24 AM.
-
yes they are, and i think ifinally cracked it last night. seems to be working ok now anyway, thanks guys!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|