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 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'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 have a little code to add multiple items to a shopping cart based page. This code works perfect, but it adds all of the info to the same input fields every time it loops. I need it to change the input names each time it loops. Here is the code:
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
I have an input box that sends data over to the next page. This input box was in a loop, there creating data looking like this: 2, 0, 0, 3, 0, 4, 0, 22, 0, 0, 0
How do i break the data up in such a way that i can populate it into my db while running through a recordset?
i create a dynamic table to modify user/account for administrative management. I have modify & delete function to be performed.
The idea is that when the admin click the Delete link, he can delete a particular account/user. is it possible to pass variable of buff value to recID??
because when i see the result of request.querystring("recID"), i does not pass the mumerical value sound pretty simple but i can't get it. Code:
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 am looking for something similar to "preg_match" and "preg_match_all" in PHP.
I have searched the forum with no luck. I hope you are able to give me some pointers
Basically I want to match some text from a form and loaded it into new variables making use of regular expressions. the text comes form a textarea input type. Code:
Is there any way to clean the user input before saving to the database.I tried to use..
Function StripNonNum(strInput) Dim regEx Set regEx = New RegExp regEx.Pattern ="^[w-.]{1,}@([da-zA-Z-]{1,}.){1,}[da-zA-Z-]{2,3}$" regEx.IgnoreCase = True regEx.Global = True StripNonNum = regEx.Replace(strInput, "") End Function
But It doesn't work when user cut&paste the information to screen.For eg.Cut&Paste from a CV which contains Bullet points is there any way to remove these bullet Points before data saving..
Code: <input type="radio" name="dewey_loc" value="dewey" onClick="toggledewey()" checked>Dewey Can't seem to work out how to call an ASP/VBSCRIPT function from within html, is this able to be done? Can call JS without issue, but need to change a Session variable when this radio button is clicked.
I have found that places double quotes ' "text" ' around text inside (INPUT) tags results in everything after the initial quote, '"' gets truncated. I'm passing the form information to another form to allow the user to look over and validate what they're submitting, then they will click the submit button to send it all along. I'm finding that in the validation form, the quoted text inside the (INPUT) tag gets truncated. However, the quoted text inside a TEXTAREA tag does not.
I'm using the following code and if someone enters something in the "instructions" field with characters -"', - it causes the SQL statement to change using those characters.
i have a software application and i have to import around 250 users data into the app. I want to automate this step,it the most common info like FN,LN,e-mail etc. The app runs on IIS and uses ASP. I am looking for a GUI input Automation tool which will have scripting capability to take input from a text file and fill the user input fields "automagically".can testing tools like winrunner do this for me?
I am in the process of writing a website which has an access database and uses asp to access it. Part of the site is a search facility. I have heard that it is possible for hackers to gain access to the database by entering SQL in to the search box. First of all is this possible? Secondly if it is possible, what sort of syntax should i be checking for on the text entered in to the search field
I have an ASP page that has a Form & Inputs that are related to an XML file. I would like to prepopulate the value of the Input with the corresponding field from the XML file.
i let the user go and submit his phone number in a particular page. on the other side on access i adjusted my input mask of that particular field to the following set (999) 000-0000;0;- or (&&&) &&&-&&&&;&;- or (@@@) @@@-@@@@;@;-
when i open the database i see the phone numbers are stored in the fine format which i wanted, however when i try to retrieve the data using the browser, i just gets me the phone number like 29384838283 without any brackets or spaces.