DETAILPAGE INFORMATION????

[snuif12]

Hello,

I have a real problem I need for my client.

I have only one tabel in access which I have placed on my page. Vertical (Y
coordinates) I have all my mobiles and horizontal (x coordinates) my several
subscriptions. All the figures in the table are the prices they have to pay for
the combination mobile vs subscription. The combination can be selected and
have a link to next page the detail page. All the mobiles are provides with an
ID (Y coordinate).

The customer will select a mobile and one subscription by selecting a price or
the link. In the detail page I have my form to give an order. But I need to
have the X and Y coordinates.

With the ID of the mobile I will know the selected mobile in the detail page
(the Y coordinates). How I get the name of the subscription to the detail page
(X coordinates)?

Note: The information is coming form one table!

[dischord13]

I might be misunderstanding what you want to do. It looks like you can get the
row (Y cooridnates) name because you have the ID but you can't get the Column
name (X Coordinates). Is that right?

Well, if the column names are static anyway, you could just add the name to
the URL parameter. In your link dialog box, click the Parameters button and add
a new one that says Name="SubscriptionName" Value="Subscription#1"

Just add a different parameter in your link for each column.

Hope that helps, let me know if I misunderstood what you need.
James

[snuif12]

Thanks for your reaction James.

You understand my problem. In holland it is 1:00 hours night now. tomorrow morning I go to try your suggestion.
I give you back the results.

Thanxx a lot.
Jan

[snuif12]

Helo, I have tright this soluttion.

Well, if the column names are static anyway, you could just add the name to
the URL parameter. In your link dialog box, click the Parameters button and add
a new one that says Name="SubscriptionName" Value="Subscription#1"

The problem is that the dialogbox afther I have selected the parameters not
gives the existed code. So I override the excisted code. I cannot add a code.
What I am doing wrong?

I don't think it is good to cut and past the codes.

I have attach the different codes for a simple trail version of an other
subject so you see the results of overwriting regioA
regioB etc is normal

I am inquisitive to your enwer. Thanxx in the meanwhile.

Jan

<tr>
<td><a
href="thanks.asp"><%=(Recordset1.Fields.Item("Merk ").Value)%></a></td>
<td><a
href="thanks.asp?<%=(Recordset1.Fields.Item("Idwag ens").Value)%>=<%=(Recordset1.
Fields.Item("Idwagens").Value)%>&regioA=regioA"><% =(Recordset1.Fields.Item("Regi
oA").Value)%></a></td>
<td><A HREF="thanks.asp?<%= Server.HTMLEncode(MM_keepURL) &
MM_joinChar(MM_keepURL) & "Idwagens=" &
Recordset1.Fields.Item("Idwagens").Value
%>"><%=(Recordset1.Fields.Item("RegioB").Value)%> </A></td>
<td><a href="thanks.asp?<%= Server.HTMLEncode(MM_keepURL) &
MM_joinChar(MM_keepURL) & "Idwagens=" &
Recordset1.Fields.Item("Idwagens").Value
%>"><%=(Recordset1.Fields.Item("RegioC").Value)%> </a></td>
<td><a href="thanks.asp?<%= Server.HTMLEncode(MM_keepURL) &
MM_joinChar(MM_keepURL) & "Idwagens=" &
Recordset1.Fields.Item("Idwagens").Value
%>"><%=(Recordset1.Fields.Item("RegioD").Value)%> </a></td>
<td><p><a
href="thanks.asp"><%=(Recordset1.Fields.Item("Regi oE").Value)%></a></p></td>
</tr>

[snuif12]

After still two hours I didn't succeed in all kinds of combinations how to make
the code with cut and past.

Ik get all kinds of mistakes from HTTP 500.001 - Internal Server Error ....
It is normal when you try somthing.

I hope and wait for relection.

If this will succeed I think it is possible that also somthing had to chanche
in the mext pas to filter the kolomn?

Thanxx

[dischord13]

Sorry, I'm more familiar with databases than I am with ASP. But I can see that
RegioA is different than the rest. I don't think you have to do any coding.
Dreamweaver should be able to write the code for you. You might have to re-make
some of the things you already made to get it to work so dreamweaver can write
all new code. What version of Dreamweaver do you have?

How do you get the Mobile ID to the form? Are you using a URL Parameter to
pass the Mobile ID?

I'm just going to state this again just to make sure we are talking about the
same thing. Here's what I think your page looks like:

Mobile, Subscription1, Subscription2
1 $100 $200
2 ..... ......
So your link in the "$100" cell would look like:
Detail.asp?Mobile=1&SubscriptionName=Subscription1
And your link in the "$200" cell would be:
Detail.asp?Mobile=1&SubscriptionName=Subscription2

On the Detail page, all the information about the Mobile you can get from a
Recordset because you know that Mobile = 1. I think you already know how to do
that. The subscription name is different and you will have to get directly from
the URL by typing something like Request.Querystring("SubscriptionName") in a
text field or text control in your form. You might not have to type that
because Dreamweaver should have a control to help you do this.

Do you want to tell me exactly what you have on your master page and exactly
what you want in the detail and I will think about it. I don't have access to
Dreamweaver right now but I can look at it tonight. Not sure what time that
will be in your time zone! I hope that helps a little bit.

James

[snuif12]

Thanks for your helpfulness

