Search results for query: *

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...

...NULL --get relevant information if @AffID IS NOT NULL begin if @ProductType = 'FLOWER' begin select @Earnings=CONVERT(money,ChargedAmount*CommissionRate) from Orders o,FlowerOrder t,Commission c where o.OrderID = t.OrderID and t.CommissionID = c.CommissionID and...

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.

...NULL --get relevant information if @AffID IS NOT NULL begin if @ProductType = 'FLOWER' begin select @Earnings=CONVERT(money,ChargedAmount*CommissionRate) from Orders o,FlowerOrder t,Commission c where o.OrderID = t.OrderID and t.CommissionID = c.CommissionID and...

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

...#my $Course_No = $cgi->param('Course_No'); $Statement = qq[ SELECT * FROM courses WHERE Course_No = $Course_No ]...

...} #select courses from the database sub CourseQuery{ #my $Course_No = $cgi->param('Course_No'); $Statement = qq[ SELECT * FROM courses WHERE Course_No = $Course_No ]; # prepare statement for...

...'the following creates a recordset object and recordset at the same time SET oRecordSet = oDBConnection.EXECUTE(&quot;SELECT * FROM Destination&quot;) 'if there are any records in the recordset, use the getrows method to 'insert inot array IF NOT oRecordSet.EOF AND...

Thanks, Paul-that did it!

...objConn.Open &quot;dsn=OraDev;uid=scott;pwd=tiger;&quot; Set objRs = objConn.Execute(&quot;SELECT * FROM Destination&quot;) Response.Write &quot;<table border=1 cellpadding=4>&quot; Response.Write &quot;<tr>&quot; For I = 0 To objRS.Fields.Count - 1...

Hi, All I am having the following problems embeding a CrystalReports report into a ColdFusion file. Error number 692 ocurred (Error in File D:\Documents and Settings\aitai\My Documents\BackUp\Development\CrystalDevcCustGraph.rpt: Invalid export DLL or export format.). Crystal Library =...

Thanks for the responses Ifincham, followed your advice, from the root console typed 'fdisk -l /dev/hdb' with no luck. The RETURN just went to the next line without processing the command. The only response that I got was from the version of fisk disk ('fdisk -v'). I formatted the unallocated...