GLT

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:- [code] ALTER TABLE tablename ADD COLUMN columnname columndatatype [/code] I have tried to insert this SQL into a stored procedure:- [code] CREATE …

Hi, I am a student on my year work placement and I have been asked to develop a web based database for a company. I think my design is ok but I am a bit confused in a part... The company wish to save emails in the database to and …

Hey Guys! I am having trouble getting my insert and login pages to work and I wondering if any of you had any ideas?? please!!! I need to get this working asap! I have followed directions to get the login page to work and used user authentication server behaviour. When …

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

Hey guys! I seem to be posting here a lot the past few days but as I am new to SQL Server I am finding to quite a pain to get used to! I am having a problem referencing foreign keys. I did post another thread about this but this …

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 table to solve the many to many relationship between the order …

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? I have used dynamic tables for displaying my results, I thought this …

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 LOGIN error. I solved this by devloping the application connecting to a locally saved …

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 …

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 solve the many-to-many relationship between some tables but now i am having trouble using them. I have …

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 solve the many-to-many relationship between some tables but now i am having trouble using them. I have …

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. 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 but I have no idea how. I am using ASP and …

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 new table to the database or add a …

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 contains every one, one for each user when i view this in firefox. …

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 new table to the database or add a …

Hi guys! I was wondering if any of you guys would be able to help solve what is probably a simple problem.... I am using dreamweaver / asp/ access to create a dynamic web application. I have created a record set which queries the database and displays the results. The …

When I try to view the page I have just built in Dreamweaver in the Browser I get a message saying 'Invalid Syntax error'. Is there something I need to do before I view the page?? GLT

Hey guys, I am developing a web based database for a company for my year work placement from university. I was wondering if anyone knew a way of retrieving the user ID from the database through the web page? Each table in the SQL Server database has an automatic Identity …

Hi guys, Sorry if I have started his thread in the wrong forum, I couldnt find a dreamweaver one. I am creating a web based database and I am having a little bit of trouble creating a login page. I know that this is quite basic and I know there …

Hi guys! Im am setting up a login page using Dreamweaver MX but I cannot set up my testing server. I need to set up my testing server to use the server behaviours. I have a little tick beside 'create a site' and 'choose a document type' but cannot get …

Hi guys! Im am setting up a login page using Dreamweaver MX but I cannot set up my testing server. I need to set up my testing server to use the server behaviours. I have a little tick beside 'create a site' and 'choose a document type' but cannot get …

Hi guys! I was wondering if comeone could help me with transferring data from one table to another. I am storing information of all customers who make an enquiry (PotentialCustomers) then transfering their details into a Customers table if they decide to purchase something from the company. How would I …

Hi, I am on my work placement where I have been given the job of developing the company's web based database. I am very confused as in university I have only learnt the basics and the company are expecting a lot more of me so I have been trying to …

Hi guys, I have two tables one for that holds Customers details and one that holds Potential Customers details. The Potential Customer table is needed so the company can see who has enquired about the products but not bought them. I need to be able to automatically transfer details from …

my second thread of the day... hey guys, I was wondering if someone could help me. I am new to SQL Server therefore new to T-SQL, I have worked with SQL before. I am trying to reference foreign keys when creating tables. The code I have in SQL is :- …

Hey guys! I am new to SQL Server and as I am still a student I have never created a database completely from scratch before. I believe that at the very start of development I have to create the database with the following code:- [I]CREATE DATABASE <database name> [ON [PRIMARY] …

Hi guys! I've never used SQL Server before and I don't want to fall at the first hurdle. SQL Server is installed and connected to the server but how do I go about actually creating the database? I am developing a web based database using dreamweaver and asp.net. Do I …

Hi Guys, I am developing a Web based database for a company for my year work placement for university. As I am still a student I am still learning and finding this difficult. I am looking at designing a login page using ASP, the code I have is:- [I]<%= sErrorMessage …

Hi guys! I am developing a web based database for a company for my year work placement for university. As I'm still a student I am still learning so I am not 100% on what i am doing. I was wondering if someone could provide me with some help?...please! :) …

Hi guys! sorry if there is already a thread on this but i couldnt see one... I just want a little bit of help about the statement ON DELETE CASADE. I am designing the structures of my tables and I am not sure about using this statement. I know it …

Hi, I am a student on my year work placement and I have been asked to develop a web based database for a company. I think my design is ok but I am a bit confused in a part... The company wish to save emails in the database to and …