John Gedeon wrote: > I tried your sql statement in my oracle db and it said it was missing a > right parenthesis
Oeps, sorry. start and end are reserved words and require double quotes. With them, it works like below: test1=# select version(); version ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists