I have a dynamic table, with a column named "player" in this column is NBA player names - generated from a statistic database. I am hoping to be able to create a link on the players name that will direct the webuser to a profile page like the following:
http://sports.espn.go.com/nba/players/profile?statsId=3282
I am having trouble becasue the stat page is not by the player name but a numbered ID.
I tried using a player search like follows:
<a href=http://www.tsn.ca/nba/player_list.asp?name=<%=(Blair.Fields.Item("IDPlayer").Value)%>&Submit=GO ><%=(Blair.Fields.Item("IDPlayer").Value)%></a></td>
When I do this it only seems to search for the first name.
<!--#include file="somefile"--> this would normally do but i need to change some file with the file name stored in a db under the field name content, i have the content file name called back to the page in the variable content and i hopped that
<!--#include file="<%=content%>"--> would work
i am aware that the quotes make it a sql bit but i cant store " in the db can i any ideas?
I have an asp page that returns a table from my database. Only about 6 columns from the table are shown on this page. I have the ID column set up as a dynamic link to a 'details' page, so a user can view the rest of the record data.
My database has been growing rapidly, and now when the page is run i get the error "page cannot be displayed".
I believe this is due to how large my database table is because if i delete records the page works fine, as it did when the system was first running. Right now there are 4600 rows in the database and will be growing.
How do I fix this problem, I cannot get rid of any records.
Oh yea, and if i delete the line of code that contains the link, the page works fine and shows the entire table.
Here is the code for the link: <A HREF="details.asp?<%= "JOB_NO=" & rsResults.Fields.Item("JOB_NO").Value %>"><%=(rsResults.Fields.Item("JOB_NO").Value)%></A>
I'm trying to figure out if this is possible before i have someone start scanning a bunch of images.
If i scan a bunch of images and give them specific names can i then look at that dir and read the name of the file and write a link in a field of a table?
example FOLDER CONTENTS 123254.jpg 125684.jpg 168468.jpg TABLE record example epn =123254 name = Bob Picture = 123254.jpg
i want the name of the file to be written if there's one in the folder for that epn.
I connected MS Exchange Server to MS Access database using Access link table function. I can open the database table and see the fields and data inside the link table. However, the table seems cannot be queried by SQL statement.
My situation is:
I'm building an intranet. I have a ASP login page for all staff in the company to login. Other people can't register or login the intranet. That's the reason I use the company email address to verify username login name.
After I made the link to the Global Address List (rename to StaffList), I can see the Alias field. I wrote ASP code to use Alias field to verify user login name. But, the ASP page seems experiencing difficulties. I always got the "Connection Timeout" Error. Code:
I have a web page form that I would like to use some ASP code in. As it stands right now I have a text box (field) that is straight HTML.I want to use the number that is put into the field to generate that number of rows in a table further down in the form.So I am posing this question how would I go about doing this.I am able to use ASP and Javascript (if need be).Or should I start over and code the entire form in ASP?
I have a web page form that I would like to use some ASP code in. As it stands right now I have a text box (field) that is straight HTML. I want to use the number that is put into the field to generate that number of rows in a table further down in the form. how would I go about doing this. I am able to use ASP and Javascript (if need be). Or should I start over and code the entire form in ASP?
I am trying to add rows to a table dynamically, using JScript. Can I someone explain, how to add events to the newly added cells/ rows? Following code does not fire the onmousemove event. Code:
I have an ASP VBScript page with a dynamic table. Each row contains a dynamic price, a qty field, and a total. The total on each row changes (onChange() ) when a qty is entered (this works fine). I now need to total up the 'total' fields and put a 'GrandTotal' into a variable for later
I have a dynamic table which is checking data from Access database and filling up the table appropriately. In my development environment of Windows 2000, the table displays properly but after hosting (that same source file), the table is not displayed. The error occurs at the following point:
I have an .asp page that contains a drop down menu, that when a selection is made, reformats the page to one of 22 different .asp pages. When clicked, the drop-down disappears and the options from it are formatted as a list on the left hand side of the page.
I need to format this so the list is in 3 columns, with the secection bold. I think I need about 4 if..then statements, but I've never done this before...here's the specific code, the code for the drop-down is first, then the code for the "quick link" list: Code:
i am just trying to build a table that will put content into 2 columns. Ideally, if there were 20 hits, 1-10 would be in column 1 and then 11-20 would appear in column 2...i just can't seem to figure it out. I had started by getting a recordcount, and dividing it by 2, but things got a little fuzzy after that.
1) I build a Html Table dynamically (Header Row, and then 2 rows with data All 2 rows have 2 cells: cell(0) contains a delete button (ASP Button), cell(1) contains a HTML Text box
2) On Form Load and get some data from a dataset and then from it's contents build the page
At this point the page is rendered and 2 rows are displayed. There is an Add button that a user can click to add another row to the table. This works fine and the row is added.
Now if the user clicks the delete button in row 2 the form is posted back, I rebuild the page, and then in the click event for the delete button remove the row from the table and the dataset. All appears to be fine at this point.
Now if the user clicks the add button again another row is added, but this time row 2's textbox has the wrong value. It appears to be related to the view state. I think the view state somehow is not getting cleared when the row is removed.
I have an Access DB which contains couple of link tables. All these tables are from different databases. So each one has it's own database password. Since there is no way to save the password during the DSN creation. Then you need to manually type in the password each first time when open the table.
This causes the problem in ASP code during run a query. Since the table cannot be accessed due to the password protection. Is there any statement than can open a table and meanwhile pass the password in? Does anyone experienced with the similar situation?
I code that creates a calendar for each month and then it displays events from that month that are stored in a db. I need to loop through my recordset and display all the events, but I can't quite figure out how to do it. I am thinking I need to do an array. But I am not really sure.... any ideas. Here is where you can view the calendar. Code:
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<% Dim conn Dim rs Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection") Set rs = Server.CreateObject("ADODB.Recordset") Set cmd = Server.CreateObject("ADODB.Recordset") conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa" conn.Open
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??
Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
Have an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page.
Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
I have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.
Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.
Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.
Ok, I have a Javascript ASP and in it I have a dynamic repeating table with certain attributes to people. If one of these attributes is old or invalid, i want to change the color of the text (and maybe make it flash, blink, change size, something) so that it's easy to read.
The following errors occured: - An error occured. -2147217904 : No value given for one or more required parameters.
there are students and teachers. therefore I have 3 tables one for logins and one for staff and on for students.
I have a form designed to capeture the need information.
in the code I am runing an if and elseif statmetn to determin the tables. I then insert the userid and password into the login table.
then i enter the remaining information into ither the staff or student table. what i am trying to do is select the perimary number that is generated as the userid and passeword are enterd. and add this to the second table. Code:
Does anyone know how to hide and show a link depending on the level of the user. Like I want the link to show if the person loging in is an admin, but if the person is a user than I dont want the link to show?
