Fine Tuning My Response
I have a Response.ContentType = "application/vnd.ms-excel" and I want the output cells to have a 0 in them if there is no other integer in the database.Is this something that I can dictate in my sub ?
View RepliesI have a Response.ContentType = "application/vnd.ms-excel" and I want the output cells to have a 0 in them if there is no other integer in the database.Is this something that I can dictate in my sub ?
View RepliesI am trying to fine tune my XLS report and for some reason I can't wrap my head around why my cells are not where I want them... another head needed for objective please.
Here is a picture of the report that is generated. I need the fields that have formulas to be where the arrow is pointing. I obviously can't figure out why I have too many cells. Code:
Microsoft ODBC Driver 2.573 to retrieve Oracle Data, it is slow. How to tune this?
View Replies View RelatedI've been trying to transition an application from an Access db to an Oracle db. I've got the base functionality down, but it's slooow. I'm prety sure that the 8 processor IIS and Oracle servers are more than capable of the low traffic that my code creates.
My question is, what's the most efficient way to do this? I've been and still am doing research on cursors, locktypes, etc... But, I haven't come across something that is similar, so I thought I'd see if anyone here has had the same experience.
Currently my connections/recordsets look like this: Code:
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 RelatedI am trying to improve the robustness and elegance of my parametized sql
statements in ASP 3.0 as they get passed to the sql server SP.
Could anyone tell me if there are weaknessess in the way I have written the
following code? I have included both the asp code and the sql stored
proceducre to tie things togoether....I appreciate any advice on this. It
basically is a application to manage static news stories on our site by
tracking and organising the meta data in a table. Code:
Below is the generated source for an ASP page that posts a value called 'album' to another ASP page. The other page retrieves the value with Request.Form('album'); On Firefox this works fine every time. On IE6, I always get nothing. I'm pretty sure it's the posting side that is at fault, so that's what I've shown here. Oh, I tried Request.QueryString too and again, fine on Firefox, nothing on IE6....
View Replies View RelatedI'm have a VB function that connect to SQL SERVER , get's information
and returns the relavant string.
using this function within VB application (say cmdbutton) works great,
but when trying to activate the function from asp page, i'm getting
nothing. Code:
<a target="_blank"
href="IndividualGamePerformances.asp?MatchID=<%=RS("MatchID")%>&TeamID=<%=Request("TeamID")%>">
Can anyone please tell me what to enter after Response.Write to write the above to the HTTP Response body.
Is there any point in having response.end after response.redirect?
View Replies View RelatedThe following code checks to see if user is an Admin...if not then the user get redirected to another page.
If(accountType <> "Admin") Then
response.redirect "message.asp?msg=20"
Response.End
End if
.
.
.
Code
.
.
My question is:
Do I need Response.End?
Can a user (not an admin) stop the browser from redirecting and execute the code after the if statement?
after looking at someone elses code here I noticed that he
always does a Response.End after a Response.Redirect. I was under the
impression that code execution would stop on the current page as soon as the
Response.Redirect statement appeared, but the guy reckons that the code will
continue running on the current page before starting the new one. Can
someone give me the definitive answer on this?
I must admit I always forget to use "response.end"
and I also forget to "set objects = nothing"
how important are these things.
I know my application run fine without them probably because I usually have
plenty of processing power and ram.
My understanding is that a small peace of ram will be tied up for a set
period of time, and then it will be returned for use.
What is wrong with this line?
response.write <img src="http://mine.web.site/persPictures/" & rs("LastName") & "_" & rs("FirstName") & ".jpg" width=85 border=1>"
I have placed an include to "security.asp" at the top of each .asp page in the Members Area of my client's web site.
When the following code in "security.asp" is executed, the user is redirected to the "join.asp" page but the url in the browser address bar still shows the last page's url.
My first question was, can I hide a form field and make it visible upon
selecting a particular value on a dropdown select field? Hoping for your
immediate response.
I have a page which runs a script. When it gets to the end of the page I want it to do 2 things:
1) take some variables from the page and create an Outlook email with the subject, body and To fields populated with those variables.
2) send the page to another page.
This is roughly the theory:
Response.Redirect("mailto:me@here.com")
Response.Redirect("mypage.asp")
1) I like to know when a problem is solved. When the original person posts a "thank you that solved my problem" message and I see it I know that what they did worked. The macromedia site allows people who opened the thread to close it as "solved" Then you can search for a topic and request only "solved" threads.
2) When I am stuck on something for a long time and someone finally gives me the info. I've been stressing out over. I would feel guilty if I did not thank the helpful person. My parents' good upbringing must have burned into me the idea that you need to say "please" and "thank you".
Just my two cents. Also the Macromedia forum is not a better forum, unless it is a specific question about one of their products. Even then
In my html page to update a table I am forwarding request to a ASP apge bys using form.action="test.asp", and form.submit(). In asp I am doing database update. Response of this I want to show alert box to user whether operation is succesful.
I donot want ot redirect to some other page and I do not want to disturn existing view. I mean I want get only response such as true or false and based on respose I will display alert in front end. I want some thing like this,
form.action="test.asp";
var result=form.submit()
if( result="successfull")
alert("Succesful")
else
alert("failed")
This is my current URL after the process takes place. I want to add in the URL after intCatID & . This additonal paramater [AL = "intAL"], then the error but I forgot how to do this.
<%
Response.Redirect "FileMaintenance.do?CatName=" & strCatName & "&CatID=" & _
intCatID & "&Error=" & Server.URLEncode(intCount & " files were successfully added to the Package.")
%>
I have a Popup window where a user inputs soem data.
On successfully entering this data I redirect the user to
a page in the same popup indicating that the form has
submitted successfully.
I want to resize the page that I redirect the user to.
Is this possible in ASP?
I have a page called createWordDoc.asp, that starts with the line <% Response.ContentType = "application/msword" %>.
What it does, is receicves information from a form on the previous page, formats everything using html, and saves it as a word document.
Everything is working ok, except when I open the word document, there should be a picture in amongst the text, but it isn't there.
Does anyone know about creating word docs from asp, or has anyone had simliar problems?
I've come across some weird bug with Response.Cookies. Or maybe it will be
called "by design" but for the life of me I can't figure out what purpose it
would serve. If you're setting a cookie (say Response.Cookies ("TEST")) and
you have a query string variable &test=x or &Test=x and you get
Request.QueryString to parse the query string, the cookie that gets dropped
matches the case of the query string, not what your code says. In other
words even though the code says Response.Cookies ("TEST"), it drops
Response.Cookies ("test") instead.
Anyone have any idea what's going on here? There's an example below. Try
it with http://127.0.0.1/cookieTest.asp?test=x and without the query string
variable.
<%@Language=Jscript Enablesessionstate=false%>
<%var exp = new Date();
exp.setTime(exp.getTime() + (2 * 365 * 24 * 60 * 60 * 1000))
var expDate = (exp.getUTCMonth()+1) + "/" + exp.getUTCDate() + "/" +
exp.getUTCFullYear()
var x = Request.QueryString ("dummy");
Response.Cookies("TEST") = "This is a test";
Response.Cookies("TEST").Expires = expDate;
%>
Having just migrated to w2k from NT4, I've stumbled across an oddity with
cookie handling - at least, that's what it appears to be.
I (was) using response.buffer with .addheader to write two cookies into a
the http header for a particular page . Worked fine for three years.
After the upgrade, I'm finding that two copies of the same cookie appear,
one with blanks for values, the other with values filled in; this has the
effect of logging the user into the page if the first copy isn't blank....
So, I changed the code to use response.cookie, which is fine, but the
names/values get encoded, and unfortunately the software vendor uses dashes
in the name part.
Is there any way to force .cookie to not encode the '-'?
or do I need to look at javascript to write the cookie?
I am trying to add some basic security to my asp web pages. I have a logon screen which, when the logon and password are checked for validity, passes the user on to a registration screen using the code
response.Redirect "user_reg.asp?User=" & Request.Form("UserName")
I then inserted the following line before the redirect
response.Cookies("ValidUser") = "ValidUser"
I have the following check at the start of the user_reg.asp page
<%
if request.Cookies("ValidUser") <> "VaildUser" then
response.redirect "user_login.asp"
End if
%>
All that happens now is that when I log in validly user_login.asp is
redisplayed rather than the user_reg.asp.
Perhaps this is not sufficient to set the cookie? I have looked for it but
can't see it amoungst other cookies dated today.
I want to know whether a certain function on the database such as add or delete record is successful or not to be indicated after the transaction.
E.g. if a record was not found, or not deleted, the next page should indicate the event. If deleted it should indicate as well.
Can anyone tell me if Response.Redirect works with IE5?, for me its seems to be working with IE6 and Firefox, but seems ineffective with IE5.
I have also set Response.Buffer = True
How to send more than one value using response redirect? For example i can send one like this:
response.Redirect "pregled.asp?ime=" & strUserName
but how to send two or more values? I tried:
response.Redirect("pregled.asp?ime=" & strUserName & " & prezime = " &
strUserLastName)but it didn't work.
How do I use Response.Redirect to point to an interal private box/site? Code:
View Replies View RelatedI writing code that will create asp pages using the file system object.
<%
..
..
'other code here
Response.Write "<%sName=" & Var & "%>"
%>
How can I do this?
If my recordset is empty I want to write "Not Complete" and if there is
a value, I want to write the value. Can someone tell me what I am
doing wrong?
<%
If IsEmpty(rsa.Fields.Item("reclaima")) Then
Response.Write("Not Complete")
Else
Response.Write(rsa.Fields.Item("reclaima"))
End If
%>
Also tried....
<%
If rsa.Fields.Item("reclaima") = "" Then
Response.Write("Not Complete")
Else
Response.Write(rsa.Fields.Item("reclaima"))
End If
%>
IF Trim(Request.QueryString("v")) = "" THEN
Back = Replace(Request.ServerVariables("Http_REFERER"),"http://localhost/","")
ELSE
Back = Request.QueryString("v")
END IF
Response.Redirect(""&Response.write(Back)&"")
why i cannot Redirect to the page?
instead of the below code Code:
Response.Write ("<img src='images/mainheader.png'><p><p style='color:#666666' font-family: Arial, Helvetica, sans-serif;>Your password has been sucessfully changed</p><p><a href='./members.asp' style='color:#a10000' font-family: Arial, Helvetica, sans-serif;>Back to the site</a></p>")
can i have the rsepone go to another page?
Response.Redirect "./members.asp"
would taht work?