JAVASCRIPT In ASP - Making A Link From Database Info

Code:
while (!MyQuery.EOF){
Response.Write("<tr><td colspan='2' class='results'>" + MyQuery('Title') + "</td>");
Response.Write("<td align='right' class='results'>£ " + MyQuery('Price') + "</td></tr>");
MyQuery.MoveNext();
}
I have that returning a record set to display ! I then need to make it so the "Title" is a link to a page with all the information shown for that book! How would i go about doing this ?

View Replies


ADVERTISEMENT

Making A Selected Link Inactive In Css

In a style sheet after someone chooses a page, is it possible to make that link inactive while on that page?

View Replies View Related

Calling Info From Subs Using A Link

I want to have a list of links on my ASP page that call specific info from different subs on the page into a <div>. So I'd have a menu-like list on the left, say:

LINK 1
LINK 2
LINK 3

so LINK 1 would call and display the info from the sub called, say, "link1", and LINK 2 would call and display info from the sub "link2", etc.

then on the right would be the <div> to contain the requested info from the sub.

Any suggestions? I've trawled the net for answers but when you don't really get the terminoligy, etc, its very hard to know what you're looking for!

View Replies View Related

Passing Info Inline To And From Javascript/ASP

I have a wierd problem. I have a multi-dimensional array. When a user selects a certain item in a drop down box, I need to manipulate certain data in the page. So essentially to find the correct information in the array, I have to know the selectedIndex in my select statement. I error checked the javascript function using an alert, so it works. I just need to know how I can pass the selected index to the array, and then pass the array to the javascript "updatePreviewPane"

View Replies View Related

Javascript Href Link

I am using Javascript with ASP and am having a problem with a javascript link in that it does not function when clicked. The page is generated correctly without any visible or runtime errors.

A bit of background as to what I'm trying to achieve: i am dynamically creating multiple forms which store details of a products into hidden fields, the information is retrieved from a database recordset. Each product is created in a unique form, this is achieved using a counter variable. I am trying to use javascript to submit the current form - i.e. a hyperlink - which unfortunately doesn't have any effect when clicked. I am thinking I might need to refer to the form differently but am unsure how to.

Below is a sniplet of the source code ....

View Replies View Related

ASP With Javascript Href Link Problem

I am using Javascript with ASP and am having a problem with a javascript link in that it does not function when clicked.
The page is generated correctly without any visible or runtime errors.

A bit of background as to what I'm trying to achieve: i am dynamically creating multiple forms which store details of a products into hidden fields, the information is retrieved from a database recordset.

Each product is created in a unique form, this is achieved using a counter variable. I am trying to use javascript to submit the current form - i.e. a hyperlink - which unfortunately doesn't have any effect when clicked. I am thinking I might need to refer to the form differently but am unsure how to. Code:

View Replies View Related

Retrieiving Info From Database

I am trying to learn how to retrieve information from the database. I am not too familiar with ASP but I was told to use it. How do I go about doing this? What specific aspect of ASP do I need to learn?

View Replies View Related

Store Info In Database.

I have made a registration form for adding my friends information in a
database. The problem is that I want to connect the persons with companies
in the same database. I wonder how i could connect a person to several other
id's in a table.

I wonder if I can make a string in the database that holds all the id's
separated with , for example....?

the string would then look like this:
1,4,6,22,56
for example...

But how can I then open this string and separate the numbers from the , ???

View Replies View Related

Updating Database Info

I have a form that when the user inserts the password data it is supposed to update the member info in the database with the password but instead it just adds a new row with the password and leaves the id requiring the password blank. SO it does add to the database but just not in the correct row.

Here is the code that I have:

View Replies View Related

Info From A Form Into A Database

i have been trying to get info from a form into a database on the server for months, i have one form page and one asp page that should send the data to the database on server heres is my code for both pages. here is the form page:

<form action="deantest.asp" method="POST">
<input type="text" name= "name" ><BR>
<input type="Submit" value="Submit">
</form>

and here is the asp page with the code that i use to put the form data into the data base.

