2. ASPRunnerPro General questions
  3. ASPRunner Professional 5.2 released
This topic is locked

ASPRunner Professional 5.2 released

 		3/11/2008 18:14:29
ASPRunnerPro General questions
Sergey Kornilov admin

ASPRunnerPro 5.2 final, build 404

March 11, 2008
Download link:

http://www.asprunner.com/files/asprunnerpro-setup.zip
New features in this update:
Here is the list of new features in this update:

  • Dynamic permissions
  • Import data from CSV and Excel files
  • Resize images on upload and iBox support
  • Auto-update fields. Automatically insert a value into field every time record is updated (UpdateBy, UpdateTime, IP address of user etc)
  • Visual SQL Editor
  • Add new item to dropdown box as a fully-featured add page in popup
  • Only allow complex passwords (mixed cases, non-alphanumeric characters)
  • Registration confirmation via email
  • CAPTCHA


Screenshots:
Add new record in popup


iBox image preview


Import page


Dynamic permissions - groups setup


Dynamic permissions - assigning users to groups
D
 		dunga 3/11/2008

hi, thANK YOU FOR THE FINAL VErsion, BUT <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=26880&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
import button is missing form ANY default layouts. FOR EXAMPLE sELECT dEAFULT +lONDON, OR pARIS OR AMSTERDAM : AND YOU WILL FIND NO import button on the layout.switch to amsterdam on the upper box, and choose any from belowe and the import button appears. I think a user several days ago mentioned it before final release.

here

http://www.asprunner.com/forums/index.php?showtopic=7814
there is aPDF icon(or button) [on Choose pages screen]that does not work) or it is not known what purpose it serves?
Sergey Kornilov admin 3/12/2008

Thank you, fixed.
D
 		dunga 3/12/2008

hi, thank you, the compressed file (the zip) iz corrupted.
P
 		Philip 3/12/2008

Hi
How do I use the new feature "Auto-update fields. Automatically insert a value into field every time record is updated (UpdateBy, UpdateTime, IP address of user etc)" ?
Philip
Sergey Kornilov admin 3/12/2008

Dunga,
seems to be okay now.
Philip,
set Default value for any field and check off Apply on Edit page as well check box.
Use one of the following as default value:

Now() - update datetime

Session("UserID") - user id of person who updated the record

Request.ServerVariables("remote_addr") - IP address
T
 		Tim 3/18/2008

Philip,

set Default value for any field and check off Apply on Edit page as well check box.
Use one of the following as default value:

Now() - update datetime

Session("UserID") - user id of person who updated the record

Request.ServerVariables("remote_addr") - IP address


To follow up on Philip's question, and just so I'm clear... this is not an "audit" feature (tracking all actions by any user) but more of a "last modified by" feature. So you update the record when added or modified with who did it and when, but, if it's an edit, it over-writes the previous value. Am I correct?
Thanks,

Tim
Sergey Kornilov admin 3/19/2008

Tim,
this is correct - it works as "last updated by" feature.
If you like to track all changes you need to have a separate table for this purpose.
D
 		dunga 3/19/2008

Add new record in popup
can you guys explain where in the application I can see that option???

I am lost.
also captchas...where are they, I mean the options..
C
 		clig 4/6/2008

In SQL Server 2005 ASPRunner cannot use the sort by feature in a drop down on a search or edit page for example...
The error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
My string:
<%

strConnection = "Provider=SQLNCLI;Server=ONAPP013\NTSSVII,1776;Database=TNS_Support;Uid=xxx;Pwd=xxx;MarsConn=yes;"

' strConnection = "Provider=sqloledb;Data Source=ONAPP013\NTSSVII,1776;Initial Catalog=TNS_Support;User Id=xxx;Password=xxx;"

' strConnection = "Provider=sqloledb;Data Source=ONAPP013\NTSSVII;Initial Catalog=TNS_Support;User Id=xxx;Password=xxx;"

%>

  • anyway none of that really matter what does matter is that you can not "disable" sorting in a drop down - it renables automatically... In regards to MSSQL2005 to reliably sort it needs to be done from a view similar to:
    SELECT DISTINCT TOP (2147483647) dbo.DIALUP1.BusUnit

    FROM dbo.DIALUP1 INNER JOIN

    dbo.DataIP_Systypes ON dbo.DIALUP1.[SYS Type] = dbo.DataIP_Systypes.[SYS Type]

    ORDER BY dbo.DIALUP1.BusUnit
  • If I use this as a source for a drop down box - you cannot disable the "sort"... This was not the case in 4.0 (my current ide)
    see: http://blogs.msdn.com/queryoptteam/archive.../02/588731.aspx
    Thanks
    Steve