5/5/2024 1:31:15 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss building external web applications for SalesLogix. View the code of conduct for posting guidelines.
|
|
|
|
updatecommand help
Posted: 13 Dec 08 12:47 PM
|
It looks like slx ignores the updateparameters and so I am left with using ? to substitute my parameters and I cannot figure out how to ignore some of the parameters or where slx gets the order from. The update statement in slx profiler looks like:
update opportunity set description = [DBTYPE_STR,"Concepts-Phase1"], estimatedclose=[DBTYPE_STR,"1/30/2009 7:00:00 PM"] where opportunityid =[DBTYPE_STR,"T"][DBTYPE_STR,"O6UJ9A000002"]
but as you can see there is an extra parameter tacked onto my oppid.
Any help would be appreciated.
Here is the asp:
DataSourceID="dsOpps" HeaderText="Edit Project" ID="oppDetails" runat="server"
Width="275px" OnItemUpdated="oppDetails_ItemUpdated" OnModeChanging="oppDetails_ModeChanging">
ProviderName="<%$ ConnectionStrings:myportal.ProviderName %>"
SelectCommand="SELECT a.opportunityid, shipcommission,description,isnull(estimatedclose,'') [estimatedclose] FROM opportunity a inner join c_opportunity_details b on a.opportunityid = b.opportunityid WHERE a.opportunityid = ?"
UpdateCommand="update opportunity set description = ?, estimatedclose=? where opportunityid =?">
<selectParameters>
</selectParameters>
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|