1. I am using Dreamweaver 2004 MX
2. I am glad to know that Dreamweaver can do everything so no coding is
necessary
3. I tell you everything in detail but I left home for 3 days tomorrow. We are
6 hours earlier then New York. I read my email dress [email]jan.vandesande@gmail.com[/email].
But my website and DW is at home.
4. In my master page is my table. The XY coordinates go to my order page there
I have a form. When they submit the form there are to places I need the XYZ
information (XYZ later in point 7). First in my database and second (I will
thank them for the order and ask them) to make a hardcopy. I have to put the
XYZ information in this document. The customer will send the hardcopy to me
with the personal registration information. This is the concept or flow of my
website. I don?t know I need an URL parameter, Form parameters, non or both.
With only the database I used NONE and it works. I think I have to use FORM
parameters for the form I use and because I need the X"YZ information later.
5. You are right about the table you describe.
6. I give you the table information in code and more
7. I give you the form information in code. In this page I need to have the
following information (1. Y coordinates) type of the mobile but I have the
IDmobiel so I can find it en (2. X coordinates) the subscription so I know what
subscription they want to have and (3. Z figure) the cross of the XY is what
they selected and that?s they amount of money they have to pay.
8. In the form they can select the present colors and other things which go to
Access and a part to the contract
9. (At that moment there can be a special offer so that is what I also have
registrate at that moment. When this afterwards will modify in my database than
it might not modify in the order. But that?s an other problem!!
10. I think my greatest problem is that I cannot find the good buttons in
DW2004MX because the overwrite the existing code. When I am at the window
screen ?Parameters? I cannot add a new one because the existing code is not
there.

Thanxx a lot Jan




The page with the table KPN hi new buy 1 year subscription (dutch:
KPNhiNK1jaar)
I am sorry I used dutch names!!

<!-- InstanceBeginEditable name="inhoud" -->
<div id="inhoud" style="position:absolute; left:157px; top:53px; width:850px;
height:585px; z-index:4; overflow: scroll;">
<table width="795" border="0" cellspacing="0" cellpadding="1">
<tr>
<td nowrap>&nbsp;</td>
<td>Abonnementen /KPN hi / aanbod 1 jarig nieuw</td>
<td>&nbsp;</td>
<td nowrap>&nbsp;</td>
</tr>
<tr>
<td width="10" nowrap><p>&nbsp;</p>
<p>&nbsp;</p></td>
<td class="Tabelkop">Abonnementaanbod KPN hi (1 jarig nieuw abonnement)
</td>
<td><div align="right"></div></td>
<td width="10" nowrap><img src="images/logos/KPN-HI.gif" alt="KPN hi
logo" width="40" height="40" border="3" align="middle"
class="darkredborder"></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><table width="450" border="1" cellspacing="1" cellpadding="1">
<tr bgcolor="#f3dde0">
<th width="68" nowrap scope="col">Abonnement</th>
<th width="250" nowrap scope="col">Uw voordeel </th>
</tr>
<%
While ((Repeat2__numRows <> 0) AND (NOT ABTbellen.EOF))
%>
<tr>
<td><%=(ABTbellen.Fields.Item("ABTnaamBellen").Val ue)%></td>
<td><%=(ABTbellen.Fields.Item("ToelichtingABT").Va lue)%></td>
</tr>
<%
Repeat2__index=Repeat2__index+1
Repeat2__numRows=Repeat2__numRows-1
ABTbellen.MoveNext()
Wend
%>

</table></td>
<td><span class="Tabelkop"><img src="images/logos/herco%20logo.GIF"
alt="Promotion" width="154" height="114"></span></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2">t</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2" class="Tabelkop">Aanbod op toestellen GSM4all (1 jarig
nieuw abonnement) </td>
<td>&nbsp;</td>
</tr>
<tr>
<td nowrap>&nbsp;</td>
<td colspan="2"><table width="100%" border="1" cellspacing="0"
cellpadding="1">
<tr bgcolor="#f3dde0">
<th width="100" nowrap scope="col"><div align="left">Merk</div></th>
<th width="100" nowrap scope="col"><div align="left">Type</div></th>
<th width="68" nowrap scope="col"> KPN hi 15 </th>
<th width="68" nowrap scope="col">KPN hi 20 </th>
<th width="68" nowrap scope="col">KPN hi 25</th>
<th width="68" nowrap scope="col">KPN hi 30 </th>
<th width="68" nowrap scope="col">KPN hi 40 </th>
<th width="68" nowrap scope="col">KPN hi 50 </th>
<th width="68" nowrap scope="col">KPN hi 80 </th>
<th width="68" nowrap scope="col">KPN hi 100 </th>
</tr>
<%
While ((Repeat1__numRows <> 0) AND (NOT kpnhikn1jaar.EOF))
%>
<tr>
<td><div
align="left"><%=(kpnhikn1jaar.Fields.Item("Merk"). Value)%></div></td>
<td><div
align="left"><%=(kpnhikn1jaar.Fields.Item("TypeMob ").Value)%></div></td>
<td class="navTable"><div align="center"><A
HREF="kpnhi-bestel-KN1jaar.asp?<%= Server.HTMLEncode(MM_keepNone) &
MM_joinChar(MM_keepNone) & "IdMobiel=" &
kpnhikn1jaar.Fields.Item("IdMobiel").Value
%>"><%=(kpnhikn1jaar.Fields.Item("KPN Hi ? 15").Value)%></A></div></td>
<td class="navTable"><div align="center"><A
HREF="kpnhi-bestel-KN1jaar.asp?<%= Server.HTMLEncode(MM_keepNone) &
MM_joinChar(MM_keepNone) & "IdMobiel=" &
kpnhikn1jaar.Fields.Item("IdMobiel").Value
%>"><%=(kpnhikn1jaar.Fields.Item("KPN Hi ? 20").Value)%></A></div></td>
<td class="navTable"><div align="center"><a
href="kpnhi-bestel-KN1jaar.asp?<%= Server.HTMLEncode(MM_keepNone) &
MM_joinChar(MM_keepNone) & "IdMobiel=" &
kpnhikn1jaar.Fields.Item("IdMobiel").Value
%>"><%=(kpnhikn1jaar.Fields.Item("KPN Hi ? 25").Value)%></a></div></td>
<td class="navTable"><div align="center"><a
href="kpnhi-bestel-KN1jaar.asp?<%= Server.HTMLEncode(MM_keepNone) &
MM_joinChar(MM_keepNone) & "IdMobiel=" &
kpnhikn1jaar.Fields.Item("IdMobiel").Value
%>"><%=(kpnhikn1jaar.Fields.Item("KPN Hi ? 30").Value)%></a></div></td>
<td class="navTable"><div align="center"><a
href="kpnhi-bestel-KN1jaar.asp?<%= Server.HTMLEncode(MM_keepNone) &
MM_joinChar(MM_keepNone) & "IdMobiel=" &
kpnhikn1jaar.Fields.Item("IdMobiel").Value
%>"><%=(kpnhikn1jaar.Fields.Item("KPN Hi ? 40").Value)%></a></div></td>
<td class="navTable"><div align="center"><A
HREF="/kpnhi-bestel-KN1jaar.asp?<%= Server.HTMLEncode(MM_keepNone) &
MM_joinChar(MM_keepNone) & "IdMobiel=" &
kpnhikn1jaar.Fields.Item("IdMobiel").Value
%>"><%=(kpnhikn1jaar.Fields.Item("KPN Hi ? 50").Value)%></A></div></td>
<td class="navTable"><div align="center"><A
HREF="/kpnhi-bestel-KN1jaar.asp?<%= Server.HTMLEncode(MM_keepNone) &
MM_joinChar(MM_keepNone) & "IdMobiel=" &
kpnhikn1jaar.Fields.Item("IdMobiel").Value
%>"><%=(kpnhikn1jaar.Fields.Item("KPN Hi ? 80").Value)%></A></div></td>
<td class="navTable"><div align="center"><A
HREF="/debitelkpn-bestel-KN1jaar.asp?<%= Server.HTMLEncode(MM_keepNone) &
MM_joinChar(MM_keepNone) & "IdMobiel=" &
kpnhikn1jaar.Fields.Item("IdMobiel").Value
%>"><%=(kpnhikn1jaar.Fields.Item("KPN Hi ? 100").Value)%></A></div></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
kpnhikn1jaar.MoveNext()
Wend
%>

</table></td>
<td>&nbsp;</td>
</tr>
<tr>
<td width="10" nowrap>&nbsp;</td>
<td colspan="2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
<p>&nbsp;</p>
</div>
<!-- InstanceEndEditable -->
<div id="bottum" style="position:absolute; left:-9px; top:621px; width:1010px;
height:17px; z-index:5; background-color: #666666; border: 1px none #000000;
visibility: visible;">
<div align="center" class="style1">&copy; 2005 GSM4al - <a
href="Contactinformatie.asp">Contactinformatie</a> - <a
href="algemenevoorwaarden.asp" class="witteletters">Algemenevoorwaarde</a></div>
</div>
</body>
<!-- InstanceEnd --></html>
<%
kpnhikn1jaar.Close()
Set kpnhikn1jaar = Nothing
%>
<%
ABTbellen.Close()
Set ABTbellen = Nothing
%>




The second page the order form KPN hi order new buy 1 year subscription
(Dutch: kpnhibestelkn1jaar)

<!-- InstanceBeginEditable name="Persgeg" --><!-- InstanceEndEditable --><!--
InstanceBeginEditable name="inhoud" -->
<div id="inhoud" style="position:absolute; left:150px; top:53px; width:810px;
height:575px; z-index:4; overflow: visible;">
<table width="840" border="0" cellspacing="0" cellpadding="1">
<tr>
<td colspan="2">frame /</td>
<td width="295" rowspan="3" class="Tabelkop"><div
align="right">logo</div></td>
</tr>
<tr>
<td colspan="2" class="Tabelkop">&nbsp;</td>
</tr>
<tr>
<td width="354" class="Tabelkop">Bestelling KPN hi nieuw 1 jarig
abonnement<br>
met <%=(kpnhink1jaar.Fields.Item("Merk").Value)%> -
<%=(kpnhink1jaar.Fields.Item("TypeMob").Value)%> </td>
<td width="185">Klik hier voor abonnementsadvies </td>
</tr>
<tr>
<td><form action="<%=MM_editAction%>" method="POST" name="formaanvraag"
id="formaanvraag" onSubmit="return check()">
<table border="0" align="center" cellpadding="0" cellspacing="0">
<tr valign="baseline">
<td nowrap align="right">Partzak:</td>
<td><select name="Partzak" class="general">
<option value="" selected></option>
<option value="Particulier" >Particulier</option>
<option value="Zakelijk" >Zakelijk</option>
</select>
</

[dischord13]

Ok, Jan. Here is my solution.

I would start clean on a new page and let Dreamweaver create the code.

Master Page:
1. Insert your table grid on the Master page.
2. Create a link in each of your Subscription columns.
3. In the link dialog, click the parameters button + to add your parameters
MobileID and/or name (click the lighning bolt and link to recordset)
Cost (link to recordset)
SubscriptionName (manually type the name of the column as the value)
Any other variables you want to pass
This method makes them all URL parameters. You can use any parameter type you
want but this is the easiest way.

Detail Page:
1. In your Detail page, in the "Bindings" panel click the + button and choose
Request variable
2. Choose the type "Request.QueryString"
3. Type the name EXACTLY as it was passed in your parameter. In this case
"Cost"
4. Select the text field in your form for Cost and click the lighning bolt in
the "init val" section in the properties window.
5. Select the request variable you created for "Cost"
6. Now your Cost textfield in the form will have the value of whatever the
user selected. Repeat this and create more Request Variables for
"SubscriptionName" and "mobile" and all of your other fields you want to get
from the master page.

Now to make your form update the database when you hit "Submit"

1. Select the form, and click the "Server Behaviors" tab
2. Click the + button and select "Insert Record"
3. Select your connection, then select the form elements and which columns
they will update.
4. Add a submit button to the form (dreamweaver has standard submit buttons)

If you have any complex code that you want to keep, you should create a new
post on this forum and ask if anyone knows ASP VBscript. I don't know anything
about that, but I'm sure someone can help you copy and paste. Otherwise, try to
use Dreamweaver as much as you can. It can create a lot of code for you and
most times you don't have to write any at all.

That's it! Let me know if you need me to explain further. Hope that helps.
Good luck.


James

[snuif12]

Hello James,

Something is change in my planning so I tried. Thanks for your fast reaction.

I see the following problem in the text

?Cost (Link to recordset)
SubscriptionName (manually type the name of the colomn as the value)?

That?s in my table the same colomn, so I have done

Name ?????????Value
Click lighningbolt????. Cost

When I selected the table I get the message:\

HTTP 404 - Bestand niet gevonden
Internet Information Services

It means Didn?t found database

I hope You can tell me what I am doing wrong!!!!

Note: Maybe you can send me your codes because it seems you are try out this
model


Here are the codes masterpage


Here are the codes masterpage

-- InstanceBeginEditable name="inhoud" -->
<div id="inhoud" style="position:absolute; left:150px; top:53px; width:810px;
height:575px; z-index:4; overflow: visible;">
<table width="795" border="1" cellspacing="1" cellpadding="1">
<tr>
<td>&nbsp;</td>
<td>abonnementen / KPN hi /Verleng Koop 2 jaar </td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>Aanbod mobielen </td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td><table width="100%" border="1" cellspacing="1" cellpadding="1">
<tr bgcolor="#f3dde0">
<th nowrap scope="col"><div align="left">Merk</div></th>
<th nowrap scope="col"><div align="left">Type</div></th>
<th nowrap scope="col"> KPN hi 15 </th>
<th nowrap scope="col">KPN hi 20 </th>
<th nowrap scope="col">KPN hi 25</th>
<th nowrap scope="col">KPN hi 30 </th>
<th nowrap scope="col">KPN hi 40 </th>
<th nowrap scope="col">KPN hi 50 </th>
<th nowrap scope="col">KPN hi 80 </th>
<th nowrap scope="col">KPN hi 100 </th>
</tr>
<%
While ((Repeat1__numRows <> 0) AND (NOT MatrixKPNhiVK2jaar.EOF))
%>
<tr>
<td><div
align="center"><%=(MatrixKPNhiVK2jaar.Fields.Item( "Merk").Value)%></div></td>
<td><div
align="center"><%=(MatrixKPNhiVK2jaar.Fields.Item( "TypeMob").Value)%></div></td>
<td class="navTable"><div align="center"><a
href="/kpnhiBestelKV2jaar.asp?<%=(MatrixKPNhiVK2jaar.Fiel ds.Item("IdMobiel").Val
ue)%>=id&<%=(MatrixKPNhiVK2jaar.Fields.Item("KPN Hi ?
15").Value)%>=Cost"><%=(MatrixKPNhiVK2jaar.Fields. Item("KPN Hi ?
15").Value)%></a></div></td>
<td><div align="center" class="navTable"><a
href="/kpnhiBestelKV2jaar.asp?<%=(MatrixKPNhiVK2jaar.Fiel ds.Item("IdMobiel").Val
ue)%>=id&<%=(MatrixKPNhiVK2jaar.Fields.Item("KPN Hi ?
20").Value)%>=Cost"><%=(MatrixKPNhiVK2jaar.Fields. Item("KPN Hi ?
20").Value)%></a></div></td>
<td><div align="center"><a
href="/kpnhiBestelKV2jaar.asp"></a></div></td>
<td><div align="center"><a
href="/kpnhiBestelKV2jaar.asp"></a></div></td>
<td><div align="center"><a
href="/kpnhiBestelKV2jaar.asp"></a></div></td>
<td><div align="center"><a
href="/kpnhiBestelKV2jaar.asp"></a></div></td>
<td><div align="center"><a
href="/kpnhiBestelKV2jaar.asp"></a></div></td>
<td><div align="center"><a
href="/kpnhiBestelKV2jaar.asp"></a></div></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
MatrixKPNhiVK2jaar.MoveNext()
Wend
%>

</table></td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
</div>
<!-- InstanceEndEditable -->


Here are the codes detailpage

<!-- InstanceBeginEditable name="Persgeg" --><!-- InstanceEndEditable --><!--
InstanceBeginEditable name="inhoud" -->
<div id="inhoud" style="position:absolute; left:150px; top:53px; width:810px;
height:575px; z-index:4; overflow: visible;">
<table width="840" border="0" cellspacing="0" cellpadding="1">
<tr>
<td colspan="2">frame /</td>
<td width="295" rowspan="3" class="Tabelkop"><div
align="right">logo</div></td>
</tr>
<tr>
<td colspan="2" class="Tabelkop">&nbsp;</td>
</tr>
<tr>
<td width="354" class="Tabelkop">Bestelling KPN hi nieuw 1 jarig
abonnement<br>
met - </td>
<td width="185">Klik hier voor abonnementsadvies </td>
</tr>
<tr>
<td><p>&nbsp;</p>
<form method="POST" action="<%=MM_editAction%>" name="form1">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">ABTaanbod:</td>
<td><input type="text" name="ABTaanbod" value="<%=
Request.QueryString("Cost") %>" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">&nbsp;</td>
<td><input type="submit" value="Insert record">
</td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
</form>
<p>&nbsp;</p></td>
<td>&nbsp;</td>
<td><p>&nbsp;</p>
</td>
</tr>
</table>
<p>&nbsp;</p>
</div>
<!-- In

[dischord13]

Not sure why you got that message. The link dialog box should be the easy part!
I made a crude test of this and I did not have any problems on my page. I used
dummy names for the mobiles.

Here's my code. Maybe you can figure out what the difference is.



'***************************************** MASTER PAGE
****************************

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/MasterDetailTest.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_MasterDetailTest_STRING
Recordset1.Source = "SELECT * FROM Subscriptions"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = 10
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<br>
<table width="772" border="1" cellspacing="5" cellpadding="5">
<tr>
<th width="181" height="75" scope="row"><div
align="center">Mobiles</div></th>
<td width="172"><div align="center">Sub1Name</div></td>
<td width="171"><div align="center">Sub2Name</div></td>
<td width="173"><div align="center">Sub3Name</div></td>
</tr>
</table>
<br>

<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>
<table width="772" border="1" cellspacing="5" cellpadding="5">
<tr>
<th width="181" height="75"
scope="row"><%=(Recordset1.Fields.Item("MobileName ").Value)%></th>
<td width="150"><a
href="Detail.asp?SubscriptionName=Sub1Name&MobileN ame=<%=(Recordset1.Fields.Item
("MobileName").Value)%>&Cost=<%=(Recordset1.Fields .Item("Subscription1").Value)%

>"><%=(Recordset1.Fields.Item("Subscription1").Val ue)%></a></td>

<td width="172"><a
href="Detail.asp?SubscriptionName=Sub2Name&MobileN ame=<%=(Recordset1.Fields.Item
("MobileName").Value)%>&Cost=<%=(Recordset1.Fields .Item("Subscription2").Value)%

>"><%=(Recordset1.Fields.Item("Subscription2").Val ue)%></a></td>

<td width="172"><a
href="Detail.asp?SubscriptionName=Sub3Name&MobileN ame=<%=(Recordset1.Fields.Item
("MobileName").Value)%>&Cost=<%=(Recordset1.Fields .Item("Subscription3").Value)%

>"><%=(Recordset1.Fields.Item("Subscription3").Val ue)%></a></td>

</tr>
</table>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>

</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>


'***************************************** DETAIL PAGE
****************************

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/MasterDetailTest.asp" -->
<%
' *** Edit Operations: declare variables

Dim MM_editAction
Dim MM_abortEdit
Dim MM_editQuery
Dim MM_editCmd

Dim MM_editConnection
Dim MM_editTable
Dim MM_editRedirectUrl
Dim MM_editColumn
Dim MM_recordId

Dim MM_fieldsStr
Dim MM_columnsStr
Dim MM_fields
Dim MM_columns
Dim MM_typeArray
Dim MM_formVal
Dim MM_delim
Dim MM_altVal
Dim MM_emptyVal
Dim MM_i

MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
If (Request.QueryString <> "") Then
MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)
End If

' boolean to abort record edit
MM_abortEdit = false

' query string to execute
MM_editQuery = ""
%>
<%
' *** Insert Record: set variables

If (CStr(Request("MM_insert")) = "form1") Then

MM_editConnection = MM_Holland_STRING
MM_editTable = "Subscriptions"
MM_editRedirectUrl = ""
MM_fieldsStr = "textfield|value|textfield2|value"
MM_columnsStr = "Subscription1|none,none,NULL|MobileName|',none,'' "

' create the MM_fields and MM_columns arrays
MM_fields = Split(MM_fieldsStr, "|")
MM_columns = Split(MM_columnsStr, "|")

' set the form values
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i)))
Next

