Recent content by jhall01

great point Lyndon!

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

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

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

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

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

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

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

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

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

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

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

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

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

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