create table with ASP

<i><b>Originally posted by : Séverine (severine.chazot@vivalis.caisse-epargne.fr)</b></i><br /><br />Can you create table with ASP?<br />If yes, how?<br /><br />

<i><b>Originally posted by : helpyou (eludz@hotmail.com)</b></i><br />you can just use HTML embedding, which would be easier anyways... here is an example from http://www.asppipeline.com/codesamples/kl1/datatable.htm<br /><br /><table><br /><br /><%<br />' -- Loop through the employee records in the Recordset Object until End Of File<br />Do While Not MyRecordsetObject.EOF<br />%><br /><br /><tr><br /> <td><%=MyRecordsetObject("LastName") %></td><br /> <td><%=MyRecordsetObject("FirstName") %></td><br /> <td><%=MyRecordsetObject("MiddleInitial") %></td><br /></tr><br /><%<br />' -- Move to next employee record<br />MyRecordsetObject.MoveNext<br />' -- Continue looping<br />Loop<br />%><br /></table><br /> <br />your welcome.. now help me out with mine "I just posted it.. and seen that I could help someone else while I was waiting so that's cool.. and your welcome.. hope it helped... and don't ask about it anymore, because this is the easiest way to do it..<br /><br />------------<br />Séverine at 8/10/2000 8:14:06 AM<br /><br /><br />Can you create table with ASP? - YES!<br />If yes, how? - read above!<br /><br />

<i><b>Originally posted by : Doug Seven (doug.seven@codejunkies.net)</b></i><br /><br />Here is a sample of the code you need to create a table.<br /><br />FYI - This forum is for ASP+, not ASP.<br /><br /><%<br />Dim cn, sSQL<br />Set cn = Server.CreateObject("ADODB.Connection")<br />sSQL = "CREATE TABLE myTable (ID int PRIMARY KEY, Name varchar(10))"<br /> <br />cn.Open "driver={SQL Server};server=myServer;database=myDataBase;uid=sa ;pwd=myPWD"<br />cn.Execute sSQL<br />%><br /><br />The CREATE TABLE command will create a table named "myTable", with two columns, "ID" (integer, primary key), and "Name"(varchar10).<br /><br />Doug Seven<br />CodeJunkies.NET / ASPNextGen.com<br />doug.seven@codejunkies.net<br /><br />------------<br />helpyou at 8/11/2000 9:19:31 AM<br /><br />if you figure out how post it here.. or email it to me at eludz@hotmail.com thanks.. and sorry. I was off in space I guess.. all this reading is making me dizzy. <br /><br />------------<br />Sev at 8/11/2000 4:06:59 AM<br /><br />I want to create table in DB with ASP!!!!<br /><br /><br />------------<br />helpyou at 8/10/2000 11:08:57 AM<br /><br />you can just use HTML embedding, which would be easier anyways... here is an example from http://www.asppipeline.com/codesamples/kl1/datatable.htm<br /><br /><table><br /><br /><%<br />' -- Loop through the employee records in the Recordset Object until End Of File<br />Do While Not MyRecordsetObject.EOF<br />%><br /><br /><tr><br /> <td><%=MyRecordsetObject("LastName") %></td><br /> <td><%=MyRecordsetObject("FirstName") %></td><br /> <td><%=MyRecordsetObject("MiddleInitial") %></td><br /></tr><br /><%<br />' -- Move to next employee record<br />MyRecordsetObject.MoveNext<br />' -- Continue looping<br />Loop<br />%><br /></table><br /> <br />your welcome.. now help me out with mine "I just posted it.. and seen that I could help someone else while I was waiting so that's cool.. and your welcome.. hope it helped... and don't ask about it anymore, because this is the easiest way to do it..<br /><br />------------<br />Séverine at 8/10/2000 8:14:06 AM<br /><br /><br />Can you create table with ASP? - YES!<br />If yes, how? - read above!<br /><br />

<i><b>Originally posted by : Sev (eludz@hotmail.com)</b></i><br />I want to create table in DB with ASP!!!!<br /><br /><br />------------<br />helpyou at 8/10/2000 11:08:57 AM<br /><br />you can just use HTML embedding, which would be easier anyways... here is an example from http://www.asppipeline.com/codesamples/kl1/datatable.htm<br /><br /><table><br /><br /><%<br />' -- Loop through the employee records in the Recordset Object until End Of File<br />Do While Not MyRecordsetObject.EOF<br />%><br /><br /><tr><br /> <td><%=MyRecordsetObject("LastName") %></td><br /> <td><%=MyRecordsetObject("FirstName") %></td><br /> <td><%=MyRecordsetObject("MiddleInitial") %></td><br /></tr><br /><%<br />' -- Move to next employee record<br />MyRecordsetObject.MoveNext<br />' -- Continue looping<br />Loop<br />%><br /></table><br /> <br />your welcome.. now help me out with mine "I just posted it.. and seen that I could help someone else while I was waiting so that's cool.. and your welcome.. hope it helped... and don't ask about it anymore, because this is the easiest way to do it..<br /><br />------------<br />Séverine at 8/10/2000 8:14:06 AM<br /><br /><br />Can you create table with ASP? - YES!<br />If yes, how? - read above!<br /><br />

<i><b>Originally posted by : helpyou (eludz@hotmail.com)</b></i><br />if you figure out how post it here.. or email it to me at eludz@hotmail.com thanks.. and sorry. I was off in space I guess.. all this reading is making me dizzy. <br /><br />------------<br />Sev at 8/11/2000 4:06:59 AM<br /><br />I want to create table in DB with ASP!!!!<br /><br /><br />------------<br />helpyou at 8/10/2000 11:08:57 AM<br /><br />you can just use HTML embedding, which would be easier anyways... here is an example from http://www.asppipeline.com/codesamples/kl1/datatable.htm<br /><br /><table><br /><br /><%<br />' -- Loop through the employee records in the Recordset Object until End Of File<br />Do While Not MyRecordsetObject.EOF<br />%><br /><br /><tr><br /> <td><%=MyRecordsetObject("LastName") %></td><br /> <td><%=MyRecordsetObject("FirstName") %></td><br /> <td><%=MyRecordsetObject("MiddleInitial") %></td><br /></tr><br /><%<br />' -- Move to next employee record<br />MyRecordsetObject.MoveNext<br />' -- Continue looping<br />Loop<br />%><br /></table><br /> <br />your welcome.. now help me out with mine "I just posted it.. and seen that I could help someone else while I was waiting so that's cool.. and your welcome.. hope it helped... and don't ask about it anymore, because this is the easiest way to do it..<br /><br />------------<br />Séverine at 8/10/2000 8:14:06 AM<br /><br /><br />Can you create table with ASP? - YES!<br />If yes, how? - read above!<br /><br />