' append the query string to the redirect URL
If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then
If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And
Request.QueryString <> "") Then
MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
Else
MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
End If
End If

End If
%>
<%
' *** Insert Record: construct a sql insert statement and execute it

Dim MM_tableValues
Dim MM_dbValues

If (CStr(Request("MM_insert")) <> "") Then

' create the sql insert statement
MM_tableValues = ""
MM_dbValues = ""
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_formVal = MM_fields(MM_i+1)
MM_typeArray = Split(MM_columns(MM_i+1),",")
MM_delim = MM_typeArray(0)
If (MM_delim = "none") Then MM_delim = ""
MM_altVal = MM_typeArray(1)
If (MM_altVal = "none") Then MM_altVal = ""
MM_emptyVal = MM_typeArray(2)
If (MM_emptyVal = "none") Then MM_emptyVal = ""
If (MM_formVal = "") Then
MM_formVal = MM_emptyVal
Else
If (MM_altVal <> "") Then
MM_formVal = MM_altVal
ElseIf (MM_delim = "'") Then ' escape quotes
MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'"
Else
MM_formVal = MM_delim + MM_formVal + MM_delim
End If
End If
If (MM_i <> LBound(MM_fields)) Then
MM_tableValues = MM_tableValues & ","
MM_dbValues = MM_dbValues & ","
End If
MM_tableValues = MM_tableValues & MM_columns(MM_i)
MM_dbValues = MM_dbValues & MM_formVal
Next
MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ")
values (" & MM_dbValues & ")"

If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close

If (MM_editRedirectUrl <> "") Then
Response.Redirect(MM_editRedirectUrl)
End If
End If

End If
%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form name="form1" method="POST" action="<%=MM_editAction%>">
<p>
<input name="textfield" type="text" value="<%= Request.QueryString("Cost")
%>">
</p>
<p>
<input name="textfield2" type="text" value="<%=
Request.QueryString("MobileName") %>">
</p>
<p> <input name="textfield3" type="text" value="<%=
Request.QueryString("SubscriptionName") %>">
</p>
<input type="hidden" name="MM_insert" value="form1">
<input type="submit" name="Submit" value="Submit">
</form>
</body>
</html>

[snuif12]

Hello James,

I am started a new simply database but I have tried a lot today. I didn't
succeed.

Is there a pssibility to get your compleet trial version?

I don't know but thats the way to know all my misunderstandings.

Thanks for your assistend!!!!!!

Jan

[snuif12]

Hello James,

My new site gives the next mistake

Soort fout:
Compilatiefout Microsoft VBScript (0x800A0411)
Naam is opnieuw gedefinieerd (Eng: Name is once more defined)
/verzameling/Connections/connverzameling.asp, line 8, column 4
Dim MM_connverzameling_STRING
Soort browser: (Eng: Kind of browser)
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

Pagina: (Eng: Page)
GET /verzameling/thanks.asp

Tijd:
zaterdag 23 april 2005, 21:44:20

It enough for today. I wait for reaction tomorrow maybe it helps and I some
new ideas!!

Good evening and thanks

Jan

[dischord13]

Don't you love Dreamweaver's wierd errors? That's how it is.

I set you an e-mail with some files. It is a very simple example and I'm sure
your's is much more complex but maybe it will give you some ideas.

I learned this stuff from a book "Dreamweaver MX 2004 Demystified." I think
it's the best one out there. You might want to check it out.

Not sure about the error. Depends on exactly when you are getting the error.
Sometimes Dreamweaver is just crazy and I restart my computer and it works
beautifully.

Let me know if the e-mail came through.
James

[dischord13]

My e-mail is not working. Is your e-mail address "jan.vandesande@gmail.com?"

[snuif12]

Hello James,

Yes my email is [email]jan.vandesande@gmail.com[/email] and another is
[email]jan.vandesande@hccnet.nl[/email]

I go to look for the book and still some other possibilities because I
discover that the error is not from the master but from the detailpage. When
the detailpage is gone he ask for it.

thanxx

I send a message about the progress I made

[snuif12]

hello James,

Thanks a lot for helping me. I succeed in making your proposal and it works.

I am very glad now because I invest I think 60-80 hours in it.
My last problem was very small as always.
I control it and again and again and again. You know how it is I think!

Thanxx.

Jan