Messages

1171

Web Server - Ask For Help / Re: Refresh Menu and select menu item after login

« on: August 11, 2007, 08:48:46 PM »

yep - just set a session variable when they log in and use this in the hide condition.

1172

Web Server - Ask For Help / Re: Track operator activity

« on: July 26, 2007, 01:41:35 AM »

Hi Alan,

to switch SQL databases do you just create a session variable when the user logs on of what DB they use and then as you pass through this embed to connect to that DB?

I'm currently running 2 exe's on 2 ports to support multiple DB's but I can see this getting messy as we roll out more DB's.

If you have time I would love to see what code you have in the process link embed to achieve this...

Cheers,

Kevin

1173

Web Server - Ask For Help / SendMail

« on: July 17, 2007, 07:44:35 PM »

Using the SMTP send mail procedure.

I also use Capesoft Mail server (very good BTW) and have it set to use authentication.

I can't seem to see where I can set a username and password as a paramter to the smtp server.

Will this be a problem?

Cheers,

Kevin

1174

Web Server - Ask For Help / Lookup

« on: July 17, 2007, 07:42:09 PM »

I want to be able to lookup a Supplier list based on the currency and the supplier name the user has entered.

I tracked this line of code down...

        packet = clip(packet) & p_web.CreateStdButton('submit',Net:Web:LookupButton,loc:formname,p_web._MakeURL(clip('LookupVendor')&'?file=VENDOR&LookupField=L:VendorName&Tab=3&ForeignField=VEN:NAME'),'right_fram')


Can I pass more than parameter so it restricts the list to just suppliers from one Currency and lands on the right supplier?
or should I just set a session variable and use this in the lookup filter?
In the lookup screen is the filter done before it tries to match the filed?
If not what will happen if it lands on a supplier that is then filtered away?

Cheers,

Kevin

1175

Web Server - Ask For Help / Re: File Hyperlink on a Browse

« on: July 06, 2007, 04:38:32 AM »

or c) copy the file from its original location to below web and put $$$ in front of it and serve it up. This is actually very quick and effective and $$$ files are cleaned up automatically...

1176

Web Server - Ask For Help / Drop List

« on: July 05, 2007, 07:12:59 PM »

Hi All,

I need to add a simple drop list to a form with values Service|Inventory|Hire, update a field on the form with either S, I or H and conditionaly hide\unhide fields on the form based on the selection.

I can only see where I can populate the drop list from a File.

Cheers,

Kevin

1177

Web Server - Ask For Help / Re: Session Variable Question

« on: June 28, 2007, 01:42:30 AM »

Thanks Bruce, 1 database is not an option as the data is already in separate databases. I have written a program that runs through and checks multiple sql databases so I think I had to disconnect and reconnect. I'll give it a go. If not I will just run multiple web server programs unless you think that is a bad idea.

Kev

1178

Web Server - Ask For Help / Re: Session Variable Question

« on: June 27, 2007, 01:05:57 AM »

Bruce from what you said here, does this also apply to MSSQL? Do I have to issue any prop:sql Use data base etc?

Cheers,

Kevin

1179

Web Server - Ask For Help / IE6 and png Images

« on: June 22, 2007, 01:26:30 AM »

Doing all my testing on Firefox and everything looks great!

Cranked up IE6 and all the png images on buttons etc that have transparent backgrounds now display with an ugly black background. Any way to fix?

Also, tested on Safari and the buttons for the browse (first, Next, Previous and last) display vertically not horizontally. Where do I look to try and fix this one?

Cheers,

Kevin