Finally!!! (updated)

I am digging what I'm seeing so far! AWESOME! Only issue is multiple dependent dropdown feature not working? Please advise... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=7279&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />

It's impossible to help someone who says "it doesn't work".
If you need help give me more info about this issue.

It's impossible to help someone who says "it doesn't work".

Well, when I select a name from the "Contributor" dropdown, my intent is to have the dependent table-based dropdowns populate themselves from the same record ("contact1first", "contact1last" for example) but they don't populate. Maybe I'm doing something wrong in the setup?

Must be something incorrect in dropdown box setup.
Zip and send your project file long with sample database and generated ASP files to support@xlinesoft.com.

I'm going to have another go at fixing it. I'm probably doing something wrong during setup.

Hello,
the new version is going the right way. Especially the possibility to integrate source code is very good.

For a future version I would wish I could integrate special functions for a group of marked records , like

I can do it with -delete-.
I think other programmers too have a lot of internel source code to apply to a group of records.

My thougt is :

The user marks (filters) the record(s)

then he points to a menu-text (above the Table View) and the special source code will be executed,

for example to write several bills to different customers.
I myself changed the original source code of ASP-Runner 3.2 and it works great.
I wish you a happy new year an thanks for your good work.

I have several application running on ASP Runner without problems.
Sincerely

Uwe Pfeiffer

Uwe,
this sounds like nice idea.
I need to see how I can easily integrate this in existing ASPRunnerPro schema.

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=7298&image=1&table=forumreplies' class='bbc_emoticon' alt=':huh:' /> How do you know if you qualify for the free upgrade? Please tell.....Thx,

All customers who purchased ASPRunnerPro in 2005 get ASPRunnerPro 4.0 as a free upgrade.

I installed the Beta 4 version and like the new features, but didn't purchase the upgrade (yet, probably will soon!). When I went back to working with my purchased 3.2 Pro version, I get nothing but errors on my projects now! Did the Beta version interfere with 3.2? Here is what I see with my newest build (which previously worked OK):
Active Server Pages error 'ASP 0126'
Include file not found
/eps/2006HCI/NewUserReg_list.asp, line 7
The include file 'include/NewUserReg_events.asp' was not found.
Help? Thanks!

In ASPRunnerPro 4.0 you cannot use custom templates created by ASPRunnerPro 3.x.

When you build a project in ASPRunnerPro 4.0 choose default template.

Hi Sergey,

I'm playing around with the beta version and when I attempt to you the sendmail features I get the following error:
Error Type:

Microsoft VBScript compilation (0x800A0414)

Cannot use parentheses when calling a Sub

/PCServices/include/Technicians_events.asp, line 11, column 34

sendmail (email, message, subject)

---------------------------------^
Any ideas?

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=7388&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />
Abel

That was a syntax error in sample Action.
Please download latest build 67 where this problem was fixed. Make sure you clear existing event code and create a new one.

Hi Sergey, a few of ideas for you: <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=7428&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />

1. A feature that I see in many database driven softwares is the ability to create a query and save it. This becomes very useful for people that need to run the same queries regularly for reporting purposes.
   
2. Automatically audit records to track who made changes. It looks like your very close to with the events section.
   
3. Date and Time pickers
   Thanks,
   
   Abel

Yes the idea of a feature that lets you use queries as a report is a great idea that I could use! One problem I have is letting some people have access to only thier records, and others (more than one) need access to all records. For example, I have agents, managers and Directors who all have varying requirements as to what fields are available, and what records are visible. reps see just his/hers. manager see his staff, directors see all staff...
Alan

Alan,
you already can use queries for this purpose s well as assign differerent permissions to view data results
Abel,

1. you already can use custom queries in ASPRunnerPro 4.0. Use "Create Table Alias" feature for this purpose.
   
2. you can easily do this using events.
   
3. Time picker will be available later.

