Display Part Of A Record
I need to limit how much of a record is printed to screen. I just want text up to the first full stop.
View Replies
ADVERTISEMENT
Display Part Of An Excel Sheet
I am trying to create an asp that will display part of an excel sheet. I have many hundered excel files and i want a page to view them.
the excel files do NOT have any header rows, i can't change the worksheets, is there any way i can display the contents of a work sheet? I have tried many ways but i seem to always have a problem displaying the top row.
all the excel files have been created using excel 97 if it makes any difference
is there any way of doing this?
Display The Second Record
i have a news page which a user can update etc add new news articals etc etc.The page which is to display the news needs to start at the second artical, ie if a user has posted a news artical on the 20/11/2005 .
a other person comes along and posts one on the 22/11/2005 i need to ignore the 1st one and display the second (20/11/2005) do i create a query when doing my record set or is it a asp thing on the page.im using ASP VBScript and a access database. Im not 100% with asp im still learning so if u could expalin exactly how to do this .
Display Only First Instance Of Record
.asp, vbscript, ms Access
I want to display a list of records on my page, like this:
California - Los Angeles - Sheraton
- Los Angeles - Meridian
- San Diego - Mercury
Colorado - Denver - ..................
ie. only display first instance of California..
Can this be done..
Onclick Display Record
I have the below code. I am trying to send information to a subroutine, I am getting an Object Required Error.
<input type="button" name="pSearch" value="Search"
onclick="DisplayRecords()">
Then in my ASP page I have this
Sub DisplayRecords()
dim conn
dim strsql
dim mycount
Add Column To Display No. Of Record
I want to display all records from the database based on keyword entered by user. As for example,
ContactName Title Phone
xxxxxxx xxxx xxxxx
xxxx xxxxx xxxx
xxxxx - xxxxxx
I want to add another column (to display no. of record), as for example,
No. ContactName Title Phone
1. xxxxxxx xxxx xxxxx
2. xxxx xxxxx xxxx
3. xxxxx - xxxxxx
Is it possible?
Database Display Record
i am trying to figure out the best way to display records. I have a page which pulls multiple data from mulitple tables in multiple queries. In order to get the page layout to put the records in the right spot i would like to be able to display each record invidually.
Is there a way to echo a record to a spot instead of using a datagrid? I know in php i can specify the database recordset and then echo the value for that particular record. Does asp have the equivalent to this?
How To Display Only First Five Record In The Database?
I've situation where I just want to displaying first five record in the database. I've search in this forum but could'nt find it.
View Replies View RelatedDisplay Partial Text Of A Record
On the webpage, I want to display like this:
I use Response.write objRS("FieldName") to display the value of a record .I guess a number of chars is allowed to display a part of record.
Display Color If Record Set Is Empty
I am using a calendar, and I want the calendar to show a different color on the date if there is something with in that recordset. So if there is an event for that date display a color else do nothing. Im not sure how to do this?
View Replies View RelatedDisplay Textbox For Each Record Retieved From Db From Same Table.
When a selection is made from a list (lstpos) - single selection allowed, (for example a user selecting engineer), it retrieves all the duties (it may b a duty i.e. 1 record OR many duties i.e. more than 1 record) an engineer performs (each one on a different line) from a table and automatically displays text boxes next to each duty so that the user can input "scores" for each duty (rate the engineer).
How to do this?
Next this data needs to be input in a table when the user clicks a button (ADD or OK) in the format :
user duty score
user1 duty1 score1
user1 duty2 score2
user1 duty3 score3
etc...
Anyone has an idea how to do this?
Getting Record Increment To Display In Form Field
How would I get the max record + 1 to auto-populate in the GMVINC form field? I have a feeling that my query is not correct. Code:
View Replies View RelatedWHERE Part Of SQL
strSQL = "SELECT user_name, password FROM [tblLogin] WHERE user_name = '" & Request.Form("user_name") & "' AND password = '" & Request.Form("password") & "';"
Is using AND the correct way to use 2 comparisons in the WHERE part of the SQL??
Sort By Part
I have a database table, that I need to sort by PART of the contents of a field (named rFieldName in the table):sample contents of this field are:Code:
qid_5_question_1
qid_12_question_5_0_1
qid_12_question_5_0_2
qid_12_question_5_1_1
qid_12_question_5_1_2
qid_12_question_5_2_1
qid_12_question_5_2_2
qid_12_question_5_3_1
qid_12_question_5_3_2
qid_6_question_2I need to sort his field by the value that appears AFTER the 3rd underscore, and if applicable BEFORE the 4th underscore
Is this possible - can you help please - I have no idea where to start on this as I've never had to try to do something like this before.
Use Only Part Of Field
I would like to use the last 10 characters of a Session object. Is this possible in active server pages. I am familiar with the user of Right$ in visual basic but I after trying serveral conatations I have had to give up.
View Replies View RelatedReg Exp To Remove Part Of String
how do I get a reg exp to remove part of a string? -
I have: '/page/txtonly/index.asp' and I want to remove the '/txtonly' to end up with: '/bobby/index.asp'.
Reload Part Of A Page.
is it possible to reload just one table row with out reloading the entire page? Or reloading just a table? i'm not thinking it's possible but if it is it's worth asking a qustion.
View Replies View RelatedRemove Part Of String
Following java script code to get subscriber ID, its value is like 975683678-28_luxap01s.southernlinc.net, I want to leave number there and cut starting _ part, does anybody know how to remove the character starting underscore "_"? the final value is 975683678-28.
<%
subsciberID = Request.ServerVariables("HTTP_X_UP_SUBNO") ;
%>
Extracting Part Of A String
we have a database with a lot of products in it. and for some reason one fo the feilds is set up like "<img src="images/something/image.jpg" />". they should be set up without the html but because of the way they are set up theres no way i can use them outside of the root directory.
I need a way to just pull the first 10 characters off the string. which would be the <img src=" part, and then pull off the last 4 characters " />. so that i am just left with images/something/image.jpg.
I can sort of get the first part to work by using Mid(string,10)
but how can i remove the last 4 characters?
in php the function would do the ending characters if you made it a negative number. but Mid(Mid(string,10),-4) doesnt seem to work.
How To Use Login Name To Be Part Of Another Page?
I have a login page where i validate my user id and password... this part is done... I need to get the user id to the next page i am showing...
Example like:
-------------------------------
Login Page
userid : abc
pwd : XXXXX
Authentication Successful
---------------------------------
Next Page:
Welcome abc ---> i want it here
----------------------------------
Anyone can show me how shld i do it...
ServerVariables - Request Only Part Of The URL
I am coding a login system with login form etc. and when users are denied access to a secure page within the secure area, I want to obviously send them to the login page to check who they are and check they are allowed to view the secure content of the site.
The problem I am having is that currently, if a user is denied access to a secure page, they are sent to the login page. Once they are granted access, they should be sent back to the page they were originally trying to view and not to the main menu.
(The secure area has lots of pages and users would not be happy if they had to trawl through hundreds of pages to try and find what they wanted.
I know I need to use the ServerVariables collection to retrieve the ("URL"), but I dont want to just use this as a querystring parameter when I send a user to the login page.
This would be insecure because someone out there would find my little login script and start using it on their own site by sending users to my login script to login, and then using the querystring parameter to redirect the user back to their own site.
All I want to do is select the part of the URL after the http://www.somedomainname.co.uk/manager/ part. I cannot use a Left select or right select option because my login script will be put onto lots of different websites, and I would have to change the Left select on each different site.
Using Wildcards In The 'Where' Part Of An SQL Statement
Basically, what I want to do is to group records according to the first letter of "username" (the primary key).
SQL = "SELECT order_date FROM cart_order WHERE username = 'A*' ORDER BY username"
I've tried using a 'wildcard' (*) in the SQL statement and it doesn't work. So, how does one filter out records according to the first letter of the cell's data?
Refresh Just Part Of The Screen?
I can come up with a page that displays some information. The information will always be displayed on specific part of the page, with auto refresh. But he doesn't want the whole page to be refreshed so that buttons and images around the information do not get
reloaded each time. Is this really possible?
Other pages on this site don't use frames, so this page can't use frams too. Creating an ActiveX control is also not an option of us ...
Extracting Part Of Text
Is there a way of extracting only part of an entry retrieved from a SQL database. For instance, if I have an article of 4000 characters can I extract only the first line of the article and them put a link to the full article after the extracted text.
It is something I have been trying to master and will help me display my retrieved recordset data better.
Print Part Of An Asp File
I have link from a page.If you click on 'pedir presupuesto' it goes to a form, when someone clicks submit on the form the next page sends an e-mail, and must print part of the table from the original asp page (0.asp - from the first darker grey header to the second one).
View Replies View RelatedStripping Part Of The Text
I want to strip email from the text. Some of my users may send me a string:
str = "This is email 1: Join Bytes! and here is email 2: <a
href="mailto:me@me.com">me@me.com</a>"
How do I parse the string to get email address only? mI know I may use instr() to determine if email address exists, but please, give me a hint on how to handle it next.
Hide Part Of Page
I have created a drop down box that picks items (active product lines) from my dbase (sql), once the user selects an item from the drop down, I would like asp to relate that choice to the next table and pop up another drop down box (active products from the above product line chosen).
I'm assuming that there needs to be some function to hide the second drop down box until the first choice is made (I could be wrong here??) so I don't know what the code would be for the page to stop showing anymore information until a choice is made. I usually show code here but this is really a question about code that I don't know.
Don't Show The Page As A Part Of URL.
The web page has page1.asp, page2.asp, page3.asp, etc... However, When we type http://www.myserver.com, and go to different pages, the URL will be unchanged. How to do that? Usually, it will be http://www.myserver.com/page1.asp, http://www.myserver.com/page2.asp, etc..., with the actual page.
View Replies View RelatedPart Of Webpage Not To Refresh
i have a site that has a header include file, i don't want the header to refresh as i navigate through the site. Is this possible?
View Replies View RelatedSelecting Part Of A String
I'm just starting out learning a bit of asp with my job so pardon my bad use of any jargon
In 'A:B:C: D:E' I want it to only return 'A:B:C: D'. Dropping off the content after and including the LAST :
Can anyone help?
Use Login Name To Be Part Of Another Page
i did not see from that view point of yours. anyway, i guess everyone reading this thread learned something about sessions & querystrings.
View Replies View Related0x80004005 Error, Cannot Add Or Change A Record Because A Related Record Is...
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:
Retrieving Form Data (part 2)
Is there a way in asp to retrieve part of the URL and use it
say the url was
http://localhost/site/craig/default.asp
or
http://localhost/site/craig/test.asp
or
http://localhost/site/craig/roger.asp?dan=1
is there anyway of retrieving the word craig so to use it in the page, I just want the word Craig
This is because i could have other addresses that are for example
http://localhost/site/jon/default.asp
or
http://localhost/site/jon/test.asp
or
http://localhost/site/jon/roger.asp
where i need to retrieve the word jon
at the moment i use the code
strURL = Replace(Request.ServerVariables("URL"), "/default.asp", "")
intStart = instrRev(strURL, "/") + 1
strName = mid(strURL, intStart)
this worked fine until new pages are added ie a page that isnt default.asp
Obviously i cant use strURL = Replace(Request.ServerVariables("URL"), "/default.asp", "") because default.asp will change...