There are some tutorials on [url]www.charon.co.uk[/url] that show how to code multiple
inserts but they are ASP based. You could adapt the code for ASP.Net but it
would mean not using the MM:Insert tag.
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
Team Macromedia Volunteer for Ultradev/Dreamweaver MX
"payado" <webforumsusermacromedia.com> wrote in message
news:d7072v$44q$1forums.macromedia.com...trucks> I built an application on an Access DB that allows a dispatcher to logtruck),> in the field at their location as they call in. There are three backend
> tables, Codes (for calling in on the radio), Trucks (for each uniquehaving> and Events to log the truck at location with a code. The problem I amlist.> is I would like to use a CheckBoxList for the dynamically generated truckin the> That would allow the dispatcher to log more than one record with one
> Does anyone know an easy way to insert a record for each truck selectedentered for> checkboxlist? It will use the same data from codes and whatever isAccess.> location upon submission. I cannot use a stored procedure because ofway> Can I loop the insert that Dreamweaver creates? Does anyone know a betterNotes)> to do multiple inserts into a table using a checkboxlist?
> Following is what Dreaweaver has generated for the Insert:
> CommandText='<%# "INSERT INTO tblEvents (TruckID, CodeID, Location,System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_STRING> VALUES (?, ?, ?, ?)" %>'
_conSystem.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_DATABA> nRadioLogASP") %>'
SETY<>> PE_connRadioLogASP") %>'
> Expression='<%# Request.Form("MM_insert") = "form1" %>'
> SuccessURL='<%# "index.aspx" %>'
> Debug="true"> <Parameters>> >
> <Parameter Name="TruckID" Value='<%# IIf((Request.Form("TruckID") <>
> Nothing), Request.Form("TruckID"), "") %>' Type="WChar" />
> <Parameter Name="CodeID" Value='<%# IIf((Request.Form("CodeID") <>
> Nothing), Request.Form("CodeID"), "") %>' Type="Integer" />
> <Parameter Name="Location" Value='<%# IIf((Request.Form("Location")> Nothing), Request.Form("Location"), "") %>' Type="WChar" />
> <Parameter Name="Notes" Value='<%# IIf((Request.Form("Notes") <>
> Nothing), Request.Form("Notes"), "") %>' Type="WChar" />