Ask a Question related to ASP Database, Design and Development.
-
rudolf #1
Weird! Problem of query the date for January and October
It's weird! I am writing an asp code to retireving data
from the MS access. Any records before today will not be
populated. It works fine except that I could not get any
result for the month of January 2004 and October 2004 at
all. What's wrong. please asvise. Many thanks!
Dim getToDate
getToDate = now
....
....
....
reqSQL = "Select EDate,Url, Title, Sdate, Edate,
Address, Organiser, Venue, Fee, Target, Category FROM
Train_Events WHERE CDATE(Period) >='" & CDATE(getToDate)
& "'" & " ORDER BY CDATE(Period)"
rudolf Guest
-
date query problem, date in variable
I am using the following query : $query_archief = "SELECT * FROM vacatures where dd_eind_plaatsing < $dd_eind_plaatsing_archief1" note:... -
More Date Query Problem
Hi, I have written the code below to return only data that are recorded this month: <cfquery name="getInfo" datasource="main_acc" dbtype="odbc">... -
Problem with ADO query against a DBF date field
Marit, Jet and VBScript use the same underlying numeric representations of date/time values, and your best bet is to pass your value as a numeric... -
[PHP] Weird Date problem driving me crazy...
Thanks John, your answer is right on the $$$. Changing the query to something like : SELECT UNIX_TIMESTAMP(ProblemStart) as ProblemStart solved... -
Weird Date problem driving me crazy...
I have two date strings coming out from MySQL. Both fields are defined as datetime. When i come to print them like this : Echo"<B>Ticket... -
Martin Honnen #2 Re: Weird! Problem of query the date for January and October
rudolf wrote:
With MS Access date values need to be delimited by #:> It's weird! I am writing an asp code to retireving data
> from the MS access. Any records before today will not be
> populated. It works fine except that I could not get any
> result for the month of January 2004 and October 2004 at
> all. What's wrong. please asvise. Many thanks!
>
>
>
> Dim getToDate
> getToDate = now
> ...
> ...
> ...
> reqSQL = "Select EDate,Url, Title, Sdate, Edate,
> Address, Organiser, Venue, Fee, Target, Category FROM
> Train_Events WHERE CDATE(Period) >='" & CDATE(getToDate)
> & "'" & " ORDER BY CDATE(Period)"
[url]http://www.aspfaq.com/show.asp?id=2040[/url]
--
Martin Honnen
[url]http://JavaScript.FAQTs.com/[/url]
Martin Honnen Guest
-
rudolf #3 Re: Weird! Problem of query the date for January and October
It works!Thanks a lot!
rudolf Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
