MD
Sat Jul 16 08:57:49 CDT 2005
Ooops, I forgot the conditional check being asked for.
Thanks for correcting it.
--
Mike -- FrontPage MVP '97-'02
J-Bots 2004 102 Components For FP
http://www.websunlimited.com
FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
"Stefan B Rusynko" <sbr_enjoy@hotmail.com> wrote in message news:eUvz3CfiFHA.3692@TK2MSFTNGP09.phx.gbl...
> That would write all records and fields in the record set - including empty fields
> To exclude the empty fields in each record, it would need to be modified to:
>
> do while not rs.eof
> for each oField in rs.fields
> If Not IsEmpty(rs(oField.name)) Then
> response.write oField.name & " = " & rs(oField.name) & "<br>"
> End If
> next
> rs.movenext
> loop
>
> Note:
> If there are actually fields w/ Null values the above will not catch them
> If the fields really have Null values the test would be
> If Not IsNull(rs(oField.name)) Then
>
>
> --
>
> _____________________________________________
> 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.net-sites.com/sitebuilder/newsgroups.asp
> _____________________________________________
>
>
> "MD Websunlimited" <none@none.com> wrote in message news:uW2F3heiFHA.576@tk2msftngp13.phx.gbl...
> | Hi,
> |
> | do while not rs.eof
> | for each oField in rs.fields
> | response.write oField.name & " = " & rs(oField.name) & "<br>"
> | next
> | rs.movenext
> | loop
> |
> | Will read each record from the record set, enumerate the fields within that record set and display a line with field name and
> value.
> |
> | HTH,
> |
> | --
> | Mike -- FrontPage MVP '97-'02
> | J-Bots 2004 102 Components For FP
> |
http://www.websunlimited.com
> | FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
> | Download the Trial
http://www.microsoft.com/frontpage/downloads/addin/launchupdate/download.asp
> |
> | "R Keck" <RKeck@discussions.microsoft.com> wrote in message news:E844E782-AFC4-44AE-BFC9-3BF4278B28FE@microsoft.com...
> | > I've been away from ASP and ADO/DAO for several years and my books are in
> | > storage in the next state ...
> | >
> | > I'm trying to remember some sort of recordset code so that I can not utilize
> | > the webbot database/form tool. What I want to do is display all fields from
> | > a record (about 25 fields, but on average, only 13 are used), but I want to
> | > skip null fields and write out a continuous result to a page that ONLY has
> | > field data and text identifiers for the fields WITH data, and not a bunch of
> | > wasted real estate.
> | >
> | > Some how I need to fetch the field data, determine if it's null, then do an
> | > If-then and place the field identifier text and field data on one line, or,
> | > skip and move to the next field, and so on.
> | >
> | > Make sense?
> | >
> | > The database can be SQL or .mdb (and/or sharepoint), prefer SQL/non
> | > sharepoint.
> | >
> | > Thanks
> |
> |
>
>