Yes, to a certain degree, but unless I am really struggling (maybe that is the case) I can't seem to get my head around it. Have you resolved the issue of teh views showing in the permissions section?
Maybe I just need to wait for the revised tutorial/faq? My learning curve is getting bigger as I progress...
Alan,

Alan,

1. you already can use custom queries in ASPRunnerPro 4.0. Use "Create Table Alias" feature for this purpose.
   
2. you can easily do this using events.
   
3. Time picker will be available later.

Issue with permissions on table aliases were resolved in build 78.

My idea is regarding of the updates, if you can create a button on the asprunner pro application window to check if there is any new updates for the software- this way user will update without reading the forum -

thanks-

We new release is ready we send an email to all users.
I'd rather avoid having extra buttons in ASPRunner.

Alan,

1. you already can use custom queries in ASPRunnerPro 4.0. Use "Create Table Alias" feature for this purpose.
   
2. you can easily do this using events.
   
3. Time picker will be available later.

Sergey, I don't see how a user can use "Create Table Alias"? All the user is presented with is a web page that can add, delete...search for records. Maybe I'm not seeing it.

I'm not talking about web page visitor. I'm talking about person who works with ASPRunnerPro. "Create Table Alias" button is located on Datasource tables tab in ASPRunnerPro.

Sergey, beta 40.79 is working well. I will be cutting over my projects, but everytime i bring up a new database, my boss asks for many semi-cosmetic changes. So here are some feature suggestions...
-on 'field order & totals' add ability for one 'search for' field to be the default

-add ability to change the default operand of 'contains' in 'search for' bar

-reduce size of 'export' page and centered

-add 'htm' export option because db's with lots of fields look very bad in Word format or modify the Excel export to include a little more formatting, such as the grid, and colors.

-add some basic options on Datasource/Menu section to enhance the menu size, location, associated text, images, header logo's, spacing, etc. I'm not sure about others, but I am rolling each db out as a standalone web page, and the main menu needs to be more user friendly.
That's all for now.

Even without these mods, we really do love ASPRunner and its functionality.

Paul.

Very nice job on version 4! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=7674&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
I agree with Paul about the export page - I always centre the export box, and add a 'close' button next to the 'export button - it would be good if this could be added as a default.
I'd also like to have the name of the table being exported as a page title (centred) above the box.
Thanks for all the hard work!
Pete
PS - A 'checkbox' format option for list view would be useful - unless I have missed this, all mine are shown as yes/no in list view.
Another minor request for the defaults - could we have the 'back to master table' link (on a detail page) at the top of the page above the master table, to the right of the 'Master Table: [TableName]' title.
Thanks

Pete and Paul - thank you for suggestions.
View as type Checkbox is something that we can easily implement.
Other suggestions sound like a job for Template Editor. Some people like titles centered while others prefer it to appear on the left. The same applies to menu page - it's really easy to customize it using Template Editor.

Hi,
One other suggestion is to add the ability to choose fields to appear on Master Detail table.
Thanks

GPF Problem
I've had a couple of GPFs when selecting the list 'View As' dropdown. Message says 'cannot read memory at...'
Seems to happen after I have made a load of changes, but before I save them <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=7698&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />
Any chance of an 'autosave' option, or reminder message?
Thanks
Pete

Template editor
Hi Sergey,
I have been finding that the 'copy', 'cut', 'paste' functions do not behave as expected when using right-click with mouse in the template editor. Either the cursor jumps a couple of lines, half of a selection is copied, or nothing happens. The menus work fine. I just thought it was worth mentioning.
Pete
PS Just had another error when selecting 'currency' as view type.

Include Field names/column titles at foot of column Option
This would be very useful in some cases, especially where you need to scroll down to see all records, and where totals etc are included.
Thank you
Pete

• Another useful option would be the ability to put the detail table links on the right hand side of the data columns rather than the left, as this takes some time to edit afterwards.

Pete,
any chance you can send a screenshot that explains GPF or Template Editor issues?

