Join our DNN Community    (Newsletter, Tips, Tricks and Forums for DNN Skins & Modules)

 


 
Microsoft Gold Certified Partner - DNN Benefactor

DotNetNuke Powered! 
Thursday, November 20, 2008 Register · Login · Contact · Search:  
Company Solutions Portfolio Contact
Forums
Tips and Tricks
You asked for it, and we added it. We have so many great developers using ListX right now - it would be best to get some samples straight from the gurus who swear by it. View and Add your samples and tips here!
Forums > Bi4ce.Modules.ListX > Tips and Tricks
Subject: Adding Record not functioning

You are not authorized to post a reply.   
Author Messages
muhairi
Flyweight
Posts:1
07/05/2006 8:38 AM Alert 
I'm newbie for this ListX. I need assistance to solve this problem.

I'm trying to add and delete record on the table. Unfortunately it doesn't work. For Update Record it work.

<?xml version="1.0" encoding="utf-16"?>
<xListSettings xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<recordsPerPage>0</recordsPerPage>
<enableAlphaFilter>false</enableAlphaFilter>
<enablePageSelection>false</enablePageSelection>
<enableRecordsPerPage>false</enableRecordsPerPage>
<enableCustomPaging>false</enableCustomPaging>
<enableExcelExport>false</enableExcelExport>
<enableQueryDebug>false</enableQueryDebug>
<enableAJAX>false</enableAJAX>
<enableAJAXCustomPaging>false</enableAJAXCustomPaging>
<enableAJAXCustomStatus>false</enableAJAXCustomStatus>
<includeJavascriptUtilities>false</includeJavascriptUtilities>
<includeJavascriptValidation>false</includeJavascriptValidation>
<enableMultipleColumnSorting>false</enableMultipleColumnSorting>
<ModuleCommunicationMessageType />
<showAll>true</showAll>
<searchItems />
<queryItems>
<anyType xsi:type="QueryOptionItem">
<Index>0</Index>
<VariableType><Session></VariableType>
<QuerySource>CurrentGatewayID</QuerySource>
<QueryTarget>[GatewayID]</QueryTarget>
<Protected>false</Protected>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>1</Index>
<VariableType><Form></VariableType>
<QuerySource>fld_Gateway</QuerySource>
<QueryTarget>[Gateway]</QueryTarget>
<Protected>true</Protected>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>2</Index>
<VariableType><Form></VariableType>
<QuerySource>fld_GatewayID</QuerySource>
<QueryTarget>[GatewayID]</QueryTarget>
<Protected>true</Protected>
</anyType>
</queryItems>
<listItems />
<messageItems>
<anyType xsi:type="MessageActionItem">
<Index>0</Index>
<ActionType>Message</ActionType>
<ActionInformation>4:7;6;ToolbarCancel</ActionInformation>
<Level>0</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>1</Index>
<ActionType>Condition-If</ActionType>
<ActionInformation>7:26;1;2;[CurrentGatewayID,Session]=-1</ActionInformation>
<Level>1</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>2</Index>
<ActionType>Action-Assignment</ActionType>
<ActionInformation>7:9;16;0;<Session>CurrentGatewayID</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>3</Index>
<ActionType>Action-Redirect</ActionType>
<ActionInformation>7:3;17;2;Tab[bi4ce_bc_back,S⒏</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>4</Index>
<ActionType>Condition-Else</ActionType>
<ActionInformation />
<Level>1</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>5</Index>
<ActionType>Action-Redirect</ActionType>
<ActionInformation>7:3;17;2;Tab[bi4ce_bc_back,S⒏</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>6</Index>
<ActionType>Message</ActionType>
<ActionInformation>4:7;4;ToolbarSave</ActionInformation>
<Level>0</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>7</Index>
<ActionType>Condition-If</ActionType>
<ActionInformation>7:26;1;2;[CurrentGatewayID,Session]=-1</ActionInformation>
<Level>1</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>8</Index>
<ActionType>Action-Execute</ActionType>
<ActionInformation>6:6;106;InsertInsertGatewayID @GatewayID=[CurrentGatewayID, Session], @Gateway='[FORMAT,[fld_Gateway,F],{REPLACE:',''}]'</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>9</Index>
<ActionType>Action-Assignment</ActionType>
<ActionInformation>8:9;16;13;<Session>CurrentGatewayID[GatewayID,0]</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>10</Index>
<ActionType>Action-Redirect</ActionType>
<ActionInformation>7:3;17;2;Tab[bi4ce_bc_back,S⒏</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>11</Index>
<ActionType>Condition-Else</ActionType>
<ActionInformation />
<Level>1</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>12</Index>
<ActionType>Action-Execute</ActionType>
<ActionInformation>6:6;106;UpdateUpdateGatewayID @GatewayID=[CurrentGatewayID, Session], @Gateway='[FORMAT,[fld_Gateway,F],{REPLACE:',''}]'</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>13</Index>
<ActionType>Action-Redirect</ActionType>
<ActionInformation>6:3;0;2;Tab59</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>14</Index>
<ActionType>Message</ActionType>
<ActionInformation>4:7;6;ToolbarDelete</ActionInformation>
<Level>0</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>15</Index>
<ActionType>Action-Execute</ActionType>
<ActionInformation>5:6;52;DeleteDeleteGatewayID@GatewayID=[CurrentGatewayID,Session]</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>16</Index>
<ActionType>Action-Assignment</ActionType>
<ActionInformation>7:9;16;0;<Session>CurrentGatewayID</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>17</Index>
<ActionType>Action-Redirect</ActionType>
<ActionInformation>6:3;0;2;Tab59</ActionInformation>
<Level>2</Level>
</anyType>
</messageItems>
<query>SELECT GatewayID, Gateway FROM GatewayID WHERE GatewayID=[GatewayID]
</query>
<filter />
<customConnection>Provider=SQLOLEDB;Server=localhost;Database=VoCALData;uid=vocal;pwd=vocal;</customConnection>
<listItem><br/><br/>
<table width="100%" cellpadding="0" cellspacing="2" border="0" id="listXTable">
<thead>
<tr>
<td width="10%" nowrap><img src="images/1x1.gif" width="100%" height="1px" border="0"></td>
<td width="90%"><img src="images/1x1.gif" width="100%" height="1px" border="0"></td>
</tr>
</thead>
<tbody>
<tr><td class="Tier3Label">Gateway ID</td><td class="Tier3Edit"><input type="textbox" class="Tier3Textbox" id="fld_GatewayID" name="fld_GatewayID" value="[GatewayID]" disabled></td></tr>
<tr><td class="Tier3LabelRequired">Gateway</td><td class="Tier3Edit"><input type="textbox" class="Tier3Textbox" id="fld_Gateway" name="fld_Gateway" value="[Gateway]"></td></tr>

