ASP :: ASP + SQL Create Table For SQL Server

Create Table
I know I can Create Tables In a database with the CREATE TABLE sql statment, but I don't exactly know the syntax of the statment.

I want to add a table with a sertin feild that has a default value, is that possible?

The syntax I know is:

sql = "CREATE TABLE tablename(feildname FEILDTYPE,feildname FEILDTYPE...)"

Are there any other parameters that I can add to the statment?

CREATE TABLE
I'm writing an ASP app to create a table in an MS Access database. I use:

Code:

sql = "CREATE TABLE success(name text (50), company text (75), article memo (), img text (50))"

and get a syntax error. When I remove the "article" field and param, it works. Even when I add a max char param inside the parenthesis

Code:

article memo (255),

I get the same error. Doesn't the "memo" data type allow unlimited charactors? If so, is there a param that I need to add to the memo () call?

Create Table SQL
how to tell access to allow a zero length and put a default value now() in the date/time field in SQL?

Create Table In MS
how to create new table which the table's name is variable. for example: i want to create table with the name is come from user's input in the form input.

create table <table's name variable> ( ...

Create Table
Can you create a table in an access database using create_table?

Asp Create Table Problem
I am trying to use asp to create a new table in an existing database and I keep getting this error:

Microsoft JET Database Engine error '80040e14'

Syntax error in CREATE TABLE statement.

/install.asp, line 75

What would cause this?

Here is the code I am using:

Code:
cnn.Execute("CREATE TABLE crosssale (prodID "&txtcl&"(50) NOT NULL,related "&txtcl&"(50) NOT NULL, PRIMARY KEY(prodID,related)")
By the way txtcl equals:
txtcl = "TEXT" 'access
or
txtcl = "NVARCHAR" 'sql

