* This is the modus mailing list *
For those using MS SQL and the Extended Database a simple script would
actually cure this problem for you:
---
UPDATE [ModusTable]
SET [FullName] = [EmailAddress]
WHERE [FullName] = '' OR [FullName] = Null
---
You will need to check the column names as I didn't refer to an Extended
Database to write the above query, in addition check the table name!
This basically takes the email address and copies it to the fullname
copy if there is no entry already.
---
Never knock on Death's door. Ring the doorbell and run (he hates that)
(--------------------------------) {((((((
( Suneel Jhangiani ) /_ _ )
( Technical Director ) ( . . )
( Inter-Computer Technology Ltd. ) ( / )
(----------------------------------oOOo------------oOOo----)
( 40 James Street Tel: +44 (0) 20 7486 9601 )
( London W1U 1EU Fax: +44 (0) 7050 678 978 )
( United Kingdom Email: [EMAIL PROTECTED] )
( Website: http://www.inctech.com )
(----------------------------------------------------------)
-----Original Message-----
From: Lewis Watson [mailto:[EMAIL PROTECTED]
Sent: 03 December 2003 18:25
To: [EMAIL PROTECTED]
Subject: [Modus] Return Address / FEATURE REQUEST
* This is the modus mailing list *
Hi John,
True, they need to fix it regardless of the type of auth type utilized.
I
guess I am just thinking it should be trivial to have another field used
in SQL.
Thanks,
Lewis
**
To unsubscribe, send an Email to: [EMAIL PROTECTED]
with the word "UNSUBSCRIBE" in the body or subject line.
