ASPRunner forums

Capture Search information in the Audit Table

Thu, 11 Mar 2010 23:35:47 +0000

Is it possible to capture the username and what they have searched on in the audit log?

error 256 unknown column

Thu, 11 Mar 2010 20:02:04 +0000

I get the error below when forst entering one of my tables from the generated menu.

The field "date" exists in the database. Im not really sure how to go about trouble shooting this. Could any one give me an idea or two.

thanks

Steve

Error type 256
Error description Unknown column 'date' in 'field list'
URL localhost/clients/polarbear/root/time-line/time_line_list.php?
Error file C:\Documents and Settings\Steve\My Documents\web_dev\polarbear\root\time-line\include\dbconnection.php
Error line 34
SQL query SELECT `date`, date_accuracy, location, description,(SELECT count(*) FROM (SELECT `date` FROM images ) `subQuery_cnt` WHERE `subQuery_cnt`.`date`=`time_line`.`date`) as `images_cnt` ,(SELECT count(*) FROM (SELECT `date` FROM log ) `subQuery_cnt` WHERE `subQuery_cnt`.`date`=`time_line`.`date`) as `log_cnt` FROM time_line ORDER BY 1 ASC limit 0,20

Graph by passing Unique IDs

Thu, 11 Mar 2010 19:52:51 +0000

Hi All,
I have a table with 3 columns:
ID, TYPE, COUNT

I want to create a pie chart with the TYPE as the X-Axis and the Count as the content.

How do I dynamically pass the ID so that I can see the chart for that item?
How do I pass more than one IDs so that the pie chart sums the counts and does not repeat the types?

For example:

ID,TYPE,COUNT
1,SALMON,3
1,TUNA,2
1,TROUT,5
2,SALMON,8
2,TUNA,0
2,TROUT,88

I want to pass the ID and get the graph ie.
http://squamish2010.ca/FRASER/FISH_DENSITY_chart.php?ID=1
or
http://squamish2010.ca/FRASER/FISH_DENSITY_chart.php?ID=1,2,3

I want the TUNA to be listed once...not duplicated for each ID.

thanks
gordon

Trigger emails on downloading

Thu, 11 Mar 2010 17:44:08 +0000

I have a table with boxes containing file names. When the user clicks on one of the file names it automatically downloads that file to the user. That works fine. However, I would like to arrange that when a user clicks on the file name, I receive an email message telling me that a particular file has been downloaded and by whom. How can I do this?

CKEditor and CKFinder Configuration

Thu, 11 Mar 2010 16:24:51 +0000

Does anyone have any experience on how to configure CKEditor along with CKFinder with PHPRunner 5.2?

What defines active table when PHPRunner opens

Thu, 11 Mar 2010 16:17:45 +0000

I was wondering, when PHPRunner opens and you go straight to the Events section. PHPRunner is highlighting my User table in the left panel of Tables.
I have run into situations where I have had to reset the pages for User, which is a bit of a pain because I have customised some of the User pages. THerefore the reset forces me to make the changes again. Its happened twice in the last month.

I have a table called Access, which would be great if PHPRunner would open and default to Access rather than the User table. If I have to reset Access, it is not an issue as I do not have anything custom on it.

Is there some file somewhere that holds the active table information.
Ver 5.1 2503

Identify who is editing the record (record locking)

Thu, 11 Mar 2010 12:46:54 +0000

Using Record Locking, when a record is being edited by User A and User B tries to edit the same record, the message
"Record is edited by another user" appears at the top of User B's screen. No problem. Works perfectly.

One edit...how can the statement "Record is edited by another user" be changed to read,
"Record is edited by USER A", where USER A's loginID is displayed?

Cheers,
Tokyoj

Advanced select functionality

Thu, 11 Mar 2010 12:30:26 +0000

Hi,

I've got two tables in a parent - child situation.
In the form that fills the parent table I ask for a birth date in Dutch format dd-mm-yyyy.
In the form that fills the child table I show a select box with options like:

1 month
2 months
3 months
4 months
5 months

and so on.

Lets say the birth date given is:

13-10-2000

I would like achieve this kind of output in my select box:

1 month = 13-11-2000
2 months = 13-12-2000
3 months = 13-13-2000
4 months = 13-14-2000
5 months = 13-15-2000

and so on

I think I can program this but cant find the location where to add my code. Normally in own my code I could find the location where to add this kind of functionality but in the ASPrunner pro code this is harder to find.

Could you help me find my way?

Kind regards,

import problems

Thu, 11 Mar 2010 00:30:06 +0000

Hello,

I am having problems importing on a project in version 6.2. It seems to work in 6.1, but in 6.2 I get the folowing error:

Wrong number of arguments or invalid property assignment: 'rawvalues'

I know this is not very much info, but I'm not sure what other details to give. Let me know if you have questions for me.

Also, I attempted to upload this to my demo account, but that crashed ASPRunner.

Thanks,
Tim

CLOB for Oracle

Wed, 10 Mar 2010 20:14:51 +0000

Hi, how do I tell my site that the current column is a CLOB?
Since my text is quite big, strings just don't cut it.

EELGRASS, Edit record [ ID: 60227 ] <<< Record was NOT edited >>>

ociexecute() [function.ociexecute]: ORA-01704: string literal too long

thanks

gordon

ps. I tried the solution at: http://www.asprunner.com/forums/topic/10040-oracle-clob-and-phpr/page__hl__clob__fromsearch__1
but then my BLOBs stop working....there are both on the page...