Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Searching 1

Status
Not open for further replies.
peter11

peter11

Instructor
Mar 16, 2001
334
US
Does anyone know what is wrong with the code below.
The date entered on the form is 11/11/01.
The database shed_date is set to Short Date.

<CFQUERY DATASOURCE=&quot;sports&quot; NAME=&quot;schedule&quot;>
SELECT *
FROM opponent, schedule, team
WHERE team.ID = schedule.SportID AND
opponent.oppID = schedule.OpponentID and
schedule.sched_date = #form.sched_date1#

ORDER BY sched_Date
</CFQUERY>
<HTML>
<HEAD>
<TITLE>Date Search</TITLE>
</HEAD>
<BODY>

<TABLE BORDER=5>


<TR><cfoutput query=&quot;schedule&quot;>
<TD valign=&quot;top&quot; align=&quot;left&quot;><font size=&quot;2&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><cfif timeformat(sched_date,&quot;HH:mm&quot;) eq &quot;00:00&quot;>TBA<cfelse>#timeformat(sched_date,&quot;h:mm&quot;)#</cfif></font>
</TD>
<TD valign=&quot;top&quot; align=&quot;left&quot;><font size=&quot;2&quot; face=&quot;Arial, Helvetica, sans-serif&quot;>#teamname#</font>
</TD>
<TD valign=&quot;top&quot; align=&quot;left&quot;><font size=&quot;2&quot; face=&quot;Arial, Helvetica, sans-serif&quot;>#dateformat(sched_date,&quot;DDDD&quot;)#</font>
</TD>
<TD valign=&quot;top&quot; align=&quot;left&quot;><font size=&quot;2&quot; face=&quot;Arial, Helvetica, sans-serif&quot;>#dateformat(sched_date,&quot;mm/dd/yy&quot;)#</font>
</TD>

<TD valign=&quot;top&quot; align=&quot;left&quot;><font size=&quot;2&quot; face=&quot;Arial, Helvetica, sans-serif&quot;>#Site#</font>
</TD>
<TD valign=&quot;top&quot; align=&quot;left&quot;><font size=&quot;2&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><cfif #Site# IS &quot;Away&quot;><a href=&quot;link.cfm?id=#opponentID#&quot; target=&quot;_blank&quot;>#OpponentName#</a>
<cfelse>
#OpponentName#
</cfif></font>
</TD>
</TR></cfoutput>

</TABLE>
</BODY>
</HTML>
 
Sort by date Sort by votes

ORDER BY schedule.sched_Date

Sylvano
dsylvano@hotmail.com
 
Upvote 0 Downvote
I still get a blank page. No Cold Fusion error, justa blank page. I don't get it.
 
Upvote 0 Downvote
A blank page would indicate no rows, so if still in dev and you have access to Administrator, trying turning on &quot;Show query information &quot; in debugging. This will let you know whether your query is returning anything, as it may be a join prob if not.

If rowcount is > 0, then your problem may be with logic not query.
 
Upvote 0 Downvote
If schedule.sched_date is a Date or Date/Time field in the database then the code needs to format the date so the db can recognize it as a date using CreateODBCDate() or CreateODBCDateTime() function:

schedule.sched_date = #CreateODBCDate(form.sched_date1)# - tleish
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

clearwave
  • Locked
  • Question
Timesheet entry form that auto-fills the Date range?
Replies
4
Views
337
clearwave
clearwave
Luvsql
  • Locked
  • Question
Hidden Date Field Issue Not Updating Properly
Replies
3
Views
264
darryncooke
darryncooke
JohnShell
  • Locked
  • Question
Date formatting input text box 1
Replies
2
Views
203
JohnShell
JohnShell
LAdProg2005
  • Locked
  • Question
creating proper date
Replies
4
Views
157
cfSearching
cfSearching
jesse1
  • Locked
  • Question
inserting date string into a smalldatetime
Replies
2
Views
190
SidianConsulting
SidianConsulting

Part and Inventory Search

Sponsor

Back
Top