Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 ASP error, HELPPPP

views
     
jasonlts
post Feb 4 2006, 04:44 AM

Casual
***
Junior Member
397 posts

Joined: Jan 2003
QUOTE(gracenalec @ Feb 4 2006, 04:17 AM)
umm..i got this error:

Script error detected at line 61.
Source line: response.write(RS("Name"))
Description: Type mismatch: 'Response.Write'
*
Hi, please check whether recordset is returning any records first before Response.Write, then you will need to assign all the values into variable before outputting them ... sample of a few variables and how u check and output

Dim strName
Dim strAge
Dim strGender

If Not (RS.eof or RS.bof) Then
Name = RS("Name").Value
Age = RS("Age").Value
Gender = RS("Gender").Value
End If

........

<%=Response.write strName%>
<%=Response.write strAge%>
<%=Response.write strGender%>



Take note when u retrieve Recordset.Value as this will increase performance.

Regards smile.gif

 

Change to:
| Lo-Fi Version
0.0132sec    0.27    6 queries    GZIP Disabled
Time is now: 24th December 2025 - 02:37 AM