I have an asp page that displays informaton from an Access database. I want to create a form that allows users to display only data that matches their search criteria.
I have made many forms like this in Front Page with the Database results wizard, but I want to manually code it. Code:
I am doing a project that uses ASP VBScript on Dreamweaver. I try to display data based on the hyperlink on the previous page, where I click on the hyperlink("ID of the informationfile") and the following page will show the detailed information of this particular file.
However, I can't display the next page even if I add the hyperlink and the required parameter on the records that are shown on the first page. I need to ask how can I display the detailed information based on the hyperlink, or in fact the fileID from the first page ??? Code:
I've been searching for an answer to this for quite some time now and have found nothing, so maybe (hopefully) someone out there will be able to help me.
At my work, we have a lot of folders for different jobs we've done. And right now, we have more than one person making the folders for all the new jobs that we get. I am trying to make a database were it will only show the jobs that have not had folders made. In order to do this, I've created a field titled "Initials". I want the webpage to pull up all the records where the Initials field is empty, but I'm having trouble doing that. I've tried a few different things and have found no success.
I'm not having a problem accesses the database or updating it, just displaying the right information. I'll give a little illustration (because I'm never good with words):
Say I have 3 jobs: Job #1, Job #2, and Job #3. Someone has already made job folders for Job #1, but Job #2 and Job #3 still need to be made. Since Job #1 has been made, that means there are initials in the initials field of the database and thus, I do not want that Job being displayed on the "To Be Made" page. Job #2 and Job #3 do not have initials in the initials field and as such, I want to display those jobs....
I am having an issue figuring out the correct syntax and possible SQL code to display data from one table (CustEndPoints) with a DropDownList used for a GridView to get data from another table. I have been playing with Joins, which is probably correct, as well as ControlParameters. Code:
View Replies View RelatedDropdown has three choices. If the third is chosen, the next field needs to be hidden. is there an ASP version of a show/hide script?
View Replies View RelatedI'm trying to write a web form that will allow users update info from a database table. Everything is working fine, except the display of the one text field from the database (nothing displays. Here's what I'm trying:Code:
<textarea name="AdditionalInformation" cols="32" rows="10" wrap="VIRTUAL"><%=(UpdateRecruiting.Fields.Item("cs_additionalinformation").Value)%></textarea>
what I'm doing wrong?
I need to solve this as part of a class project. It is designed to simply read a SQL table and display the data in the browser. But it will only show one record based on ID at a time. So if I have multiple records with the same ID such as page.asp?ID=9734, it would show all records using that ID in the browser. Code:
View Replies View RelatedI am trying to display some DateTime data from a SQL Server db using the standard recordset object...objRec("PostTime").value
It displays nothing.
I am designing a shopping site, in the picture the #1 section is a check box behind product name that customer can select that product to buy in #2 section the customer can set quantity of the selected product ok now codes this is the code which I have used to pull out produts and categoris from database and show them on the page Code:
View Replies View RelatedI currently have a web page that pulls in job vacancies from a search form all written in asp and the database is in access. I will be placing an extra field which will say "apply now" and on selecting this you will be taken to a new page where you can fill in your details and email them to the employer.
My problem is I need to know how to get a field in the form that will automatically fill in the title of the vacancy being applied for from the database.
I get a "data type mismatch error". I assume it is because this is a number, but I don't know what to change.
<%
dim cnStr
dim rcSet
dim frmSSN
dim sqlStr
'store form input into variables
frmSSN = Request.Form("SSN")
'create connection and recordset objects
Set cnStr = Server.CreateObject("ADODB.Connection")
Set rcSet = Server.CreateObject("ADODB.Recordset")
' defining database connection (connectionstring2.inc)
cnStr.ConnectionString = path
cnStr.Provider = provider
cnStr.open
%>
<%
SQL_query = "SELECT * FROM Orders WHERE Driver = '" & frmSSN & "'"
Set RS = cnStr.Execute(SQL_query)
WHILE NOT RS.EOF
%>
I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.
I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.
I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).
I currently have entries in my dbase with time stamps. Does anyone know how I would display only those records with the time stamp that reflects a particular day. For example I want to display all records from today which would be 8/23/2004 on the page.
Im assuming this has something to do with the Date () function but i dont understand how it could incorporate it into code.
I am trying to pass a hidden field value on a form into another field on the
form so that it can then be inserted in the database, to enable me then to
reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the
other input field.)
The code for the text field that allows users to type an number into it for
submission to the db is below, but what code do i need within the hidden
field to populate this text field below so that users do not have to type the
number in? Code:
have form on asp page with an email address field, when the user enters
their email address I want it to populate another field automatically on the
same page, some kind of OnBlur event. Have worked extensively with dropdown
OnChange events but cant get my head around this one.
Here is the situation:
1. User fills in form and hits submit
2. Some processing is done with the posted data using ASP
3. The posted form variables now need to be submitted to another script which only receives POSTed data.
How do I send the posted data to another script? I can't run step 2 on the next script as its validation script and I'm going across two servers.
What I would like to happen on this page is that when a user selects a company name from a drop down list, his selection autopopulates the cID field based on the selection. The drop down list is getting its choices from the customer table.
As I am still a novice, I am sure there is a way to do it I have not been able to get it right. Code:
How does one return records in a recordset based on a time/date field. If todays date is 8/25/04, how could i return all those records from 8/25/04. Mind you, i have long date format ex. "8/25/2004 4:46:45 pm"
I dont want to user a form for this i simply just want these time- sensative records to be returned in the recordset .
On a heavily used page that pulls a lot of data from the SQL server and XMl files we would like to implement refresh of only one data grid control in order to improve performance.
Is there a way to refresh data grid control without (post back) reload of the hole page. Data refresh can be done on regular time intervals or on click on the button. Environment (ASP.NET and SQL Server 2000).
I have a classic ASP page with a number of text boxes which are updatable.
For convenience I want to add 'tabs' at the top of the page (like a card
index) as the data to be displayed is split into specific groups (client,
company, preferences, events).
How do I update any changes to the data and switch to a different page - at
the same time? i.e. the user doesn't have to click 'update' (submit button)
before changing pages Code:
ASP/javascript with a drop down populated by an access database. The drop down works fine but I cant figure out how to get it to change a value of a text field.
I want the value in the text field to change to reflect the data in another column in the table, same row. Code:
my question is regarding using ASP to loop through the results of a sql query and calculate a monthly total based on a date field.
I am using the following query to total the number of train rides for a given branch by day type (weekday, Sat., Sun.) and create a 3 month rolling avg. (to diminish large fluctuations in the data). I am using Oracle 9i to store the data.
Please see below for the database query, the query output, and the desired output using ASP to sum the rides for each month. Code:
Is it possible to post the form data and open the page as a modal window?
Because when I do the following, it will open page2.asp in a new window, but
I still able to manipulate page1.asp. I want to make page2.asp as modal
window.
<form action="http://server2/page2.asp" method="post" target="_blank">
Any ideas?
This script works, however when I read in the fields, if they have a space in them, it only puts the first word in. For example, if the company name is Bell Mobility then it will only put Bell. Code:
View Replies View RelatedI saw creole's post regarding a similar CF function and thought I'd start a similar ASP thread. If I have an article (entirety of kept in a field adequately named "article") how would I select only the first, say 450 words, to be displayed on a page....followed by a prev/next nav item. Naturally, page 2 would pick up where it left off. How to do this? Or do I have to split the article up into article_sec1, article_sec2, etc?
View Replies View RelatedI know how to display a text field from an mdb file. You type: <%= CmdPopulateStates("fieldname") %>
where CmdPopulateStates is declared as:
Set CmdPopulateStates = Server.CreateObject("ADODB.Recordset")
But if 'fieldname' was a memo field rather than text field then the information isn't displayed. In fact, if it's anything other than text then it won't be displayed. How do I display other field types?
I am trying to display only certain columns from a table and this is a code that I am using but it is not diplaying anything, can anyone tell me where my code is wrong
<%FOR EACH field IN rstSite1.FIELDS
if field.name ="EmpName" then
RESPONSE.WRITE("<TH ALIGN='LEFT' BGCOLOR='#B0C4DE'>"& FIELD.NAME & "</TH>")
end if
NEXT%>
I have an Oracle database which has a field LONG RAW type to store text files. I'm trying to display the output of this field in ASP but I'm having problems. I've gone through many different approaches but they either do nothing or do the following;
I've tried doing response.binarywrite(rs("data_object")) and I get
somethinglike below ....
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
Does anybody know of techniques (or websites) where a graph is generated based on data of an array?
View Replies View RelatedI'm looking to display information pulled from a database based on
information the user puts into a text box. The user will enter their
sales rep number and I want to hit a table and return their name as
soon as they tab off of the text box. Any ideas or help would be
appreciated
I have a db with about 15 fields in, what i have a list of all the fields on a form, simply check the checkbox relating to that field and on the next page it creates a table only with those fields in it.
View Replies View RelatedI've been racking my brains over this one. I have a Classic ASP edit
form with many fields, one of them a Status drop-down. If the Status
(option value) has been changed to "Pending" for instance, I do a
objMail.send, otherwise it doesn't send.
No problem, but how can I
prevent the mail from sending AGAIN if a user goes back to the page and
updates another field, or even just refreshes the page? If it helps, I
am updating a SQL Server database.