•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 427,383 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,046 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP advertiser: Lunarpages ASP Web Hosting
Views: 1354 | Replies: 1 | Solved
 |
•
•
Join Date: Aug 2007
Posts: 98
Reputation: 
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
Hi,
Im trying to work out a way for users to be able to add new columns to tables in an SQL Server database through Dreamweaver.
I have tried using stored procedures but i keep getting errors. The user will choose which table they wish to add a column then give that column a name and datatype. I just cant get it to work so i tried to go back to basics and not use stored procedures but just code the SQL stating the tablename, columnname and datatype. This seems to work :-
how can I change this so the user can choose the table and then give the column a name and datatype? or even my next step... how can i change this so the user can just enter the tablename?
any ideas would be great!!!!! Ive been working on this for a long time and need to get it to work ASAP!
Thanks!
GLT
Im trying to work out a way for users to be able to add new columns to tables in an SQL Server database through Dreamweaver.
I have tried using stored procedures but i keep getting errors. The user will choose which table they wish to add a column then give that column a name and datatype. I just cant get it to work so i tried to go back to basics and not use stored procedures but just code the SQL stating the tablename, columnname and datatype. This seems to work :-
<%
set addcolumn = Server.CreateObject("ADODB.Command")
addcolumn.ActiveConnection = MM_Silverwingdatabase_STRING
addcolumn.CommandText = "ALTER TABLE dbo.customer ADD newcolumn VarChar(50)"
addcolumn.Execute()
%>how can I change this so the user can choose the table and then give the column a name and datatype? or even my next step... how can i change this so the user can just enter the tablename?
any ideas would be great!!!!! Ive been working on this for a long time and need to get it to work ASAP!
Thanks!
GLT
•
•
Join Date: Aug 2007
Posts: 98
Reputation:
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
Re: alter table add column through Dreamweaver ... need to get this to work ASAP! :(
#2
Jun 2nd, 2008
Sorted it myself! well... the table bit anyway but i think the rest will be quite straight forward now. I'll post this so anyone else who is having this problem can solve it.
You have to pass the variables from a form on another page like you would creating search page and results page.
code for form:-
form action points to the page with the asp command and stored procedure.
code for command:-
There may be other ways of doing this but after much frustration i found this way worked.
You have to pass the variables from a form on another page like you would creating search page and results page.
code for form:-
<form name="form1" method="post" action="TESTaddcolumn.asp">
<table width="50%" border="1">
<tr>
<td>Table Name </td>
<td><input type="text" name="texttablename"></td>
<td><input type="submit" name="insert" value="insert"></td>
</tr>
</table>
</form>form action points to the page with the asp command and stored procedure.
code for command:-
<%
Dim cmd_addcolumnTEST__tablename
cmd_addcolumnTEST__tablename = "1"
if(Request("texttablename") <> "") then cmd_addcolumnTEST__tablename = Request("texttablename")
%>
<%
set cmd_addcolumnTEST = Server.CreateObject("ADODB.Command")
cmd_addcolumnTEST.ActiveConnection = MM_Silverwingdatabase_STRING
cmd_addcolumnTEST.CommandText = "dbo.sp_addcolumnTEST"
cmd_addcolumnTEST.CommandType = 4
cmd_addcolumnTEST.CommandTimeout = 0
cmd_addcolumnTEST.Prepared = true
cmd_addcolumnTEST.Parameters.Append cmd_addcolumnTEST.CreateParameter("@RETURN_VALUE", 3, 4)
cmd_addcolumnTEST.Parameters.Append cmd_addcolumnTEST.CreateParameter("@tablename", 200, 1,50,cmd_addcolumnTEST__tablename)
cmd_addcolumnTEST.Execute()There may be other ways of doing this but after much frustration i found this way worked.
|
•
•
•
•
•
•
•
•
DaniWeb ASP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Previous Thread: web page generates document file
- Next Thread: how to code for retrive data from sql server 2003 to excel sheet by using asp
