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'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 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:
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 want to have a single script for sending emails, accessible from both ASP pages in any virtual directory in our websites (all on the one server), plus accessible from a number of WSH (windows scripting host vbscript files) which are triggered by the web servers Scheduled tasks.
The script formats text and checks emails and so on.
Is this a candidate for a web service? if so, how would i write it? Is a web service available from WSH?
We have a C++ DLL that we call from VB6 program. This is how we declare the DLL in VB6: Declare Function RefSearch Lib "csearch32.dll" (ByVal path As String, ByVal findword As String, ByVal CaseSensitive As Integer) As Integer This is how we call the DLL in VB6: hit = RefSearch(path, SearchStr1, ChkValue). Can I call this DLL in ASP and how ?
I have a bummer here. I have 3 sub R. that I need to call from a input button. I set up the following line, but the script just calls them with out having the button pressed. OOOO! Any ideas?
I have a form which checks email addresses. On submitting the form i have some JavaScript checking the format of the email address, once this has been completed successfully I would like my asp function to run. On successful completion of that I would like my form to be submitted to another page. Is this possible?
This may be in the wrong forum, but I'm going to give it a shot anyways. Here goes. I have a conference report that has 24 phone lines that are available for booking. Each call can take between 1-24 lines, you can have any number of calls as long as the number of lines they take up does not go over 24. I graphiclly represent this in a horizontal bar graph that displays the number of lines that are taken up for a particular half hour. Problem is when a meeting takes more than a half an hour, the meeting bar fills up for that whole time without any information on the meeting. What I would like to do is have each meeting when assigned in the DB or through an array be assigned a color and then that color appears on the graph under the time the meeting is. If there are multiple meetings (there almost always are), then the meeting that has been active the longest will be the first color bar on the graph. To make a way too long story short. I want to have a stacked bar chart that moves colors to the front as other's leave every half hour and move new ones to the back. If you want to look at what we have now visit URL.
Ok i'm self taught with regards to ASP so not great etc, so sorry if this is a really basic question..
On the last line here i'm trying to some how get it to call the last ID entry...
ImageID = Request("ID") If (Len(ImageID) = 0) then ImageID = "1" If Not IsNumeric(ImageID) Then ImageID = "1" If ImageID = "0" then ImageID = "1" If ImageID>3 then ImageID = max(Len(ImageID))
This is basically for some max min links for a online comic here's what it links to
My 1st page calls a 2nd that uses same data from a database. What is the best way to get the data in the second: a new call to the database or passing array through session variable?? I seems to me that avoiding a new call will speed up things but my concerne is that I have read many posts with caution messages againts session vars.
I've built an application in VB6 does some processing - it's not really important what it does. The application consists of a single DLL which does all the hard work, and a simple EXE which acts as the front-end. I designed it this way in the hope that I could also build an intranet app that controls the same component (DLL). I'm building the intranet page now, but I get this error when I try to instantiate the component. Rather than fiddle aimlessly with the permissions, I thought I'd post here and find out what I am missing. What permissions do I need to set up and where?
The error occur as "myiframe" is in a.asp and i need to call it in b.asp and i can't find the solution for that too.?anyone know how to pass value from a.asp to b.asp in above?
DLL name: openagent_HTTP.dll Function name: TurnOn
The above coding works fine, i run the above script in button on click, it can pass the value to the dll, but evertime it prompts for each click, because i use the window open,
What i need to do is, instead of calling my dll through Internet explorer,
Is there is any way i call my dll straight and pass the value without window open?, pls help almost struggle for a week...
I have written a very complex web app for intranet use. It allows users to search a large database and then returns formatted results. I am currently employing a method as below: Code:
I have an asp page accepting input from users Lets say this is form A, form A passes data to another form (say form B) to validate the data, if its valid then I want to open up another asp form (say form C) that does some queries based on data sent by form B.
I need help in opening the form without user intervention meaning, users should not have to press any key.
With .asp,how do I call another program?I would like to have my .asp script make a call to a PERL script, wait for the PERL script to finish, and then continue with what is/isn't returned from PERL.
I know in PERL this is simply done: system(theASPprog.asp). No fork is created, so the PERL prog waits for the .asp to finish.How do I do this with ASP?
I want to syndicate some content to other users. (no RSS).Anybody should be able to publish some information from my server/database by placing some javascript like: