Help with asp code

Report · Jul 21, 2010

Helleo Everyone

I have been given a website to ammend and although i am not new to dreamweaver and using asp within dremweaver i sometimes struggle dealing with stuff that may have not been created with the tools i am used to.

I have a page that displays information relating to different clocks the page gets its info ftom an access table called tblmovements, in that table is column Called KitID and another column called details that has link information that would go to another page.

Back to the main page all that i need to happen is when the user scrolls down to find the clock that they want i need them to be able to click on more details and for that to link to the page that is referenced in the details column in the table.

But i am not sure on how to do this.

The column kitID is a unique column.

Can anyone assist

Thanks

John

Report · Jul 22, 2010

You would need to create a link to the detail page that contains the ID that identifies the detail row. The detail page reads the querystring and extracts the ID and uses that in the where clause of the SQL select statement. If you need more details, please include more info about your data structure and some sample data.

Report · Jul 23, 2010

Hi Thanks for the response

Below is the page that shows the information, then where it says details that would then link to the appropriate page.

I did do a link using dreamweaver recordset to the column that has the link in it but every details bit went to the same page, so i understand what you are saying about identifying via the ID but thats the bit i am unsure of.

<%@LANGUAGE="VBSCRIPT"%>

<% Dim Recordset1 Dim Recordset1_cmd Dim Recordset1_numRows

Set Recordset1_cmd = Server.CreateObject ("ADODB.Command") Recordset1_cmd.ActiveConnection = MM_dbConn_STRING Recordset1_cmd.CommandText = "SELECT * FROM tblMovements"

Recordset1_cmd.Prepared = true

Set Recordset1 = Recordset1_cmd.Execute

Recordset1_numRows = 0

%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<%

Dim objRS

Set objRS = Server.CreateObject ("ADODB.Recordset") strSQL = "SELECT * FROM tblMovements ORDER BY KitID ASC"

objRS.Open strSQL, MM_dbConn_STRING%>

<title>Oakside Classic Clocks | Clock Makers - Kit Gallery</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <meta name="description" content="Oakside Classic Clocks' Gallery of clock makers Kieninger 'movement, dial, pendulum and accessories' kits." /> <style type="text/css">

<!--

@import url(css/global.css);

.style3 {

color: #990000;

font-style: italic;

}

.style6 {

font-family: Georgia, "Times New Roman", Times, serif;

color: #000066;

font-style: italic;

}

