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>
Here's what my code looks like...
View Replies View RelatedI have a table having 3 columns. There is a checkbox for each line. I
need to get those lines whose checkboxes are checked, and show those
lines to another webpage. Is there any way to do that? My concern is
that all information in the table are in <tb></tb> pairs without any
name tag. Any idea?
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?
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?
how to tell access to allow a zero length and put a default value now() in the date/time field in SQL?
View Replies View Relatedhow 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> ( ...
Can you create a table in an access database using create_table?
View Replies View RelatedCode:
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("mydb.mdb"))
'conn.Open "DSN=Survey"
Dim strSQL
' Creates a table called survey3
strSQL = "CREATE TABLE survey3 (Q1 text(20),Q2 text(20));"
conn.Execute strSQL
%>
This code works..But before I create the table I need to check if it exists and only if it doesn't i want to create it...How can i do it?
I need to create a new table in an Access Db for a Db driven Classic ASP website. My concern is that if I alter my local copy of the Db and then simply upload it, data might be lost if any of the users are logged in and posting stats.
Is there a way for me to write and execute some code to add to the Db? In PHP I usually use sql statements with the PHP MyAdmin interface, but I don't know of such a thing for ASP-does it exist?
I am having a problem using the SQL statement "CREATE TABLE" for an SQL Server database. The code works right in Access but when it did not work in SQL Server 7, I changed some of the datatypes to match an SQL Server 7 generated script. The problem is, it still does not work!
Now the first comments will probably be something like, "make sure your SQL user has permission," or, "make sure your connection string is correct." I have already tested that - the connection string works and I used the DBO (sa) user. Code:
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
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?
View Replies View Relatedhow 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.
View Replies View RelatedI 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??
I use ASP on a website and i'd like to create PDF files from HTML pages that are on the website. Which free software or component can i use to do this ?
View Replies View RelatedHow 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?
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?
I'm trying to dynamicly create a table in an existing ACCESS database. Code:
View Replies View RelatedI have a large database of reviews, and the asp processing slows down the server a lot when retrieveing the information. I want an asp application to generate an html page everytime a review is entered into the database so people view static pages.Anyone have a clue on how to do this, i've searched everywhere i cant find the solution.
View Replies View RelatedI need to be able to generate/create a html file. I know that probably the best way to do it would be to use PHP or CGI, but my server doesn't support either. Is there a way (and can you point me in the direction of some help) of doing it using ASP?
View Replies View RelatedI design auction templates and I need a way for my buyers to be able to fill out a form, click submit, and have a preview of the HTML template come up as well as the HTML coding so they can copy & paste it into their auction listing. Does that make sense?
I have NO experience with ASP programs but I was told by someone that this is what I need to get the results I am looking for. I do very well learning things on my own but this one has stumped me. I've spent many hours looking for any kind of tutorial or program that I could purchase.
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?
View Replies View RelatedI 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:
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.
Can someone explain to me or give me an example of how I would insert a row into an html table.
I will explain more so you understand what I am talking about.
I'm a newbie working on a dynamic website using asp.
I want to insert records dynamically. There is a command button insert when this is selected I would like a row added to my html table so the administrator can add his records.
The records will also be automatically updated to the original mysql table.
How would I add this row to my html table when the insert button is selected
I'm trying to figure out how to run a script on my server which will go over a few folders of Word documents, and create html pages out of them which I can then serve to my users. Preferably I want to do this without installing anything else on the server, hopefully it's achievable with a scripting language like VBscript/ASP?
I am used to web programming in PHP,Perl, Java, but for this I need to use ASP, on IIS. I've Googled & Yahooed and not come up with much.
On the first ASP page I have a form (checkbox) with 20+ different categories. After the user clicks on a few of them, they all have to be transfered on the second ASP page in HTML table. My problem:
If user selects only three categories, they should represent themselves in three differenst columns in my html table(something like Column-Name). If he selects 4, - four differesnt columns in the same table, etc.
So the table has to be 'dynamic'. It should have the same number of categories that the user selected on the first page. Could it be done? After that I should populate every category from a recordset and I know now how to do that.
I am planning to export data from SQL that generates HTML table. Instead of selecting the table and then copy then paste to word, I need a script(JS or VB) that will automatically export or open the Query to word.
View Replies View RelatedI have a dynamic html table. I want to write the code to edit rows in the table. Right now I can't change anything in the table. How do I make the rows so they can be selected and changed.
View Replies View Relatedi want to convert my txt file into a html table for display . But i dun want it to go through db .
View Replies View RelatedWe have a report in html Table form. When he gives print, say the table would take 5 papers to print, he wants the table headers in all pages. Is this possible? I calculated a A4 paper would be of 1090 pixels.
I thought if I could find the height of one table row, then I could do the paging easily. Could it be possible to find the height of a table row.
I have tried to edit table in html page with asp, but I havent succeeded in it. The pupose was to check with "if" function that does the variable fit into certain number array. For example:
if data1 < 100 then
"change the colour in a certain cell in a HTML table
end if
Is it possible to change with asp the properties in a html table? The purpose was to change the colour in a certain cell if the condition in the if function does not match. And if it is possible.. how I can point to a certain cell and change the colour in it.