I show information from a database in a table format. I will be showing more and more data and would like to show it one page at a time with a next page back page option.
Can I do this on a web page and does anyone know where I could look to find out how
There's an access database on an iisserver and asp makes updates to it. The
database got moved to a newer server. The users used to be able to open the
database and use the asp pages at the same time. Now when the database is
open the asp pages won't update.
there i was just windering how do i compare a date/time vlaue in sql server agaisnt the computers' date/time.
for example, if computer date/time is two months or 2 weeks before the database date/time do something
I have a website that I subscribe to that allows me to track tasks. I have an extra computer with a big monitor that i want to always display the task list. the problem is after so many hours I get logged out.
I need to need to reload that sign in url every few hours Code:
Any some tools or sample codes drop down asp script execute time and
database connection time ?
When we want to get data access, we need to specify the datasource name and
table name in ASP page. I want to know if we can get the list of databases
and tables of SQL Server at run time? i.e. The user can choose the database
or table to open, and get the records of the table?
i am selecting a field from a list .i want to show all the list after searching on the basis of that selected field from database in another list box which is on the same page.
I am trying to list a database (SQL) i a dropdown list but I just cant get it to work... I am writing in ASP. This is some of the code:
mySQL="SELECT ras.raser FROM ras ORDER by raser"
<tr>
<td width="220">Raser</select></td>
<td width="342" height="23">
<select name="idRas">
<%do while not rstemp.eof
pRaser= rstemp("raser")
%>
<option value='??????????' </option>
</select>
</td>
</tr>
An HTML page that have two dropdown list whit different values:
1. Dropdown list 1(tblname1) =values with different location's. After user
has selected one value from the dropdown it should show values from
(tblname2) in the dropdown list2.
2. When user select an value from dropdown list2(tblname2) and click on a
button "GO" it should show all the value's from the database that been
selected in dropdown list1 and 2.
Please someone please help me out with this problem!?
I need a vb 6 's list box equivelent component in web (HTML or ASP) ?The detail is. I need to develope a system in which a database offers list of items from which user will select its choice & that choice will be added to a list box of selected items. When user's selection finish he can see his selected items in a seprate list box In VB 6 it has been done using list boxes. If we create a web based system for that how we'll accomplish that.
View Replies View RelatedI need to have three list boxes automatically populating each other, (ie
when region is selected from the first listbox, it will populate
automatically the second one which is the TOWNS and when the town is
selected is should populate the third one AREA) all data is in the database
in one table.
I need to compare the files in a folder to ones that are entered into a database (filenames list) and update it to include ones that dont have entities.
Whats the best way to accomplish this ? I'v thought of creating an array out of the physical file entities then rolling through the database and deleting the array entities that already exist; that way I end up with an array of filenames that need to be entered into the DB. that way just a thought (I wouldnt even know how to do it) but I want to think it through more thoroughly before starting the code:
My question is this: how do I get a value from a listbox to assign to a variable (elementary I know)? Code:
View Replies View RelatedIs there anyway to store a list of data in an access database.
For example if i have several input text fields for a customer to add descriptions of a particular item, this list should then come together and be stored in one place in the database. This information should then be displayed in a list when retreiving the data from the database.
ive tried to explain what i am trying to achieve, if anyone can advise me on how to do this or for a better way to accomplish this.
what is code for populating a list menu with data from a database. also the default(first) option in the list should be "ALL".
View Replies View RelatedI have a list that has two pages or more. How to print all the pages
clicking a print button? Right now, it just prints the screen using the
following.
<input type='button' class='button' value='Print'>
I am hoping a mixed ASP- Javascript programmer could help me with this scenario:
I have a list box populated with randomized records (NewID()) from a Broker (Salesperson) sql server table.
Each time the user selects one of the broker items I need to display a Image of the broker in the table cell next to it.
I have found a number of online js scripts that use the image selector route but I am unable to work out to populate the list item from the database AND at the same time utilize the JS...
Are there any coders who come across a solution like this. Here is an example of my ASP code populating the List box: .....
how to show a drop down list with a selected value that is derived from the database? Is this correct? When I do this, it shows "Mastercard" always, even when its "Visa" in the database.
<select name="ccType">
<option value="Visa" selected="<%=rs("cardtype")%>" >Visa
<option value="Mastercard" selected="<%=rs("cardtype")%>">MasterCard
</select>
I am creating one web page which contain a drop down list. It use the data from database. Now my problem is when the user select the drop down list value, I want the current selected value update to the database. How to write the code?
View Replies View RelatedI have been provided with a DSN, user name and password for one of my
clients sites.
I'm not an ASP developer and need to view all the contents of this database.
I usually work in PHP but only have ASP available on this server.
I want to open the database and simply output all the contents into a HTML
page.
My form contains a drop down list of univ. campuses and depending
upon the campus user is selecting, I am selecting the courses offered
in that campus from database (MS Acccess) and showing those in a
different drop down list below.
Is there any way that I can access that campus-list value before
submitting it to database?
Also, please give me solutions in VBScript and no javascript. That's my
Prof.s restriction. One of my friend told, there is no way this can be
done. But I am sure there must be some solution. Microsoft is not that less
creative.
Let's say I have a dynamic list/menu, which gets its values from a
database table, for example a list of contact people where the value is
an ID number and the label is the name. However, if the value the user
wants is not in the list I would like to place a hyperlink which
will...
(1) open a small window, with an ASP form to allow the user to add a
new entry
(2) save the entry to the database
(3) add that value to the list/menu in the parent window and make it
the selected option
(4) close the small window and return to the original window.
I can handle the code for 1,2 and 4, but 3 is what I'm not sure about.
I don't like the idea of forcing the user to leave the current screen,
go to some other form, add the entry they need to the lookup table,
then come back; this seems like a logical approach, but just wondering
how to make it work.
This seems like a common enough situation; anyone have any code samples
or suggestions about how to do this?
how do you time how long a database script takes to access the data? i have looked around and cannot find anything. I want it to compare the time difference between access and mysql on an identical query.
View Replies View RelatedI am creating a text file. I have a button that will import data to an sql tabel and then redirect to the file page. the File page will generate letter with name and address pulled out of the database and then show a table with the name / address the letter / file was created for.
The thing works fine if i place "top 10 " in my select query. If I let it just run the whole list (could be 1300 or more names) the page times out on me.
I'm trying to post a value from a form field into a database field of type Date/Time formated to short date.
Even though the value from the form comes in short date style ie 19/06/2004 I'm getting a type mismatch error
I know how to write a script that will show all the tables fieldnames and then all the tables fields, but how can I do it so that it shows the database table one column at a time? for instance:
fieldname 1
<br>
1st fieldvalue for this column
2nd fieldvalue for this column
3rd fieldvalue for this column
<P>
fieldname 2
1st fieldvalue for this column
2nd fieldvalue for this column
3rd fieldvalue for this column
etc..
When a student taking a quiz having a duration of 2 hrs, a timer will start and keep track the time.
So if he logout or close the window, the remaining time should be recorded into the database. And when he take the same quiz again, the timer will not restart but continue from the previous time.
E.g i take a quiz having a duration of 60mins, and when i logout the time duration remain is 30mins. And when i logon and take the quiz again, the timer countdown from there 30mins but not begining of 60mins.
How to insert time stamp data into Access Database when insert other data together in ASP/.
View Replies View RelatedI output a list of towns from a database via a normal recordset loop into a normal paragraph with links - BUT for some reason it is totally pushing the page out... is there any reason for this? I also placed trim() on the town name in case there were lots of mistaken spaces, etc. Code:
View Replies View RelatedI'm using VBScript to display a list of the ten most recently updated
pages on my web site. Right now, the script lists the filenames and
the date modified in a given directory.
What I want to know is if there is any way to extract the page title
and display that instead of the file name? Can I use .asp and VBscript
to "delve" into the file and extract the title? Code:
What's a way to do a: Page generated in X.XXXXXXXXX seconds.
i want to run two pieces of sql that connect to two different tables that are not assosiated with each other, in 1 asp file. how do i do this. Code:
View Replies View Relatedis there any method that tests if it's the 1st time that page is loaded? Or if the submit button is clicked or not? my form validation function is working as soon as the page is loaded. but i don't want that. i need that function start working only after my submit button is hit. how can i check the difference?
View Replies View Related