2. ASPRunnerPro General questions
  3. Export/Print Selected
This topic is locked

Export/Print Selected

 		4/16/2009 4:09:02 AM
ASPRunnerPro General questions
M
 MrDerp author

I'm having issues with the "Export Selected" and "Print Selected" functions. Upon using these features, I am just presented with either a blank file (in the case of the export) or a print-out consisting of simply the column headers.
All other print and export options work fine, so the issue appears to be limited to the selective approach.
Any help would be greatly appreciated!
M
 		MrDerp author 4/16/2009

I've done some more digging and I've managed to isolate the cause of the problem. It seems that when the primary key is a char (as opposed to numeric or a varchar), there are some linking issues due to the whitespace at the end of the primary key.
Does anyone happen to know of a fix for this? Unfortunately, the database cannot be altered so I'm stuck with this datatype.
J
 		Jane 4/16/2009

Hi,
what ASPRunnerPro version do you use?

Also you can publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error and I'll try to help you.
M
 		MrDerp author 4/16/2009

Thanks for your reply, Jane.
This probably isn't the most elegant solution, but if I change the following line of code in commonfunctions.asp it seems to fix the problem for me (but I'm unsure whether it will affect other parts of the system):
From:

SafeURLEncode = replace(server.urlencode(CStr(str)),"+","%20")
To:

SafeURLEncode = replace(server.urlencode(CStr(str)),"+","")
Is this URL encoding needed or, as I've done above, can I live without it?
Also, do you know of a way of doing this through ASPRunner (so I don't have to manually edit commonfunctions.asp)?
FYI, I'm using v6.0.
M
 		MrDerp author 4/22/2009

Jane,
I am using an evaluation of ASPRunner so presumably that's why I can't post the project to a demo account. I'm also connecting to an Informix DB, which would make it difficult for me to give you access to the data anyway.
Before purchasing this software, I really need to know if there is a fix for this. It seems that the printing and exporting problems are all caused by the fact my ID field has a char datatype and the majority of records end with trailing whitespace.
When looking at the HTML source, it seems that the ID field isn't always trailing with the URL encoded '%20', e.g.

<A href="foo_list.asp?mastertable=informix%2Ebar&masterkey1=P00001066%20%20%20%20%20%20%20%20%20" id="master_foo13">Extended</A></TD>

<TD class=borderbody vAlign=middle align=middle >P00001066 </TD>


Any ideas?
Sergey Kornilov admin 4/22/2009

I'm not sure what is the problem with the last snippet as only URLs need to be encoded. Probably you provide access to your website so I can what exactly is happening and how to fix this.
PS. to make commonfunctions.asp changes permanent modify file C:\Program files\ASPRunnerPro6.0\source\include\commonfunctions.asp