SQL help - Copy a record

[dubnet.co.uk]

Is it possible copy a record (with all its related records in other tables) with a single SQL statement?

Please help.

[Dan Bracuk]

The answer was yes, until you added the part about the related records.

[dubnet.co.uk]

I am not able to answer any questions in this CF forum as Ima Flash developer.

I know there must be a SQL statemet similar to UPDATE which may make my quest complete!

Your help is appreciated.

[Dan Bracuk]

Originally posted by: dubnet.co.uk
I am not able to answer any questions in this CF forum as Im a Flash developer.
I know there must be a SQL statemet similar to UPDATE which may make my quest
complete!
Your help is appreciated.

But there isn't. It brings up the question though, if you have the records
available, why do you need to copy them?

[dubnet.co.uk]

its because I am using this particular record as a blue print to instantiate
other new records. The user can then use that as a starting point to modify its
relationships accordingly.

My SQL is not strong enough to query then create a new record with that query
result so I thought there may be a cloning tag/function that may do this ie.
look at a record and cascade down do its leaf node if you like and then dumb it
put into a new record.

or am i just going off into a dead end?

[Dan Bracuk]

The user can use that as a starting point to modify it's relationships? You got an example in mind?

[dubnet.co.uk]

there isnt anything special going on here, but I will try and give an example.
In fact this is what Im trying to do:

One CMS with one DB. The DB has a main table. Each record in this main table
represents one website/intranet site that the CMS creates. Each record is also
linked to other tables through relationships.

An administrator builds a particular site which may be used for a particular
learning function. This site structure, once built, can be used to serve other
learning functions, if there is a way of 'cloning' the site (record) into
another new record.

I hope this makes sence...

[philh]

Add another table that identifies a certain site record as a template:

ID int autonumber (identity, whatever)
Site_FK (the foreign key to the site table
template_category varchar(1024)
template_description varchar(max)

Once you have this, you can use its records as a basis to reproduce the site.
This function would not be a "simple SQL statement", but a full-blown stored
procedure.

Good luck.