Recordset elements failing to write to page

[Greg Hurlman]

I've got what I'm sure is a very simple problem. In an ASP page, I am trying
to write out 4 fields from a recordset in succession:

Response.Write rs("LastName")
Response.Write rs("Suffix")
Response.Write rs("FirstName")
Response.Write rs("MiddleInitial")

All fields are populated and are single terms. I would expect
"LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test record) to
be written out on the page. However, all I get is "LastNameSuffix"
(UserIII). If I move the FirstName and/or MiddleInitial to be written
first, I get "TestAUserIII".

What is the deal?

Please respond to the group, but email is ok too, just switch the username
and domain name in the address.

Thanks,
Greg

[Greg Hurlman]

I've got what I'm sure is a very simple problem. In an ASP page, I am trying
to write out 4 fields from a recordset in succession:

Response.Write rs("LastName")
Response.Write rs("Suffix")
Response.Write rs("FirstName")
Response.Write rs("MiddleInitial")

All fields are populated and are single terms. I would expect
"LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test record) to
be written out on the page. However, all I get is "LastNameSuffix"
(UserIII). If I move the FirstName and/or MiddleInitial to be written
first, I get "TestAUserIII".

What is the deal?

Please respond to the group, but email is ok too, just switch the username
and domain name in the address.

Thanks,
Greg

[Bob Barrows]

Are any Memo fields involved? This sounds like the bug described here:
[url]http://www.aspfaq.com/show.asp?id=2188[/url]

Greg Hurlman wrote:

> I've got what I'm sure is a very simple problem. In an ASP page, I am
> trying to write out 4 fields from a recordset in succession:
>
> Response.Write rs("LastName")
> Response.Write rs("Suffix")
> Response.Write rs("FirstName")
> Response.Write rs("MiddleInitial")
>
> All fields are populated and are single terms. I would expect
> "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test
> record) to be written out on the page. However, all I get is
> "LastNameSuffix" (UserIII). If I move the FirstName and/or
> MiddleInitial to be written first, I get "TestAUserIII".
>
> What is the deal?
>
> Please respond to the group, but email is ok too, just switch the
> username and domain name in the address.
>
> Thanks,
> Greg

[Bob Barrows]

Are any Memo fields involved? This sounds like the bug described here:
[url]http://www.aspfaq.com/show.asp?id=2188[/url]

Greg Hurlman wrote:

> I've got what I'm sure is a very simple problem. In an ASP page, I am
> trying to write out 4 fields from a recordset in succession:
>
> Response.Write rs("LastName")
> Response.Write rs("Suffix")
> Response.Write rs("FirstName")
> Response.Write rs("MiddleInitial")
>
> All fields are populated and are single terms. I would expect
> "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test
> record) to be written out on the page. However, all I get is
> "LastNameSuffix" (UserIII). If I move the FirstName and/or
> MiddleInitial to be written first, I get "TestAUserIII".
>
> What is the deal?
>
> Please respond to the group, but email is ok too, just switch the
> username and domain name in the address.
>
> Thanks,
> Greg

[Greg Hurlman]

Sadly, no... the field definitions are these (from a SQL 2000 DB):

FirstName - varchar 50
MiddleInitial - char 1
LastName - varchar 50
Suffix - varchar 10

Thanks,
Greg

"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:%2314Ra9hcDHA.3044@TK2MSFTNGP11.phx.gbl...

> Are any Memo fields involved? This sounds like the bug described here:
> [url]http://www.aspfaq.com/show.asp?id=2188[/url]
>
> Greg Hurlman wrote:

> > I've got what I'm sure is a very simple problem. In an ASP page, I am
> > trying to write out 4 fields from a recordset in succession:
> >
> > Response.Write rs("LastName")
> > Response.Write rs("Suffix")
> > Response.Write rs("FirstName")
> > Response.Write rs("MiddleInitial")
> >
> > All fields are populated and are single terms. I would expect
> > "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test
> > record) to be written out on the page. However, all I get is
> > "LastNameSuffix" (UserIII). If I move the FirstName and/or
> > MiddleInitial to be written first, I get "TestAUserIII".
> >
> > What is the deal?
> >
> > Please respond to the group, but email is ok too, just switch the
> > username and domain name in the address.
> >
> > Thanks,
> > Greg

>
>

[Greg Hurlman]

Sadly, no... the field definitions are these (from a SQL 2000 DB):

FirstName - varchar 50
MiddleInitial - char 1
LastName - varchar 50
Suffix - varchar 10

Thanks,
Greg

"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:%2314Ra9hcDHA.3044@TK2MSFTNGP11.phx.gbl...

> Are any Memo fields involved? This sounds like the bug described here:
> [url]http://www.aspfaq.com/show.asp?id=2188[/url]
>
> Greg Hurlman wrote:

> > I've got what I'm sure is a very simple problem. In an ASP page, I am
> > trying to write out 4 fields from a recordset in succession:
> >
> > Response.Write rs("LastName")
> > Response.Write rs("Suffix")
> > Response.Write rs("FirstName")
> > Response.Write rs("MiddleInitial")
> >
> > All fields are populated and are single terms. I would expect
> > "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test
> > record) to be written out on the page. However, all I get is
> > "LastNameSuffix" (UserIII). If I move the FirstName and/or
> > MiddleInitial to be written first, I get "TestAUserIII".
> >
> > What is the deal?
> >
> > Please respond to the group, but email is ok too, just switch the
> > username and domain name in the address.
> >
> > Thanks,
> > Greg

>
>

[Aaron Bertrand - MVP]

Show your code.


"Greg Hurlman" <squaretwo@ghurlman.net> wrote in message
news:el#906hcDHA.300@TK2MSFTNGP12.phx.gbl...

> I've got what I'm sure is a very simple problem. In an ASP page, I am

trying

> to write out 4 fields from a recordset in succession:
>
> Response.Write rs("LastName")
> Response.Write rs("Suffix")
> Response.Write rs("FirstName")
> Response.Write rs("MiddleInitial")
>
> All fields are populated and are single terms. I would expect
> "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test record)

to

> be written out on the page. However, all I get is "LastNameSuffix"
> (UserIII). If I move the FirstName and/or MiddleInitial to be written
> first, I get "TestAUserIII".
>
> What is the deal?
>
> Please respond to the group, but email is ok too, just switch the username
> and domain name in the address.
>
> Thanks,
> Greg
>
>

[Aaron Bertrand - MVP]

Show your code.


"Greg Hurlman" <squaretwo@ghurlman.net> wrote in message
news:el#906hcDHA.300@TK2MSFTNGP12.phx.gbl...

> I've got what I'm sure is a very simple problem. In an ASP page, I am

trying

> to write out 4 fields from a recordset in succession:
>
> Response.Write rs("LastName")
> Response.Write rs("Suffix")
> Response.Write rs("FirstName")
> Response.Write rs("MiddleInitial")
>
> All fields are populated and are single terms. I would expect
> "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test record)

to

> be written out on the page. However, all I get is "LastNameSuffix"
> (UserIII). If I move the FirstName and/or MiddleInitial to be written
> first, I get "TestAUserIII".
>
> What is the deal?
>
> Please respond to the group, but email is ok too, just switch the username
> and domain name in the address.
>
> Thanks,
> Greg
>
>

[Ray at]

What's in your View-Source?

Also, try

Response.Write Server.HTMLEncode(rs.Fields.Item(0).Value)
Response.Write Server.HTMLEncode(rs.Fields.Item(1).Value)
Response.Write Server.HTMLEncode(rs.Fields.Item(2).Value)
Response.Write Server.HTMLEncode(rs.Fields.Item(3).Value)

What does that yield?

Ray at work




"Greg Hurlman" <squaretwo@ghurlman.net> wrote in message
news:el%23906hcDHA.300@TK2MSFTNGP12.phx.gbl...

> I've got what I'm sure is a very simple problem. In an ASP page, I am

trying

> to write out 4 fields from a recordset in succession:
>
> Response.Write rs("LastName")
> Response.Write rs("Suffix")
> Response.Write rs("FirstName")
> Response.Write rs("MiddleInitial")
>
> All fields are populated and are single terms. I would expect
> "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test record)

to

> be written out on the page. However, all I get is "LastNameSuffix"
> (UserIII). If I move the FirstName and/or MiddleInitial to be written
> first, I get "TestAUserIII".
>
> What is the deal?
>
> Please respond to the group, but email is ok too, just switch the username
> and domain name in the address.
>
> Thanks,
> Greg
>
>

[Ray at]

