Search found 15 matches

by Accumike
2015-02-27 13:55
Forum: MX Kollection - Pro Edition
Topic: How to Link Insert to Delete Transaction
Replies: 1
Views: 6743

Re: How to Link Insert to Delete Transaction

Returning to this... I forgot to add that you need to put the code for the Delete transaction before the Insert / Update transaction.
by Accumike
2015-02-16 13:25
Forum: MX Kollection - General Info
Topic: Plesk Session Problem
Replies: 0
Views: 19751

Plesk Session Problem

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...
by Accumike
2014-11-25 18:55
Forum: ADDT
Topic: Insert multiple rows in database
Replies: 2
Views: 8879

Re: Insert multiple rows in database

Thanks Fred, I'll have a look at this.
by Accumike
2014-11-14 12:43
Forum: ADDT
Topic: Insert multiple rows in database
Replies: 2
Views: 8879

Insert multiple rows in database

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...
by Accumike
2014-07-29 12:23
Forum: MX Kollection - Pro Edition
Topic: How to Link Insert to Delete Transaction
Replies: 1
Views: 6743

How to Link Insert to Delete Transaction

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...
by Accumike
2013-07-12 12:09
Forum: MX Form Validation
Topic: Date Validation
Replies: 2
Views: 56157

Re: Date Validation

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
by Accumike
2013-07-10 15:00
Forum: MX Form Validation
Topic: Date Validation
Replies: 2
Views: 56157

Date Validation

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
by Accumike
2012-12-13 12:39
Forum: MX Kollection - General Info
Topic: Interakt Documentation
Replies: 0
Views: 19784

Interakt Documentation

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
by Accumike
2012-10-11 17:30
Forum: NeXTensio
Topic: Delete Detail Records
Replies: 3
Views: 58414

Re: Delete Detail Records

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 ...
by Accumike
2012-10-01 12:42
Forum: NeXTensio
Topic: Delete Detail Records
Replies: 3
Views: 58414

Delete Detail Records

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...