Edit Database Directly
I'm keen to learn how to do some simple asp script so that I can access my customer database over the internet from various locations.
I want to know how to write the appropriate script into an html form (I use MS Frontpage as an editor) so that when I log in to my site I will be able to see and edit this database directly on the net without having to download the file for editing, then upload it again until next time.I understand that I will have to save my database as a MS Access file (*.mdb) because this format will work better with asp commands.
If you know of an online Dummies Guide to ASP please let me have the link so I can learn some of the basics without having to bore you with working through all that.
View Replies
ADVERTISEMENT
I am trying to retrieve and updata a MS Access record with the following code:
View Replies
View Related
I have built a set of forms to add delete and edit records on my database for asp pages the add and delete are working fine but the edit form opens and I can change the field but if I try to update the record I get the following error MM_editCmd.
View Replies
View Related
I have index.asp (Form) & process.asp (submit data from index.asp to Access Database), the Form is running Perfectly.
But, How can I create a login name and page for the applicants to edit the information they submitted?
Let say I have Email (username), Password (password) & lastname on index.asp, then I really have no clue!
View Replies
View Related
I have the page "content.asp" and it is called from the "menu.asp" page.
Two page are on diffenent servers and on different Databases.
Users who request the content.asp page are authenticated when they enter the
"menu.asp" page.
So, if another authentication is required when users enter "conent.asp", it
is redundent, I think.
Finally, I want to reject users requests for content.asp if the page
"contnet.asp" is requested directly from URL.
Are there ways if the page content.asp is called from URL or the <a> tag in
the menu.asp?
View Replies
View Related
When somebody downloads my Setup Program from my Web-Site they are taken to a blank page first so that I can use this to record the download hits, then the download window comes up.
How can it be done so that when somebody clicks on the download link, the download window comes up, but by this stage I have recorded this as a download hit,without having to display a blank page on the browser first?
View Replies
View Related
In order to test some pages of mine, is possible to directly hard-code a request passing some parameters in a post method to an asp page?
View Replies
View Related
we have web users that have requested the web application access an existing
excel spreadsheet directly.
Users have an excle spreadsheet with complex functions, macros, formatting
etc. They have data in the database that is accessed via a web applciation.
They would like to use the web app to get the data they want on screen and
then click a button to get that data and put it into specifc cells in the
spreadsheet. is this possible?
View Replies
View Related
I need to provide a way to download a software and its corresponding
manual from a web page.
So far I have done the sign in page where people give their data. I
will then give access to a page with a link allowing to download the
required file(s).
My worry is how to avoid that somebody grabs the URL of the file and
send it to another for downloading directly from the server. What can
I do to avoid this ?
View Replies
View Related
Theres a script that bypasses ODBC and connects directly to .mdb database for asp scripts , is anyone familiar with this? I dont even know if its a .asp script.
View Replies
View Related
I'm looking for an activex com that will be given an existing url and turn it into pdf binary stream (no files on the server) either that or turn into a tiff image.
I would like something that has a small footprint meaning no impersonation, no visual screens, just pure sdk ...
View Replies
View Related
I currently have my database set up so that when a user uploads a file, it writes it in binary in the database. I know the benefits of having a separate file server and storing the path, but unfortunately, I can not do it that way.
I know how to include the file in, lets say, a hyperlink so that any user can click on the file to view it. But, I would like to know how to include the file (mainly pictures) directly into the page as an <img src> Any suggestions?
P.S.
Once the information is in the database, these are the commands I use to output the file to a hyperlink. The file that this code is in is "file.asp?Id=" Where the Id is taken from the URL and used to obtain the correct file. I left out all the connection/cmd strings intentionally just show I could show the relevant information:
Response.AddHeader "Content-Disposition", "filename=" & _
rs("FileName")
Response.ContentType = rs("ContentType")
Response.BinaryWrite RS("FileData")
View Replies
View Related
Does anyone know how to save an export excel file to the server automatically without any prompting and opening of the excel file?
Because I'm doing archiving, I need to let the user click on the archive button and the exported excel file will be saved directly to the server without opening the file.
View Replies
View Related
I have registered a domain, if i want to check my mail i had provision to go to there web server mail page from there i could login and see my emails,
i have a created home page in ASP there i had login page with username and password,
if i enter the username and password it should straight away take me to the email folder(accessing from my home page rather than going to the their web server login page)....
View Replies
View Related
how to print the content of a multiline textbox without taking the content to some other "printer friendly" page. I just wanna send whatevers in the textbox directly to the printer.
View Replies
View Related
I have page for user to update his/her details. What i want is after idle for more than 20 mins, the page will redirect to login page automatically. So that the user knows that his/her session already expired and need to login again.
But it doesn't working. This is because if he/she update the details (after idle more than 20 mins), and click the Submit button, it will go to login page and all the data will be lost. Code:
View Replies
View Related
I want to display a recordset in an editable form. The TblID can be a listbox and the content related to the id will be displayed where i can edit them i've tried everything and nothing is workin so if some1 can help me i will be gr8full. (w/ VBscript Only)
PS: If some has a URL or a code to share i will appriciate it . i know it's so much to ask but i really need it and i've reached a dead end .
View Replies
View Related
I need to be able to edit a drop down box is asp. On my web app I
populate a drop down box from a databse. The user can then select an
option that will then be saved to a Database for example
Mr
Mrs
Miss
but if the option is not their e.g Dr, Prof etc then I want them to be
able to enter in the drop down box and then I will save this to the
database.
I know that I will have to have a function to dynamically re-populate
the Drop down box to include this option once the new value has been
entered, so that it will be included in the POST method.
But I can't even edit the text. I have tried
<SELECT>
<OPTION selected contenteditable=true> value="Mr">Mr</OPTION>
</SELECT>
and
<SELECT contenteditable=true>
<OPTION selected> value="Mr">Mr</OPTION>
</SELECT>
View Replies
View Related
I have a form which I would like to allow a customer to edit/update. I need to populate the text boxes with retrieved data and then allow customer to select 'update' button. I can't figure out the syntax to place the retrieved value within an input box.
I have this so far, which obviously doesn't work - double quotes etc. Tried double and single quotes but no value appears.
Also tried placing retrieved value within variable, but didn';t work either.
<input type="text" name="FirstName" value="<%=rsdetails("FirstName")%>"
View Replies
View Related
I m trying to edit forms like "Record Insertion Form" and "Master Detail Page Set",
once i click ok, i don't know how to bring up the dialogues again.
My question is how can i bring the "Record Insertion Form"/"Master Detail Page Set" dialogue up again so i can change some settings after i clicked ok.
View Replies
View Related
I'm currently working on cms gallery. I need a component that can take images +/- 800kb and resize them into tumbnails.
I have used AspJpeg until now, but I think it's a little slow.. Do any of you have any suggestion about what's the best upload component and image component to put together in a app?
View Replies
View Related
I'm currently thinking of a good way to edit records from using an ASP page.
I got the page to display the table (all records) and next to each record, there's a button to "Edit" and "Delete", so basically the GUI is sort of ready to go.
But for the functionality part, I'm pretty much stuck. Please give me some ideas in how to make this work. Here's what I've got so far:
View Replies
View Related
I have an edit page that works successfully except for two dates at the bottom.
I'm trying to pull the dates out of the database so that they can be edited, if necessary.
At the moment when you go to the edit page the date fields are blank. This causes problems because if you update the page and leave the date fields blank then a default value of 1/1/1900 will overwrite your existing date - pain in the butt.
Therefore I need the date fields in my edit page to be filled from the existing dates in the database.
View Replies
View Related
I have a DataGrid which has checkbox columns. The data source is a run-time created data set that I store in a session so I can rebind it during postbacks. I don't have a database or xml file, etc.if it's possible to edit a dataset directly? So when I click on a checkbox it will change the value in the dataset and store it back into session?
If this is not possible how can I use arrays or vectors to temporary store my checkbox statuses? I guess it's not possible to have one DataGrid have more than one datasource
View Replies
View Related
I have recently started a new programming job with a new company. One of the tasks they have me working on is editing and maintaining an ASP web application. Two of the problems they need me to fix with this application, involve editing a previously created com+ object.
There is no documentation on this com object, however, that is where the application bombs. I can only find very old versions of the class(.cls) file that was used to compile the com+ dll.
I don't have very much knowledge of com+ objects, is there an easy way that I can edit this com+ object that I am missing?? I have been trying to decompile and unassemble this thing, but it can't be as difficult as all that, can it??
View Replies
View Related
I want to open an excel xls file with asp and edit some cells of it and save it back.
The excel file contains 2 worksheets.How can i do so?
View Replies
View Related
users around the internet need to edit the same spreadsheet. I don't want to code a bunch of pages for each spreadsheet we create. I know that a spreadsheet will open in a browser, but is it possible to save it back to the server, without downloading and re-uploading? What is the shortest path to success on this?
View Replies
View Related
how i can edit and delete records?
View Replies
View Related
I have HTML documents. Nothing fancy. I want the ability to edit them, via a web interface, without a DB backend. I also want the ability to create HTML pages from a template. but how?
View Replies
View Related
Rather than deleting I'd much prefer jsut to change a row. What is the rs.adnew as edit (as with VB6) does not seem to work. Code:
adoCon.Execute("DELETE * FROM TableNum")
'
With rs
rs.AddNew
rs.Fields("NextClientID") = vClientID + 1
rs.Update
End With
View Replies
View Related
what is the easiest way to edit records on asp.net page? I have an Access database on a remote server and I want to be able to search through, add, delete and edit the records. Is the easiest way to do this by creating a Data Access Page in Access?- if so is it possible to create ASP pages based on the forms in the database?
I've read through some material on ASP and DataControl but it seems very complicated- does anyone know if there are any good examples of ASP code that lists items in a table and allows the user to edit and delete them?
View Replies
View Related
I am trying to edit text entered in a textbox. I have previously used a function where you can specify certain characters to be removed from a text string but I can't remember what it is.
View Replies
View Related
