(#2002-683) - Topics this issue: 1) (Fwd) Q? Gen GUI Client pictures stored in a datab as {03}, 2) HTTPServletRequest {02}, 3) HTTPServletRequest {03}, 4) contractor pay, 5) contractor pay {01}, 6) contractor pay {02}, ---------------------------------------------------------------------- Date: Thu, 2 May 2002 21:37:50 -0700 (PDT) From: rupen shah Subject: Re: (Fwd) Q? Gen GUI Client pictures stored in a datab as {03} Hi Greg What we have done is instead of storing the file in the database, we store/retreive the file on a FTP server which can run on the application server or any other machine if you like And we then store the file attributes ie. FTP_SERVER_FILENAME (unique string) These FTP server details are global constants stored in a table so the user is not prompted for it. FTP_SERVER_NAME FTP_SERVER_IP FTP_SERVER_LOGIN FTP_SERVER_PASSWORD FTP_SERVER_DEFAULT_DIRECTORY When we want to store a record, we upload the file onto a FTP server using an OCX control and create the database entry for the FTP_SERVER_FILENAME When we want to retrive the image, use the record and retrive the file on the TEMP directory using the FTP control. We wanted to avoid using BLOBS. One alternate solution is if you plan to use Oracle, they have stored procedures to "link" physical files to the database field (some sort of OLE for Oracle) Regards -Rupen > > >------- Forwarded message follows ------- > > > From: "Nesheim, Greg N." > > > > To: "COOLGEN List Member" > > > > > > Subject: [COOLGEN] Q? Gen GUI Client > pictures stored > > > in a database {01} > > > Date sent: Thu, 2 May 2002 17:08:58 > -0500 > > > > > >We are doing an enhancement to our application. > > >We desire to display a customers photo on our > main menu GUI > > >window when > > >their customer number is entered. > > >The plan is to store the picture on the database. > > > > > >Has anyone done anything like this? > > > > > >We have some theoretical ideas on how to do this > but we are > > >wondering if > > >someone has already done something like this. > > > > > >We plan to have a table with 3 attributes. The > first attribute is the > > >customer number, the second attribute is an > attribute we can use to > > >identify > > >a "Part Number" of the picture (ie: 1,2,3,4), and > the 3rd is an > > >attribute to > > >hold the picture (plan to use jpg pictures). In > GEN we would declare > > >the > > >picture attribute a "mixed text", but because the > max size is 4094 we > > >will > > >split the jpg into chunks of 1,2,3,or 4 pieces. > We have found that > > >most > > >jpg's are from 9 to 30k characters in length. > > > > > >We will have the Gen client request the Gen > server to deliver each > > >piece of > > >the jpg for that customers picture and write the > picture locally onto > > >the > > >request PC's hard drive with a file name of > picture.jpg and display > > >the > > >picture as an OLE on the GUI client window. > > > > > >Does anyone think this will work? or have a > better idea? > > > > > >Environment: > > >Gen 6.0 eBusiness > > >Oracle 8i > > > > > >Greg Nesheim > > >Customer Loyalty Solutions Development Manager > > >Unisys Global Transportation > > >3199 Pilot Knob Road > > >MS: F3M09 > > >Eagan MN 55121 USA > > >Phone: (651) 687-3052 > > >Fax: (651) 687-2368 > > >Email: Greg.Nesheim@Unisys.com > > > <> __________________________________________________ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com ------------------------------ Date: 3 May 2002 09:02:01 -0000 From: "Sachin" Subject: Re: HTTPServletRequest {02} Guys, To explain the problem in more detail. We have a Servlet created by WCE genereted HTMLs. Now any servlet basically communicates on two parameters. One request, which is of type HTTPServletRequest and this basically requests information from the Servlet about the server (the browser in this case). The information like Ip address, cookies stored on the browser machine etc. Other response, which is of type HTTPServletResponse. This basically sends the response from the servlet. Therefore it is require if you want to 'write' or 'set# something on the server(again the browser in this case). Now to write a cookie you require this parameter from the servlet. Cool:Gen Java generated external action block provided only the request id in parameter2 of the EAB. But we require the response id to write cookies on the browser. So what we want is either some method in Java which will give us this response id or the way Cool:Gen provides us this id. Has anyone used cookies in WCE before? Any help is appreciated... Sachin On Fri, 03 May 2002 Carter, John wrote : >I believe that the HttpServletRequest is a Java class, not one >that CA has written. The e-books mentions writing an external >action block in order to get access to this class. It also >mentions looking at the J2EE documentation for the supported >methods. > >-----Original Message----- > From: Peter Rints [mailto:peter@rints.co.uk] >Sent: Thursday, May 02, 2002 11:40 AM >To: COOLGEN List Member >Subject: [COOLGEN] HTTPServletRequest {01} > > >Guys > >Is anyone out there using HttpServletRequest to read from Cookies >for 6.0e Web-enabled applications, and if so has anyone managed >to use HttpServletResponse to write the data in the first >place!! > > >We have managed to read information from a Cookie, but it does >not appear that creating and writing them is supported!!! I >cannot beleive this is not possible, as it would make the read >Cookie redundant which is in the E-Books..... > >Anyone got the answer or a workaround? > >Pete > > > >----- Original Message ----- > From: Lee Bobbitt >To: COOLGEN List Member >Sent: Wednesday, May 01, 2002 5:53 PM >Subject: [COOLGEN] Event execution {02} > > >Uh oh, my name taken in vain... ;-) > >Bring up the Environment Properties for your Business System. >Click the button labeled "MVS Parms". You'll see that there is a >check box with the label "XCTL for Flows When Possible (CICS)". >(We always generate our code with this option on.) > >In typical Cool:Gen fashion, you will not find a single "EXEC >CICS" block in your generated source -- Cool:Gen hides those >details in their run-time libs. In our Dialog Manager and Screen >source members, there is a variable called "CICS-XCTL-SW" with >the value set to "Y". This gets passed to the "TIRMSG" module. > >Sorry, I know this doesn't completely answer your question. >Re-generate your code with the "XCTL for Flows.." option on. >Trace in CEDF and see what happens -- you should see XCTL being >used. Someone please correct me if I'm wrong. > >Cheers, >Lee > > > > > > > "Anand M" >Sent by: DDoyle@duick.com > > >05/01/2002 10:41 AM >Please respond to coolgen > > > > To: "COOLGEN List Member" > cc: coolgen@duick.com, (bcc: Lee >Bobbitt/MIS/DAS/MODNR) > Subject: [COOLGEN] Event execution {01} > > > >To settle an argument... >Does NEXTTRAN translate in a CICS environment to >a) XCTL (Lee Bobbitt posted a mail to this effect sometime >back) >b) RETURN (tranid) where tranid is the next transaction >c) START > >Someone at work claims that he saw in CEDF that the NEXTTRAN >was >converted to a RETURN (tranid). > >Whatever it is, in CICS, is the RETRIEVE command to be used for >getting >the Clear screen data that is part of the SET NEXTTRAN >statement? > >Thanks >Anand > > >__________________________________________________ >Do You Yahoo!? >Yahoo! Health - your guide to health and wellness >http://health.yahoo.com >--COOLGen-List------------------------------------------------------------- >Subscribe: email coolgen-subscribe@duick.com >Unsubscribe: email coolgen-unsubscribe@duick.com >List Home Page: http://www.duick.com/coolgen/ >List Archive: http://www.duick.com/cgi-bin/search/search.pl >--------------------------------------------------------------------------- > > > > > _________________________________________________________ Click below to visit monsterindia.com and review jobs in India or Abroad http://monsterindia.rediff.com/jobs ------------------------------ Date: Fri, 3 May 2002 18:07:20 +0200 From: "Armin Sterk" Subject: RE: HTTPServletRequest {03} Sachin, Peter, You are correct. The response object is created in the CG runtime and the handle is not available. As a workaround you can pass the desired cookievalue through a hidden field on the screen, create an HTML object in the windows designer with javascript to read the value of the hidden field and put it in an cookie. Armin -----Original Message----- From: DDoyle@duick.com [mailto:DDoyle@duick.com] On Behalf Of Sachin Sent: vrijdag 3 mei 2002 11:02 To: COOLGEN List Member Subject: [COOLGEN] HTTPServletRequest {03} Guys, To explain the problem in more detail. We have a Servlet created by WCE genereted HTMLs. Now any servlet basically communicates on two parameters. One request, which is of type HTTPServletRequest and this basically requests information from the Servlet about the server (the browser in this case). The information like Ip address, cookies stored on the browser machine etc. Other response, which is of type HTTPServletResponse. This basically sends the response from the servlet. Therefore it is require if you want to 'write' or 'set# something on the server(again the browser in this case). Now to write a cookie you require this parameter from the servlet. Cool:Gen Java generated external action block provided only the request id in parameter2 of the EAB. But we require the response id to write cookies on the browser. So what we want is either some method in Java which will give us this response id or the way Cool:Gen provides us this id. Has anyone used cookies in WCE before? Any help is appreciated... Sachin On Fri, 03 May 2002 Carter, John wrote : >I believe that the HttpServletRequest is a Java class, not one >that CA has written. The e-books mentions writing an external >action block in order to get access to this class. It also >mentions looking at the J2EE documentation for the supported >methods. > >-----Original Message----- > From: Peter Rints [mailto:peter@rints.co.uk] >Sent: Thursday, May 02, 2002 11:40 AM >To: COOLGEN List Member >Subject: [COOLGEN] HTTPServletRequest {01} > > >Guys > >Is anyone out there using HttpServletRequest to read from Cookies >for 6.0e Web-enabled applications, and if so has anyone managed >to use HttpServletResponse to write the data in the first >place!! > > >We have managed to read information from a Cookie, but it does >not appear that creating and writing them is supported!!! I >cannot beleive this is not possible, as it would make the read >Cookie redundant which is in the E-Books..... > >Anyone got the answer or a workaround? > >Pete > > > >----- Original Message ----- > From: Lee Bobbitt >To: COOLGEN List Member >Sent: Wednesday, May 01, 2002 5:53 PM >Subject: [COOLGEN] Event execution {02} > > >Uh oh, my name taken in vain... ;-) > >Bring up the Environment Properties for your Business System. >Click the button labeled "MVS Parms". You'll see that there is a >check box with the label "XCTL for Flows When Possible (CICS)". >(We always generate our code with this option on.) > >In typical Cool:Gen fashion, you will not find a single "EXEC >CICS" block in your generated source -- Cool:Gen hides those >details in their run-time libs. In our Dialog Manager and Screen >source members, there is a variable called "CICS-XCTL-SW" with >the value set to "Y". This gets passed to the "TIRMSG" module. > >Sorry, I know this doesn't completely answer your question. >Re-generate your code with the "XCTL for Flows.." option on. >Trace in CEDF and see what happens -- you should see XCTL being >used. Someone please correct me if I'm wrong. > >Cheers, >Lee > > > > > > > "Anand M" >Sent by: DDoyle@duick.com > > >05/01/2002 10:41 AM >Please respond to coolgen > > > > To: "COOLGEN List Member" > cc: coolgen@duick.com, (bcc: Lee >Bobbitt/MIS/DAS/MODNR) > Subject: [COOLGEN] Event execution {01} > > > >To settle an argument... >Does NEXTTRAN translate in a CICS environment to >a) XCTL (Lee Bobbitt posted a mail to this effect sometime >back) >b) RETURN (tranid) where tranid is the next transaction >c) START > >Someone at work claims that he saw in CEDF that the NEXTTRAN >was >converted to a RETURN (tranid). > >Whatever it is, in CICS, is the RETRIEVE command to be used for >getting >the Clear screen data that is part of the SET NEXTTRAN >statement? > >Thanks >Anand > > >__________________________________________________ >Do You Yahoo!? >Yahoo! Health - your guide to health and wellness >http://health.yahoo.com >--COOLGen-List--------------------------------------------------------- >---- >Subscribe: email coolgen-subscribe@duick.com >Unsubscribe: email coolgen-unsubscribe@duick.com >List Home Page: http://www.duick.com/coolgen/ >List Archive: http://www.duick.com/cgi-bin/search/search.pl >----------------------------------------------------------------------- ---- > > > > > _________________________________________________________ Click below to visit monsterindia.com and review jobs in India or Abroad http://monsterindia.rediff.com/jobs --COOLGen-List---------------------------------------------------------- --- Subscribe: email coolgen-subscribe@duick.com Unsubscribe: email coolgen-unsubscribe@duick.com List Home Page: http://www.duick.com/coolgen/ List Archive: http://www.duick.com/cgi-bin/search/search.pl ------------------------------------------------------------------------ --- ------------------------------ Date: Fri, 03 May 2002 12:18:57 -0400 From: "John Miles" Subject: contractor pay I'd like the opinion of all the COOL:Gen contractors out there. I was a perm hire using CG for almost 3 years and am looking into taking a contracting position but don't know what hourly rate I should be asking for. That perm hire job was my first out of college and all my work has been mainframe batch and online - I'd be doing the same stuff for the contract work as well. It would be a W-2 position w/ straight-time overtime and no relocation assistance. Feel free to reply to me off the mailing list - I guarantee discretion. Thanks for your help. John _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com ------------------------------ Date: Fri, 3 May 2002 11:39:23 -0500 (CDT) From: "David K. Bond" Subject: Re: contractor pay {01} You didn't leave an email address for the purposes of sending responses to your learned query. David Bond > I'd like the opinion of all the COOL:Gen contractors out there. I was > a perm hire using CG for almost 3 years and am looking into taking a > contracting position but don't know what hourly rate I should be asking > for. > That perm hire job was my first out of college and all my work has > been > mainframe batch and online - I'd be doing the same stuff for the > contract work as well. It would be a W-2 position w/ straight-time > overtime and no relocation assistance. > > Feel free to reply to me off the mailing list - I guarantee discretion. > Thanks for your help. > > John > > _________________________________________________________________ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > --COOLGen-List------------------------------------------------------------ - > Subscribe: email coolgen-subscribe@duick.com > Unsubscribe: email coolgen-unsubscribe@duick.com > List Home Page: http://www.duick.com/coolgen/ > List Archive: http://www.duick.com/cgi-bin/search/search.pl > -------------------------------------------------------------------------- - ------------------------------ Date: Fri, 3 May 2002 12:11:36 -0500 From: Subject: RE: contractor pay {02} David. the list server forward the email with the email address... It is john_r_miles@hotmail.com... -----Original Message----- From: DDoyle@duick.com [mailto:DDoyle@duick.com]On Behalf Of David K. Bond Sent: Friday, May 03, 2002 11:39 AM To: COOLGEN List Member Subject: [COOLGEN] contractor pay {02} You didn't leave an email address for the purposes of sending responses to your learned query. David Bond > I'd like the opinion of all the COOL:Gen contractors out there. I was > a perm hire using CG for almost 3 years and am looking into taking a > contracting position but don't know what hourly rate I should be asking > for. > That perm hire job was my first out of college and all my work has > been > mainframe batch and online - I'd be doing the same stuff for the > contract work as well. It would be a W-2 position w/ straight-time > overtime and no relocation assistance. > > Feel free to reply to me off the mailing list - I guarantee discretion. > Thanks for your help. > > John > > _________________________________________________________________ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > --COOLGen-List------------------------------------------------------------ - > Subscribe: email coolgen-subscribe@duick.com > Unsubscribe: email coolgen-unsubscribe@duick.com > List Home Page: http://www.duick.com/coolgen/ > List Archive: http://www.duick.com/cgi-bin/search/search.pl > -------------------------------------------------------------------------- - --COOLGen-List------------------------------------------------------------- Subscribe: email coolgen-subscribe@duick.com Unsubscribe: email coolgen-unsubscribe@duick.com List Home Page: http://www.duick.com/coolgen/ List Archive: http://www.duick.com/cgi-bin/search/search.pl --------------------------------------------------------------------------- ------------------------------ End coolgen@duick.com Digest [05/03/2002 21:01] -----------------------------------------------