Topics

46

Web Server - Ask For Help / SQL Dummy table in a browse

« on: October 03, 2011, 02:46:25 PM »

Is it possible to have a browse on your SQL dummy table?  I've tried putting the PROP:SQL statement in every embed point I can think of and I always get no records found.

Or if there's a way to use the template to get the information I want.  Here is an example of one of the SQL statements I want to turn into a browse

Code: [Select]

SELECT CAST(t.Time as DATE), SUM(t.Quan) FROM Inventory.Location as l
JOIN History.ArcTransaction as t on t.LocationID = l.LocationID
WHERE l.LocationID = 78865 AND t.Time BETWEEN DATEADD(YEAR, -1, GETDATE()) AND GETDATE()
GROUP BY CAST(t.Time as DATE)
ORDER BY CAST(t.Time as DATE)


47

Web Server - Ask For Help / Upgraded to 5.34 from 4.47 XP Tabs don't work

« on: September 07, 2011, 03:13:02 PM »

After the upgrade I can't get XP Tabs working on my converted app (see attachment).  Each tab is it's own box under each other.  Clicking the tabs does nothing.    Example 57 works fine so I'm assuming I'm missing some setting. 

I already tried replacing my web folder with the one from example 57.  I just can't find whatever setting I need to change in my app to get them working again.

[attachment deleted by admin]

48

Web Server - Ask For Help / Mixed secure sever

« on: August 27, 2009, 12:13:10 PM »

I am trying to make a server that has secure and insecure pages.  When I navigate to a page that is set to only be served in SSL I get a page can not be displayed error.  Chrome also give me the following: Error 324 (net::ERR_EMPTY_RESPONSE): Unknown error.

If I manually change the http to https it works fine.  Also redirecting all traffic to secure works.

49

Web Server - Ask For Help / Insert only form?

« on: July 31, 2009, 02:40:17 PM »

I use a form to that allows users to register them selfs with the web site.  However a clever individual could use this same form to view or even change the information of other users.

What is the best way to prevent this kinda of action?

50

Web Server - Ask For Help / Forms creating empty records

« on: July 31, 2009, 01:57:44 PM »

When you use a form to insert a new record a blank recored is instantly created in the file.  The record had no data except for auto numbered fields, even if this defies rules you set in the dictionary.  If you then click cancel the empty record is deleted.  However if you navigate away the record stays in the file.

Since a new record is created every time this is done it can make a big mess of a file.  Is their any way to ether delete the record once you leave the form, or just delay writing it until the form is posted?

51

Web Server - Ask For Help / Filter a browse based on the menu choice

« on: July 08, 2009, 02:31:11 PM »

I want to have multiple menu items that all call the same browse, but filter it differently.  My idea was to store the filter in a session value, but I can not find the correct place to set the value.  If I set it in an embed point for the menu item then all embed point look to get executed in the order of the menu items.  Meaning only the last filter will ever be used regardless of which menu item the user clicked on.  Setting the value with the "onClick" field seems to have the same result.

I'm using NetTalk 4.31 by the way.

52

Web Server - Ask For Help / Dynamic fields

« on: June 25, 2009, 11:35:58 AM »

I want to create a button that when the user presses it 1 or more fields on the form are changed.  In other words, almost exactly what the calculator example does.  However mine doesn't work and I can't figure out why.  As far as I can tell all settings in the form are the same.

In the 2 Validate embed I have:
ISS:Employee = 'Test me!'
p_web.SetValue('ISS:Employee', ISS:Employee)
do value::ISS:Employee