accessing SQL Stored Procedures?
Hi How do I access/refer/actuate SQL 6.5 Stored Proceedures from within a .cfm page? Thanks! * john * __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Upgrading SQL 6.5 - 7.0?
Ben Thanks for your comments. I feel more confident heading into this project. Thanks, * John * --- "Benjamin S. Rogers" <[EMAIL PROTECTED]> wrote: > All in all, it was one of the smoothest upgrades (of that relative > magnitude) I've ever done. We upgraded about 20 or so databases of varying > size and complexity. The only issues we ran into were the fault of bad > programming on the developer's part. > > Some badly designed SQL Queries quit running after the upgrade. On the > average, each query took only a moment to fix. For instance, the SQL Server > 7 syntax validator seems to be a little more judicious about what it will > let pass: SQL Server 6.5 only seems to check whether or not a character, > word or phrase is allowed but not necessarily the syntax in which it is used > (e.g. stray semi-colons). > > The only other issue we had was also the fault of bad programming on the > developer's side. Some of our developers got into the bad habit of using > some reserved words. If I remember correctly, SQL Server prefixed an > underscore to column names named after a word that SQL Server 7 put into use > (e.g. "Date"). Where we got hit the hardest was with a table that was named > "Logins." I don't believe "Logins" was on the reserved list, but SQL Server > 7 adds several more system tables to each database, one of which is called > "Logins." In this instance, the data simply did not transfer. We had to > import the data separately into a table of a different name, change a few > foreign key constraints, and change the SQL queries that used the table. > None of which was terribly difficult. > > Anyway, everything you need to perform the upgrade should be on the SQL > Server 7 CD ROM. After the upgrade, you'll just have to test your sites and > monitor the ColdFusion error logs to determine what errors are occurring > because of the upgrade. The SQL Server upgrade utility will notify you upon > completion if any data fails to transfer from SQL Server for whatever > reason. I believe it pipes it out to a text file, if I remember correctly. > > In any case, go for it. In our collective opinion, SQL Server 7 is a vastly > superior product. In our situation it solved far more problems than it > caused. > > Benjamin S. Rogers > Web Developer, c4.net > voice: (508) 240-0051 > fax: (508) 240-0057 > > -Original Message- > From: JB Mentzer [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 07, 2000 3:59 PM > To: [EMAIL PROTECTED] > Subject: Upgrading SQL 6.5 - 7.0? > > > Hi > > Has anyone on list overseen a project to upgrade a CF site's SQL backend > from v6.5 to 7.0? > > I've been asked to quote a price for this project ... and haven't a clue > what this entails (I'm familiar with SQL 7, but not 6.5) > > Any advice/related experience would be greatly appreciated. > > * john * > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
not seeing debug information ...
Hi I've put my PC's IP in the CF Admin Debug settings window. When I view pages, none of the debug info displays. When I remove all of the IP addresses, the debug info displays. When I put my IP in alone, no dice. FWIW, the CF Server can ping my PC by name. Any ideas why this is? Thanks, * john * __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Session Management Errors
Hi I have an Application.cfm file with this code: That generates the following error: Attempt to access a Session variable when session management is not enabled. Use the CFAPPLICATION tag to enable session management. Note: This feature may have been disabled by the site administrator. The error occurred while evaluating the expression: SESSION.datasource = "Webacctg" The error occurred while processing an element with a general identifier of (CFSET), occupying document position (18:2) to (18:40) in the template file C:\Inetpub\wwwroot\accounting\Application.cfm The specific sequence of files included or processed is: C:\INETPUB\WWWROOT\ACCOUNTING\APPLICATION.CFM * * * * * When I comment the the page works correctly. Also, where would I enable Session Management if it was disabled by the Administrator? Thanks in advance, * john * __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SQL Question (sorta OT)
Hi all Here the query I'm trying to edit: SELECT CompanyName, City, State, CompanyURI FROM Main (Index=ix_Main_CompanyURI) WHERE CompanyURI IN (#QuotedValueList(CompanyNameSearch.Custom1)#) ORDER BY CompanyName I would like to add "omit <> 'yes' " to the WHERE clause. When I do this, the query returns 0 records (unmodified, it returns 25 records). Any ideas are greatly appreciated. * John * __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
disappearing session variables
Hi all I'm using IE 5 and Nestcape 4.72 to develop a site for a client. I sometimes experience this error: "Error resolving parameter SESSION.PRODUCT_LINEThe session variable PRODUCT_LINE does not exist." This session.variable is defined and called on the site's home page. It's called again when users drill down to the next level. I use it to keep track of which of two product lines the user is browsing. When I browse this site on my laptop/dev server using it's IP address (192.168.x.x), the site runs ok in IE, but chokes on the 2nd page in Netscape. It works in IE if I use either 127.0.0.1 or localhost as the domain. Netscape only likes localhost. Are session vars handled differently between the browsers? What would prompt Netscape to drop a session var? Does browsing by the 192.168.x.x address differ from browsing by 127.0.0.1 and/or 'localhost'? Assistance resolving this would be greatly appreciated. * john * __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: disappearing session variables
Lon, et al --- Lon Lentz <[EMAIL PROTECTED]> wrote: > > Is Netscape issuing a new cookie on the second page because it thinks > that the domain has changed? The domain doesn't change between pages. I didn't think browsers issued cookies? * john * > > -Original Message- > > From: c talk [mailto:[EMAIL PROTECTED]] > > Sent: Monday, February 04, 2002 4:16 PM > > To: CF-Talk > > Subject: disappearing session variables > > > > > > > When I browse this site on my laptop/dev server using it's IP address > > (192.168.x.x), the site runs ok in IE, but chokes on the 2nd page > > in Netscape. > > It works in IE if I use either 127.0.0.1 or localhost as the > > domain. Netscape > > only likes localhost. > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists