I've got a subroutine, defined as Private, takes two parameters, that is
called lots of times from different ASP scripts. I need specific error
handling when it is called from only one particular section of my code - and
from the page it's called from, it's called multiple times from there, too,
so I can't check by page.
I thought about adding an additional parameter, but it's called so many
times that it would be unwieldy to do so.
Is there a way I can tell a Private Subroutine what piece of code called it?
I am calling a subroutine when I click a submit button. In the subroutine I grab values from text boxes and validate them. If it all works then it goes to the Update page.
Well my validating works but when it calls the Update page I am using the Request.Form to get the values from the form to update/insert into the database.
Well if I do an update it updates all the fields as empty. If I try to do an insert is says it can't insert NULL into the Primary key field.
Now most of the time the Primary key field is a list box and I don't touch it in the subroutine. Still why are all my values disappearing when I call the subroutine??
So I guess that is it. When I validate a forms values, them same values are no longer available on another page through Request.Form?
I am currently using an Access 2000 database as the back end of an ASP website that is under development. I have some vba code that generates a Word document from within Access and saves it in a folder that makes it available for download over the website. Can I execute this code from ASP?
Further, I am planning to split the Access database, once it is complete, by migrating the back end to SQL Server. Once the website connection is to SQL Server, will I still be able to execute the vba code located in the Access front end?
I understand that I can use "Exit Sub" to terminate an subroutine. However,this does not prevent everything before the "Exit Sub" from processing and displaying. Now, if I can't determine if a certain condition is met or not met until later in the subroutine, how can I prevent any parts of the code from displaying?
For example:
Code: Sub XYZ Response.Write "Table Header" For 0 to all user's online If user's page is an product page, then Response.Write Page_Name Y = Y + 1 end if next
Not sure if this is the right group for this but anyways... I've got an ASP web application that uses a Visual Basic component to do some work. I instantiate the component in asp and then attempt to call the subroutine. The subroutine is actually invoked maybe 2 out of 10 times run. What could possibly be the reason for this?? Why the inconsistency in running the subroutine?
I'm using a database table to create forms on our intranet. If the record is 'text', an input is printed, if it's 'dropdown', a dropdown is printed etc. In the case of dropdowns, the next field in the recordset is 'options' (eg Mr, Mrs etc.) and this works fine by splitting the options array and creating a separate <option> for each one.
My problem is that I've written a subroutine that creates dynamic dropdowns and it looks like this: Code:
here is some background on the page I made. It's a calendar page with events listed. No database, just used id="" to display certain months depending on the option chosen from the jump down menu.
The question I have is this: I would like to display the current month's events when they land on the page. I used
<% id=request.querystring("id") %>
and created an <%elseif id="1" then%> and so on for each month. Is there a way can request the month and display that id? Thanks for you help. I have the code for the page if need be
Is there a way to determine the actual width and height of a image file ? I'm using aspsmartupload to upload the image, how can determine and save the width and height value ? seems that aspsmartupload doesn't have this property. If so, is there any method to determine it in asp in the simpliest way? I will prefer to maintain the aspsmartupload method.
I have many servers which will be reghosted everyday with different OS (Win2000, Win2003, WinXP...). How could I write the ASP code to get the information of other servers' OS?
Let say the asp page is hosted on Server A, how can I check the OS version of Server B and Server C?
Somewhere in my program I ask users to provide their website URL. I would like to determine if the given website exists or not.How can I determine a website with given URL exists?
I am creating an ASP page for members of my team to add and delete records from specified tables. This table is choose by the user and I am dynamically creating text boxes. I also wish to include the type of the attribute to assist the user.
<% for s_intCounter=0 to objRs.Fields.Count -1 %><tr> <td width="34%"><% objRs.Fields.Item(s_intCounter) %>: <input type="text" id = <% objRs.Fields.Item(s_intCounter) %> > </td>
<td width="66%">Type: <% INSERT ASP FOR RETRIVING TYPE</td> </tr> <%next%>
I want to use asp to assign a css class to <td> tag. I was thinking an If statement, but i've not come across trying to assign a class to a table cell before! I want the cell background to be highlighted red determined by a database table with - yes or null. (null remains white, yes - red) At the moment it simple like this: Code:
My web hosting account lets me use ASP and so I thought I'd try to learn and use some. There is only one thing that I would like to know, and that is how to find out what version of ASP is running. Preferably, what I am looking for is something similar to the PHP php_info() function. Is there anything like this for ASP?
I have an ASP/ADO application querying an SQL Server DB. I want know the most efficient way to determine if more than one row is returned from a query. If more than one row is returned, the user will be presented with a choice of which row to process. If only one row is returned, I want to skip this stage, and process that single row immediately.
I can think of a number of ways of acheiving this (eg. .recordcount) but I'm looking for the slickest and most efficient method.
This may be a trivial question, but I was wondering how can you determine if a value contains an Integer or Float. I know there is a function called IsNumeric, however you can't determine what type it is.
I built a simple scheduling application using an access db.
The relevent fields are eventRoom, startDate, startTime and endTime.
When I go to add a new event, what method can I use to make sure the eventRoom is available for the selected date and time slot? Id like to just display an alert with the conflicting times and suggest the next available startTime.
I need to figure out if this file is over a day (or however many hours) and if it is, i need to delete it. If its not i redirect the user to it Code:
If (fs.FileExists(workFile))=true Then set f=fs.GetFile(workFile) If (f.DateLastModified > Date-1) Response.Redirect "/" & tFileName & "/" & reqString & ".html" Else f.Delete End If set f=nothing End If
obviosuly the date-1 is wrong, i can't fid the appropriate syntax to save my life.
Just wondering if anyone knows how to determine someones connection speed in asp the reason for this being so i can redirect the user to a different media file depending on their connection speed.
I have a recordset with two three fields. One is an autonumber field called ID , one is a text field called Name and the last is a date/time field called DateEntered. How can I programatically determine the autonumber field ? Code:
is there anyone here who can help me to determine google's pagerank with asp code. Just like pagerank tools are doing, where do they request data from, how do they get it, etc..
First I would question why you want to do this. If they get to the page by any means it should respond appropriately, whether refresh or by link. This is a stateless environment after all.
That being said...
I would take the approach of setting a session variable that gets set the first time they hit the page:
<% if session("NotTheFirstTime") = "" then 'write the onload session("NotTheFirstTime") = true end if %>
then based on that variable write or don't write the onload.
Of course, if the user can access the page from multiple links and the onload is valid for each link, regardless of how many times they hit the page, this won't work....
how do i determine how many items are in an array? the following code creates an array of values each time a space is found in a name field. the problem is that sometimes names have middle initials and sometimes they do not. so i want to determine how many items exist in this array created bythe split BEFORE assigning values:
I have a database i want to be able to determine its size from an asp page, Also is it possible to list tables and column names list what tables are in the database and column names of each table contained?
I have an asp script that lists the files in a directory:
CurrentPATH = "c: emp" Set oFSO = CreateObject("Scripting.FileSystemObject") Set oFolder = oFSO.GetFolder(CurrentPATH) Set oFolderContents = oFolder.Files For Each oFileItem in oFolder.Files ..... next
before doing the "For..Next" loop, I want to determine the number of files in oFolderContents. How can I do this? Is there another way to determine the number of files in a given directory?
