I have announcements down the left hand column of a site and want to display contact info if it is available - if it is entered into the database. So I only want to display a space plus the data if there is data in the field. Code:
View RepliesI have a strange problem. I have to show demo presentation in CD. In
this presentation record will be show from database. But we dont have
to install the database. any body can see the cd and can search the
data. how it is possible because the databse will not be installed in
CD and computer also.
I have a form that has a drop-down select box which is linked to a database table, and also tow text fields. I would like to show or hide text fields according to the value selected in the select-box without refreshing the page.
If I select TEST from the select box I want to show the RESULT field and hide OTHER field . If I select anything else I want to show the OTHER field and hide RESULT field. I'm interesting code in ASP and PHP.
i would like to show a summary of data in our database. it's more like a report showing things like totals for 2006, 2005, etc. what is the best way to do this and make it efficient?
i have a report right now consisting of about 20 queries i've been slowly putting together. when i run all of these on the page, it takes a good 15 seconds for it to generate the figures (and this is on a dual 3.0 ghz xeon machine). does anyone have any suggests on an efficient way to accomplish this?
My code show no error but the record cannot appear. My code =
if request("tarikh") = "" then
tarikh = Date()
else
tarikh = request("tarikh")
if isdate(tarikh) = false then
ralat = "Sila masukkan tarikh dalam format dd/mm/yyyy"
tarikh = Date()
end if
end if
sql = "select * from audit_trail where cstr(tarikhlogin) = '"&tarikh &"' order by masalogin desc"
set rs = conn.execute(sql)
response.write sql =
select * from audit_trail where cstr(tarikhlogin) = '04/02/2005' order by masalogin desc
Storing record have no problem but this code cant display any data.
how to show excel data in asp?
View Replies View RelatedI was just wondering if there is a variable or procedure for getting all the POST data sent to a page. I don't want to have to handle every case for the POST data, I just want all POST data sent to the page to be outputted automatically.
View Replies View RelatedI have an Excel file and NEED to show the data onto the webpage using ASP. The data shown on the page varies depending on the ID entered in the webpage.
Right now i Import the data into Access and then show it on the page with the JET engine.
I have two pages in my Web system that works in such a manner:
1. Page A allows users to input data into the web form
2. Page B displays data from Page A and other additional info
Page A contains only data inputs of HTML types TEXT and SELECT.I'd like to have an "Edit" button in Page B where it allows users to be redirected to Page A to view all of the previously entered data (and edit the data from there).
Can I do this without using "Request.QueryString" or "Request.Form" commands? I can't use "history.back()" or "history.go(-1)" commands, because with them, Page A is shown with empty data in it.
how can i make that the page show only TOP 5 record in the database ?
View Replies View RelatedI have a problem with show all values from my database into my html page! Code:
View Replies View RelatedI have in the database two columns, one for picture_id and one for image. Then I want to show the image which the user sent into the database.
I am using sql server 2000, how should I write the code in asp so that it can show the image not the disordered characters on screen.
I have code as following but the output is disordered characters....
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>
My problem is this: This database has a field called "b_name" which contains the first, middle (if any) and last names of registered users. The table also has corrosponding other demographics pertaining to each registered user.
I've used the code below to parse the full names in "b_name" in the original table and put the names in another new table which has 3 fields, "FirstName" "MiddleName" & "LastName".
My problem is the fact that the way the names are stored in the original table and the parsed names in the new table do not correspond. Code:
I want to take the contents of many fields of various datatypes (varchars
and text) and combine them into a single "junk" field that I will perform
SQL Server free text searching upon, e.g.:
tblArticles
Title
Subtitle
ArticleText
CombinedField [Title, Subtitle, and Article text smashed together]
Is it possible to create a query or T-SQL stored proc that would do this? Is
SQL Server DTS a better approach? It needs to be built for each row in the
table, and it needs to happen regularly.
The Now() function returns the date and time. How do i get each individual values such as year, month, date, hours and minutes.
View Replies View RelatedI want my customers to be able to login using username and password. But I only want them to see their own page.Can I somehow set the URL in an Access database and then redirect them depending on their details Or am I going about it the wrong way completely? Also, can anyone explain all this "session id" stuff?
Just in case it's relevant I'm looking to insert the pages into a MS Frontpage 2003 website and using an Access 2003 database.
I'm writing ASP/mysql apps, and I'm almost clueless about mysql. Can someone tell me how to insert data into fields using ASP? Code:
View Replies View RelatedI'm trying to design a voting page. The flow as follow:
1) there is a table filled with rows (data from db)
2) each row come with a button = "vote"
3) when user click the button "vote", db will UPDATE the value(Yes/No/etc) of the row + 1
example:
1. Yes "Button"
2. No "Button"
3. etc "Button"
Since there is three button, how can the button identify which value to UPDATE in db (when the user might just click any one of it)?
I would like to remove individual elements from a vbscript array without just blanking out that element. Is this possible?
View Replies View RelatedWhat i am trying to do is Update data in a table with data in another table but i want to update 2 fields in the destination table with data from 1 field in another table.
These are the table i have and their fields:
*CUPFirstRound* - Table1
GameId
GameDate
Home
Away
HomeScore
AwayScore
Winner
There are 8 rows in this table, thereofre the GameID's go from 1 to 8 Code:
i have a table which has many field, they go across and are named as a1a2a3a4a5a6-a16 the next row will be b1b2b3b4b5b6-b16 the last row is g1g2g3g4g5g6-g16 and so on.
now in the first column i.e which would be a1 b1 c1 d1 e1 f1 g1, the user enters a part number what i want to do is prevent him or her entering the same part no.
twice if this the case the two filds with same part no should be cleared.i.e if user enter p45 in a1 then p45 in d1 then both a1 and d1 should be cleared would be better if the later was only cleared but any method would do. Code:
I am creating a form that has 5 steps/pages. Each page contains about 20 fields. But I don't want to write them until they submit on the last page. I figured out that I can use hidden fields to carry the data from the previous forms forward. If should bascially work like this:
Page 1 Page 2 Page 3 Page 4 Page 5 Page 6
20 Fields 20 Fields 20 Fields 20 Fields 20 Fields 100 Hidden
20 Hidden 40 Hidden 60 Hidden 80 Hidden Write to DB
But the problem I am having is when I submit page 4 page 5 won't load. No error, it just won'tload. It seems to be overburdened. Is there a max on the number of fields it can pass? Is there a better way to go about doing this that someone can suggest? Or a suggestion that someone can make to fix this problem?
I'm given a DB with everyone's particulars including emails which I'm supposed to retrieve all their emails and do a mass reminder email to the individual email addresses.
I don't want to send a email whereby all the email addresses is shown in the email. Can someone give me some ideas as how am I supposed to go about doing it using asp and vb. Is there any working codes I can refer to?
I am looking for an ASP script that let me to serach all database contents with only one textfield in search page. eg: I have a database with five columns for lessons: Mat, physics, geography, history and sport. Each field have numbers 1 thr 5. I want to search only those students have number eg:3. with entering the number in textfield in serach page. I have no problem in result page.
View Replies View RelatedIs their a way to check with asp-code if a database field is relational with another field (from another table)?
For example:
If fieldname = relational Then...
End If
I'm trying to set up a quick if/then/else statement for when the database field returns no results. I'm not getting an error but when the field is EMPTY it still executes the ELSE statement.
<%
If rsOffice("FloorPlan") = Empty Then
Response.Write ("Not Available")
Else
Response.Write ("<a href=" _
& rsOffice("FloorPlan") _
& ">View</a>")
End If
%>
At the moment in time I have a product database being displayed. I could do with including another column to the database which allows me to enter a specific quantity for that product line. All the quantitys fields need to be calculated to their specific product cost value.
Finally all the sub totals need to be calculated together to give a grand total, which will be displayed on another page.
how to compare one Database field against another which both have a date and time in them (DateTime format) using VB in WebMatrix. or just comparing Database fields of DateTime aginst each other in VB.
View Replies View RelatedI have been using two forms of password protection:
A) On working web sites I use an ASP script that is included in every page requiring protection: uses session - works fine
B) On quick test sites or temporary stuff I use the Windows Network Authentication provided by my web host. A whole folder is protected at once which is very convenient but it has a problem. If a user types the wrong password and is denied access, the next time they go to type the password, their browser sometimes remembers the wrong password as so they go straight to the 'access denied' 401 page.
How to proceed?
1) Does anyone know of a way of preventing all browsers from cacheing the login info.
2) Is there any way of using ASP to protect whole folders?
I have an IIS v5.0 installed in a windows 2000 box hosting a set of asp pages. These pages are accessed by premium service subscribers only with a 5-hour timeout setting.
Now I need to build another jsp site for a special group of users which enjoys a longer session timeout of 8 hours. I have duplicated the original asp pages and this duplicated asp pages will be accessed and displayed by iframe in the jsp. (I hate to do this because I'm relying on an ocx for the page to work).
How do I control the session timeout settings of these 2 sets of asp pages so that they have individual timeout settings?
i have a form with fields that contain data from a db. the fields can then be edited, and on the click of the "submit" button, the updated information is returned to the database, replacing the old. a bonus would be arrow buttons allowing navigation from one record to the next, with the information populating the form each time. i'm having a hard time with this.
View Replies View RelatedI'm trying to retrieve information from a field in a database, which contains data, some of which are the same. ex:
let's say the table is called "Person_info" and there are 5 rows of info with a different person's info.
let's say i want to display the info in the fields called "City" but there are duplicates ex:
Toronto
Vancouver
Toronto
New York
Atlanta
I'd like it to display all the cities in there on a web page, but, I don't want it to display the same city twice:
so it'll display this:
Toronto
Vancouver
New York
Atlanta
I just can't get it to work? it keeps displaying duplicates.