May 9th, 2003, 05:55 PM
|
|
|
|
Join Date: Apr 2007
Location: Seattle, WA
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Whats wrong with this block of code?
Hey, one of my clients can't retrieve an online application that we made for them, the get an error that reads as follow when they try and view it:
Quote:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'FormatNumber'
/maint/apps/application.asp, line 232
|
Here is the block of code with line 232 in it, with line 232 being the line that says " Response.Write "<tr>" & vbcrlf & _ "
Quote:
sql = "SELECT aptName, aptContact, aptPhone, aptAddy, stateAbbrev, aptCity, " & _
"aptNum, aptRent, aptMoveIn, applicationType, placePhNum, placePhOther, aptZip FROM applicantNewApt " & _
"LEFT JOIN states ON stateID = aptState " & _
"LEFT JOIN applicant ON applicant.applicantID = applicantNewApt.applicantID " & _
"LEFT JOIN applicantPlaceInfo ON applicantPlaceInfo.applicantID = applicantNewApt.applicantID " & _
"WHERE applicantNewApt.applicantID = " & applicantID & " AND presentPlace = 1"
rs.Open sql
if(rs.RecordCount > 0) Then
Response.Write "<tr>" & vbcrlf & _
"<td>" & vbcrlf & _
"<table cellpadding='0' cellspacing='0 border='0'>" & vbcrlf & _
"<tr>" & vbcrlf & _
"<td class='mainBoldText'>Member Name:</td>" & vbcrlf & _
"<td width='5' class='mainText'> </td>" & vbcrlf & _
"<td class='mainText'>" & _
stripQuote(printMemberName(rs.Fields("aptName"), rs.Fields("aptContact"), rs.Fields("aptPhone"))) & _
"</td>" & vbcrlf & _
"</tr>" & vbcrlf & _
"</table>" & Vbcrlf & _
"</td>" & vbcrlf & _
"</tr>" & vbcrlf & _
|
My developer is unreachable right now and I cant code worth crap, but does anyone see anything wrong with this? Something that I can change real quick? THANK YOU
|
Codewalkers Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
