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...
...'the following creates a recordset object and recordset at the same time
SET oRecordSet = oDBConnection.EXECUTE("SELECT * FROM Destination")
'if there are any records in the recordset, use the getrows method to
'insert inot array
IF NOT oRecordSet.EOF AND...
...objConn.Open "dsn=OraDev;uid=scott;pwd=tiger;"
Set objRs = objConn.Execute("SELECT * FROM Destination")
Response.Write "<table border=1 cellpadding=4>"
Response.Write "<tr>"
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.