I'm trying to figure out how to display a query generated table in a div through an "innerHTML=...." - not only can I not to get the table to generate more than one row, I can't populate the column/cells with any data from the query -
The asp's/vb script (which works fine as a standalone asp page) is: Code:
I have a RequiredFieldValidator
This gets rendered out as a <span>
I want to set the innerHTML.
So I do this by using below javascript.
var eMail = document.getElementById
("Requiredfieldvalidator1");
eMail.innerHTML="";
The same code works for other spans but not for this one.
I have this code that retrieves the logged in users info. What I also need it to do is to display other records in the database that match the logged in users custnumber. Code:
View Replies View RelatedIn 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 RelatedUsing regular VB ASP (not .net) and calling an Access database using ODBC, I've generated a recordset based a query... (no big whoop, obviously)
Now I want to be able to open a new XL spreadsheet (client side - we're assuming user has XL) and export that table to it. I've seen some posts about DoCmd.TransferSpreadsheet, and CreateObject("excel.application")... I've never actually used them before, so I don't know where to start.
I'd like to have a link on the page with the table to "export to XL"... and then have it open XL (client side) with that table in a spreadsheet.
Is there a method where by I could check for a certain table or query
exist in my access database file before I made query to it??
this runs perfectly as a .vbs but I'd like to convert it to an ASP... any
ideas? Code:
i have written a stored procedure. depending upon different parameters, query is prepared as string and executed through exec() function. it returns a certain number of rows. stored procedure also contains a temporary table. the question is this how can i insert the rows returned by the query in to temporary table?
View Replies View Relatedit possible to pull the information from a query located inside the .mdb database already, instead of pulling the information from the tables ?
View Replies View RelatedI want to retrieve a large number of rows from my database (Select SomeColumns from myDatabase)and then to fill a table with the retrieved data. What can i do?
View Replies View RelatedI am new to ASP and I want to use a query which links one record in a table to another record in the same table to display a list of values. The query lists the names of all managers (the managers staff no is held in the reports_to field of an employee)
Set rs=Server.CreateObject("ADODB.Recordset")
rs.Open "SELECT DISTINCT p2.Surname + ', ' + p2.[First name] AS Expr1
FROM People p1 INNER JOIN People p2 ON p1.reports_to = p2.[Staff no] WHERE (p1.[Staff no] IS NOT NULL)",con,3,3
while not rs.EOF
%>
<option value="<%=rs("p2.surname")%></option>
<%
rs.MoveNext
wend
rs.Close
However it doesn't like the alias (p2). Is it possible to return a list from this type of query?
I want to do the following but am not able to do it.I have one query which is:
SQL2 = "SELECT * From totalcloser INNER JOIN zipcode ON totalcloser.zip = zipcode.zip order by totalcloser.zip"
I want to store result of this query in a temp table so that now i can go ahead and compare the results in the temp table with some other table.I know i can do this in Access..but i want to do this by coding (in my program itself) where the query runs and dumps the query results in temp table and then the second query runs and does comparisons and displays the result on screen.Towards the end ,we can flush the contents of the temp table.
I’m trying to build an application that will flow like this “when the data from my form1 is submitted an auto increment is generated id will generated...I want to be able to used the generated id in other form or page in my application.. this is because the id would be use as foreign key in other table in the database” …is there anybody can guide me on these issue.. I manage to develop it only until the submission of the first form after that I didn’t know how to call the generated id.. For your information I’m using mysql as database.
View Replies View RelatedCan anyone provide me with, or point me in the direction of somewhere where I can get the code to get the server to create and send an email.
Basically, when an order is completed on my site, I need to create and send an email notification both to the client and also to ourselves.
Is there anything else I need to be aware of when dealing with this? Any help would be greatly appreciated.
Im trying to send plain text emails to a japanese mobile phone.they use 3G in japan. However,one make of mobile phone can't read messages when the message is generated from two strings concatenated together.yes,i dont belive it either
e.g.
message = "Hi"
message = message & " Bye"
cannot be read on one type of mobile phone (giving invalid content error).
I've also tried message = message + " Bye" but that gives the same problem.This email can be read on all otehr types of phones. A single string can be read, but as soon as the string is ended and then started again,it breaks.
I used to have a piece of code that would generate a random string of
8,16,24 or 32 characters in length.
I got it from this group, does any one have this piece of code?
It will be used for a double opt-in email newsletter.
I want to send customers and automatecly generated email once they submit a form/place order. I've been searching the net for a whille but I haven't been able to find any usefull information.
View Replies View Related<%
for Counter = 1 to Sections
%>
<tr>
<td><input name="<%=Counter%>_Title" type="text" value="Item Number <%=Counter%>" size="40"></td>
</tr>
<%
next
%>
As you can see, the name for the text field is being generated as (in this instance) 1_Title
the form submits to another page.
How do I retreive the new value of that form?
<%=1_Title%> returns an error.
I have an insert query that creates a customer record, this record is given a ReferenceNo that is autoincremented within Access.
What I want to know is how can I retrieve this value after I have applied this update. Using MySQL I know there was a way to retrieve autogenereated keys, but is there something similar that I can do via the ADO stuff and access?
have a number of text box rows generated dynamically with the same name. This gets posted to the same page as a comma delimted string.
The Problem: If a user enters a comma the string gets disjointed.
Need to parse(remove commas)the dynamic text box values generated on client side.
I have in the past run some ASPs that generated Excel reports via the following line:
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=rpt_s2dpoc_Access_dump.xls"
I have a critical issue where I need to from an ASP gereate and excell spreadsheet but with three tabs. I will need different sections of the asp to write to those three tabs.
Code:
i need to build a booking system which relies on a calender. basically i have a db of clinics thar offer allotted times for appointments on certain dates. eg: a clinic may offer five 20 minutes slots 2 days a week.
so i need to get the data out of the db and display that in a calender form which the user can then select the time/date convenient to them. my question is (apart from how do i build this!?!?!?!) does anyone know a good calender that would fit my purpose? Code:
I have an asp page that collects data on referrals. The user inputs the
information and selects the rep to receive the referral. My data is being
saved to a backend database (SQL) and the user is receiving a confirmation
page after hitting the Submit button. Now, what I need is a way to have an
email sent to the rep that is selected in the drop down list on the asp form.
I have a SQL table containing the reps and corresponding email addresses.
Is it even possible to achieve what I am trying to do? I am trying to avoid
sending a blanket email to a single address and having someone filter them
from there.
I know you can use the XMLHTTP object to retrieve Html, but how can you get html created by an asp page? Is there a way.
View Replies View RelatedHow could I create a random filename for a single-use download? So, if a user was to download a file from a site it would send them a unique filename that could only be used once. That link would not be available after the download completed.
View Replies View RelatedI am relatively new to this generation of variables in ASP. I am unable to proceed from here. Can somebody advise?
Challenge :
I get number of participants in an exam, from a sql statement and stored into a variable called headcount.
After that, I am using the following to initialize randomly generated variables. For example if there are 4 students in the class, I intend to get student1, student2, student3 and student4, all of them initialized to 0.
For j=1 To CLng(headcount)
Eval Execute("student" & j & "=" & 0)
Next
Now we are trying to find out question wise defaults in the test. I have a for loop that does traverse through all the questions in the test. As I go question by question, if there is any failure I would like to increment the errorcounter of that participant.
Which means .....
I am not the ASP programmer on this project so I am simply asking for possiblities.
We are using ASP to generate html documents with data drawn from a database. We need to email some of these pages to our users.
We do not want to create separate email-able versions of all of these pages. It would be ideal to create an html email or attach and html document to an email, using the html code the asp code generates on the existing page.
Can this be done? My programmers tell me that the second option (write the generated code to a file, attach it to an email, send it, delete the file) would need to use FSO and the this object opens security holes.
Can anyone point me in the right direction for tutorials etc on dynamically generated pdfs from pages created from a database.
View Replies View RelatedI have to make a page with an inline frame, in this frame will come a dynamic generated PDF.
The PDF will have to be stored on the server to load in the preview frame but after the user had loaded the pdf in his browser I want it removed.
I thougt maybe I could use a General variable defined in global.asa that counts from 1 to 100 or something and every time a pdf is generated the number = number + 1 so I can create a pdf with the name ' filename & number & ".pdf" ' so that there would be constantly 100 pdf's on the server but not more and there is no danger of mixing up the preview which users get to see because it takes a while before their number is used again / their pdf is overwritten ...
I have a client who is requesting information in a batch type form in their CMS (easy enough).And they've asked that these reports would print one per page (hmm). From my experience I don't think this is possible but thought I'd ask on the forums here.Anyone know about this?
View Replies View RelatedMy Asp database generated pages' content links all open a new window containing the same page by default; this is strange since the default behavior for anchor links is to open in the same window; I can and have corrected this with target="_self" but I have additional anchor links that call JavaScript to submit a form and these aren't stopped from opening the new window by the "_self" value.
Interestingly, once the new window is open with the original page within, the links all work as expected in that window(!?!); is there a window or DOM value I need to instantiate so the generated windows will "recognize"themselves?
I wrote an asp script to generate an email only to find there is no mail server on the server running my scripts.
View Replies View RelatedI am exporting data from ASP page to an excel sheet using the following
code.
Response.AddHeader "Content-Disposition", "attachment;filename=ExcelView.xls"
Response.ContentType="application/vnd.ms-excel"
I have two questions.
1. How the excel file gets created on the server before it is sent to the
client.
2. Is there any prerequisite for exporting the data to excel? I mean do we
need to install any software like MS office on to the server?