2. ASPRunnerPro General questions
  3. Errors and help please
This topic is locked

Errors and help please

 		3/14/2008 2:27:15 PM
ASPRunnerPro General questions
M
 mastermax author

In your program ASPRunner Pro 5.1 build 327 i found several erros.When you make a vacation rental project and go to preview on the screen i have all properties and when i click the property photo it goes to view.php instead of view.asp but that is ok i managed that,also in admin when i want to add new property or if i want to edit property there is no bedroom field and also bathroom field is missing but i managed that too.

My problem is when i want to add or edit property and i mark amenities checked or unchecked there is no change i can not even see them on the properties view.
Please help
Thanks
Sergey Kornilov admin 3/14/2008

You need to get ASPRunnerPro 5.2 which is the latest and greatest and don't have any of those issues.
M
 		mastermax author 3/14/2008

I just downloaded the trial version of asprunner pro 5.2 (build 403) and vacation rental is not working.When i press build the pages and i want to see them in browser i get the main login page and when i click on log in as guest it says asp error happened (error message).Real estate project works fine.

As i can see when i want to make vacation rental project those mistakes i wrote in the previous message are the same,there is no bedroom and bathroom field in edit or add property.
please check and reply me

thanks
J
 		Jane 3/21/2008

Hi,
thank you for pointing me to this bug.

We'll fix it in the next update.
To make your pages working open ListOnLoad event for properties table, find this code:

' Search By Number of Bedrooms

set rstmp2 = Server.CreateObject("ADODB.Recordset")

rstmp2.Open "SELECT Bedrooms , Count(bedrooms) as count FROM properties group by bedrooms;", dbConnection
strMenu=strMenu & "<table width=150 border=0><tr><td align=left height=20 class=blackshade><Font face=Tahoma><b>&nbsp;Search By Bedrooms</b></Font></td></tr>"

do while not rstmp2.eof

Bedrooms = Replace(rstmp2("Bedrooms")," ","+")

strMenu=strMenu & "<tr><td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=properties_list.asp?a=search&value=1&SearchFor=" & Bedrooms & "&SearchOption=Equals&SearchField=Bedrooms><Font face=Tahoma>"

strMenu=strMenu & rstmp2("Bedrooms") & " (" & rstmp2("count") & ")</font></a></td></tr>"

rstmp2.MoveNext

loop



and replace it with this one:

' Search By Number of Bedrooms

set rstmp2 = Server.CreateObject("ADODB.Recordset")

rstmp2.Open "SELECT Bedrooms , Count(bedrooms) as scount FROM properties group by bedrooms;", dbConnection
strMenu=strMenu & "<table width=150 border=0><tr><td align=left height=20 class=blackshade><Font face=Tahoma><b>&nbsp;Search By Bedrooms</b></Font></td></tr>"

do while not rstmp2.eof

Bedrooms = Replace(rstmp2("Bedrooms")," ","+")

strMenu=strMenu & "<tr><td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=properties_list.asp?a=search&value=1&SearchFor=" & Bedrooms & "&SearchOption=Equals&SearchField=Bedrooms><Font face=Tahoma>"

strMenu=strMenu & rstmp2("Bedrooms") & " (" & rstmp2("scount") & ")</font></a></td></tr>"

rstmp2.MoveNext

loop


Then rebuild your project.