What's in your View-Source?

Also, try

Response.Write Server.HTMLEncode(rs.Fields.Item(0).Value)
Response.Write Server.HTMLEncode(rs.Fields.Item(1).Value)
Response.Write Server.HTMLEncode(rs.Fields.Item(2).Value)
Response.Write Server.HTMLEncode(rs.Fields.Item(3).Value)

What does that yield?

Ray at work




"Greg Hurlman" <squaretwo@ghurlman.net> wrote in message
news:el%23906hcDHA.300@TK2MSFTNGP12.phx.gbl...

> I've got what I'm sure is a very simple problem. In an ASP page, I am

trying

> to write out 4 fields from a recordset in succession:
>
> Response.Write rs("LastName")
> Response.Write rs("Suffix")
> Response.Write rs("FirstName")
> Response.Write rs("MiddleInitial")
>
> All fields are populated and are single terms. I would expect
> "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test record)

to

> be written out on the page. However, all I get is "LastNameSuffix"
> (UserIII). If I move the FirstName and/or MiddleInitial to be written
> first, I get "TestAUserIII".
>
> What is the deal?
>
> Please respond to the group, but email is ok too, just switch the username
> and domain name in the address.
>
> Thanks,
> Greg
>
>

[jason kennedy]

you're not using any conditional statements or trying to write out the
recordset data more than once?
could be your choice of recordset cursor

jason

"Greg Hurlman" <squaretwo@ghurlman.net> wrote in message
news:uwyF$$hcDHA.3068@TK2MSFTNGP11.phx.gbl...

> Sadly, no... the field definitions are these (from a SQL 2000 DB):
>
> FirstName - varchar 50
> MiddleInitial - char 1
> LastName - varchar 50
> Suffix - varchar 10
>
> Thanks,
> Greg
>
> "Bob Barrows" <reb_01501@yahoo.com> wrote in message
> news:%2314Ra9hcDHA.3044@TK2MSFTNGP11.phx.gbl...

> > Are any Memo fields involved? This sounds like the bug described here:
> > [url]http://www.aspfaq.com/show.asp?id=2188[/url]
> >
> > Greg Hurlman wrote:

> > > I've got what I'm sure is a very simple problem. In an ASP page, I am
> > > trying to write out 4 fields from a recordset in succession:
> > >
> > > Response.Write rs("LastName")
> > > Response.Write rs("Suffix")
> > > Response.Write rs("FirstName")
> > > Response.Write rs("MiddleInitial")
> > >
> > > All fields are populated and are single terms. I would expect
> > > "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test
> > > record) to be written out on the page. However, all I get is
> > > "LastNameSuffix" (UserIII). If I move the FirstName and/or
> > > MiddleInitial to be written first, I get "TestAUserIII".
> > >
> > > What is the deal?
> > >
> > > Please respond to the group, but email is ok too, just switch the
> > > username and domain name in the address.
> > >
> > > Thanks,
> > > Greg

> >
> >

>
>

[jason kennedy]

you're not using any conditional statements or trying to write out the
recordset data more than once?
could be your choice of recordset cursor

jason

"Greg Hurlman" <squaretwo@ghurlman.net> wrote in message
news:uwyF$$hcDHA.3068@TK2MSFTNGP11.phx.gbl...

> Sadly, no... the field definitions are these (from a SQL 2000 DB):
>
> FirstName - varchar 50
> MiddleInitial - char 1
> LastName - varchar 50
> Suffix - varchar 10
>
> Thanks,
> Greg
>
> "Bob Barrows" <reb_01501@yahoo.com> wrote in message
> news:%2314Ra9hcDHA.3044@TK2MSFTNGP11.phx.gbl...

> > Are any Memo fields involved? This sounds like the bug described here:
> > [url]http://www.aspfaq.com/show.asp?id=2188[/url]
> >
> > Greg Hurlman wrote:

> > > I've got what I'm sure is a very simple problem. In an ASP page, I am
> > > trying to write out 4 fields from a recordset in succession:
> > >
> > > Response.Write rs("LastName")
> > > Response.Write rs("Suffix")
> > > Response.Write rs("FirstName")
> > > Response.Write rs("MiddleInitial")
> > >
> > > All fields are populated and are single terms. I would expect
> > > "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test
> > > record) to be written out on the page. However, all I get is
> > > "LastNameSuffix" (UserIII). If I move the FirstName and/or
> > > MiddleInitial to be written first, I get "TestAUserIII".
> > >
> > > What is the deal?
> > >
> > > Please respond to the group, but email is ok too, just switch the
> > > username and domain name in the address.
> > >
> > > Thanks,
> > > Greg

