Pure ASP Upload 2 Support Product Page

This topic is locked
This topic was archived

Various errors since adding PAU3 & HTML Editor 2

Reported 27 Mar 2007 12:26:12
1
has this problem
27 Mar 2007 12:26:12 Mike McEachern posted:
Hello there.

I was initially impressed by the features when I was messing around with adding adv html editor to my existing forms and adding PAU to them but that wore off quickly. I am hopeful that this will be a user error, but can you please give me a hand?

Basically I am trying to retro-fit some UPDATE pages with PAU and adv html editor. I am getting all kinds of weird behaviour now. I am getting a Recordset.htm error on opening my forms now. Also, all my recordsets have been renamed from 'Recordset1' to 'Recordset1_cmd' - which is fine, you know, whatever, but in the SERVER BEHAVIOURS tab the recordsets have disappeared. Now the form page will not update my database, plus any dynamic text referring to 'Recordset1' have red !s by them. The upload feature seems to work uploading files, but not adding a record to the db - what is going on here?

Let me know if you'd like to view my code. Kind of urgent to get this working.

Cheers!

Replies

Replied 27 Mar 2007 16:09:09
27 Mar 2007 16:09:09 Georgi Kralev replied:
Hi Mike,

If you provide your code will be quite helpful. Because, right now it is not very clear what is the problem.

Regards,

Georgi Kralev

