DisplayURL=/jsp/display.jsp DisplayURL.formHandlerName=DisplayURLFORM DisplayURL.transformType=jsp request.DisplayURL.transform.className=com.ai.jsp.JSPTransform request.DisplayURLFORM.form_handler.class_request.className=com.ai.htmlgen.DBHashTableFormHandler1 request.DisplayURLFORM.mainDataRequest.className=com.ai.db.DBPreTranslateArgsMultiRequestExecutor request.DisplayURLFORM.mainDataRequest.db=testDB request.DisplayURLFORM.mainDataRequest.query_type=select request.DisplayURLFORM.mainDataRequest.request.1=getdeltab2 request.DisplayURLFORM.mainDataRequest.request.2=getbilltab2 request.getdeltab2.className=com.ai.db.DBRequestExecutor2 request.getdeltab2.query_type=select request.getdeltab2.stmt= \ SELECT Order_id as idD, \ C_name as NameD, \ Street as StD, \ City as CiD, \ State as StaD, \ Country as CouD, \ Zip as ZipD, \ Phone as PhD, \ Mobile as MobD, \ Email as EmD \ from order_del \ where Order_id={ordid} request.getbilltab2.className=com.ai.db.DBRequestExecutor2 request.getbilltab2.query_type=select request.getbilltab2.stmt= \ SELECT Order_id as idB, C_name as NameB, \ Street as StB, \ City as CiB, \ State as StaB, \ Country as CouB, \ Zip as ZipB, \ Phone as PhB, \ Mobile as MobB, \ Email as EmB \ from order_bill \ where Order_id={ordid} DisplayURLFORM.loopNames=cartdetailsloop2 #request.DisplayURLFORM.cartdetailsloop2.class_request.className=com.ai.htmlgen.RandomTableHandler7 request.DisplayURLFORM.cartdetailsloop2.class_request.className=com.ai.htmlgen.GenericTableHandler6 request.DisplayURLFORM.cartdetailsloop2.query_request.className=com.ai.db.DBRequestExecutor2 request.DisplayURLFORM.cartdetailsloop2.query_request.db=testDB request.DisplayURLFORM.cartdetailsloop2.query_request.stmt= \ SELECT product_id,pname,user_id,\ qty,size,color \ from basket \ where user_id = {useid1} ######Mailing from the JSP file######## request.DisplayURLFORM.classname=com.ai.db.DBPreTranslateArgsMultiRequestExecutor request.DisplayURLFORM.db=testDB request.DisplayURLFORM.query_type=select ## Start the pipeline request.DisplayURLFORM.request.1=GetFromToSubject request.DisplayURLFORM.request.2=FinalSendMail request.DisplayURLFORM.request.3=GetBodyText ## One possible way to get the from, to, and subject fields ## Or you could pass them from your input request directly ## request.GetFromToSubject.classname=com.ai.db.DBRequestExecutor2 request.GetFromToSubject.db=testDB request.GetFromToSubject.stmt= \ select toadd as toa, fromadd as froma,sub as suba \ from usertable1 where useid = {useid1} ##Expected inputs ##from, to, subject, bodyText request.FinalSendMail.classname=com.ai.aspire.utils.MailRequestExecutor request.FinalSendMail.smtpMailHost=smtp.eth.net request.FinalSendMail.user=itsolutions request.FinalSendMail.password=itpassw #http://localhost:8080/itsolutions/display?url=DisplayURL&ordid=465&useid1=43534563 # USing the URLStringReader to retrieve a url as a string # request.GetBodyText.classname=com.ai.parts.URLStringReaderPart request.GetBodyText.URL=/itsolutions/display?url=DisplayURL&ordid={ordid}&useid1={useid1} request.GetBodyText.resultName=bodyText
>> Tuesday, October 05, 2004 10:45:12 AM - Comments by satya
First thing you can do is break your select statements for a better read using the new line continuation character
>> Tuesday, October 05, 2004 10:54:15 AM - Comments by satya
Also see how DisplayURLFORM is reused. Try to use a diffrent name for the mail request. Try "SendJSPAsEmailRequest" for the second one.
First thing to try is to get your JSP page working with out thinking about email. Let me know if you are able to get this working