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.
1
Web Server - Ask For Help / Re: Upload - Rename - Store New Path & Filename In Data Base
« on: August 22, 2011, 03:08:24 AM »
Thanks Bruce,
I'll get to the image on the web server adifferent way for now. I wrote the company standards, I'll break them.
The app is too big and the files are too big to package. I'll worry about it after I move it to Clarioin 8 in a few months.
Dave
I'll get to the image on the web server adifferent way for now. I wrote the company standards, I'll break them.
The app is too big and the files are too big to package. I'll worry about it after I move it to Clarioin 8 in a few months.
Dave
2
Web Server - Ask For Help / Upload - Rename - Store New Path & Filename In Data Base
« on: August 20, 2011, 04:33:28 PM »
Hi Folks,
I need to upload documents atttached with any given order. When I just use the upload dialogue the documents get placed in my web\uploads folders just fine and the data base field is updated.
When I go through the Rename embed and use the RenameFile procedure, the uploaed document is
placed where I want it. (note under the web). I needed to use he customer number to make a path and the order number with the document extension added to make a file name. Again, it is where I need it to be placed.
However, the field in my data base is only updated for the last 5 characters.
Example s:\uploads\964\39482.jpg is only be recorded in the data base field as 82.jpg
A message for both the filename and the path are fine. In the form field I have p_name = 'vti:documentpath'
which is also the field on the form with the lookup.
I have to be mssing somehting.
I need to upload documents atttached with any given order. When I just use the upload dialogue the documents get placed in my web\uploads folders just fine and the data base field is updated.
When I go through the Rename embed and use the RenameFile procedure, the uploaed document is
placed where I want it. (note under the web). I needed to use he customer number to make a path and the order number with the document extension added to make a file name. Again, it is where I need it to be placed.
However, the field in my data base is only updated for the last 5 characters.
Example s:\uploads\964\39482.jpg is only be recorded in the data base field as 82.jpg
A message for both the filename and the path are fine. In the form field I have p_name = 'vti:documentpath'
which is also the field on the form with the lookup.
I have to be mssing somehting.
3
Web Server - Ask For Help / Any Problem With New Adobe on Client
« on: December 10, 2010, 05:27:11 AM »
I installed Adove Reader X on a Windows 7 Pro workstation I use for testing. I had version 9 on it before and all was fine.
Now, I can not open web server generated PDF reports. Has anyone seen this? I duplicated the problem on another Windows 7 machine with Adobe Reader X.
I can still open the reports on workstations loaded with Windows 7 Adobe 9 and XP with Adobe 9.
Thanks,
Dave
Now, I can not open web server generated PDF reports. Has anyone seen this? I duplicated the problem on another Windows 7 machine with Adobe Reader X.
I can still open the reports on workstations loaded with Windows 7 Adobe 9 and XP with Adobe 9.
Thanks,
Dave
4
Web Server - Ask For Help / Re: Unique Key Is Customer Number - Can't Access
« on: October 15, 2010, 11:29:36 AM »
Bruce
Orders File - Primary unique key is single field, record no.
Customer File - Unique primary key, single field, Customer Number
Contacts File - Unique Key - Single field, RecordNumber, Key used for this - Customer No, COntacnt NO - Contact NO is auto Increment and customer no is filled from the customer parent
I have a form I do the selection of the customer number from. WHen it returns it DOES place the customer no in the field on the orders record and pulls the customer description and places it in the comments field. However, the setseession variable value is zero (it used to work).
When I place message statements after the return from the selection form, I can display every field in the Customer record upon the server except the customer number, which is the only field in the unique key.
Orders File - Primary unique key is single field, record no.
Customer File - Unique primary key, single field, Customer Number
Contacts File - Unique Key - Single field, RecordNumber, Key used for this - Customer No, COntacnt NO - Contact NO is auto Increment and customer no is filled from the customer parent
I have a form I do the selection of the customer number from. WHen it returns it DOES place the customer no in the field on the orders record and pulls the customer description and places it in the comments field. However, the setseession variable value is zero (it used to work).
When I place message statements after the return from the selection form, I can display every field in the Customer record upon the server except the customer number, which is the only field in the unique key.
5
Web Server - Ask For Help / Unique Key Is Customer Number - Can't Access
« on: October 15, 2010, 08:11:06 AM »
Hi All,
This used to work. I compiled under PR32 today and it does not.
3 Tables
Orders
Customers
CustomerContacts
Orders has a filed for the ID for the Customer table and the Contact Table.
The unique key, auton umber, in the customer table is also the customer number. Over 700 customers in the table. Clarion 6 apps work fine.
The customer is obtained using a select table. The customer number is placed in a session var
When the contact Table is called, the session var, placed in a local variable is used to filter so only the contacts for the selected customer are visibile to be select.
So, the user selects a customer, then selects a contact from 2 different forms.
Worked great
Now
The slections of the customer is returning a zero instead of the proper customer number from the ufield whic is also part of the unique key for the table. I can display any other field from the customer table on the server, be they long, or string.
Funny thing is the customer number does return from the select lookup and is placed in the field on the orders record as well as showing the customer name in the comments field... I just can no longer access it like before and save it for use in another lookup.
This used to work. I compiled under PR32 today and it does not.
3 Tables
Orders
Customers
CustomerContacts
Orders has a filed for the ID for the Customer table and the Contact Table.
The unique key, auton umber, in the customer table is also the customer number. Over 700 customers in the table. Clarion 6 apps work fine.
The customer is obtained using a select table. The customer number is placed in a session var
When the contact Table is called, the session var, placed in a local variable is used to filter so only the contacts for the selected customer are visibile to be select.
So, the user selects a customer, then selects a contact from 2 different forms.
Worked great
Now
The slections of the customer is returning a zero instead of the proper customer number from the ufield whic is also part of the unique key for the table. I can display any other field from the customer table on the server, be they long, or string.
Funny thing is the customer number does return from the select lookup and is placed in the field on the orders record as well as showing the customer name in the comments field... I just can no longer access it like before and save it for use in another lookup.
6
Web Server - Ask For Help / Re: Example 60 - CPCS
« on: August 04, 2010, 01:45:58 PM »
Bruce,
It works when I push the button you placed on the web handler/log screen, which of course is located on the server.
It will not work from a web client - when selecting the option from the drop down.
Any trick or skip it for now?
Dave
It works when I push the button you placed on the web handler/log screen, which of course is located on the server.
It will not work from a web client - when selecting the option from the drop down.
Any trick or skip it for now?
Dave
7
Web Server - Ask For Help / Re: Example 60 - CPCS
« on: August 04, 2010, 04:08:24 AM »
Bruce,
I'm using the vanilla CPCS example 60. I just got the same result with PR28
When I select the CPCS report option from the menu, page not found...
Dave
I'm using the vanilla CPCS example 60. I just got the same result with PR28
When I select the CPCS report option from the menu, page not found...
Dave
8
Web Server - Ask For Help / Example 60 - CPCS
« on: August 03, 2010, 10:51:48 AM »
I compiled this example and when I selected the CPCS report I get the 404 message - page can not be found. Maybe I'm blind, but the tag looks correct.
Can someone check to see if example 60 - mailboxes CPCS option works.....
I have 9 reports in CPCS i'd love to through up on the web for the customers to run ad-hoc
Thanks,
Dave
Can someone check to see if example 60 - mailboxes CPCS option works.....
I have 9 reports in CPCS i'd love to through up on the web for the customers to run ad-hoc
Thanks,
Dave
9
Web Server - Ask For Help / Re: Bad data sent to NetWebserverworker
« on: August 02, 2010, 05:41:42 AM »
I too, like the folks above, need the product fix. Just don't have the time to mess with this and my production stuff still runs fine. Have a stack of enhancements built under 26 that I'd like to get in .
Dave
Dave
10
Web Server - Ask For Help / Re: Bad data sent to NetWebserverworker
« on: July 31, 2010, 06:33:49 AM »
Larry,
I got it.....
Thanks so much for your time and effort.
Guess I got to get to work this afternoon
Take Care
Dave
I got it.....
Thanks so much for your time and effort.
Guess I got to get to work this afternoon
Take Care
Dave
11
Web Server - Ask For Help / Re: Bad data sent to NetWebserverworker
« on: July 31, 2010, 02:42:20 AM »
Hi all,
Is there a sequence that produces this problem? I have 13 services and have not seen it in testing, and 26 fixed my other problems.
Also, what does Larry mean in his post above by hook the procedure?
Thanks,
Dave
Is there a sequence that produces this problem? I have 13 services and have not seen it in testing, and 26 fixed my other problems.
Also, what does Larry mean in his post above by hook the procedure?
Thanks,
Dave
12
Web Server - Ask For Help / Re: The Browse Next & Previous don't work with MS SQL : Need to hit Refresh Browser
« on: July 24, 2010, 01:40:15 PM »
Both dowload sites?
The one I just downloaded was the same size as the one I downloaded on 7/7/2010
Dave
The one I just downloaded was the same size as the one I downloaded on 7/7/2010
Dave
13
Web Server - Ask For Help / Re: The Browse Next & Previous don't work with MS SQL : Need to hit Refresh Browser
« on: July 23, 2010, 05:13:03 PM »
Hi,
Bruce says this will be fixed in PR 26. Your '&' should be accessed and displayed fine after that. (It used to work)
Dave
Bruce says this will be fixed in PR 26. Your '&' should be accessed and displayed fine after that. (It used to work)
Dave
14
Web Server - Ask For Help / Re: Bruce - Does This Make Sense ?
« on: July 13, 2010, 05:02:45 AM »
Thanks a bunch Bruce,
This one was really going to be a problem with a few customers....
Dave
This one was really going to be a problem with a few customers....
Dave
15
Web Server - Ask For Help / Re: Bruce - Does This Make Sense ?
« on: July 10, 2010, 07:17:48 AM »
Let me correct myself - I cheated the problem.
I went to example 31 - Accounts and modified a customer record that does not appear on the first page of the browse with the ampersand sign. The browse will not go forward and open up the next set of records, with with the &.
Also, you can not page back because of the very first record in the cvustomer file.
Dave
I went to example 31 - Accounts and modified a customer record that does not appear on the first page of the browse with the ampersand sign. The browse will not go forward and open up the next set of records, with with the &.
Also, you can not page back because of the very first record in the cvustomer file.
Dave