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 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.
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?
I released to open source a while back but forgot to post in here a DLL that was used in some of our older developments. It's not really a live project, but may be of use to peeps in here given some of the recent queries:Quote:
DBSite: Written in Visual Basic this DLL helps solve issues for ASP web developers, e.g. handling uploads, safe parameter population for stored procedures (sql injection checks), SQL XML calls, file system browsing, etc.
I was trying:
Code:
<!--#include file="lang/<%= Request.QueryString("lang") %>.asp"-->
But it doesn’t work.
How can i create a multi tab page in asp.net 2.0?
create a frame and a number of page with hyperlink?
Would i have some directives?
How can I update/delete a record which is linked to another table with a
unique field. I know the select inner join, but no update/delete.
Trying to join three tables and find the records which DON'T match OR have less than x number of matches.Not sure how to go about it.keep getting matching fields only.
View Replies View RelatedI need to create in asp/access/javascript a questionnaire that shows a single question on each page of which there are five then after the last question create a new record in the access db and write the answers.
View Replies View RelatedI have written a asp application whihc uses a number of pages and each page connects to a sql database.
Currently I have the connection script coded on each page however if i need to change the database I have to change every page.
I have been told there is a way to have the connection on one page and each page to referance this one so I only need to change the one page
As part of the development of a shopping basket function, I've a two dimensional aray which I'm storing in the session variable.
I want the array to be dynamic to store any amount of products which may added.
I am getting a problem when trying to write to the second row to the array, saying that the subscript is out of range...
You can see an example of this at:
http://www.foulkestudios.com/session.asp
I am getting what should be the first empty row by getting rows=UBound(myArray,2)
I'm then trying to add into the next row by using rows + 1
I am b-testing a community site, with currently 1,000 or so membership,
and low concurrency, say no more than 5 on-line at once.
The site is hosted on a shared server, which is sufferening from
intermittent accute slowness, affecting all other hosted sites as well as
mine.
The finger of suspicion is pointing at me and possible sloppy code. As
this is the first site I have done of this nature, could someone recommend
reading matter (knowledge bases etc), especially coding samples, in
connection with data connections (opening and closing connections and
objects) and record locking issues, which if improperly coded, could
contribute to throughput bottlenecks due to inefficient use of resources so
that I can check out my pages and correct any nasties..
I am think to write a code that will need more then 2 servers.
Can anyone give me some information to do code like that?
Like yahoo, google, msn.
I need to develop an application that will span 12 or so pages, and on the
last page, it lets the user review the data and then insert it all. This is
kind of like selling something on eBay, you give it information, click next,
enter more info and then at the end you review and submit the item. I was
thinking about sessions, but some of the fields are pretty big, like
varchar(5000) so I didn't know if there was a way to handle these big
fields.
I am in the process of developing several web sites that will accommodate up to 3 or 4 languages. The sites are not that complex, but will use an Access database for some data presentation/storage. Each page will have a series of flags for respective languages. Ideally, if someone enters on a "gateway" page for say Gallery, and they choose another language, I would like the same page to display but in a different language (there might be a page for each language, but if I can avoid that I'd rather).
So here are my thoughts on how to approach this. Have a session var for language preference and set it in a Global.asa file. I would think it could be set dependant on the origin of the request, .de, .co.uk, .it, etc. Then, if the code is not too verbose, use Case statements in the code to display content based on language preference. One thing of a bit challenging for me is that if the "flags" are in an include file, how can I get them to when clicked go to a script, change the session variable and return to the page from which it was clicked. Am I on the right track with this approach.
I have a database full of info and I have display.asp which I want to display 10 items at a time so I have display.asp?page=1, display.asp?page=2, etc.
How do I go about actually filtering the database to only produce 10 results per page? I was trying to use:
results.Move 10
and things like that, but I'm not sure of the best way around this.
I have a table in the db and one field in the db is an email field various records can have the same email address in. When an email address changes from x to y I want to be able to change an email address x in every record in the table to y, how would I do this?
View Replies View RelatedI was wondering if anyone had any links to some resources / tutorials or could offer up some help with regards to my current project.
The concept is pretty simple. Multiple user login - which are then presented with a page where they need to answer some questions (drop-down responses). These responses are then checked against the answers and the points are then added and the results list the different users in descending order.
Help and suggestions with any part of this would be greatly appreciated!
I know this will be linked to a database (open to suggestions about which to use) and then how to structure my tables.
Will the Request.form show the correct order that they were displyed in or
will it do something different. I have been testing and it always shows the
order they were displayed.Is this just coincidental?
Simple question no doubt -
I am trying to send an email to a form variable as well as a list of addresses, but I can't seem to get it to work. Please help.
I want to combine these two lines - what is the syntax?
Code:
MyCDONTSMail.To= "xxxxxxx@nzl.xerox.com"
Code:
MyCDONTSMail.To= creat_email
They work individually (I have declared creat_email).
I have two multi-select boxes...selLeft and selRight. The user moves choices from selLeft to selRight with arrow buttons. selLeft is populated using XML.
My question is, when clearing everything on the screen, how do I repopulate selLeft, without losing items in selRight or repeating items left in selLeft.
I'm a newbie and not familiar with the code used to build the multi select box in the first place. Code: