ERT

(please excuse didn't use aliases). query output "none" if 3rd qrtr sales equals 4th quarter sales, output saying "up" when equal each other. please me correct code trend: iif([qryquarterlycustomersales3rdquarter_final] .[3rd qrtr sls]=[qryquarterlycustomersales4thquarter_final] .[4th qrtr sls],"none", iif([qryquarterlycustomersales3rdquarter_final] .[3rd qrtr sls]>[qryquarterlycustomersales4thquarter_final] .[4th qrtr sls],"down","up")) are sure 2 values same? written there appears slight mistake in inner iif statement, doesn't explain results you're getting. pseudocode helps me understand how these expressions work: if q3 = q4 "none" else* if q3 > q4 "up" else* "down" *note else implied; not legal syntax here making few changes possible, should work expect to: trend: iif([qryquarterlycustomersales3rdquarter_final] .[3rd qrtr sls]...

can access file/folder within zip file without extracting temporary file? this on linux system. right now, need "read" file, possible "write" well? edit 1: sorry not clarifying, hoping command line tool allow work language, alternate, php solution / toolkit need. you don't mention language, java has whole library can used read , write zip file. see: http://download.oracle.com/javase/6/docs/api/java/util/zip/package-summary.html for c or c++, you'll have use 3rd party library.

i use log4j smtp appender , doubt effect application memory when it's tries send many emails.and errors located (memory or other) before send? if application crashes lost "errors" not send yet? if concerned memory investigate e.g. "jvisualvm" in jdk. the contents of mail , events needed generate stored in memory. encourage investigate source code. if application exits jvm no more actions can taken, mails errors should have been sent immediately. if concern you, consider adding shutdown hooks run when jvm shutting down.

i have jquery ui dialog containing checkboxes. want conditionally set state of these checkboxes , open dialog. unfortunately causes problems in ie6. checkbox never checked if it's value set before opening dialog. for example in following code "dialog checkbox 1" never checked in ie6, in every other browser. [ update ] problem how ie6 resets state of checkbox appended anywhere. , when dialog opened, jquery ui appends top of body. apparently "it's known fact when working ie, checked state of checkboxes lose state when appended [anywhere]" (see link below) this jquery forum post suggests resolution concerned changing jquery ui code; i'd rather not if @ possible. are there solutions this? thanks, d. code: <script type="text/javascript"> $(document).ready(function() { $('#dialog').dialog({ autoopen : false, modal : true }); $("a#opendialog").click(function() { $(...

binding dependency property easy in code-behind. create new system.windows.data.binding object, , call target dependency object's setbinding method. but how do when property we're binding clr property , can't provide dependencyproperty argument setbinding ? edit: object implements inotifypropertychanged , if that's relevant. binding targets must dependency properties! that's requirement databinding work! read more here: http://msdn.microsoft.com/en-us/library/ms531387(vs.85).aspx http://msdn.microsoft.com/en-us/library/ms752347.aspx

i have data store, i must store data every user, the data more or less key: 0 value: 107, key: 1 value 213 there 80 key/value sets per user so question is, do have 1 row basically user_id key1, key2... key80 or have 80 rows of user_id, key, value data must store: can see actual data must store here: http://219.89.41.169/reachapi/?gt=the%20hailwood i cant copy/paste approx 8mb of data, page may take while load. but can see given data in format, hence why must store way. i'd cringe @ thought of 81 columns in table. however, if: the number of keys/fields unlikely change, and all of fields relate directly user, , apply every user, and/or you're need query more 1 key @ time given user, then makes more sense have many columns store each user/key combo own row. type safety, ability constrain , index data better, , query user's stats without needing dozen joins (or getting bunch of rows have assemble data structure). if numb...

how command line argument in tasm? pretty simple in masm32 invoke getcl,1,addr buffer i presume should able use os's api functions. windows programs, start getcommandline .