After all this I finally realized I had a column name that was a key word in MS SQL 2000. Once that was corrected the original code worked.
For anyone contemplating migrating to MS SQL If there is one hard lesson that I have learned about MS SQL 2000, it is how unforgiving MS SQL is with any variance from the rules. I got by with a lot of slop in MS Access and MySQL that MS SQL just wont let fly. Aside from the slop and reformatting, I.e., when and where to use single and double quotes, everything went fairly smoothly. MySql's TRUNCATE feature is nice, but I had to revert to slightly more involved DELETE for SQL. This comment comes from very little knowledge and a whole lot more ignorance of both MS SQL and MySQL, but I can't see any gain unless you need the advanced features of MS SQL, such as, procedures and security. For many Websites MySQL seems to be much easier to get started with and use. Definitely the phpMyAdmin is the easier to get on board with. All of you wiser ones can correct me on that. Thanks for everyone's input! Nick At 12:55 PM 2/20/2005, you wrote: > > Don't you need to wrap the entire SELECT in parenthesis? > > > > INSERT INTO ChartGraph (field 1, field2, field3) (SELECT > > field1, field2, > > field3 FROM MasterTable Where Col1= 'TransactionDate' AND > > TransactionTime <= #EndTime# AND TransactionTime >=#StartTime#) > >No, you shouldn't have to do that. > >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! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195720 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