I am trying build 79 of 4.0 and I cannot get any searches to function.
using basic search I get an asp error
Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'SRVNAME'.

/all1/TESTALL1/DSMSC_Query_list.asp, line 767
Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; BR7; .NET CLR 1.1.4322)
Page:

GET /all1/TESTALL1/DSMSC_Query_list.asp?TargetPageNumber=1&action=Search&lang=&orderby=&dir=&PageSize=2000&masterkey=&SearchField=Analyst&SearchOption=Contains&SearchFor=shane&PageSizeSelect=10
Time:

Saturday, January 28, 2006, 9:30:15 AM
The other thing that happens is I selected to add new entries to the dropdowns. When I type a new entry and hit submit, I get a page could not be found message in the popup box

Just in case make sure you are not using templates created by older version of ASPRunnerPro.
To help me troubleshoot first error change vDebug variable in include/commonfunctions.asp file from false to true and run the same search again. Post SQL query here.

Just in case make sure you are not using templates created by older version of ASPRunnerPro.

I actually started the project from scratch. So there weren't any old pieces of code at all.
Here is the debug info.
select [Analyst], [SRVNAME], [Client Name], [Client Email], [Client Phone], [Role], [OS], [ClientContacted], [ImplementDate], [CompletedDate], [Comments], [SMSSchedule], [Latest Patch], [BCPVerified], [Managment Link], [Counter], [Log_Time], [Log_Who], [STATIC_SCH] From [dbo].[DSMSC_Query] where (upper([dbo].[DSMSC_Query].[Analyst] ) like upper('%Shane%')) SRVNAME
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'SRVNAME'.
/all1/TESTALL1/DSMSC_Query_list.asp, line 767

I fixed it. I had type in the value SRVNAME in the SQL part of the project. This time I used the button to insert the field and it worked.
I still have an issue with the edit/add new entry from the pop up and I discovered one more issue.

previously I could insert the code in the /.list file that would make my field SRVNAME a hotlink.
I replaced

<%

if IsBinaryField(rs.Fields("SRVNAME")) or Format("SRVNAME")=FORMAT_DATABASE_FILE then

Response.Write CreateImageControl(rs, "SRVNAME", "")

else

Response.Write ProcessLargeText(GetData(rs.Fields("SRVNAME"), ""))

end if

%>
with:
<%

Response.Write ProcessLargeText("<a href=""http://USGMS23CN/SMSReporting_ACN/Report.asp?ReportID=163&MachineDetails=True&ComputerName="; & GetData(rs.Fields("SRVNAME"), "") & """ target=_blank>" & GetData(rs.Fields("SRVNAME"), "") & "</a>")

%>
It no longer works with that setup. I get a partial DB displayed and in the SRVNAME column on the list I get an error
Microsoft VBScript runtime error '800a01c2'
Wrong number of arguments or invalid property assignment: 'ProcessLargeText'
/all1/TESTALL1/DSMSC_Query_list.asp, line 1182
Thanks for the help.

Do you use custom templates created by older version?
In ASPRunnerPro 4.0 ProcessLargeText function requires three parameters.

Got it. Thanks!
<%
Response.write "<a target=_blank
href=http://USGMS23CN/SMSReportingACN/Report.asp?ReportID=163&MachineDetails=True&ComputerName=" &

Server.URLEncode(GetData(rs.Fields("SRVNAME"), "")) & _

"&source=" & Server.URLEncode(GetData(rs.Fields("SRVNAME"), "")) & ">" & GetData(rs.Fields("SRVNAME"), "") & "</a>"
%>

Can we run version 4 and version 3.2 on the same machine now without a problem? I know it was an issue with previous versions. I know the templates won't crossover, just want to know if I can make changes to existing 3.2 Runner apps with 3.2 while I'm testing 4.0 or rebuilding some old ones in 4.0.

Thanks!

No, you cannot have both 4.0 and 3.2 versions on the same box at the same time.