how to pass multiple parameter using master/detail page set
im going crazy on this and nobody can give me adecuate answer
i want to pass three parameters using standard master/detail page set, but i want to bind data in parameter that is allready binded in page somwhere, i get errors
F1 F1 F1
help please

you can pass as many parameters as you want... just append to the querystring with the values you need...
<pre id=code><font face=courier size=2 id=code>
&lt;a href="thePage.asp?id=&lt;%=rs.fields("id".value%&gt;&date=&lt;%=rs.fields("theDate".value%&gt;"&gt;detail&lt;/a&gt;
</font id=code></pre id=code>

as you can see, after the page is the "?", then each parameter is divided by the "&", you can add as many as the next page needs...

hope that helps,

Joel Martinez

----------
Is this thing on?....

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
you can pass as many parameters as you want... just append to the querystring with the values you need...
<pre id=code><font face=courier size=2 id=code>
&lt;a href="thePage.asp?id=&lt;%=rs.fields("id".value%&gt;&date=&lt;%=rs.fields("theDate".value%&gt;"&gt;detail&lt;/a&gt;
</font id=code></pre id=code>

as you can see, after the page is the "?", then each parameter is divided by the "&", you can add as many as the next page needs...

hope that helps,

Joel Martinez

----------
Is this thing on?....
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
i have the same problem everything looks ok but i get this error
Error Type:
ADODB.Fields (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.

hmmm, that's a thinker, try setting the value of the field to a variable:
<pre id=code><font face=courier size=2 id=code>
&lt;%
id = rs.fields("id".value
thedate = rs.fields("thedate".value
%&gt;

&lt;a href="thePage.asp?id=&lt;%=id%&gt;&date=&lt;%=thedate%&gt;"&gt;detail&lt;/a&gt;
</font id=code></pre id=code>
then, the variable can be used (in the loop) instead of the recordset.

the reason I suggest this, is because I've heard somewhere of some problem with the RS losing the value after it's used once... but I don't remember where.

an added plus to this technique, is that it's faster this way.

other than that, you may want to look at the recordset... I had a problem like this once where I was getting a recordset from an adodb.connection, it didn't work until I got the recordset from an adodb.command
you can use a command instead of a recordset query (<b>Data bindings&gt;command (stored procedure)</b> but it doesn't have to be a stored proc, I think you can just build the SQL query in there...

Joel Martinez

----------
Is this thing on?....

Edited by - joelmartinez on 07/17/2001 19:55:37

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> the reason I suggest this, is because I've heard somewhere of some problem with the RS losing the value after it's used once... but I don't remember where.

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I think that was my problem, because if i used binding data for more than once i get,... well i didn't get anything<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>)
will try as u recomended me
tnks