Anyone tell me whats wrong with this code? Programming Web Development by Cheesecake87 … seen here: [url]http://imageshack.us/photo/my-images/194/databasedesign.png/[/url] Hmm :/ is there something different about how coldfusion… Re: export sql server database to access Programming Software Development by kvprajapati [QUOTE=shuhana84;1247383]hi,i want to know how to export sql server 2005 database to access through vb.net coding..no need to select n insert table one by one,just save package...[/QUOTE] Read this article - [url]http://www.databasedesign-resource.com/import-and-export-in-sql-server.html[/url] Databasedesign problem price list system Programming Databases by heinzel Hi All, After searching the web and this specific forum I can't seem to find a suitable solution to my problem and after hours of thinking I wasn't able to come up with a solution that will fit the problem. This is the case: I need a database model that will support a price list system for determining the price for a given article with … Re: Databasedesign problem price list system Programming Databases by debasisdas may be i will read this LONG question in weekends. Re: Databasedesign problem price list system Programming Databases by heinzel [QUOTE=debasisdas;1503726]may be i will read this LONG question in weekends.[/QUOTE] Thanks for your response. But I already thought of another approach that will help me to achieve my goal. So I will leave this thread for what it is and close it. Re: Anyone tell me whats wrong with this code? Programming Web Development by arrgh [QUOTE=;][/QUOTE] [quote]its not even a variable with time in it. ... <cfset ET = timeformat(EndTime, 'H')> [/quote] Then why are you using timeFormat on it? :) If EndTime is null, its probably returning an empty string, hence the error when you try and perform subtraction. Make sure it's a number and problem solved. [code] <…