noel - thank you so very kindly for your solution...unfortunately the design of the tables is so evil that after beating my brains out with this darn thing...I am stopping...

I wouldn't make any comments on the dating issue either except to say that I've told remi only about 10 times in as many weeks to G.A.L....

magyar - did you have time to take a look at the shortcut syntax i sent you ?! that should cut down considerably on your typing...

never mind...i just saw that...

you could play around with this shortcut syntax:

with MyCmd

.ActiveConnection = my connection

.CommandTimeout =...

well - bob day is in the process of "beating it to death"....let him tell us whether he's been flogging a dead horse or whether he's managed to draw some...

i have some vb code samples...hopefully asp should be similar ?!?!?!

magyar..what happened to the uniqueID that you were to have ?! don't see any mention of that...!!!

Dim objCmd As ADODB.Command

Set...

Just aiming for that dull old documentation specialist job that noel may have that nobody in their right minds would ever want....

mean this in all earnestness...no teasing involved at all...

if this ever happens that the two of you land up under the same roof I think the very air around you...

don't have time to worry about anything except my own problems right now...

i was just teasing remi...i know how wonderful & capable you...

also tell him that if he wants to be dba in your team then the right attitude is..."so what if it's a monster...I'll be happy to code it...as soon as...

this is becoming funny...mike...see noel's last post...

I just posted that After Bob mentioned that pictures numbers were his way of differentiating them.........

you see I am not expensive either......

you certainly aren't noel - though if you were a piece of software you should be.......for all the...

thank you for throwing that in noel...otherwise I'd have thought that it's only my clients who're tightfisted (& unreasonable) enough to want much more bang for their meager bucks!

what if the PictureNames are 'camel 1', 'camel 2' etc...?!

remi...am using same thread...it is about the same subject....

I have 5 tables in all that're involved in this trigger:

1) 2 tables are lookup tables that have the following columns and...