<%dim strformfieldvalues
strformfieldvalues =request.Form("name")
response.Write ("your name is ") & strformfieldvalues%>

View Replies View Related

Pulling Info From Database According To ID

Im getting this error message:

Microsoft JET Database Engineerror '80040e07'Data type mismatch in criteria expression.

Im passing a ID value to a pop up window attached to a variable named 'cat'.

Its passing it across fine, but the following code doesnt seem to be working in relation to it:

strsql = "SELECT cat_ID, art_Artist, art_Title, art_FDescription, art_Price, art_PicFull " &_
"FROM eventDisplay WHERE cat_ID='" & cat & "' "

can anybody see what im doing wrong here?

The following code:

View Replies View Related

VBS And Database Info Issue

I'm trying to update a database from a form, but only by updating the info that was changed on the form (if that makes sense.) Basically, the problem I am having it that the if statements I have setup to build the sql isn't working when the database doesn't have any info in that field. Code:

View Replies View Related

Displaying Database Info Using Asp

I have a database on my server that houses information regarding trouble tickets. I know how to write asp page to take the inputted info from a form and put it in the database but what I would like to know if someone could show me or point me in the direction of a good tutorial that shows me how to list all the content in my database on a web page.

For instance I would have a page titled, view all tickets, then on that page would be a listing of all the tickets and their information with buttons to add, delete or update ticket.

View Replies View Related

Displaying Database Info On Asp Page

I can display information to a webpage from a database and handle the connections etc. My next task is a bit more complicated for myelf. Id like to have a page the pulls information from a record set and displays like this.

down one side

the container numbers

along the top

the products in the containers

the information in the middle would be the amount of product that came on that container.

Im just wondering how the best way to setup my database would be, and the best way to setup the asp webpage. (oh) nearly forgot, it has to repeat the information till all the records are finished but i guess that gos without saying.

View Replies View Related

Display Info From A Access Database

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 Related

Database Connection Info And Driver

Im doing a login page for my website, and it seems i have to do this:

'Database connection info and driver
strCon = "DRIVER={Microsoft Access Driver (*.mdb)};uid=;pwd=letmein; DBQ=" & Server.MapPath(strAccessDB)

What the hell is that? Do I just put the physical path of my DB in there?

View Replies View Related

Adding Info From A Form To Access Database

Except for extremely basic ASP programming that I did two years ago and have forgotten I have not touched coding since!

I've taken a look at a couple of tutorials but they all baffle me!

Can anyone tell me how I can just create a simple html form with input fields of FirstName, LastName, Email and Phone amd when the user hits submit it is recorded in an access database?

I can do the HTML part fine. And I believe I've set up access ok although Ive never used it before.

Also, if the server that the database will go on is a Microsoft one i suspect that is ok? Im not sure if all i have to do is upload the database and it will work? or do i need to talk to my hosting company to set up some kind of odbc thing that ive heard about?

My database will just be called clients.mdb and the table is called Customers.

View Replies View Related

Displaying Info From A Database On An Html Page.

if I have a list of book names and prices and I just want the info to be called onto an HTML page to be displayed how would I do that?

It sounds easy...but who knows with code? :P

I havent' set up the database yet but i suspect it will just be called books.mdb and the table will be called Books.

Fields in the table will be

Name, Type, Condition, Price

View Replies View Related

Send Form Info To Multiple Database Emails?

I have two forms, one on each page. The user fills the first, then the second, then on the third page all the information is displayed for the user to make sure thats what they want to send.

Then they click submit on the third page and it goes through a database and depending on which category, state and county the user selected it will email all the information displayed on that third page to all the emails in the Email field in the database.

Now, I already have the first and second pages(easy enough) and the third page I can get it to display all the info how I want it and now I need to know how to go about emailing that info to the emails that match the specific fields? Right now all I have it doing on the third page, instead of submitting it for emailing, it just displays the info from the forms AND emails that match from the database. Code:

View Replies View Related

Link Access Database

Can anyone tell me or guide me (in details) on how to link Access Database in ASP, including SELECT, INSERT, UPDATE, DELETE issues.Is there any sites offering this resource?

View Replies View Related

