Forum Moderators: phranque

Message Too Old, No Replies

ColdFusion, Using Access DB

         

sheri_ziba

10:40 pm on Jan 16, 2004 (gmt 0)



Let me start the questions from the beginning and make it more clear. I need to create Project_No and Just_Detail. Project_No should have 3 parts(4SE-123”yr,dept,autonum”)Both of these fields do not appear in the submittal form(they are not submitted by submitter), but they will be in the editform and the search page. Just_Detail field is created by this code(I have to mention that this code was working in another application when I was using a preexisting project_No meaning project_no was inputed by submitter)
<CFOUTPUT>
<cfset Just_Detail=#Form.Project_No# & ".doc">
</CFOUTPUT>
and Just_Detail has a link to a word document form for each project number. For example in the search page next to project number there are 2 options view and edit. View is linked to printform and edit is linked to editform. There should be 2 options next to Just_Link too. One should be linked to premade(by submitter) detailed justification word dodument for that project number, and the second one should be linked to a blank form if the submitter of that project wants to fill out the detailed justification afterward.
Project Number : 12345 View Only Edit Only
Justification Detail: 12345.doc CreateOnly View/Edit Only
I used this code(in other application with preexisting projecy_no) to retrieve a preexisting Just_detail or the blank form, it was not working to get a blank form.
<CFIF #Just_Detail# is not "">
<AHREF="http://wheng1/ES_Capital/general_tech/proposal/Search/Justifications/#Just_Detail#"> <big><b>Justification Detail (View)</big> <font color="red"> </A> </b></font><p>
<CFELSEIF #Just_Detail# is "">
<AHREF="http://wheng1/ES_Capital/general_tech/proposal/Search/BlankJustificationForm/#BlankForm#"> <big><b>Justification Detail (Create)</big> <font color="red"> </A> </b></font><p>
</CFIF>

By having this information would you please tell me what my steps should be to start on creating and making both of them work properly.