Re: [U2] Base 16, 26, 36

2005-04-22 Thread Cliff Bennett
Try this Bill. It returns a value for SUFFIX of AA1 for box 1, bag 1 and ZZ9 for box 676, bag 9. You could extend it to capture numbers also but would need to account for the gap in the ASCII character chart between upper case letters and numbers. This could be condensed into a single line;

Re: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}

2005-04-22 Thread Cliff Bennett
Millions (plural) of DB requests per day will require serious infrastructure regardless of middleware platform. Plus there's always the last-day-of-quarter discount with IBM. 8-) With SQL Server, you also need one or two CAL's (Client Access Licenses) per named user (not concurrent). Plus I

[U2] Base 16, 26, 36

2005-04-22 Thread Brutzman, Bill
We have a bar-code labeling challenge. We need to print hundreds of unique serialized labels. We have three characters available. I am expecting to do something like Master (pallet): H42 2x MMM H42 is our supplier ID. Box # 1 H42 2x AA0 2x is the six-digit

Re: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series]

2005-04-22 Thread FFT2001
In a message dated 4/22/2005 7:29:58 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: So, if you use MQ like a connection pool, that is not desirable performance-wise, and is a breach of your license agreement. But if you use it for applications to communicate (which is the purpose of

RE: [U2] color laserjet pcl programming for logos

2005-04-22 Thread Buss, Troy \(Logitek Systems\)
Tom, Thanks for your reply. Playing around late last night, I was able to select the CYAN color option and resolve the problem I had with the graphics. Coincidentally, that color was acceptable and the 2 bit logo mapped into the CMYK pallette with white(0) and cyan(1) just right. Had I wanted

RE: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series]

2005-04-22 Thread Richard Taylor
LeRoy, Perhaps I don't fully understand your example, but I don't see the distinction here. If I have a webpage that sends a request to the U2 database (via any method mentioned in this thread) and waits for it's response then goes on with it's own life each web site vistor would only be using

Re: [U2] Hold-file to CSV

2005-04-22 Thread Mark Johnson
I created the best of both worlds. I have a preview program that gathers the HOLD (PEQS) items and displays the first 5 non-blank lines. When a user chooses an item, the program asks if its going to a TXT file or CSV. If TXT, I simply copy it to that filename verbatim. If CSV, I run it through a

RE: Re[2]: [U2] URL Encoding

2005-04-22 Thread George Gallen
FYI. Anything past the first ? will be ignored by the webserver as a URL, but WILL be passed to the .cgi in the environment variable for URL. It will then be up to the .cgi or whatever program, to decode the URL paramters and use them as such. so http://somewebsite.com/foldername is the

RE: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}

2005-04-22 Thread Bill H.
Cliff: With SQL Server, you also need one or two CAL's (Client Access Licenses) per named user (not concurrent). Plus I believe the more full-featured server versions are more expensive on the server side. A quick look on Google and you'll find an SQL Server Enterprise for $2,000 -

RE: [U2] Base 16, 26, 36

2005-04-22 Thread Tony Gravagno
Here's a link to similar discussion in CDP a number of years ago. There you'll find a couple programs and what may be a one-liner *nix solution. http://groups-beta.google.com/group/comp.databases.pick/browse_frm/thread/c c9509f274c79134/c40d80cdc7e46bad (may need to be sewn together if your mail

RE: [U2] Base 16, 26, 36

2005-04-22 Thread Rod Hills
Take a look at this small program... 0001 FOR I = 0 TO 625 0002 A=INT(I/26) ; B=MOD(I,26) ; C=MOD(A,26) 0003 PRINT I,CHAR(65+C),CHAR(65+B) 0004 NEXT I It will map the numbers from 0 to 625 into AA to ZZ. -- Rod Hills -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Re: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}

2005-04-22 Thread Dave S
What is the definition of a webshare ? Cliff Bennett [EMAIL PROTECTED] wrote:Millions (plural) of DB requests per day will require serious infrastructure regardless of middleware platform. Plus there's always the last-day-of-quarter discount with IBM. 8-) With SQL Server, you also need one or