Re: MS-SQL 7 versus MS-SQL 2000

On Wed, May 08, 2002 at 11:59:43AM +0200, Vincent Oostindie wrote: > > everytime I do an insert I get an error 'This statement has been > cancelled', but the record is inserted successfully!. I thought that this > is very strange, so I dug a little deeper. It turns out that the code > above is executed many times instead of just once: the first time the > record is inserted successfully, but the script simply continues to insert > new records. Sounds like a problem with your code. I'll bet the reason the error arrises with some db servers and not with others is because you have some if, for, or while statement which evaluates a value returned from the database. But, the value returned from MS-SQL 7 is not one you expected. --Dan -- PHP classes that make web design easier SQL Solution | Layout Solution | Form Solution sqlsolution.info | layoutsolution.info | formsolution.info T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409