Update Database Using Link

how do you create a link that will add 1 or subtract 1 from a number in the database?would it have to call a function that would do it or would i have to use buttons that did it?

View Replies View Related

Link To Acees Database

I have a web page that lists our group's service activites we are doing thorughout the year. Curently we have abook that we write down what events we were present to but I would like to make it available online to eliminate having to type down all the information in an excel sheet or access database.

I would like to have the page somehow link to an acess database or excel sheet so that anyone can make changes to the tables and querys (by adding to their name what events they attended). Idealy whatever chenges they made would be saved.

View Replies View Related

Connection & ASP Link To Database - Not Working

I am new to asp pages and vbscripting and am having a problem trying to get a form in a html document to be submitted back to a asp page, then into a microsoft access database.But not sure what I am doing incorrectly. Every time I fix one error I seem to get another error.

This is the latest error, and I believe the problem exsists in the ASP page? Something to do with the connection, that it is not seeing the Nano.mdb database. It is set up correcly under the System DSN in the ODBC data source. Any ideas?

Microsoft OLE DB Provider for ODBC Drivers- Error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/WPF Project/NanoGroup.asp, line 39

Also would the connection string be in the include file or in the ASP file. If it is in the asp file, then do I need to attach the include file? Code:

View Replies View Related

Create Link To Database Records

What I am wanting to do is list the last 10 submissions to a knowledge base and create a link to each one with the question text serving as the visual representation of the link.

I have searched the forums for info on how to do this in ASP and have come up empty. I will detail what I have so far.

I have a database table called kbase and want to have html table with links to the last 10 things entered. I just can't figure out how to get a dynamic link to point back to the database entry.

I may be missing something very simple here but as this is work related my time frame for learning is small at best. Code:

View Replies View Related

MySQL And Access Database Link

Is it possible to call fields from a MySQL Database and an Access Database on the same asp web page? If so, can someone please point me in the direction of a good guide/article/post on how to do this.

View Replies View Related

Sending A Query To A Database On A Link

I would like to know how to go about sending a query to a database when a certain image/link is clicked by the user.

By this I mean e.g. table in a database called cd, primary key in table id. Each image/link has its own id number which refers to its record in the table.

So when the user clicks an image or link i would like it to preform a SELECT query using the id number.

How would i go about giving a link/image its own id number? I guess this is simple as i have seen it on many sites and have seen the query string at the bottom of the browser in status bar when you hover over image/link.

View Replies View Related

Displaying Mailto Link In A Database

I am developing a simple little application for a client that allows them to do an employee lookup. This small Access database contains only a few fields such as name, job, email address etc.

However, when the data is pulled from the database, I would like my ASP pages to create the email as a mailto command when pressed. I'm not sure how to go about this.

I tried creating a mailto: link on the dynamic text but that hasn't worked.

Can anyone assist?

View Replies View Related

Dynamic Link Breaks When Database Gets Too Large

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>

View Replies View Related

Database Lookup In A Javascript Function *before* Displaying The Error

Is it possible to do a database lookup in a javascript function *before* displaying the error alert?

We want to do a database table lookup first and get a BETTER error message based on the text field throwing the error.

View Replies View Related

Javascript Language Paging Larger Database Record Sets

I am fimliar with asp javascript and not asp VB.

i can display the results ok, but if i return 100 records from my table i would like it to display 5 records per page. i have looked at asp recordset paging on several sites, however cannot find any scripts that work with ASP JAVASCRIPT....

View Replies View Related

Making Connection

For an upcoming test I need to write an explanation of the code on connecting to a databse through a webpage. I wrote the code and the page works, but could someone help me explain this line of code:
SET myConn=SERVER.createobject("adodb.connection")

View Replies View Related

Making A Quiz

Does anyone have a clue have to make a quiz in asp using an xml file? I found a good quiz but the code is in asp.net so we can't use it

View Replies View Related

Making A Session Less

how can i identify the user session?and, assuming that i generate my own "session id" for each login carrying it along the requests.how can i, latter, release the session ?

remember that Session_OnEnd( ) don't work well all the time.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved