|
it
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Multiple Insert Help...I have a page that will populate information from a "reference" table
in the DB (SQL) like this: sku qty 123 10 111 10 222 10 333 10 This information will be different each time the page is visited based on the variable they submit. So next time it may show 20 records. My question is how would I go about inserting this data to the DB? Can anyone point me in the right direction to get me started? Mangler wrote on 09 nov 2007 in microsoft.public.inetserver.asp.general:
Show quoteHide quote > I have a page that will populate information from a "reference" table Use a <form> to send the data to the server.> in the DB (SQL) like this: > > sku qty > 123 10 > 111 10 > 222 10 > 333 10 > > > This information will be different each time the page is visited based > on the variable they submit. So next time it may show 20 records. My > question is how would I go about inserting this data to the DB? Can > anyone point me in the right direction to get me started? Name the elements of the formm logically by clientside script, allowing the user to enter a dynamic number of lines [records] composed of two fields. Receive the data using a serverside loop and drop each line [record] into the database. That's all. Now go and experiment. -- Evertjan. The Netherlands. (Please change the x'es to dots in my emailaddress)
Show quote
Hide quote
On Nov 9, 10:23 am, "Evertjan." <exjxw.hannivo***@interxnl.net> wrote: Thank you. Thats all I was looking for bc if I know the process like> Mangler wrote on 09 nov 2007 in microsoft.public.inetserver.asp.general: > > > I have a page that will populate information from a "reference" table > > in the DB (SQL) like this: > > > sku qty > > 123 10 > > 111 10 > > 222 10 > > 333 10 > > > This information will be different each time the page is visited based > > on the variable they submit. So next time it may show 20 records. My > > question is how would I go about inserting this data to the DB? Can > > anyone point me in the right direction to get me started? > > Use a <form> to send the data to the server. > Name the elements of the formm logically by clientside script, > allowing the user to enter a dynamic number of lines [records] composed of > two fields. > > Receive the data using a serverside loop and drop each line [record] into > the database. > > That's all. > > Now go and experiment. > > -- > Evertjan. > The Netherlands. > (Please change the x'es to dots in my emailaddress) you provided I can play with the rest trying to make it work. Helps me learn better although it gets frustrating sometimes. As always man thanks!
Other interesting topics
aspexec is not working in IIS 6.0
Automated Email How much is Application Data Need basic help authenticating remote wmi call from an asp webpage print page script - login problems BLOB to MS Word via ASP/VBScript PSEUDO WEB SERVICES CALLING OTHER SERVICES how to find quoteint in asp ASP CDO mail only works when browser cache is cleared NT Domain Account |
|||||||||||||||||||||||