5-Oct-04 (Created: 5-Oct-04) | More in 'Questions'

General Questions from Sanjays team

What is wrong with this code?

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