Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: aitai
  • Order by date
  1. aitai

    BCP & formatfile

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

    BCP & formatfile

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

    Unique Problem

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

    Unique Problem

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

    CF 5.0 & XML

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

    MSQuery &amp; ODBC connection

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

    MSQuery &amp; ODBC connection

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

    Trigger Gurus Only Please!

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

    Insert Trigger Logical Error

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

    Insert Trigger Logical Error

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

    Insert Trigger Logical Error

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

    URL Parameters &amp; DBD::mysql::st execute failed

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

    Type mismatch: 'UBOUND'

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

    Hi, All I know that this should

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

    URL Parameters &amp; DBD::mysql::st execute failed

    ...} #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...
  16. aitai

    Type mismatch: 'UBOUND'

    ...'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...
  17. aitai

    Totally Weird-Oracle Returns Empty RecordSet!

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

    CFREPORT Error 692

    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 =...
  19. aitai

    Linux Install on Windows Dual Boot

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

Part and Inventory Search

Back
Top