Recent content by aitai

Hi, All The solution to this question is below. I reverse generated a format file from the dos command promt, the results are displayed below: 7.0 2 1 SQLCHAR 0 16 "," 1 CallDateTime 2 SQLCHAR 0 4 "\r\n" 2 AnsweredDuration Whats happening is that the file is in character...

Hi, All I hope someone can give me insight into this problem-thanks in advance! Text File with sample data: CallDateTime,AnsweredDuration 08/02/2002 14:09:56,214 08/02/2002 14:09:54,9 08/02/2002 14:09:54,0 08/02/2002 14:09:52,0 08/02/2002 14:09:52,183 The bcp...

The number of records will always be about 3000 (100% certain). Without the counter, and error is thrown on the first loop after the last record. Thanks

Hi, All I have a unique insert problem with the code below. This code takes a structure from a parsed xml document, and inserts the values the database. The number of records will always be about 3000. Hence, the loop is placed on the inside the query tag to limit the calls to the database to...

Hi, All I am programming in Coldfusion 5. I need to get the xml information in the attached file into Coldfusion for minipulation (display and database input). The file is an .asp file that is fetched from a remote location with the <CFHTTP> tag. The elements (and their corresponding...

Hi, All Our IP addresses recently change, and for some reason, the msquery that pulls data from our SQLServer (7.0) into spreadsheets does not work (error message: connection failure). And we have, quite literally, hundreds of these making manual intervention impractical. The IP address for...

Hi, All Our IP addresses recently change, and for some reason, the msquery that pulls data from our SQLServer (7.0) into spreadsheets does not work (error message: connection failure). And we have, quite literally, hundreds of these making manual intervention impractical. The IP address for...

The many that I have spoken to all are clueless on this one. Thanks in advance for the right solution! The insert trigger I created works fine (well, nearly fine), except that AFTER the first insert operation (ie second, third etc), it always produces the correct results BUT FOR THE PREVIOUS...

Guys, thanks for both of your suggestions. The problem still persists, however. That is, the values from the inseted table still display a latency of 1 row after running the statement more than once.

create trigger UpdateAffiliateEarnings on Orders for insert, update as --declare variables declare @ProductType varchar(15), @AffID int, @Earnings money, @CurrentEarnings money, @AffTotalEarnings money, @AffTotalPayments money, @AffOutstandingBalance money --check existence of...

Hi, All The many that I have spoken to all are clueless on this one. Thanks in advance for the right solution! The insert trigger I created works fine (well, nearly fine), except that AFTER the first insert operation (ie second, third etc), it always produces the correct results BUT FOR THE...

Thanks, Guys Your suggestions put me over the top-much appreciated! Ivan

Thanks, All You advice did the trick-much appreciated! Ivan

Hi, All I know that this should be simple, and for some reason I am losing my hair! I would appreciate any insight into this problem. Thanks in advance. This is the full error message:Can't execute the select statement:Unknown column 'INSS209' in 'where clause' The unknown column in the...

Hi, All I know that this should be simple, and for some reason I am losing my hair! I would appreciate any insight into this problem. Thanks in advance. This is the full error message:Can't execute the select statement:Unknown column 'INSS209' in 'where clause' The unknown column in the...