Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1] 2
1
Web Server - Ask For Help / How to store wholemessage email in MSSQL
« on: December 03, 2012, 12:26:22 PM »
I want to save my nettalk wholemessage in a mssql . I use the datatype varchar(max) (in the dct blob) , but when i save my record i get a file system errorif self.WholeMessage <> ''
! This code runs each time an email is downloaded. Here we are simply
! storing the WholeMessage property, which we need to use later (below)
! to load the email into the FileExplorer control.
TempLong = self.WholeMessageLen
if TempLong
pTempString &= new (string(TempLong))
pTempString = self.WholeMessage
end
if ~pTempString &= null
ema:WholeMessage[0: TempLong - 1] = pTempString
dispose (pTempString)
end
end
2
Web Server - Ask For Help / Planner / Calender time range and name of day
« on: July 26, 2011, 01:17:40 PM »
Hi Bruce,
A customer asks me
- Can you put the name of the days in the planner (before the date)
- Can you limit the time range e.g. 7 - 6 pm and calculate the width of the column (appointments) against it?
Is this possible?
Best regards,
Walter
A customer asks me
- Can you put the name of the days in the planner (before the date)
- Can you limit the time range e.g. 7 - 6 pm and calculate the width of the column (appointments) against it?
Is this possible?
Best regards,
Walter
3
Web Server - Ask For Help / Popup validation screws browse control in planner
« on: April 18, 2011, 01:06:49 PM »
Hi Bruce and all,
I attached a modified example of hotdates (12) (c9056/ nt5.22) . It took me some days to find the error because it was in a total different place then i expected.
My planning page consists of three controls: date entry, netwebyear planner control and a browse of orders to be scheduled.
The Sabra example uses updappointment1 . The only difference with updappointment is a validation of the field keu:order. If i use popup validation, the change button in the bnt_KeuringenUNplanned (updkeuring) does not work anymore: a total different control and table?! Also , the planner is not refreshed (have to press F5) if i validate in popup mode.
The second strange thing is the width of the days. I copied the procedures, they are identical .
Best regards,
Walter
The Netherlands
[attachment deleted by admin]
I attached a modified example of hotdates (12) (c9056/ nt5.22) . It took me some days to find the error because it was in a total different place then i expected.
My planning page consists of three controls: date entry, netwebyear planner control and a browse of orders to be scheduled.
The Sabra example uses updappointment1 . The only difference with updappointment is a validation of the field keu:order. If i use popup validation, the change button in the bnt_KeuringenUNplanned (updkeuring) does not work anymore: a total different control and table?! Also , the planner is not refreshed (have to press F5) if i validate in popup mode.
The second strange thing is the width of the days. I copied the procedures, they are identical .
Best regards,
Walter
The Netherlands
[attachment deleted by admin]
4
Web Server - Ask For Help / Netwebyear Calender TakeAccepted embed
« on: April 07, 2011, 12:52:27 AM »
Bruce,
I added a netwebyear calender (month 1) which i use as a control on the planning_form. I want to pich a date , store in a session value and then reset the planner browse which i also added as a control on the planning_form.
Which embed must i use (click on a date, set session value) ,e.g. like takeaccepted?
walter
I added a netwebyear calender (month 1) which i use as a control on the planning_form. I want to pich a date , store in a session value and then reset the planner browse which i also added as a control on the planning_form.
Which embed must i use (click on a date, set session value) ,e.g. like takeaccepted?
walter
5
Web Server - Ask For Help / Planner (netwebyear) questions update form does not show
« on: April 06, 2011, 09:56:43 PM »
Hi Bruce,
I strongled today with the planner. The example (web12) runs fine but in my own app the update form did not show up.
Because off a bug in former versions of NT5 , i disabled the popup options in the global extension. I restored it to default and that solved my problem. I have to test the rest of the app I all runs smoothly.
I have these questions (includes questions asked earlier today):
1. I also want to show a table of unplanned tasks, but there is no place to enter a control (browseunplanned) . I want to create a table below the planner browse.
2. Set width of the planner browse to full or qty pics.
3. How to set a bold font in the description field (cell )
4. Set the time scope e.g. from 6:00 am to 6 pm . The cell width has to be calculated against the time scope (so the cell gets wider). I now have to set a huge pix for a readable cell content.
5. I also want a date picker on the screen. The option ‘start with’ is now set to today() so you are limited to the number of days ahead to plan.
Best regards,
Walter / The Netherlands
I strongled today with the planner. The example (web12) runs fine but in my own app the update form did not show up.
Because off a bug in former versions of NT5 , i disabled the popup options in the global extension. I restored it to default and that solved my problem. I have to test the rest of the app I all runs smoothly.
I have these questions (includes questions asked earlier today):
1. I also want to show a table of unplanned tasks, but there is no place to enter a control (browseunplanned) . I want to create a table below the planner browse.
2. Set width of the planner browse to full or qty pics.
3. How to set a bold font in the description field (cell )
4. Set the time scope e.g. from 6:00 am to 6 pm . The cell width has to be calculated against the time scope (so the cell gets wider). I now have to set a huge pix for a readable cell content.
5. I also want a date picker on the screen. The option ‘start with’ is now set to today() so you are limited to the number of days ahead to plan.
Best regards,
Walter / The Netherlands
6
Web Server - Ask For Help / Javascript scheduler dhtmlxScheduler how to start?
« on: February 22, 2011, 02:46:14 PM »
Hi all
I started with the javascript dhtmlxScheduler . The folder structure is
Codebase \ dhtmlxscheduler.js
\ dhtmlxscheduler.css
\connector \connector.js
\*.php
\ext \small .js files
\imgs
1) In nt the default scripts folder is ‘scripts’. Should I copy all the js files in this folder or is it best to keep the js in the codebase folder.? And how must I add this in NT script entry?
2) In the example there is a file 02_units_view.html. If I open this in the browser, the scheduler opens and runs. Should I call this page directly as a hard page in NT or must I create a NT source page e.g.?
3) See http://dhtmlx.com/docs/products/dhtmlxScheduler/sample_basic.html. You can download the code there.
Best regards,
Walter
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<head>
<meta http-equiv="Content-type" content="text/html; charset=utf-8">
<title></title>
</head>
<script src="../../codebase/dhtmlxscheduler.js" type="text/javascript" charset="utf-8"></script>
<script src="../../codebase/ext/dhtmlxscheduler_units.js" type="text/javascript" charset="utf-8"></script>
<link rel="stylesheet" href="../../codebase/dhtmlxscheduler.css" type="text/css" title="no title" charset="utf-8">
<script src="../../codebase/ext/dhtmlxscheduler_collision.js" type="text/javascript" charset="utf-8"></script>
<style type="text/css" media="screen">
html, body{
margin:0px;
padding:0px;
height:100%;
overflow:hidden;
}
</style>
<script type="text/javascript" charset="utf-8">
function init() {
var sections=[
{key:1, label:"Section A"},
{key:2, label:"Section B"},
{key:3, label:"Section C"},
{key:4, label:"Section D"}
];
scheduler.locale.labels.unit_tab = "Unit"
scheduler.locale.labels.section_custom="Section";
scheduler.config.details_on_create=true;
scheduler.config.details_on_dblclick=true;
scheduler.config.xml_date="%Y-%m-%d %H:%i";
scheduler.config.lightbox.sections=[
{name:"description", height:130, map_to:"text", type:"textarea" , focus:true},
{name:"custom", height:23, type:"select", options:sections, map_to:"section_id" },
{name:"time", height:72, type:"time", map_to:"auto"}
]
scheduler.createUnitsView({
name:"unit",
property:"section_id",
list:sections
});
scheduler.config.multi_day = true;
scheduler.init('scheduler_here',new Date(2009,5,30),"unit");
scheduler.load("../common/units.xml");
}
</script>
<body onload="init();">
<div id="scheduler_here" class="dhx_cal_container" style='width:100%; height:100%;'>
<div class="dhx_cal_navline">
<div class="dhx_cal_prev_button"> </div>
<div class="dhx_cal_next_button"> </div>
<div class="dhx_cal_today_button"></div>
<div class="dhx_cal_date"></div>
<div class="dhx_cal_tab" name="day_tab" style="right:204px;"></div>
<div class="dhx_cal_tab" name="week_tab" style="right:140px;"></div>
<div class="dhx_cal_tab" name="unit_tab" style="right:280px;"></div>
<div class="dhx_cal_tab" name="month_tab" style="right:76px;"></div>
</div>
<div class="dhx_cal_header">
</div>
<div class="dhx_cal_data">
</div>
</div>
</body>
I started with the javascript dhtmlxScheduler . The folder structure is
Codebase \ dhtmlxscheduler.js
\ dhtmlxscheduler.css
\connector \connector.js
\*.php
\ext \small .js files
\imgs
1) In nt the default scripts folder is ‘scripts’. Should I copy all the js files in this folder or is it best to keep the js in the codebase folder.? And how must I add this in NT script entry?
2) In the example there is a file 02_units_view.html. If I open this in the browser, the scheduler opens and runs. Should I call this page directly as a hard page in NT or must I create a NT source page e.g.?
3) See http://dhtmlx.com/docs/products/dhtmlxScheduler/sample_basic.html. You can download the code there.
Best regards,
Walter
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<head>
<meta http-equiv="Content-type" content="text/html; charset=utf-8">
<title></title>
</head>
<script src="../../codebase/dhtmlxscheduler.js" type="text/javascript" charset="utf-8"></script>
<script src="../../codebase/ext/dhtmlxscheduler_units.js" type="text/javascript" charset="utf-8"></script>
<link rel="stylesheet" href="../../codebase/dhtmlxscheduler.css" type="text/css" title="no title" charset="utf-8">
<script src="../../codebase/ext/dhtmlxscheduler_collision.js" type="text/javascript" charset="utf-8"></script>
<style type="text/css" media="screen">
html, body{
margin:0px;
padding:0px;
height:100%;
overflow:hidden;
}
</style>
<script type="text/javascript" charset="utf-8">
function init() {
var sections=[
{key:1, label:"Section A"},
{key:2, label:"Section B"},
{key:3, label:"Section C"},
{key:4, label:"Section D"}
];
scheduler.locale.labels.unit_tab = "Unit"
scheduler.locale.labels.section_custom="Section";
scheduler.config.details_on_create=true;
scheduler.config.details_on_dblclick=true;
scheduler.config.xml_date="%Y-%m-%d %H:%i";
scheduler.config.lightbox.sections=[
{name:"description", height:130, map_to:"text", type:"textarea" , focus:true},
{name:"custom", height:23, type:"select", options:sections, map_to:"section_id" },
{name:"time", height:72, type:"time", map_to:"auto"}
]
scheduler.createUnitsView({
name:"unit",
property:"section_id",
list:sections
});
scheduler.config.multi_day = true;
scheduler.init('scheduler_here',new Date(2009,5,30),"unit");
scheduler.load("../common/units.xml");
}
</script>
<body onload="init();">
<div id="scheduler_here" class="dhx_cal_container" style='width:100%; height:100%;'>
<div class="dhx_cal_navline">
<div class="dhx_cal_prev_button"> </div>
<div class="dhx_cal_next_button"> </div>
<div class="dhx_cal_today_button"></div>
<div class="dhx_cal_date"></div>
<div class="dhx_cal_tab" name="day_tab" style="right:204px;"></div>
<div class="dhx_cal_tab" name="week_tab" style="right:140px;"></div>
<div class="dhx_cal_tab" name="unit_tab" style="right:280px;"></div>
<div class="dhx_cal_tab" name="month_tab" style="right:76px;"></div>
</div>
<div class="dhx_cal_header">
</div>
<div class="dhx_cal_data">
</div>
</div>
</body>
7
Web Server - Ask For Help / Servedocument in netform embed
« on: January 25, 2011, 01:25:59 PM »
In the postupdate embed of my netwebform i create a pdf report. Based on the condition SendByPost = true i want to show this pdf in a new page in the browser. I have the servedocument procedure working , but thats based on clicking a download button in a browse.
How can i do this on the server side ?
Best regards,
Walter
How can i do this on the server side ?
Best regards,
Walter
8
Web Server - Ask For Help / Browse filtered status 10 > change record status 20 > return > no recs in browse
« on: January 25, 2011, 01:12:43 PM »
Hi,
I have a browse that is filtered on status =10. When i update a record (form) and change it to 20 , the browse returns with no records found. I want to return to the browse filled with status= 10 records . At the moment i use a refresh button .
Best Regards,
Walter
,The Netherlands
I have a browse that is filtered on status =10. When i update a record (form) and change it to 20 , the browse returns with no records found. I want to return to the browse filled with status= 10 records . At the moment i use a refresh button .
Best Regards,
Walter
,The Netherlands
9
Web Server - Ask For Help / hide - show button in browse if calling from parent x or y
« on: January 14, 2011, 12:39:11 AM »
Hi all,
I have a browse with a 'sendpdf' button in each row. This button only must appear is the parent that is embedding the browse is 'Y') (loc:parent).
How can this be done?
Cheers,
Walter , the Netherlands
I have a browse with a 'sendpdf' button in each row. This button only must appear is the parent that is embedding the browse is 'Y') (loc:parent).
How can this be done?
Cheers,
Walter , the Netherlands
10
Web Server - Ask For Help / browse refresh after change (status of record changed)
« on: January 06, 2011, 02:18:50 PM »
Hi folks,
I have several forms with the same browse control on it. The browse has several filter conditions : calling form and status = 'fixed value' (CAN BE 0 , 10 , 20)
When a change a record from the browsecontrol and change the status (filter value) of that record from 0 to 10 and save the record, the browse does not show any more records. For the moment a have a button 'refresh' that resets the browse , but that should happen automatically.
What can be done to safe the act filter in a session variable and 'return' to the browse with that filter?
Best regards,
Walter
I have several forms with the same browse control on it. The browse has several filter conditions : calling form and status = 'fixed value' (CAN BE 0 , 10 , 20)
When a change a record from the browsecontrol and change the status (filter value) of that record from 0 to 10 and save the record, the browse does not show any more records. For the moment a have a button 'refresh' that resets the browse , but that should happen automatically.
What can be done to safe the act filter in a session variable and 'return' to the browse with that filter?
Best regards,
Walter
11
Web Server - Ask For Help / prototype netwebsource with additional parameters
« on: December 30, 2010, 11:43:02 AM »
Hi folks,
Started as a normal clarion source procedure i prototyped it with (long recordsysid, long sessionid).
I now have to access the p_web object because i have to store a var (result of email process) in a <!-- Net:v:Variable --> tag
if a prototype the procedure as ( NetWebServerWorker p_web, long recordsysid) i get compile errors in the webhandler procedure (processtag).
Is this possible or must i change to a session value for the recordsysid ?
Best regards,
Walter The netherlands
Started as a normal clarion source procedure i prototyped it with (long recordsysid, long sessionid).
I now have to access the p_web object because i have to store a var (result of email process) in a <!-- Net:v:Variable --> tag
if a prototype the procedure as ( NetWebServerWorker p_web, long recordsysid) i get compile errors in the webhandler procedure (processtag).
Is this possible or must i change to a session value for the recordsysid ?
Best regards,
Walter The netherlands
12
Web Server - Share Knowledge / Creating a control record - form
« on: December 28, 2010, 12:32:55 PM »
Hi All,
For me a control record typically is a (tps) file with just one record and has all kind off control field and settings e.g. the name of the smtp server. I took me some time to access the record from a menu. My table has just one key (pksysid) with just one field (with the name ID) which has the value of 1 The prefix of the file is WBC (web control)
- create a form , use the pksysid key as access key
- In the menupoint call the form with the URL e.g. 'UpdWebconfig?&wbc__id=1&Change_btn=Change&'
- &wbc__id=1 tells the form to retrieve the record by fetching the record with wbc:id=1
- &Change_btn=Change& tells to call the form in change mode
Unfortunaly this did not work for me and i want to share my mistakes with you!
In the dct :
- I did not tick the primary key and require unique value option ON (i leave the other ones unticked)
- I used a byte for the ID field
Then in the form:
- i changed the default action from 'change' to none (Change_btn) does the work (?)
After these changes it worked.
to get the first record into the table i use the
'before menu item 'embed of the 'configure'menu option.
! config record check
wbc:id = 1
if access:webconfig.fetch(wbc:pksysid)
P_WEB._TRACE('Error getting config record'& errorcode() )
wbc:id = 1
access:webconfig.insert()
end
I can't see that the file is opened actualy but is works (abc access: opens it readonly??))
Maybe someone else can answer this last question .
Best Regards,
Walter van der Horst
The Netherlands
For me a control record typically is a (tps) file with just one record and has all kind off control field and settings e.g. the name of the smtp server. I took me some time to access the record from a menu. My table has just one key (pksysid) with just one field (with the name ID) which has the value of 1 The prefix of the file is WBC (web control)
- create a form , use the pksysid key as access key
- In the menupoint call the form with the URL e.g. 'UpdWebconfig?&wbc__id=1&Change_btn=Change&'
- &wbc__id=1 tells the form to retrieve the record by fetching the record with wbc:id=1
- &Change_btn=Change& tells to call the form in change mode
Unfortunaly this did not work for me and i want to share my mistakes with you!
In the dct :
- I did not tick the primary key and require unique value option ON (i leave the other ones unticked)
- I used a byte for the ID field
Then in the form:
- i changed the default action from 'change' to none (Change_btn) does the work (?)
After these changes it worked.
to get the first record into the table i use the
'before menu item 'embed of the 'configure'menu option.
! config record check
wbc:id = 1
if access:webconfig.fetch(wbc:pksysid)
P_WEB._TRACE('Error getting config record'& errorcode() )
wbc:id = 1
access:webconfig.insert()
end
I can't see that the file is opened actualy but is works (abc access: opens it readonly??))
Maybe someone else can answer this last question .
Best Regards,
Walter van der Horst
The Netherlands
13
Web Server - Ask For Help / When to tick send new value to server
« on: December 21, 2010, 01:04:30 PM »
I'm serious confused on when to tick this value on and when to use add server code. Do i have to tick send new value IF i have code attached?
The reason for asking this is that i have two drop fields and two browses on a memory file driven form and that the reset functions do not work (anymore) , although i see that e.g. the browse receives a new filter (session value). Also hide and unhide the second drop field (condition p_web.gsv('sv_filter') <> 'C' ) does not work (anymore)
5.06 / 90.56
Cheers Walter
The reason for asking this is that i have two drop fields and two browses on a memory file driven form and that the reset functions do not work (anymore) , although i see that e.g. the browse receives a new filter (session value). Also hide and unhide the second drop field (condition p_web.gsv('sv_filter') <> 'C' ) does not work (anymore)
5.06 / 90.56
Cheers Walter
14
Web Server - Ask For Help / Drop filter - table entry does not stay selected
« on: December 20, 2010, 03:54:52 PM »
Hi all,
I have a drop table and a browse on a netwebform (memory). I want to select a department from the droptable and filter the job browse .
Drop table: loc:dropfilter (string 255) , value field : dep:cd (string 6) .
1) if I select e.g. entry three, the selection does not stay on entry 3 but defaults to the first entry!
- Value field is dep:cd, order - dep:cd
I do not reset any controls and have no embed code . I checked the examples
Any ideas
c 90.56 - 5.06
Best regards
Walter
I have a drop table and a browse on a netwebform (memory). I want to select a department from the droptable and filter the job browse .
Drop table: loc:dropfilter (string 255) , value field : dep:cd (string 6) .
1) if I select e.g. entry three, the selection does not stay on entry 3 but defaults to the first entry!
- Value field is dep:cd, order - dep:cd
I do not reset any controls and have no embed code . I checked the examples
Any ideas
c 90.56 - 5.06
Best regards
Walter
15
Web Server - Ask For Help / Send Word file create PDF in batch
« on: December 15, 2010, 01:28:09 PM »
Hé guys,
I have a customer that wants to upload a msword doc and let the website create a pdf from it (instead of using all kind of different local pdf creators which give minor different results).
I know that that are web services that have this functionality but they all are asp.net or so based . I'am thinking of using Oddjob in combination with acrobat writer fired by Nettalk webserver.
Does anybody has experience with this or have good ideas how this can be done?
Best Regards,
Walter van der Horst
Sabra Systems
The Netherlands
I have a customer that wants to upload a msword doc and let the website create a pdf from it (instead of using all kind of different local pdf creators which give minor different results).
I know that that are web services that have this functionality but they all are asp.net or so based . I'am thinking of using Oddjob in combination with acrobat writer fired by Nettalk webserver.
Does anybody has experience with this or have good ideas how this can be done?
Best Regards,
Walter van der Horst
Sabra Systems
The Netherlands
Pages: [1] 2