I need to create a table with 4 cols and X rows based on the number records
in my database. I dont know how this can be done, mabye with an array?
If I got for example 6 records in my database, a table with 4 cols and 2
rows should be generated, the last row will only have 2 cols with
information... Code:
Anyone have any advice on getting a recordset of all tablenames in a database? I have an access database that I am constantly adding tables to.
I want to have code that will lookup all tables and populate a selectbox with the tablenames so that I can click to look at each table individually.
I am using ASP to generate an HTML table from a database. I use FSO to output a file with an XLS extension then open it. I can set the column width and row height; I can set the font family, size, and weight. I know I can include formulas in a "cell".
What else can I do when I generate the table that will take effect when the file is opened in Excel? I'd like to do things like autofit and sorting. The client does allow Office Automation on the server so I can't write to Excel directly.
Im running a select statement to a database and wish to display the relevant records into a table. For some reason, its not liking this - can someone see why, and or tell me an easier way to produce an 'automatically generating' table of results.
<% @language="vbscript" %>
<% Option Explicit %>
<% Response.Buffer=True %>
<html>
<head>
<title>Search Results</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<!-- #include file="dbConn.asp" -->
<!-- #include file="adovbs.inc"-->
<h1>Your search results returned the following popup messages:</h1>
<% Dim msgtype, title, message, url
msgtype=request.form("type")
title=request.form("title")
message=request.form("msg")
url=request.form("URL")
Dim adoDB, adors, strSQL
set adoDB = Server.CreateObject("ADODB.Connection")
adoDB.Open strConnection
set adoRS = Server.CreateObject("ADODB.RecordSet")
strSQL="SELECT PID,P_TITLE,P_MSG,P_URL,P_TYPE FROM POPUP WHERE ("
If msgtype <> "" then
strSQL=strSQL & "P_TYPE='" & msgtype & "' "
If title <> "" then
strSQL=strSQL & "OR P_TITLE LIKE '%" & title & "%' "
If message <> "" then
strSQL=strSQL & "OR P_MSG LIKE '%" & message & "%' "
If url <> "" then
strSQL=strSQL & "OR P_URL LIKE '%" & url & "%' "
End if
strSQL=strSQL & ")"
'DEBUG ONLY!!
'response.write strSQL
'response.end
adoRS.Open strSQL, adoDB
' Loop through the recordset to display the records
Do While Not adoRS.EOF
& " <tr> " &
& " <td> " & Response.Write adoRS.Fields("PID").Value & " </td> "
& " <td> " & Response.Write adoRS.Fields("P_TYPE").Value & " </td>"
& " <td> " & Response.Write adoRS.Fields("P_TITLE").Value & "</td>"
& " <td> " & Response.Write adoRS.Fields("P_MSG").Value & "</td>"
& " <td> " & Response.Write adoRS.Fields("P_URL").Value & "</td></tr>"
adoRS.MoveNext
Loop
& " </table> " &
' Tidy up afterwards
adoRS.Close
Set adoRS = Nothing
adoDB.Close
Set adoDB = Nothing
%>
</body>
</html>
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 ....
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
how I generate a new XML file that I can then use with an XSLT file. I am trying to use an XML file generated from Microsoft Project or even better generate an XML file from the project file (MPP File) itself. Which I can then use with an XSLT file
I am new to XML and want to create a project viewer using XML, ASP and XHTML. I have an idea of how this should work but would really appritiate any help someone can offer. Is it possible to take an XML file and generate it in ASP without using an XSLT file??
I've been trying to Google this but have been getting far too many hits to be of use. Is there a slick way to generate a CSV or other Excel-friendly format and push it to the client? I'm using VBScript (and HTML and other typical stuff of course) on the ASP pages (no .NET stuff). Just a shove in the right direction is all I really need here.
View Replies View Relatedhow can i generate ID(automatically) when user press the "New Record" button in my registration pages.the ID will get from the existing database and start with C01234.let says the last id in database is C01234,then when the New Record is entered,then the id number will change to C01235.
View Replies View RelatedI noticed that PHP have the ability to create PDF files without using any third partty componentys. Most notably is via FPDF. It generates PDF by using "pdf markups" / or ghostscripts .
I believe the same can be done via ASP too. One has to use response.write pdf headers. Has anyone succeeded in doing that? I have the intention to go thru PHP's FPDF and try to convert that to VBScript.
I trying to generate a new XML file everytime a user post a value through a simple form.
The form has one textfield called "price" and I want to save a new XML file (rewriting the file if the case) using the value entered. I don't want to append the value. I saw many turorials, but none of them work for me, and everytime I try to edit them, nothing seems to work.
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:
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:
View Replies View RelatedHave 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.
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:
View Replies View RelatedI 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.
Can you tell me how to generate a GUID value in ASP?
View Replies View RelatedI want to create an Excel object from an ASP page. Basically, the input parameters to the Excel would be from the ASP. I know ASP and I know VBA, but I haven't used both of them together. Here's what I would like to do -
The ASP should generate an Excel report by passing 2 parameters to the Excel application (I have done this independently; without interfacing with ASP).
I know that I can create an excel handle from the ASP as -
Set MyExcel = Server.CreateObject("Excel.Application")
I dont know where the VBA code has to go? DO I have to include it in the ASP?
I have a web page using frameset split into few pages. And I want to generate one page of HTML code and send it through email. My question is have to generate a HTML page using asp?
View Replies View RelatedI want to be able to generate a date (day,month,year)
and add it to a DB so as to prove when a record was added(when a transaction was completed)I then want to delete a record automatically 1 day after the date was generated.
I have a form which contains drop down box with several available selections. Based on the users selection, I would like to have a popup box appear upon the form submission that gives them some additional information about their dropdown box selection. Is this possible?If so, how do I go about doing something like this?
View Replies View Relatedi have a long recordset that i want to page through. can sql pass back say, 5 records from 20 to 25 out of 1000?
i can then pass 2 variables between the pages to dynamically generate the sql and thus page through the results. can someone post up a simple example of this if its possible?
I have design a single row (which includes text box and combo box) with muptilpe columns. When user enters a one details (for example: employee id), the other boxes will be automatically be filled in with that employees details. This I can do. However, how if I want to add more rows (to get more than one employee's details)? I can add rows but then the previous info (say on row one) goes missing
View Replies View RelatedI've looked around for a good while trying to figure out how to do this... and I need your help.I have a web page that is dynamically generated and it display rows from a DB and the rows get to be in the 100s. I need to break it up into sections... but I'm not sure how to go about doing it.What I'm wanting is something like this:
<< Previous 1 | 2 | 3 | 4 Next >>
(kindof like what is at the bottom of the forums here)
I have two webpages main.asp with some codes and text.html I need joint
(insert) text into main.asp.
I forgotten instructions to insert first webpage into second. How I can do
it?
currently, i export data from ASP to Excel. but i want to change it to RTF. i have looked at microsoft website and tried whay i have studied but failed to make it. at microsoft website, the table is created using rtf script but in my case, i just want to create it using html script.
and then, when user click PRINT button, i want my system shows the detail contents of rtf file and then open the Print window later. so user does not need to click File->Print and so on. is there any example script i can study?
I'm trying to generate three random different numbers to display three images on a page without repeating them. I can't seem to be able to get them to always be different. There's probably some simple solution, but I can't figure it out.
Here's my current code: ....
I am using the code below to create an excel document from data that is returned from an sql query. The formatting of the excel document is pretty and all is good unless I hit the back button and run my query a second time, or a third time (I haven't made it past 3
times). Basically what happens is every time I do this, excel does not close once I hit my back button. Does anyone have a solution to this problem? Another problem is that when I run the query it just opens excel within my browser, is there any way to make it ask if you want to save or open the file?
I basically throw this code at the top of the html doc: .....
i am developing asp project. database in ACCESS. i want to generate AUTOID when user submit the form. how can i do this?i mean, there is one field AutoId which increment by 1 , when user submit the form.
View Replies View RelatedThis is a strange request - but I'm trying to generate a Type Mismatch error. It's for an example in some documentation.I was looking for something that would error (like a mathematical equation using a string) that could be simply fixed using CInt(). However, the strings are getting converted at run time so I can't get the error to throw.
View Replies View RelatedI want to prepopulate a ticket number in my form, like when user enters the form the field ticket Id should always be filled with a number. I want to start my number with 1000.
View Replies View Relatedif this is possible and what is the best method to do it? I have heard of website copier but they don't seem to work perfectly.
View Replies View Relatedin relation to creating word documents on the fly using asp.I am using SQL Server 2000 as my backend and want to create word documents containing the data i retrieve.
View Replies View Related