Create Table Query
In the same way that you can create and alter permanent tables in Access 2000 using SQL in ASP ( CREATE TABLE <tablename> col_1(col_1 datatype), col_2(col_2 datatype....Col_n(col_n datatype)) is there any way to do this for Queries?

CREATE TABLE IN ACCESS
how do you create a table in MS Access from with an asp script? I will be creating the table name from Request.querystring("name"), also needs fields of branchname and branchcode. guess something like CREATE TABLE & Request.querystring("name") branchname. branchcode.

Create Html Table From Rs
how do i create a td for each field in my rs, with out labeling them. this is what i have, not sure if i'm heading in the right direction or not.

Code:

<table>
<tr>
<%Do while not rs.eof%>
<td>
<%= rs ('insert rs name'<<<<???)%>
</td>
<%rs.movenext
loop%>
</tr>
</table>

Create A Table Thru Asp Script?
I have MS SQL Server as database. i want to create a new table in the DATABASE, through asp script, naming table's name and naming the fields with their data types.

Can i do this through an asp script, like it can be done through Database tools like Enterprise Manager??

Create Tables From Values In Another Table
How can I loop through the values of one MSACCESS table to display the related records from another table? I have one table with two single field records. The values are 4 and 9. These fields are related to another table which contains records that belong to either 4 or 9.

I want my web page to display a table for all records belonging to 4 and then another table of all records that belong to 9. I could specify either 4 or 9 in different record collections but the 4 and 9 could one day be 1 and 5 and I don't want someone to have to get into my code to change the 4 and 9 to 1 and 5 in my sql queries. Any advice?

For Every Record Is Table A, Create 1 In Tables B,C, And D
I need to do a simple but complex thing...

For every record is my users table, I need it to creating a record in 3 tables, with one value (all the same)...

So, in detail:

1 users table

Need to create a record in 3 other tables with the userid from the record it added...

e.g.

From record 1 in Table A, create a record in Table B, C, and D with the value of field 'userid' the value of the 'userid' field from Table A...

Get it?

Sql CREATE TABLE Syntax Error
I'm trying to dynamicly create a table in an existing ACCESS database. Code:

Complete Function To Create Table And Columns
I have been looking everywhere, and can't find a complete function to create tables and columns in access .mdb from ASP, while adding columns that are missing in tables that already exist, can anyone post a link or the code to such function?

Create Recordset, Loop, Update Second Table
I am in the process of rewriting my table formats for an Access Project that was created. I now need to get the data from 1 table and transfer to a second table.

I created a page that creates the record set, I then loop through that record set and need to run an update statement to a second table, however, I get the following message:

Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
/BusPlanTest/updBusPlan.asp, line 17

Below is the code I am using: Code:

Create Table With Username And Write To It With Results From Form
I have an asp page that gives results for a search from a previous page from streetguide.streets in MySql. The page displays the UserName of the person logged in.

I have the results of this query displayed inside a form with hidden variables. When the user clicks "save to my folder" I want it to create a table in the mysql db with the same name as the user name, and then write to this table.

I have it working if I created the table beforehand, but I want the table to be created dynamically upon form submission with the table name to match the persons user name.

How Many Max Cookies Can We Create In Server
How many Max Cookies can we Create in Server.

Create Csv And Upload Thru Ftp Server
I want to generated a csv file from sql server table, in which I would like to create a asp page which display a field list with a check box.

Then whatever check box I selected, and click on generate button, then a CSV text fill will generate depending on sellected field with the field header and uploaded to FTP server.

How Can I Create New Folders On The Server Which Allows Anonymous Upload
How can I create new folders on the server, via ASP programming, which automatically allows by any user:

1. Files to be browsed
2. Anonymous upload to this directory
3. Allow uploaded files to over-write the existing file

I use the following ASP codes to create new folders, but all above options are off and I cannot e.g., upload (via ASP programming) to upload a file in the new directory because the option is off.

Set fs = CreateObject("Scripting.FileSystemObject")
set b = fs.CreateFolder(newFolder)

Dynamically Create Subdomains, Or Folders On Server
I need to dynamically create subdomains, or folders, on my site. I am currently developing a portal where when the person registers he/she gets their own sub-domain on my site. Either that or I need to create a subfolder for them on the site. I am developing in ASP and need some advice/help urgently.

Sql Server Table
I have an asp page with a table filled with data from sql server table. I want the user to be able to update the records in this page itself. for example, if user clicks on a cell, it should allow the user to change the content and then be able to update the sql table with these new updated values. I know there is this editable content feature to use to make a cell editable, but iam kinda stuck on how to retrive the updated values and insert/update them to the sql table.

SQL Server Table Date?
Is there a way to find and display the creation or last modified date for a SQL server table? I want to put a date on my site of when the table was last updated. I am using ASP.

Pulling Data From SQL Server Table
I have a table with 30 or so columns. I'm pulling the data and putting them into variables like so:

objRS.Open query, db
UserID = objRS("UserID")

That's obviously not including the db conn info or even the query itself. Rather than manually typing out each and every variable and pulling the data from the RS object, is there a function that will automatically store all the data from the RS into its respective variable? I'm basically just lazy and the carpal tunnel kicked in after 10 or so variables.

How To Transfer Records From One Table Of A Database To Another Table In Another Data
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?

<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2

Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open

startdate=request("tarikh1")
enddate=request("tarikh2")

MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....

Table Inside A Table Update To DB
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??

Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:

Copying From Table 1 Inserting In Table 2
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:

Bookmarking A Position In A Table <table>
Have an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page.

Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.

How To Get Data From A Table Into A Table Form?
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:

Best Method Of Updating Table From 2nd Table
I have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.

Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.

Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.

Record Set For Id From Table 1 To Table 2
Hello I have a page for registering users.

I am reciveing this error:

The following errors occured:
- An error occured. -2147217904 : No value given for one or more required parameters.

there are students and teachers. therefore I have 3 tables one for logins and one for staff and on for students.

I have a form designed to capeture the need information.

in the code I am runing an if and elseif statmetn to determin the tables. I then insert the userid and password into the login table.

then i enter the remaining information into ither the staff or student table. what i am trying to do is select the perimary number that is generated as the userid and passeword are enterd. and add this to the second table. Code:

How To Make Column Of Table 1 = To Column Of Table 2?
I want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:

Create A PDF From ASP
Is there anyway to generate a PDF using ASP Scripting(VB Script).

Create Pdf
Does anybody knows a way (free of cost, code or dll) to generate pdf?

Create Url
I use a website in asp for which I have to type a username and
password everytime I want to login.
On the form are two fields for typing the username and password and
one button LOGIN.
I want to create an standard url for the website which includes my
username and password so I don't have to type it in everytime.

I looked at the page source but I can't find the right string.
I thought maybe http://.........aspx?username=me&password=it

but that doesn't work.

Create PDF
Is there a (simple) way to create a PDF file from ASP?

Cannot Create A Asp
I have 2 developper machine running visual studio 2003 and Windows 2000. On the first machine (Machine A) I may create a new asp project without problem. On the second (Machine B) I cannot create a new project.Visual Studo create the project but not the initial files and freezes.

But I may create a new project from Machine A using the web server of machine B.I have checked the access rights of both servers, the access rights on directory wwwroot and inetpub.Everything seems the same.

Create A TGP In ASP
Has anyone seen or know if anyone has done this? I think that ASP would be a great tool to do this with but I am curious if anyone has tried it and found it to be too hard or too burdensome to follow through with?

[Microsoft][ODBC SQL Server Driver][DBNETLIB]"The SQL Server Does Not Exist Or There Is No Permission
I have sql server express at my PC-windows xp professional, I try to connect to a table via asp (queryString :"Driver={SQL Server};" &"Server=localhost;" & _
"Database=local;" & "Uid=nikos;" & "Pwd=nikos;" but there is an error
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]"The SQL server does not exist or there is no permission.

I can login with EMS lite both with sql server Auth. and windows auth.What is fault?

Server Object Error 'ASP 0177 : 800401f3' Server.CreateObject Failed
I'm trying to install a simple e-mail form to my webpage; which takes some info from user (like name, phone, e-mail,etc...) and when user pushes submit button e-mails them to me immediately. I've tried to do so with ASP Formmail but I couldn't succeed. . it gives me: Server object error " 'ASP 0177 : 800401f3' Server.CreateObject Failed " error. Can anyone please help me to install my form? Because I need to install it immediately;

How To Read An SQL Server Into A ASP Page And Then Change, Add, Delete And Write It Back To SQL Server
I need to read a SQL Server table into a Web Page and within the Web
Page to permit my users to make changes to the records, delete or add
new records and then save the entire contents back to the SQL Server
table back.

The functionality I am looking is almost the same as In the SQL
Enterprise Manager whereby I can choose a table open the table and
then return all rows and I can maintain the same and save it back to
the SQL Server table. I want almost a similar web interface to such a
functionality.

Even if not a generic functionality as the SQL Enterprise Manager
table maintenance appreciate if somebody can share the code with a
sample how I can do it in ASP pages + T-SQL if need be.

Server.CreateObject Error: Server Object, ASP 0177 (0x800401F3), Invalid Class String
What do I need to do to enable CDONTS om my macine to make it working

I'm testing the code:

Dim objCDO
Set objCDO = Server.CreateObject("CDONTS.NewMail")
objCDO.To = "xyz@xxxxx.com"
objCDO.From = "zyx@zzzzz.com"
objCDO.Subject = "TESST CDONTS MAIL"
objCDO.Body = "SOME TEXT TO SEND OVER"
objCDO.Send
Set objCDO = Nothing

It gives me an error after Set objCDO =
Server.CreateObject("CDONTS.NewMail")
Server object, ASP 0177 (0x800401F3)
Invalid class string

Sending Email By Using Corporate Exchange Server Instead Of Local Server
I have created a form that sends email thru my local server. What I want to do is send the email thru our corporate Exchange server. Does anyone know how I can accomplish this task? Please advise. Thanks.

P.S. I’m using Dreamweaver MX2004.

The code that sends email is shown below ....

Create New User Using IIS/ASP
I'm running IIS5 on a Win2K server, and I want to have an ASP page that
creates new users. I have some simple code to test this, but am getting
a "500" error when I run it. The ASP looks like:

<%

strDomain ="Foo.com"
strUser ="Foo1"

' Create new user with password
Set oDomain = GetObject("WinNT://" & strDomain)
Set oUser = oDomain.Create ("User", strUser)
oUser.SetPassword = "password"
oUser.SetInfo
%>

Just for this testing, I've added IUSR_machinename to the Administrators
group, but am still getting the 500 error.

Create Object & DAO
how to create dao.tabledef object in asp:

I need to convert the following code into asp:
Dim tdf As DAO.TableDef
Dim db As DAO.Database
Dim fld As DAO.Field

Set db = OpenDatabase("C:Mydb.mdb")
Set tdf = db.TableDefs("Table1")
Set fld = tdf.CreateField("Field2", dbText, 10)
tdf.Fields.Append fld

Create Hostheader With ASP
Is there a way to create a host header in IIS with an ASP?

How Can I Create A Guestbook?
I want to create a web page for my friends.(I have a subdomain and my server supports ASP scripts) It will contain a small basic guestbook.It must write the entries to a text file on the server.And i must be able to view the guestbook.

Create ASP File On The Fly
I'd like to create ASP file on ther server side. Can I use
fso.createtextfile("c:folder est.asp")
Do I need to create a folder too?

Trying To Create A Menu With ASP
I am trying to create a menu with multiple tiers. I want to use the one menu as an include file throughout the site. Depending on what page you are on, I want the 2nd and third tiers to show up.

The rest just show the tier 1 links. I'm pretty sure this can be done in CSS, but the problem is that with a very big menu, I'd rather not have to load up the entire menu when it all won't be showing.

There for I figured I could create it in ASP. I could set some sort of parameter in the page so the menu include file would know what page I'm on, and then would only show and load the 2nd and 3rd tiers of that section. Is this possible? Code: