freelanceprogrammers.org Forum Index » Cold Fusion

View previous topic :: View next topic

SQL Query Help

Goto page Previous 1, 2

bhhightower Posted: Tue Apr 05, 2005 3:16 pm

Joined: 10 Sep 2002

Posts: 9

SQL Query Help

Try putting single tics around your dates like this

<cfset start_yr1 = start_yr + q -1>
<cfset start_yr1 = "12/31/" & start_yr1>
<cfset start_yr1 = DateFormat(start_yr1,"yyyy/mm/dd")>
<cfset end_yr1 = start_yr + q + 1>
<cfset end_yr1 = "1/1/" & end_yr1>
<cfset end_yr1 = DateFormat(end_yr1,"yyyy/mm/dd")>

<cfquery name="colA" datasource="#ds">
SELECT ID from people
where Entered_Program BETWEEN `#CreateODBCDate(start_yr1)#`
AND `#CreateODBCDate(end_yr1)#`
AND HID = #dist_site.ID#
</cfquery>

<cfquery name="colB" datasource="#ds#">
SELECT ID from people
where Graduation BETWEEN `#CreateODBCDate(start_yr1)#`
AND `#CreateODBCDate(end_yr1)#`
AND HID = #dist_site.ID#
</cfquery>

<cfquery name="colC" datasource="#ds#">
SELECT ID from people
where Entered_Program > `#CreateODBCDate(start_yr1)#`
AND Graduation < `#CreateODBCDate(end_yr1)#`
AND HID = #dist_site.ID#
</cfquery>

-----Original Message-----
From: Jennifer [mailto:chrystalheart@...]
Sent: Monday, April 04, 2005 7:58 PM
To: cold_fusion@yahoogroups.com
Subject: [cold_fusion] Re: SQL Query Help

Then I saw it was dashes, not slashes, and I changed those, but got
the same error.

Jen

Yahoo! Groups Links

Chrystalheart Posted: Tue Apr 05, 2005 6:29 pm

Joined: 05 Apr 2005

Posts: 37

SQL Query Help

Still no luck.

--- In cold_fusion@yahoogroups.com, "Brannon Hightower"
<hightower@a...> wrote:
> Try putting single tics around your dates like this

Goto page Previous 1, 2

freelanceprogrammers.org Forum Index » Cold Fusion

All times are GMT
Page 2 of 2

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Freelace Website Designer - Customer web design and software building.
Booking Calendar - reservation calendar script
Land Surveying - total station instruments and equipments
China Wholesale - Electronics Products
Character Studio - Tutorials and Help