found the answer .. i'm stupid ;) was calling on a ms sql query that referred to the cglobal table .. duh
thanks for the help :-) >>-----Original Message----- >>From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] >>Sent: 02 February 2006 12:21 >>To: CF-Talk >>Subject: RE: help! cgi.global >> >> >>Is the default storage mechanism for Client sessions set to the right db >>in the Administrator? >> >>Or is this some other table named Cglobal? I'm assuming it is dealing >>with client sessions because of the name of the table. >> >>Steve >> >> >>-----Original Message----- >>From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] >>Sent: Thursday, February 02, 2006 7:09 AM >>To: CF-Talk >>Subject: RE: help! cgi.global >> >> >>Hi Steven, >> >>I've configed another db and other sites are using it ok. >> >>It's only on this site and with one query I'm seeing the error. >> >>jenny >> >> >>>>-----Original Message----- >>>>From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] >>>>Sent: 02 February 2006 12:06 >>>>To: CF-Talk >>>>Subject: RE: help! cgi.global >>>> >>>> >>>>Jennifer, >>>> >>>>Looks like your database for client variables wasn't configured. If >>you >>>>go into the CF Administrator there should be an option to create the >>>>tables you need. >>>> >>>>Steve >>>> >>>> >>>>-----Original Message----- >>>>From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] >>>>Sent: Thursday, February 02, 2006 6:58 AM >>>>To: CF-Talk >>>>Subject: help! cgi.global >>>> >>>> >>>>I've just moved a site to a new server and I've set up a separate >>>>database >>>>for the client variable store. >>>> >>>>I changed the value in my application.cfm, but I'm getting the >>following >>>>error on some pages: >>>> >>>>Error Executing Database Query.[Macromedia][SQLServer JDBC >>>>Driver][SQLServer]Invalid object name 'dbo.CGLOBAL'. The specific >>>>sequence >>>>of files included or processed is: >>>>C:\Inetpub\chicksnchaps.co.uk\search\browse.cfm >>>> >>>>So the application is still looking for the tables in the old >>location. >>>> >>>>How do i solve this please? >>>> >>>>Thanks, Jenny >>>> >>>> >>>> >>>> >>>> >>>> >> >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231089 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