> >
> >

>
>

[Bob Barrows]

You're going to have to give us more to go on. Show us the connection string
for your connection object (censor the user info of course) and the code
used to open your recordset.

Are you using ODBC or the native SQL OLEDB provider (recommended)?

FWIW, I've never experienced this problem.

Bob Barrows

Greg Hurlman wrote:

> Sadly, no... the field definitions are these (from a SQL 2000 DB):
>
> FirstName - varchar 50
> MiddleInitial - char 1
> LastName - varchar 50
> Suffix - varchar 10
>
> Thanks,
> Greg
>
> "Bob Barrows" <reb_01501@yahoo.com> wrote in message
> news:%2314Ra9hcDHA.3044@TK2MSFTNGP11.phx.gbl...

>> Are any Memo fields involved? This sounds like the bug described
>> here: [url]http://www.aspfaq.com/show.asp?id=2188[/url]
>>
>> Greg Hurlman wrote:

>>> I've got what I'm sure is a very simple problem. In an ASP page, I
>>> am trying to write out 4 fields from a recordset in succession:
>>>
>>> Response.Write rs("LastName")
>>> Response.Write rs("Suffix")
>>> Response.Write rs("FirstName")
>>> Response.Write rs("MiddleInitial")
>>>
>>> All fields are populated and are single terms. I would expect
>>> "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test
>>> record) to be written out on the page. However, all I get is
>>> "LastNameSuffix" (UserIII). If I move the FirstName and/or
>>> MiddleInitial to be written first, I get "TestAUserIII".
>>>
>>> What is the deal?
>>>
>>> Please respond to the group, but email is ok too, just switch the
>>> username and domain name in the address.
>>>
>>> Thanks,
>>> Greg

[Bob Barrows]

You're going to have to give us more to go on. Show us the connection string
for your connection object (censor the user info of course) and the code
used to open your recordset.

Are you using ODBC or the native SQL OLEDB provider (recommended)?

FWIW, I've never experienced this problem.

Bob Barrows

Greg Hurlman wrote:

> Sadly, no... the field definitions are these (from a SQL 2000 DB):
>
> FirstName - varchar 50
> MiddleInitial - char 1
> LastName - varchar 50
> Suffix - varchar 10
>
> Thanks,
> Greg
>
> "Bob Barrows" <reb_01501@yahoo.com> wrote in message
> news:%2314Ra9hcDHA.3044@TK2MSFTNGP11.phx.gbl...

>> Are any Memo fields involved? This sounds like the bug described
>> here: [url]http://www.aspfaq.com/show.asp?id=2188[/url]
>>
>> Greg Hurlman wrote:

>>> I've got what I'm sure is a very simple problem. In an ASP page, I
>>> am trying to write out 4 fields from a recordset in succession:
>>>
>>> Response.Write rs("LastName")
>>> Response.Write rs("Suffix")
>>> Response.Write rs("FirstName")
>>> Response.Write rs("MiddleInitial")
>>>
>>> All fields are populated and are single terms. I would expect
>>> "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test
>>> record) to be written out on the page. However, all I get is
>>> "LastNameSuffix" (UserIII). If I move the FirstName and/or
>>> MiddleInitial to be written first, I get "TestAUserIII".
>>>
>>> What is the deal?
>>>
>>> Please respond to the group, but email is ok too, just switch the
>>> username and domain name in the address.
>>>
>>> Thanks,
>>> Greg

[Greg Hurlman]

This yields the same result.

Also, from my View->Source...

<td>
UserIII
</td>

Where User is LastName, and III is Suffix.

Thanks,
Greg

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:%23nZGhDicDHA.1872@TK2MSFTNGP12.phx.gbl...

> What's in your View-Source?
>
> Also, try
>
> Response.Write Server.HTMLEncode(rs.Fields.Item(0).Value)
> Response.Write Server.HTMLEncode(rs.Fields.Item(1).Value)
> Response.Write Server.HTMLEncode(rs.Fields.Item(2).Value)
> Response.Write Server.HTMLEncode(rs.Fields.Item(3).Value)
>
> What does that yield?
>
> Ray at work
>
>
>
>
> "Greg Hurlman" <squaretwo@ghurlman.net> wrote in message
> news:el%23906hcDHA.300@TK2MSFTNGP12.phx.gbl...

