if not exists (select * from sysobjects where id = object_id(N'Indoo_template_0118') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN create table Indoo_template_0118 (ID bigint PRIMARY KEY IDENTITY(1, 1), productName nvarchar (200) NULL, itemNumber bigint NULL, amount real NULL, file1_content image NULL, file1_mimetype nvarchar (200) NULL) END tablename Indoo_template_0118 binaryData.fileSytemDBPath notSkipSqlOnImport on gridView.recordcount 1 gridView.inlineEdit version 01.05.00 connectionType 0 connectionString tableKeyColumn id showGridView on gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.insertrecord on gridview.editrecord on gridview.deleterecord gridview.viewrecord hidegridview gridView.hideElement 0 gridView.pagerecord showGridEdit on hidegridviewonedit grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode gridEdit.valueID gridEdit.TextboxWidth gridEdit.redirectURL gridEdit.txt_Save gridEdit.txt_Insert gridEdit.txt_Back gridEdit.txt_Next gridEdit.txt_Finish gridEdit.txt_cancel gridEdit_customHTMLForm gridEdit.isBinary on networkCredential.userName networkCredential.passWord sqldeveloperwindowcb importexportcb on gridView.importStopAfterErrorCount 10 isEmptyCaptionReplaced on gridedit.allowunecryptedquerystring gridedit.isgridvieweditredirected gridview.ispagenumbertextbox gridview.sqlstatementquery gridView.gridDdlForm 0 alternateTablename alternateConnectionString gridView.ID gridEdit.ID gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter gridEdit.sendToMail gridView.OrderBy gridView.SqlWhere moduleHeader <INPUT TYPE="hidden" NAME="cmd" VALUE="_ext-enter"> <INPUT TYPE="hidden" NAME="redirect_cmd" VALUE="_xclick"> <INPUT TYPE="hidden" NAME="business" VALUE="recipient@paypal.com"> <INPUT TYPE="hidden" NAME="undefined_quantity" VALUE="1"> <INPUT TYPE="hidden" NAME="item_name" VALUE=""> <INPUT TYPE="hidden" NAME="item_number" VALUE=""> <INPUT TYPE="hidden" NAME="amount" VALUE=""> <input type="hidden" name="no_shipping" value="1" /> <INPUT TYPE="hidden" NAME="currency_code" VALUE="USD"> <INPUT TYPE="hidden" NAME="first_name" VALUE="[User:firstname]"> <INPUT TYPE="hidden" NAME="last_name" VALUE="[User:lastname]"> <input type="hidden" name="lc" value="US" /> moduleFooter <script> function Indoo_template_0118_f(item, amount, productName){ myForm=document.forms[0]; myForm['item_name'].value=productName; myForm['item_number'].value=item; myForm['amount'].value=amount; myForm.action='https://www.paypal.com/cgi-bin/webscr'; myForm.method='POST'; myForm.submit(); } </script> htmlHeadBlock startupScriptBlock onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnUpdateFinishRecord sqlOnViewModule sqlOnViewRecord addcreatestatement on gridViewColumn.0.columnName productName gridViewColumn.0.Visible on gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 1 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridViewColumn.0.isOther 0 gridEditColumn.0.columnName productName gridEditColumn.0.Visible on gridEditColumn.0.multiplePage 1 gridEditColumn.0.Autovalidator on gridViewColumn.1.columnName itemNumber gridViewColumn.1.Visible on gridViewColumn.1.allowExport on gridViewColumn.1.allowEdit on gridViewColumn.1.allowFilter 1 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridViewColumn.1.isOther 0 gridEditColumn.1.columnName itemNumber gridEditColumn.1.Visible on gridEditColumn.1.multiplePage 1 gridEditColumn.1.Autovalidator on gridViewColumn.4.columnName amount gridViewColumn.4.Visible on gridViewColumn.4.allowExport on gridViewColumn.4.allowEdit on gridViewColumn.4.allowFilter 1 gridViewColumn.4.allowSort on gridViewColumn.4.allowImport on gridViewColumn.4.isOther 2 gridEditColumn.2.columnName amount gridEditColumn.2.Visible on gridEditColumn.2.multiplePage 1 gridEditColumn.2.Autovalidator on gridViewColumn.0.caption gridViewColumn.1.caption gridViewColumn.4.caption Payment gridEditColumn.0.caption gridEditColumn.0.Readonly gridEditColumn.1.caption gridEditColumn.1.Readonly gridEditColumn.2.caption gridEditColumn.2.Readonly gridViewColumn.2.columnName amount gridViewColumn.2.Visible on gridViewColumn.2.allowExport on gridViewColumn.2.allowEdit on gridViewColumn.2.allowFilter 1 gridViewColumn.2.allowSort on gridViewColumn.2.allowImport on gridViewColumn.2.isOther 0 gridViewColumn.2.caption Picture gridViewColumn.2.isBinary on gridViewColumn.2.binaryData.target _blank gridViewColumn.2.binaryData.columnName file1_content gridViewColumn.2.binaryData.showType 2 gridViewColumn.2.binaryData.mimeTypeSource 2 gridViewColumn.2.binaryData.mimeTypeColumnName file1_mimetype gridViewColumn.2.binaryLocation 0 gridViewColumn.2.binaryData.thumbnailWidth 120 gridViewColumn.2.binaryData.thumbnailHeight 120 gridEditColumn.3.columnName file1_content gridEditColumn.3.Visible on gridEditColumn.3.multiplePage 1 gridEditColumn.3.Autovalidator on gridEditColumn.3.binaryData.showType 2 gridEditColumn.3.binaryData.target _blank gridEditColumn.3.binaryData.mimeTypeSource 2 gridEditColumn.3.binaryData.mimeTypeColumnName file1_mimetype gridEditColumn.3.binaryLocation 0 gridEditColumn.3.binaryData.thumbnailWidth 120 gridEditColumn.3.binaryData.thumbnailHeight 120 gridEditColumn.3.binaryData.uploadLimit 3000000 gridEditColumn.3.caption gridEditColumn.3.Readonly gridViewColumn.4.width gridViewColumn.4.defaultContent gridViewColumn.4.formatData gridViewColumn.4.importDefault gridViewColumn.4.filterAdditionalColumn gridViewColumn.4.defaultSortColumn gridViewColumn.4.isBoolean gridViewColumn.4.isLink gridViewColumn.4.isBinary gridViewColumn.4.isJoin gridViewColumn.4.isHtmlAttributes gridViewColumn.4.customHTMLForm <TEXTAREA id=Indoo_template_0118_c_[columnField:ID]_[columnIndex] style="DISPLAY: none">[columnField:productName]</TEXTAREA> <A title="Make payments with PayPal - it's fast, free and secure!" href="javascript:Indoo_template_0118_f('[columnField:itemNumber]','[columnField:amount]',document.getElementById('Indoo_template_0118_c_[columnField:ID]_[columnIndex]').innerHTML)">Enroll via PayPal</A> gridViewColumn.2.width gridViewColumn.2.defaultContent gridViewColumn.2.formatData gridViewColumn.2.importDefault gridViewColumn.2.filterAdditionalColumn gridViewColumn.2.defaultSortColumn gridViewColumn.2.isBoolean gridViewColumn.2.isLink gridViewColumn.2.isJoin gridViewColumn.2.isHtmlAttributes gridViewColumn.2.binaryData.FilenameSource 1 gridviewcolumn.2.binarydata.isforcedownload gridViewColumn.2.binaryData.isBinaryIdFromColumn gridViewColumn.2.binaryData.allowExport gridViewColumn.2.binaryData.allowImport gridViewColumn.2.binaryData.Filename gridViewColumn.2.binaryData.defaultImageUrl gridViewColumn.3.Visible on gridViewColumn.3.allowExport on gridViewColumn.3.allowEdit on gridViewColumn.3.allowFilter 1 gridViewColumn.3.allowSort on gridViewColumn.3.allowImport on gridViewColumn.3.columnName amount gridViewColumn.3.caption gridViewColumn.3.width gridViewColumn.3.defaultContent gridViewColumn.3.formatData gridViewColumn.3.importDefault gridViewColumn.3.filterAdditionalColumn gridViewColumn.3.defaultSortColumn gridViewColumn.3.isBoolean gridViewColumn.3.isLink gridViewColumn.3.isOther 0 gridViewColumn.3.isBinary gridViewColumn.3.isJoin gridViewColumn.3.isHtmlAttributes tablename Indoo_template_0118 binaryData.fileSytemDBPath |DataDirectory|indooGrid\ notSkipSqlOnImport on gridView.recordcount 1 gridView.inlineEdit version 01.05.00 connectionType 0 connectionString tableKeyColumn id showGridView on gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.insertrecord on gridview.editrecord on gridview.deleterecord gridview.viewrecord hidegridview gridView.hideElement 0 gridView.pagerecord showGridEdit on hidegridviewonedit grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode gridEdit.valueID gridEdit.TextboxWidth gridEdit.redirectURL gridEdit.txt_Save gridEdit.txt_Insert gridEdit.txt_Back gridEdit.txt_Next gridEdit.txt_Finish gridEdit.txt_cancel gridEdit_customHTMLForm gridEdit.isBinary on networkCredential.userName networkCredential.passWord sqldeveloperwindowcb importexportcb on gridView.importStopAfterErrorCount 10 isEmptyCaptionReplaced on gridedit.allowunecryptedquerystring gridedit.isgridvieweditredirected gridview.ispagenumbertextbox gridview.sqlstatementquery gridView.gridDdlForm 0 alternateTablename alternateConnectionString gridView.ID gridEdit.ID gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter gridEdit.sendToMail gridView.OrderBy gridView.SqlWhere moduleHeader <INPUT TYPE="hidden" NAME="cmd" VALUE="_ext-enter"> <INPUT TYPE="hidden" NAME="redirect_cmd" VALUE="_xclick"> <INPUT TYPE="hidden" NAME="business" VALUE="recipient@paypal.com"> <INPUT TYPE="hidden" NAME="undefined_quantity" VALUE="1"> <INPUT TYPE="hidden" NAME="item_name" VALUE=""> <INPUT TYPE="hidden" NAME="item_number" VALUE=""> <INPUT TYPE="hidden" NAME="amount" VALUE=""> <input type="hidden" name="no_shipping" value="1" /> <INPUT TYPE="hidden" NAME="currency_code" VALUE="USD"> <INPUT TYPE="hidden" NAME="first_name" VALUE="[User:firstname]"> <INPUT TYPE="hidden" NAME="last_name" VALUE="[User:lastname]"> <input type="hidden" name="lc" value="US" /> moduleFooter <script> function Indoo_template_0118_f(item, amount, productName){ myForm=document.forms[0]; myForm['item_name'].value=productName; myForm['item_number'].value=item; myForm['amount'].value=amount; myForm.action='https://www.paypal.com/cgi-bin/webscr'; myForm.method='POST'; myForm.submit(); } </script> htmlHeadBlock startupScriptBlock onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnUpdateFinishRecord sqlOnViewModule sqlOnViewRecord addcreatestatement on gridViewColumn.0.columnName productName gridViewColumn.0.Visible on gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 1 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridViewColumn.0.isOther 0 gridEditColumn.0.columnName productName gridEditColumn.0.Visible on gridEditColumn.0.multiplePage 1 gridEditColumn.0.Autovalidator on gridViewColumn.1.columnName itemNumber gridViewColumn.1.Visible on gridViewColumn.1.allowExport on gridViewColumn.1.allowEdit on gridViewColumn.1.allowFilter 1 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridViewColumn.1.isOther 0 gridEditColumn.1.columnName itemNumber gridEditColumn.1.Visible on gridEditColumn.1.multiplePage 1 gridEditColumn.1.Autovalidator on gridViewColumn.4.columnName amount gridViewColumn.4.Visible on gridViewColumn.4.allowExport on gridViewColumn.4.allowEdit on gridViewColumn.4.allowFilter 1 gridViewColumn.4.allowSort on gridViewColumn.4.allowImport on gridViewColumn.4.isOther 2 gridEditColumn.2.columnName amount gridEditColumn.2.Visible on gridEditColumn.2.multiplePage 1 gridEditColumn.2.Autovalidator on gridViewColumn.0.caption gridViewColumn.1.caption gridViewColumn.4.caption Payment gridEditColumn.0.caption gridEditColumn.0.Readonly gridEditColumn.1.caption gridEditColumn.1.Readonly gridEditColumn.2.caption gridEditColumn.2.Readonly gridViewColumn.2.columnName amount gridViewColumn.2.Visible on gridViewColumn.2.allowExport on gridViewColumn.2.allowEdit on gridViewColumn.2.allowFilter 1 gridViewColumn.2.allowSort on gridViewColumn.2.allowImport on gridViewColumn.2.isOther 0 gridViewColumn.2.caption Picture gridViewColumn.2.isBinary on gridViewColumn.2.binaryData.target _blank gridViewColumn.2.binaryData.columnName file1_content gridViewColumn.2.binaryData.showType 2 gridViewColumn.2.binaryData.mimeTypeSource 2 gridViewColumn.2.binaryData.mimeTypeColumnName file1_mimetype gridViewColumn.2.binaryLocation 0 gridViewColumn.2.binaryData.thumbnailWidth 120 gridViewColumn.2.binaryData.thumbnailHeight 120 gridEditColumn.3.columnName file1_content gridEditColumn.3.Visible on gridEditColumn.3.multiplePage 1 gridEditColumn.3.Autovalidator on gridEditColumn.3.binaryData.showType 2 gridEditColumn.3.binaryData.target _blank gridEditColumn.3.binaryData.mimeTypeSource 2 gridEditColumn.3.binaryData.mimeTypeColumnName file1_mimetype gridEditColumn.3.binaryLocation 0 gridEditColumn.3.binaryData.thumbnailWidth 120 gridEditColumn.3.binaryData.thumbnailHeight 120 gridEditColumn.3.binaryData.uploadLimit 3000000 gridEditColumn.3.caption gridEditColumn.3.Readonly gridViewColumn.4.width gridViewColumn.4.defaultContent gridViewColumn.4.formatData gridViewColumn.4.importDefault gridViewColumn.4.filterAdditionalColumn gridViewColumn.4.defaultSortColumn gridViewColumn.4.isBoolean gridViewColumn.4.isLink gridViewColumn.4.isBinary gridViewColumn.4.isJoin gridViewColumn.4.isHtmlAttributes gridViewColumn.4.customHTMLForm <TEXTAREA id=Indoo_template_0118_c_[columnField:ID]_[columnIndex] style="DISPLAY: none">[columnField:productName]</TEXTAREA> <A title="Make payments with PayPal - it's fast, free and secure!" href="javascript:Indoo_template_0118_f('[columnField:itemNumber]','[columnField:amount]',document.getElementById('Indoo_template_0118_c_[columnField:ID]_[columnIndex]').innerHTML)">Enroll via PayPal</A> gridViewColumn.2.width gridViewColumn.2.defaultContent gridViewColumn.2.formatData gridViewColumn.2.importDefault gridViewColumn.2.filterAdditionalColumn gridViewColumn.2.defaultSortColumn gridViewColumn.2.isBoolean gridViewColumn.2.isLink gridViewColumn.2.isJoin gridViewColumn.2.isHtmlAttributes gridViewColumn.2.binaryData.FilenameSource 1 gridviewcolumn.2.binarydata.isforcedownload gridViewColumn.2.binaryData.isBinaryIdFromColumn gridViewColumn.2.binaryData.allowExport gridViewColumn.2.binaryData.allowImport gridViewColumn.2.binaryData.Filename gridViewColumn.2.binaryData.defaultImageUrl gridViewColumn.3.Visible on gridViewColumn.3.allowExport on gridViewColumn.3.allowEdit on gridViewColumn.3.allowFilter 1 gridViewColumn.3.allowSort on gridViewColumn.3.allowImport on gridViewColumn.3.columnName amount gridViewColumn.3.caption gridViewColumn.3.width gridViewColumn.3.defaultContent gridViewColumn.3.formatData gridViewColumn.3.importDefault gridViewColumn.3.filterAdditionalColumn gridViewColumn.3.defaultSortColumn gridViewColumn.3.isBoolean gridViewColumn.3.isLink gridViewColumn.3.isOther 0 gridViewColumn.3.isBinary gridViewColumn.3.isJoin gridViewColumn.3.isHtmlAttributes