Problem With SQL Generated From Access On An ASP Page
The following SQL code does not return anything to the Full_Name fields when the ASP page tries to display it in a table. Code:
View Replies
ADVERTISEMENT
ASP + Access Question (Determining The Last Id Generated By Access)
I'm working on a site that inserts records into an Access database and Access assigns an auto-incrementing id for the record. How can I quickly figure out what id that was just created? I seem to remember there being a function for this....
View Replies View RelatedGetting Html Generated From An Asp Page
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 RelatedChanging The Link On FP Generated Confirmation Page
I am passing variables around from page to page using the following:
../new.asp?Info=stuff&name=Fred
then re-capturing it with:
<% 'Get the users info passed from the previous page
strUserInfo = Request.QueryString("info") %>
strUserName = Request.QueryString("name") %>
I use that info to personalize pages:
Hello <% strUserName %>, glad you are back to work on your <% info %>.
This works great for pages/forms that only update a record or display the strings, but the problem I'm having is with a form that creates a brand new record using the passed data.
I use hidden inputs into the new record so that the user does not have to re-enter it but when they hit submit Front Page posts a confirmation page with a link to return to the same form. I need to change that link but cannot figure out where the confirmation page is generated.
ASP Auto Generated List Forcing Page To Push Out
I output a list of towns from a database via a normal recordset loop into a normal paragraph with links - BUT for some reason it is totally pushing the page out... is there any reason for this? I also placed trim() on the town name in case there were lots of mistaken spaces, etc. Code:
View Replies View RelatedGetting The Generated Id
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 RelatedGenerated Email
Can 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.
Generated Mail
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.
Access The Page
ADODB.Connection.1 error '80004005'
SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified
admin/conn.asp, line 4
I get this error when trying to access the page to view. If anyone can help me out or lead me in the right direction, that would be awesome.
Access The Page
I have a website I just built. On the index.asp page I have an employee login section. When the employee inputs his username and password he is redirected to www.mydomain.org/employees/employeesonly.asp. how do I go about making the employees/employeesonly.asp require a password if someone was to paste www.mydomain.org/employees/employeesonly.asp into their browser? The way it is set up now anyone can paste the url into their broowser and access the page.
View Replies View RelatedRandomly Generated Strings
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.
Automatic Generated Email
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 RelatedGetting Loop Generated Variables?
<%
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.
Retrieving Auto Generated Key From DB
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?
Parse Dynamically Generated
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.
Generated Excel Reports
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:
Dynamically Generated Calender?
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:
System Generated Email
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.
Randomly Generated Filename
How 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 RelatedRandomly Generated Variables
I 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 .....
Redirect Generated Html
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.
Pdf From Dynamically Generated Pages
Can anyone point me in the right direction for tutorials etc on dynamically generated pdfs from pages created from a database.
View Replies View RelatedGenerated Pdf Preview Issue
I 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 ...
Dynamically Generated Reports
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 RelatedGenerated Content Links
My 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?
ASP Script To Generated Email
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 RelatedHow Excel File Is Generated?
I 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?
Access, ASP And Page Format
I have a site using Access 2K and ASP.
The site uses frames and the ASP page appears in between two of the frames;
so I have a limited amount of space to present the DB information. I want
the ASP page to have a restricted number of characters showing horizontally
and to automatically wrap if the line limit is surpassed. Can this
formatting be set in the ASP code for particular fields?
Also, I'd like to indent some of the data that's being pulled from the DB.
Need To Block Access To A Page...
I am designing an app with multiple users. User 1 logs in and navigates to a Page 1 where a page template is modified. When modifications are over User 1 saves the page and logs out of the system.
I need to block access to every other user to Page 1 until User 1 "releases" the page.
At the moment I am using a field on my Access DB called locked that I set when any user enters Page 1, and upon saving locked field is cleared... Is there a more efficient way to do this?
Page Access Restriction
Suppose I have one website www.mywebsite.com and I have one page in this sitte "myrestrictedpage.asp".
The page "myrestrictedpage.asp" should NOT be accesible from the hosted website (www.mywebsite.com) instead of that the page can only be accessible
only from :
1) www.OtherWeb1.com/welcomeuser.asp
2) www.OtherWeb5.com/
How can I do this?
Open Access Mde From Web Page
how to open a mde file from a web page (asp,html,shtml,apsx) ? I know there is a security setting that don't allows web server to run/launch executable files but can it be turned off.
View Replies View RelatedPage Access Handling
Supressing the "Save password" prompt: Are there any good approaches to keeping a password from being stored client-side if auto-fill is on? Ideally I'd like to supress the prompt. The only other option I can find is to use a timestamp as part of the form name and pass it (the name as well as the value) in a hidden field to the login script.
Unique concurrent logins: Are there any good ways to prevent userX from being logged in from 3 different locations simultaneously? -I can code for a 'logged in / out" field, but that relies on the user actually login out. And if I use a variation of the "who's online" approach the user may have to wait until the seeion expires befor logging in again (suppose thier net connection dropped for a moment and they need to get back online) - At least I think this assumption is correct.
Block Web Page Access
I use the windows 2003 server with IIS 6 and my web pages are created with ASP script.I am trying to block some web pages (not all) that is created only for internal users like an intraweb.To do this, how can i control it and how should i block to prevent access from external users.
View Replies View Related