thanks!

probably silly question but.... where abouts in my code do i put the retrieve code?

i dont really understand.. sorry!!! bit of a newbi!

ok start again....

I have an order table and an order detail table (called HireOrderEnquiry and HireOrderEnquiryLine).

I want to insert the ID that is automatically generated when details are...

Hi,

I had a problem a while ago when i was developing my web based database application. I was developing locally but the database was saved on a different server. I got a NT AUTHORITY/ ANONYMOUS...

once i add a new column to the DATABASE table through my application i need the HTML table and insert form to somehow refresh to include this new column.

Sorry for confusing you!

Thanks for getting back to me!

yeah i understand that i would have to refresh the table somehow but how would i do this so the it will automatically do it if the user adds a new column? Im a bit...

I tried using a stored procedure to insert and retieve the ID. here is what i have:-

stored procedure:-

CREATE PROCEDURE spInsertRetrieveID
-- Add the parameters for the stored procedure...

Hi!

I cant seem to get it to work. I am a newbi to this sort of thing so im not sure exactly where to put this code or how to edit it (if at all) for my page.

Can someone please help me and...

I cant do it because ive never done it before... have to start somewhere somehow.
Thanks for your help! ill try that now.

if i did use the method you suggested it would not solve the ID problem which was the original problem. I need to add the ID of the order that has just been entered into the orderline table as a...

how would i do this? I thought only one insert was allowed per page??

yeah i mean column...
I know how to enter a new record but the company wants to be able to add a new column to tables in the database if needed... i dont really understand but trying to do as im...

would use a stored procedure to join and insert the ID into the details table??

any ideas??

Hi guys!

I have an order table and an order detail table in a database. I am trying to create insert forms using ASP for these so the user can insert new order details. I created an order details...

Hi guys!

I just worked out how to add new columns to my database tables through dreamweaver i was wondering if anybody knew of a way of now searching for and getting the data from the new column?...

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...

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....

Sorry for making you pull your hair out! :$
You've been a great help!

What i have now is:-

CREATE PROCEDURE sp_addcolumn
-- Add the parameters for the stored procedure here
@TABLE_NAME...

what i have now is:-

CREATE PROCEDURE sp_addcolumn
-- Add the parameters for the stored procedure here
@TABLE_NAME VARCHAR(50) = 0,
@columnname VARCHAR(50) = 0,
@datatype VARCHAR (50) =...

I keep getting the same error. I tried taking the datatype part out and putting an actual datatype in the code but i got this:-

"Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)...

Thanks for your quick reply!

I now have this:-
CREATE PROCEDURE sp_addcolumn
-- Add the parameters for the stored procedure here
@TABLE_NAME varchar(50) = 0,
@columnname varchar(50) = 0,...

Hi,

I am trying to create a stored procedure to add a new column into a database from an ASP web application.

The SQL Code for this is:-

ALTER TABLE tablename
ADD COLUMN columnname...

Hi guys,

I am a student on placement and I have created a database for a company. This database contains customer details, enquiries, orders and product details. I used joining 'line' tables to...

Hi guys,

I am a student on placement and I have created a database for a company. This database contains customer details, enquiries, orders and product details. I used joining 'line' tables to...

yip, that link worked!

THANK YOU!!!! :)

GLT

Thank you, however... in the tutorial it says that you will need a copy of the uploading component and gives a link to this but when i clicked on the link it said 'file not found'.

well i dont really know. I am student on placement and i have been asked for a way for the company to upload files of drawings etc of the equipment they sell so they can be accessed by customers. I...

Im using SQL Server and ASP

Hi guys,

I was wondering if someone could help me please.
How do i query the database using ASP and Dreamweaver to return the field names of a table?

Thanks!
Any ideas greatly appreciated.
...

how do I upload a file into the database from dreamweaver? I have used a file field in the form but will this automatically upload no problems?

cheers!
GLT

I wish to transfer data from a potential customer table to a customer table in my database if and when they become a customer and not just an enquiring customer. I need to be able to do this simply...

Thank you for getting back to me!
I do know the SQL for creating a table but how would I go about coding ASP to create the table? I am a bit confused of how to link it all together.

Thanks GLT

Ive been having aply with my code and trying to find information on this. It looks like I have to use dynamic SQL which I have never used before. Here is the SQL code I have now:-

CREATE PROCEDURE...

Hi, Thanks for you help!

This is what ive got so far... it may be completely wrong but am I on the right lines??

stored procedure:-

CREATE PROCEDURE sp_createtable
AS
CREATE TABLE...

Thank you,

I'm using ASP with SQL Server 2005. The web based database that I am developing will hold details of the companies products and customers, their orders and enquiries. I have developed a...

Hi thanks for replying!

I do know the SQL for creating and altering tables but I was wondering if anyone had any idea how I would get information from a form or something in dreamweaver to then...

Hey guys!

I was wondering if anyone could help me. I am a student on my work placement year and I am developing a web based database. I have been asked to design it so users can if need be add a...

anyone any ideas?? really need to know how to do this!

Any ideas would be great!

Thanks
GLT

Hi, Thanks for getting back to me.

I moved the input line above and below the select bit but that just created an input box above or below the drop down box depending where i put it.

Any other...

I created a user registration page using ASP and Dreamweaver, I tried to create a drop down box filled with options from a database. I only wanted the box to contain one of each option but it...