Re: why "SESSION scope is not enabled" error on new server?
Oracle defaults table names etc to uppercase if you don't quote them (so it coverts statements in the background). On 4/26/07, Rick Root wrote: > > I don't remember having a case problem with table names when we ran > Oracle on Linux either... probably because the tables are not in > separate files managed by the file system. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276370 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: why "SESSION scope is not enabled" error on new server?
yes, i have experienced this: you do have to match case in your SQL statements - Original Message From: stylo stylo <[EMAIL PROTECTED]> To: CF-Talk Sent: Thursday, April 26, 2007 5:35:09 AM Subject: Re: why "SESSION scope is not enabled" error on new server? Next time I'll google first: http://www.firstserv.com/support/sharedHosting/coldfusion/coldfusionLinuxConversion.cfm Still curious why application would be capitalized; guess something internal, huh? >>Table names are case sensitive. -doesn't mention the field names. Do you know? I know there is also some ini setting in mysql to force lower case; I guess I still would have to change the queries to lowercase then, huh? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: why "SESSION scope is not enabled" error on new server?
On 4/26/07, stylo stylo <[EMAIL PROTECTED]> wrote: > > Still curious why application would be capitalized; guess something internal, > huh? Because Coldfusion only looks for "Application.cfm" rather than looking for TWO files, and to avoid any confusion should Application.cfm and application.cfm both exist. In windows, it looks for "Application.cfm" and doesn't worry about case because althoug the filenames have case in them, searches are case insensitive. As for table names and such.. it depends on the database. I know in MySQL with MyISAM tables, the table names are case sensitive. The field names aren't because they're not managed by the file system, but the TABLES are because they *ARE* managed by the file system. BTW, that does NOT apply to MySQL on Windows. I don't remember having a case problem with table names when we ran Oracle on Linux either... probably because the tables are not in separate files managed by the file system. I'm not sure if case is relevant for InnoDB tables in MySQL on unix or not. Rick ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276297 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: why "SESSION scope is not enabled" error on new server?
Next time I'll google first: http://www.firstserv.com/support/sharedHosting/coldfusion/coldfusionLinuxConversion.cfm Still curious why application would be capitalized; guess something internal, huh? >>Table names are case sensitive. -doesn't mention the field names. Do you know? I know there is also some ini setting in mysql to force lower case; I guess I still would have to change the queries to lowercase then, huh? ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276292 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: why "SESSION scope is not enabled" error on new server?
> Capital A for Application. > Windows spoils you :-) Do you mean the file itself must always be named Application.cfm? Why exactly? Slightly off-topic, am I correct that db table names must match case as well? What about field names within tables? I see some serious search & replace in my near future. Thanks. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: why "SESSION scope is not enabled" error on new server?
On Thursday 26 Apr 2007, stylo stylo wrote: > yet application.cfm has: > Worked fine locally or on old host. Newly on linux if that makes any > difference. Capital A for Application. Windows spoils you :-) -- Tom Chiverton Helping to assertively deliver extensible interfaces on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276281 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
why "SESSION scope is not enabled" error on new server?
New bd7 server, just setting up a very simple site but getting the error: The requested SESSION scope is not enabled. yet application.cfm has: BD is set to regular sessions, not j2ee, cookie storage. Worked fine locally or on old host. Newly on linux if that makes any difference. Ideas??? ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276279 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