</tbody>
</table>
</listItem>
<listAItem />
<defaultItem><br/><br/>
<table width="100%" cellpadding="0" cellspacing="2" border="0" id="listXTable">
<thead>
<tr>
<td width="10%" nowrap><img src="images/1x1.gif" width="100%" height="1px" border="0"></td>
<td width="90%"><img src="images/1x1.gif" width="100%" height="1px" border="0"></td>
</tr>
</thead>
<tbody>
<tr><td class="Tier3Label">Gateway ID</td><td class="Tier3Edit"><input type="hidden" class="Tier3Textbox" id="fld_GatewayID" name="fld_GatewayID" value="[CurrentOrderID]" ></td></tr>
<tr><td class="Tier3LabelRequired">Gateway</td><td class="Tier3Edit"><input type="textbox" class="Tier3Textbox" id="fld_Gateway" name="fld_Gateway" value=""></td></tr>

</tbody>
</table>
</defaultItem>
<noqueryItem>{IIF,"'[GatewayID]'='-1'","<span class=""Tier3NewRecordTitle""><New Gateway Being Added></span>","<span class=""Tier3Title"">Edit: [Gateway]</span>"}

</noqueryItem>
<Version>16</Version>
</xListSettings>

I'm follow the code shown in Northwind tutorial Order Edit page.
All the Stored Procedure used tested work on Query Analyzer.

Thanks in advance.
You are not authorized to post a reply.
Forums > Bi4ce.Modules.ListX > Tips and Tricks > Adding Record not functioning


ActiveForums 3.6
Latest Post
 
At R2integrated (formerly Bi4ce), we take support seriously.  That's why we support our customers and DNN community with daily monitoring from our experienced engineering team.  We ask that the first step taken is to read the relevant documentation and support forums prior to submitting any questions that may already be available or have been answered.  We ask that you review the documentation that we provide for our products before posting a question.

The Forums are for our customers to chat, exchange ideas and strategies, and submit feedback.  Please be sure to perform keyword searches for previous related forum responses.

To be helpful when submitting a new item, please include the following: 
  1. DNN Version
  2. Module Version
  3. Admin Log Viewer Information
  4. Environment detail: Operating system, .NET framework version, database and version, IIS version, Browser version (if appropriate)
We always try to respond quickly and monitor the forums daily during business hours (EST).  Occasionally, requests for a specific project requirement may not apply for the free support offered. For project specific support please submit via our Information Request form.

Thank you for using our Forums.

Click here to register for the Forums
 
© 2008 by R2integrated (formerly Bi4ce) | DNN® is a registered trademark of DotNetNuke Corporation