> Tried that one (I guess 1899-12-31 is a default of some > sort), now I get: > > Error Occurred While Processing Request > Error Executing Database Query. > [Macromedia][SequeLink JDBC Driver][ODBC > Socket][Microsoft][ODBC Microsoft > Access Driver] Too few parameters. Expected 1. > > The error occurred in > C:\CFusionMX7\wwwroot\marylandPro\Reports\TheDailyFeed.cfm: line 20 > > 18 : FROM TimeCard > 19 : WHERE TimeCard.Associate = session.Associate
Since there's no table called "Session" within your query, I assume that session.Associate should be a CF variable and therefore wrapped in hashes for evaluation? In addition, I'd recommend that you use CFQUERYPARAM for all these variables within your query. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218346 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