> > I've got what I'm sure is a very simple problem. In an ASP page, I am

> trying

> > to write out 4 fields from a recordset in succession:
> >
> > Response.Write rs("LastName")
> > Response.Write rs("Suffix")
> > Response.Write rs("FirstName")
> > Response.Write rs("MiddleInitial")
> >
> > All fields are populated and are single terms. I would expect
> > "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test

record)

> to

> > be written out on the page. However, all I get is "LastNameSuffix"
> > (UserIII). If I move the FirstName and/or MiddleInitial to be written
> > first, I get "TestAUserIII".
> >
> > What is the deal?
> >
> > Please respond to the group, but email is ok too, just switch the

username

> > and domain name in the address.
> >
> > Thanks,
> > Greg
> >
> >

>
>

[Greg Hurlman]

This yields the same result.

Also, from my View->Source...

<td>
UserIII
</td>

Where User is LastName, and III is Suffix.

Thanks,
Greg

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:%23nZGhDicDHA.1872@TK2MSFTNGP12.phx.gbl...

> What's in your View-Source?
>
> Also, try
>
> Response.Write Server.HTMLEncode(rs.Fields.Item(0).Value)
> Response.Write Server.HTMLEncode(rs.Fields.Item(1).Value)
> Response.Write Server.HTMLEncode(rs.Fields.Item(2).Value)
> Response.Write Server.HTMLEncode(rs.Fields.Item(3).Value)
>
> What does that yield?
>
> Ray at work
>
>
>
>
> "Greg Hurlman" <squaretwo@ghurlman.net> wrote in message
> news:el%23906hcDHA.300@TK2MSFTNGP12.phx.gbl...

> > I've got what I'm sure is a very simple problem. In an ASP page, I am

> trying

> > to write out 4 fields from a recordset in succession:
> >
> > Response.Write rs("LastName")
> > Response.Write rs("Suffix")
> > Response.Write rs("FirstName")
> > Response.Write rs("MiddleInitial")
> >
> > All fields are populated and are single terms. I would expect
> > "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test

record)

> to

> > be written out on the page. However, all I get is "LastNameSuffix"
> > (UserIII). If I move the FirstName and/or MiddleInitial to be written
> > first, I get "TestAUserIII".
> >
> > What is the deal?
> >
> > Please respond to the group, but email is ok too, just switch the

username

> > and domain name in the address.
> >
> > Thanks,
> > Greg
> >
> >

>
>

[Bob Barrows]

Create a page with just the following server-side code in it (no html
stuff). Run it and let us know if you get the same result.

Bob

Greg Hurlman wrote:

> My code:
>
> Option Explicit
> Response.Buffer = True
>
> Dim rs, ID, SQL, cn, UserID
>
> Set cn = Server.CreateObject("ADODB.Connection")
> cn.Open Application("DSN")
> SQL = "select * from RegisteredUsers where UserID='" & UserID & "'"
> Set rs = cn.Execute(SQL)
>
> Response.Write rs("FirstName")
> Response.Write rs("LastName")
> Response.Write rs("Suffix")
> Response.Write rs("MiddleInitial")
> ...
>
> I've left out HTML formatting code, but the code above represents all
> DB interaction.
>
> Thanks,
> Greg
>
>
> "Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
> news:Oxy9BDicDHA.2684@TK2MSFTNGP11.phx.gbl...

>> Show your code.
>>
>>
>> "Greg Hurlman" <squaretwo@ghurlman.net> wrote in message
>> news:el#906hcDHA.300@TK2MSFTNGP12.phx.gbl...

>>> I've got what I'm sure is a very simple problem. In an ASP page, I
>>> am trying to write out 4 fields from a recordset in succession:
>>>
>>> Response.Write rs("LastName")
>>> Response.Write rs("Suffix")
>>> Response.Write rs("FirstName")
>>> Response.Write rs("MiddleInitial")
>>>
>>> All fields are populated and are single terms. I would expect
>>> "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test
>>> record) to be written out on the page. However, all I get is
>>> "LastNameSuffix" (UserIII). If I move the FirstName and/or
>>> MiddleInitial to be written first, I get "TestAUserIII".
>>>
>>> What is the deal?
>>>
>>> Please respond to the group, but email is ok too, just switch the
>>> username and domain name in the address.
>>>
>>> Thanks,
>>> Greg

