Classic ASP, Trouble with fields.value

[Joe Resudek]

running code like:

for each ofield in rs.fields
response.write ofield.value
next

Getting and error that says TYPE MISMATCH. I KNOW that value is a correct
type, right???

Using SQlserver

--
Joe Resudek
Frontier New Media
225 Crummer Lane
Reno, NV 89509
(775) 824-4040
(775) 824-4044 fax
[url]http://www.thefrontiergroup.com[/url]

[John Beschler]

I just copied your code into and asp page on my dev box,
added the code for the connection objects and ran it. It
works fine. There must be something you've left out.

Exactly which line is failing?

>-----Original Message-----
>running code like:
>
>for each ofield in rs.fields
> response.write ofield.value
>next
>
>Getting and error that says TYPE MISMATCH. I KNOW that

value is a correct

>type, right???
>
>Using SQlserver
>
>--
>Joe Resudek
>Frontier New Media
>225 Crummer Lane
>Reno, NV 89509
>(775) 824-4040
>(775) 824-4044 fax
>[url]http://www.thefrontiergroup.com[/url]
>
>
>.
>

[John Blessing]

"Joe Resudek" <joe@thefrontiergroup.com> wrote in message
news:eAXB%23JTVDHA.3232@tk2msftngp13.phx.gbl...

> running code like:
>
> for each ofield in rs.fields
> response.write ofield.value
> next
>
> Getting and error that says TYPE MISMATCH. I KNOW that value is a correct
> type, right???
>
> Using SQlserver
>
> --
> Joe Resudek
> Frontier New Media
> 225 Crummer Lane
> Reno, NV 89509
> (775) 824-4040
> (775) 824-4044 fax
> [url]http://www.thefrontiergroup.com[/url]
>
>

On the assumption they are char fields, you might have some nulls,
concatenating with an empty string will sort it.


for each ofield in rs.fields
response.write "" & ofield.value
next

If they are not char fields, test for null first.



--
John Blessing
[url]http://www.LbeHelpdesk.com[/url] - Help Desk software at affordable prices
[url]http://www.free-helpdesk.com[/url] - Completely free help desk software !
[url]http://www.lbetoolbox.com[/url] - Remove Duplicates from MS Outlook
[url]http://www.lbesync.com[/url] - Synchronize two Outlook Personal Folders

[Joe Resudek]

I will bet money that this is the issue, the first field is not a char
field. I'll test it and change the code, thanks.


--
Joe Resudek
Frontier New Media
225 Crummer Lane
Reno, NV 89509
(775) 824-4040
(775) 824-4044 fax
[url]http://www.thefrontiergroup.com[/url]
"John Blessing" <ntlnews@**REMOVETHIS**lbehelpdesk.com> wrote in message
news:1zeVa.3865$G85.715@newsfep4-winn.server.ntli.net...

> "Joe Resudek" <joe@thefrontiergroup.com> wrote in message
> news:eAXB%23JTVDHA.3232@tk2msftngp13.phx.gbl...

> > running code like:
> >
> > for each ofield in rs.fields
> > response.write ofield.value
> > next
> >
> > Getting and error that says TYPE MISMATCH. I KNOW that value is a

correct

> > type, right???
> >
> > Using SQlserver
> >
> > --
> > Joe Resudek
> > Frontier New Media
> > 225 Crummer Lane
> > Reno, NV 89509
> > (775) 824-4040
> > (775) 824-4044 fax
> > [url]http://www.thefrontiergroup.com[/url]
> >
> >

>
> On the assumption they are char fields, you might have some nulls,
> concatenating with an empty string will sort it.
>
>
> for each ofield in rs.fields
> response.write "" & ofield.value
> next
>
> If they are not char fields, test for null first.
>
>
>
> --
> John Blessing
> [url]http://www.LbeHelpdesk.com[/url] - Help Desk software at affordable prices
> [url]http://www.free-helpdesk.com[/url] - Completely free help desk software !
> [url]http://www.lbetoolbox.com[/url] - Remove Duplicates from MS Outlook
> [url]http://www.lbesync.com[/url] - Synchronize two Outlook Personal Folders
>

[Manohar Kamath [MVP]]

Try this:

response.write ofield.value & vbNullString

I am guessing some fields have Null values.

--
Manohar Kamath
Editor, .netBooks
[url]www.dotnetbooks.com[/url]


"Joe Resudek" <joe@thefrontiergroup.com> wrote in message
news:eAXB%23JTVDHA.3232@tk2msftngp13.phx.gbl...

> running code like:
>
> for each ofield in rs.fields
> response.write ofield.value
> next
>
> Getting and error that says TYPE MISMATCH. I KNOW that value is a correct
> type, right???
>
> Using SQlserver
>
> --
> Joe Resudek
> Frontier New Media
> 225 Crummer Lane
> Reno, NV 89509
> (775) 824-4040
> (775) 824-4044 fax
> [url]http://www.thefrontiergroup.com[/url]
>
>