On 2/28/07 1:55 PM, Steve Milburn wrote: > Damien McKenna wrote: >> Anyone have any idea why it would give the error "name can't be empty" for >> the above statement? I'm thoroughly flummoxed. > > It could be that "name" is a reserved word. Try enclosing it in > brackets like so: > where [name] = .....
It isn't a reserved word in SQL Server 2000 (I checked that one), and also the error isn't coming from the JDBC system anyway. I made the change and, as expected, it made no difference. I'm going to rearrange my code (its a file of functions) to see if there's something else tripping me up that I'm just not seeing. -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include <stdjoke.h> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

