Thanks for your feedback Alejandro,
This does work however, it only spans out for one day. What I am wanting to
accomplish is a five day work week span.
Any suggestions?
Thanks,
Dayv
-----Original Message-----
From: Alejandro Mozo [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 1:58 AM
To: CF-Server
Subject: Re: Weekly Date Driven Content in Cold Fusion?
I think you don?t want people use a form to select the date, so you must use
now() function.
In my website I use this code:
<cfquery name=".." datasource="..">
select * from my_table where my_date = (select max(my_date) from my_table
where my_date <= #createodbcdate(now())#)
</cfquery>
If the real date is the same than my_date column the article will be on
line.
Alejandro Mozo Quesada
Sistemas / Programacion
http://www.tiza.net
educar divirtiendo
----- Original Message -----
From: "Tomas Becklin :: Web Developer" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Friday, April 20, 2001 11:23 PM
Subject: RE: Weekly Date Driven Content in Cold Fusion?
> Loose the pound (#) signs inside <CFSET> tag, no need for them
>
> and are you sure that the form variable is spelled right,try to output it
> before doing anything else with it... besides that you need to put ''
around
> the "where my_date <= '#start_date#'"
>
> If the my_date field is a TEXT field that is...
>
>
>
> -----Original Message-----
> From: SHEETS, DAYV (PB) [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 20, 2001 1:51 PM
> To: CF-Server
> Subject: RE: Weekly Date Driven Content in Cold Fusion?
>
>
> Yep - and I also tried it using the Date/Time stamp...
>
> When I attempt to try your suggestion, I receive the following error:
>
> <snip>
> ===============================
> Error Diagnostic Information
>
> An error occurred while evaluating the expression:
>
>
> my_date = #CreateODBCDate(FORM.my_date_column, "mm/dd/yyyy")#
>
>
>
> Error near line 1, column 7.
> --------------------------------------------------------------------------
--
> ----
>
> Error resolving parameter FORM.MY_DATE_COLUMN
>
>
> The specified form field cannot be found. This problem is very likely due
to
> the fact that you have misspelled the form field name.
>
>
>
> The error occurred while processing an element with a general identifier
of
> (CFSET), occupying document position (1:1) to (1:69).
>
> </snip>
> ===============================
>
>
> My page looks like this -
> ===============================
> <snip>
> <CFSET my_date = #CreateODBCDate(FORM.my_date_column, "mm/dd/yyyy")#>
> <CFSET start_date = #CreateODBCDate(FORM.start_date, "mm/dd/yyyy")#>
> <CFSET end_date = #CreateODBCDate(FORM.end_date, "mm/dd/yyyy")#>
>
> <cfquery name="weekly" datasource="temp">
> select * from weekly where my_date >= #start_date# and my_date_column
<=
> #end_date#
> </cfquery>
>
> </snip>
> ===============================
> ..... any advise... ? besides the obvious (pull my hair out) ;)
>
> TA,
>
> Dayv
>
>
> -----Original Message-----
> From: Hong, Tammy T [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 20, 2001 1:10 PM
> To: CF-Server
> Subject: RE: Weekly Date Driven Content in Cold Fusion?
>
>
> Humm have you formatted to ODBC?? Not sure if this will help or perhaps
you
> have done this already?? Just curious but why is my_date_column TEXT
instead
> of Date/Time data type??
>
> <CFSET my_date = #CreateODBCDate(FORM.my_date_column, "mm/dd/yyyy")#>
> <CFSET start_date = #CreateODBCDate(FORM.start_date, "mm/dd/yyyy")#>
> <CFSET end_date = #CreateODBCDate(FORM.end_date, "mm/dd/yyyy")#>
>
> then query DB:
>
> <cfquery name="weekly" datasource="temp">
> select * from weekly where my_date >= #start_date# and my_date_column
<=
> #end_date#
> </cfquery>
>
> -T
>
> -----Original Message-----
> From: SHEETS, DAYV (PB) [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 20, 2001 2:34 PM
> To: CF-Server
> Subject: RE: Weekly Date Driven Content in Cold Fusion?
>
>
> Ack -
>
> I am still having difficulty using the code provided. For some reason I
keep
> receiving an error. I used the following example provided (for now, I am
> using access as the db):
>
> <!--weekly.cfm-->
>
> <cfset date_in = #createodbcdate(now())#>
>
> <cfquery name="weekly" datasource="temp">
> select * from weekly where my_date_column >= #form.start_date# and
> my_date_column <= #form.end_date#
> </cfquery>
>
> On my database, I have the following feilds:
>
> QuoteID =>AutoNumber
> Quote =>Memo
> Author =>Memo
> start_date =>Date/Time
> end_date =>Date/Time
> my_date_column =>Text
>
> When the page is executed, I receive the following error:
>
> <snip>
> Error Diagnostic Information
>
> An error occurred while evaluating the expression:
>
>
> #form.start_date#
>
>
>
> Error near line 4, column 51.
> --------------------------------------------------------------------------
--
> ----
>
> Error resolving parameter FORM.START_DATE
>
>
> The specified form field cannot be found. This problem is very likely due
to
> the fact that you have misspelled the form field name.
>
>
>
> The error occurred while processing an element with a general identifier
of
> (#form.start_date#), occupying document position (4:50) to (4:66).
>
> </snip>
>
> -Ack!-
>
> Can someone tell me what I need to correct in order to get it to work
(with
> the relevent codes entirety)?
>
> Thanks,
>
> Dayv
>
> -----Original Message-----
> From: SHEETS, DAYV (PB) [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 20, 2001 1:26 PM
> To: CF-Server
> Subject: RE: Weekly Date Driven Content in Cold Fusion?
>
>
> So should I name the column "my_date_column" and if the date falls within
> the date span from the current date it will then be displayed, OR should I
> instead have two columns; one named "start_date" and one named "end_date"?
>
> Please clarify...
>
> Thanks again for all of your responses! :)
>
> Dayv
>
>
> -----Original Message-----
> From: Heath Tucker [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 20, 2001 7:13 AM
> To: CF-Server
> Subject: Re: Weekly Date Driven Content in Cold Fusion?
>
>
> I would go so far as to run a dateformat statement on the input dates
> to insure they are read correctly.
>
> #DateFormat(Now(),"mm/dd/yyyy")#
>
> <cfquery name="..." datasource="...">
> SELECT *
> FROM mytable
> WHERE my_date_column >= #DateFormat(form.start_date,"mm/dd/yyyy")# and
> my_date_column <= #DateFormat(form.end_date,"mm/dd/yyyy")#
> </cfquery>
>
>
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: "CF-Server" <[EMAIL PROTECTED]>
> Sent: Friday, April 20, 2001 8:40 AM
> Subject: Re: Weekly Date Driven Content in Cold Fusion?
>
>
> >
> >
> > I think he actually wants something like this:
> > <cfquery name="..." datasource="...">
> > select * from mytable where my_date_column >= #form.start_date# and
> > my_date_column <= #form.end_date#
> > </cfquery>
> >
> >
> > tom
> >
> >
> >
> > Of course!
> >
> > try somethig like this:
> >
> > <cfquery name="..." datasource="...">
> > select * from mytable where start_date <= #createodbcdate(now())#
and
> > end_date >= #createodbcdate(now())#
> > </cfquery>
> >
> > Alejandro Mozo Quesada
> > Sistemas / Programaci
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
