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.
16
Web Server - Ask For Help / Re: xml string not resulting in an correct word document
« on: January 12, 2018, 01:39:24 AM »
Hi Bruce,
It works.
I got to use more StringTheory.
Thanks again,
Joep
It works.
I got to use more StringTheory.
Thanks again,
Joep
17
Web Server - Ask For Help / xml string not resulting in an correct word document
« on: January 10, 2018, 06:25:50 AM »
Hi There,
I have build a webservice which recieves xml's containing images, word ducuments and pdf's.
In my code I decode the base64 encoded string and save it as blob in the database:
If Clip(fo:data)
LenCoded = len(clip(fo:data))
Clear(StringDecoded)
str.SetValue(Clip(StringDecoded))
NetBase64DecodeEx(fo:data,StringDecoded,LenCoded)
str.SetValue(Clip(StringDecoded))
str.ToBlob(Upl:ImageBlock)
END
When I save this later to a file from the database only images show themselves correctly.
The pdf and the word document are complaining about damaged content.
If I click a few times in word, word resolves this problems and shows correctly afterall.
If I take the strings out of the xml and feed them to an bas64 decode website tool they both show correctly.
Can someone tell me what I'm doing wrong?
Regards Joep
I have build a webservice which recieves xml's containing images, word ducuments and pdf's.
In my code I decode the base64 encoded string and save it as blob in the database:
If Clip(fo:data)
LenCoded = len(clip(fo:data))
Clear(StringDecoded)
str.SetValue(Clip(StringDecoded))
NetBase64DecodeEx(fo:data,StringDecoded,LenCoded)
str.SetValue(Clip(StringDecoded))
str.ToBlob(Upl:ImageBlock)
END
When I save this later to a file from the database only images show themselves correctly.
The pdf and the word document are complaining about damaged content.
If I click a few times in word, word resolves this problems and shows correctly afterall.
If I take the strings out of the xml and feed them to an bas64 decode website tool they both show correctly.
Can someone tell me what I'm doing wrong?
Regards Joep
18
Web Server - Ask For Help / Re: compile errors since nettalk 10.07
« on: October 01, 2017, 10:22:23 PM »
Hi Bruce,
I'm up and running again.
Thanks so much.
Regards Joep
I'm up and running again.
Thanks so much.
Regards Joep
19
Web Server - Ask For Help / compile errors since nettalk 10.07
« on: September 29, 2017, 04:01:43 AM »
Hi All,
I got a lot of compile erros since I moved to nettalk 10.07
One part of these errors is an unresolved error in map\release
Unresolved External CONSTRUCT@F9NETSIMPLE in la10off003.obj - C:\Clarion10\apps\Aag2018Sql\map\release\ la10off.MAP
Unresolved External DESTRUCT@F9NETSIMPLE in la10off003.obj - C:\Clarion10\apps\Aag2018Sql\map\release\ la10off.MAP
Unresolved External CONSTRUCT@F9NETSIMPLE in la10off003.obj - C:\Clarion10\apps\Aag2018Sql\map\release\ la10off.MAP
Unresolved External DESTRUCT@F9NETSIMPLE in la10off003.obj - C:\Clarion10\apps\Aag2018Sql\map\release\ la10off.MAP
And these
No matching prototype available - C:\Clarion10\Accessory\libsrc\win\ NetDrive.Clw
Unknown procedure label - C:\Clarion10\Accessory\libsrc\win\ NetHttp.Clw
Field not found: CAT - C:\Clarion10\Accessory\libsrc\win\ NetHttp.Clw
No matching prototype available - C:\Clarion10\Accessory\libsrc\win\ NetHttp.Clw
No matching prototype available - C:\Clarion10\Accessory\libsrc\win\ NetHttp.Clw
No matching prototype available - C:\Clarion10\Accessory\libsrc\win\ NetHttp.Clw
No matching prototype available - C:\Clarion10\Accessory\libsrc\win\ NetHttp.Clw
No matching prototype available - C:\Clarion10\Accessory\libsrc\win\ NetHttp.Clw
Unknown procedure label - C:\Clarion10\Accessory\libsrc\win\ NetLDAP.Clw
Hope someone can help me
Regards Joep
I got a lot of compile erros since I moved to nettalk 10.07
One part of these errors is an unresolved error in map\release
Unresolved External CONSTRUCT@F9NETSIMPLE in la10off003.obj - C:\Clarion10\apps\Aag2018Sql\map\release\ la10off.MAP
Unresolved External DESTRUCT@F9NETSIMPLE in la10off003.obj - C:\Clarion10\apps\Aag2018Sql\map\release\ la10off.MAP
Unresolved External CONSTRUCT@F9NETSIMPLE in la10off003.obj - C:\Clarion10\apps\Aag2018Sql\map\release\ la10off.MAP
Unresolved External DESTRUCT@F9NETSIMPLE in la10off003.obj - C:\Clarion10\apps\Aag2018Sql\map\release\ la10off.MAP
And these
No matching prototype available - C:\Clarion10\Accessory\libsrc\win\ NetDrive.Clw
Unknown procedure label - C:\Clarion10\Accessory\libsrc\win\ NetHttp.Clw
Field not found: CAT - C:\Clarion10\Accessory\libsrc\win\ NetHttp.Clw
No matching prototype available - C:\Clarion10\Accessory\libsrc\win\ NetHttp.Clw
No matching prototype available - C:\Clarion10\Accessory\libsrc\win\ NetHttp.Clw
No matching prototype available - C:\Clarion10\Accessory\libsrc\win\ NetHttp.Clw
No matching prototype available - C:\Clarion10\Accessory\libsrc\win\ NetHttp.Clw
No matching prototype available - C:\Clarion10\Accessory\libsrc\win\ NetHttp.Clw
Unknown procedure label - C:\Clarion10\Accessory\libsrc\win\ NetLDAP.Clw
Hope someone can help me
Regards Joep
20
Web Server - Ask For Help / Re: saving uploaded image as blob
« on: June 10, 2014, 06:47:30 AM »
Hi Bruce
I traced it down to the SaveFileTo Session routine in Netweb.clw
In there I have:
s = self.GetValue(lower(clip(p_name)) & '_start')
l = self.GetValue(lower(clip(p_name)) & '_length')
Both parameters are zero when working with sql server
Do you have a clue what the problem might be?
Regards,
Joep
I traced it down to the SaveFileTo Session routine in Netweb.clw
In there I have:
s = self.GetValue(lower(clip(p_name)) & '_start')
l = self.GetValue(lower(clip(p_name)) & '_length')
Both parameters are zero when working with sql server
Do you have a clue what the problem might be?
Regards,
Joep
21
Web Server - Ask For Help / Re: saving uploaded image as blob
« on: June 05, 2014, 04:32:46 AM »
Hi Bruce,
I haven't been able to test the new blob function untill now .
I was experiencing the same issues with 8.13.
In the example I sent which was "tps" I can save the image to blob
So far so good.
Now my real program runs on a sql server database.
Changing to "saving incoming file to blob" there has no effect.
And in the complete form routine p_web.GetSessionValueLength('Upl:ImageBlock') = 0
So the Session value is empty?
Regards,
Joep
I haven't been able to test the new blob function untill now .
I was experiencing the same issues with 8.13.
In the example I sent which was "tps" I can save the image to blob
So far so good.
Now my real program runs on a sql server database.
Changing to "saving incoming file to blob" there has no effect.
And in the complete form routine p_web.GetSessionValueLength('Upl:ImageBlock') = 0
So the Session value is empty?
Regards,
Joep
22
Web Server - Ask For Help / Re: how to implement autoincrement in update form afterwords
« on: May 26, 2014, 02:54:06 AM »
Hi Bruce,
I changed the foreign key's on the sql server database and now it works.
Regards,
Joep
I changed the foreign key's on the sql server database and now it works.
Regards,
Joep
23
Web Server - Ask For Help / Re: how to implement autoincrement in update form afterwords
« on: May 26, 2014, 02:08:07 AM »
Hi Bruce,
Actually it's a bit different now.
The record is primed now and I can see the parent id in the form,
but the child is still complaining that there is no parent id.
All I have done is setting the auto increment in the dct on a few key's.
Regards,
Joep
Actually it's a bit different now.
The record is primed now and I can see the parent id in the form,
but the child is still complaining that there is no parent id.
All I have done is setting the auto increment in the dct on a few key's.
Regards,
Joep
24
Web Server - Ask For Help / Re: saving uploaded image as blob
« on: May 26, 2014, 01:04:34 AM »
Hi Bruce,
This is a simple TPS example of a file upload attached.
Like I said before I can do an additional insert and the coding gets around the SaveFile embed like you suggested in the webinar.
The blob gets saved but then I end up with 2 records.
And I have to create additional coding to get rid of one record.
So I hope there is a way to update the active record.
Regards,
Joep
[attachment deleted by admin]
This is a simple TPS example of a file upload attached.
Like I said before I can do an additional insert and the coding gets around the SaveFile embed like you suggested in the webinar.
The blob gets saved but then I end up with 2 records.
And I have to create additional coding to get rid of one record.
So I hope there is a way to update the active record.
Regards,
Joep
[attachment deleted by admin]
25
Web Server - Ask For Help / Re: how to implement autoincrement in update form afterwords
« on: May 23, 2014, 04:31:08 AM »
Hi Bruce,
The problem is that I cannot insert a child record upon the insert of the parent.
I get an error that the parent has no id yet.
I suppose that problem is due to the fact that we generated the forms with no auto increment in de DCT.
Now I have set several auto increments in the dictionary.
But the code is not changed by these settings in the dictionary.
And the parent is still not primed, so I keep getting an error that there is no id.
I thought I could paste the nescessary priming code by hand, so the form would get primed.
Regards,
Joep
The problem is that I cannot insert a child record upon the insert of the parent.
I get an error that the parent has no id yet.
I suppose that problem is due to the fact that we generated the forms with no auto increment in de DCT.
Now I have set several auto increments in the dictionary.
But the code is not changed by these settings in the dictionary.
And the parent is still not primed, so I keep getting an error that there is no id.
I thought I could paste the nescessary priming code by hand, so the form would get primed.
Regards,
Joep
26
Web Server - Ask For Help / how to implement autoincrement in update form afterwords
« on: May 23, 2014, 01:58:14 AM »
Hi All
I have generated an webapplication with several browses and forms.
In the database (sql server) I have several key's with an identity.
But I haven't got auto increments on those key's in the dictionary.
Unfortunally, implementing these increments in the dct, generates no extra code by the templates.
I tried to implement the code by myself but it doesn't work. (form is not primed)
code I used at the preinsert and precopy:
! Start of "Pre Insert After Primes"
! [Priority 5000]
p_web.PrimeFile(Smp_Algemeen,true,0)
Ans = Net:ChangeRecord
p_web.SetSessionValue('UpdateSmp_Algemeen:Primed',1)
! End of "Pre Insert After Primes"
What am I doing wrong?
Regards,
Joep
I have generated an webapplication with several browses and forms.
In the database (sql server) I have several key's with an identity.
But I haven't got auto increments on those key's in the dictionary.
Unfortunally, implementing these increments in the dct, generates no extra code by the templates.
I tried to implement the code by myself but it doesn't work. (form is not primed)
code I used at the preinsert and precopy:
! Start of "Pre Insert After Primes"
! [Priority 5000]
p_web.PrimeFile(Smp_Algemeen,true,0)
Ans = Net:ChangeRecord
p_web.SetSessionValue('UpdateSmp_Algemeen:Primed',1)
! End of "Pre Insert After Primes"
What am I doing wrong?
Regards,
Joep
27
Web Server - Ask For Help / Re: saving uploaded image as blob
« on: May 23, 2014, 01:46:17 AM »
The blob is created, but somehow it isn't saved to the record.
This is the code
Access:Smp_Uploads.open()
Access:Smp_Uploads.UseFile()
! End of "Save File"
p_web.SSV('_save_Upl:ImageName',Upl:ImageName)
p_web.SaveFile('Upl:ImageName',Upl:ImageName)
! Start of "Save File"
! [Priority 5000]
i#=FileToBlob(Upl:ImageName,Upl:ImageBlock)
p_web.Trace('Embed Blob Image after ave File=' & Clip(Upl:ImageName) & ' size=' & Upl:ImageBlock{PROP:Size} & ' p_stage=' & p_stage)
I even tried to move the filetoblob to the postinsert section.
The Filetoblob succeeds but is also not saved to the record.
Other fields do get saved at this place
What is the wright place for the blob to get saved?
I also tried to create an additional record at the saveFile embed.
With an insert I can save the blob.
But then I end up with 2 records.
And I have to create additional coding to get rid of one record.
Doesn't seem logic to me.
Regards,
Joep
This is the code
Access:Smp_Uploads.open()
Access:Smp_Uploads.UseFile()
! End of "Save File"
p_web.SSV('_save_Upl:ImageName',Upl:ImageName)
p_web.SaveFile('Upl:ImageName',Upl:ImageName)
! Start of "Save File"
! [Priority 5000]
i#=FileToBlob(Upl:ImageName,Upl:ImageBlock)
p_web.Trace('Embed Blob Image after ave File=' & Clip(Upl:ImageName) & ' size=' & Upl:ImageBlock{PROP:Size} & ' p_stage=' & p_stage)
I even tried to move the filetoblob to the postinsert section.
The Filetoblob succeeds but is also not saved to the record.
Other fields do get saved at this place
What is the wright place for the blob to get saved?
I also tried to create an additional record at the saveFile embed.
With an insert I can save the blob.
But then I end up with 2 records.
And I have to create additional coding to get rid of one record.
Doesn't seem logic to me.
Regards,
Joep
28
Web Server - Ask For Help / saving uploaded image as blob
« on: April 16, 2014, 06:20:48 AM »
Hi all,
We have got an web application created with nettalk 8.03 and clarion 9.0.
I'd like to perform some actions:
1) upload foto or sound and save it as a blob in the database.
2) view the foto's that already have been saved as blob
In the dictionary I have:
- imagename (which is an string, used as name identification of the image)
- imageblock (which is an blob)
I can upload an image, but it is saved on disk in the web/upload folder instead of saving it as a blob.
Can anyone tell me, what to do and where, to save the image as an blob instead?
And how to view it afterwards
Regards
Joep
We have got an web application created with nettalk 8.03 and clarion 9.0.
I'd like to perform some actions:
1) upload foto or sound and save it as a blob in the database.
2) view the foto's that already have been saved as blob
In the dictionary I have:
- imagename (which is an string, used as name identification of the image)
- imageblock (which is an blob)
I can upload an image, but it is saved on disk in the web/upload folder instead of saving it as a blob.
Can anyone tell me, what to do and where, to save the image as an blob instead?
And how to view it afterwards
Regards
Joep
29
Web Server - Ask For Help / Re: problem reaching Apple's Notification service (webservice)
« on: October 04, 2013, 05:13:23 AM »
Hi Bruce,
Maybe it's not possible in an synchronous way.
These are some of the specifications for the Apple Notification Server :
General Requirements
As a provider you communicate with Apple Push Notification service over a binary interface. This interface is a high-speed, high-capacity interface for providers; it uses a streaming TCP socket design in conjunction with binary content. The binary interface is asynchronous
Although Debugview tells me the connection is succesfull, but I get no response:
NetSimple.Open - self._connection.mode=0 server=gateway.sandbox.push.apple.com port=2195
NetSimple(Client).Open - Attempting to connect to gateway.sandbox.push.apple.com on Port 2195
NetSimple(Client).Open - Will use InActive (Idle) Timeout (hs) = 9000
NetSimple(Client).Open - Connection opened on Socket = 648 SockID = 2
NetSimple.Send (Client Mode) - Sending Data to HostName = gateway.sandbox.push.apple.com OnSocket = 648 SockID = 2 Port = 2195 BinDataLen = 198
NetSimple.Send (Client Mode) - Sending Data to HostName = gateway.sandbox.push.apple.com OnSocket = 648 SockID = 2 Port = 2195 BinDataLen = 199
NetSimple.Send (Client Mode) - Sending Data to HostName = gateway.sandbox.push.apple.com OnSocket = 648 SockID = 2 Port = 2195 BinDataLen = 199
NetSimple.Send (Client Mode) - Sending Data to HostName = gateway.sandbox.push.apple.com OnSocket = 648 SockID = 2 Port = 2195 BinDataLen = 200
NetSimple.Close - Closing Client Socket = 648 SockID = 2 to Server = gateway.sandbox.push.apple.com Originally Connected to Port = 2195
I was also curious if there's a way to send a password along with a certificate?
Regards,
Joep
Maybe it's not possible in an synchronous way.
These are some of the specifications for the Apple Notification Server :
General Requirements
As a provider you communicate with Apple Push Notification service over a binary interface. This interface is a high-speed, high-capacity interface for providers; it uses a streaming TCP socket design in conjunction with binary content. The binary interface is asynchronous
Although Debugview tells me the connection is succesfull, but I get no response:
NetSimple.Open - self._connection.mode=0 server=gateway.sandbox.push.apple.com port=2195
NetSimple(Client).Open - Attempting to connect to gateway.sandbox.push.apple.com on Port 2195
NetSimple(Client).Open - Will use InActive (Idle) Timeout (hs) = 9000
NetSimple(Client).Open - Connection opened on Socket = 648 SockID = 2
NetSimple.Send (Client Mode) - Sending Data to HostName = gateway.sandbox.push.apple.com OnSocket = 648 SockID = 2 Port = 2195 BinDataLen = 198
NetSimple.Send (Client Mode) - Sending Data to HostName = gateway.sandbox.push.apple.com OnSocket = 648 SockID = 2 Port = 2195 BinDataLen = 199
NetSimple.Send (Client Mode) - Sending Data to HostName = gateway.sandbox.push.apple.com OnSocket = 648 SockID = 2 Port = 2195 BinDataLen = 199
NetSimple.Send (Client Mode) - Sending Data to HostName = gateway.sandbox.push.apple.com OnSocket = 648 SockID = 2 Port = 2195 BinDataLen = 200
NetSimple.Close - Closing Client Socket = 648 SockID = 2 to Server = gateway.sandbox.push.apple.com Originally Connected to Port = 2195
I was also curious if there's a way to send a password along with a certificate?
Regards,
Joep
30
Web Server - Ask For Help / Re: problem reaching Apple's Notification service (webservice)
« on: October 01, 2013, 06:01:17 AM »
Thanks all.
I have got it working now.
The certificate was indeed the problem.
I tested it with openssl and after generating new certificates with the Apple Developers account I got response.
But what I really want now is to fire notifications in a batch sequence.
To do that I have created an procedure to process a file.
I included the netSimpleObject.
After the init of the netSimpleObject I do an Net.open.
And in the for each record activity embed I do the net.Send
But the connection is not open when I do the net.Send.
I used debugview to get behind the problem.
Actually the connection doesn't get open until the whole file is processed.
To be precice wrigth before the connection close embed.
Does anyone have a clue,why the connection is not open when I process the file?
Regards,
Joep
I have got it working now.
The certificate was indeed the problem.
I tested it with openssl and after generating new certificates with the Apple Developers account I got response.
But what I really want now is to fire notifications in a batch sequence.
To do that I have created an procedure to process a file.
I included the netSimpleObject.
After the init of the netSimpleObject I do an Net.open.
And in the for each record activity embed I do the net.Send
But the connection is not open when I do the net.Send.
I used debugview to get behind the problem.
Actually the connection doesn't get open until the whole file is processed.
To be precice wrigth before the connection close embed.
Does anyone have a clue,why the connection is not open when I process the file?
Regards,
Joep