[Bob Barrows]

Create a page with just the following server-side code in it (no html
stuff). Run it and let us know if you get the same result.

Bob

Greg Hurlman wrote:

> My code:
>
> Option Explicit
> Response.Buffer = True
>
> Dim rs, ID, SQL, cn, UserID
>
> Set cn = Server.CreateObject("ADODB.Connection")
> cn.Open Application("DSN")
> SQL = "select * from RegisteredUsers where UserID='" & UserID & "'"
> Set rs = cn.Execute(SQL)
>
> Response.Write rs("FirstName")
> Response.Write rs("LastName")
> Response.Write rs("Suffix")
> Response.Write rs("MiddleInitial")
> ...
>
> I've left out HTML formatting code, but the code above represents all
> DB interaction.
>
> Thanks,
> Greg
>
>
> "Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
> news:Oxy9BDicDHA.2684@TK2MSFTNGP11.phx.gbl...

>> Show your code.
>>
>>
>> "Greg Hurlman" <squaretwo@ghurlman.net> wrote in message
>> news:el#906hcDHA.300@TK2MSFTNGP12.phx.gbl...

>>> I've got what I'm sure is a very simple problem. In an ASP page, I
>>> am trying to write out 4 fields from a recordset in succession:
>>>
>>> Response.Write rs("LastName")
>>> Response.Write rs("Suffix")
>>> Response.Write rs("FirstName")
>>> Response.Write rs("MiddleInitial")
>>>
>>> All fields are populated and are single terms. I would expect
>>> "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test
>>> record) to be written out on the page. However, all I get is
>>> "LastNameSuffix" (UserIII). If I move the FirstName and/or
>>> MiddleInitial to be written first, I get "TestAUserIII".
>>>
>>> What is the deal?
>>>
>>> Please respond to the group, but email is ok too, just switch the
>>> username and domain name in the address.
>>>
>>> Thanks,
>>> Greg

[Aaron Bertrand - MVP]

Okay, now try:

<%
set conn = CreateObject("ADODB.Connection")
conn.open "<use a connection string from [url]http://www.aspfaq.com/2126[/url], not
an ODBC DSN>"
sql = "SELECT FirstName, LastName, Suffix, MiddleInitial" & _
" FROM RegisteredUsers WHERE UserID = '" & UserID & "'"
response.write sql & "<p>"
set rs = conn.execute(sql)
if not rs.eof then
response.write rs("FirstName") & "<br>"
response.write rs("LastName") & "<br>"
response.write rs("Suffix") & "<br>"
response.write rs("MiddleInitial") & "<br>"
else
response.write "Empty RS"
end if
rs.close: set rs = nothing
conn.close: set conn = nothing
%>

Key changes: (a) use an OLE-DB connection string, not a crappy DSN, (b)
*NAME* your columns, instead of lazy SELECT *, (c) test for EOF, (d) inspect
the actual SQL statement you're running (I don't see where you populate
UserID in your script).

Also, if UserID is a string, it is poorly named, IMHO. Appended "ID"
usually indicates a numeric column. If UserID is in fact a number, then
remove the single quotes around it.



"Greg Hurlman" <squaretwo@ghurlman.net> wrote in message
news:e2EZVJicDHA.1128@tk2msftngp13.phx.gbl...

> My code:
>
> Option Explicit
> Response.Buffer = True
>
> Dim rs, ID, SQL, cn, UserID
>
> Set cn = Server.CreateObject("ADODB.Connection")
> cn.Open Application("DSN")
> SQL = "select * from RegisteredUsers where UserID='" & UserID & "'"
> Set rs = cn.Execute(SQL)
>
> Response.Write rs("FirstName")
> Response.Write rs("LastName")
> Response.Write rs("Suffix")
> Response.Write rs("MiddleInitial")
> ...
>
> I've left out HTML formatting code, but the code above represents all DB
> interaction.
>
> Thanks,
> Greg
>
>
> "Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
> news:Oxy9BDicDHA.2684@TK2MSFTNGP11.phx.gbl...

