Quick question for the list. Does anyone know of a way to execute a CREATE statement from ColdFusion with Visual Foxpro on the back end? I've successfully run some other DDL statements (ALTER TABLE ADD column, DROP TABLE), but when I try to execute a CREATE statement, I get a "File access is denied" error. I'm assuming that this has something to do with the fact that while the other DDL statements affect .dbf files that already exist, the CREATE statement requires the creation of a new .dbf file, and there's something about try to do that on the fly that either ColdFusion or Foxpro doesn't like... Could it be that ColdFusion or Foxpro is attempting to create the file in a directory other than the current template directory (access rights to the current directory are wide open)? Any other thoughts? --IronFury PS - for anyone that's interested, I finally figured out the Advanced Security problem. Apparently, at some point in setting up one of the contexts, SiteMinder only INSERTed one of two crucial rows into its database. Blowing the context (with associated rules and policies) away and recreating worked out fine. One other note: the Forta books say you don't have to specify an Action for your Rules if the Action is Execute. This is *NOT* true. You must always specify an Action when setting up a Rule; otherwise, you get unexpected results. ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
