I am using ASP with VBScript. I want to query an access database username
field, and display the output as a hyperlink on an a webpage.The webpage
will display all records. I then need to be able to select a given
record(hyperlink), and display all of the fields for that record on another
webpage so I can execute some code against it.
Can anyone point me to some sample code so I can get an idea of how to
accomplis this?
I've been using both Frontpage and Access for a couple of years. Now I'm trying to integrate the two of them.
So, I have a webpage with a map of several locations. I want to be able to click on a location and have it run a query in my Access database to spit out
information about that one site.
My Access database is loaded on the server. I've created an .asp already and I can use the Frontpage interface to select various sites, but I want the query to be driven by what site I click on.
and of course I've already created the hotspots. What SQL coding would I use to tell the Frontpage Database Results wizard to look up information based on which hotspot I clicked on?
how can I display multiple access data on hyperlink in ASP?? For example like I click on Monday link it will only display all the informaton about Monday and click tuesday will only display tuesday information on same page.
View Replies View RelatedI'm trying to put a long hyperlink into my database table which works fine. I used longtext as the field type. My records insert just fine. But when I try to retrieve the records on the asp page all the other data shows up but the hyperlink data. Here's an example of my link.
INSERT INTO products
(manufaturer, prod_category, prod_link)
VALUES ('Xtra','Irons','<a href="http://www.kqzyfj.com/click-1692223-10304326?url=http%3A%2F%2Fwww.golfsmith.com%2Fppage.php%3Fstynum%3DCL1480%26tcode%3Dcj" target="_top" >CG1 Irons w/ Steel - 3-PW Iron Set<br>$799.99</a><img src="http://www.afcyhf.com/image-1692223-10304326" height="1" width="1" border="0">');
What am I doing wrong.
I have a database which I need to display a hyperlink to another web page when the results are displayed in an existing web page. The current line of code is as follows:
Response.Write " | " & objRS.Fields.Item("contact")
This displays the information I need but it also displays the hyperlink as text after the field information ie development team#http://www.awebaddress.com# .what the line of code should be in order for the contact field to appear as a working link to another web page.
I have a form where a user enters their name, date etc. i also want them to be able to click on a browse button and select a file which will then appear in a textbox. when they press submit i want the file name and path to be put into the database. e.g.
"C:windowsworkwork.doc".
Basically I don't want to UPLOAD the file just enable the user to browse to it and send the filename and path to the database.
I would like to create a page of hyperlinks that are constructed from the contents of a database field. When the user clicks the link they are taken to a page that will display all fields from that particular record.
I already have the page structures in place. There are two pages, one with the links and the other to display the record. Code:
I have 3 different check box's on a DB query display. Can I check all 3 fields and if all are <null>, base my display verses if all are on or a mixture of on and off?
View Replies View RelatedI have set up an Access database with a couple of time fields. These display within the database columns as hh:mm but when used to populate my web page show up as hh:mm:ss.
What ASP code can i use to remove the seconds and show these times in the format hh:mm?
just manged to get an image retireval search engine working. The ASP script works fine, my query results are filepaths of images.
i structured a query in within asp to obtain images which have similar textual values. It is more of a cosmetic issue. when i get my query results back, my script prints or displays the images from top to bottom. which means i have to scroll vertically up and down the asp page over 10-30 images. Code:
i have a form where users leave their reviews that will be displayed on the home page. [sometimes the reviews are too long to be on the homepage, i was wondering if i can limit the size of the review display on the homepage.] but i still want to have the full review on my database.
View Replies View RelatedI'm creating a database search page and the table I want to search has fields linked to other tables in the database. For example, the job table has a number of fields, 2 of which are area and job type which are tables in the database. My search page has option for searching by job title, job type and job area (via dynamic drop-down).
Do I need to create a recordset for each referenced for the dynamic drop-downs to work
I want to display a system maintenance notification on my webpage using a splash screen. I got the code for splash screen from Dynamic Drive and added it on my web page. Now here is my problem. I have created a table in my SQL database with these two fields, Flag and Description. I am trying to connect this splash screen to this table.
This is because-if the flag is set to 1 the splash screen will pop up and display the data in the description field on the splash screen and if it is set 0 the screen will not pop-up at all. Two things I am having trouble with-
1. Displaying the data on the splash screen. I made the connection to my db but can't get it to display it on my splash screen.
2. How to make the splash screen pop-up only if the Flag field is set to 1.
How to use the for loop to display all the data in database? For example, displaying the data that start with "a".
View Replies View RelatedI am using an ASP page to display the information in a database.The last field in the table does not display properly if there are words in the last field.So,when its blank this code works:
If x.name="Reviewer_Comments" Then
Response.Write("Reviewer Comments: "&x.value&"<br>")
End If
When there are words in the field it fails to display and on a check it said that x.value was null when there are supposed to be words in it.the field is set as a memo field to accept the text that will be entered.When I set it to a Text field which only accepts 255 characters it worked fine.
i have a database..(pics.mdb)
1 table
pics(table name)
id,file,display(3 fields)
4 records..
1,pic1.jpg,yes
2,pic2.jpg,no
3,pic3.jpg,yes
4,pic4.jpg,yes
what line of code do i use on my asp page to display the picture where display is yes?
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 RelatedI have this code that retrieves the logged in users info. What I also need it to do is to display other records in the database that match the logged in users custnumber. Code:
View Replies View Relatedi'm confused about perfoming insert, update and delete operations in a database. I know that to only use SELECT statement you would create a recordset and use it but for all other you need to use Command or Connection Object.
I'm confused because in some books/articles they create and open a connection and perform insert/update using that. in others they say to use Command object instead. which one do u use when?, why?.
I wish draw data from a MySQL Database using ASP.
The Code I have so far:
<%
dim adoConn, adoRS
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "driver={SQL Server};server=SERVER-WEB;database=testing;uid=products;pwd=starmart"
adoRS.ActiveConnection = adoConn
%>
and in the asp page code:
116. <%=rsDaySummary.fields("PageViews")%>
This is obviously wrong as it returns this error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/stats.asp, line 116
Any pointers would be appreciated.
The following code works fine doing a query in the db and return the data with the link ...mes.asp?month=X (where X is a month and mes.asp is the name of the file that this code is in...)
I have a ID column in the database and would like to know how to catch data from ID.. i have tried without success, dunno why but the code comes with a error in the line "rs.Open sqlStr, data_source"... Code:
i have this shopping cart i'm working on and it keeps giving me this error and the original code is on the bottom. Code:
View Replies View RelatedI am using MS Sql server and asp pages together.The problem I am getting is not knowing what data type to best set my data to.There is a part # set to nvarchar which seems to work great.
THen an Inductance, currently set as float. My inductance values show as 1.5 and 5, 3, 3.2, etc etc, however I need it to show 5.00 and 3.00, 3.20 etc.the inductance is measured in mH and another column called DCR is measured in Ù. Is there anyway to get this symbol to show in my table on my asp page? or do I need to enter the symbol into the database table?
im using ajax to load different pages of code into containers on one page.. i have checked my code.. and things SEEM to be named correctly.. and i know the db is workin because it populates the drop downs properly.
so if you could do this form me.. choose the first radio.. 'london postcode' and proceed from there.. when you click the get quote that error comes up.
I am trying to create a xml tree using sql server 2000 and asp 3.0 i am looking for a code for it .
View Replies View RelatedI need to know the syntax to achieve the following.
<%
Dim Year_Value_Num = 1999
Year_Value_Num = 1999
rsUsage.Open "Select AuthorLastName,ReceptorName,Year from TblAuthorInfo where Year > Year_Value_Num ", strConn
%>
The database access works fine otherwise But if i attempt the above code i get the error.
How can I display images that reside in my database through an ASP page?
View Replies View Relatedprincipally I'm a photographer, and in the absence of any image galleries I could make sense of I created my own asp pages in Dreamweaver displaying images from a path stored in a database. These can then be paged through, all done using server behaviours in Dreamweaver. However, because I wanted to include some text next to my images, again a field in the database, I have to scale them down. I would like to give the user the option to see a larger version of the image on display, preferably in a pop-up window that is then closed by the user before they continue scrolling through the images....
View Replies View RelatedI am rewriting from scratch some code done by previous programmer on a glossary for our website. I have a database with three fields, ID, Term, Definition and a table called glossary. I need to be able to display everything to the *same* ASP page.
I have already successfully created the db connection and the records display according to the SQL statement, i.e. where Term like 'a%'.
What I would like to do is to display each letter of the alphabet dynamically from the Term field as a hyperlink that will display the terms beginning with that letter, i.e.
A B C D .... Z
The terms would be displayed as hyperlinks and when clicked will display that term and the definition. If A were clicked: Code:
I have a table in an Access database that is called news. Inside that table is a field name called newsNews. I'm trying to get that is in that field to display on a page and her is my code:
View Replies View RelatedWe have a table where we store employee information. One of the fields in
the table stores the manager number which is the employee number of the
users manager. Sample data is below
EmpNo Name ManagerNo
2211 Peter 9900
8899 James 9900
9900 Mel 9111
9901 Ian 9111
9111 Simon 9111
I want to able to display all the employees who report to a certain manager
and also all the employees who report to them
Something like
Simon
Ian
Mel
Peter
James
I am sure this can be done but I don't know how to do it recursively.
i need to display all my tables from the mySQL database in a table on an ASP/Javascript page, each as a link, so that when clicked, it wil open the selected table for editing. unable to do it as dreamweaver MX is not accepting 'show tables' as a valid query. how can i go about doing this? i'm relatively new to ASP, working on it for only 2 months now.
View Replies View Related