Database Editing Solution
I have a roster of people from a db showing up in a frame containing ans asp page. In order for the client to edit a record on the roster, I have an edit page opening up in a javascript pop-up.
I know how to edit the db but what I don't know is how to 'bind' the text boxes in the pop up to the correct record in the db (based on which record they selected to edit). Here is how it looks:
John Smith 12 123 Main Street Your Town State edit this
the 'edit this' is a link that opens the pop-up. How can I get the correct record to show up in the pop up?
View Replies
ADVERTISEMENT
I can edit information in tables no problem with insert delete etc etc. My question: is it possible to edit the tables themselves ie make new fields, tables etc! If so can someone provide a simple example or point me to a tutorial im sure I will pick it up pretty quick but I have no idea where to start!
View Replies
View Related
I'm thinking of developing a relatively small news system for my website, but I'm wondering if there is a nice free file-contained database solution. Access would be great except for the screwy licensing.
I don't like these server-based databases because I'd like to just plop the DB in a dir somewhere and have the system portable.
View Replies
View Related
I'm new to programming databases with MS Access. I'd like to know how I get user input for a database, in a form, read from it and do "if" statements. Does anyone know how to do this? I've tried ASP approaches (with the FSO function and .txt files) but none are as effiecient and organized as databases appear to be.
View Replies
View Related
actually, I have a problem while i want to add, delete, or edit a record to a database through a asp page, I can read well but when i want to submit changes using rds object , the data does not change on the source database,
I tried hard to get a solution but i think that the actual problem is only on one figure which is the server value of the data control when i use my own iis server, I do not know this value and microsoft is saying use an empty value but it does not work either.
View Replies
View Related
1. SELECT VALUES FROM TABLE A WHERE ID=5
2. I create an array x(0,n), and I populate n with the values based on
select above.
What I have... I have x(0,1)
x(0,2)
x(0,3)... and so on.
Result:> I need to have variable called
varx that should consist all the values from x(0,1), x(0,2), x(0,n).
So I need to declare varx = x(0,1) & "," & x(0,2) & etc.
1. question. I don't know how many elements I would have, coz they depends
on "select".
2. Can someone give me example how I can dynamicly create (parse) this
values in single variable, so I can send this values to pageB.asp
View Replies
View Related
After a member registers, he's able to access and download any file
available. We want to avoid the end user being able to distribute an URL
to these files thereby making it simple for other users to download them.
Solution I'm working on:
I have a variety of files (html, pdf, doc, xls, and others) sitting
outside my "wwwroot" folder. I have an ASP script which checks the MIME
type for the given file and now, my problem is, how do I use the
FileSystemObject to grab those files and display them to the user?
Let's suppose the user is requesting demo.html. I use the FSO to open
the demo.html in the folder outside the wwwroot, and then set the mime
type and then what do I do? Response.write? What about binary files
which need to trigger a download action?
View Replies
View Related
my client wants a forum integrated in his website. Ive found some existing forum solutions (snitz, carbon communities etc...). These are great, but my client wants the forum working whereby when a user posts, the post is sent to the clients who then confirms or denies the post. The forum is for a school, hence the very tight regulation of posts.
Does anybody know of an existing forum which allows this functionality (preferably a free forum).
View Replies
View Related
I have a script on my asp page which takes values entered from a form and inputs it into a database, in their appropriate fields. It's been working fine, but lately I'm noticing that I've been getting some blank records being entered in my DB table.
I know it's not my form becuase there is no way to leave it entirely blank, so even if you don't enter anything... their are hidden fields which already contains a value that get's passed and goes into the DB.
I am wondering if this is a result of many people entering data into the access db at the same time, and i'm wondering if i have the right locktype parameter.
I am using adLockPessimistic right now... should that be adLockOptimistic or adLockBatchOptimistic????
and should the cursor type be adOpenDynamic???
View Replies
View Related
I am trying to implement a printing to file solution of a html page on the server. What I have is a form with a IE control that loads the page I want to print to.
I am using execWB command for printing. Printer's port is set 'To file'. Everything works fine when I am running that component from a desktop apps. But when I call that component from an asp page nothing is happening. I dont see any dialogs popping up on the screen.
BTW, if I print to a printer works fine either.
View Replies
View Related
I'm in the process of 'trying' to write a very small CMS which will allow me update an existing XML script I have.
Unfortunately I just cannot get the script to work, my script falls over with an objRoot error when I try to set the objField using selectsinglenode. XML looks like this:
View Replies
View Related
Is it possible to edit an asp file using filesystem? when I read a
text file using filesystem it doesnt show me the asp code in the <%
tags as this code is run server side, but is there a way to read ande
edit this code from another asp file
View Replies
View Related
It is saturday night and guess what i'm doing. Friggin geek.
anyway. I have another question for you guys. I have a form to send emails. But i want the user of the form to be able to edit the html content, so if he wants to add bold text he can just click a button and the <b></b> tags apear in the body textbox. Much like the options we have here press the button # and you get the quote tags on screen.
I looked all over but nobody seems to have anything on that particular feature. So i was wondering if any of you could tell me or at least point me on the right direction.
View Replies
View Related
I have a .js menu file that runs in all of my intranet
files.I have an asp calendar system where I can add
calendar names to a db and it will display these new
calendars. What I don't have is a good way to edit my .js
menu file to add a new menu item.
Can fso add a line to a .js file that is "live" on an
intranet or will it run into file locks? by iis?
View Replies
View Related
I'm hoping for an easy solution to this that I'm not seeing that
someone more experienced will.
All I want to do it mark an option tag as selected....
<%
hourCounter = 1
Do WHILE hourCounter <= 12 %>
<option value="<%=hourCounter%>" <%If hourCounter =
hour(rsCalendarEdit("fld_calendar_DateTime")) Then Response.write "
selected" End If %>><%=hourCounter%></option>
<% hourCounter = hourCounter + 1
Loop
%>
The trouble is if the time is "PM" I have a problem as you can see. Is
there a method or property here I can implement that I'm not seeing?
View Replies
View Related
We've been asked to upgrade the system and one of the common complaints is that they often have to edit just one field, but for all the students. Currently you have a list of students and you have to click each one and go to their summary page before you can edit anything.
So they've asked if there is there any way of creating a 'spreadsheet like' view of my data and allowing the user to edit and either save everything, or save each row as they go (without causing a page refresh).
I managed to get a basic idea up and running, involving lots of wee forms or one big form... but my ASP ended up creating 266 SQL queries to do the saving (one for each pupil) ... and the script would just take forever. Code:
View Replies
View Related
I'd like to know if there is any robust FTP solution out there that
integrates well with ASP applications. In particular, it has to allow huge
uploads over 3 gigabytes in size. It must have the ability to resume
incomplete uploads by the users.
View Replies
View Related
I have a recordset where when a user uploads a file, the field on the recordset will create the word "Processing". Once the Administrator logs on and gets the uploaded file, it will provide that record with a File Number. The problem I am having is that when I go in the form to create the "File Number", the field where it printed the date of the upload, disappears.....
View Replies
View Related
What's the best free method of getting attractive looking charts to display data from a DB.For example, in my next project i will need to show the change in someone's weight over time. The different weight in pounds(lbs) will be entered into the database along with the date that the weight was entered.
Whats the best way to show it? I can't install any 3rd party com's on the server.I have seen a website offering a flash based solution. Is this the best way? Ideally i would like a line graph, rather than a bar chart.
View Replies
View Related
I need an ASP dictionary/glossary script. I saw a bunch of options online for PHP but almost nothing for ASP. I'm not a programmer....but can install working code and connect a database. can anyone recommend a tutorial or even better a finished working piece of code I can implement to create my own dictionary with custom definitions?
View Replies
View Related
Can you edit ASP pages using dreamweaver without being connected to a test server? If so, how?
View Replies
View Related
Does anybody know how to edit an existing word document using ASP or VBScript. For instance, I have some text in the doc that I want to change to something else. Is this possible?
View Replies
View Related
I am currently writing a script for a course i am doing, It lists all the files and folders on the server, and works similar to windows explorer ( if you click on the folder it shows the content ). I have enabled it so you can delete, view source, and download all files/folders.
Now theres one more thing i would like to do, and that is to enable the user to edit a file, and i am struggling quite a bit, any guidance, ideas or links to a similar tutorial. I am probably going about it completley the wrong way, I was trying to open the file read each line and write it into a textarea, so the user could edit it, and then save it.
View Replies
View Related
I know how to read a file system object and output it to the browser page. The desired result would be to put that file into a textbox on the screen for a user to modify and then write the file back to the file system.
The concept seems simple enough, read the text file into a variable then some magic asp will put it into a textbox value, then somehow take that value and write the file. I know how to write files to the system as well. I am missing a key piece.. any ideas?
View Replies
View Related
What is the best Method, for deleting or editing existing XML Data? I have a form that submits to XML via ASP using VBScript. I now need to pull data into another ASP page which allows for either Editing or Deleting Individual fields.
I know I can use XSL but is there any better methods as the original form imports data into the Drop Down lists?
View Replies
View Related
I can get the data from my database to be displayed in a table, but how can i get the data to be displayed in a way that it can be edited? Can i populate a form from the database? If i can, how would i go about it please?
View Replies
View Related
I am using adRotator to rotate some reminders on my intranet site. I have a
redirect page name redirect.asp that recieves the querystring variable, 'url'
and redirects the user to that page. One of the reminders should be
redirected to a url that contains query strings itself. The url passes in the
string up to the first '&'. What should I do. Here is the code on the page
displaying the ad: Code:
View Replies
View Related
i have been using Notetab Lite for PHP, Perl and HTML editing. I see it can be used for ASP work. There is a fair amount of files (ASP) to modify; will NoteTab Lite do the job? The files have quite a bit of VBScript code in them. I have heard that Crimson Editor is better than NoteTab Lite, for ASP work. I notice that Crimson editor 'color highlights' the VBS and the xhtml code, which is easier to view than Note Tab Lite.
I would like an editor that will be able to syntax check the VBScript code, if possible. Also, is there any method of viewing ASP files locally . This would save me lots of uploading/testing the modifications, if I could test locally (i) the syntax of both the VBS and xhtml code , and (ii) See what the form looks like. The ASP application uses an MS Access database. I do have Access 2000 Developer and VBA.
View Replies
View Related
Can anyone help me find a solution to quickly working out relative paths to
a folder in the root of my server...
Although it easy when you go - say - two levels down:
.../includes
it becomes increasingly difficult to ball park the folder when you go deeper
and wider down:
.../.../.../includes
....How do you guys get a quick fix on where the hell the folder or file is
and use that path in asp?
View Replies
View Related
I am looking for an asp change password solution. I know there are very
efficient ways of doing it and perhaps you have some samples or ideas.
Basically I would like the user to be able to change their password. Then a
link is mailed to their email address on file and when they click on the
link, they are taken to a place to type in a new password.
View Replies
View Related
i have a simple form in a html page.
the form successfully sends data to my database using asp.
currently sending details using
<input type="submit" value="Submit">
which as you know uses the small grey box Submit button.
what i would like instead, is that instead of using this default button to submit..
i could replace that with a roll over image, that is compiled of the 2 files
submit.gif and submit-white.gif
and when it is pressed, the form details are posted, how can this be done
View Replies
View Related
Has anyone had any luck editing the Microsoft Outlook Web Access pages? I am setting up my company's new OWA 2003 server. Now here's the problem, I had to create new logon pages because we authenticate to a different domain then the server is on (stupid mergers).
Now when the logout button is clicked on the page, it takes you back to the default logon page. Were a user to try and log back in from here it wouldn't work. Now simply adding a "response.redirect" to that page seems to break their code completely. So has anyone managed to do this and could let me know how?
View Replies
View Related
I am in need of something like mod_rewrite or an alternate solution.
I have a client, who's website is all HTML files (200+ files) and was previously password protected by javascript only. Anyway, what I need to do is password protect the site using a better solution, which would be a server side scripting obviously.
I am familiar with apache's mod_rewrite and PHP, which would make this problem easy to solve by simply passing the HTML file to a php file, then after neccessary security checks, pass the requested html back to the browser..
The only problem is that its on an ASP server and I have no knowledge of ASP. I am not even 100% positive what kind of server it is, I just know that .asp files work in it and .php does not.
Anyone know of something like mod_rewrite for ASP or an alternate solution that would work in my situation?
View Replies
View Related