.style9 {color: #990000; font-style: italic; font-weight: bold; }

.style14 {color: #990000; font-style: italic; font-weight: bold; font-size: small; }

.style15 {color: #000000}

-->

</style>

</head>

<tr>

</tr>

</table>

<tr>

</tr>

</table>

<h1 class="strapline">Kieninger Clock 'Movement, Dial & Pendulum' Sets - For those who insist on the Best! </h1>

<h2 align="left" class="strapline">Welcome to Oakside's 'Clock Makers' Gallery - On this page Frank has assembled a large selection of comprehensive clock makers sets to suit all styles of clock cabinets - each Set contains a Kieninger mechanical Clock Movement and a Dial and where appropriate, a Pendulum, the Weight Shells & Fillings, plus all of the Accessories required to get your clock running. We believe that Oakside now stock the largest range of Kieninger Movements and Accessories in Europe! </h2>

<h2 align="left" class="strapline">Each of Oakside's Clock Makers Sets include every thing you will need to get your clock running, including a Kieninger Mechanical Clock Movement, a Dial, a Pendulum, polished brass weight shells & fillings, the cable pulleys, the gongs, winding key and the fixings. We also include a drawing showing the primary 'movement, dial and pendulum' accommodation dimensions and a template for positioning the mounting holes required to fit these items into your clock. On the 'Spares & Accessories' page you will find special brass rebate hinges, mortise locks, escutcheons, keys and brass screws and adjustable cabinet feet for leveling your clock. You may collect your pre-ordered/pre-paid kit and save the postage.</h2>

<h2 align="justify" class="strapline">We also stock a huge range of <a href="kit_spares_accessories.asp">replacement parts</a> for Kieninger movements. </h2><h2 align="left" class="strapline">If you require a replacement Kieninger movement without accessories please <a href="movement_gallery.asp">click here</a>. </h2>

<h3 class="style6"> You are invited to phone Frank to discuss your project prior to ordering a kit. If you are designing your own clock or are intending to modify an existing design, we suggest that you pre-order your Movement set with a deposit of £25. We will then send you the Kieninger installation drawing so that you can ensure that all parts will fit and operate without later cabinet alterations.</h3>

<h3 align="justify" class="style6">Please note, when you purchase your mechanical clock parts from Oakside, you are dealing with a dedicated Longcase Clock Designer & Maker, not just a shop! We would happily examine you clock drawings to ensure that your design will be able to accommodate the Kieninger movement of your choice; we will also provide telephone assistance when you are installing the mechanicals and commissioning your clock - our expertise will ensure that your new clock performs perfectly!</h3>

<h3 class="style6">Thinking about building you first Grandfather Clock - We suggest that you visit the web site of <a href="http://www.van-vliet.org/dempseywoodworking/grandfatherclock.shtml">Dempsey Woodworking</a> in Canada. Frank has coordinated with the sites owner who has prepared detailed construction plans for a longcase clock, in the style of our Winchester Grandfather clock. Please note that by modifying the depth dimensions on the plan, you can build this clock to accept any of our Kieninger 116cm movements. The web site provides an illustrated 'Step by Step' guide showing each of the constructional stages and you can down-load a free copy of the plans.</h3>

<h5> For Grandfather Clocks around 80 inches high and taller we suggest a 116cm movement with a 280mm width dial.</h5>

<h5> For Grandmother Clocks between 60 & 70 inches tall consider a 100 or 93cm pendulum Movement with a 250mm width dial. </h5>

<h5>For Granddaughter clocks we suggest a 93 or 80CM pendulum Movement and a 200mm width dial. </h5>

<h5>For Laterndluhr Style, Large Wall Regulators with 116cm 'Seconds pendulums, consider Kits 24, 25, 26, 27 28 and 29. </h5>

<h5>For Medium Height Longcase Wall clocks consider the 65, 80 and 93cm Pendulum Movements.</h5>

<h5>For Smaller longcase Wall Clocks consider Kits 08, 09 and 09A. </h5>

<h5>Shaker Wall clocks require a movement of shallow depth and are usually without chimes - Frank suggests Kit 09 .</h5>

<h5>For Small Mantle Clocks consider Kits 01 and 02. </h5>

<h5>For Large Mantle or Bracket Clocks, consider Kits 04, 05, 06 and 07.. </h5>

<p>

<%

Do While Not objRS.EOF

' Replace character retuns, ' and " characters

strKitDescriptionShort = objRS("KitDescriptionShort")

strKitDescriptionShort = Replace(strKitDescriptionShort, vbCRLF & vbCRLF, "</dd><dd>")

strKitDescriptionShort = Replace(strKitDescriptionShort, chr(34), """)

strKitDescriptionShort = Replace(strKitDescriptionShort, chr(39), "'")

strImgSrc = "imgs/clocks" & objRS("imgKitCatalogue") %>

<dl>

<img src="<%="imgs/clocks/movement_images/" & objRS("imgKitCatalogue")%>" alt="<%=objRS("imgKitCatalogueAltText")%>" hspace="10" vspace="10" class="img-gallery" />

<dt><%=objRS("KitID")%> featuring the Kieninger

<%=objRS("MovementName")%> </dt>

<h6 align="center" class="strapline">Price including UK & Ireland delivery £<%=objRS("KitCostStandard")%></h6>

<h6 align="center" class="style3"> Please note that we ship to Canada, the USA, Australia & New Zealand and you get UK Tax Free Prices. </h6>

<dd>

<h3 class="strapline"> You can view the dials etc available for this kit by <a>clicking here.</a>Details</h3>

</dd>

<dt class="strapline">Click to view the </span><%=objRS("KitID")%> <a href="kit_options.asp?KitID=<%=objRS("KitID")%>"> Options & Prices</a> page. </dt>

</dl>

<%

objRS.MoveNext

Loop

%>

</div>

</div>

</body>

</html>

<%

Recordset1.Close()

Set Recordset1 = Nothing

%>

Report · Jul 23, 2010

A couple of things.

First, please post only the relevent parts of the code. We don't need to see the css or parts of the html that don't include dynamic elements. It's just makes it easier to read through the code.

Next, you defined two recordsets - Recordset1 and objRS but are only using objRS and only closing Recordset1.

The code you have for the link looks correct, so it's possible that your detail page code is wrong. Seeing this online would help - is there a url?

Report · Jul 26, 2010

Sorry about the code i will keep it to a minimum in the future.

I noticed you said that there are two Recordsets in the code and i just wanted to say that i added the secound one through using the dreamweaver recordset tools.

I think the reason that i am having trouble with this is because the site was built by somebody else, writing all the code etc by hand and not using the tools in dreamweaver which i am used to doing.

The URL for the site is www.classic-clocks.co.uk

maybe if you could assist me with doing the code by hand ill give that a go.

John

Report · Jul 26, 2010

I think it depends on what sort of "link Information" is stored in your table to decide what direction to take.

Is it an actual URL or is it another identifier to another table that contains the details?

Either way, I would replace the original recordset code with a DW recordset, then you have access to all the functions that occur afterward - such as adding data to a URL string when you click the "More info" link.

Do you have a link to the actual page where this is currently working? I went to the site but I'm not sure which page it is that you're working on.

Report · Jul 26, 2010

I just went to the site and tried the links and they appear to be working - the details pages bring up the correct details. Can we assume you've got this working now?

Report · Jul 27, 2010

Hi

The site that you went to is correct and working, that is the site that i have to make the ammendments to so i am working on a copy of the site.

I am going to try and rewrite this using the dreamweaver tools.

I will let you know how i get on