User Name Password Register
DaniWeb IT Discussion Community
Home
Forums
Tutorials
Code Snippets
Blogs
Link Directory
White Papers
All
•
•
•
•
What is DaniWeb IT Discussion Community?
DaniWeb is a massive community of 370,573 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 2,021 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.
Join our community!
•
•
•
•
Showing results 1 to 40 of 98
Search took 0.01 seconds. Posts Made By: GLT
Save these search results for 24 hours
Page 1 of 3 1 23 >
Forum: ASP 24 Days Ago
Replies: 16
Views: 1,109
Posted By GLT
Re: creating order/order detail insert forms

thanks!

probably silly question but.... where abouts in my code do i put the retrieve code?
Forum: ASP 25 Days Ago
Replies: 8
Views: 693
Posted By GLT
Re: adding and searching newly added column...HELP PLEASE!!!!! :(

i dont really understand.. sorry!!! bit of a newbi!
Forum: ASP 25 Days Ago
Replies: 16
Views: 1,109
Posted By GLT
Re: creating order/order detail insert forms

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...
Forum: ASP 25 Days Ago
Replies: 0
Views: 337
Posted By GLT
help needed ASAP! please!.. what do i do next???

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...
Forum: ASP 26 Days Ago
Replies: 8
Views: 693
Posted By GLT
Re: adding and searching newly added column...HELP PLEASE!!!!! :(

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!
Forum: ASP 26 Days Ago
Replies: 8
Views: 693
Posted By GLT
Re: adding and searching newly added column...HELP PLEASE!!!!! :(

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 of...
Forum: ASP 26 Days Ago
Replies: 16
Views: 1,109
Posted By GLT
Re: creating order/order detail insert forms

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...
Forum: ASP 26 Days Ago
Replies: 16
Views: 1,109
Posted By GLT
Re: creating order/order detail insert forms

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 tell me...
Forum: ASP 27 Days Ago
Replies: 16
Views: 1,109
Posted By GLT
Re: creating order/order detail insert forms

I cant do it because ive never done it before... have to start somewhere somehow.
Thanks for your help! ill try that now.
Forum: ASP Jun 11th, 2008
Replies: 16
Views: 1,109
Posted By GLT
Re: creating order/order detail insert forms

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...
Forum: ASP Jun 11th, 2008
Replies: 16
Views: 1,109
Posted By GLT
Re: creating order/order detail insert forms

how would i do this? I thought only one insert was allowed per page??
Forum: ASP Jun 11th, 2008
Replies: 8
Views: 693
Posted By GLT
Re: adding and searching newly added column...HELP PLEASE!!!!! :(

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...
Forum: ASP Jun 4th, 2008
Replies: 16
Views: 1,109
Posted By GLT
Re: creating order/order detail insert forms

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

any ideas??
Forum: ASP Jun 4th, 2008
Replies: 16
Views: 1,109
Posted By GLT
creating order/order detail insert forms

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...
Forum: ASP Jun 2nd, 2008
Replies: 8
Views: 693
Posted By GLT
adding and searching newly added column...HELP PLEASE!!!!! :(

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...
Forum: ASP Jun 2nd, 2008
Replies: 1
Views: 882
Posted By GLT
Re: alter table add column through Dreamweaver ... need to get this to work ASAP! :(

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...
Forum: ASP Jun 2nd, 2008
Replies: 1
Views: 882
Posted By GLT
alter table add column through Dreamweaver ... need to get this to work ASAP! :(

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...
Forum: MS SQL May 27th, 2008
Replies: 9
Views: 1,531
Posted By GLT
Re: alter table stored procedure...???...

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...
Forum: MS SQL May 27th, 2008
Replies: 9
Views: 1,531
Posted By GLT
Re: alter table stored procedure...???...

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) =...
Forum: MS SQL May 23rd, 2008
Replies: 9
Views: 1,531
Posted By GLT
Re: alter table stored procedure...???...

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...
Forum: MS SQL May 23rd, 2008
Replies: 9
Views: 1,531
Posted By GLT
Re: alter table stored procedure...???...

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) =...
Forum: MS SQL May 23rd, 2008
Replies: 9
Views: 1,531
Posted By GLT
alter table stored procedure...???...

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...
Forum: ASP May 14th, 2008
Replies: 0
Views: 326
Posted By GLT
using joining 'line' database tables in Dreamweaver

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...
Forum: MS SQL May 14th, 2008
Replies: 1
Views: 258
Posted By GLT
using joining 'line' tables

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...
Forum: ASP May 9th, 2008
Replies: 8
Views: 673
Posted By GLT
Re: how do I upload a file into the database from dreamweaver?

yip, that link worked!

THANK YOU!!!! :)

GLT
Forum: ASP May 9th, 2008
Replies: 8
Views: 673
Posted By GLT
Re: how do I upload a file into the database from dreamweaver?

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'.
Forum: ASP May 9th, 2008
Replies: 8
Views: 673
Posted By GLT
Re: how do I upload a file into the database from dreamweaver?

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...
Forum: ASP May 8th, 2008
Replies: 8
Views: 673
Posted By GLT
Re: how do I upload a file into the database from dreamweaver?

Im using SQL Server and ASP
Forum: ASP May 6th, 2008
Replies: 1
Views: 418
Posted By GLT
asp and SQL Server

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
Forum: ASP Apr 30th, 2008
Replies: 8
Views: 673
Posted By GLT
how do I upload a file into the database from dreamweaver?

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
Forum: ASP Apr 30th, 2008
Replies: 1
Views: 619
Posted By GLT
Transfer data from one table to another in database with ASP

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...
Forum: ASP Apr 14th, 2008
Replies: 4
Views: 732
Posted By GLT
Re: adding new database tables and columns through dreamweaver???

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
Forum: MS SQL Apr 9th, 2008
Replies: 8
Views: 1,018
Posted By GLT
Re: add a new table to the database or add a new column to an existing table.

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...
Forum: MS SQL Apr 9th, 2008
Replies: 8
Views: 1,018
Posted By GLT
Re: add a new table to the database or add a new column to an existing table.

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...
Forum: MS SQL Apr 8th, 2008
Replies: 8
Views: 1,018
Posted By GLT
Re: add a new table to the database or add a new column to an existing 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...
Forum: MS SQL Apr 7th, 2008
Replies: 8
Views: 1,018
Posted By GLT
Re: add a new table to the database or add a new column to an existing table.

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...
Forum: MS SQL Apr 7th, 2008
Replies: 8
Views: 1,018
Posted By GLT
add a new table to the database or add a new column to an existing table.

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...
Forum: ASP Apr 7th, 2008
Replies: 4
Views: 732
Posted By GLT
Re: adding new database tables and columns through dreamweaver???

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

Any ideas would be great!

Thanks
GLT
Forum: ASP Apr 4th, 2008
Replies: 4
Views: 738
Posted By GLT
Re: the title attribute of the SELECT tag is not supported????

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...
Forum: ASP Apr 2nd, 2008
Replies: 4
Views: 738
Posted By GLT
the title attribute of the SELECT tag is not supported????

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...
Showing results 1 to 40 of 98
Page 1 of 3 1 23 >

 
Advertising Opportunities on DaniWeb
Contact Us - Newsletter Archive - Sitemap - Privacy Statement
All times are GMT -4. The time now is 5:11 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC