RE: JOIN help
Cedric, I didn't examine the query too well in the first place. The outer join doesn't work because of the filter on the table you want nulls in. I would suggest a UNION instead of an outer join. I'm not sure it's the most efficient solution though. SELECT Q.QueueID, XUQ.AccessID, Q.QueueName FROM Queues Q JOIN SecurityXrefUserQueues XUQ ON XUQ.QueueID = Q.QueueID WHERE XUQ.UserID = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#url.uid# UNION SELECT Q.QueueID, NULL AS AccessID, Q.QueueName FROM Queues Q WHERE Q.QueueID NOT IN ( SELECT XUQ.QueueID FROM SecurityXrefUserQueuesXUQ WHERE XUQ.UserID = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#url.uid# ) Pascal -Oorspronkelijk bericht- Van: Cedric Villat [mailto:[EMAIL PROTECTED] Verzonden: za 15/11/2003 17:12 Aan: CF-Talk CC: Onderwerp: Re:JOIN help No such luck. I had tried that earlier, but tried again just to make sure. A left and right join just return 1 row: UserIDQueueID AccessID 2 1 0 I never get the NULL row. Any more ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: JOIN help
Pascal Peters wrote: SELECT Q.QueueID, XUQ.AccessID, Q.QueueName FROM Queues Q JOIN SecurityXrefUserQueues XUQ ON XUQ.QueueID = Q.QueueID WHERE XUQ.UserID = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#url.uid# UNION SELECT Q.QueueID, NULL AS AccessID, Q.QueueName FROM Queues Q WHERE Q.QueueID NOT IN ( SELECT XUQ.QueueID FROM SecurityXrefUserQueuesXUQ WHERE XUQ.UserID = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#url.uid# ) How about: SELECT q.ID, uq.AccessID, cfqueryparam cfsqltype=CF_SQL_INTEGER value=#url.uid# AS userID FROM queues q LEFT OUTER JOIN ( SELECT uq.userID, uq.AccessID, uq.queueID FROM userqueues uq WHERE userID = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#url.uid# ) uq ON q.ID = uq.queueID; Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
HTML e-Newsletter
I'm looking for a tutorial that would explain how to send HTML e-Newsletters. I am particular interesting in finding out how include graphics in the message. Any advice would be useful. Dwayne Cole, MS in MIS, MBA Florida AM University Certified Advanced ColdFusion Developer 850-591-0212 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: HTML e-Newsletter
Dwayne, On Sunday, November 16, 2003, 9:00:58 AM, you wrote: DC I'm looking for a tutorial that would explain how to send HTML DC e-Newsletters. I am particular interesting in finding out how DC include graphics in the message. Any advice would be useful. All you need to do is code the images as you would for a regular HTML file, but make the SRC values absolute: img src=""> The images don't actually get attached to the message, rather, they are loaded from yourdomain.com when the message is read. ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Very vague error message
Hello I have a rather large page of code which ive been working on, and I get the following error: This _expression_ must have a constant value. It doesn¹t give me a line number, or a code snippet, just that text. As I said I have a lot of code (1000+ lines) and I cant quite tie down the problem... Has anyone come across this before? Thanks, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
HELP - Logout (sessionDelete, StructClear)?
I have written an application that allows a user to log in. When the user logs in I run the following code... I first check to see if the user exisits. If so... CFIF CheckUser.RecordCount GREATER THAN 0 CFSET Session.LoggedIn = True CFELSE CFSET Session.LoggedIn = False /cfif Then I set some session variables CFIF Session.LoggedIn EQ True CFSET Session.AuthUserID = Trim(CheckUser.UserID) CFSET Session.AuthMemberID = Trim(CheckUser.member_id) CFSET Session.AuthAccountTypeSeller = Trim(CheckUser.accounttypeseller) CFSET Session.AuthAccountTypeBidder = Trim(CheckUser.accounttypeBidder) SCRIPT LANGUAGE=_javascript_ self.location ='https://foo'; /SCRIPT CFELSE return them to the home page /cfif This works fine. The problem I am having is that when they press logout. It does not really logo them out. Here is my logout code... CFSET StructDelete(Session, LoggedIn) CFSET StructDelete(Session, AuthUserID) CFSET StructDelete(Session, MemberID) CFSET StructDelete(Session, AuthAccountTypeBidder) CFSET StructDelete(Session, AuthAccountTypeSeller) CFIF isDefined(session.AuthUserID) Log Off Failed CFELSE Logging Off. cflocation url="" addtoken=no /cfif It does send them back to the home page, but if I log in with a different ID, I am still accessing the site with the account I just logged out with. HELP...I have tried everything I could think of and it is still not logging them out. I have an application file running with this... cfset hrsBeforeTimeout = 2 cfapplication name=Inside clientmanagement=Yes sessionmanagement=Yes sessiontimeout=Yes applicationtimeout=Yes CFPARAM name=session.LoggedIn DEFAULT=FALSE cfparam name=BidPlaced default=0 Not sure if that will make a difference. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: HTML e-Newsletter
That might help: http://www.easycfm.com/tutorials/pdf_output.cfm?tutorial_id=14' Uwe DC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: JOIN help
Jochem, Thanks, that worked like a champ. I had a solution using 2 queries, but that wasn't really elegant. This should be much better. Thanks! Cedric Subject: JOIN help From: Jochem van Dieten [EMAIL PROTECTED] Date: Sun, 16 Nov 2003 13:53:17 +0100 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=28709forumid=4#144210 Pascal Peters wrote: SELECT Q.QueueID, XUQ.AccessID, Q.QueueName FROM Queues Q JOIN SecurityXrefUserQueues XUQ ON XUQ.QueueID = Q.QueueID WHERE XUQ.UserID = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#url.uid# UNION SELECT Q.QueueID, NULL AS AccessID, Q.QueueName FROM Queues Q WHERE Q.QueueID NOT IN ( SELECT XUQ.QueueID FROM SecurityXrefUserQueuesXUQ WHERE XUQ.UserID = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#url.uid# ) How about: SELECT q.ID, uq.AccessID, cfqueryparam cfsqltype=CF_SQL_INTEGER value=#url.uid# AS userID FROM queues q LEFT OUTER JOIN ( SELECT uq.userID, uq.AccessID, uq.queueID FROM userqueues uq WHERE userID = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#url.uid# ) uq ON q.ID = uq.queueID; Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: HTML e-Newsletter
To add another bit to this: You can do the same thing as ubqtous referenced for images to your style sheet call.Won't work on any kind of web mail, but not sure what your project requirements are.Best used when you know your recipients are using mail clients that can handle this (i.e. Outlook Netscape). Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Ideas needed! Password protect a file download.
Hey everyone, Very soon I'll need to set up a system that will let users download files. The users will need to be logged in, so I'll be checking for a username and password before I let them download the file. The part I'm not sure about is protecting the file itself. I want the file to be protected so no one can brows to it by http. Someting similar to download.com, where the file just starts downloading automaticly would be great. How do they (download.com) have the file auto-download without a user having to right click on the file?? Any suggestions toward any of this would be most helpful. Thanks! Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ideas needed! Password protect a file download.
The part I'm not sure about is protecting the file itself. I want the file to be protected so no one can brows to it by http. Jeff, A bit of pseudo code for you. cfif loggedin IS true cfcontent reset=yes cfheader name=Content-Disposition value=attachment;filename=thefilenamethatyouwanttheusertosee cfcontent file=Yourfilethatisntinyourwebrootincludingthefullpath type=putyourmimetypehere cfelse h3Access denied!/h3 /cfif Put this into a .cfm file and try it out.. Obviously, you need to set the filenames and mime types correctly.. I use a piece of code like this for zip files on our server. The getproductquery basically contains the filename of the file I want to send to the user. cfheader name=Content-Disposition value=attachment;filename=#Trim(getproduct.Filename)# cfcontent file=#GetDirectoryFromPath(GetCurrentTemplatePath())##Trim(getproduct.F ilename)# type=application/x-zip-compressed Yours Paul Vernon http://www.web-architect.co.uk http://www.web-architect.co.uk/ t: +44 (0)844 779 9797 m: +44 (0)7887 952591 f: +44 (0)844 779 9797 e: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The information contained in this e-mail and any attachment is intended only for the named addressee(s). If you are not the named addressee(s), please notify the sender immediately and do not disclose, copy or distribute the contents to any other person other than the intended addressee(s). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Ideas needed! Password protect a file download.
What you need is cfcontent tag. Set standard security in application.cfm file. Once user is logged in create a page under application.cfm control called download.cfm. In that file place cfcontent tag set for the file you wish user to get. User selects what he wants from index.cfm and gets redirected to download.cfm where download of his choice starts automatically. TK - Original Message - From: Jeff Fongemie To: CF-Talk Sent: Sunday, November 16, 2003 11:33 AM Subject: Ideas needed! Password protect a file download. Hey everyone, Very soon I'll need to set up a system that will let users download files. The users will need to be logged in, so I'll be checking for a username and password before I let them download the file. The part I'm not sure about is protecting the file itself. I want the file to be protected so no one can brows to it by http. Someting similar to download.com, where the file just starts downloading automaticly would be great. How do they (download.com) have the file auto-download without a user having to right click on the file?? Any suggestions toward any of this would be most helpful. Thanks! Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ideas needed! Password protect a file download.
Use CFContent to pass the file to the user, but have it behind a login type thing - then you can check that the user has rights to the relevant file With CFContent you can place the files anywhere on the hard disk, so they can be nowhere near the browsable area -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 11:34 AM To: CF-Talk Subject: Ideas needed! Password protect a file download. Hey everyone, Very soon I'll need to set up a system that will let users download files. The users will need to be logged in, so I'll be checking for a username and password before I let them download the file. The part I'm not sure about is protecting the file itself. I want the file to be protected so no one can brows to it by http. Someting similar to download.com, where the file just starts downloading automaticly would be great. How do they (download.com) have the file auto-download without a user having to right click on the file?? Any suggestions toward any of this would be most helpful. Thanks! Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: Internal/Intranet Search Engines - What to ask the sales critters
Jeremy Brodie wrote: Larry, Some of the critical questions to help you in your search. 1) Do you need to search locally from a CD/DVD or from a server? 2) In what file format is the manual (PDF, word docs, etc) 3) What will you use as your user interface for searching the manual (flash, HTML, etc)? 4) What is your budget? 5) Are there any components of the manual located on the server (diagrams, videos, and so on)? 6) If using a CD, what platforms will the target audiance use? If you're searching directly from a CD/DVD then you'll need to bundle DT search (the others require a server) and create an interface that interacts with the search program either using Flash or Java Swing (assuming not everyone has Windows). Jeremy Brodie Intelix an Edgewater Technology Solutions Company Good questions. As far as I know (remember its a friend who looking at the search engines) its for technicians and engineers who need to access the technical manuals on the shop floor. As far as I know, the computers will all be the same. I've passed along the question list to my friend. Again thanks for your help. larry [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ideas needed! Password protect a file download.
If you put the downloadable files into the web root, then they're not at all protectable by CF. Downloadable files need to be placed somewhere off the web root. -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: November 16, 2003 10:41 AM To: CF-Talk Subject: RE: Ideas needed! Password protect a file download. The part I'm not sure about is protecting the file itself. I want the file to be protected so no one can brows to it by http. Jeff, A bit of pseudo code for you. cfif loggedin IS true cfcontent reset=yes cfheader name=Content-Disposition value=attachment;filename=thefilenamethatyouwanttheusertosee cfcontent file=Yourfilethatisntinyourwebrootincludingthefullpath type=putyourmimetypehere cfelse h3Access denied!/h3 /cfif Put this into a .cfm file and try it out.. Obviously, you need to set the filenames and mime types correctly.. I use a piece of code like this for zip files on our server. The getproductquery basically contains the filename of the file I want to send to the user. cfheader name=Content-Disposition value=attachment;filename=#Trim(getproduct.Filename)# cfcontent file=#GetDirectoryFromPath(GetCurrentTemplatePath())##Trim(getproduct.F ilename)# type=application/x-zip-compressed Yours Paul Vernon http://www.web-architect.co.uk http://www.web-architect.co.uk/ t: +44 (0)844 779 9797 m: +44 (0)7887 952591 f: +44 (0)844 779 9797 e: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The information contained in this e-mail and any attachment is intended only for the named addressee(s). If you are not the named addressee(s), please notify the sender immediately and do not disclose, copy or distribute the contents to any other person other than the intended addressee(s). _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Opinions: Where to Save data for both public and logged in users
I've got an existing site for a large, day festival.The system has three types of identification: 1) SessionID - ID stored in a non-persistent cookie.We store clickstreams (page visits), for example linked to the SessionID. 2) ClientID - ID stored in a persistent cookie.We store, for example, UserAgent stats and group SessionIDs with ClientID. 3) UserID - ID stored in database, but only available when the visitor logs in.All personal information (address, name, etc) is linked to the UserID. For general users log in is not at all mandatory (right now it's only to receive a monthly newsletter).People are generally not used to logging into the site. All of this works fine.Forget, for a moment, the fact that people may disable cookies. Part of the site is a Planner allowing people to mark certain events within our festival and later see them as a personal schedule.In past years this information was always cookie-based: one browser, one plan. This year I'd like to store that data in the database (at the very least this will allow us to perform statistical analysis on the data).It would also be nice to offer storage of the plan as a perk to those who sign up (this also means that the plan would be available on multiple machines). I'm a little (well, a lot) confused by this.I'm wondering what others would expect from this kind of system. It's simple enough to say If not logged in, link the plan to the ClientID, and it's simple as well to say IF they log in link the plan to both the ClientID and the UserID - or just Link the plan to UserID. But if they come back and add events then log in (so there's a current plan and another linked to the UserID and THEN log in what should I do? Replace the current one with the one linked to the UserID?Combine the two? When a signed-in user logs out should I then delete the plan from the current session (meaning they'd have to log in to see it)? If I do maintain ClientID AND UserID what should be done (if anything) about multiple computers? Should it be different the first time?Our sign up is of the we'll send you a password in an email type so they may not be able to log in immediately upon signing up.So should I say If there's a plan linked to the ClientID and NONE linked to the UserID copy it when they sign up, otherwise use only the UserID plan. If I ignore the ClientID plan when logging in that would mean that two people using the same computer could make different plans (linked to unique UserIDs) but that any changes made when NOT logged in would be lost. In short... I'm confused.;^) Any thoughts?I've got no problem actually building any of this: it's the expected user experience that's concerning me (so I suppose that also makes this an off topic post... sorry) Jim Davis [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Compensating for Server Time
Howdy, What's the best way to compensate for time on a server in a hosted environment when the time is set to a different time than a user's local time zone? Ex: client is in Central Time, server is on Eastern Time (one hour ahead); client wants everything to reflect local time. Thanks. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Compensating for Server Time
Chris Montgomery wrote: What's the best way to compensate for time on a server in a hosted environment when the time is set to a different time than a user's local time zone? Ex: client is in Central Time, server is on Eastern Time (one hour ahead); client wants everything to reflect local time. I use the AT TIME ZONE functionality from SQL, it even compensates for daylight savings time: testDB= select '2003-12-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-12-12 12:00:00 testDB= select '2003-07-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-06-12 11:00:00 Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Compensating for Server Time
there is a great little cfc @ cfczone.org that paul hastings whipped up that does some timezone work.best way, is to use _javascript_ to get the time of the browser, set that timezone offset as a cookie on the users browser, then access that with the cookie. whatever you call it variable name in cf, and do the time changes that way.i had to use it extensively on our site, www.navtrak.net, since we have clients whose vehicles report in other time zones than where our servers are located, on the east coast. so, if you have any other questions i can probably help. tony -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 3:55 PM To: CF-Talk Subject: Re: Compensating for Server Time Chris Montgomery wrote: What's the best way to compensate for time on a server in a hosted environment when the time is set to a different time than a user's local time zone? Ex: client is in Central Time, server is on Eastern Time (one hour ahead); client wants everything to reflect local time. I use the AT TIME ZONE functionality from SQL, it even compensates for daylight savings time: testDB= select '2003-12-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-12-12 12:00:00 testDB= select '2003-07-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-06-12 11:00:00 Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Compensating for Server Time
Does that work in SQL 2000? I've always used _javascript_ at logon to determine the time zone of the user's computer.I then store the time zone offset in a cookie or session/client variable.I then use a UDF to convert the time from the SQL server to that user's local time. If there was a way to do this all in one single shot via SQL as it seems you have a solution for below I'd love to try it out.Unfortunately I can't seem to make the example you gave below work in SQL 2000. -Novak -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 12:55 PM To: CF-Talk Subject: Re: Compensating for Server Time Chris Montgomery wrote: What's the best way to compensate for time on a server in a hosted environment when the time is set to a different time than a user's local time zone? Ex: client is in Central Time, server is on Eastern Time (one hour ahead); client wants everything to reflect local time. I use the AT TIME ZONE functionality from SQL, it even compensates for daylight savings time: testDB= select '2003-12-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-12-12 12:00:00 testDB= select '2003-07-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-06-12 11:00:00 Jochem -- Who needs virtual reality if you can just dream? - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Directory, download and cfmail attachment issues
Hi all, We have just moved from Windows to Linux, and CF5 to MX.This move brought a whole host of unpleasant issues with it, mostly having to do with our download process. 1.Does anyone know of a really good zip tag that works with Linux?I loved Ben Forta's cfx_zip on Windows, but can't find one that robust for Linux.Specific problem:I can't find one that will unzip a specific file in an archive that has a zipped folder in it. 2.We store our design files in a non-browser-accessible directory, and then create a zip file in another temp non-accessible directory after purchase.I'm using cfdirectory to create this directory.Most of the time it works, but sometimes for no reason that is apparent to me, it doesn't.(Yeah, as I wrote this I realized that I needed to do a different thing with error handling here, so maybe next time it happens I will get a clue.)Meanwhile, does anyone know why this would happen?It can work sometimes for a particular user and not others. 3.When everything else has worked so far, and the customer's zip file has been created, they can choose download or email.I'm using CFHEADER NAME=Content-Disposition VALUE=attachment; StitcheryMall.zip CFCONTENT TYPE=application/x-zip-compressed FILE=#zipname# deletefile=yes for the download.In our testing, this worked acceptably.It does indeed download the proper file, and for all of our tests (except with Opera), the file ended with .zip.We have customers saying that they are getting .cfm or no extension.Any ideas? 4.When they select email, we use cfmail to=#user.email# from=#me# subject=Stitchery Mall Files spoolenable=no cfmailparam file=#zipname# type=application/x-zip-compressed blah blah blah /cfmail Spoolenable is no because the next thing that happens is that the file gets deleted, and if it is yes, half the time it gets deleted before the message gets sent.The problem here is also the file name.People are getting all sorts of things - and they have forwarded them to me.Generally it is a good file, but often with a .dat or no extension.Any clues here? 5.Some customers are reporting corrupted files.Could this be an issue with the zip tag, or is it more likely part of the download/email process?I suppose it could also simply be their way of reporting a bad file extension. I appreciate any help you can give me.I'm almost too busy sending out files to customers to actually fix anything! Carol Chandler [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
weird one! help :)
i have site director3 and for some reason on my console this is the error i get, when trying to load my order manager... what does this mean?ihave cfabort at line 1.what gives? thanks. tony Error Occurred While Processing Request The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. Please try the following: Check the CFML Reference Manual to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. BrowserMozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705) Remote Address68.33.142.157 Referrer Date/Time16-Nov-03 05:13 PM Stack Trace (click to expand) tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: weird one! help :)
i have site director3 and for some reason on my console this is the error i get, when trying to load my order manager... what does this mean?ihave cfabort at line 1.what gives? I have no idea, but I'd guess that the error is occurring in Application.cfm. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: weird one! help :)
yeah, i thought the same, but on any other page request, no error like that, ive actually narrowed it down to some code in some cfcase tags, its weird... tony -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:27 PM To: CF-Talk Subject: RE: weird one! help :) i have site director3 and for some reason on my console this is the error i get, when trying to load my order manager... what does this mean?ihave cfabort at line 1.what gives? I have no idea, but I'd guess that the error is occurring in Application.cfm. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: weird one! help :)
Weegs, I sure hope you got the monitor in one eye and an NFL game in the other :-) _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:24 PM To: CF-Talk Subject: RE: weird one! help :) yeah, i thought the same, but on any other page request, no error like that, ive actually narrowed it down to some code in some cfcase tags, its weird... tony -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:27 PM To: CF-Talk Subject: RE: weird one! help :) i have site director3 and for some reason on my console this is the error i get, when trying to load my order manager... what does this mean?ihave cfabort at line 1.what gives? I have no idea, but I'd guess that the error is occurring in Application.cfm. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Compensating for Server Time
If you want to it directly from SQL you can create a function and call that from your sql query create function localtime (@gmtdate datetime, @timezoneoffset int) returns datetime As begin declare @localtime datetime select @localtime = dateadd(hh, -1 * @timezoneoffset, @gmtdate) return @localtime end Then it can be called like this select localtime(getdate(), 3) Tim -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 4:54 PM To: CF-Talk Subject: RE: Compensating for Server Time Does that work in SQL 2000? I've always used _javascript_ at logon to determine the time zone of the user's computer.I then store the time zone offset in a cookie or session/client variable.I then use a UDF to convert the time from the SQL server to that user's local time. If there was a way to do this all in one single shot via SQL as it seems you have a solution for below I'd love to try it out.Unfortunately I can't seem to make the example you gave below work in SQL 2000. -Novak -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 12:55 PM To: CF-Talk Subject: Re: Compensating for Server Time Chris Montgomery wrote: What's the best way to compensate for time on a server in a hosted environment when the time is set to a different time than a user's local time zone? Ex: client is in Central Time, server is on Eastern Time (one hour ahead); client wants everything to reflect local time. I use the AT TIME ZONE functionality from SQL, it even compensates for daylight savings time: testDB= select '2003-12-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-12-12 12:00:00 testDB= select '2003-07-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-06-12 11:00:00 Jochem -- Who needs virtual reality if you can just dream? - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: weird one! help :)
but of course ;) -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:34 PM To: CF-Talk Subject: RE: weird one! help :) Weegs, I sure hope you got the monitor in one eye and an NFL game in the other :-) _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:24 PM To: CF-Talk Subject: RE: weird one! help :) yeah, i thought the same, but on any other page request, no error like that, ive actually narrowed it down to some code in some cfcase tags, its weird... tony -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:27 PM To: CF-Talk Subject: RE: weird one! help :) i have site director3 and for some reason on my console this is the error i get, when trying to load my order manager... what does this mean?ihave cfabort at line 1.what gives? I have no idea, but I'd guess that the error is occurring in Application.cfm. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Compensating for Server Time
but how are you going to *KNOW* the persons local time? _javascript_ is the only way. -Original Message- From: Tim [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:35 PM To: CF-Talk Subject: RE: Compensating for Server Time If you want to it directly from SQL you can create a function and call that from your sql query create function localtime (@gmtdate datetime, @timezoneoffset int) returns datetime As begin declare @localtime datetime select @localtime = dateadd(hh, -1 * @timezoneoffset, @gmtdate) return @localtime end Then it can be called like this select localtime(getdate(), 3) Tim -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 4:54 PM To: CF-Talk Subject: RE: Compensating for Server Time Does that work in SQL 2000? I've always used _javascript_ at logon to determine the time zone of the user's computer.I then store the time zone offset in a cookie or session/client variable.I then use a UDF to convert the time from the SQL server to that user's local time. If there was a way to do this all in one single shot via SQL as it seems you have a solution for below I'd love to try it out.Unfortunately I can't seem to make the example you gave below work in SQL 2000. -Novak -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 12:55 PM To: CF-Talk Subject: Re: Compensating for Server Time Chris Montgomery wrote: What's the best way to compensate for time on a server in a hosted environment when the time is set to a different time than a user's local time zone? Ex: client is in Central Time, server is on Eastern Time (one hour ahead); client wants everything to reflect local time. I use the AT TIME ZONE functionality from SQL, it even compensates for daylight savings time: testDB= select '2003-12-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-12-12 12:00:00 testDB= select '2003-07-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-06-12 11:00:00 Jochem -- Who needs virtual reality if you can just dream? - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Compensating for Server Time
read on tony, sorry, i see you were just explaining the way to the sql in one shot :) tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:38 PM To: CF-Talk Subject: RE: Compensating for Server Time but how are you going to *KNOW* the persons local time? _javascript_ is the only way. -Original Message- From: Tim [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:35 PM To: CF-Talk Subject: RE: Compensating for Server Time If you want to it directly from SQL you can create a function and call that from your sql query create function localtime (@gmtdate datetime, @timezoneoffset int) returns datetime As begin declare @localtime datetime select @localtime = dateadd(hh, -1 * @timezoneoffset, @gmtdate) return @localtime end Then it can be called like this select localtime(getdate(), 3) Tim -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 4:54 PM To: CF-Talk Subject: RE: Compensating for Server Time Does that work in SQL 2000? I've always used _javascript_ at logon to determine the time zone of the user's computer.I then store the time zone offset in a cookie or session/client variable.I then use a UDF to convert the time from the SQL server to that user's local time. If there was a way to do this all in one single shot via SQL as it seems you have a solution for below I'd love to try it out.Unfortunately I can't seem to make the example you gave below work in SQL 2000. -Novak -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 12:55 PM To: CF-Talk Subject: Re: Compensating for Server Time Chris Montgomery wrote: What's the best way to compensate for time on a server in a hosted environment when the time is set to a different time than a user's local time zone? Ex: client is in Central Time, server is on Eastern Time (one hour ahead); client wants everything to reflect local time. I use the AT TIME ZONE functionality from SQL, it even compensates for daylight savings time: testDB= select '2003-12-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-12-12 12:00:00 testDB= select '2003-07-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-06-12 11:00:00 Jochem -- Who needs virtual reality if you can just dream? - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Compensating for Server Time
Yes you can detect their time zone everytime they login or what I've done in the past is to build it in to the users profile, so that the user has the ability to select the time zone their in when they create/update their profile. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:38 PM To: CF-Talk Subject: RE: Compensating for Server Time but how are you going to *KNOW* the persons local time? _javascript_ is the only way. -Original Message- From: Tim [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:35 PM To: CF-Talk Subject: RE: Compensating for Server Time If you want to it directly from SQL you can create a function and call that from your sql query create function localtime (@gmtdate datetime, @timezoneoffset int) returns datetime As begin declare @localtime datetime select @localtime = dateadd(hh, -1 * @timezoneoffset, @gmtdate) return @localtime end Then it can be called like this select localtime(getdate(), 3) Tim -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 4:54 PM To: CF-Talk Subject: RE: Compensating for Server Time Does that work in SQL 2000? I've always used _javascript_ at logon to determine the time zone of the user's computer.I then store the time zone offset in a cookie or session/client variable.I then use a UDF to convert the time from the SQL server to that user's local time. If there was a way to do this all in one single shot via SQL as it seems you have a solution for below I'd love to try it out.Unfortunately I can't seem to make the example you gave below work in SQL 2000. -Novak -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 12:55 PM To: CF-Talk Subject: Re: Compensating for Server Time Chris Montgomery wrote: What's the best way to compensate for time on a server in a hosted environment when the time is set to a different time than a user's local time zone? Ex: client is in Central Time, server is on Eastern Time (one hour ahead); client wants everything to reflect local time. I use the AT TIME ZONE functionality from SQL, it even compensates for daylight savings time: testDB= select '2003-12-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-12-12 12:00:00 testDB= select '2003-07-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-06-12 11:00:00 Jochem -- Who needs virtual reality if you can just dream? - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Compensating for Server Time
sure, but just getting it from their browser time is the best way, if you let them input it, they can mess it up, user error, one more thing to tech support. either way is fine, but somethign that is easy to abstract from a dumb customer is always nice! tony -Original Message- From: Tim [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:52 PM To: CF-Talk Subject: RE: Compensating for Server Time Yes you can detect their time zone everytime they login or what I've done in the past is to build it in to the users profile, so that the user has the ability to select the time zone their in when they create/update their profile. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:38 PM To: CF-Talk Subject: RE: Compensating for Server Time but how are you going to *KNOW* the persons local time? _javascript_ is the only way. -Original Message- From: Tim [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:35 PM To: CF-Talk Subject: RE: Compensating for Server Time If you want to it directly from SQL you can create a function and call that from your sql query create function localtime (@gmtdate datetime, @timezoneoffset int) returns datetime As begin declare @localtime datetime select @localtime = dateadd(hh, -1 * @timezoneoffset, @gmtdate) return @localtime end Then it can be called like this select localtime(getdate(), 3) Tim -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 4:54 PM To: CF-Talk Subject: RE: Compensating for Server Time Does that work in SQL 2000? I've always used _javascript_ at logon to determine the time zone of the user's computer.I then store the time zone offset in a cookie or session/client variable.I then use a UDF to convert the time from the SQL server to that user's local time. If there was a way to do this all in one single shot via SQL as it seems you have a solution for below I'd love to try it out.Unfortunately I can't seem to make the example you gave below work in SQL 2000. -Novak -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 12:55 PM To: CF-Talk Subject: Re: Compensating for Server Time Chris Montgomery wrote: What's the best way to compensate for time on a server in a hosted environment when the time is set to a different time than a user's local time zone? Ex: client is in Central Time, server is on Eastern Time (one hour ahead); client wants everything to reflect local time. I use the AT TIME ZONE functionality from SQL, it even compensates for daylight savings time: testDB= select '2003-12-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-12-12 12:00:00 testDB= select '2003-07-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-06-12 11:00:00 Jochem -- Who needs virtual reality if you can just dream? - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Ideas needed! Password protect a file download.
You guys are fantastic. I just talked to the crummy isp for the site and it looks like it may take some work to get them to allow me to use the cfcontent tag, but they are considering it. Looks like it is the way to go. I'll report back if I can get them to switch it back on. Thanks!!! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ideas needed! Password protect a file download.
Thats why I love hostmysite.com for my CF hosting needs.. They allow the tags! _ From: Jeff Fongemie [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:00 PM To: CF-Talk Subject: Re:Ideas needed! Password protect a file download. You guys are fantastic. I just talked to the crummy isp for the site and it looks like it may take some work to get them to allow me to use the cfcontent tag, but they are considering it. Looks like it is the way to go. I'll report back if I can get them to switch it back on. Thanks!!! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Compensating for Server Time
Sunday, November 16, 2003, 2:55:11 PM, Jochem van Dieten wrote: I use the AT TIME ZONE functionality from SQL, it even compensates for daylight savings time... Thanks Jochem, Tony, Tim, Novak, et. al. I'll look into your recommendations. I should have clarified the situation a bit more, however. The database is MS Access (for now; will probably upsize to MS SQL server soon). I want to keep this is simple as possible (because I'm a simple person). I am going to assume that the user's time zone is always local because my client's business is local. So, in effect, I need only subtract one hour from the server's time for any transaction (storing appointment times, mainly). I guess I could set this as a constant in a request variable in the application.cfm file and then use that for the current time from then on. Would that seem feasible? Cheers. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Compensating for Server Time
Howdy Tony, Sunday, November 16, 2003, 3:49:51 PM, Tony Weeg wrote: there is a great little cfc @ cfczone.org Ooops, forgot to mention: this is on CF5/Windows. I'll take a look at the CFC anyway, might give me some good tips. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Compensating for Server Time
Looks like LocalTime() at cflib.org might be just what the doctor ordered ( http://www.cflib.org/udf.cfm?ID=719 ). Gonna give it a try. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Compensating for Server Time
Sunday, November 16, 2003, 6:14:47 PM, Chris Montgomery wrote: LocalTime() at cflib.org This UDF uses cffunction, which I guess is an MX tag. I converted Chad Jackson's UDF to be compatible with CF5 (in case anyone else wants it). Note that the offset is for Central Daylight Time (-6). !--- Function that returns adjusted local server time. @return Returns a date object. @orignal_author chad jackson @author chris montgomery @version 1, September 24, 2002 @version 2, November 16, 2003 (CF5) --- cfscript function LocalTime() { var timeZoneInfo = GetTimeZoneInfo(); // local time GMT offset. var offset = -6; var GMTtime = DateAdd('s', timeZoneInfo.UTCtotalOffset, Now() ); var theLocalTime = DateAdd('h',offset,GMTtime); return theLocaltime; } /cfscript pThe date/time on the server is: cfoutput#now()#/cfoutput/p pThe local date/time is cfoutput#Localtime()#/cfoutput/p Cheers. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: SQL server question
Hey all, I recently did something really dumb - I had a really small SQL server database that I was using for a home project, and, during an upgrade fiasco (long story), I deleted it by mistake.Now... I see that the .MDF and .LDF files still exist in my MSSQL7/data folder, and I would like to restore this database, but I have no idea how to do it.Any ideas? Thanks in advance! Robyn [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL server question
I recently did something really dumb - I had a really small SQL server database that I was using for a home project, and, during an upgrade fiasco (long story), I deleted it by mistake. Now... I see that the .MDF and .LDF files still exist in my MSSQL7/data folder, and I would like to restore this database, but I have no idea how to do it.Any ideas? You can use the sp_attach_db stored procedure from Query Analyzer to attach your database and its log. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL server question
Open Enterprise Manager and right click the Databases folder. Choose attach database from the all tasks menu. A new window will open which will allow you to select the MDF file and attach the database. chris _ From: Robyn Follen [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:27 PM To: CF-Talk Subject: OT: SQL server question Hey all, I recently did something really dumb - I had a really small SQL server database that I was using for a home project, and, during an upgrade fiasco (long story), I deleted it by mistake.Now... I see that the .MDF and .LDF files still exist in my MSSQL7/data folder, and I would like to restore this database, but I have no idea how to do it.Any ideas? Thanks in advance! Robyn _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL server question
Ah, perfect. This worked! Thanks -Robyn -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 8:42 PM To: CF-Talk Subject: RE: SQL server question I recently did something really dumb - I had a really small SQL server database that I was using for a home project, and, during an upgrade fiasco (long story), I deleted it by mistake. Now... I see that the .MDF and .LDF files still exist in my MSSQL7/data folder, and I would like to restore this database, but I have no idea how to do it.Any ideas? You can use the sp_attach_db stored procedure from Query Analyzer to attach your database and its log. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Very vague error message
I have never come across this in a ColdFusion.One way you can try to pinpoint the error is to place cfabort statement at say, line 50. Run your code and if you don't get an error, place the cfabort on line 100 and run the code.Keep doing this until you get closer to the error. Do you have any idea where it could be?It sounds as though ColdFusion is saying do not place a dynamic variable in this evaluating statement.I can't think of a place where this would be so.Are you using cfscript in this page anywhere?If so, if you are using a case statement that reads case constant, this may be the culprit. Hope that helps. -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:41 AM To: CF-Talk Subject: Very vague error message Hello I have a rather large page of code which ive been working on, and I get the following error: This _expression_ must have a constant value. It doesn¹t give me a line number, or a code snippet, just that text. As I said I have a lot of code (1000+ lines) and I cant quite tie down the problem... Has anyone come across this before? Thanks, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Very vague error message
i always use Im here (#timeFormat(now(),'hh:mm:ss')# ! cfabort and place it before trouble points, or after them to see if they are really, trouble points.stepping through the code, its the easiest way i can see for myself to debug, unless i know *exactly* where the code is wrong, of course. but, you probably already use something like this... :) and funny enough, the message Im here is usually a gauge of frustration with the particular problem, lots of times it has some four letter words mixed in, cursing that damn jeremy allaire for creating this cursed thing we all LOVE, cf. tony -Original Message- From: Michael S. Hodgdon [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:18 PM To: CF-Talk Subject: RE: Very vague error message I have never come across this in a ColdFusion.One way you can try to pinpoint the error is to place cfabort statement at say, line 50. Run your code and if you don't get an error, place the cfabort on line 100 and run the code.Keep doing this until you get closer to the error. Do you have any idea where it could be?It sounds as though ColdFusion is saying do not place a dynamic variable in this evaluating statement.I can't think of a place where this would be so.Are you using cfscript in this page anywhere?If so, if you are using a case statement that reads case constant, this may be the culprit. Hope that helps. -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:41 AM To: CF-Talk Subject: Very vague error message Hello I have a rather large page of code which ive been working on, and I get the following error: This _expression_ must have a constant value. It doesn¹t give me a line number, or a code snippet, just that text. As I said I have a lot of code (1000+ lines) and I cant quite tie down the problem... Has anyone come across this before? Thanks, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Very vague error message
assuming that it is within cfoutput/cfoutput tags, that is ;) tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:24 PM To: CF-Talk Subject: RE: Very vague error message i always use Im here (#timeFormat(now(),'hh:mm:ss')# ! cfabort and place it before trouble points, or after them to see if they are really, trouble points.stepping through the code, its the easiest way i can see for myself to debug, unless i know *exactly* where the code is wrong, of course. but, you probably already use something like this... :) and funny enough, the message Im here is usually a gauge of frustration with the particular problem, lots of times it has some four letter words mixed in, cursing that damn jeremy allaire for creating this cursed thing we all LOVE, cf. tony -Original Message- From: Michael S. Hodgdon [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:18 PM To: CF-Talk Subject: RE: Very vague error message I have never come across this in a ColdFusion.One way you can try to pinpoint the error is to place cfabort statement at say, line 50. Run your code and if you don't get an error, place the cfabort on line 100 and run the code.Keep doing this until you get closer to the error. Do you have any idea where it could be?It sounds as though ColdFusion is saying do not place a dynamic variable in this evaluating statement.I can't think of a place where this would be so.Are you using cfscript in this page anywhere?If so, if you are using a case statement that reads case constant, this may be the culprit. Hope that helps. -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:41 AM To: CF-Talk Subject: Very vague error message Hello I have a rather large page of code which ive been working on, and I get the following error: This _expression_ must have a constant value. It doesn¹t give me a line number, or a code snippet, just that text. As I said I have a lot of code (1000+ lines) and I cant quite tie down the problem... Has anyone come across this before? Thanks, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Very vague error message
How about cftrace? _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:24 PM To: CF-Talk Subject: RE: Very vague error message i always use Im here (#timeFormat(now(),'hh:mm:ss')# ! cfabort and place it before trouble points, or after them to see if they are really, trouble points.stepping through the code, its the easiest way i can see for myself to debug, unless i know *exactly* where the code is wrong, of course. but, you probably already use something like this... :) and funny enough, the message Im here is usually a gauge of frustration with the particular problem, lots of times it has some four letter words mixed in, cursing that damn jeremy allaire for creating this cursed thing we all LOVE, cf. tony -Original Message- From: Michael S. Hodgdon [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:18 PM To: CF-Talk Subject: RE: Very vague error message I have never come across this in a ColdFusion.One way you can try to pinpoint the error is to place cfabort statement at say, line 50. Run your code and if you don't get an error, place the cfabort on line 100 and run the code.Keep doing this until you get closer to the error. Do you have any idea where it could be?It sounds as though ColdFusion is saying do not place a dynamic variable in this evaluating statement.I can't think of a place where this would be so.Are you using cfscript in this page anywhere?If so, if you are using a case statement that reads case constant, this may be the culprit. Hope that helps. -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:41 AM To: CF-Talk Subject: Very vague error message Hello I have a rather large page of code which ive been working on, and I get the following error: This _expression_ must have a constant value. It doesn¹t give me a line number, or a code snippet, just that text. As I said I have a lot of code (1000+ lines) and I cant quite tie down the problem... Has anyone come across this before? Thanks, Ryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Very vague error message
how about it? never used it :) tw -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:33 PM To: CF-Talk Subject: RE: Very vague error message How about cftrace? _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:24 PM To: CF-Talk Subject: RE: Very vague error message i always use Im here (#timeFormat(now(),'hh:mm:ss')# ! cfabort and place it before trouble points, or after them to see if they are really, trouble points.stepping through the code, its the easiest way i can see for myself to debug, unless i know *exactly* where the code is wrong, of course. but, you probably already use something like this... :) and funny enough, the message Im here is usually a gauge of frustration with the particular problem, lots of times it has some four letter words mixed in, cursing that damn jeremy allaire for creating this cursed thing we all LOVE, cf. tony -Original Message- From: Michael S. Hodgdon [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:18 PM To: CF-Talk Subject: RE: Very vague error message I have never come across this in a ColdFusion.One way you can try to pinpoint the error is to place cfabort statement at say, line 50. Run your code and if you don't get an error, place the cfabort on line 100 and run the code.Keep doing this until you get closer to the error. Do you have any idea where it could be?It sounds as though ColdFusion is saying do not place a dynamic variable in this evaluating statement.I can't think of a place where this would be so.Are you using cfscript in this page anywhere?If so, if you are using a case statement that reads case constant, this may be the culprit. Hope that helps. -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:41 AM To: CF-Talk Subject: Very vague error message Hello I have a rather large page of code which ive been working on, and I get the following error: This _expression_ must have a constant value. It doesn¹t give me a line number, or a code snippet, just that text. As I said I have a lot of code (1000+ lines) and I cant quite tie down the problem... Has anyone come across this before? Thanks, Ryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Very vague error message
Weegs, how did the test go? _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:37 PM To: CF-Talk Subject: RE: Very vague error message how about it? never used it :) tw -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:33 PM To: CF-Talk Subject: RE: Very vague error message How about cftrace? _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:24 PM To: CF-Talk Subject: RE: Very vague error message i always use Im here (#timeFormat(now(),'hh:mm:ss')# ! cfabort and place it before trouble points, or after them to see if they are really, trouble points.stepping through the code, its the easiest way i can see for myself to debug, unless i know *exactly* where the code is wrong, of course. but, you probably already use something like this... :) and funny enough, the message Im here is usually a gauge of frustration with the particular problem, lots of times it has some four letter words mixed in, cursing that damn jeremy allaire for creating this cursed thing we all LOVE, cf. tony -Original Message- From: Michael S. Hodgdon [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:18 PM To: CF-Talk Subject: RE: Very vague error message I have never come across this in a ColdFusion.One way you can try to pinpoint the error is to place cfabort statement at say, line 50. Run your code and if you don't get an error, place the cfabort on line 100 and run the code.Keep doing this until you get closer to the error. Do you have any idea where it could be?It sounds as though ColdFusion is saying do not place a dynamic variable in this evaluating statement.I can't think of a place where this would be so.Are you using cfscript in this page anywhere?If so, if you are using a case statement that reads case constant, this may be the culprit. Hope that helps. -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:41 AM To: CF-Talk Subject: Very vague error message Hello I have a rather large page of code which ive been working on, and I get the following error: This _expression_ must have a constant value. It doesn¹t give me a line number, or a code snippet, just that text. As I said I have a lot of code (1000+ lines) and I cant quite tie down the problem... Has anyone come across this before? Thanks, Ryan _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Very vague error message
taking it @ max on the 20th :) studying while working tonight!! tw -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:42 PM To: CF-Talk Subject: RE: Very vague error message Weegs, how did the test go? _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:37 PM To: CF-Talk Subject: RE: Very vague error message how about it? never used it :) tw -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:33 PM To: CF-Talk Subject: RE: Very vague error message How about cftrace? _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:24 PM To: CF-Talk Subject: RE: Very vague error message i always use Im here (#timeFormat(now(),'hh:mm:ss')# ! cfabort and place it before trouble points, or after them to see if they are really, trouble points.stepping through the code, its the easiest way i can see for myself to debug, unless i know *exactly* where the code is wrong, of course. but, you probably already use something like this... :) and funny enough, the message Im here is usually a gauge of frustration with the particular problem, lots of times it has some four letter words mixed in, cursing that damn jeremy allaire for creating this cursed thing we all LOVE, cf. tony -Original Message- From: Michael S. Hodgdon [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:18 PM To: CF-Talk Subject: RE: Very vague error message I have never come across this in a ColdFusion.One way you can try to pinpoint the error is to place cfabort statement at say, line 50. Run your code and if you don't get an error, place the cfabort on line 100 and run the code.Keep doing this until you get closer to the error. Do you have any idea where it could be?It sounds as though ColdFusion is saying do not place a dynamic variable in this evaluating statement.I can't think of a place where this would be so.Are you using cfscript in this page anywhere?If so, if you are using a case statement that reads case constant, this may be the culprit. Hope that helps. -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:41 AM To: CF-Talk Subject: Very vague error message Hello I have a rather large page of code which ive been working on, and I get the following error: This _expression_ must have a constant value. It doesn¹t give me a line number, or a code snippet, just that text. As I said I have a lot of code (1000+ lines) and I cant quite tie down the problem... Has anyone come across this before? Thanks, Ryan _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Very vague error message
Cool. I wish I wasn't up Managerial accounting homework is not as much fun as Cold Fusion Coding :-) _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:42 PM To: CF-Talk Subject: RE: Very vague error message taking it @ max on the 20th :) studying while working tonight!! tw -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:42 PM To: CF-Talk Subject: RE: Very vague error message Weegs, how did the test go? _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:37 PM To: CF-Talk Subject: RE: Very vague error message how about it? never used it :) tw -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:33 PM To: CF-Talk Subject: RE: Very vague error message How about cftrace? _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:24 PM To: CF-Talk Subject: RE: Very vague error message i always use Im here (#timeFormat(now(),'hh:mm:ss')# ! cfabort and place it before trouble points, or after them to see if they are really, trouble points.stepping through the code, its the easiest way i can see for myself to debug, unless i know *exactly* where the code is wrong, of course. but, you probably already use something like this... :) and funny enough, the message Im here is usually a gauge of frustration with the particular problem, lots of times it has some four letter words mixed in, cursing that damn jeremy allaire for creating this cursed thing we all LOVE, cf. tony -Original Message- From: Michael S. Hodgdon [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:18 PM To: CF-Talk Subject: RE: Very vague error message I have never come across this in a ColdFusion.One way you can try to pinpoint the error is to place cfabort statement at say, line 50. Run your code and if you don't get an error, place the cfabort on line 100 and run the code.Keep doing this until you get closer to the error. Do you have any idea where it could be?It sounds as though ColdFusion is saying do not place a dynamic variable in this evaluating statement.I can't think of a place where this would be so.Are you using cfscript in this page anywhere?If so, if you are using a case statement that reads case constant, this may be the culprit. Hope that helps. -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:41 AM To: CF-Talk Subject: Very vague error message Hello I have a rather large page of code which ive been working on, and I get the following error: This _expression_ must have a constant value. It doesn¹t give me a line number, or a code snippet, just that text. As I said I have a lot of code (1000+ lines) and I cant quite tie down the problem... Has anyone come across this before? Thanks, Ryan _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX JRun Servlets - Help!
I'm attempting to setup a credit card gateway (Worldpay - select pro, java) which requires some servlets to operate.Basically I'm having trouble setting them up to run on the version of JRun that comes with CFMX, can anyone offer a basic tutorial on what/how i have to configure on the server to achieve this.I'm running CFMX 6.1 on a Windows 2000 Server if that helps.I don't really want to install another servlet server such as tomcat etc.. since I already have JRun and have heard of others managing to configure it for similar purposes. Thanks in advance. Will [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX JRun Servlets - Help!
Heya Will, Are you running Enterprise or Standard? Unless you are running Enterprise, then you can't use the included JRUN server to serve anything but Cold Fusion templates... or thats what I understand anyway... What problem are you having, are they license violation errors? bye Monday, November 17, 2003, 2:48:24 PM, you wrote: WB I'm attempting to setup a credit card gateway (Worldpay - select pro, java) WB which requires some servlets to operate.Basically I'm having trouble WB setting them up to run on the version of JRun that comes with CFMX, can WB anyone offer a basic tutorial on what/how i have to configure on the server WB to achieve this.I'm running CFMX 6.1 on a Windows 2000 Server if that WB helps.I don't really want to install another servlet server such as tomcat WB etc.. since I already have JRun and have heard of others managing to WB configure it for similar purposes. WB Thanks in advance. WB Will WB [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Inserting rows into a 2d array
Hi all, Need some help with inserting rows into a 2d array. As an example I populate an array with values cityName and LocationID from a query. I then need to insert a new ROW between row 4 and row 5. In essence shifting rows 5 and below down one row. I'd thought of appending to the array, then using ArraySwap to move all elements down one row (need to keep elements in order), then using ArrayInsertAt to populate the new row at row 5. This seems like such an inefficient way. Any suggestions? Thanks, Doug [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Very vague error message
1000+ lines of code in a single CF template seems a bit excessive for starters. Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 Michael S. HodgdonTo: CF-Talk [EMAIL PROTECTED] [EMAIL PROTECTED]cc: omcast.netSubject:RE: Very vague error message 17/11/2003 14:17 Please respond to | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]