Search results for query: *

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

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

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

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

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

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! :)