MSSQL -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Mandel Sent: Thursday, June 02, 2005 1:19 PM To: CFAussie Mailing List Subject: [cfaussie] Re: CFQUERYPARAM - please explain
Stupid question but - what DB are you guys working from? This may be specific to SQLServer (I know Steve uses it), because I've never seen it on Oracle or mySQL. Just a thought at narrowing it down. Mark On 6/2/05, Phil Rasmussen <[EMAIL PROTECTED]> wrote: > I have also copped this problem every now and after adding new fields to a > table and having cfqueryparam based queries die for no reason. In the past I > have just changed the datasource in cfadmin to point to a non-existent > database, saved this, then changed it back and resaved. This causes the > datasource to be recreated and flushed, and the new table schema will then > be accessible by cfqueryparam. > > That "Maintain Connections" settings looks like a much more elegant solution > as long as it has no undesired onflow effects. -- E: [EMAIL PROTECTED] W: www.compoundtheory.com ICQ: 3094740 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
