HI



I do following simple joined query with ASP/VB-script and SQL 7.0:



select * from SupportQuery_T 

Inner Join HtmlSupportQuery_T 

ON SupportQuery_T.SupportQuery_ID = HtmlSupportQuery_T.SupportQuery_FK 

where SupportQuery_ID = 86



This query works fine in SQL Server Query Analyzer - It returns/lists all

fields of the selected record.



But if I do following in my VB-Script:

------

if not RecordSet.EOF then 

	for Each x in RecordSet.Fields

	Response.Write ("<br>-->" & x.Name & " - " & x.Value & "<--")

Next



-----



I only get the field values from the first table AND the error message:





-->SupportQuery_ID - 86<--

-->Company_FK - 4<--

-->ContactClient_FK - 5<--

-->ClientType_FK - 4<--

-->ContactHelpDesk_FK - 2<--

-->SupportQueryDate_DT - 14/12/00 17:07:58<--

-->CompilerSerialNumber_FK - 1<--

-->CompilerVersion_VC - ffda<--

-->ServerOS_FK - 0<--

-->ServerOSVersion_VC - fsdfsa<--

-->RDBMS_FK - 0<--

-->RDBMSVersion_VC - fdsfasd<--

-->SQShortDescription_VC - fdsfsfdad<-- 

Microsoft OLE DB Provider for ODBC Drivers error '80040e21' 



Errors occurred 



/querix/vss/vssVBScriptClassLibrary.asp, line 3451 



Note: line 3451 is:

Response.Write ("<br>-->" & x.Name & " - " & x.Value & "<--")



Any idea about this ???? or is this simply a Microsoft Bug ???



Yours



Hubert



--- 

NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?

Visit EarthWeb for the latest in IT Management, Software Development, 

Web Development, Networking & Communications, and Hardware & Systems.  

Click on http://www.earthweb.com for FREE articles, tutorials,

and discussions from the experts.

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com