Dynamically Generated Named Ranges
I know it's possible to extract data from a named range on an excel sheet. What I want to know is can I dynamically generate a named range with X columns and Y rows with VBScript.
View Replies
ADVERTISEMENT
Processing Forms With Dynamically Named Input Items
I am unsure how to process the results of a form where the name of the <input> is generated dynamically i.e.
<input name="X<%=counter%>">
or similar.
How is each input then referred to in the page the form is posted to? I can't see any way to dynamically create variable names in ASP?
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.
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:
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 RelatedDynamically 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 RelatedBack Button Problems With Dynamically Generated Pages...
I have a web application done in Cold fusion but I think this may apply to other dynamic apps done in asp etc.
I have a "list" page which lists items and is generated from a database. When you click on the item name it passes the unique itemID in the URL to a "details" page where more info about that Item is displayed - standard drill down proceedure.
The problem is this - when I am on the "details" page I cannot go back to the "list" page in NN or Mozilla - in fact the browser back button is grayed out like the first page never existed. This does NOT happen in IE - the back button works as expected.
Similarily, java script solutions like <a href="javascript:history.go(-1);">back</a> also fail in NN and Mozilla but DO work in IE.
I think this has do do with the dynamically generated pages and the above mentioned browsers not "remembering" them since they are created on the fly - but why? Since things work fine in IE there must be a simple solution to this problem...
Dates In Ranges
If I have a list with dates how can i seperate them in ranges?
View Replies View RelatedSelecting Ranges
On the online crm system i've built (using ASP) our customers can create a list of contacts and download/delete/add to this list when they want to and then go and view the list. It will display 20 on a page with forward/back buttons etc.
I have written a routine which queries the MS SQL 2000 database and retrieves all the IDs of the contacts. It will then work out the page it is on and display the appropriate records by reading through the 20 IDs for that page and query the data from each ID it needs to display on the screen.
This works fine for lists of up to 1000-2000 but when it gets to 5000, 10000 records it becomes an issue of performance as it will hold in a variable all of those 5000 or 10000 IDs. There has to be another way of doing this.
Validating Date Ranges Using Javascirpt.
I have two input fields on an ASP Page.
User enters 2 dates.
I want to check that the difference in months does not
exceed 360 months.
Is this possible in Javascript to get the difference in
months?
Named CDO Constants
I've been searching for a complete listing of the CDO constants, but have
come up empty. Where can I find a listing of all the CDO named constants
that can be referenced directly with the CDO metadata typelib, i.e.,
<!--
METADATA
TYPE="typelib"
UUID="CD000000-8B95-11D1-82DB-00C04FB1625D"
NAME="CDO for Windows 2000 Library"
-->
Named Anchors
Can you use named anchors in ASP links?
I am using an <IFRAME> on one of my pages and want to jump to one part of the page that is loaded, but I'm also passing querystring variables in the link. It doesn't seem to recognise the #now anchor that I want to jump to.
Named Array Not Numbered
Can I name my array index rather than number?I am reading a RS into an array and rather than reference the fields in each elements using a number, i would lke to use the column headers from the table:
myArray(13,6)
would become
my array(name,6).
The reason is that i am worried about a query being added to in the table and throwing the column numbers out.
Jump To Named Anchor
Let's say I have a form like this:
<form action="handler.asp"> ... </form>
Within handler.asp, I output a number of named anchors:
<a name="important1">Important 1</a> ...
<a name="important2">Important 2</a> ...
<a name="important3">Important 3</a> ...
In my form processing code, I want the returned page to jump to one of these anchors depending on the result of the processing.
How can I do this?I don't want to use a redirection because then I would have to
re-process the same page.
Passing Variables Via Url With Named Anchors
I am trying to passing some variables via the url and also a named anchor appended to the end. unfortunetely the named anchor is been read in as part of the last variable.
threads.asp?t=96&f=15&j=y#288
I use request.queryString("j") to retrieve the value but the value returned is y#288 and no y as expected.
Is there anyway to fix this problem.
I can't pass the value via a form.
here is the code I use to create the url
Code:
Response.redirect And Named Anchors
All of these fail :
response.redirect("page.asp?Param=Param#Anchor")
response.redirect("page.asp#Anchor?Param=Param")
This one works fine :
location.href = "page.asp?Param=Param#Anchor"
I have a solution i dont like :
i can replace #Anchor by &Anchor=Anchor
Does someone has an other idea ?
Creating Dynamic Named Folders
Basically, I would like to create a folder on my server for each user that comes to my site based on their last name which they enter. The code I have below is incomplete as I don't know how to incorporate the lastname into the CreateFolder method.
dim lastname, objFSO
lastname = Request.Form("lastname")
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
folder = Server.mapPath("/test/")
objFSO.CreateFolder(folder)
Set objFSO = Nothing
Named Anchors Not Working In IE.... Fine In Firefox/...?
I have developed an extranet system, that is not recognizing any named anchors in IE. The top drop down on the page should be jumping the user to each section. It works beautifully in Firefox, but not in IE. Has anyone encountered this before? Any insights?
View Replies View RelatedSearch Result To Custom Named Page
Here is what I am trying to accomplish.
Language: .asp vbscript
Building a searchable real estate property database (MS Access)
Search page submits form variables to result page.
Works great but I have seen other web sites where the results page is a custom named page. for example.
If you search for homes with the following criteria.
Criteria: Buford, GA 30519
Your results page is named something like the following.
MLS-Buford-GA-30519-10-Distancea-0.aspx
Is this only doable in .aspx or can I accomplish this task in .asp?
Unable To Find An Entry Point Named EnumerateSecurityPackagesW In
I am trying to solve the following exception. The exception occurs when my
ASP.NET code behind code attemtps to access a remore site using SSL. Please
note that all certificates are valid and the remote site is trusted. Also, my
web site uses a custom HTTPModule implemented in a DLL named Security.dll.
Unable to find an entry point named EnumerateSecurityPackagesW in DLL
security.dll.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.EntryPointNotFoundException: Unable to find an
entry point named EnumerateSecurityPackagesW in DLL security.dll.
Getting 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.
Randomly 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?
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:
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.
Getting 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 RelatedRandomly 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.