Referencing a data item from DRW elsewhere in a page

[Guest]

I am using the DRW to return a single data item from a SQL database and need
to use that value elsewhere on my webpage.

Is it possible to reference this value using a variable name?

I tried acutally putting the DRW form at the location where I need the data,
but it does not behave correctly.

Any help would be greatly appreciated.

 

[MD Websunlimited]

You can use JavaScript to access the containing table cell, etc.

 

[Guest]

Can you give me a hint on what the JavaScript would be? I don't know Java
and need to get this figured out soon. I admit it is something I need to
study, but is not in my regular field of expertise.

 

[Stefan B Rusynko]

Find the field name used by the DBRW in the DBR region
Say fp_rs("somefieldname")
In Code view right after it (but in the DBR region) add an ASP variable
<% myfield = fp_rs("somefieldname") %>

Then refer to it later in the page as
<%=myfield%>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I am using the DRW to return a single data item from a SQL database and need
| to use that value elsewhere on my webpage.
|
| Is it possible to reference this value using a variable name?
|
| I tried acutally putting the DRW form at the location where I need the data,
| but it does not behave correctly.
|
| Any help would be greatly appreciated.

 

[Guest]

Thanks!
That worked great.