Well, even SQL Server pays attention to foreign key constraints. From SQL
Manager, if you try to drop a table that has constraints defined for it,
it'll stop you. You'd have to have check constraints turned off to just drop
a table or have SQL Server do a delete on all the rows. And if you had check
constraints turned off, it would be off for anything that sent a command to
the db, including Spectra.
I'm concerned because I think it sounds like an attack. Is there a URL that
could be generated by someone who knows enough about Spectra to be able to
exploit it to have it call the cf_generatetables tag or some method of an
object that would delete the contents of the objects table?
Ed
>>-----Original Message-----
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>>Sent: Tuesday, May 29, 2001 4:56 PM
>>To: Spectra-Talk
>>Subject: RE: CODB vanishing
>>
>>
>>Just want to make sure all things are being considered.
>>
>>Anything is technically possible at this point.
>>
>>I just cannot imagine how Spectra could seemingly run a
>>delete * on all the
>>tables. I would think even if a delete * {tables} was
>>submitted it would
>>have a hard time deleting rows due to the foriegn key constraints.
>>
>>Perhaps a Drop Table then a Create Table was performed during
>>an aborted
>>reinstall, or
>>
>>Maybe someone ran cf_generatetables by itself, that would do it.
>>
>>
>>Mike
>>-----Original Message-----
>>From: Ed McLaughlin [mailto:[EMAIL PROTECTED]]
>>Sent: Tuesday, May 29, 2001 2:01 PM
>>To: Spectra-Talk
>>Subject: RE: CODB vanishing
>>
>>
>>>>
>>>>Were the columns there? By blank you mean no rows?
>>>>
>>>>Never have seen or heard of anything like this before.
>>>>Sounds like a MSSQL
>>>>issue more then Spectra at this point.
>>
>>That's a pretty broad jump you've made there, Mike. What part
>>of this sounds
>>like an MSSQL issue, other than that the content object database is
>>installed on it? Have you come across situations where SQL Server
>>arbitrarily drops all the data in a table or tables?
>>
>>>>
>>>>Mike
>>>>
>>>>-----Original Message-----
>>>>From: Govinda Alangar [mailto:[EMAIL PROTECTED]]
>>>>Sent: Tuesday, May 29, 2001 11:53 AM
>>>>To: Spectra-Talk
>>>>Subject: RE: CODB vanishing
>>>>
>>>>
>>>>Sorry, let me clarify.
>>>>
>>>>All the tables existed but just blank :-)
>>>>
>>
>>s/spectra_talk or send a message to
>>[EMAIL PROTECTED]
>>with 'unsubscribe' in the body.
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
