Messages

61

Web Server - Ask For Help / Processing PHP in XHmtl tab not working

« on: August 07, 2013, 04:37:56 PM »

I would like to run some PHP in the XHtml to post code based on a condition. I wanted to test this using the example in the PHP (58) folder (which I renamed to PHP) for this. The "pattern.php" runs just fine, but the same code in the XHtml tab in the MailboxesFormControl does not run in the example. It prints the code after the "print" command.

I would like to post the following PHP code in the PageHeaderTag procedure at the TOP:

<?php
     if(stripos($_SERVER['SERVER_NAME'],"test",0) > 0);?>
        <img src="images/test01.png"/>
<?php else;?>
        <img src="images/test02.png"/>
<?php endif;?>

Thanks
Ken

62

Looking To Hire / Nettalk Web Server Project

« on: July 26, 2013, 08:17:19 AM »

I am looking for some assistance in a Nettalk website. I have the base, but I need to get the project a bigger jump start to get the website up and running with ordering process and working as I need it. This is working with MSSQL.

Please contact me by email at ken@wasatchconsultingservices.com

Thanks
Ken Watts
Wasatch Consulting Services

63

Web Server - Ask For Help / Accessing another MSSQL table issue

« on: July 24, 2013, 06:44:55 PM »

This was working prior to version 7.12.

I have run into an issue with accessing an additional MSSQL table in the code to gather some additional information. The tables are related and I can add this as a related table to the primary table, but this ends up creating multiple rows for each primary record as there are multiple records in the child table.

I include the required table in the "Other Files" section for the procedure. When I try to access the file I get "connection is busy - s1000" error. I have the MARS option on the table, I even checked the code, but yet it still gives me this error.

Thanks
Ken Watts
Wasatch Consulting Services

64

Web Server - Ask For Help / Calling form without browse

« on: July 16, 2013, 02:39:05 PM »

I am trying to call a form without a browse. I have the unique record id stored in a session value and so I have placed the following code in the INITFORM embed in the form:

p_web.SetValue('UniqueRecordID',p_web.GSV('SessionValue'))

This just keeps giving me an alert indicating that the record cannot be found (error -2). This is on an MSSQL table.

Thanks for your help.

Ken Watts
Wasatch Consulting Services

65

Web Server - Ask For Help / Lookup width from EIP

« on: July 10, 2013, 08:06:55 PM »

I have a couple of lookups in an EIP browse. This works great, but I do not see where you can change the width of the lookup like you can from a form.

Thanks
Ken Watts
Wasatch Consulting Services

66

Web Server - Ask For Help / Re: EIP Lookup

« on: June 18, 2013, 10:13:00 AM »

Bruce,

I found my problem. I started from a new browse and worked through it. It was working until I placed some custom code in the "Procedure Setup". It boiled down to the following line of code:

p_web.SetSessionValue('StoreID','100')

When the procedure processes the "Procedure Setup" the first time, no problem. But this code is being processed every time you edit any EIP field. In fact, when you click into a EIP field, the "Procedure Setup" is processed. I have placed code so that this code is only processed once as there are things in that code that I absolutely want processed only once.

Is there are reason the "Procedure Setup" code is processed every time anything is processed for that procedure?

Thanks
Ken Watts
Wasatch Consulting Services

67

Web Server - Ask For Help / Re: EIP Lookup

« on: June 13, 2013, 02:02:42 PM »

After further testing, I have found that the problem only exists when using a lookup with the EIP field. This holds true with the web21 example. If you add the lookup to the example, then the update does not work. The EIP does not get updated and you get an error 40 in the example web21 app. If I do not use the lookup, I do not get the "Field Invalid" error, but as soon as I add the lookup back, if I try typing anything in, it gives me the "Field Invalid" and the lookup does not work.

Ken Watts
Wasatch Consulting Services

68

Web Server - Ask For Help / Re: EIP Lookup

« on: June 13, 2013, 08:02:11 AM »

I tried the same setup in the web21 example. At first, it gave me the "Field Invalid", but I realized that I had used a lookup field that was a numeric field with a string field. Changed it to match and the process stopped giving me the error and accepted the entry. I went back to my app and looked to see what the two field types were and they were both cstring and the same size. My application properties appear to be identical to the example. The question that I would have before posting a example of what I am doing, what causes the "Field Invalid" error and what are the rules for the EIP field so that this error does not appear.

Ken Watts
Wasatch Consulting Services

69

Web Server - Ask For Help / EIP Lookup

« on: June 09, 2013, 02:38:37 PM »

I am using EIP string field on a browse that has a lookup. When I type in an entry that matches a record in the lookup file it says "Field Invalid". When using the same lookup in a form it works just fine. In addition, when I click on the "?" next to the field to select a record, no records appear to select. Everything works just fine from a form field using the same field and lookup. What I am doing wrong?

Ken Watts
Wasatch Consulting Services

70

Web Server - Ask For Help / Slow SQL Update

« on: June 04, 2013, 01:01:21 PM »

I have noticed that saving and deleting records in a MSSQL table is extremely slow. Accessing a record and displaying it is just fine, but saving or deleting records slow down dramatically. In other Clarion apps that I have done, I use PROP:SQL to send SQL code to save and delete records as this improves speed and at times the normal Clarion code does not update the tables correctly if there are calculated fields in the tables. Where would I place SQL code instead of using the Clarion code to update or delete?

Ken Watts
Wasatch Consulting Services

71

Web Server - Ask For Help / Re: Locator Dropdown

« on: June 04, 2013, 12:52:28 PM »

Kevin and Bruce,

Thanks for you help. This put me in the right direction and I have it working now.

Ken Watts
Wasatch Consulting Services

72

Web Server - Ask For Help / Locator Dropdown

« on: June 03, 2013, 01:29:33 PM »

I have a browse with multiple columns of which there are 4 columns which the user can click on the header and then the user can type in a search parameter in the locator field. This client would like to have it so that instead of clicking on the column headers, one would use a drop box to select which column to search on.

Thanks
Ken Watts
Wasatch Consulting Services

Using Clarion 8 with Nettalk 7