.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..
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 .
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 View RelatedI 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
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?
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?
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 RelatedOn 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.
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 RelatedWhen 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?
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 RelatedI have a script that looks for a phone number. I use an instr to see if
it finds a - for the phone number. I them grab the 3 characters before
and 4 after for the phone number. Works well, except when someone uses
the - in the text.How can look for the second instance of the - if the right 4 characters
past the - are not numeric?
I have a Class and i want to be able to use its instance
example
public class Enrolltest : System.Web.UI.Page
{
MyClass mc = new MyClass();
mc.mymethod();
}
when i do this i get an error telling me there is no name space what should i do .,,.
i dont want to create a dll and add it to assembly and all that stuff.
How to create an instance of Internet Explorer from classic ASP? I want
to create an instance of IE and then subsequently load a webpage through
this object.I am aware of creating web pages through scripting.
Long way to go before I sleep .
How do i lanch a new instance of explorer from withing a current web page.I want to click on a link that take me to a new page in another "window" so that when i close it i see the old window.
View Replies View RelatedA three-tier user authentication system was running without a problem for almost a year and now is suddenly dysfunctional. We don't know of any changes to any of the servers. It's quite maddening. The details:
1) We know the COM+ app is instanced on the COM+ server (Win 2000). The component graphic spins when CreateObject is called.
2) The proxy is installed on an IIS server (Win 2000) with delivers the interface, written in ASP, to the client PC.
3) These are the error messages displayed when a method of DAMS is called:
when i try to open an excel spreadsheet using the
following code, the process just hangs IF the spreadsheet
contains macros:
Set objXls = CreateObject("Excel.Application")
objXls.DisplayAlerts = False
objXls.Visible = False
objXls.Workbooks.Open my_excel_path '<-- hangs here
this worked on iis4, but since moving this to iis5 it
fails under the aformentioned circumstances. my guess is
that the macro security has something to do with it as a
dialog box will pop up if macro security is set to medium,
but i'm not sure this is really the problem. if it was,
what profile should change the macro security on the
server? when task manager is opened on the server to see
the hanging task, it shows SYSTEM as the process owner...
any ideas?
My server chokes when i try to use the filesystemobject. I'm running IIS v5.1 on XP Pro and it stalls when i try to create a text file or open one. Here's an example script that fails on the 3rd line.
dim filesys, filetxt
Set filesys = CreateObject("Scripting.FileSystemObject")
Set filetxt = filesys.CreateTextFile("C:InetpubwwwrootAIS estfile.txt", True)
filetxt.WriteLine("Here's the text...")
filetxt.Close
set filetxt = nothing
set filesys = nothing
Am not sure where to start troubleshooting .
How to set timeout for COM+ object instance? If any instance is running more than 15 minutes, I want COM+ application to kill the instance automatically. Is there any way to set this?
View Replies View Relatedneed inserting the radio buttons that are checked. Ok I'm trying to insert the user picks but i need help on first renaming each set of radio buttons so they can select one from each group then i need help on inserting the ones selected. Code:
View Replies View RelatedIf I have 30 of the same cmpycd in the column, it brings it all up. I think this is one of those IF/THEN things, but not sure how to impliment it in the code.
All I want to do is show one instance of each unique item that exists in the cmpycd column. If it exists 300 times, I just want to show it once. Then also show the compFN that is also in the same row.
I can make it count and show how many are of each, but I cannot seem to get it to display just one of each. Code:
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:
We are using .net 1.1 on windows 2003 server. This is we are facing in our
production server.
When we are doing the load testing we are getting the bellow error. While
the load testing this error is not coming frequently. When we run 20 threads
for 3 mins we are getting this error message 2 or 3 times. But this line of
code is executed by all the threads. Code:
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
View Replies View RelatedI have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
A three-tier user authentication system was running without a problem for almost a year and now is suddenly dysfunctional. We don't know of any changes to any of the servers. It's quite maddening. The details:
1) We know the COM+ app is instanced on the COM+ server (Win 2000). The component graphic spins when CreateObject is called.
2) The proxy is installed on an IIS server (Win 2000) with delivers the interface, written in ASP, to the client PC.
3) These are the error messages displayed when a method of DAMS is called: Code:
I want to download record set from my SQL database as csv format but in ZIP file .I can download as a csv file now ..But i can't put that in zip file and download.
View Replies View Relatedhow to deal with multiple recordsets on the same page?
It's gotta be something small and clear so I could understand.
Somewhere I've read that multiple recordsets are not allowed when using Microsoft Access Database?
I am looking to
have some sort of SQL Trigger maybe? I have a field called 'dateActivated' and 'isActive'I'm looking to somehow say when dateActivated + 6 months then set isActive = false. I want this to
be automatic. I am using ASP/VBScript if this somehow matters.
I have a form on an asp page which is used to add additional users to
the DB, i.e. adding a UserID (PK on table), Password & Email.
The companies are allowed a max of 3 users. If the company only has
the default 1 user and wishes to add another 1 or 2, then the form
displays the current user details, not in text boxes as this is not an
adit data form. The additional user/s can be entered into 1/2 rows of
text boxes, user 2 & 3.
If they decide to add 2 new users, how do I add the additional 2
records to my db table on submit ? Code:
i am tryin to run a search on a db and am using a like statement which works fine but i want to select what it finds and also the next 9 records any idea on how to do this
View Replies View RelatedIs there any way to change the following code so that when it's the second last record in the set it doesn't put UNION ALL at the end? Basically, is there a way of saying:
if SecondLastRecord then
I don't know how many records there will be, so I can't count down from 7 or anything.
Code:
Every time I try to ADD a new record from my asp page to SQL table, I got this error:
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Violation of PRIMARY KEY constraint 'PK_Cancelled_Classes'. Cannot insert duplicate key in object 'Cancelled_Classes'
Here is the Insert statement:
Sql="INSERT INTO Cancelled_Classes (yrtr, cou_id, cancell_date, Message)" sql=sql & " VALUES " sql=sql & "('" & Request.Form("yrtr") & "'," sql=sql & "'" & Request.Form("cou_id") & "'," sql=sql & "'" & Request.Form("cancell_date") & "'," sql=sql & "'" & Request.Form("note") & "')" '
conData.Execute sql