> > Show your code.
> >
> >
> > "Greg Hurlman" <squaretwo@ghurlman.net> wrote in message
> > news:el#906hcDHA.300@TK2MSFTNGP12.phx.gbl...

> > > I've got what I'm sure is a very simple problem. In an ASP page, I am

> > trying

> > > to write out 4 fields from a recordset in succession:
> > >
> > > Response.Write rs("LastName")
> > > Response.Write rs("Suffix")
> > > Response.Write rs("FirstName")
> > > Response.Write rs("MiddleInitial")
> > >
> > > All fields are populated and are single terms. I would expect
> > > "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test

> record)

> > to

> > > be written out on the page. However, all I get is "LastNameSuffix"
> > > (UserIII). If I move the FirstName and/or MiddleInitial to be written
> > > first, I get "TestAUserIII".
> > >
> > > What is the deal?
> > >
> > > Please respond to the group, but email is ok too, just switch the

> username

> > > and domain name in the address.
> > >
> > > Thanks,
> > > Greg
> > >
> > >

> >
> >

>
>

[Aaron Bertrand - MVP]

Okay, now try:

<%
set conn = CreateObject("ADODB.Connection")
conn.open "<use a connection string from [url]http://www.aspfaq.com/2126[/url], not
an ODBC DSN>"
sql = "SELECT FirstName, LastName, Suffix, MiddleInitial" & _
" FROM RegisteredUsers WHERE UserID = '" & UserID & "'"
response.write sql & "<p>"
set rs = conn.execute(sql)
if not rs.eof then
response.write rs("FirstName") & "<br>"
response.write rs("LastName") & "<br>"
response.write rs("Suffix") & "<br>"
response.write rs("MiddleInitial") & "<br>"
else
response.write "Empty RS"
end if
rs.close: set rs = nothing
conn.close: set conn = nothing
%>

Key changes: (a) use an OLE-DB connection string, not a crappy DSN, (b)
*NAME* your columns, instead of lazy SELECT *, (c) test for EOF, (d) inspect
the actual SQL statement you're running (I don't see where you populate
UserID in your script).

Also, if UserID is a string, it is poorly named, IMHO. Appended "ID"
usually indicates a numeric column. If UserID is in fact a number, then
remove the single quotes around it.



"Greg Hurlman" <squaretwo@ghurlman.net> wrote in message
news:e2EZVJicDHA.1128@tk2msftngp13.phx.gbl...

> My code:
>
> Option Explicit
> Response.Buffer = True
>
> Dim rs, ID, SQL, cn, UserID
>
> Set cn = Server.CreateObject("ADODB.Connection")
> cn.Open Application("DSN")
> SQL = "select * from RegisteredUsers where UserID='" & UserID & "'"
> Set rs = cn.Execute(SQL)
>
> Response.Write rs("FirstName")
> Response.Write rs("LastName")
> Response.Write rs("Suffix")
> Response.Write rs("MiddleInitial")
> ...
>
> I've left out HTML formatting code, but the code above represents all DB
> interaction.
>
> Thanks,
> Greg
>
>
> "Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
> news:Oxy9BDicDHA.2684@TK2MSFTNGP11.phx.gbl...

> > Show your code.
> >
> >
> > "Greg Hurlman" <squaretwo@ghurlman.net> wrote in message
> > news:el#906hcDHA.300@TK2MSFTNGP12.phx.gbl...

> > > I've got what I'm sure is a very simple problem. In an ASP page, I am

> > trying

> > > to write out 4 fields from a recordset in succession:
> > >
> > > Response.Write rs("LastName")
> > > Response.Write rs("Suffix")
> > > Response.Write rs("FirstName")
> > > Response.Write rs("MiddleInitial")
> > >
> > > All fields are populated and are single terms. I would expect
> > > "LastNameSuffixFirstNameMiddleInitial" ("UserIIITestA" in my test

> record)

> > to

> > > be written out on the page. However, all I get is "LastNameSuffix"
> > > (UserIII). If I move the FirstName and/or MiddleInitial to be written
> > > first, I get "TestAUserIII".
> > >
> > > What is the deal?
> > >
> > > Please respond to the group, but email is ok too, just switch the

> username

> > > and domain name in the address.
> > >
> > > Thanks,
> > > Greg
> > >
> > >

> >
> >

>
>