I want to add record in my form. Previously i can only add 1 record and click on Add button to add 2nd record. Is it possible for me to directly add 2nd record? So i will have 2 options here, view the list and add 2nd record or directly add 2nd record.
View RepliesI have a page that is showing X number of records. I have a column with a check box in front of each record. I would like the user to be able to select certain records by selecting the check box in front of the record and then have the user hit "Submit." They will then be taken to another page in which only the selected records are shown.
I'm having trouble with my SQL statement. I'm not quite sure how to word my SQL statement since I do not have a field in my recordset that points to the value in the checkbox.
In other words, I'm not sure how to carry the value of the checkbox over into my SQL statement when I don't have a field for it. Do I need to add a field, and then update the field on a confirmation page before I use a SQL statement to show me the selected records?
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
View Replies View RelatedI have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
I've got IIS installed and running on Win 2000 Professional. However it
seems that I cannot view asp code. To test I've used the good old "Hello
world" example.
When run through localhost I'm met with page cannot be displayed.
When run through c:inetpubwwwroot, I'm met with a blank page yet I can
view the text in HTML.
I've checked my properties for home directory and I've got TCP port 80,
execute permissions as script only and application protection as
medium(pooled).
The local path address is correct and its set to Read, Log visits and Index
this resource.
I have a registered user that buys a product online. The user supplies his/her email during the order also for verification purposes.
What I want to do as an Administrator is to be able to see that users first name and surname on my "Completed Orders" page (which dynamically refreshed every time a new order is made) using the email to get them from the database.
Code: .....
i had created an asp file and want to upload it to the server...however, when i uploaded
the file..the file cannot be viewed through internet...why?do i need to set anything at the server?
I have a asp code that shows the values from a database. But here it shows all the values in one page. I want to make each record appear in a new page. How can i do it. Code:
View Replies View RelatedI recently upgraded my PC from Windows XP Home to XP
Professional, so that I can use XP Pro's build in IIS
functionality to build ASP pages off of my home PC. I
have installed IIS 5.1, configured it and tried several
other things (restarting the server, configuring a web
project, etc.).
When I attempt to view the page using
the project name and computer name (in this case, it
would be http://apollo/twinadev/), the status bar shows
that IE is attempting to connect to the page, but after a
long timeout period, I finally receive a Page Cannot Be
Displayed Error.
I actually want tree view which can dynamically display
all the child nodes(undifinte) dynamically.
I have a soccer database I am working on. My boys play once a week. I would like to have a way to query past games meaning the one they play the week before. So another words we played this sunday score was 1 -0, on my home page with my query I would like it to show 1 - 0 against so and so. Next week when we play again, I want the next team we played then to show up on the home page. So in essance the most recent game played to be displayed. In data base i Have a table called schedule, in that schedule I have a field called GameDate which defines the day of the game. How would I create a query that would pull all recent games played up until the next game day.
View Replies View Relatedyet my colleague can? (when looking at exactly the same page - same destination folder etc)
Is there some sort of setting, so that you dont only see those small yellow ASP blocks when looking at the design view, and see the layout of the page , with the tables etc?
I realise that most of you gurus dont use the design view at all, but it is something that using ASP,
How can we disable the browser to view the code..
i faced this question in interview..
what would be answer for this
I have designed a page that list department projects. I have decided to add sub projects to main projects that are listed. I would like to be able to view the sub projects on the main page where all of the main projects are listed. I would like it to look like something in Access when you have sub records that are related to a main record.
In Access you click on the + sign and it opens up the related records and then you can click on the - to close them. Even something like is on this page up at the top where it has the main folder (ASP Free Forums) with a sub folder connected to it. (Post New Thread) Something like that would be perfect.
I am able to show the associated sub projects when I click on a detail button that isolates that record, but I can't think of how I would do this on the main page with several records. Any ideas how I could do this or examples of where I can find some similar code that will accomplish this? I'm not even what sure as to what key words to type into Google.
I expect this has been covered before but I can't anything to reflect this. How (with code) can you view folders within a directory from within a drop down menu?
View Replies View RelatedI installed iis and wrote a simple script.I get a password protected pop up when I access:
localhost/tests/tests.asp
i had created an .asp file for my website.however, it cannot be viewed using internet but through local computer, it can be viewed. the address http://www.perak.uitm.edu.my --> click on ''pengurusan atasan''link under UiTM Perak menu. tq.
View Replies View Relatedafter a member log in and he is redirected to the memberpage.as and there are a link to view his profile or details which is in the database in members table.
how can i view his details and he can make changes to it??? how many pages i have to do ? and the page which has his details should it be html with a form or should be asp page?
I have 2 tables, one has id, fname, lname, and the other has id, amount. I need to create a view to sumarize the total amount of each person, what's wrong with this:
create view myView (id, firstname, lastname, totalamount) as select d.id, firstname, lastname, sum(amount) as totalamount from mtcdata d, mtcbilling b where b.id=d.id
how can i built a tree view component in asp then tree view node values are get from data base. if any one know pls explain, how it possible?
View Replies View RelatedHow can I list all the tables in a MS Access database using ASP? Is there anyway of doing this with the ADO object?
View Replies View Relatedi have configured a web server at port 8888. i have a .asp page which i want to view it through browser. something like http://localhost:8888/test.asp isnt working.
View Replies View Relatedin a forum there is a section where it list out how many people have view the subject. i been thinking hard how to get it done but still can't.
View Replies View RelatedIIS5, on a Windows 2000 Server machine. Debeg.WriteLine "Hello, world!" How can i view it?
View Replies View RelatedI have a datbase (db2.mdb) on the server
Here is the information:
DB name-Addresses
Input - user
Input - password
Here is the script that I'm using to try to view, unsuccessfully, the user in this database. Does anyone see the error? Code:
On our IIS 5 windows 2000 web server we have many .asp's.most of which (When right clicked / security tab / edit authentication) are
using Integrated Windows Authentication.
Is there an easy way to check ALL of them? Some of the pages require a
higher level of security (Our password reset page for example) and I am just
auditing everything and want to make sure that only the few pages that
require it are using the elevated security level. (By the way this is
accomplished by using anonymous access with a domain account that is
'elevated'...
I hate right clicking on 1000 different .asps to see the file / directory
level authentication methods... is there an easy way to do this? Maybe
through resource kit command line tools or some meta edit type tool
I wanted to view the Event View log in a web page. I think using
OBJECT tag it can be done in HTML but I need to pass some PARAM
values.
I just dont know how to go about it.
If anyone can suggest a doc or some link on how to view objects like
these in a webpage i could manage it on my own.
This is my page that displays a certain players games played below. It sorts by games played and excludes all records that = 0. Now with 9 different grades to show i did not want 9 different pages, so i added in 'strSortGames' so that they can select which grade to view and only one page is needed.
I used a menu (list field) on a previous page to do this, do you no a better way to do this? e.g Text links or some other way? or is a list field a fairly good way? Code:
The code that i have presenting allows me to view the database entries and to choose what i want to edit and then to do an update. Its not allowing me to save my new changes back to the database. Code:
View Replies View RelatedI am trying to have a web page list the contents of my database table. I have been trying for ever and cannot find what I am doing wrong.
Here is my code: (I hope it is not a mess I am new too this)I have included comments to walk myself through this. Code:
When I open a page from an existing website file in VS 2003, the page
immediately executes without giving me the opportunity to view the code or
insert a stop or break. How to view the code?
I am using listview control in a asp page to populate some database
results.In some machines (which is having only OS and no other softwares
installed) this control is not loading. In machines in which visual basic is
installed it is loading properly.