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.
I have an Employee Database in MSAccess with more than 10 tables. The updates of employee is done frequently and is done in bulk. The fresh data arrives in Excel worksheets (more than 50 records).
I have created a user interface in ASP to update these records in Access. But the user ends up doing more work updating. Importing Excel worksheets to Access is one way ...but then the column names and types have to be adjusted evrytime.
Can i build a datagrid in browser using ASP, so that the whole table gets displayed and the user can update the data in bulk. And is there any way I could copy paste the Excel records in such datagrid?
my problem is The updates on my asp files are not reflected in the browser. Till recently everything was working fine.
Today I installed new updates on my windows 2000. After all the cached asp contents are appearing and the updates are not getting refreshed. I dont know if this is becoz of the updates on my OS.
I had a file addfield.asp. It was working fine, I made some changes and they worked. But after that my updates are not reflected. If I rename the file to addfield1.asp. I am getting the desired results. Again if I change the contents of this file, they are not appearing.
lets say we have a ms db with two cols
id value
1 4
2 7
3 9
4 1
is there a simple way of updating all the value fields with one form? so i can have the page lay the four value's out in a list, the user could then edit them and hit update and this would update all the value fields. i can update single records no problem but have no idea where to start with this one.
I need to know if I should use asp.net or Java for this. I would like to use asp in general. I need to have a function check to see if a variable is true or false and update an icon. But I want it to either check when updated or every 3 seconds. I suppose it has to be somewhat client side scripting but is there a way around this.
As of now I use IFrames whith a refresh of 10 seconds, any less will cause it to timeout. I kind of want it real-time or very near. It's kind of like a status page for information in a database.
I would like to have it to use the variable "Id" in the bit which says where Subject = having set the variable earlier. This is for updating replies in a forum script. Code:
View Replies View RelatedI have a new feature called What's New i'm implementing. Whenever i add a new feature to my site, i am goign to write a little blurb about it.
On my main page, i have a javascript that will appear if there are any WhatsNew to show. However, i only want it to appear at least until the person has visited my WhatsNew page. Then, it does not need to appear again until i add another feature.
So, i have a Publish date field in my DB for weach feature and i was going to do this.
On the main page, check to see if Cookie exists, if not, display JS. When user goes to WhatsNew page, i update the cookie with the date.
My problem is that if my last feature was published say 12/02/2005 and todays date is 12/05/2005, the JS will appear. So my theory is flawed. I need to JS to only appear when the user has visited that page, since the last feature was added.
In the site I have to create the user area to bring update the site he himself, as a form
to enter with the texts and images, and to be inserted automatically following the layout and design of the site, and the images with the accurate measures.
I am having problems sending emails via the CDO.Message object from an
ASP script which was working fine. On the server I can still send
emails via the CDO.Message from a .vbs script executed on the desktop.
If I pause the SMTP service I can see mails queuing up from the .vbs
script but the ASP script no longer generates emails, nor does it error
when it creates the object.
Could this be a permissions problem? No IIS settings have changed, but
the server downloads automatic Windows updates.
I'm used to passing information between asp pages but now need to try something different. I've set up a page which loops through a database table and shows the results in text boxes.
I want the user to be able to change the text and then update the database. I guess this would be passing the whole page to another page which will use oRS.update. I can't imagine how I can pass the looped text to a receiving page.
I'm trying to install the Devices Update 4.0 but it failes every time with the error
"Application has generated an exception that could not be handled." Does anybody has any idea where I could find what's going wrong, or who I have to contact for support on Devices Update at Microsoft? As Devices Update is a free download.
Im trying to get a drop-down box that when a value inside it is selected, it updates a data grid below.
I am making a world cup fantasy football league between a few buddies and i want for each person to view points stats etc on a web page which connects to a database.
On one of these pages which i want help with has a list of Managers, and when a manager is selected it will show in a data grid their chosen squad of players.
I can get a page to select each teams squad, but at the moment i only know how to do that as a set of unique pages for each team which would be time consuming to do. Therefore a drop-down list of the team names would be a lot easier if it could update the page when a value is selected. Code:
I would like to know that ,is there any way that the asp page would get refreshed automatically when there is an update in a tbale in SQL Server. The page should get refresh automatically on updates in SQL Server. The user will not hit refresh button neither I want the page to have meta-refresh tag.
View Replies View RelatedWhat I want to do I select one database and the set the Rs1, rs2 etc.. like in Vb6 I would set DB then:
Set rs1 = db1.OpenRecordSet("Table1")
Set rs2 = db1.OpenRecordSet("Table2")
etc...
However how do I do this in asp3? Code:
I'm trying to create a single form to update multiple records in a database (Access). Similar to an update qty's in a shopping basket, whereby, on submit/update it passes and updates each record, without using the ONCHANGE feature (otherwise this would become an extremely laborious task in this application)
I've tried passing and updating an array but to no avail (maybe I'm doing something wrong)
Also, I can't seem to grab the contents of the form text field, even though I'm dynamically assigning names to each text field.
Should I be using Javascript to handle the change in values, if so, anyone got any sample code/helpful links?
<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.
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