Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About animockery

  • Rank
  • Birthday 01/31/1984

Profile Information

  • Location
  1. OK, I got it! Thank you a ton that was much easier than I thought it would be.
  2. So to get the return, or the output that will be referenced into the email body I need to do a replace? I do not think I am familiar with how to do this but I would like to learn how. Can I get an example of how this would look if I want the line breaks inserted by the user to hold true in an email?
  3. There a great deal of conditions added in to some parts but the basics of the script are below; -JavaScript- To= document.myform.Approvermail.value ;Subject="SQL Access Request";BHeader= "**"+document.myform.Approvername.value+", Please approve this request and reply to all.**"Body= "Server Name - "+document.myform.Servername.value+ "";Body2= "Database Name - "+document.myform.Databasename.value+ "";Body3= "Access Groups:";Body3a= document.myform.Accessgroups1.value ;Body3b= document.myform.Accessgroups2.value ;Body3c= document.myform.Accessgroups3.value ;Body3d= document.myform.Accessgroups4.value ;Body3e= document.myform.Accessgroups5.value ;Body3a1= ""+al1Aval+""+al1Bval+""+al1Dval+""+al1Eval+""+al1Gval+""+al1GRval+""+al1Ival+""+al1Lval+""+al1Sval+""+al1Tval+""+al1Uval+" ";Body3b2= ""+al2Aval+""+al2Bval+""+al2Dval+""+al2Eval+""+al2Gval+""+al2GRval+""+al2Ival+""+al2Lval+""+al2Sval+""+al2Tval+""+al2Uval+" ";Body3c3= ""+al3Aval+""+al3Bval+""+al3Dval+""+al3Eval+""+al3Gval+""+al3GRval+""+al3Ival+""+al3Lval+""+al3Sval+""+al3Tval+""+al3Uval+" ";Body3d4= ""+al4Aval+""+al4Bval+""+al4Dval+""+al4Eval+""+al4Gval+""+al4GRval+""+al4Ival+""+al4Lval+""+al4Sval+""+al4Tval+""+al4Uval+" ";Body3e5= ""+al5Aval+""+al5Bval+""+al5Dval+""+al5Eval+""+al5Gval+""+al5GRval+""+al5Ival+""+al5Lval+""+al5Sval+""+al5Tval+""+al5Uval+" ";Body3a1x= ng1val ;Body3b2x= ng2val ;Body3c3x= ng3val ;Body3d4x= ng4val ;Body3e5x= ng5val ;Body4= document.myform.tables.value ; location = "mailto:"+To+"?CC=email@example.com?subject="+Subject+"&Body="+BHeader+"%0d%0A%0d%0A"+Body+"%0d%0A%0d%0A"+Body2+"%0d%0A%0d%0A"+Body3+"%0d%0A Group= "+Body3a+" Access= "+Body3a1+" "+Body3a1x+"%0d%0A Group= "+Body3b+" Access= "+Body3b2+" "+Body3b2x+"%0d%0A Group= "+Body3c+" Access= "+Body3c3+" "+Body3c3x+"%0d%0A Group= "+Body3d+" Access= "+Body3d4+" "+Body3d4x+"%0d%0A Group= "+Body3e+" Access= "+Body3e5+" "+Body3e5x+"%0d%0A%0d%0A Owner/Tables= "+Body4+" ";} -Form- <FORM onclick="" name=myform NewEmail(myForm) return> <P align=left><B>Approving Manager/Supervisor Name:*</B> <BR><INPUT style="WIDTH: 280px" type=email name=Approvername> </P><P align=left><B>Approving Manager/Supervisor Email:*</B> <BR><INPUT style="WIDTH: 280px" name=Approvermail> </P><P align=left><B>Server name:*</B> <BR><INPUT style="WIDTH: 280px" name=Servername> </P><P align=left><B>Database name:</B>* <BR><INPUT style="WIDTH: 280px" name=Databasename> </P> <P><br /><b>Access Permission(s):</b><br /> <fieldset Style="width: 15%"><b>Netezza Group:</b><INPUT style="WIDTH: 110px" name=Accessgroups1><u>New Group?</u><input type="checkbox" title="New Group" name="ng1"><p> <input type="checkbox" name="al1A" value="Abort, ">Abort<br /> <input type="checkbox" name="al1B" value="Alter, ">Alter<br /> <input type="checkbox" name="al1D" value="Delete, ">Delete<br /> <input type="checkbox" name="al1E" value="Execute, ">Execute<br /> <input type="checkbox" name="al1G" value="Gen Stats, ">Gen Stats<br /> <input type="checkbox" name="al1GR" value="Groom, ">Groom<br /> <input type="checkbox" name="al1I" value="Insert, ">Insert<br /> <input type="checkbox" name="al1L" value="List, ">List<br /> <input type="checkbox" name="al1S" value="Select, ">Select<br /> <input type="checkbox" name="al1T" value="Truncate, ">Truncate<br /> <input type="checkbox" name="al1U" value="Update, ">Update<br /> </p> </fieldset> <fieldset Style="width: 15%"><b>Netezza Group:</b><INPUT style="WIDTH: 110px" name=Accessgroups2><u>New Group?</u><input type="checkbox" title="New Group" name="ng2"><p> <input type="checkbox" name="al2A" value="Abort, ">Abort<br /> <input type="checkbox" name="al2B" value="Alter, ">Alter<br /> <input type="checkbox" name="al2D" value="Delete, ">Delete<br /> <input type="checkbox" name="al2E" value="Execute, ">Execute<br /> <input type="checkbox" name="al2G" value="Gen Stats, ">Gen Stats<br /> <input type="checkbox" name="al2GR" value="Groom, ">Groom<br /> <input type="checkbox" name="al2I" value="Insert, ">Insert<br /> <input type="checkbox" name="al2L" value="List, ">List<br /> <input type="checkbox" name="al2S" value="Select, ">Select<br /> <input type="checkbox" name="al2T" value="Truncate, ">Truncate<br /> <input type="checkbox" name="al2U" value="Update, ">Update<br /> </p> </fieldset> <fieldset Style="width: 15%"><b>Netezza Group:</b><INPUT style="WIDTH: 115px" name=Accessgroups3><u>New Group?</u><input type="checkbox" title="New Group" name="ng3"><p> <input type="checkbox" name="al3A" value="Abort, ">Abort<br /> <input type="checkbox" name="al3B" value="Alter, ">Alter<br /> <input type="checkbox" name="al3D" value="Delete, ">Delete<br /> <input type="checkbox" name="al3E" value="Execute, ">Execute<br /> <input type="checkbox" name="al3G" value="Gen Stats, ">Gen Stats<br /> <input type="checkbox" name="al3GR" value="Groom, ">Groom<br /> <input type="checkbox" name="al3I" value="Insert, ">Insert<br /> <input type="checkbox" name="al3L" value="List, ">List<br /> <input type="checkbox" name="al3S" value="Select, ">Select<br /> <input type="checkbox" name="al3T" value="Truncate, ">Truncate<br /> <input type="checkbox" name="al3U" value="Update, ">Update<br /> </p></fieldset> <fieldset Style="width: 15%"><b>Netezza Group:</b><INPUT style="WIDTH: 115px" name=Accessgroups4><u>New Group?</u><input type="checkbox" title="New Group" name="ng4"><p> <input type="checkbox" name="al4A" value="Abort, ">Abort<br /> <input type="checkbox" name="al4B" value="Alter, ">Alter<br /> <input type="checkbox" name="al4D" value="Delete, ">Delete<br /> <input type="checkbox" name="al4E" value="Execute, ">Execute<br /> <input type="checkbox" name="al4G" value="Gen Stats, ">Gen Stats<br /> <input type="checkbox" name="al4GR" value="Groom, ">Groom<br /> <input type="checkbox" name="al4I" value="Insert, ">Insert<br /> <input type="checkbox" name="al4L" value="List, ">List<br /> <input type="checkbox" name="al4S" value="Select, ">Select<br /> <input type="checkbox" name="al4T" value="Truncate, ">Truncate<br /> <input type="checkbox" name="al4U" value="Update, ">Update<br /> </p></fieldset> <fieldset Style="width: 15%"><b>Netezza Group:</b><INPUT style="WIDTH: 115px" name=Accessgroups5><u>New Group?</u><input type="checkbox" title="New Group" name="ng5"><p> <input type="checkbox" name="al5A" value="Abort, ">Abort<br /> <input type="checkbox" name="al5B" value="Alter, ">Alter<br /> <input type="checkbox" name="al5D" value="Delete, ">Delete<br /> <input type="checkbox" name="al5E" value="Execute, ">Execute<br /> <input type="checkbox" name="al5G" value="Gen Stats, ">Gen Stats<br /> <input type="checkbox" name="al5GR" value="Groom, ">Groom<br /> <input type="checkbox" name="al5I" value="Insert, ">Insert<br /> <input type="checkbox" name="al5L" value="List, ">List<br /> <input type="checkbox" name="al5S" value="Select, ">Select<br /> <input type="checkbox" name="al5T" value="Truncate, ">Truncate<br /> <input type="checkbox" name="al5U" value="Update, ">Update<br /> </p></fieldset></p><br /><p><b>Owner/Table(s):*</><br /><textarea id="tables" name="tables" rows="10" style="width: 600px" ></textarea><br /> </p><br /><br /> <INPUT id=sub onclick="location.href='javascript:SQLEmail()'" value=Submit type=button> <span> <input type="reset"> </FORM> The only thing I cannot get is the text area to stay in the format entered by the user.
  4. I am creating a form that is captured and placed in an email. I have managed to do this fine with the exception of one item. when getting the value of a text area it will not maintain the user entered format. Thsi will be important when recieving the information in the email. what I need is this, when a user enters the below info in a textarea;---example---Reference line 1Reference line 2Reference line 3Reference line 4----------------- I need it to popluate in the email the same way. When I pull this infor like a normal input it comes out like this; Reference line 1Reference line 2Reference line 3Reference line 4 can anyone help? I am not able to use PHP in my environment I am working with, as I understand it now. I also do not know much about asp.net
  5. OK so I put the onchange in my select but I am not sure how I check the value of the selected option. <select name="Accesslevel1" onChange="DbRole(Accesslevel1.value);"> the if condition should only be when "Database Role" is selected. I also am not sure if I did the "addfeilds()" part right.
  6. OK, I have hit a snag and I want to try and make this work if I can. I am trying to add a new text field next to a current list field based on a single selected item. can anyone help me on this? I added the segments that I want this to change. *script* function DbRole(myform){if (document.myform.Accesslevel1.value=="Database Role = "){document.myform.Accesslevel1("DbRole1").setValue(""); AddFields();}} *form* <input name="Accessgroups1" type="text" size="50"> <select name="Accesslevel1"> <option value=""></option> <option value="Read">Read</option> <option value="Write">Write</option> <option value="Read/Write">Read/Write</option> <option value="Update">Update (accounting)</option> <option value="Delete">Delete (Accounting)</option> <option value="Update/Delete (Accounting)">Update/Delete (Accounting)</option> <option onChange="DbRole()" value="Database Role = ">-Database Role-</option> (**the idea is that when this last item is selected a text field will appear next to this list field**) </select> Any help would be appreciated, I am new to this but I have already managed to set up other js that works but this one escapes me at this moment.
  • Create New...