Returning to this... I forgot to add that you need to put the code for the Delete transaction before the Insert / Update transaction.

This might apply if your hosting server uses Plesk. Hope this might help anyone else who has been ambushed by this problem! Here's what happened and here's how we fixed it: We host several sites using MX Kollection / ADDT on a VPS from a large hosting company, using Linux, Apache and Plesk 11. Occas...

Thanks Fred, I'll have a look at this.

We have a database that holds weekly employee shift information. There are up to 7 (daily) shifts for each job function. Each employee shift is a different record - example fields: (user_id, user_name, date, start_time, end_time, header_id) etc. Each week therefore consists of several records, group...

Hi everyone, I was going to post this as a query, but while writing this the solution occured to me, so I thought I would share it: I have a DB table that logs User activity. Every time a record is added, changed or deleted, it will store the User id and the transaction type (add, change, delete). I...

Hi Fred,

Thanks for your help, this works very well. I even managed to include a dynamic date for 7 days ago in the error message, using a dummy recordset.

I have not really used the Throw Error function before - this has been a real eye opener.

Michael

Hi - I want to ensure that any date entered in a form is no more than 7 days ago.

I know how to ensure that the date is greater than current by using the {NOW} expression.

Does anyone know the syntax for 7 days ago? {NOW-7} and {NOW}-7 don't work.

Thanks in advance,

Michael Bullard

Hi Fred

I was just looking through the forum, when I came across the old MX Kollection 3 documentation. Thanks for putting this up, I have missed it when solving problems.

You are a star!

Regards

Michael

Hi Fred Thanks for your reply. I can see why you are confused. I don't use the Nextensio feature very often and didn't realise that I had to create a 'form' page to go with the list! I have tried doing this, but it won't display. I just get a blank screen and no error message. As Adobe have removed ...

Hi Everyone I have a list of Job Applications posted to a recruitment site, together with CVs attached in Word or PDF format. We want to do bulk deletes of old Applications, together with associated files. I can do this for individual records using the standard Delete Record SB and the associated SB...