----------------------------------
Support - www.DMXzone.com
Replied 27 Mar 2007 16:11:29
27 Mar 2007 16:11:29 Mike McEachern replied:
Hello, thanks for the reply. Here's a massive page full of code to peruse. As you can see, the recordset is there, but doesn't seem to be working properly with the new adv html editor and PAU:

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/DSRNMIX.asp" -->
<!--#include file="ScriptLibrary/incPU3Class.asp" -->
<!--#include file="ScriptLibrary/incPU3Utils.asp" -->
<%
//*** Pure ASP File Upload 3.0.8
// Process form MtgForm
var pau = CreatePureUpload(), DMX_uploadAction, UploadRequest, UploadQueryString, pau_thePath, pau_nameConflict, pau_saveWidth, pau_saveHeight;
pau.ScriptLibrary = "ScriptLibrary";
pau.TimeOut = 60;
pau.ConflictHandling = "over";
pau.StoreType = "file";
pau.ProgressTemplate = "circle.htm";
pau.ProgressWidth = 500;
pau.ProgressHeight = 150;
pau.UploadFolder = "\"UploadedFiles\"";
var uploadPBAttachments = pau.AddField("PBAttachments";
uploadPBAttachments.UploadFolder = "\"UploadedFiles\"";
pau.ProcessUpload();
pau.SaveAll();
if (pau.Done) {
SetUploadFormRequest("upload_org_PBAttachments",pau.Fields("upload_org_PBAttachments".Value);
}
if (pau.Done) Response.Redirect("MainDetail.asp";
%>
<%
// *** Edit Operations: (Modified for File Upload) declare variables

// set the form action variable
var MM_editAction = Request.ServerVariables("SCRIPT_NAME";
if (UploadQueryString) {
MM_editAction += "?" + Server.HTMLEncode(UploadQueryString);
}

// boolean to abort record edit
var MM_abortEdit = false;
%>
<%
if (String(UploadFormRequest("MM_update") == "MtgForm" {
if (!MM_abortEdit) {
// execute the update

var MM_editCmd = Server.CreateObject ("ADODB.Command";
MM_editCmd.ActiveConnection = MM_DSRNMIX_STRING;
MM_editCmd.CommandText = "UPDATE dbo.NMXAllpubs SET PBAttachments = ?, PBAttachmentComments = ?, PBType = ?, PBStudyID = ?, PBTitle = ?, PBAuthors = ?, PBReference = ?, PBAbstractWeb = ?, PBCountry = ?, TrialDesign = ?, PBProduct = ?, PBStatus = ?, ManuscriptStatus = ?, PBTargetJnl = ?, PBCongressPresented = ?, PBFirstPresentation = ?, WebEPs = ?, PBDSCats = ?, PBRank = ?, PBKM1 = ?, PBKM2 = ?, PBKM3 = ?, PBKM4 = ?, PBKMNot = ?, PBReportDate = ?, PBSubmissionDate = ?, PBPubDate = ?, PBPriority = ?, PBNNContact = ?, PBAction = ?, PBDSStatus = ?, PBStatusSummaryList = ?, PBPubList = ?, PBUSDriven = ? WHERE docNum = ?";
MM_editCmd.Prepared = true;
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param1", 201, 1, 8000, MM_IIF(UploadFormRequest("PBAttachments", UploadFormRequest("PBAttachments", UploadFormRequest("upload_org_PBAttachments"))); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param2", 201, 1, 8000, UploadFormRequest("PBAttachmentComments")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param3", 201, 1, 8000, UploadFormRequest("PBType")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param4", 201, 1, 8000, UploadFormRequest("PBStudyID")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param5", 201, 1, 8000, UploadFormRequest("PBTitle")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param6", 201, 1, 8000, UploadFormRequest("PBAuthors")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param7", 201, 1, 8000, UploadFormRequest("PBReference")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param8", 201, 1, 8000, UploadFormRequest("PBAbstractWeb")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param9", 201, 1, 8000, UploadFormRequest("PBCountry")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param10", 201, 1, 8000, UploadFormRequest("TrialDesign")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param11", 201, 1, 8000, UploadFormRequest("PBProduct")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param12", 201, 1, 8000, UploadFormRequest("PBStatus")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param13", 201, 1, 8000, UploadFormRequest("ManuscriptStatus")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param14", 201, 1, 8000, UploadFormRequest("PBTargetJnl")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param15", 201, 1, 8000, UploadFormRequest("PBCongressPresented")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param16", 201, 1, 8000, UploadFormRequest("PBFirstPresentation")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param17", 201, 1, 8000, UploadFormRequest("WebEPs")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param18", 201, 1, 8000, UploadFormRequest("PBDSCats")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param19", 5, 1, -1, (String(UploadFormRequest("PBRank") != "undefined" && String(UploadFormRequest("PBRank") != "" ? UploadFormRequest("PBRank" : null)); // adDouble
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param20", 201, 1, 8000, (String(UploadFormRequest("PBKM1") != "undefined" && String(UploadFormRequest("PBKM1") != "" ? "Y" : "N"); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param21", 201, 1, 8000, (String(UploadFormRequest("PBKM2") != "undefined" && String(UploadFormRequest("PBKM2") != "" ? "Y" : "N"); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param22", 201, 1, 8000, (String(UploadFormRequest("PBKM3") != "undefined" && String(UploadFormRequest("PBKM3") != "" ? "Y" : "N"); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param23", 201, 1, 8000, (String(UploadFormRequest("PBKM4") != "undefined" && String(UploadFormRequest("PBKM4") != "" ? "Y" : "N"); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param24", 201, 1, 8000, (String(UploadFormRequest("PBKMNot") != "undefined" && String(UploadFormRequest("PBKMNot") != "" ? "Y" : "N"); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param25", 201, 1, 8000, UploadFormRequest("PBReportDate")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param26", 201, 1, 8000, UploadFormRequest("PBSubmissionDate")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param27", 201, 1, 8000, UploadFormRequest("PBPubDate")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param28", 201, 1, 8000, UploadFormRequest("PBPriority")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param29", 201, 1, 8000, UploadFormRequest("PBNNContact")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param30", 201, 1, 8000, UploadFormRequest("PBAction")); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param31", 201, 1, 8000, (String(UploadFormRequest("PBDSStatus") != "undefined" && String(UploadFormRequest("PBDSStatus") != "" ? "Y" : "N"); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param32", 201, 1, 8000, (String(UploadFormRequest("PBStatusSummaryList") != "undefined" && String(UploadFormRequest("PBStatusSummaryList") != "" ? "Y" : "N"); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param33", 201, 1, 8000, (String(UploadFormRequest("PBPubList") != "undefined" && String(UploadFormRequest("PBPubList") != "" ? "Y" : "N"); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param34", 201, 1, 8000, (String(UploadFormRequest("PBUSDriven") != "undefined" && String(UploadFormRequest("PBUSDriven") != "" ? "Y" : "N"); // adLongVarChar
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param35", 5, 1, -1, (String(UploadFormRequest("MM_recordId") != "undefined" && String(UploadFormRequest("MM_recordId") != "" ? UploadFormRequest("MM_recordId" : null)); // adDouble
MM_editCmd.Execute();
MM_editCmd.ActiveConnection.Close();

// append the query string to the redirect URL
var MM_editRedirectUrl = "MainDetail.asp";
if (MM_editRedirectUrl && UploadQueryString && UploadQueryString.length > 0) {
MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1) ? "?" : "&" + UploadQueryString;
}
Response.Redirect(MM_editRedirectUrl)
}
}
%>
<%
var Recordset1__MMColParam = "1";
if (String(Request.QueryString("docNum") != "undefined" &&
String(Request.QueryString("docNum") != "" {
Recordset1__MMColParam = String(Request.QueryString("docNum");
}
%>
<%
var Recordset1_cmd = Server.CreateObject ("ADODB.Command";
Recordset1_cmd.ActiveConnection = MM_DSRNMIX_STRING;
Recordset1_cmd.CommandText = "SELECT * FROM dbo.NMXAllpubs WHERE docNum = ?";
Recordset1_cmd.Prepared = true;
Recordset1_cmd.Parameters.Append(Recordset1_cmd.CreateParameter("param1", 5, 1, -1, Recordset1__MMColParam)); // adDouble

var Recordset1 = Recordset1_cmd.Execute();
var Recordset1_numRows = 0;
%>
<%
var Recordset2_cmd = Server.CreateObject ("ADODB.Command";
Recordset2_cmd.ActiveConnection = MM_DSRNMIX_STRING;
Recordset2_cmd.CommandText = "SELECT * FROM dbo.MTGAllmeetings ORDER BY MeetingShortTitle ASC";
Recordset2_cmd.Prepared = true;

var Recordset2 = Recordset2_cmd.Execute();
var Recordset2_numRows = 0;
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Upload your changes</title>
<style type="text/css">
<!--
@import url("Lira style sheet.css";
#backG
{
background:url(NovoBar5.jpg) no-repeat scroll top center;
}
/* BEGIN Advanced HTML Editor */
.dmx_btn { width: 22px; height: 22px; border: 1px solid #ECE9D8; margin: 0; padding: 0; background-color: #ECE9D8; }
.dmx_btnOver { width: 22px; height: 22px; border: 1px outset; margin: 0; padding: 0; background-color: #FCF9E8; }
.dmx_btnDown { width: 22px; height: 22px; border: 1px inset; margin: 0; padding: 0; background-color: #FCF9E8; }
.dmx_btnNA { width: 22px; height: 22px; border: 1px solid #ECE9D8; margin: 0; padding: 0; -moz-opacity:0.25; opacity:0.25; filter: alpha(opacity=25);}
.dmx_menuBar { background-color: #ECE9D8; }
/* END Advanced HTML Editor */
-->
</style>
<script language="javascript" type="text/javascript">
function select_date(field) {
var val = document.forms[2].elements[field].value.replace(/-/gi, "/".replace(/ /gi, "";

var args = new Array();
var today = new Date();
args[0] = today.getFullYear();
args[1] = today.getMonth();

if (val != "" {
if (is_valid_date(val)) {
var date1 = new Date(val);
args[0] = date1.getFullYear();
args[1] = date1.getMonth();
}
}

var retValue = open_modal_subwin("\popup_calendar.html", args, 210,230);
if(retValue != null) document.forms[2].elements[field].value = retValue;
}

/* url modal open */
function open_modal_subwin(url, args, win_width, win_height) {
var winFeature = "dialogWidth:"+win_width+"px; dialogHeight:"+win_height+"px; center:yes; help:no; status:no; scroll:yes; resizable:yes";

var retValue = window.showModalDialog(url, args, winFeature);
return retValue;
}

// date check
function is_valid_date(it) {
var dt = it.replace(/-/gi, "/";
dt = dt.replace(/\./gi, "/";
var date1 = new Date(dt);

if (date1.toString() == "NaN" return false;

dt = dt.replace(/:/gi, "/";
dt = dt.replace(/ /gi, "/";

var dt_list = dt.split("/";

var Y = dt_list[0];
var M = make_two_digit(dt_list[1]);
var D = make_two_digit(dt_list[2]);

if (dt_list.length == 3) {
var h = "00";
var m = "00";
var s = "00";
} else {
var h = make_two_digit(dt_list[3]);
var m = make_two_digit(dt_list[4]);
var s = make_two_digit(dt_list[5]);
}

var Y2 = date1.getFullYear();
var M2 = date1.getMonth()+1;
var D2 = date1.getDate();
var h2 = date1.getHours();
var m2 = date1.getMinutes();
var s2 = date1.getSeconds();

M2 = make_two_digit(M2);
D2 = make_two_digit(D2);
h2 = make_two_digit(h2);
m2 = make_two_digit(m2);
s2 = make_two_digit(s2);

if (Y == Y2 && M == M2 && D == D2 && h == h2 && m == m2 && s == s2)
return true;
else
return false;
}

function make_two_digit(x) {
if (x.toString().length == 1) return "0"+x; else return x;
}

/* BEGIN Advanced HTML Editor */
var BaseURL = "";
/* END Advanced HTML Editor */
</script>
<style type="text/css">
<!--

.tooltiptitle{COLOR: #efefef; TEXT-DECORATION: none; CURSOR: Default; font-family: verdana; font-weight: bold; font-size: 8pt}
.tooltipcontent{COLOR: #000000; TEXT-DECORATION: none; CURSOR: Default; font-family: verdana; font-size: 8pt}
#ToolTip{position:absolute; width: 100px; top: 0px; left: 0px; z-index:4; visibility:hidden;}
-->
</style>
<script language = "javascript">
<!--

var ie = document.getElementById ? 1 : 0
var ns = document.layers ? 1 : 0

if(ns){doc = "document."; sty = ""}
if(ie){doc = "document.getElementById('"; sty = "').style"}

var initialize = 0
var Ex, Ey, topColor, subColor, ContentInfo

if(ie){
Ex = "event.x"
Ey = "event.y"

topColor = "#808080"
subColor = "#C0C0C0"
}

if(ns){
Ex = "e.pageX"
Ey = "e.pageY"
window.captureEvents(Event.MOUSEMOVE)
window.onmousemove=overhere

topColor = "#808080"
subColor = "#C0C0C0"
}

function MoveToolTip(layerName, FromTop, FromLeft, e){
if(ie){eval(doc + layerName + sty + ".top = " + (eval(FromTop) + document.body.scrollTop))}
if(ns){eval(doc + layerName + sty + ".top = " + eval(FromTop))}
eval(doc + layerName + sty + ".left = " + (eval(FromLeft) - 215))
}

function ReplaceContent(layerName){

if(ie){document.getElementById(layerName).innerHTML = ContentInfo}

if(ns){

with(document.layers[layerName].document)
{
open();
write(ContentInfo);
close();
}

}

}

function Activate(){initialize=1}
function deActivate(){initialize=0}

function overhere(e){
if(initialize){

MoveToolTip("ToolTip", Ey, Ex, e)
eval(doc + "ToolTip" + sty + ".visibility = 'visible'"
}

else{
MoveToolTip("ToolTip", 0, 0)
eval(doc + "ToolTip" + sty + ".visibility = 'hidden'"
}

}

function EnterContent(layerName, TTitle, TContent){

ContentInfo = '<table border="0" width="200" cellspacing="0" cellpadding="0">'+
'<tr><td width="100%" bgcolor="#000000">'+

'<table border="0" width="100%" cellspacing="1" cellpadding="0">'+
'<tr><td width="100%" bgcolor='+topColor+'>'+

'<table border="0" width="90%" cellspacing="0" cellpadding="0" align="center">'+
'<tr><td width="100%" align="center">'+

'<font class="tooltiptitle"> '+TTitle+'</font>'+

'</td></tr>'+
'</table>'+

'</td></tr>'+

'<tr><td width="100%" bgcolor='+subColor+'>'+

'<table border="0" width="90%" cellpadding="0" cellspacing="1" align="center">'+

'<tr><td width="100%">'+

'<font class="tooltipcontent">'+TContent+'</font>'+

'</td></tr>'+
'</table>'+

'</td></tr>'+
'</table>'+

'</td></tr>'+
'</table>';

ReplaceContent(layerName)
}
//-->
</script>
<script type="text/javascript"><%=pau.generateScriptCode()%></script>
<script src="ScriptLibrary/incPU3.js" type="text/javascript"></script>
<script language="JavaScript" src="ScriptLibrary/AdvHTMLLang.js"></script>
<script language="JavaScript" src="ScriptLibrary/AdvHTMLEdit.js"></script>
</HEAD>
<body style="position:relative" onmousemove="overhere()">
<div id="ToolTip"></div>
<SCRIPT language = "javascript">
<!--
var ie = document.getElementById ? 1 : 0
var ns = document.layers ? 1 : 0
if(ie){
document.write('<style type="text/css">')
document.write('.textfield {font-size:10pt; font-family:arial; color:#808080; font-weight:bold;}\n')
document.write('.hexfield {font-size:10pt; font-family:arial; color:#808080; font-weight:bold;}\n')
document.write('.buttons {border-style: solid; background-color: #808080; border-color: #000000; border-width: 1; color: #FFFFFF; font-size: 10pt; font-family: arial; font-weight: bold;}\n')
document.write('</style>')
}
//--> </SCRIPT>
<body>
<table width="756" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="left"><img src="NMLogo.GIF" /></td>
<td width="543" align="right" valign="bottom"><img src="BullLogo.gif" alt="Bull logo" width="78" height="55" align="right" /></td>
</tr>
</table>
<form ACTION="<%=MM_editAction%>" method="post" enctype="multipart/form-data" name="MtgForm" target="_self" id="MtgForm" onSubmit="<%=pau.submitCode()%>;return document.MM_returnValue">
<table width="756" border="0" align="center" cellpadding="1" cellspacing="1">
<tr valign="baseline">
<td colspan="2" height="20" id="backG" align="right" nowrap class="gw1"></td>
</tr>
<tr>
<td> </td>
<td class="g5lnk" align="right"><div align="left"></div></td>
</tr>
</table>
<table width="756" border="0" align="center" cellpadding="1" cellspacing="0">
<tr valign="baseline">
<td align="right" class="gb9">Add attachments:</td>
<td class="gb2"><input name="PBAttachments" type="file" onchange="<%=uploadPBAttachments.validateCode()%>;return document.MM_returnValue" value="<%= pau.Fields("upload_org_PBAttachments".Value %>" /></td>
<td align="right"><a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Attachment help','Any attachments should be added here.'); Activate();" onMouseout="deActivate()"><img src="helpIcon.jpg" /></a></td>
</tr>
<tr>
<td></td>
<td><hr class="hr1" size="1" /></td>
</tr>
<tr valign="baseline">
<td align="right" class="gb9">Current attachments:</td>
<td class="gb2"><%=(Recordset1.Fields.Item("PBAttachments".Value)%></td>
<td align="right"><a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Attachment help','Any attachments should be added here.'); Activate();" onMouseout="deActivate()"><img src="helpIcon.jpg" /></a></td>
</tr>
<tr>
<td></td>
<td><hr class="hr1" size="1" /></td>
</tr>
<tr valign="baseline">
<td align="right" class="gb9">Attachment comments:</td>
<td class="gb2"><input name="PBAttachmentComments" type="text" class="gb2" id="PBAttachmentComments" value="<%=(Recordset1.Fields.Item("PBAttachmentComments".Value)%>" size="100" /></td>
<td align="right"><a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Attachment comments help','Any attachment comments, including ‘No attachments available’ should be added here. This is important since the user may think we have not uploaded an attachment when really there just isnt’t one available. The field will only be ‘shown’ if it contains text. The field will always show in ‘edit’ mode.'); Activate();" onMouseout="deActivate()"><img src="helpIcon.jpg" /></a></td>
</tr>
<tr>
<td></td>
<td><hr class="hr1" size="1" /></td>
</tr>
<tr valign="baseline">
<td nowrap align="right" class="gb9">Type:</td>
<td class="gb2"><select name="PBType" id="PBType" class="gb2">
<option selected="selected"><%=(Recordset1.Fields.Item("PBType".Value)%></option>
<option>Background reference</option>
<option>Meeting abstract</option>
<option>Primary manuscript</option>
<option>Secondary manuscript</option>
<option>Review article</option>
<option>Proceedings article</option>
<option>Other</option>
</select>
</td>
<td align="right"><a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication type help','Select one of the publications types from the drop down list'); Activate();" onMouseout="deActivate()"><img src="helpIcon.jpg" /></a></td>
</tr>
<tr>
<td></td>
<td><hr class="hr1" size="1" /></td>
</tr>
<tr valign="baseline">
<td nowrap align="right" class="gb9">Study number:</td>
<td class="gb2"><input name="PBStudyID" type="text" class="gb2" id="PBStudyID" value="<%=(Recordset1.Fields.Item("PBStudyID".Value)%>" size="100" /></td>
<td align="right"><a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication study ID help','Enter the Study ID number (aka ‘impact number’ within NN). This is case sensitive so ensure all study publications have identical ID names – this will help with the search function. Generally, the following study terminology is used: For NovoMix: BIAsp 1234, For NovoRapid: ANA 1234, For Levemir: NN304-1234'); Activate();" onMouseout="deActivate()"><img src="helpIcon.jpg" /></a></td>
</tr>
<tr>
<td></td>
<td><hr class="hr1" size="1" /></td>
</tr>
<tr valign="baseline">
<td nowrap align="right" class="gb9">Title:</td>
<td class="gb2"><input name="PBTitle" type="text" class="gb2" id="PBTitle" value="<%=(Recordset1.Fields.Item("PBTitle".Value)%>" size="100" /></td>
<td align="right"><a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication title help','Enter title as per publication; be aware that as the publication progress, the title may change and should thus be updated accordingly.'); Activate();" onMouseout="deActivate()"><img src="helpIcon.jpg" /></a></td>
</tr>
<tr>
<td></td>
<td><hr class="hr1" size="1" /></td>
</tr>
<tr valign="baseline">
<td nowrap align="right" class="gb9">Authors:</td>
<td class="gb2"><input name="PBAuthors" type="text" class="gb2" id="PBAuthors" value="<%=(Recordset1.Fields.Item("PBAuthors".Value)%>" size="100" /></td>
<td align="right"><a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication authors help','Enter authors as author surname followed by initial of first name. Insert comma after each name.'); Activate();" onMouseout="deActivate()"><img src="helpIcon.jpg" /></a></td>
</tr>
<tr>
<td></td>
<td><hr class="hr1" size="1" /></td>
</tr>
<tr valign="baseline">
<td nowrap align="right" class="gb9">Reference:</td>
<td class="gb2"><input name="PBReference" type="text" class="gb2" id="PBReference" value="<%=(Recordset1.Fields.Item("PBReference".Value)%>" size="100" /></td>
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication reference help','Enter reference citation as: Journal year;volume(issue or supplement)<img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>p–pp'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td nowrap align="right" valign="top" class="gb9"&gt;Abstract:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;textarea dmxedit="true" id="PBAbstractWeb" name="PBAbstractWeb" style="width:100%;height:400px;" toolbar="F:NS;S:S;H:H;T:BIU;E:SBU;J:LCRF;O:LUOI;C:FB;X:SXHLITCFWM"&gt;&lt;%=(Recordset1.Fields.Item("PBAbstractWeb".Value)%&gt;&lt;/textarea&gt;&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication abstract help','Copy and paste abstract from publication. Check formatting OK and symbols have copied over. View in ‘non-edit’ mode to check formatting.'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td nowrap align="right" class="gb9"&gt;Country of journal:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;input name="PBCountry" type="text" class="gb2" id="PBCountry" value="&lt;%=(Recordset1.Fields.Item("PBCountry".Value)%&gt;" size="100" /&gt;&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication country help','Country of journal; not widely used so only complete if known. Generally either EU or USA.'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="right" nowrap valign="top" class="gb9"&gt;Study design:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;textarea name="TrialDesign" cols="100" rows="5" class="gb2" id="TrialDesign"&gt;&lt;%=(Recordset1.Fields.Item("TrialDesign".Value)%&gt;&lt;/textarea&gt;&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication study design help','Brief details of study design, eg, BIAsp 30 BID + met vs glargine OD + met in 26-week, treat-to-target trial in xx T2DM.'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td nowrap align="right" class="gb9"&gt;Product:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;select name="PBProduct" id="PBProduct" class="gb2"&gt;
&lt;option selected="selected"&gt;&lt;%=(Recordset1.Fields.Item("PBProduct".Value)%&gt;&lt;/option&gt;
&lt;option&gt;NovoMix 30&lt;/option&gt;
&lt;option&gt;NovoMix 30 and 50 and 70&lt;/option&gt;
&lt;option&gt;NovoMix 50 and 70&lt;/option&gt;
&lt;option&gt;NovoMix 30 and 70&lt;/option&gt;
&lt;option&gt;NovoMix 30 and 50&lt;/option&gt;
&lt;option&gt;FlexPen&lt;/option&gt;
&lt;option&gt;InnoLet&lt;/option&gt;
&lt;/select&gt;
&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication product help','Generally only needed for NovoMix due to the number of ratios available'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="right" nowrap class="gb9"&gt;Status:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;select name="PBStatus" id="PBStatus" class="gb2"&gt;
&lt;option selected="selected"&gt;&lt;%=(Recordset1.Fields.Item("PBStatus".Value)%&gt;&lt;/option&gt;
&lt;option&gt;Not determined&lt;/option&gt;
&lt;option&gt;Planned/proposed&lt;/option&gt;
&lt;option&gt;Not yet started&lt;/option&gt;
&lt;option&gt;Manuscript in preparation&lt;/option&gt;
&lt;option&gt;Data analysis in progress&lt;/option&gt;
&lt;option&gt;Manuscript internal review&lt;/option&gt;
&lt;option&gt;Manuscript author review&lt;/option&gt;
&lt;option&gt;Submitted&lt;/option&gt;
&lt;option&gt;Journal comments received&lt;/option&gt;
&lt;option&gt;Returned to journal&lt;/option&gt;
&lt;option&gt;Rejected&lt;/option&gt;
&lt;option&gt;Accepted for publication&lt;/option&gt;
&lt;option&gt;Published&lt;/option&gt;
&lt;option&gt;On hold&lt;/option&gt;
&lt;option&gt;Cancelled&lt;/option&gt;
&lt;option&gt;No publication planned&lt;/option&gt;
&lt;/select&gt;
&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication status help','Every time the status of the publication changes, this field should be updated using the drop down list. Writers and editors are both responsible for ensuring this field is updated. Likewise, the status details should be updated at the same time. This is a free text field, useful for supplying dates of when a draft was sent or when an article was submitted, for example.'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="right" nowrap class="gb9"&gt;Status notes:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;input name="ManuscriptStatus" type="text" class="gb2" id="ManuscriptStatus" value="&lt;%=(Recordset1.Fields.Item("ManuscriptStatus".Value)%&gt;" size="100" /&gt;&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication manuscript status help','Every time the status of the publication changes, this field should be updated using the drop down list. Writers and editors are both responsible for ensuring this field is updated. Likewise, the status details should be updated at the same time. This is a free text field, useful for supplying dates of when a draft was sent or when an article was submitted, for example.'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td nowrap align="right" class="gb9"&gt;Target journal:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;input name="PBTargetJnl" type="text" class="gb2" id="PBTargetJnl" value="&lt;%=(Recordset1.Fields.Item("PBTargetJnl".Value)%&gt;" size="100" /&gt;&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication target journal help','Enter full journal name'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td nowrap align="right" class="gb9"&gt;Congress presented:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;select name="PBCongressPresented" class="gb2"&gt;
&lt;option selected="selected"&gt;&lt;%=(Recordset1.Fields.Item("PBCongressPresented".Value)%&gt;&lt;/option&gt;
&lt;%
while (!Recordset2.EOF) {
%&gt;
&lt;option value="&lt;%=(Recordset2.Fields.Item("MeetingShortTitle".Value)%&gt;"&gt;&lt;%=(Recordset2.Fields.Item("MeetingShortTitle".Value)%&gt;&lt;/option&gt;
&lt;%
Recordset2.MoveNext();
}
if (Recordset2.CursorType &gt; 0) {
if (!Recordset2.BOF) Recordset2.MoveFirst();
} else {
Recordset2.Requery();
}
%&gt;
&lt;/select&gt;&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication congress presented help','Enter the abbreviated congress name and year; eg, EASD 2005, ADA 2006. It is essential that the format of this field is accurate since the database will use this field to identify and list the publication under the relevant congress in the ‘event materials’ view. To check the correct format for the abbreviated name, check the ‘event materials’ link for the list of congresses.'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td nowrap align="right" class="gb9"&gt;First presented at:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;select name="PBFirstPresentation" class="gb2"&gt;
&lt;option selected="selected"&gt;&lt;%=(Recordset1.Fields.Item("PBFirstPresentation".Value)%&gt;&lt;/option&gt;
&lt;%
while (!Recordset2.EOF) {
%&gt;
&lt;option value="&lt;%=(Recordset2.Fields.Item("MeetingShortTitle".Value)%&gt;"&gt;&lt;%=(Recordset2.Fields.Item("MeetingShortTitle".Value)%&gt;&lt;/option&gt;
&lt;%
Recordset2.MoveNext();
}
if (Recordset2.CursorType &gt; 0) {
if (!Recordset2.BOF) Recordset2.MoveFirst();
} else {
Recordset2.Requery();
}
%&gt;
&lt;/select&gt;&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication first presented help','Enter the abbreviated congress name and year; eg, EASD 2005, ADA 2006. It is essential that the format of this field is accurate since the database will use this field to identify and list the publication under the relevant congress in the ‘event materials’ view. To check the correct format for the abbreviated name, check the ‘event materials’ link for the list of congresses.'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td nowrap align="right" valign="top" class="gb9"&gt;Essential points:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;textarea name="WebEPs" cols="100" rows="10" class="gb2" id="WebEPs"&gt;&lt;%=(Recordset1.Fields.Item("WebEPs".Value)%&gt;&lt;/textarea&gt;&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication essential points help','All publication forms for primary and secondary manuscripts and reviews should include essential points; this is a summary, as a bulleted list, of the key points of the publication. Since the abstract is included on the form, the essential points should not just be a summary of this but they place the study in the context of the product’s key messages. Between 3-5 essential points are generally required for each publication.'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td nowrap align="right" class="gb9"&gt;Publication categories:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;select name="PBDSCats" id="PBDSCats" class="gb2"&gt;
&lt;option selected="selected"&gt;&lt;%=(Recordset1.Fields.Item("PBDSCats".Value)%&gt;&lt;/option&gt;
&lt;option&gt;Comparative studies: Lantus&lt;/option&gt;
&lt;option&gt;Comparative studies: LisproMix25&lt;/option&gt;
&lt;option&gt;Comparative studies: Mixtard 30/BHI30&lt;/option&gt;
&lt;option&gt;Comparative studies: NPH&lt;/option&gt;
&lt;option&gt;Convenience&lt;/option&gt;
&lt;option&gt;Health economics&lt;/option&gt;
&lt;option&gt;Hypoglycaemia&lt;/option&gt;
&lt;option&gt;OAD combination studies&lt;/option&gt;
&lt;option&gt;PK/PD&lt;/option&gt;
&lt;option&gt;Placebo studies&lt;/option&gt;
&lt;option&gt;FlexPen&lt;/option&gt;
&lt;/select&gt;
&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication categories help','Where appropriate, select one of the publication categories for the publication from the drop-down list. In the ‘published studies’ view, there is the option to sort the publications by these categories (as there are so many publications). '); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td nowrap align="right" class="gb9"&gt;Ranking:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;select name="PBRank" id="PBRank" class="gb2"&gt;
&lt;option selected="selected"&gt;&lt;%=(Recordset1.Fields.Item("PBRank".Value)%&gt;&lt;/option&gt;
&lt;option&gt;&lt;/option&gt;
&lt;option&gt;1&lt;/option&gt;
&lt;option&gt;2&lt;/option&gt;
&lt;option&gt;3&lt;/option&gt;
&lt;option&gt;4&lt;/option&gt;
&lt;option&gt;5&lt;/option&gt;
&lt;/select&gt;
&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication ranking help','On the front page, the key messages are listed. When you click on a key message, the top 5 supporting references will be listed. If the publication is a key reference, use this field to rank the publication accordingly. '); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td nowrap align="right" class="gb9"&gt;Key messages:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;input name="PBKM1" type="checkbox" value="NovoMix 30 provides both post-prandial plasma glucose and fasting plasma glucose control" &lt;%=(((Recordset1.Fields.Item("PBKM1".Value) == "NovoMix 30 provides both post-prandial plasma glucose and fasting plasma glucose control"?"checked=\"checked\"":""%&gt; /&gt;
&lt;label class="gb2"&gt;NovoMix 30 provides both post-prandial plasma glucose and fasting plasma glucose control&lt;/label&gt;
&lt;br /&gt;
&lt;input name="PBKM2" type="checkbox" value="NovoMix 30 gets people with diabetes to HbA1C target" &lt;%=(((Recordset1.Fields.Item("PBKM2".Value) == "NovoMix 30 gets people with diabetes to HbA1C target"?"checked=\"checked\"":""%&gt; /&gt;
&lt;label class="gb2"&gt;NovoMix 30 gets people with diabetes to HbA1C target&lt;/label&gt;
&lt;br /&gt;
&lt;input name="PBKM3" type="checkbox" value="NovoMix is a convenient way to start insulin" &lt;%=(((Recordset1.Fields.Item("PBKM3".Value) == "NovoMix is a convenient way to start insulin"?"checked=\"checked\"":""%&gt; /&gt;
&lt;label class="gb2"&gt;NovoMix is a convenient way to start insulin&lt;/label&gt;
&lt;br /&gt;
&lt;input name="PBKM4" type="checkbox" value="NovoMix three times daily is an efficacious and convenient way of intensifying conventional insulin therapy" &lt;%=(((Recordset1.Fields.Item("PBKM4".Value) == "NovoMix three times daily is an efficacious and convenient way of intensifying conventional insulin therapy"?"checked=\"checked\"":""%&gt; /&gt;
&lt;label class="gb2"&gt;NovoMix three times daily is an efficacious and convenient way of intensifying conventional insulin therapy&lt;/label&gt;
&lt;br /&gt;
&lt;input name="PBKMNot" type="checkbox" value="Not categorised" &lt;%=(((Recordset1.Fields.Item("PBKMNot".Value) == "Not categorised"?"checked=\"checked\"":""%&gt; /&gt;
&lt;label class="gb2"&gt;Not categorised&lt;/label&gt;
&lt;br /&gt;
&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication key message help','Each publication must be assigned one of the four key messages or as ‘Not categorised’. If no message is assigned, the publication will be ‘lost’ in the database as the majority of the views in the toolbox are sorted by key message. '); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="right" class="gb9"&gt;ICTR available:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;input name="PBReportDate" type="text" class="gb2" id="PBReportDate" value="&lt;%=(Recordset1.Fields.Item("PBReportDate".Value)%&gt;" size="11" /&gt;
&nbsp;
&lt;input class="select" type="button" value="Calendar" onClick="select_date('PBReportDate');" /&gt;&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Upload help','Enter the date when the ICTR will be available (if known).'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="right" class="gb9"&gt;Estimated submission date:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;input name="PBSubmissionDate" type="text" class="gb2" id="PBSubmissionDate" value="&lt;%=(Recordset1.Fields.Item("PBSubmissionDate".Value)%&gt;" size="11" /&gt;
&nbsp;
&lt;input class="select" type="button" value="Calendar" onClick="select_date('PBSubmissionDate');" /&gt;&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication estimated submission date help','Enter the date when publication will be submitted; this should always be up to date as it is used regularly in publication planning meetings'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="right" class="gb9"&gt;Estimated/actual publication date:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;input name="PBPubDate" type="text" class="gb2" id="PBPubDate" value="&lt;%=(Recordset1.Fields.Item("PBPubDate".Value)%&gt;" size="11" /&gt;
&nbsp;
&lt;input class="select" type="button" value="Calendar" onClick="select_date('PBPubDate');" /&gt;&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Estimated publication date help','Enter the date that the publication became available etiher in print or on-line (whichever came first). The date is important for the ‘timeline’ view, as this will show publications published in different quarters. It is easy, therefore, to see what has been published in, eg, the last 3 months. This should always be up to date as it is used regularly in publication planning meetings'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="right" class="gb9"&gt;Priority:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;input name="PBPriority" type="text" class="gb2" id="PBPriority" value="&lt;%=(Recordset1.Fields.Item("PBPriority".Value)%&gt;" size="100" /&gt;
&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication priority help','Enter low/medium/high if necessary. NovoMix doesn’t regularly use this field; check with other toolboxes for importance.'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="right" class="gb9"&gt;Contact at NN:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;input name="PBNNContact" type="text" class="gb2" id="PBNNContact" value="&lt;%=(Recordset1.Fields.Item("PBNNContact".Value)%&gt;" size="100" /&gt;
&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication contact help','Enter initials of contact at Novo; useful for following up publications'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td valign="top" align="right" class="gb9"&gt;Action:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;textarea name="PBAction" cols="100" rows="5" class="gb2" id="PBAction"&gt;&lt;%=(Recordset1.Fields.Item("PBAction".Value)%&gt;&lt;/textarea&gt;
&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication action help','Free text field for providing a commentary/log of actions, for example, submission pack sent to author 01.01.06. Author confirmed submission to journal 07.01.06….etc This field is only viewable in ‘edit’ mode'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="right" class="gb9"&gt;Include in Data Support bibliography:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;input &lt;%=(((Recordset1.Fields.Item("PBDSStatus".Value) == "Y"?"checked=\"checked\"":""%&gt; name="PBDSStatus" type="checkbox" class="gb2" id="PBDSStatus" value="&lt;%=(Recordset1.Fields.Item("PBDSStatus".Value)%&gt;" size="100" /&gt;
&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication include in data support bibliography help','Tick if to …..? To be confirmed'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="right" class="gb9"&gt;Include in 'Upcoming publications' page:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;input &lt;%=(((Recordset1.Fields.Item("PBStatusSummaryList".Value) == "Y"?"checked=\"checked\"":""%&gt; name="PBStatusSummaryList" type="checkbox" class="gb2" id="PBStatusSummaryList" value="&lt;%=(Recordset1.Fields.Item("PBStatusSummaryList".Value)%&gt;" size="100" /&gt;
&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Include in upcoming publications page help','Tick if to appear on ‘upcoming publications’ page'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="right" class="gb9"&gt;Include on front page under key message:&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;input &lt;%=(((Recordset1.Fields.Item("PBPubList".Value) == "Y"?"checked=\"checked\"":""%&gt; name="PBPubList" type="checkbox" class="gb2" id="PBPubList" value="&lt;%=(Recordset1.Fields.Item("PBPubList".Value)%&gt;" size="100" /&gt;
&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Include on front page under key message help','Tick if to appear on front page under key message'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="right" class="gb9"&gt;US driven?&lt;/td&gt;
&lt;td class="gb2"&gt;&lt;input &lt;%=(((Recordset1.Fields.Item("PBUSDriven".Value) == "Y"?"checked=\"checked\"":""%&gt; name="PBUSDriven" type="checkbox" class="gb2" id="PBUSDriven" value="&lt;%=(Recordset1.Fields.Item("PBUSDriven".Value)%&gt;" size="100" /&gt;
&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication US-Driven help','Only in NovoMix medical toolbox; tick if US affiliate driving publication'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;&lt;hr class="hr1" size="1" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td nowrap align="right"&gt;&nbsp;&lt;/td&gt;
&lt;td&gt;&lt;input name="Save" type="submit" class="gb2" value="Save" /&gt;&lt;/td&gt;
&lt;td align="right"&gt;&lt;a href="javascript:void(0)" onMouseover="EnterContent('ToolTip','Publication US-Driven help','Any changes you have made must be saved!'); Activate();" onMouseout="deActivate()"&gt;&lt;img src="helpIcon.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;input type="hidden" name="MM_update" value="MtgForm" /&gt;
&lt;input type="hidden" name="MM_recordId" value="&lt;%= Recordset1.Fields.Item("docNum".Value %&gt;" /&gt;
&lt;input type="hidden" name="upload_org_PBAttachments" value="&lt;%= pau.Fields("upload_org_PBAttachments".Value %&gt;" /&gt;
&lt;/form&gt;
&lt;/body&gt;
&lt;/html&gt;
&lt;%
Recordset1.Close();
%&gt;
&lt;%
Recordset2.Close();
%&gt;
Replied 27 Mar 2007 17:19:34
27 Mar 2007 17:19:34 Georgi Kralev replied:
Mike,

I have take a look at your code and noticed that you have put after upload to go to MainDetail.asp
Check the following line:
if (pau.Done) Response.Redirect("MainDetail.asp";

This means that your Update statement will not be executed. You already have Redirect after the update
Response.Redirect(MM_editRedirectUrl)

Therefore, remove the following line: if (pau.Done) Response.Redirect("MainDetail.asp";
Or from PAU3 Dialog window clear Go To field.

If this does not solve your problem I could try to check your code in more details. But in order to execute your code on my computer I will need part of your database structure. Could you generate Create Table SQL scripts for the tables that are used by your page and provide some sample data? You can send it to my email.

Regards,

Georgi Kralev

----------------------------------
Support - www.DMXzone.com
Replied 27 Mar 2007 17:37:50
27 Mar 2007 17:37:50 Mike McEachern replied:
Thanks for looking at this for me. I've done what you suggested and no dice. It still won't update either the file field OR the rest of the fields. What I'm going to try next is simply find and replace all the occurences of 'Recordset1' with 'Recordset1_cmd' and see if that un-confuses the page.

I'll send you some scripts generated if you think that would be useful, where do you do that from? Is that from Dreamweaver, or from my SQL Server? Never done it before, sorry.
Replied 27 Mar 2007 17:44:09
27 Mar 2007 17:44:09 Mike McEachern replied:
That didn't work at all. Really grasping at straws now. I keep getting this error whenever trying to do anything after reopening any of my pages.

'Javascript error while loading Recordset.htm: invalid quantifier ?'

Replied 27 Mar 2007 17:52:10
27 Mar 2007 17:52:10 Georgi Kralev replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>I'll send you some scripts generated if you think that would be useful, where do you do that from? Is that from Dreamweaver, or from my SQL Server? <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

You could generate the scripts from your SQL Server. Then send them to my email: (Please, include also in the email the URL of this thread).

I will create your tables and try to debug the page.

Regards,

Georgi Kralev

----------------------------------
Support - www.DMXzone.com
Replied 27 Mar 2007 17:54:10
27 Mar 2007 17:54:10 Mike McEachern replied:
Basically, I wonder what the best order of operations is when changing an existing ASP page that works fine to use PAU and adv html editor. Because what I've done so far is create a new asp page, create new instances of my 2 recordsets, then cut and paste all the html tags, fields over into the new page. Then I change one of my fields to use the adv html editor instead of a plain textarea field, then did a run through to see if it uploaded ok. That worked fine. Then I added a file field that would hold the file and applied PAU to that field. Then the probs start. Then not only do any of the fields not upload, but this javascript error comes up, plus the recordsets don't show up on the server behaviours tab.

Just don't get it.
Replied 28 Mar 2007 14:45:52
28 Mar 2007 14:45:52 Georgi Kralev replied:
Hi Mike,

I have tested your page and send you an email.
Please, check your email for more details.

Regards,

Georgi Kralev

----------------------------------
Support - www.DMXzone.com

Reply to this topic