December 4, 2008 09:49pm pst

1. SidFishes 237,211
2. Zvonko 169,944
3. gdemaria 121,410
4. _agx_ 76,137
5. Plucka 70,175
6. erikTsomik 69,400
7. dgrafx 61,964
8. SBennett 59,348
9. zadoc 48,130
10. azadisaryev 44,375
11. hielo 42,450
12. Mr_Nil 40,535
13. duncancu... 24,750
14. srikanthm... 23,062
15. meverest 22,200
16. pmascari 21,125
17. eszaq 18,300
18. BSSupport 17,400
19. angelIII 16,700
20. Jester_48 16,200
21. msfletch 15,948
22. Kerrdo 15,300
23. rob_loren... 14,360
24. js_vaughan 12,250
25. pigmentarts 12,000

1. mrichmon 1,346,158
2. trailblazzy... 693,166
3. pinaldave 662,896
4. SidFishes 613,161
5. anandkp 591,655
6. dgrafx 573,902
7. gdemaria 563,331
8. _agx_ 424,602
9. Plucka 411,543
10. Tacobell777 390,907
11. Jester_48 387,445
12. danrosent... 348,915
13. mkishline 295,040
14. mmc98dl1 271,238
15. entrance... 248,605
16. SBennett 244,438
17. jyokum 242,423
18. usachrisk... 237,753
19. rob_loren... 224,358
20. cheekycj 205,597
21. jimmy282 200,834
22. hart 192,788
23. substand 189,138
24. Mause 180,288
25. CFDevHead 178,970

01.24.2006 at 12:50PM PST, ID: 21708702

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.8

DATEdiff problem coldfusion

Asked by dpedersen in ColdFusion Application Server, ColdFusion Studio

Tags: datediff, coldfusion

hello
this cfquery works fine till i add the datediff part

<cfquery name="get_admits" datasource="#DSN#">
SELECT last_name, first_name, admit_date, disch_date, admitting_diagnosis, icd9_code, DateDiff("d",admit_date,disch_date) AS LOS
FROM Patient AS p, patient_visit AS pv, visit_icd9 AS v
WHERE pv.admit_date between #startdate# AND #enddate#
AND pv.patient_id=p.patient_id
AND pv.med_rec_num=v.med_rec_num
AND v.type Like 'primary'
ORDER BY pv.admit_date;
</cfquery>

once i add that i get tihs error

Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

The error occurred in C:\Inetpub\darrenpedersen.com\admit\reports\yearly_admits\index2.cfm: line 8

6 : SELECT last_name, first_name, admit_date, disch_date, admitting_diagnosis, icd9_code, DateDiff("d",admit_date,disch_date) AS LOS
7 : FROM Patient AS p, patient_visit AS pv, visit_icd9 AS v
8 : WHERE pv.admit_date between #startdate# AND #enddate#
9 : AND pv.patient_id=p.patient_id
10 : AND pv.med_rec_num=v.med_rec_num

WHY?

please help
Start Free Trial

Keywords: DATEdiff problem coldfusion

	Title
1	My "show tables" mistery in linux-m…
2	CFQUERY problem
3	CFQuery
4	syntax for updating a sql datetime field …
5	<= and >= in cfquery
6	CFQuery

Loading Advertisement...

20081112-EE-VQP-43

DATEdiff problem coldfusion

Asked by dpedersen in ColdFusion Application Server, ColdFusion Studio

Tags: datediff, coldfusion

About this solution