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 outputScript error detected at line 61.
Source line: response.write(RS("Name"))
Description: Type mismatch: 'Response.Write'
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
Feb 4 2006, 04:44 AM

Quote
0.0132sec
0.27
6 queries
GZIP Disabled