Interface For Editing SQL DB Tables
I'm moving away from Access db's to MS SQL Server databases for storing form records.
While the MS SQL Server provides all the tools I need to edit/delete/add records, I need to provide an interface for non-technical people for obvious reasons.
I have a halfway decent one for manipulating Access databases but it doesn't seem to translate over to SQL Server too well. Obviously I'm fairly new to ASP and SQL but I've tried everything to make this editor work for SQL server.
So, I would like to just start from scratch and ask if anyone has an asp script that acts as a front-end to edit/delete/add records - nothing too fancy.
View Replies
ADVERTISEMENT
i would like some assistance in creating a user interface that reads from a database.
View Replies
View Related
Is asp/asp.net able to interface with the PC's I/O ports? I'm currently doing a program on VB using the SDK from the vendor to interface my biometric scanner to my PC using usb port. Can this same thing be done using asp?
View Replies
View Related
i have a website and i use do import data , but with diffrent types(*.xls,*.xml...)
how can i concept a inteface to read all this files
i now my question is not clear but iit's freindly to answer me
View Replies
View Related
I made this little application-variable interface to help me see what application variables/values I currently have on the server and it lets me easily add or remove single variables, remove all the variables, or re-create the variables I declare in an ASP file called "CreateVariables.asp". Code:
View Replies
View Related
i'm getting a bit cought up with the ASP for a poll creation page i am trying to do.
i am trying to get it so that it will display a varying number of boxes depending on how many options there will be - have it so that it displays the first 2 (the minimum options) and then the other input form elements will be added as needed i'm also having a bit of trouble trying to get the numbers to update with the onchange but that part doesnt feel like its the most challenging - heres what i have so far: Code:
View Replies
View Related
how to access Outlook methods to generate an "add contact" event on the local user's machine. Most of the info I'm finding relates to Exchange server, not the local instance of OUtlook.
This event will be spawned from an intranet-based ASP page. The online contacts list will have a button to add the contact. On click, the default contact form will be displayed, with the primary fields pre-populated from the recordset selected. I'm sure this is a no-brainer, but haven't done this before.
View Replies
View Related
Is it possible that my asp web application can interface with the hardware? like the PIC or the microcontroller? and if it is possible, what im gonna do?
View Replies
View Related
We got two interface. Staff and member. When member login, they are brought to member's page. However, when staff login, they are also brought to member's page. This is because at Dreamweaver 8, we have specified that if login succeeds, go to member.asp.
So how do I make sure that when staff login, they go to their staff.asp.? Is it by command procedures or SQL or some kind of other function? Much help needed! Project deadline is just around the corner!!!
View Replies
View Related
I'm having a problems when trying to make a DLL in VB6. The code is using ScriptingContext to access the Cookies-collection from the asp-pages, but when I try making the DLL I get the following error-message:
**************
Compile error:
Function of interface marked as restricted, or the function uses an
Automation type not supported in Visual Basic.
**************
When I click OK, ScriptingContext.Request.Cookies is marked. Could anyone please help me with this problem? I'm more of a .NET guy but some of the applications that I'm in charge of are still using ASP and COM+ so unfortunately I'm not too familiar with these techniques.
View Replies
View Related
I am wondering if it's possible to simulate the Multiple Document Interface
in ASP/ASP.NET webpages? Maybe using DIV layers? I am trying to create the
little document windows in an application, but in a webpage. I need
dragging, overlap, focusing, resizing capabilites. Also must be able to
encapsulate another DIV layer within this DIV layer. Is this possible?
Does anyone know a library (already-made) div/layer MDI windows for
webpages?
View Replies
View Related
i often to make a user interface in access for data entry using Grid view. is there a possibility to make Data Entry user interface using Grid in ASP?
View Replies
View Related
I know how to create dynamic tables in dreamweaver to display fields and records in a table of a database, but in my case I need to create a dynamic table that lists all the tables in the database, then to click on the one i want 2 edit the data in there.
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'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
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 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
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 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
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
When I type out my new stuff in the edit field I click submit and get this error. The next post is my code for the entire page.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/hwnetwork/edit1.asp, line 110
View Replies
View Related
I am working on the form where the client can go back and uncheck and check collections to be assigned. This is in a different table. The collections come from a table called Collections.
The products table adds collectionID of each collection selected in the RelProdCollection Table. I need to be able to allow the user to edit the collections by unchecking and checking check boxes on the form. Let me show you my code.
Code That Displays All of the Collections dynamically in a check box. But it doesn't show the values if there are some collections that are checked by a product with a productID of 4. I need that code:
View Replies
View Related
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
Is it possible to write a web based text editor? For example, is there a way to edit an asp file using an asp file? Here is what I have so far but instead of displaying the asp code it just displays the output html, Can I display the asp code so I can edit files without being at my computer and not using FTP?
Here is the current code:
Code:
<textarea name="editor" rows="35" cols="120">
<!-- #include file="default.asp" -->
</textarea>
View Replies
View Related
I have been searching the web for hours trying to find a simple tutorial or code example for what i need, but i have had no luck. What i need is very simple. I have an asp news page which will simply feed off a .txt file (hopfully maintaining line breaks).
All i want is another simple asp page which will display the content of that text file in a html form (one field), so that the user can simply edit or add to the text using that form, click submit and the text file will be updated.
View Replies
View Related
