Return Specific Record
I have a few ASP pages that go out and query a database and return data that meets a requirement. For example I have Department hyperlinks in a Nav bar that select just the records associated with that department. The returned records are placed in a table to be viewed. In that table I have a field hypelinked to a PDF image. 100+ records could be returned.
How could I place a hyperlink, or check box, in one of the fields that would select that specific record and display the data on another ASP Page. What I am trying to get at is when I get the returned set of records, being able to click ONE of them and display that information as well as any associated images connected to that single record.
View Replies
ADVERTISEMENT
If Request.ServerVariables("URL") renders
/myserver/mywebpage.asp
How can I just return mywebpage.asp?
I can use the RIGHT function, but I'd like for it to work on any page,
regardless of the length of the page name. I'm looking for a good example of
using a combination of MID, LEFT, RIGHT, etc to get certain parts of
strings.
View Replies
View Related
I have an interesting problem and am looking for some advice. I am
hoping to build an asp whereby records are pulled from SQL Server. These
records will be merely file locations for thumbnail images I hope to display
in a grid.
Rather than having a grid be constructed row-to-row, I was
wondering if it is at all possible to dynamically construct this grid as a
table of thumbnails whereby each cell (perhaps 5-6 columns across)
represents one record? I have no idea how one would construct this loop that
spans columns AND rows rather than just rows.
View Replies
View Related
i have a shopping cart that gets its information from the cookie.
is it possible to add a remove item to my shopping cart so that i can delete a specific item from my cart?
View Replies
View Related
I am developing a budget app using asp, access and Dreamweaver. What I need is a way to loop so that I can display months starting with a designated begininng fiscal month. In this case it is July. I need to display 6 months in a row starting with July and in a separate table below I need to display the rest of the months in the fiscal year Jan - Jun. Like so....
7 8 9 10 11 12
1 2 3 4 5 6
I think it will take two separate while loops.
View Replies
View Related
I have a server using a webapp built on classic ASP, and I use a library that creates/manipulates a datagrid-style display on the page.
I am displaying a large chart with sufficient data that it will likely be paged, and there are several columns that are toggles (using checkboxes for these, with the entire column having the same checkbox NAME, but different values depending on the record).
I have a piece of script that for loops through the records present on the page (determined by a collection of hidden form values), and then I need to check if the collection formed by a given column contains that value, something like the following (pseudo-code):
View Replies
View Related
cmdTemp.CommandText = "Select * From users"
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = DataConn
rstContacts.Open cmdTemp, , 1, 3
rstContacts.Move CLng(Request("Record"))
i only want this command to display from the users table the details
of the user that has the username (from the database) equal to the username of the person who has just logged in from my login form (uname input box) this code at the moment displays the first record, i dont want that.
View Replies
View Related
I need to can a function in a COM object that returns a record set and then I need to display the record set. Any ideas of how to return the record set tp the asp page?
View Replies
View Related
can I return a recordset through a function in asp? and Suppose there are two buttons in asp. I want if I presss the first button then it should go to page 1.asp and if I press the second button then it should go to page2.asp. Is it possible?
View Replies
View Related
I have a database that has only 3 users in it. (that is the way it will pretty much stay) They will be contributing articles to a web site on occasion. So I have only two tables in the database, one with for the "writers" and one for the "articles". The relation between the two is based on the ID given to each writer.
ON the main page of the site I will have a little table that will display each writer with their picture, date of last entry, and topic. So what I am needing is the code for the Record Set to go and look in the database to find the latest article for each writer so that it can be placed in the table.
View Replies
View Related
I have a page where a user can submit a record for a new "applicant". After the user clicks Submit, I would like to send the user to a new page containg the "Applicant Number" which the user will need.
The applicant number is simply the autonumbering of the record in the table which is in a SQL Server db. How do I capture the record number(primary key) of the newly entered record in the table and send it to my new page?
View Replies
View Related
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:
View Replies
View Related
I was able to alternately change the rows colors, but this time lets say I have 10 records in a table taken from my database. How do i put colors on rows where value(certain value from a field) is lets say greater than 10?
Like for example I want to highlight only those student number greater than 10.
View Replies
View Related
I have a program that needs to rely on the date for Sundays on a given month. Here's an example:
Today is 3/18/2005 (Friday). When a user logs into my page, I need to grab the date that the past Sunday fell on (3/13/2005)
If the user logged in on 3/24/2005 (a thursday), I would need to grab 3/20/2005 (that sunday)
Any ideas in vbscript?
View Replies
View Related
Ok let me explain what I am trying to do as easily as I can. I have a table in my access database that I am connecting to. I select a specific id number using my SQL statement. Now what I am trying to do is scroll through that records row and get the column name of that column along with the value of that cell. I hope that isn't to confusing. Now I'm not sure whether this would be done using ASP or done in my SQL statement. Code:
View Replies
View Related
I am working on a college project which has a user area and a page where only a user can access their information and no one elses.I am trying to do a select statment to read specific information from a field without reading any other users info.
The code below is for a drop down menu for payment months i have stored in a database...
Here is what i have got so far...
Code:
Set oRs = Conn.Execute("SELECT [Payment_Period] FROM wages WHERE [Staff_ID]=" & staffid" ORDER BY [fullname]")
View Replies
View Related
I am looking to find out how to grab a specific content on a particular Website and put it on my Website. Of course, I will get permissions before doing so. Any ideas? I have found a sample ASP script that shows how to grab the entire page, but certain sections of the page.
View Replies
View Related
I need to execute different asp programs based on different values of a parameter. For example, if the user inputs ID of 1, program1 needs to be executed automatically, if user inputs ID=2, program2 needs to be executed in the background automatically. How do we do this in asp?
View Replies
View Related
I'm then going to use the answers in my select statement to pull data from the database.
Heres what i have now:
sql= "select * from assistancerequest where datein >= Date() - 7"
heres the problem with it:
it gives no errors but when it shows my output it shows wrong data.
Example:
27/08/04
28/09/04
28/09/04
29/09/04
this is some of what i get. as you can see it counts back 7 days, but its not working because this is from two different months! so it looks like its only checking for the days and not the month. does any of this make sense?
View Replies
View Related
i want to check item before insert new item. let say resID = 1052. before that, i have inserted item which is prodNumber = 100 for resID = 1052. then, still at resID = 1052, i insert another item, prodNumber = 100.
then an error message will come out. but if i insert item, prodNumber = 100 but for resID = 1047, suppose there is no an error message.
that means the sql conditions are at current resID and prodNumber.
View Replies
View Related
i need to connect to sql with different roles. is there any way for do that without passing users or passwords in the connection string?
View Replies
View Related
Does anyone know a way to find out the numeric value of a day of the week for a specific week, I am trying to display week periods from Mon-Sun. Ive toyed around with is but can seem to come up with anything.
View Replies
View Related
I have a feeling someone can answer this very quickly, but Im having problems. Basically Im trying to get the rate variable which will be either a 0 - 10 inserted into the appropriate row. I want the variable filename to match up with the matching filename in the database and then insert the rate variable into that filenames rate column. Hope I didnt confuse you to much.. Code:
View Replies
View Related
I want to get data in a specific format. For example i have 10 names in database and i want to show these 10 names in this format.
Name1 Name2
Name3 Name4
Name5 Name6
........ ........
....... .........
how it could be possible.
View Replies
View Related
I have a script which creates an array by doing this:Code:
strInputValue = "this will be split into an array"
arrMyArray = split(strInputValue)
This produces an array of 6 (UBound(arrMyArray) = 6).
Is it possible to remove part of the array, so that "into" for example will be removed, such that UBound(arrMyArray) = 5?
View Replies
View Related
im a bit of a rookie and i couldnt find anything using search,how can i have a statement which selects only the records which contain data.
Code:
sSQL = "SELECT * FROM VIEW_COLLECTION " &_
"WHERE (BusinessID = 20) AND (Parentid = " & objRScats("CategoryID") & ") " &_"ORDER BY CollectionName"
Thats what i currently have. This is for the page navigation - and i dont want a those collections that do not have any data to be diaplyed - but i do not want to delete these records altogether just yet.
View Replies
View Related
I want to get data in a specific format.For example i have 10 names in database and i want to show these 10 names in this format.
Name1 Name2
Name3 Name4
Name5 Name6
.. ...
... ....
how it could be possible.
View Replies
View Related
I'm trying to read in a specific cell, and am having problems. I have a table of contact information, in which each contact has a user_id that defines where there information is.
At login it stores their user_id into a temp variable that is used to define where to find the information for each contact. I can read in contact information for the first row but anything below that I cant seem to grasp.
Im not sure how to tell it to match that temp variable with their user_id and read in the user_name. the temp variable is user_ID. Code:
View Replies
View Related
I have a string like this - 203_4_54_3_12_43_0_204_3_23_43_0_2_2
How could I count how many "_" there are in the string?
View Replies
View Related
i have a remove user and change password script written, but the only thing they are missing is the actual text file editing part. i have the file open because i have read it, but how can i delete a line that matches with 'OldLine' and put 'NewLine' where it was with a couple of lines of code?
View Replies
View Related
I would like to collect financial data from the stock exchange into the asp web page.
Complete daily results are in txt format on a fixed URL. Soo far I managed to pull the data on my web page, but now would like to select only specific rows. Unfortunatly the rows are not fixed, but each one has a 4 digit code on the beggining.
So I would like to create asp code which would select n rows from txt page based on specific code on the beginning - for example 0020. In the SQL would look like this one SELECT * FROM file.txt WHERE the beggining of the row = 0020
Is that possible in asp ?
View Replies
View Related
This might be i bit complicated, but i'll explain this to the best of my ability. I have a txt document with the following content. PHP Code:
Blue<br>7<br>2. Green <td align="center" class="normal">3. Light Blue </td><br>8
How would I go about creating something that reads the text file, and only outputs the text without the html?
View Replies
View Related
I have made a secure website which you can only get access to with right username and password. On this webpage I have some links to some pdf-files, but how can I avoid people from getting the file if they are not logged on first? As it is now they can
easily get the file if they just know the exact URL-address, ex:
www.website.com/dir/file1.pdf
If people type the URL above I would like them to be redirected to the logon-page first.
I can't use components or MS-Access database, so I'm looking for another solution.
View Replies
View Related
