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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. jhall01

    Leading zeros

    great point Lyndon!
  2. jhall01

    Help Joining 2 tables on a distinct query

    oh, and looking at the query i just noticed that you are passing numbers as strings? '6587490' AND '6587491' is sdocumentnosort really string data types that you are trying to evaluate as numeric/int? or are they numeric/int datatypes in the database? If so you don't need the single quotes...
  3. jhall01

    Help Joining 2 tables on a distinct query

    I prefer using Group By clauses instead of Distinct, they tend to be more efficient and allow me more control over what data is actually being "thrown out" Try the following: SELECT tblpagerange.* FROM tblPageRange JOIN tbldocumentinfo ON tbldocumentinfo.imageid = tblpagerange.imageid where...
  4. jhall01

    data source not found

    have you setup "sd99" as your DSN in the CF admin datasources?
  5. jhall01

    Leading zeros

    yes, zip codes are best stored as strings since mathematical operations won't be used on the data...plus having it as a string will support non US postal codes that contain letters. Depending on your usage, since zip codes are always 5 characters long, its sometimes better to use char(5)...
  6. jhall01

    Dynamic Variable Names & Values

    although its best to avoid evaluate whenever possible: <cfset Number = #Evaluate('Session.#url.number#.Number')#>
  7. jhall01

    Monthly Reports

    Depending on your Database system you could do something similar (date functions vary DB to DB): <cfquery name="qsummary" datasource="#request.dsn#" username="#request.uname#" password="#request.passwd#"> SELECT b.project ,SUM(CASE WHEN month(a.day) = 1 THEN a.hours_worked ELSE 0 END) jan...
  8. jhall01

    Excel & Attachmate Timing?

    BTW - Thanks for the help calculus, as always you are a tremendous help!
  9. jhall01

    Excel & Attachmate Timing?

    for those having problems with timing issues here is one possible issue to fix: set your .WaitHostQuiet object to a variable: boolSleep = MyScn.WaitHostQuiet(xtraSettleTime) this forces the Excel to wait for boolSleep to be set to "True" before it moves on in the code. I was previously using...
  10. jhall01

    Excel & Attachmate Timing?

    I have found a couple of other posts very similar to mine. I actually made my sleep() and added 3 Xstatus loops. It seems that Excel and Attachmate are not syncing up. The problem, excel is moving too fast for Attachmate. Does the Xstatus loop slow down excel or Attachmate? I have even...
  11. jhall01

    Excel & Attachmate Timing?

    So just for curiousity, I would put that loop after every step i need to wait on? ie Do while MyScn.OIA.Xstatus <> 0 Doevents Loop compName = MyScn.GetString(3, 2, 25) MyScn.PutString "CPNI", 1, 6 Do while MyScn.OIA.Xstatus <> 0 Doevents Loop...
  12. jhall01

    Excel & Attachmate Timing?

    Hah, found a solution: With MyScn .SendKeys (npa) .SendKeys (nxx) .SendKeys (line) .SendKeys ("<Pf2>") End With Application.Wait (Now + TimeValue("0:00:01")) compName = MyScn.GetString(3, 2, 25) MyScn.PutString "CPNI", 1, 6 Application.Wait (Now +...
  13. jhall01

    Excel & Attachmate Timing?

    Here is my VBA code: Sub set_settleTime() xtraSettleTime = 3000 OldSystemTimeout = System.TimeoutValue If xtraSettleTime > OldSystemTimeout Then System.TimeoutValue = xtraSettleTime End If End Sub ... call set_settleTime ... With MyScn .SendKeys (npa)...
  14. jhall01

    Is it a Global Variable or a Global Constant?

    I do this all the time. A great source for creating exactly what you need: http://www.sqldts.com/default.aspx?246
  15. jhall01

    .db2 file extension

    Thanks Greg, This appears to be what the file is! Now on to learning the basics DB2 :D
  16. jhall01

    Cant Enable Verity

    We are running the following Environment: RedHat Linux AS 2.1 ColdFusion MX 6.1 SunOne Webserver 6.0 J2EE We get a collection created and the K2Server started. We added the path on the Webserver JVM Path Settings, but we get the error on Coldfusion Administrator when we try to setup Verity...
  17. jhall01

    .db2 file extension

    I am trying to understand a custom App a client has that a company who went bankrupt built for them. There is a file within the app that contains the file extension of .db2, and all I can find on it is that it might be a precompiled DB2 SQL procedure Script. I have never used DB2 in my life...
  18. jhall01

    db2 file extension

    Well I did find this: http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/ad/c0007609.htm Looks like it might not be a data file at all but a precompiled Procedure Script for IBM's DB2. Guess I was wrong about it containing data. Problem is this came from a...
  19. jhall01

    db2 file extension

    Yeah i look on several file extension sites and they say it is associated with dbase II but i thought dbase II data files were *.dbf I also found that *.db2 are associated with CA-dbFast, but that is another dead end. DB2 associates the file with comand line script. I know there is data in...
  20. jhall01

    db2 file extension

    What the heck is a *.db2 file? all I can find is that it is a dbase II file. If it is a dbase II data file how can I open? Can I get an ODBC Driver to open it? I have never used dbase(if it is in fact a dbase II data file) so please speak to me as if I were a child! :)

Part and Inventory Search

Back
Top