Deven the html image link worked. i had to change the control size but it still looks good. thank you
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.
#2
Nomads / Mimic Ctrl + Scroll
September 27, 2024, 02:21:55 PM
Hi All,
I'm working on a program to display Delivery Pictures for a customer. I'm displaying the pics using Shell.Explorer. It is working nice except the pictures are really large. I found if I do a ctrl + scroll zoom in and zoom out. Is there a way i can do this with negative ctl's?
or maybe there is a way to fit the picture to the screen. We used shell explorer because it gives a preview of multiple docs (xml, pdf, any image, text)
thanks
jeff
I'm working on a program to display Delivery Pictures for a customer. I'm displaying the pics using Shell.Explorer. It is working nice except the pictures are really large. I found if I do a ctrl + scroll zoom in and zoom out. Is there a way i can do this with negative ctl's?
or maybe there is a way to fit the picture to the screen. We used shell explorer because it gives a preview of multiple docs (xml, pdf, any image, text)
thanks
jeff
#3
ODBC / Re: ODBC ini file config
August 29, 2024, 03:53:53 PM
Hi Deven, my field contains hexadecimal characters and i think that is causing problem. than you for clarifying for me.
#4
ODBC / Re: ODBC ini file config
August 29, 2024, 03:19:56 PM
thank you Deven - so it doesn't seem to be working for me.
i'll try again ...thank you.
i'll try again ...thank you.
#5
ODBC / Re: ODBC ini file config
August 29, 2024, 01:53:14 PM
I would consider Offset to be where we start in string like in a mid function
let if string is
JEFFREY-JONES
Offset = 4
Length = 3
and i say offset is 4 (assuming 0 based then) i would expect it to return
"REY"
where the "R" is in the 4th position (0 based) and then go over 3 characters...
is that what the Offset is?
let if string is
JEFFREY-JONES
Offset = 4
Length = 3
and i say offset is 4 (assuming 0 based then) i would expect it to return
"REY"
where the "R" is in the 4th position (0 based) and then go over 3 characters...
is that what the Offset is?
#6
ODBC / ODBC ini file config
August 27, 2024, 02:56:12 PM
I'm struggling with something that works but I don't understand why?
[*tables*]
Unit_Completion=p:\custom_data\CFUNIT
[Unit_Completion]
ORDER_NUMBER=STRING,LEN=9,FIELD=1,OFFSET=6
UTC_MTIME=STRING,LEN=10,FIELD=2,OFFSET=0
Can someone tell me what ORDER_NUMBER=STRING,LEN=9,FIELD=1,OFFSET=6 what this is doing?
it does what i want but intuitively i feel like it should not be working.
[*tables*]
Unit_Completion=p:\custom_data\CFUNIT
[Unit_Completion]
ORDER_NUMBER=STRING,LEN=9,FIELD=1,OFFSET=6
UTC_MTIME=STRING,LEN=10,FIELD=2,OFFSET=0
Can someone tell me what ORDER_NUMBER=STRING,LEN=9,FIELD=1,OFFSET=6 what this is doing?
it does what i want but intuitively i feel like it should not be working.
#7
Nomads / Re: Drag and Drop a File
July 16, 2024, 04:23:32 PM
Hi Mike - thank you. this worked for me.
#8
Nomads / Re: Drag and Drop a File
July 10, 2024, 02:47:26 PM
thank you Mike - i will give it a try.
#9
Nomads / Drag and Drop a File
July 10, 2024, 11:07:48 AM
this is probably totally pie in the sky...
is there any way in pxplus that i can drop a file on to something say like from Email Outlook on to a control and get access to that file in some way.
what i'm trying to do is associate a pdf with an invoice or quote.
is there any way in pxplus that i can drop a file on to something say like from Email Outlook on to a control and get access to that file in some way.
what i'm trying to do is associate a pdf with an invoice or quote.
#10
Nomads / Re: Sort On Header Click / Row Height
June 07, 2024, 02:34:25 PM
I will give that a try Jane. Thank you.
#11
Nomads / Re: Sort On Header Click / Row Height
June 07, 2024, 11:02:57 AM
Hi Jane,
So the problem that usually brings about these queries is the Customer, Vendor Name would be something like this:
Mast Road and Grain
and they want to search for Grain
This is my conundrum. The pxplus standard queries work fine when using the keys and typing in first few letters of key.
this is more like a key word search thru the entire row of data.
maybe there is no solution for this - i have coded around it before by checking to see if they clicked on Row -1 and executing Sort Logic myself but i was trying to avoid.
jeff
So the problem that usually brings about these queries is the Customer, Vendor Name would be something like this:
Mast Road and Grain
and they want to search for Grain
This is my conundrum. The pxplus standard queries work fine when using the keys and typing in first few letters of key.
this is more like a key word search thru the entire row of data.
maybe there is no solution for this - i have coded around it before by checking to see if they clicked on Row -1 and executing Sort Logic myself but i was trying to avoid.
jeff
#12
Nomads / Sort On Header Click / Row Height
June 06, 2024, 07:44:00 PM
Hello,
I sometimes make custom queries where as the user types into a multi-line I hide rows via the RowHeight property to zero for those rows that don't meet search criteria. Customers seem to really like it, the only problem is when they ask me to enable 'SortOnHdrClick.
If i filter rows via the row height then if they click a column it just messes it up.
is there a way i can do both / hide rows and still have sort on header click enabled
jeff
I sometimes make custom queries where as the user types into a multi-line I hide rows via the RowHeight property to zero for those rows that don't meet search criteria. Customers seem to really like it, the only problem is when they ask me to enable 'SortOnHdrClick.
If i filter rows via the row height then if they click a column it just messes it up.
is there a way i can do both / hide rows and still have sort on header click enabled
jeff
#13
Web Services / Re: Posting a File to a Web Service
May 24, 2024, 04:41:42 PM
i think the problem is this line
Content-Disposition: form-data; name="xmlsing"; filename="xmlsing.xml"
Mine looks like this
Content-Disposition: form-data; name="filename"; filename="s:\jeff\Cleary_Quote.xml"
i feel like your line should like something like this:
Content-Disposition: form-data; name="filename"; filename="xmlsing.xml"
in other words
the value that name = points to should be the key in the next key value pair
i have to head out but i'll try to check back in again later on this.
Content-Disposition: form-data; name="xmlsing"; filename="xmlsing.xml"
Mine looks like this
Content-Disposition: form-data; name="filename"; filename="s:\jeff\Cleary_Quote.xml"
i feel like your line should like something like this:
Content-Disposition: form-data; name="filename"; filename="xmlsing.xml"
in other words
the value that name = points to should be the key in the next key value pair
i have to head out but i'll try to check back in again later on this.
#14
Web Services / Re: Posting a File to a Web Service
May 24, 2024, 04:10:23 PM
Henderson, for me the problem was that keyword file/filename that i had to pass in.
i feel like you might have to pass in the word "xml"
i could be wrong.
do me a favor - you know where i have
1080 let BODY$=UPLOAD'BODY$() ! Calling Stephane's code
after you execute this method
print the mid(body$,1,300) and then send the contents to this thread...
i feel like you might have to pass in the word "xml"
i could be wrong.
do me a favor - you know where i have
1080 let BODY$=UPLOAD'BODY$() ! Calling Stephane's code
after you execute this method
print the mid(body$,1,300) and then send the contents to this thread...
#15
Web Services / Re: Posting a File to a Web Service
May 24, 2024, 02:55:03 PM
Hi Henderson,
here was is my best try to scale down with no extra stuff
you need Stephane's program http.upload.pvc for this to work. The other stuff is standard pxplus.
if you can't get it working let me know.
0010 begin
0020 precision 4
0030 let XML_FILE$="s:\jeff\Cleary_Quote.xml" ! Your File would be different
0040 let RAW_CREDENTIALS$="login:password" ! Using Basic Credentials then separate your login and password with a colon before calling base64 program
0050 call "*web/base64;ENCODE_STR",RAW_CREDENTIALS$,BASE64_CREDENTIALS$
0060 let EXTRA_HEADERS$="Authorization: Basic "+BASE64_CREDENTIALS$
0070 let URI$="https://staging.saberis.com:9000/api/v1/documents/modules/21/upload"
0080 gosub HELPER
0090 call "*plus/web/request",URI$,BODY$,RESPONSE$,RESPONSE_HEADER$,CONTENT_TYPE$,"",EXTRA_HEADERS$
0100 print RESPONSE_HEADER$
0110 print RESPONSE$
0120 msgbox "Done"
0130 end
1000 ! ^1000
1010 HELPER:
1020 let FIELD_NAME$="filename" ! This part was custom for my api / yours will probably be different
1040 call "*tools/readfile",(XML_FILE$),FILE_CONTENTS$
1050 let FILE_MIME_TYPE$="multipart/form-data"
1060 let UPLOAD=new("http.upload",FIELD_NAME$,XML_FILE$,FILE_CONTENTS$,FILE_MIME_TYPE$) ! This is Stephane's program http.upload.pvc that handles the boundaries (this is part i was messing up (the boundaries))
1070 let CONTENT_TYPE$=UPLOAD'CONTENT_TYPE$
1080 let BODY$=UPLOAD'BODY$()
1090 return
here was is my best try to scale down with no extra stuff
you need Stephane's program http.upload.pvc for this to work. The other stuff is standard pxplus.
if you can't get it working let me know.
0010 begin
0020 precision 4
0030 let XML_FILE$="s:\jeff\Cleary_Quote.xml" ! Your File would be different
0040 let RAW_CREDENTIALS$="login:password" ! Using Basic Credentials then separate your login and password with a colon before calling base64 program
0050 call "*web/base64;ENCODE_STR",RAW_CREDENTIALS$,BASE64_CREDENTIALS$
0060 let EXTRA_HEADERS$="Authorization: Basic "+BASE64_CREDENTIALS$
0070 let URI$="https://staging.saberis.com:9000/api/v1/documents/modules/21/upload"
0080 gosub HELPER
0090 call "*plus/web/request",URI$,BODY$,RESPONSE$,RESPONSE_HEADER$,CONTENT_TYPE$,"",EXTRA_HEADERS$
0100 print RESPONSE_HEADER$
0110 print RESPONSE$
0120 msgbox "Done"
0130 end
1000 ! ^1000
1010 HELPER:
1020 let FIELD_NAME$="filename" ! This part was custom for my api / yours will probably be different
1040 call "*tools/readfile",(XML_FILE$),FILE_CONTENTS$
1050 let FILE_MIME_TYPE$="multipart/form-data"
1060 let UPLOAD=new("http.upload",FIELD_NAME$,XML_FILE$,FILE_CONTENTS$,FILE_MIME_TYPE$) ! This is Stephane's program http.upload.pvc that handles the boundaries (this is part i was messing up (the boundaries))
1070 let CONTENT_TYPE$=UPLOAD'CONTENT_TYPE$
1080 let BODY$=UPLOAD'BODY$()
1090 return