This topic is locked

checkbox in list/edit when data = "+" or "-" not true/

3/21/2011 8:46:54 AM
ASPRunnerPro General questions
S
spants author

Hi
I'm trying out asprunner as I need to produce a simple addition to an existing web based application.
There are only two issues left to solve:

  1. Pulling params from the url to use within the select of records (I think I have found out how this is done but if you have any tips!)
  2. I want to use the checkbox to show in the list view and in the editing a of record. However, the datasource uses "+" and "-" for true and false. Is there a way to change what the checkbox uses?
    regards

    Tony

Sergey Kornilov admin 3/21/2011

Getting parameters from the URL is easy.
URL: somepage.asp?param=somevalue
Use Request("param") or Request.QueryString("param") to access the value of param.
Checkbox field expects values of 0 and 1. You can covert - and + to 0 and 1 and vice versa using events.

To convert data before saving to the database use BeforeEdit event: http://xlinesoft.com/asprunnerpro/docs/before_record_updated.htm

To convert data before displaying on the edit page use ProcessValues event: http://xlinesoft.com/asprunnerpro/docs/process_record_values.htm
If you need more assistance post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.

S
spants author 3/22/2011

Thanks for the reply.
for the url query: I have the following code in the Before SQL Query
'Username= Request("UserID") <= commented out
Username= "MACCLESFIELD"

strWhereClause = whereAdd(strWhereClause, "evt_mrc="&Username)
...but get a build error. The problem is the syntax here: "evt_mrc="&Username

I cant see anything the the samples that could help me - how should this be done?

regards

Tony

Sergey Kornilov admin 3/22/2011

Tony,
If you need more assistance post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.

S
spants author 3/22/2011



Tony,
If you need more assistance post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.


I get an "Unable to create database script" when I try to do so

Sergey Kornilov admin 3/22/2011

You need to find a way to send your files and database to the support team. I guess you can create database script manually or send us database backup.

S
spants author 3/24/2011

solved the first question- needed the single quotes. Now for the checkboxes!
code:
Username2= Request("UserID")

if username2<>"" then session("UserID")=Username2

strWhereClause = whereAdd(strWhereClause, "evt_mrc='"&session("UserID")&"'")
regards

Tony

Sergey Kornilov admin 3/24/2011

Tony,
how you want as to help you?