Instead of locking this bit of code down to the "crreport1.rpt" entry I was wanting to have it receive a "POST" command(from a form page that would post to the page that contains this code) so that it can be more dynamic. Here's the original: Code:
Set session("oRpt") = session("oApp").OpenReport(basePath & "report1.rpt", 1)
Would something like this work in my asp page?Code:
Set session("oRpt") = session("oApp").OpenReport(basePath & Request.Form("report"), 1)
and then use something like www.test.com?report=report1.rpt
I have downloaded some sample code from the net to display a calendar etc.
The code is below.
How can I modify this code so that when called in a popup window and a date is clicked, that date is inserted into a form field on the original page. I know how to pass this value back but do not know how to modify this code to include the correct line. Code:
I have been searching for a solution to a permissions problem: Currently, I have an app that creates an html file in a folder on the web server, closes the file, opens it again and dumps the contents into an HTML-formatted e-mail message. In order to create and open the file, I had to set permissions for anonymous browsers to READ/WRITE. The app works fine, but this poses a security problem, because the files contain personal data that anyone may intentionally or unintentionally view. My question is: Is it possible to modify the folder permissions within the ASP app? I'd like to open the folder for READ/WRITE in order to create the file and open it for sending the e-mail and then immediately turn off all permissions for anonymous browsers.
Using the following query I get my desired results. However, in the resulting recordset, how can I show for example 10 words before and 10 words after the keyword or phrase that was searched upon? If I get 20 resulting records I think it would be easier for the user to decide which they want to view.
DECLARE @SearchString varchar(100) SET @SearchString = ' "stress" ' SELECT KEY_TBL.RANK, Title, Body FROM Articles INNER JOIN FREETEXTTABLE(Articles,*, @SearchString) AS KEY_TBL ON Articles.ID = KEY_TBL.[KEY] ORDER BY Rank DESC
I have a simple png image file which has a white background and one layer of text. Is there a way in ASP/VB to dynamically change the contents of the text layer? I guess the steps would be to load the image, extract and replace the text, rebuild the image and save to the file system under a new name.
if I could use the same 'Thank You' page but display a different message depending on which page it was referred to from: eg an order page or a mailing list page. Is there a way ASP can tell which was the preceding page?
I currently have a sql query that pulls all records based on a variable(var1) inputed by a user from a form. Each record in my database has a time stamp assoicated with it. I want to give the user the option of pulling all records based on (var1) and allow them to sort based on date or time stamp also with a two fields that will take a range.
(ex. Beginning date and Ending date). So my default sql query will allow for var1 to be inserted and to have all records returned for the current day. BUT, IF A USER HAS ENTERED
A DATE RANGE then all records will be returned for that date range based on the var1's value. How could i go about about structuring my code for this? I was thinking about a "Switch" statement that could response to different user options with different sql queries. What do you guys think?
I am using a SQL Server database. I am using a bit datatype. O is true and 1 is False. How do I get the radio button to have the correct value checked for a certain record?
Does anyone have and easy way of modifying the format of a number once pulled from an Access database? In the thread listed above, Access is stripping the 0's in front of my numbers. As a work around I have an If statement that checks to see if the number is < 10 and if so write a 0 before pulling from the recordset. I'm looking for a simpler, one line code instead of the big If statement.
I know that using Word Automation inside an ASP page is no good idea.Anything I want to do in the current project is: open document, change some text, save and close document. Basically changing some variables, consting of a name embraced by special chars, to some value. As for example: change "[FirstName]" to "Michael".
Does anybody know whether there is a way for achieving this with basic "file input / output". Can I regard a Word document as some binary data, perform the replacement, and save the data, without destroying Word's internal structure?
i have absolutely no experience using ASP or PHP, but I've been tasked with making a simple login page for certain clients. I found this tutorial which is almost what i'm looking for.
The one thing that i need to modify is each username, after login, must be directed to a specific protected page. Since the username and password get split into an array, i know there must be a way to also keep track of which pages are associated with which usernames, and then have that URL be evaluated in this line of code:
Code: Response.Redirect ("/protected/default.asp") if anyone has a better way of doing this simple form that would be very helpful as well, thanks -ak
if it is possible to open a text file using FSO and modifying the content of it.I have a template of a file (template.bsi) as a text file and I want to change variables within the text file by a simple replace command, but I'm not sure whether this is possible.
i'm wondering if it's possible to modify the design of an sql database from within a script. I don't have MS SQL installed on my machine but i need to add a few fields to some of the tables.
I know it's possible to create and drop tables so that is one option. ie: drop the existing one and create it again with the extra fields. the problem with that way is I'll lose all the data. so long story short. how do i modify the design of a table from within a vbscript?
What I'm trying to accomplish is the ability to post information to the querystring based upon values that are within a drop down that was generated from a database. Code:
is it possible to open an excel file (used as a template) from server using server-side vbscript; then modify it or add values from client using client-side vbscript?
Is there any way that I can store my ASP code in an Access DB and have it display that way? Ideally, I would like to make a page with a text area that I can write and edit code in, and then when I submit it, I would like to view the page that the code creates. The code in the DB would include code that selects from and updates the DB. I would like to do this because I can't work remotely now.
This is the error. Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'CLASSDATE >= 6/23/2004 ORDERBY CLASSDATE'.
This is the code.
Code:
strSQL = "Select * FROM WellClass WHERE CLASSDATE >= " & DATE & " ORDERBY CLASSDATE"
I am trying to follow the W3Schools tutorial on the XMLDOM object, and it works fine in a regular HTML document inside <script> tags (vbscript), but I am trying to do it in the ASP tags (<% %>) and it does not work. The error says:
Code:
Microsoft VBScript runtime (0x800A01A8) Object required: '[object]'
I am trying to do something with it and I can figure out what to do!I have created a database that lets realtors track clients, potential clients, and offers made. Here is a link to the database:(URL address blocked: See forum rules) What I am trying to do is create a form that lets a user enter his first name, last name, email, and offer amount into textboxes. When they click send it adds their information to the Potential Buyer table (the primary key is an auto generated number.) The offer table is basically an associative table, containing the following information: buyer$buyerid, client$clientid, and amount. I would like the amount to be added to this table, and I would like it to also add the newly created buyerid. My problem is that well, I have no idea how to do this, as the buyerid is created only seconds before I need to post it in the offer table. Could anyone help me out with this? I'd really appreciate it.
Here's the current code that I'm using for navigation through some pages. MY question is, I want the item "System-Add Ons" to still stay bolded if I'm on a page that's in a subset of "Products" Is this possible?
For example, if a user gets to the page "Monitors," (monitors.asp) I want System-Add Ons to stay bolded....
How can I set up subsets of the "Products" page? Do I have to make a directory and do a test if the page is in the directory "Products" and is affiliated with "Products?" Code:
I Wanna to know that which of below codes related to ADO within ASP (VBscript) is better?
CODE ONE :: rsEduCalender.CursorLocation=3 With rsEduCalender if .State=1 then .Close .Open SQLstr,cn,3,1 End With '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''' CODE TWO:: With rsEduCalender if .State=1 then .Close .CursorLocation=3 .Open SQLstr,cn,3,1 End With
i created ASP page for Online TEST it Consist three pages First Page is Selection of Topic and Number of Questions from List Box. Second page is shows the Questions as per the Selection in previous page Datas from the Database. Third Page is Result Page. But My problem is in Second Page, because all the question are created dynamicaly so that how can i get the User answer I get the question id and correct answer for all the questions. but i need to get the user answer for Result.I attached my code for the second page.
Is there a program or website that will validate my asp pages?Kind of like how html pages can be validated on http://www2.imagiware.com/RxHTML/ and on http://netmechanic.com
this is what i am doing for zip codes i want user to enter zip codes like this
92274 92274-0965
so if the user enters zip code like this 92274 then its right but if he enters zip codes like this 922740965 then change it to 92274-0965 this is what i have done so far so i have got the values of first 5 i need to include a -and then the rest of the numbers any idea how to make this work
