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.
31
Web Server - Ask For Help / Is anyone else having problems with buttons since 5.30
« on: September 19, 2011, 07:23:08 AM »
I've recently upgraded from 5.30 to 5.34, and now up to 5.36 and I've noticed that my buttons (Save, Login, Logout, etc.) have stopped working since I updated my web folder. I can click on them, but nothing happens.
If I put my old web folder back version 5.30, whilst I get the normal warning, asking me to update my web folder, my buttons all work again.
Have I missed something in these latest releases?
Regards,
Neil.
If I put my old web folder back version 5.30, whilst I get the normal warning, asking me to update my web folder, my buttons all work again.
Have I missed something in these latest releases?
Regards,
Neil.
32
The Rest - Ask For Help / Save Base64 encoded label PDF
« on: July 04, 2011, 07:47:52 AM »
Has anyone had any sucess saving PDF labels that have been produced by a SOAP server?
EG. I provide the following request:
<SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<PrintLabelRequest xmlns="http://www.parcelforce.net/ws/ship/v2">
<Authentication>
<UserName>username</UserName>
<Password>password</Password>
</Authentication>
<ShipmentNumber>AA1082805</ShipmentNumber>
<PrintFormat>PDF</PrintFormat>
</PrintLabelRequest>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
The server sends me the response:
<SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<PrintLabelReply xmlns="http://www.parcelforce.net/ws/ship/v2">
<Label>
<Data>{base 64 encoded label PDF}</Data>
</Label>
</PrintLabelReply>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
I need to save the encoded label, so that I can print it.
The question is how do I save that data to disk?
Any advice whould be very welcome.
Regards
Neil.
EG. I provide the following request:
<SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<PrintLabelRequest xmlns="http://www.parcelforce.net/ws/ship/v2">
<Authentication>
<UserName>username</UserName>
<Password>password</Password>
</Authentication>
<ShipmentNumber>AA1082805</ShipmentNumber>
<PrintFormat>PDF</PrintFormat>
</PrintLabelRequest>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
The server sends me the response:
<SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<PrintLabelReply xmlns="http://www.parcelforce.net/ws/ship/v2">
<Label>
<Data>{base 64 encoded label PDF}</Data>
</Label>
</PrintLabelReply>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
I need to save the encoded label, so that I can print it.
The question is how do I save that data to disk?
Any advice whould be very welcome.
Regards
Neil.
33
Web Server - Ask For Help / JQuery display in IE8
« on: December 09, 2010, 04:12:26 AM »
I'm running the same webserver.exe with the same web folder on 2 different machines.
When I access the 2 sites my jquery formatting of my menu and my form buttons seems to go haywire.
See the attached screen shots. I've tried clearing my browser history etc.
If I use firefox, the site displays fine from both servers.
Has anyone else seen this?
TIA,
Neil Porter.
[attachment deleted by admin]
When I access the 2 sites my jquery formatting of my menu and my form buttons seems to go haywire.
See the attached screen shots. I've tried clearing my browser history etc.
If I use firefox, the site displays fine from both servers.
Has anyone else seen this?
TIA,
Neil Porter.
[attachment deleted by admin]
34
Web Server - Ask For Help / Duplicate Check broken between 5.01 and 5.05??
« on: December 09, 2010, 03:32:59 AM »
Unfortunately I think I might have found a bug in 5.05. I always tend to assume that I’m doing something wrong when something doesn’t work, but in this case I’m getting distinctly different results between version 5.01 and 5.05 versions of the webserver templates, which makes me think that Bruce might have changed something.
I’ve upgraded to 5.05 as it appears to fix a problem that I was having with trying to display a popup browse (I’ve embedded a browse into a popup form, and that seems to work ok with this version). Unfortunately I’ve just found that every time I try to insert a new record in to one of my SQL tables I get a “Creates Duplicate Key” error on my primary key. Exactly the same app, and the same database with 5.01 works fine and allows the insert without the error.
A bit of background: I’m using MSSQL 2005/2008. I have a JOBID column that is an SQL identity field. I have a Primary Key on that field which is also my unchanging key in my netwebform. I have the EmulateAutoNumKey value set to 1 in my dictionary.
I have child browses that I need to populate during the insert of my parent record, so I have both the “prime Auto Inc if necessary” and “Prime Auto Inc even if not necessary” ticked, and I don’t have the “Ignore Key being not unique” ticked, although this doesn’t seem to have any effect either way.
I can’t see any difference between the generated code in the Check For Duplicates routine, with either template, so I’m not quite sure where to go now. Has anyone else seen this problem?
TIA,
Neil Porter
I’ve upgraded to 5.05 as it appears to fix a problem that I was having with trying to display a popup browse (I’ve embedded a browse into a popup form, and that seems to work ok with this version). Unfortunately I’ve just found that every time I try to insert a new record in to one of my SQL tables I get a “Creates Duplicate Key” error on my primary key. Exactly the same app, and the same database with 5.01 works fine and allows the insert without the error.
A bit of background: I’m using MSSQL 2005/2008. I have a JOBID column that is an SQL identity field. I have a Primary Key on that field which is also my unchanging key in my netwebform. I have the EmulateAutoNumKey value set to 1 in my dictionary.
I have child browses that I need to populate during the insert of my parent record, so I have both the “prime Auto Inc if necessary” and “Prime Auto Inc even if not necessary” ticked, and I don’t have the “Ignore Key being not unique” ticked, although this doesn’t seem to have any effect either way.
I can’t see any difference between the generated code in the Check For Duplicates routine, with either template, so I’m not quite sure where to go now. Has anyone else seen this problem?
TIA,
Neil Porter
35
Web Server - Ask For Help / Can I browse from a queue
« on: June 22, 2010, 05:08:42 AM »
Does anyone know of a way that I can use the NetWebBrowse to display a Local queue rather than a specific table?
I'm trying to use a 3rd party soap server to give me a list of postal addresses from an entered post/zip code. I would then like to display a browse, showing the possible addresses, and allow my user to select the correct address, which I can then popluate into a netwebform. I have all of the code to talk to the soap server, and I can do everything that I need to do in a standard Clarion app, I just need to replicate this functionality on a web interface.
The netwebbrowse template only seems to allow me to select tables from my dictionary.
I'm using Nettalk 4 at the moment. Not sure if that makes a difference.
TIA,
Neil Porter.
I'm trying to use a 3rd party soap server to give me a list of postal addresses from an entered post/zip code. I would then like to display a browse, showing the possible addresses, and allow my user to select the correct address, which I can then popluate into a netwebform. I have all of the code to talk to the soap server, and I can do everything that I need to do in a standard Clarion app, I just need to replicate this functionality on a web interface.
The netwebbrowse template only seems to allow me to select tables from my dictionary.
I'm using Nettalk 4 at the moment. Not sure if that makes a difference.
TIA,
Neil Porter.
36
Web Server - Ask For Help / Still battling with SQL identity fields...and loosing
« on: March 05, 2009, 04:02:59 AM »
I have a NetWebForm that updates records in my Jobs table. My jobs table has a child browse showing related records in my JobParcels table. These tables are related using a JOBID field in each table. JOBID in the jobs table is an Identity field. My dictionary is set so that my table has the EmulateAutoNumKey option set to true, and my JOBID field has AutoNumber = 1,1, and IsIdentity = 1
For debugging purposes I'm displaying my JOBID in my form. If I tick the Prime Auto Inc if necessary box my JOBID field DOESN'T get primed, and any child records that I add to JobParcels are orphaned as you would expect. If I tick the Prime Auto Inc even if not necessary, my JOBID is primed, and I can sucessfully add related child records, fantastic
Now the bad news, if I leave the Prime Auto Inc even if not necessary box ticked, and I get any kind of validation errors occuring on the form, reminding me to enter a mandatory field, etc. I can't save the job, because I get Duplicate Key error at the top of my form
Has anybody managed to get this to work, or is it just me doing something silly? This is driving me mad.
I'm using Clarion 6.3 9059 with NetTalk 4.31 PR 32 and MSSQL 2005.
TIA
Neil Porter
For debugging purposes I'm displaying my JOBID in my form. If I tick the Prime Auto Inc if necessary box my JOBID field DOESN'T get primed, and any child records that I add to JobParcels are orphaned as you would expect. If I tick the Prime Auto Inc even if not necessary, my JOBID is primed, and I can sucessfully add related child records, fantastic
Now the bad news, if I leave the Prime Auto Inc even if not necessary box ticked, and I get any kind of validation errors occuring on the form, reminding me to enter a mandatory field, etc. I can't save the job, because I get Duplicate Key error at the top of my form
Has anybody managed to get this to work, or is it just me doing something silly? This is driving me mad.
I'm using Clarion 6.3 9059 with NetTalk 4.31 PR 32 and MSSQL 2005.
TIA
Neil Porter
37
Web Server - Ask For Help / Priming MSSQL Identity field
« on: January 26, 2009, 06:09:18 AM »
I have a netwebform that I'm using to update records from an MSSQL table called "Jobs".
I have a tab that contains a browse showing child records from a table called "JobParcels"
For some reason I have never been able to get the suggested Clarion 6.3 way of getting the parent identity field value to work, even though I have a table option of EmulateAutoNumKey = True and AutoNumber = 1,1 and IsIdentity = True set against my Identity field in my clarion dictionary.
Becasue I need to prime my child records, I managed to use Geoff Bomford's GWBInsert template, that I use in many other applications. I had to make a few small tweeks to the netwebform to make it work, adding the following code to the PreInsert2 embed:
! Set UpdateJobs:Primed to 1 so that we prevent duplicate checking.
p_web.SetSessionValue('UpdateJobs:Primed',1)
p_web.setsessionvalue('showtab_UpdateJobs',0)
This has been working great until I upgraded my template to 4.31 at the start of this month. Now when I save my charges, my original record is saved as nulls (together with the related child records) and I get a new record inserted in the parent table with all of my keyed values assigned to it.
The wierd thing is, that if I put my template back to 4.30, and recompile (and update my web subfolder) it still doesn't work anymore
I've got 2 production sites where this works absolutely fine, but I now can't recreate it.
Does anyone have any suggestions as to where I might be going wrong. I've been going round in circles now for days.
Regards,
Neil Porter.
I have a tab that contains a browse showing child records from a table called "JobParcels"
For some reason I have never been able to get the suggested Clarion 6.3 way of getting the parent identity field value to work, even though I have a table option of EmulateAutoNumKey = True and AutoNumber = 1,1 and IsIdentity = True set against my Identity field in my clarion dictionary.
Becasue I need to prime my child records, I managed to use Geoff Bomford's GWBInsert template, that I use in many other applications. I had to make a few small tweeks to the netwebform to make it work, adding the following code to the PreInsert2 embed:
! Set UpdateJobs:Primed to 1 so that we prevent duplicate checking.
p_web.SetSessionValue('UpdateJobs:Primed',1)
p_web.setsessionvalue('showtab_UpdateJobs',0)
This has been working great until I upgraded my template to 4.31 at the start of this month. Now when I save my charges, my original record is saved as nulls (together with the related child records) and I get a new record inserted in the parent table with all of my keyed values assigned to it.
The wierd thing is, that if I put my template back to 4.30, and recompile (and update my web subfolder) it still doesn't work anymore
I've got 2 production sites where this works absolutely fine, but I now can't recreate it.
Does anyone have any suggestions as to where I might be going wrong. I've been going round in circles now for days.
Regards,
Neil Porter.
38
Web Server - Ask For Help / Display an Image from a blob
« on: January 26, 2009, 04:06:22 AM »
Does anyone know if it is possible to display an image on a netwebform that is contained in an MSSQL blob field??
Everything that I'm seeing, suggests that I have to display something that is held as an image file in the images folder.
TIA,
Neil Porter.
Everything that I'm seeing, suggests that I have to display something that is held as an image file in the images folder.
TIA,
Neil Porter.
39
Web Server - Ask For Help / PDF Not formatting correctly
« on: December 10, 2008, 04:03:45 AM »
I don't think this is a probelm with NetTalk as such, but I'm hoping that someone might have come across this, and be able to advise me.
I've just deployed a pretty simple NetTalk web server onto a customers server, and when it generates a pdf report, a lot of the report fields, overlap each other, and almost seem to have changed font.
When I run the same app on my test machines, and on other customers servers, the reports generate just fine Which suggests to me that there is something specific I'm missing with the server itself, rather than with NetTalk or Clarion.
I'm using really simple fonts like MS San Serif and Arial, which are installed on that particular server, so I don't think that it is a case of the font being substituted.
Has anyone else seen anything similar?
TIA
Neil.
I've just deployed a pretty simple NetTalk web server onto a customers server, and when it generates a pdf report, a lot of the report fields, overlap each other, and almost seem to have changed font.
When I run the same app on my test machines, and on other customers servers, the reports generate just fine
Which suggests to me that there is something specific I'm missing with the server itself, rather than with NetTalk or Clarion.I'm using really simple fonts like MS San Serif and Arial, which are installed on that particular server, so I don't think that it is a case of the font being substituted.
Has anyone else seen anything similar?
TIA
Neil.
40
Web Server - Ask For Help / NetWebForms - I think I'm missing something fundamental here
« on: October 27, 2008, 06:34:34 AM »
I'm very new to NetTalk Web Server, so I apologise in advance if what I'm asking here is really dumb.
I have a scenario, where an end user will log into a NetTalk Web site, to book "jobs". To give this end user an estimated cost of this job prior to them submitting the job, I have added a GetPrice button to my NetWebForm with some embedded code attached to it, that I use in a standard clarion application elsewhere. (see attachment 1.jpg)
From looking at the documentation, and other posts on this forum, I thought that I would have to reference session variables in calculation code rather than the fields from my table, as I would do in a standard clarion form.
I’ve looked at a number of the example applications, but focussed on the Calculator mostly, as this seems similar in logic. (see attachment 2.jpg & 3.jpg for my embed code)
My problem is that my session variables don’t appear to be set when I call my calculation routine, unless I have used an unrelated lookup button elsewhere on my form. If I use this lookup, my session variables are populated with the variables that have been entered by the end user.
There is obviously a missing step somewhere in my logic, can anyone point me in the correct direction please.
TIA,
Neil Porter.
[attachment deleted by admin]
I have a scenario, where an end user will log into a NetTalk Web site, to book "jobs". To give this end user an estimated cost of this job prior to them submitting the job, I have added a GetPrice button to my NetWebForm with some embedded code attached to it, that I use in a standard clarion application elsewhere. (see attachment 1.jpg)
From looking at the documentation, and other posts on this forum, I thought that I would have to reference session variables in calculation code rather than the fields from my table, as I would do in a standard clarion form.
I’ve looked at a number of the example applications, but focussed on the Calculator mostly, as this seems similar in logic. (see attachment 2.jpg & 3.jpg for my embed code)
My problem is that my session variables don’t appear to be set when I call my calculation routine, unless I have used an unrelated lookup button elsewhere on my form. If I use this lookup, my session variables are populated with the variables that have been entered by the end user.
There is obviously a missing step somewhere in my logic, can anyone point me in the correct direction please.
TIA,
Neil Porter.
[attachment deleted by admin]