Re:Adding remote datasource dynamically
Don said: Same result after ds.password = ds_service.encryptPasword(#FORM.pwd#); ds.password = ds_service.encryptPasword(javaCast(string,FORM.pwd)); Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFStat from remote machine
Peter Amiri wrote: On page 21 of the new Administering ColdFusion MX mini manual it shows options for web server (-h) and web server listening port (-p) but doesn't give any examples. I would like to run a cfstat on my local machine and see info for my server. Anyone know if this works. Hi Peter, I'm not sure how that works, but you could create a cfm page and use the GetMetricData function. I just posted an example in my blog: http://www.petefreitag.com/item/101.cfm __ Pete Freitag http://www.cfdev.com Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle Sequences
kpeterson wrote: You might need to increase your Sequence Number Cache size http://download-west.oracle.com/docs/cd/A87860_01/doc/index.htm Cheers Kore... Will give it a try out.Sorry for the late reply, didn't get any list emails at all yesterday! -- -dc[ cf5, ora8.1.7, iis5 ] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Password encryption
Hi I am storing user name and password in Access DB and running a query to match the combination when user attempts to login. Authorised users can do everything with the DB. Whats the best way to make it secure? encrypting passwords stored in DB? or some other way.. Thanks Shaz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Flight Schedule CustomTag or Webservice
Im working on an application where I need to make travel and lodging arrangement.Do any of you know of a webservice or custom tag that would allow me to send origins, destinations, dates and times and back comes flight schedules and hotel rates? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Password encryption
You could hash() the password on the way in, stops in being stored in clear text. Jb. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 16 December 2003 11:01 To: CF-Talk Subject: Password encryption Hi I am storing user name and password in Access DB and running a query to match the combination when user attempts to login. Authorised users can do everything with the DB. Whats the best way to make it secure? encrypting passwords stored in DB? or some other way.. Thanks Shaz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Password encryption
http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid =29317forumid=4 Just yesterday. -- -dc[ cf5, ora8.1.7, iis5 ] -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 16 December 2003 11:01 To: CF-Talk Subject: Password encryption Hi I am storing user name and password in Access DB and running a query to match the combination when user attempts to login. Authorised users can do everything with the DB. Whats the best way to make it secure? encrypting passwords stored in DB? or some other way.. Thanks Shaz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX 6.1 / AD / Single-Sign-On
I was asked by some of our network guys to see if a single sign on would be possible for our intranet applications. We have intranet applications that were written in CF: 4.0-MX 6.1 Currently the applications have their own login pages and some kind of role/permission architecture in place (home grown) that pull from the respective application databases. Has anyone taken a handful of applications that rolled their own authentication and switched it over to authenticating from an Active Directory? My main concern is that a good portion of the apps would need to be altered to accommodate the new authentication means and then somehow build the roles and permissions if needed off of that. Basically I am just looking for some input, cautions, dos don'ts, etc. Comments, feedback, etc welcome.. Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 / AD / Single-Sign-On
http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid =29269forumid=4 Suppose I was asking about CF5 but the theory is the same but I suppose this disscussion seems kind of dead now apart from our own investigation into it... wonder if you'll have any better luck with your question Michael ;-) -- -dc[ cf5, ora8.1.7, iis5 ] -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 16 December 2003 13:18 To: CF-Talk Subject: CFMX 6.1 / AD / Single-Sign-On I was asked by some of our network guys to see if a single sign on would be possible for our intranet applications. We have intranet applications that were written in CF: 4.0-MX 6.1 Currently the applications have their own login pages and some kind of role/permission architecture in place (home grown) that pull from the respective application databases. Has anyone taken a handful of applications that rolled their own authentication and switched it over to authenticating from an Active Directory? My main concern is that a good portion of the apps would need to be altered to accommodate the new authentication means and then somehow build the roles and permissions if needed off of that. Basically I am just looking for some input, cautions, dos don'ts, etc. Comments, feedback, etc welcome.. Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Single Sign On (implemented in CF)
Got some intereting off-list emails from Jochem that are def worth reading (they were for me) if Jochem doesn't mind me posting them. -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Single Sign On (implemented in CF)
def worth reading (they were for me) if Jochem doesn't mind me posting them. The content of emails were worth reading for me I mean :-) -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 / AD / Single-Sign-On
On a possibly related topic...back when MX first came out I had major issues getting it to work with active Directory over SSL. Was told by MM tech support that it was M$'s fault due to a non standard implementation. (which may or may not be true) This was with MX 6.0 Just heads up, Stace _ From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 8:18 AM To: CF-Talk Subject: CFMX 6.1 / AD / Single-Sign-On I was asked by some of our network guys to see if a single sign on would be possible for our intranet applications. We have intranet applications that were written in CF: 4.0-MX 6.1 Currently the applications have their own login pages and some kind of role/permission architecture in place (home grown) that pull from the respective application databases. Has anyone taken a handful of applications that rolled their own authentication and switched it over to authenticating from an Active Directory? My main concern is that a good portion of the apps would need to be altered to accommodate the new authentication means and then somehow build the roles and permissions if needed off of that. Basically I am just looking for some input, cautions, dos don'ts, etc. Comments, feedback, etc welcome.. Thanks, Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Password encryption
Depends on your security requirements.I do a one-way hash when the password is created, and email Users temporary passwords when they forget theirs.No one can look-up a password, not even the DBA. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 5:01 AM To: CF-Talk Subject: Password encryption Hi I am storing user name and password in Access DB and running a query to match the combination when user attempts to login. Authorised users can do everything with the DB. Whats the best way to make it secure? encrypting passwords stored in DB? or some other way.. Thanks Shaz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFStat from remote machine
Thanks Pete. I'll look into using that. -Peter Amiri [EMAIL PROTECTED] MySpace.com -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 11:44 PM To: CF-Talk Subject: Re: CFStat from remote machine Peter Amiri wrote: On page 21 of the new Administering ColdFusion MX mini manual it shows options for web server (-h) and web server listening port (-p) but doesn't give any examples. I would like to run a cfstat on my local machine and see info for my server. Anyone know if this works. Hi Peter, I'm not sure how that works, but you could create a cfm page and use the GetMetricData function. I just posted an example in my blog: http://www.petefreitag.com/item/101.cfm __ Pete Freitag http://www.cfdev.com Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 / AD / Single-Sign-On
whoa... thanks for the heads-up... especially since all our intranet apps MUST run over SSL. I will see if I can get an update on the issue. Mike -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 8:54 AM To: CF-Talk Subject: RE: CFMX 6.1 / AD / Single-Sign-On On a possibly related topic...back when MX first came out I had major issues getting it to work with active Directory over SSL. Was told by MM tech support that it was M$'s fault due to a non standard implementation. (which may or may not be true) This was with MX 6.0 Just heads up, Stace _ From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 8:18 AM To: CF-Talk Subject: CFMX 6.1 / AD / Single-Sign-On I was asked by some of our network guys to see if a single sign on would be possible for our intranet applications. We have intranet applications that were written in CF: 4.0-MX 6.1 Currently the applications have their own login pages and some kind of role/permission architecture in place (home grown) that pull from the respective application databases. Has anyone taken a handful of applications that rolled their own authentication and switched it over to authenticating from an Active Directory? My main concern is that a good portion of the apps would need to be altered to accommodate the new authentication means and then somehow build the roles and permissions if needed off of that. Basically I am just looking for some input, cautions, dos don'ts, etc. Comments, feedback, etc welcome.. Thanks, Mike _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 / AD / Single-Sign-On
Problem was using LDAP over SSL specifically...to query Active Dir... Stace _ From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 9:57 AM To: CF-Talk Subject: RE: CFMX 6.1 / AD / Single-Sign-On whoa... thanks for the heads-up... especially since all our intranet apps MUST run over SSL. I will see if I can get an update on the issue. Mike -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 8:54 AM To: CF-Talk Subject: RE: CFMX 6.1 / AD / Single-Sign-On On a possibly related topic...back when MX first came out I had major issues getting it to work with active Directory over SSL. Was told by MM tech support that it was M$'s fault due to a non standard implementation. (which may or may not be true) This was with MX 6.0 Just heads up, Stace _ From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 8:18 AM To: CF-Talk Subject: CFMX 6.1 / AD / Single-Sign-On I was asked by some of our network guys to see if a single sign on would be possible for our intranet applications. We have intranet applications that were written in CF: 4.0-MX 6.1 Currently the applications have their own login pages and some kind of role/permission architecture in place (home grown) that pull from the respective application databases. Has anyone taken a handful of applications that rolled their own authentication and switched it over to authenticating from an Active Directory? My main concern is that a good portion of the apps would need to be altered to accommodate the new authentication means and then somehow build the roles and permissions if needed off of that. Basically I am just looking for some input, cautions, dos don'ts, etc. Comments, feedback, etc welcome.. Thanks, Mike _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfmail in cf5 spool re-sends to infinity
and kudos to macromedia for seemingly pretending that this doesn't even exist. We (I) spent a lot of time trying to address just these types of complaints in CFMX 6.1.Upgrade and you should not see this problem ever again. -- Tom Jordahl Macromedia Server Development -Original Message- From: j cc [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 3:17 PM To: CF-Talk Subject: Re:cfmail in cf5 spool re-sends to infinity Yup.Seen this.Been aggrivated by this. yeah, the more research i do the more i see that a lot of people have seen this.and kudos to macromedia for seemingly pretending that this doesn't even exist.(do a groups.google search for cfmail spool and see all the people who posted to forums about this very problem, without so much as a single response) what kills me, is this seems like it could be fixed by what i'm sure is a 2 line code change.read the mail into memory, delete the file.if the file deletes, send the mail.if the file doesn't delete, don't send the mail. but instead, we send the mail 25,000 times and drop a 'warning' level error in the logs. Unfortunately, the only way to fix it I've found is to reboot the box, stop CF, and move or delete the file myself (so it doesn't send again). yeah, this just isn't feasible though :/-- to monitor the spool 24/7.A script could poll it, but the script couldn't delete a troubled file -- so the best it could do is notify admins that something is wrong (granted, this is better than the out of box behavior) it seems that we'll have to use something other than cfmail.but what i don't understand -- do cfmail alternatives replace the spooling mechanism that CF uses, or do they use the built-in CF spool?b/c it's that spooling mechanism that is faulty, and as long as that is till being used then there's no point in going to an alternative... Fortunately for us, this has only happened (that we know of) when the mail was unsendable, so we weren't bombarding people with eight billion copies of an email. after reading those other stories on google tho, i'm very happy our customer only got 79 emails.25,000 would have been a lot worse :) thanks Ben, -Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMAIL (MX - 6.0) and multiple email servers
Upgrade to 6.1 (it's free!). This feature was added to the 6.1 release.You are getting unknown host error because CFMX 6.0 is trying to look up mail1,mail2. -- Tom Jordahl Macromedia Server Development -Original Message- From: Turetsky, Seth [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 5:55 PM To: CF-Talk Subject: RE: CFMAIL (MX - 6.0) and multiple email servers Hey Dave, I work with Mario, so I ran an nslookup on the address and a few records do show up.But I think you're right when saying it isn't CF's job to query the dns server, but unfortunately it fails with an unknown host error. And the docs do say that the mail server takes multiple entries, but only in 6.1, which IT hasn't gotten around to installing for us, lucky us. I'm going to look into a java alternative(javamail as someone suggested offlist) if I have the time -seth -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 5:21 PM To: CF-Talk Subject: RE: CFMAIL (MX - 6.0) and multiple email servers I have tried to get CFMAIL to work with our MX-records but I cannot get it to connect - seems as though CFMAIL cannot hadle MX records for incoming mail? I'm not sure what you mean by this. CFMAIL doesn't handle MX records - it simply uses the OS to resolve MX names to addresses. If this isn't working, you should go to a console and see if you can resolve them yourself using nslookup or the like. Does any know of way to specify a second email server to use? I know that the CFMAIL in 6.1 has a failto but this is an email address and not a server. According to the documentation, you can specify multiple mail servers in the SERVER attribute. 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: Verity problem running MX 6.1 J2EE under Tomcat 4.1.18 on Win dows XP
You need to have the Verity libraries on the PATH environment variable so Java/CFMX will find them when it tries to open them. There are instructions for the J2EE editions on where to set this path, I am not sure if they cover Tomcat. -- Tom Jordahl Macromedia Server Development -Original Message- From: Michael R. Levy [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 9:41 PM To: CF-Talk Subject: Verity problem running MX 6.1 J2EE under Tomcat 4.1.18 on Windows XP Hi, I have got MX 6.1 running as J2EE under Tomcat 4.1.18 on Windows XP Pro. I've followed the instructions here: http://www.macromedia.com/support/coldfusion/j2ee/phase2-tomcat-deploy.html http://www.macromedia.com/support/coldfusion/j2ee/phase2-tomcat-deploy.html ...and created the WAR files and deployed them, created 'setenv.bat' according to instructions, and done the other things mentioned in the article. I've ported an application and everything is working fine -- the SQL Server database connections, email, CFC's -- everything except Verity.So I think overall the configuration must be OK. The CF debug info shows: Could not create instance of tag handler class coldfusion.tagext.lang.CFSearchTag: coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Verity service is not available.. The error in (Tomcat Root)\webapps\cfusion\WEB-INF\cfusion\logs\exception.log seems to be more specific, but I don't understand what is wrong with the path. Error,main,12/14/03,17:42:46,,no cfindex in java.library.path java.lang.UnsatisfiedLinkError: no cfindex in java.library.path at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1403) at java.lang.Runtime.loadLibrary0(Runtime.java:788) (.etc) I figured it had to do with not having set up setenv.bat correctly. However, I can say that if I open a DOS window, set the directory to C:\Tomcat4.1\bin and then run call setenv.bat and then I run dir %CF_SHARED_LIBS% I see all the files in the various directories that should be there, including C:\Tomcat4.1\webapps\cfusion\WEB-INF\cfusion\lib\_nti40\bin and C:\Tomcat4.1\webapps\cfusion\WEB-INF\cfusion\jintegra\bin Any ideas? Thanks! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
test
Test __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Using CFFile
Use this Java FTP Applet http://www.jscape.com --Original Message Text--- From: Robert Orlini Date: Mon, 15 Dec 2003 14:45:50 -0500 Using CFfile, how do I copy more than one file at a time? The code below works great copying one file, but does not accept more than one. For example lets say I want to copy all the files in the e:\template\ directory to d:\template? CFFile action="" source=e:\template\application.cfm destination=d:\template\ Thanks. Robert O. Wilson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Adding remote datasource dynamically
Oops, Java was not a friend of mine :) Same result same err msg after using javaCast string function. Could you use your MM resources (MM your buddy) for more inside scoop?Many thanks. Don Don said: Same result after ds.password = ds_service.encryptPasword(#FORM.pwd#); ds.password = ds_service.encryptPasword(javaCast(string,FORM.pwd)); Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Adding remote datasource dynamically
Oops, was probably half asleep when composing the following msg. cfset foo = 1433 is the same as cfset foo = 1433 But personally I would stick with the later all the time. Also, How come urlPath.PORT = 1433; instead of urlPath.PORT = 1433? Shouldn't 1433 be a string, which requires quotes? And I did not get any error msg. Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFStat from remote machine
make a cfm page and put this in it: precfexecute name = C:\CFusionMX\runtime\jre\bin\java.exe arguments = -cp C:\CFusionMX\lib\cfusion.jar coldfusion.tools.CfstatMain timeout = 100 /cfexecute /pre then just hit your cfstat.cfm to see cfstats for the server you put it on. -nathan strutz -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:44 AM To: CF-Talk Subject: Re: CFStat from remote machine Peter Amiri wrote: On page 21 of the new Administering ColdFusion MX mini manual it shows options for web server (-h) and web server listening port (-p) but doesn't give any examples. I would like to run a cfstat on my local machine and see info for my server. Anyone know if this works. Hi Peter, I'm not sure how that works, but you could create a cfm page and use the GetMetricData function. I just posted an example in my blog: http://www.petefreitag.com/item/101.cfm __ Pete Freitag http://www.cfdev.com Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:OT: GeoTrust Certs @ 25$ ?
Here's an example of one of the phony expiration notices Geotrust sends out.Check the site: the cert hasn't expired yet.If the client's domain admin email wasn't also mine that client would be tearing into me. These start 90 days out from expiration (with the expiration date calc'd properly), I might add.So their renewal process starts out plain obnoxious and ends up as flat-out dishonest. Hopefully Comodo will behave decently.Guess I'll find out next August. --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 7:57 AM To: matt robertson; hl bromberg Subject: URGENT - Your QuickSSL Certificate for www.ferrariinsurance.com expired 4 day(s) ago! Renewal Notice for www.ferrariinsurance.com Dear EV1servers.net (formerly Rackshack) Customer, Your GeoTrust QuickSSL certificate expired 4 Days ago! ***snip*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFC Not showing in CFC Explorer
What would cause a CFC/CFC package to not show in the CFC explorer? If I type the direct URL as in: http://www.myserver.com/CFIDE/componentutils/componentdetail.cfm?component=mypath.mypackage.mycfc I can browse the data. It does not appear, however, in the listing of CFCs on my server. I can also invoke the CFC properly from application pages. What would cause the CFC not to appear in the explorer? Thanks, -- Alex Sherwood PHS Collection Agency [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL Help
Hello All, I am having problems with an update statement that used to work fine in Access with CFMX.I have an issue tracking app that used to have the issue numbers stored as TEXT, I converted the column to Number a little while ago and it worked fine.Recently users have been having problems updating the records. My update statement is pretty simple Update IssueRegister SET IssueStatus = '#form.IssueStatus#', Response = '#form.Response#', ResponseUserId = '#session.activeuser.USER_NAME#', DateofResponse = #CreateODBCdate(now())# Where IssueNumber = #form.issuenumber# The error that I get from CF is The search key was not found in any record. But if I look in the error window it show my statment as follows Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110 This look correct to me.So I tried running it in access's query window and I get the same error, yet when I try to search the column for issuenumber 1110 Access finds it through its own search utility. This has me stumped.Any ideas anyone. Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFLDAP query runs short in MX 6.1
Two identical CFLDAP queries on two different boxes: CF 5 and 6.1.The 5 box returns 55k+ records, as it's supposed to.The 6.1 box runs its query in about 10-20 seconds and returns a varying number of results, between 100 and 400.They're hitting the same LDAP server. Both machines *can* talk to the LDAP server, here is the output of a 'time ldapsearch' command executed at the same time on both machines.It's timing the execution and completion time of a command-line LDAP query: CF5 machine: real 7m7.31s user 0m6.19s sys0m4.32s CF 6.1 real 5:22.5 user 5.3 sys 3.6 Roughly the same, but more importantly, the time taken to return the recordset is 5+ minutes on the 6.1 machine.But like I said, the CFLDAP query returns in about 10-20 seconds.So it does not appear that there's a timeout or other problem on the LDAP server end.What could be keeping the code from executing properly, going from 5 to 6.1? Thanks, Shawn [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
[Macromedia][Oracle JDBC Driver]No more data available to read.
I am running CFMX 6.0, no updates, on Apache 1.3.27 and using Oracle 9i on the back end.I am getting intermittent 500 Errors: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [EMAIL PROTECTED] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL Problem
Hello All, I am having problems with an update statement that used to work fine in Access with CFMX.I have an issue tracking app that used to have the issue numbers stored as TEXT, I converted the column to Number a little while ago and it worked fine.Recently users have been having problems updating the records. My update statement is pretty simple Update IssueRegister SET IssueStatus = '#form.IssueStatus#', Response = '#form.Response#', ResponseUserId = '#session.activeuser.USER_NAME#', DateofResponse = #CreateODBCdate(now())# Where IssueNumber = #form.issuenumber# The error that I get from CF is The search key was not found in any record. But if I look in the error window it show my statment as follows Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110 This look correct to me.So I tried running it in access's query window and I get the same error, yet when I try to search the column for issuenumber 1110 Access finds it through its own search utility. This has me stumped.Any ideas anyone. Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Problem
No need to post your question twice.. be patient, someone will respond if they know the answer.:-) -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:42 PM To: CF-Talk Subject: SQL Problem Hello All, I am having problems with an update statement that used to work fine in Access with CFMX.I have an issue tracking app that used to have the issue numbers stored as TEXT, I converted the column to Number a little while ago and it worked fine.Recently users have been having problems updating the records. My update statement is pretty simple Update IssueRegister SET IssueStatus = '#form.IssueStatus#', Response = '#form.Response#', ResponseUserId = '#session.activeuser.USER_NAME#', DateofResponse = #CreateODBCdate(now())# Where IssueNumber = #form.issuenumber# The error that I get from CF is The search key was not found in any record. But if I look in the error window it show my statment as follows Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110 This look correct to me.So I tried running it in access's query window and I get the same error, yet when I try to search the column for issuenumber 1110 Access finds it through its own search utility. This has me stumped.Any ideas anyone. Thanks Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Problem
Hi Michael, Sorry for the double post but I thought there was something up with the list, I posted the first one two hours ago didn't see it on the list and sure enough as soon as I post again the both show up - Original Message - From: Tangorre, Michael To: CF-Talk Sent: Tuesday, December 16, 2003 12:48 PM Subject: RE: SQL Problem No need to post your question twice.. be patient, someone will respond if they know the answer.:-) -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:42 PM To: CF-Talk Subject: SQL Problem Hello All, I am having problems with an update statement that used to work fine in Access with CFMX.I have an issue tracking app that used to have the issue numbers stored as TEXT, I converted the column to Number a little while ago and it worked fine.Recently users have been having problems updating the records. My update statement is pretty simple Update IssueRegister SET IssueStatus = '#form.IssueStatus#', Response = '#form.Response#', ResponseUserId = '#session.activeuser.USER_NAME#', DateofResponse = #CreateODBCdate(now())# Where IssueNumber = #form.issuenumber# The error that I get from CF is The search key was not found in any record. But if I look in the error window it show my statment as follows Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110 This look correct to me.So I tried running it in access's query window and I get the same error, yet when I try to search the column for issuenumber 1110 Access finds it through its own search utility. This has me stumped.Any ideas anyone. Thanks Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Help
Try parameterizing your form.issuenumber variable: Update IssueRegister SET IssueStatus = '#form.IssueStatus#', Response = '#form.Response#', ResponseUserId = '#session.activeuser.USER_NAME#', DateofResponse = #CreateODBCdate(now())# Where IssueNumber = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#form.issuenumber# If that wasn't the issue, you should use it anyway :) -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 10:54 AM To: CF-Talk Subject: SQL Help Hello All, I am having problems with an update statement that used to work fine in Access with CFMX.I have an issue tracking app that used to have the issue numbers stored as TEXT, I converted the column to Number a little while ago and it worked fine.Recently users have been having problems updating the records. My update statement is pretty simple Update IssueRegister SET IssueStatus = '#form.IssueStatus#', Response = '#form.Response#', ResponseUserId = '#session.activeuser.USER_NAME#', DateofResponse = #CreateODBCdate(now())# Where IssueNumber = #form.issuenumber# The error that I get from CF is The search key was not found in any record. But if I look in the error window it show my statment as follows Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110 This look correct to me.So I tried running it in access's query window and I get the same error, yet when I try to search the column for issuenumber 1110 Access finds it through its own search utility. This has me stumped.Any ideas anyone. Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Problem
Try Trimming your vars especially since they were text before you converted them. If it was char type text there might be some padding that you don't see.. -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:56 PM To: CF-Talk Subject: Re: SQL Problem Hi Michael, Sorry for the double post but I thought there was something up with the list, I posted the first one two hours ago didn't see it on the list and sure enough as soon as I post again the both show up - Original Message - From: Tangorre, Michael To: CF-Talk Sent: Tuesday, December 16, 2003 12:48 PM Subject: RE: SQL Problem No need to post your question twice.. be patient, someone will respond if they know the answer.:-) -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:42 PM To: CF-Talk Subject: SQL Problem Hello All, I am having problems with an update statement that used to work fine in Access with CFMX.I have an issue tracking app that used to have the issue numbers stored as TEXT, I converted the column to Number a little while ago and it worked fine.Recently users have been having problems updating the records. My update statement is pretty simple Update IssueRegister SET IssueStatus = '#form.IssueStatus#', Response = '#form.Response#', ResponseUserId = '#session.activeuser.USER_NAME#', DateofResponse = #CreateODBCdate(now())# Where IssueNumber = #form.issuenumber# The error that I get from CF is The search key was not found in any record. But if I look in the error window it show my statment as follows Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110 This look correct to me.So I tried running it in access's query window and I get the same error, yet when I try to search the column for issuenumber 1110 Access finds it through its own search utility. This has me stumped.Any ideas anyone. Thanks Mike _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:UniData ODBC connectivity
Did you ever get a response to this privatly? I'm new to UniData.I'd like to set up an ODBC connection to the UniData database hosted on an NT box on the network.I read some documentation.Is the following understanding correct?Two key pieces: 1) uci.conf file, an entry pointing to the train(training) database; 2) install Unidata ODBC driver, making the ODBC datasource setup matches that. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Installing CF MX 6.1 Path about DoS
Hi there ! I installed a new path for CF MX 6.1 MPSB03-07 Security Patch available for ColdFusion MX and JRun 4.0 Web Services DoS http://www.macromedia.com/devnet/security/security_zone/mpsb03-07.html I think i put in CF Serversection: Java and JVM a wrong parameters.. Now i can't start CF Server... What can I do ? Where are stored all settings Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:UniData ODBC connectivity
No. But I'm quite comfortable with this stuff now. Did you ever get a response to this privatly? I'm new to UniData.I'd like to set up an ODBC connection to the UniData database hosted on an NT box on the network.I read some ... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Installing CF MX 6.1 Path about DoS
Now i can't start CF Server... What can I do ? Where are stored all settings If you changed the JVM configuration through the CF Administrator, you should have a backup of your jvm.config file in the same directory as the jvm.config file itself. 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: CFC Not showing in CFC Explorer
I've run into this problem as well, and I think it stems from the CFC not being within the CF web root, or a CF mapping, though I've never taken the time to confirm it for sure. In other words, if you only ever reference the CFC relatively, and haven't set anything up to be able to reference it absolutely, then it doesn't appear in CFC explorer, because there is no absolute name for it. Cheers, barneyb -Original Message- From: Alexander Sherwood [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 8:42 AM To: CF-Talk Subject: CFC Not showing in CFC Explorer What would cause a CFC/CFC package to not show in the CFC explorer? If I type the direct URL as in: http://www.myserver.com/CFIDE/componentutils/componentdetail.c fm?component=mypath.mypackage.mycfc I can browse the data. It does not appear, however, in the listing of CFCs on my server. I can also invoke the CFC properly from application pages. What would cause the CFC not to appear in the explorer? Thanks, -- Alex Sherwood PHS Collection Agency [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Installing CF MX 6.1 Path about DoS
thanks Dave I'll check it now __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:17 PM To: CF-Talk Subject: RE: Installing CF MX 6.1 Path about DoS Now i can't start CF Server... What can I do ? Where are stored all settings If you changed the JVM configuration through the CF Administrator, you should have a backup of your jvm.config file in the same directory as the jvm.config file itself. 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 Problem
Try putting # signs around the date field.I had this problem before after my service provider switch from ODBC to OLDBC. Dwayne Cole, MS in MIS, MBA Florida AM University Certified Advanced ColdFusion Developer 850-591-0212 It can truly be said that nothing happens until there is vision. But it is equally true that a vision with no underlying sense of purpose, no calling, is just a good idea - all sound and fury, signifying nothing.The Fifth Discipline - Peter Senge -- Original Message -- From: Tangorre, Michael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 16 Dec 2003 12:55:30 -0500 Try Trimming your vars especially since they were text before you converted them. If it was char type text there might be some padding that you don't see.. -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:56 PM To: CF-Talk Subject: Re: SQL Problem Hi Michael, Sorry for the double post but I thought there was something up with the list, I posted the first one two hours ago didn't see it on the list and sure enough as soon as I post again the both show up - Original Message - From: Tangorre, Michael To: CF-Talk Sent: Tuesday, December 16, 2003 12:48 PM Subject: RE: SQL Problem No need to post your question twice.. be patient, someone will respond if they know the answer.:-) -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:42 PM To: CF-Talk Subject: SQL Problem Hello All, I am having problems with an update statement that used to work fine in Access with CFMX.I have an issue tracking app that used to have the issue numbers stored as TEXT, I converted the column to Number a little while ago and it worked fine.Recently users have been having problems updating the records. My update statement is pretty simple Update IssueRegister SET IssueStatus = '#form.IssueStatus#', Response = '#form.Response#', ResponseUserId = '#session.activeuser.USER_NAME#', DateofResponse = #CreateODBCdate(now())# Where IssueNumber = #form.issuenumber# The error that I get from CF is The search key was not found in any record. But if I look in the error window it show my statment as follows Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110 This look correct to me.So I tried running it in access's query window and I get the same error, yet when I try to search the column for issuenumber 1110 Access finds it through its own search utility. This has me stumped.Any ideas anyone. Thanks Mike _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Request timed out - what does this mean?
When CF terminates a request based on the timeout parameter set in the CF Admin, and when the request being terminated is an SQL query or a request to a stored procedure (i.e., the error message in the log includes the SQL or the name of the stored procedure), is it safe to assume that the request ended with the answer set from the SQL or stored procedure still not returned to the web server? Or could it be that the answer set came back to the web server and the cfm page is still processing it? Thanks! George [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [Macromedia][Oracle JDBC Driver]No more data available to read.
You're probably still running 6.0 for specific reason but in general 6.0 = evil. Think there were major driver updates in 6.1 Stace _ From: Smith, Don , CTR , WHS/PSD [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:29 PM To: CF-Talk Subject: [Macromedia][Oracle JDBC Driver]No more data available to read. I am running CFMX 6.0, no updates, on Apache 1.3.27 and using Oracle 9i on the back end.I am getting intermittent 500 Errors: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [EMAIL PROTECTED] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Weird Images issues...
Ok, here is some weirdness for you... http://www.lcgis.com/STAGE/GlobalImages http://www.lcgis.com/STAGE/GlobalImages See the list of images, click one, does it show up...mine don't. No matter what I do they do not appear in the browser. However if I view folder in Thumbnail mode I can see them all. To boot if I go to the STAGE directory and open up Index.htm as a File-Open in IE they show up as well. This seems to be something with IIS and the folder. I have set all permissions to full and made sure they were not read only or something. I also checked in IIS and turned on browse to that folder so I could see that they were indeed there This is a Win 2K3 box running the latest and greatest IIS. Any help, any ideas. I have never ever had this happen before Thanks, Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Request timed out - what does this mean?
Usually when I see this happen is when I've written a poor query and the database server is taking longer to process said query than the CF Admin allows.In this case, the CF request is ended, but the database is still processing my request.The database server will churn and churn on the problem until it's finished, but by that time, the result has no place to go to. -Original Message- From: Earl, George [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 1:34 PM To: CF-Talk Subject: Request timed out - what does this mean? When CF terminates a request based on the timeout parameter set in the CF Admin, and when the request being terminated is an SQL query or a request to a stored procedure (i.e., the error message in the log includes the SQL or the name of the stored procedure), is it safe to assume that the request ended with the answer set from the SQL or stored procedure still not returned to the web server? Or could it be that the answer set came back to the web server and the cfm page is still processing it? Thanks! George [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Installing CF MX 6.1 Path about DoS
Problems fixed. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 01:13 PM To: CF-Talk Subject: RE: Installing CF MX 6.1 Path about DoS thanks Dave I'll check it now __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:17 PM To: CF-Talk Subject: RE: Installing CF MX 6.1 Path about DoS Now i can't start CF Server... What can I do ? Where are stored all settings If you changed the JVM configuration through the CF Administrator, you should have a backup of your jvm.config file in the same directory as the jvm.config file itself. 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 Images issues...
It appears that your files are damaged.I can't open them with Fireworks either. Cheers, Jeff - Original Message - From: Schuster, Steven To: CF-Talk Sent: Tuesday, December 16, 2003 11:39 AM Subject: Weird Images issues... Ok, here is some weirdness for you... http://www.lcgis.com/STAGE/GlobalImages http://www.lcgis.com/STAGE/GlobalImages See the list of images, click one, does it show up...mine don't. No matter what I do they do not appear in the browser. However if I view folder in Thumbnail mode I can see them all. To boot if I go to the STAGE directory and open up Index.htm as a File-Open in IE they show up as well. This seems to be something with IIS and the folder. I have set all permissions to full and made sure they were not read only or something. I also checked in IIS and turned on browse to that folder so I could see that they were indeed there This is a Win 2K3 box running the latest and greatest IIS. Any help, any ideas. I have never ever had this happen before Thanks, Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Problem
No luck, I tried trimming the vars, and the cfqueryparam cfsqltype=CF_SQL_INTEGER value=#form.issuenumber# Both turn up the same error The search key was not found in any record. But I see the information in the table.This is really weird one - Original Message - From: Tangorre, Michael To: CF-Talk Sent: Tuesday, December 16, 2003 12:55 PM Subject: RE: SQL Problem Try Trimming your vars especially since they were text before you converted them. If it was char type text there might be some padding that you don't see.. -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:56 PM To: CF-Talk Subject: Re: SQL Problem Hi Michael, Sorry for the double post but I thought there was something up with the list, I posted the first one two hours ago didn't see it on the list and sure enough as soon as I post again the both show up - Original Message - From: Tangorre, Michael To: CF-Talk Sent: Tuesday, December 16, 2003 12:48 PM Subject: RE: SQL Problem No need to post your question twice.. be patient, someone will respond if they know the answer.:-) -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:42 PM To: CF-Talk Subject: SQL Problem Hello All, I am having problems with an update statement that used to work fine in Access with CFMX.I have an issue tracking app that used to have the issue numbers stored as TEXT, I converted the column to Number a little while ago and it worked fine.Recently users have been having problems updating the records. My update statement is pretty simple Update IssueRegister SET IssueStatus = '#form.IssueStatus#', Response = '#form.Response#', ResponseUserId = '#session.activeuser.USER_NAME#', DateofResponse = #CreateODBCdate(now())# Where IssueNumber = #form.issuenumber# The error that I get from CF is The search key was not found in any record. But if I look in the error window it show my statment as follows Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110 This look correct to me.So I tried running it in access's query window and I get the same error, yet when I try to search the column for issuenumber 1110 Access finds it through its own search utility. This has me stumped.Any ideas anyone. Thanks Mike _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird Images issues...
Ok, would that explain why I can see them in the file browser or when viewing the page offline??? That's why this is kicking my butt, it just doesn't make any sense... -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 1:43 PM To: CF-Talk Subject: Re: Weird Images issues... It appears that your files are damaged.I can't open them with Fireworks either. Cheers, Jeff - Original Message - From: Schuster, Steven To: CF-Talk Sent: Tuesday, December 16, 2003 11:39 AM Subject: Weird Images issues... Ok, here is some weirdness for you... http://www.lcgis.com/STAGE/GlobalImages http://www.lcgis.com/STAGE/GlobalImages http://www.lcgis.com/STAGE/GlobalImages See the list of images, click one, does it show up...mine don't. No matter what I do they do not appear in the browser. However if I view folder in Thumbnail mode I can see them all. To boot if I go to the STAGE directory and open up Index.htm as a File-Open in IE they show up as well. This seems to be something with IIS and the folder. I have set all permissions to full and made sure they were not read only or something. I also checked in IIS and turned on browse to that folder so I could see that they were indeed there This is a Win 2K3 box running the latest and greatest IIS. Any help, any ideas. I have never ever had this happen before Thanks, Steve _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFStat from remote machine
Thanks Pete. The sample code works great. One question though. This seems to only work on CFMX 6.1 standalone install. I tried it on my Mac OX CFMX 6.0 on top of JRUN and also on a new CFMX 6.1 on JRUN (the second option given in the installer) and both times I get an error message The metrics service is not available. I know that under the JRUN install the checkboxes for Perf Mon and CFStat are gone. So here is my question, do you know how to start this service? -Peter Amiri [EMAIL PROTECTED] MySpace.com -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 11:44 PM To: CF-Talk Subject: Re: CFStat from remote machine Peter Amiri wrote: On page 21 of the new Administering ColdFusion MX mini manual it shows options for web server (-h) and web server listening port (-p) but doesn't give any examples. I would like to run a cfstat on my local machine and see info for my server. Anyone know if this works. Hi Peter, I'm not sure how that works, but you could create a cfm page and use the GetMetricData function. I just posted an example in my blog: http://www.petefreitag.com/item/101.cfm __ Pete Freitag http://www.cfdev.com Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:cfmail in cf5 spool re-sends to infinity
We (I) spent a lot of time trying to address just these types of complaints in CFMX 6.1. Upgrade and you should not see this problem ever again. And I thank you for that, really, I don't mean to be ungrateful :)In fact, the server housing our custom ticket/mail app -- which runs all customer emails in and out of the company -- has been updated to 6.1, and the mail performance is better than ever, reliable even. Unfortunately, for other servers it's not as simple as installing mx.This particular server runs auxillary operations essential to our product and data mining that have been vigurously tested for performance and reliability over years.eventually we will move it to MX, but we're not there yet. In the meantime, we have to know we can email our customers without sending them 79, or 25,000 emails.Specifically, can I bring this earlier question to your attention?This solution I seek would seem to enable us to bide our time until an mx upgrade is more feasable, and if anybody would know the answer it would probably be you: :it seems that we'll have to use something other than cfmail.but what i :don't understand -- do cfmail alternatives replace the spooling mechanism :that CF uses, or do they use the built-in CF spool?b/c it's that spooling :mechanism that is faulty, and as long as that is till being used then :there's no point in going to an alternative... Thanks again, Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Problem
But it is not the date field that is causing the issue, it the what I am using as the issue number - Original Message - From: Dwayne Cole To: CF-Talk Sent: Tuesday, December 16, 2003 1:18 PM Subject: RE: SQL Problem Try putting # signs around the date field.I had this problem before after my service provider switch from ODBC to OLDBC. Dwayne Cole, MS in MIS, MBA Florida AM University Certified Advanced ColdFusion Developer 850-591-0212 It can truly be said that nothing happens until there is vision. But it is equally true that a vision with no underlying sense of purpose, no calling, is just a good idea - all sound and fury, signifying nothing.The Fifth Discipline - Peter Senge -- Original Message -- From: Tangorre, Michael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 16 Dec 2003 12:55:30 -0500 Try Trimming your vars especially since they were text before you converted them. If it was char type text there might be some padding that you don't see.. -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:56 PM To: CF-Talk Subject: Re: SQL Problem Hi Michael, Sorry for the double post but I thought there was something up with the list, I posted the first one two hours ago didn't see it on the list and sure enough as soon as I post again the both show up - Original Message - From: Tangorre, Michael To: CF-Talk Sent: Tuesday, December 16, 2003 12:48 PM Subject: RE: SQL Problem No need to post your question twice.. be patient, someone will respond if they know the answer.:-) -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:42 PM To: CF-Talk Subject: SQL Problem Hello All, I am having problems with an update statement that used to work fine in Access with CFMX.I have an issue tracking app that used to have the issue numbers stored as TEXT, I converted the column to Number a little while ago and it worked fine.Recently users have been having problems updating the records. My update statement is pretty simple Update IssueRegister SET IssueStatus = '#form.IssueStatus#', Response = '#form.Response#', ResponseUserId = '#session.activeuser.USER_NAME#', DateofResponse = #CreateODBCdate(now())# Where IssueNumber = #form.issuenumber# The error that I get from CF is The search key was not found in any record. But if I look in the error window it show my statment as follows Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110 This look correct to me.So I tried running it in access's query window and I get the same error, yet when I try to search the column for issuenumber 1110 Access finds it through its own search utility. This has me stumped.Any ideas anyone. Thanks Mike _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Problem
Here is a long shot.. Have you double checked to be sure you don't have an ambiguous table name or are connecting to the wrong datasource (IE a development datasource)? Kore Peterson Mickael [EMAIL PROTECTED] To:CF-Talk [EMAIL PROTECTED] netcc: Subject:Re: SQL Problem 12/16/2003 12:59 PM Please respond to cf-talk But it is not the date field that is causing the issue, it the what I am using as the issue number - Original Message - From: Dwayne Cole To: CF-Talk Sent: Tuesday, December 16, 2003 1:18 PM Subject: RE: SQL Problem Try putting # signs around the date field.I had this problem before after my service provider switch from ODBC to OLDBC. Dwayne Cole, MS in MIS, MBA Florida AM University Certified Advanced ColdFusion Developer 850-591-0212 It can truly be said that nothing happens until there is vision. But it is equally true that a vision with no underlying sense of purpose, no calling, is just a good idea - all sound and fury, signifying nothing. The Fifth Discipline - Peter Senge -- Original Message -- From: Tangorre, Michael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 16 Dec 2003 12:55:30 -0500 Try Trimming your vars especially since they were text before you converted them. If it was char type text there might be some padding that you don't see.. -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:56 PM To: CF-Talk Subject: Re: SQL Problem Hi Michael, Sorry for the double post but I thought there was something up with the list, I posted the first one two hours ago didn't see it on the list and sure enough as soon as I post again the both show up - Original Message - From: Tangorre, Michael To: CF-Talk Sent: Tuesday, December 16, 2003 12:48 PM Subject: RE: SQL Problem No need to post your question twice.. be patient, someone will respond if they know the answer.:-) -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:42 PM To: CF-Talk Subject: SQL Problem Hello All, I am having problems with an update statement that used to work fine in Access with CFMX.I have an issue tracking app that used to have the issue numbers stored as TEXT, I converted the column to Number a little while ago and it worked fine.Recently users have been having problems updating the records. My update statement is pretty simple Update IssueRegister SET IssueStatus = '#form.IssueStatus#', Response = '#form.Response#', ResponseUserId = '#session.activeuser.USER_NAME#', DateofResponse = #CreateODBCdate(now())# Where IssueNumber = #form.issuenumber# The error that I get from CF is The search key was not found in any record. But if I look in the error window it show my statment as follows Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110 This look correct to me.So I tried running it in access's query window and I get the same error, yet when I try to search the column for issuenumber 1110 Access finds it through its own search utility. This has me stumped.Any ideas anyone. Thanks Mike _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [Macromedia][Oracle JDBC Driver]No more data available to read.
I've seen this error a lot when working with ORACLE from EJB's on CFMX J2EE - usually when callingprocedures that return XML.Have you tried using the thin client drivers?Can you put updater 3 on the box first? ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -Original Message- From: Smith, Don , CTR , WHS/PSD [mailto:[EMAIL PROTECTED] Sent: 16 December 2003 17:29 To: CF-Talk Subject: [Macromedia][Oracle JDBC Driver]No more data available to read. I am running CFMX 6.0, no updates, on Apache 1.3.27 and using Oracle 9i on the back end.I am getting intermittent 500 Errors: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [EMAIL PROTECTED] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Request timed out - what does this mean?
We had some timeout issues with the first version of CFMX and its default jvm.(I believe the default jvm had a known issue with timing out https requests)After a few posts here and the macromedia forums, I came away with the understanding that the timeout does NOT apply to external processes, including cfquery and cfhttp. If the long running-ness is caused by an external process, you will see things in the log like template ran 900 seconds even with a timeout of 60 in the admin. Long running cf-centric processes will obey the timeout specified. I am not absolutely certain on this, however, so hopefully anyone one here more knowledgeable then I can clear up anything I got wrong.Just figured I would put something out there, if anything to help guide you own research. Cheers, Matthew -Original Message- From: Hagan, Ryan Mr (Contractor ACI) [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:39 PM To: CF-Talk Subject: RE: Request timed out - what does this mean? Usually when I see this happen is when I've written a poor query and the database server is taking longer to process said query than the CF Admin allows.In this case, the CF request is ended, but the database is still processing my request.The database server will churn and churn on the problem until it's finished, but by that time, the result has no place to go to. -Original Message- From: Earl, George [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 1:34 PM To: CF-Talk Subject: Request timed out - what does this mean? When CF terminates a request based on the timeout parameter set in the CF Admin, and when the request being terminated is an SQL query or a request to a stored procedure (i.e., the error message in the log includes the SQL or the name of the stored procedure), is it safe to assume that the request ended with the answer set from the SQL or stored procedure still not returned to the web server? Or could it be that the answer set came back to the web server and the cfm page is still processing it? Thanks! George [EMAIL PROTECTED] _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Problem
Update IssueRegister SET IssueStatus = '#form.IssueStatus#', Response = '#form.Response#', ResponseUserId = '#session.activeuser.USER_NAME#', DateofResponse = #CreateODBCdate(now())# Where IssueNumber = #form.issuenumber# The error that I get from CF is The search key was not found in any record. But if I look in the error window it show my statment as follows Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110 This look correct to me.So I tried running it in access's query window and I get the same error, yet when I try to search the column for issuenumber 1110 Access finds it through its own search utility. This is most probably a problem with Access and not your SQL statement or ColdFusion. Try a search in Google Groups for The search key was not found in any record. There appear to be any number of scenarios that can lead to this vague error message - replication, memo fields, Jet version, etc.You are definitely not the only one who has experienced this. Here's something else you might try if it's feasible: Try creating a new (blank) Access database. Immediately turn off Name AutoCorrect (Tools | Options | General). Then import everything from the old database (File | Get External | Import). Recreating everything like that may solve the issue. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird Images issues...
What's weird is that you can view the source after clicking on an image, so it's an html page that is loading, not the image.something is up with your webserver, at least i think -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 1:51 PM To: CF-Talk Subject: RE: Weird Images issues... Ok, would that explain why I can see them in the file browser or when viewing the page offline??? That's why this is kicking my butt, it just doesn't make any sense... -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 1:43 PM To: CF-Talk Subject: Re: Weird Images issues... It appears that your files are damaged.I can't open them with Fireworks either. Cheers, Jeff - Original Message - From: Schuster, Steven To: CF-Talk Sent: Tuesday, December 16, 2003 11:39 AM Subject: Weird Images issues... Ok, here is some weirdness for you... http://www.lcgis.com/STAGE/GlobalImages http://www.lcgis.com/STAGE/GlobalImages http://www.lcgis.com/STAGE/GlobalImages See the list of images, click one, does it show up...mine don't. No matter what I do they do not appear in the browser. However if I view folder in Thumbnail mode I can see them all. To boot if I go to the STAGE directory and open up Index.htm as a File-Open in IE they show up as well. This seems to be something with IIS and the folder. I have set all permissions to full and made sure they were not read only or something. I also checked in IIS and turned on browse to that folder so I could see that they were indeed there This is a Win 2K3 box running the latest and greatest IIS. Any help, any ideas. I have never ever had this happen before Thanks, Steve _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird Images issues...
Yeah, it is really freaky weird. Oh well, on to other things...I'll let you all know what it was when I fix it. Steve -Original Message- From: Turetsky, Seth [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 2:41 PM To: CF-Talk Subject: RE: Weird Images issues... What's weird is that you can view the source after clicking on an image, so it's an html page that is loading, not the image.something is up with your webserver, at least i think -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 1:51 PM To: CF-Talk Subject: RE: Weird Images issues... Ok, would that explain why I can see them in the file browser or when viewing the page offline??? That's why this is kicking my butt, it just doesn't make any sense... -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 1:43 PM To: CF-Talk Subject: Re: Weird Images issues... It appears that your files are damaged.I can't open them with Fireworks either. Cheers, Jeff - Original Message - From: Schuster, Steven To: CF-Talk Sent: Tuesday, December 16, 2003 11:39 AM Subject: Weird Images issues... Ok, here is some weirdness for you... http://www.lcgis.com/STAGE/GlobalImages http://www.lcgis.com/STAGE/GlobalImages http://www.lcgis.com/STAGE/GlobalImages http://www.lcgis.com/STAGE/GlobalImages See the list of images, click one, does it show up...mine don't. No matter what I do they do not appear in the browser. However if I view folder in Thumbnail mode I can see them all. To boot if I go to the STAGE directory and open up Index.htm as a File-Open in IE they show up as well. This seems to be something with IIS and the folder. I have set all permissions to full and made sure they were not read only or something. I also checked in IIS and turned on browse to that folder so I could see that they were indeed there This is a Win 2K3 box running the latest and greatest IIS. Any help, any ideas. I have never ever had this happen before Thanks, Steve _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Problem
Stephen Thanks a lot that did it.I can now stop banging my head against the wall - Original Message - From: Stephen Hait To: CF-Talk Sent: Tuesday, December 16, 2003 2:39 PM Subject: Re: SQL Problem Update IssueRegister SET IssueStatus = '#form.IssueStatus#', Response = '#form.Response#', ResponseUserId = '#session.activeuser.USER_NAME#', DateofResponse = #CreateODBCdate(now())# Where IssueNumber = #form.issuenumber# The error that I get from CF is The search key was not found in any record. But if I look in the error window it show my statment as follows Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110 This look correct to me.So I tried running it in access's query window and I get the same error, yet when I try to search the column for issuenumber 1110 Access finds it through its own search utility. This is most probably a problem with Access and not your SQL statement or ColdFusion. Try a search in Google Groups for The search key was not found in any record. There appear to be any number of scenarios that can lead to this vague error message - replication, memo fields, Jet version, etc.You are definitely not the only one who has experienced this. Here's something else you might try if it's feasible: Try creating a new (blank) Access database. Immediately turn off Name AutoCorrect (Tools | Options | General). Then import everything from the old database (File | Get External | Import). Recreating everything like that may solve the issue. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Dynamic variable names in QuerySetCell
I'm trying to avoid Evaluate and have hit a wall. I am trying to dynamically call column names from qResults and set the values in a QuerySetCell - val1, val2, val3, val4, etc... Here's an example: cfset Monthly2003= QueryNew(month, dollar_amount) cfset QueryAddRow(Monthly2003, 12) cfloop index=LoopCount from=1 to=12 cfset QuerySetCell(Monthly2003, month, curMonth, LoopCount) cfset QuerySetCell(Monthly2003, dollar_amount, qResults[valLoopCount], LoopCount) /cfloop The second QuerySetCell is what is killing me. It gives the wretched, Complex objects cannot be converted to simple values error. -- Ryan Kime mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Web Developer Webco Industries [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC Not showing in CFC Explorer
Is the CFC stored in the standard custom tags directory in CF? If it isn't then you need to create a CF mapping to the directory where the CFC is found. Then it should show. -Gel -Original Message- From: Alexander Sherwood [mailto:[EMAIL PROTECTED] What would cause a CFC/CFC package to not show in the CFC explorer? If I type the direct URL as in: HYPERLINK http://www.myserver.com/CFIDE/componentutils/componentdetail.chttp://w ww.myserver.com/CFIDE/componentutils/componentdetail.c fm?component=mypath.mypackage.mycfc I can browse the data. It does not appear, however, in the listing of CFCs on my server. I can also invoke the CFC properly from application pages. What would cause the CFC not to appear in the explorer? Thanks, --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.544 / Virus Database: 338 - Release Date: 11/25/2003 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: Dynamic variable names in QuerySetCell
Original Message: From: Ryan Kime [EMAIL PROTECTED] cfloop index=LoopCount from=1 to=12 cfset QuerySetCell(Monthly2003, month, curMonth, LoopCount) cfset QuerySetCell(Monthly2003, dollar_amount, qResults[valLoopCount], LoopCount) /cfloop The second QuerySetCell is what is killing me. It gives the wretched, Complex objects cannot be converted to simple values error. How many rows does qResults turn? I think what you need is qResults[val loopCount][1]to get just the first row's val1 value (even if the query only returns 1 row). It's just an educated guess, but it's worth a shot. Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Getting directory name only
Hi! I'm trying to get the name of the directory that houses template. The problem is that I just need the directory's name. For example, given the actual path: C:\whatever\whateverElse\myDirectory\myTemplate I need to extract the directory's name (myDirectory) into a variable. I have been able to do it by using cfset myDirectory=REReplace(cgi.script_name,/[^/]*$,) cfoutput#ListLast(myDirectory, /)#/cfoutput but wondered if there is a simpler or better way of doing the same. thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
multi-part emails?
Does anyone have a good _simple_ resource for how to create multi-part email messages using CFMAIL?Or is that even possible?I know type can be plain or HTML, but I'm not sure how to create a multi-part email where it will display HTML if the client can read it and plain text if the client can not.Any help would be greatly appreciated. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
shouldn't be getting cfquery output ?
At the bottom of my page I'm getting the following. Queries getit (Records=1, Time=47ms) SQL = select * from order_users where id = 2 This shouldn't be appearing at all. None of my other templates have the query information appearing, why would this page have it. As far as I know debugging isn't turned on. If it was the query info would appear on my other pages. __ Daniel Farmer Producer / Coldfusion Developer http://www.bernardclark.com/danfarmer.ca P: 613.284.1684 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: multi-part emails?
if you're using the latest and greatest, http://www.macromedia.com/devnet/mx/coldfusion/articles/mail_61_02.html -Original Message- From: John Burns [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 4:08 PM To: CF-Talk Subject: multi-part emails? Does anyone have a good _simple_ resource for how to create multi-part email messages using CFMAIL?Or is that even possible?I know type can be plain or HTML, but I'm not sure how to create a multi-part email where it will display HTML if the client can read it and plain text if the client can not.Any help would be greatly appreciated. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: multi-part emails?
Does anyone have a good _simple_ resource for how to create multi-part email messages using CFMAIL? Or is that even possible? I know type can be plain or HTML, but I'm not sure how to create a multi-part email where it will display HTML if the client can read it and plain text if the client can not. Any help would be greatly appreciated. If you're using CFMX 6.1, you can use the CFMAILPART tag to have HTML and text within a single message. I'm pretty sure that the client will show the plaintext CFMAILPART if it doesn't understand HTML. If you're using CF 5 or earlier versions, there are custom tags to help construct multipart messages. I believe Jochem's site has one. 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: Adding remote datasource dynamically
If anyone is interested I am about to release a suite of tools, its been in the making for the last 2 months but its finally almost ready to release. If you have ever wanted to create, verify, delete a datasource within a coldfusion application then this Coldfusion component will be for you. Currently only works on CF Mx 6.1, haven't tested it on MX 6.0 and works on SQL Server with the others to follow in the next few weeks. If you wish to express your interest in these tools, send me an email offline. _ From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, 16 December 2003 6:41 PM To: CF-Talk Subject: Re:Adding remote datasource dynamically Don said: Same result after ds.password = ds_service.encryptPasword(#FORM.pwd#); ds.password = ds_service.encryptPasword(javaCast(string,FORM.pwd)); Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dynamic variable names in QuerySetCell
Good question Scott, the recordcount of qResults will always be 1. FYI, adding the [1] worked! Thanks! -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 3:05 PM To: CF-Talk Subject: re: Dynamic variable names in QuerySetCell Original Message: From: Ryan Kime [EMAIL PROTECTED] cfloop index=LoopCount from=1 to=12 cfset QuerySetCell(Monthly2003, month, curMonth, LoopCount) cfset QuerySetCell(Monthly2003, dollar_amount, qResults[valLoopCount], LoopCount) /cfloop The second QuerySetCell is what is killing me. It gives the wretched, Complex objects cannot be converted to simple values error. How many rows does qResults turn? I think what you need is qResults[val loopCount][1]to get just the first row's val1 value (even if the query only returns 1 row). It's just an educated guess, but it's worth a shot. Scott --- Scott Brady http://www.scottbrady.net/ http://www.scottbrady.net/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ColdFusion Blog App from Macromedia DevNet Resource Kit V5
The Macromedia DevNet Resource Kit team is looking for suggestions on how to improve or enhance the ColdFusion Blog App (a.k.a. Blogman) from DRK Volume 5. If you used the Blogman application (http://www.macromedia.com/software/drk/productinfo/product_overview/volume5/coldfusionmx.html#blog_man_application) and have feature requests, please respond to this post or feel free to send them directly to me. Thanks, Heidi Voltmer Macromedia [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: shouldn't be getting cfquery output ?
Definitely debugging information, Try cfsetting showdebugoutput=no and see if it disappears, Jb. -Original Message- From: Dan Farmer [mailto:[EMAIL PROTECTED] Sent: 16 December 2003 21:17 To: CF-Talk Subject: shouldn't be getting cfquery output ? At the bottom of my page I'm getting the following. Queries getit (Records=1, Time=47ms) SQL = select * from order_users where id = 2 This shouldn't be appearing at all. None of my other templates have the query information appearing, why would this page have it. As far as I know debugging isn't turned on. If it was the query info would appear on my other pages. __ Daniel Farmer Producer / Coldfusion Developer http://www.bernardclark.com/danfarmer.ca P: 613.284.1684 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:ColdFusion Blog App from Macromedia DevNet Resource Kit V5
Perhaps a better investment of Macromedia's resources would be to create applications with a bigger potential user base. A blogging application is kind of useless to most people. We frequently come across them (blogs) because of the nature of our work, but something like a Newletter Manager, an Events Manager, a Web Photo Album would appeal to a wider audience. Sorry I can't offer a specific answer to your question! (I have a DevNet subscription, but -like most people- have no use for a blog). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
BIG Forms: CFSWITCH or CFIF?
I'm going over old code that has pre-filled form fields based on previous user entry.Many are select boxes or radio groups with lots of options.The current coding method is shown in Method 1 below.The common way I see recommended to do this is in Method 2.Before I rewrite this code, I thought I'd ask which y'all think is the better approach for a big form. Method 1 is verbose, but its use of cfswitch might be faster? Method 2 is easier to code, but uses slower cfifs.Lots of them on longer forms. So on a form with a couple of dozen fields like this, which do you think is faster/a better approach? !---METHOD 1--- cfparam name=variables.LocalAA01 default= type=string cfparam name=variables.LocalAA02 default= type=string cfswitch _expression_=#QName.AA# cfcase value=A cfset variables.LocalAA01= selected /cfcase cfcase value=B cfset variables.LocalAA02= selected /cfcase cfdefaultcase cfset variables.LocalAA01= selected /cfdefaultcase /cfswitch SELECT name=AA OPTION value=A#variables.LocalAA01#Choice A OPTION value=B#variables.LocalAA02#Choice B /SELECT !---METHOD 2--- SELECT name=AA OPTION value=Acfif not CompareNoCase(QName.AA,A) selected/cfifChoice A OPTION value=Bcfif not CompareNoCase(QName.AA,B) selected/cfifChoice B /SELECT -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Logging out on session expiration under MX
I am porting our application to MX 6.1. We are not refactoring anything yet, simply re-deploying. However, I decided to redo the login mechanism using cflogin architecture. In my Application.cfm I have: cfif not isdefined(session.loggedin) cfinclude template=_login.cfm /cfif _login.cfm, among other things, instantiates session.loggedin var. What I am experience is that upon session expiration the above cfif block in Application.cfm doesn't get prevent the application to execute further. What am I missing? We are not using J2EE session variables, but I have this in my application.cfm: cfif isdefined('cookie.cfid') and isdefined('cookie.cftoken') cfset localCFID = cookie.cfid cfset localCFToken = cookie.CFTOKEN cfcookie name = CFID value = #localCFID# cfcookie name = CFTOKEN value = #localCFTOKEN# /cfif Thanks for any tips! Stas [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:ColdFusion Blog App from Macromedia DevNet Resource Kit V5
Irvin Gomez wrote: Perhaps a better investment of Macromedia's resources would be to create applications with a bigger potential user base Macromedia chopping down their developer base by starting to build end-user applications?As a developer I'd call that a pretty bad idea... Correction.A REALLY bad idea. If you want any of the things you describe, there are developers who will build them for you, or who sell them pre-built already.Cheap. -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL Less Then comparison and cfqueryparam
Is there some trick to doing a less then () comparison combined with a cfqueryparam tag? I've got a query something like this. SELECT * FROM aTable WHERE DateField = (SELECT Max(DateField) FROM aTable WHERE DateField cfqueryParam value=#url.date#...) I'm trying to select the previous record in aTable by date to the value in url.date, which corresponds to another record in aTable.. This does not throw an error, but it also does not return any records when there is one that should be returned.I notice in the debug window that the SQL statement is truncated at the first left angle bracket ().I suspect it is being treated as an open tag character, but I'm not sure what to do about it if it is.lt; does not work in a SQL statement. Thanks. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: BIG Forms: CFSWITCH or CFIF?
Method 2 for sure.At the Java level, both the CFIF and the CFSWITCH are both if statements, because the Java switch statement only works on numeric types (byte, short, int, long and char).Then, factor in the extra assignment overhead on method 1, count the number of extra lines in method 1, and then the vastly superior readability of method 2, and I think it's a pretty clear-cut case.At least in my mind.;) IMHO, 99.9% of the time, readable, easily maintainable code is way more valuable than speed.If we're talking about the last fractions of a percent of performace, than it's almost never worth it.Better to spend 10 minutes optimizing some query, since that might actually result in several milliseconds of speed. Cheers, barneyb -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 1:58 PM To: CF-Talk Subject: BIG Forms: CFSWITCH or CFIF? I'm going over old code that has pre-filled form fields based on previous user entry.Many are select boxes or radio groups with lots of options.The current coding method is shown in Method 1 below.The common way I see recommended to do this is in Method 2.Before I rewrite this code, I thought I'd ask which y'all think is the better approach for a big form. Method 1 is verbose, but its use of cfswitch might be faster? Method 2 is easier to code, but uses slower cfifs.Lots of them on longer forms. So on a form with a couple of dozen fields like this, which do you think is faster/a better approach? !---METHOD 1--- cfparam name=variables.LocalAA01 default= type=string cfparam name=variables.LocalAA02 default= type=string cfswitch _expression_=#QName.AA# cfcase value=A cfset variables.LocalAA01= selected /cfcase cfcase value=B cfset variables.LocalAA02= selected /cfcase cfdefaultcase cfset variables.LocalAA01= selected /cfdefaultcase /cfswitch SELECT name=AA OPTION value=A#variables.LocalAA01#Choice A OPTION value=B#variables.LocalAA02#Choice B /SELECT !---METHOD 2--- SELECT name=AA OPTION value=Acfif not CompareNoCase(QName.AA,A) selected/cfifChoice A OPTION value=Bcfif not CompareNoCase(QName.AA,B) selected/cfifChoice B /SELECT -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Adding remote datasource dynamically
What's your email address?I'm on CFMX 6.0.Thanks. Don If anyone is interested I am about to release a suite of tools, its been in the making for the last 2 months but its finally almost ready to release. If you have ever wanted to create, verify, delete a datasource within a coldfusion application then this Coldfusion component will be for you. Currently only works on CF Mx 6.1, haven't tested it on MX 6.0 and works on SQL Server with the others to follow in the next few weeks. If you wish to express your interest in these tools, send me an email offline. _ From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, 16 December 2003 6:41 PM To: CF-Talk Subject: Re:Adding remote datasource dynamically Don said: Same result after ds.password = ds_service.encryptPasword(#FORM.pwd#); ds.password = ds_service.encryptPasword(javaCast(string,FORM.pwd)); Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Re:ColdFusion Blog App from Macromedia DevNet Resource Kit V5
Matt said: Macromedia chopping down their developer base by starting to build end-user applications?As a developer I'd call that a pretty bad idea... Correction.A REALLY bad idea. I missed this whole thread..but this concept is not new ;-)Just look at Breeze...it's just an app written with Flash Comm server and Flash (very well done...but still just a web app that alot of us could build given time). I'm a bit on the fence one the whole thingcould raise CF awareness if they build decent marketable appscould be bad if those apps become industry standard and nobody wants custom development now I'll crawl back under my rock Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Matt Robertson To: CF-Talk Sent: Tuesday, December 16, 2003 2:04 PM Subject: Re:ColdFusion Blog App from Macromedia DevNet Resource Kit V5 Irvin Gomez wrote: Perhaps a better investment of Macromedia's resources would be to create applications with a bigger potential user base Macromedia chopping down their developer base by starting to build end-user applications?As a developer I'd call that a pretty bad idea... Correction.A REALLY bad idea. If you want any of the things you describe, there are developers who will build them for you, or who sell them pre-built already.Cheap. -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: BIG Forms: CFSWITCH or CFIF?
Barney Boisvert wrote: Method 2 for sure.At the Java level, both the CFIF and the CFSWITCH are both if statements Very Interesting.I'm still running on CF 4.5 but I'll be upgrading to 6.1 shoertly. IMHO, 99.9% of the time, readable, easily maintainable code is way more valuable than speed Absolutely.I've got about 50 of these forms, and some of them have up to 250 lines of this stuff at page top.On the other side, though,is this is part of a very complex insurance rating system, where the execution time for the process at hand is about 3000 (three thousand) ms.At that scale I'm really conscious of exec times. -- Original Message -- From: Barney Boisvert [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 16 Dec 2003 14:05:33 -0800 Method 2 for sure.At the Java level, both the CFIF and the CFSWITCH are both if statements, because the Java switch statement only works on numeric types (byte, short, int, long and char).Then, factor in the extra assignment overhead on method 1, count the number of extra lines in method 1, and then the vastly superior readability of method 2, and I think it's a pretty clear-cut case.At least in my mind.;) IMHO, 99.9% of the time, readable, easily maintainable code is way more valuable than speed.If we're talking about the last fractions of a percent of performace, than it's almost never worth it.Better to spend 10 minutes optimizing some query, since that might actually result in several milliseconds of speed. Cheers, barneyb -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 1:58 PM To: CF-Talk Subject: BIG Forms: CFSWITCH or CFIF? I'm going over old code that has pre-filled form fields based on previous user entry.Many are select boxes or radio groups with lots of options.The current coding method is shown in Method 1 below.The common way I see recommended to do this is in Method 2.Before I rewrite this code, I thought I'd ask which y'all think is the better approach for a big form. Method 1 is verbose, but its use of cfswitch might be faster? Method 2 is easier to code, but uses slower cfifs.Lots of them on longer forms. So on a form with a couple of dozen fields like this, which do you think is faster/a better approach? !---METHOD 1--- cfparam name=variables.LocalAA01 default= type=string cfparam name=variables.LocalAA02 default= type=string cfswitch _expression_=#QName.AA# cfcase value=A cfset variables.LocalAA01= selected /cfcase cfcase value=B cfset variables.LocalAA02= selected /cfcase cfdefaultcase cfset variables.LocalAA01= selected /cfdefaultcase /cfswitch SELECT name=AA OPTION value=A#variables.LocalAA01#Choice A OPTION value=B#variables.LocalAA02#Choice B /SELECT !---METHOD 2--- SELECT name=AA OPTION value=Acfif not CompareNoCase(QName.AA,A) selected/cfifChoice A OPTION value=Bcfif not CompareNoCase(QName.AA,B) selected/cfifChoice B /SELECT -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Resolved: Re:CFMX and Fedora
I am trying to install CFMX 6.1 with Fedora Core 1 and am running into the exact same problem described. Can you give any more detail as to how you solved the problem? I am just installing CF from a .bin file and am not sure how to recompile the connectors. Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF PHP Same Server
Does anyone have experience with CF PHP on the same server? Any notes on tricks and issues would be appreciated. Sincerely yours, Jim Gurfein President, CEO RestaurantRow.com, Inc. http://www.restaurantrow.com 914.921.3200 ext 101 914.921.9190 fax [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Blog App from Macromedia DevNet Resource Kit V5
Hi, These are sample applications that are distributed on the DevNet Resource Kits. They are just like the sample applications that are available on the Macromedia website except they are only available to anyone who buys the kits or anyone who is a DevNet subscriber. They are designed to be samples of what you can do with Macromedia products. Thanks, Heidi -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 2:05 PM To: CF-Talk Subject: Re:ColdFusion Blog App from Macromedia DevNet Resource Kit V5 Irvin Gomez wrote: Perhaps a better investment of Macromedia's resources would be to create applications with a bigger potential user base Macromedia chopping down their developer base by starting to build end-user applications?As a developer I'd call that a pretty bad idea... Correction. A REALLY bad idea. If you want any of the things you describe, there are developers who will build them for you, or who sell them pre-built already.Cheap. -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com http://mysecretbase.com --- -- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
shouldn't be getting cfquery output ? ( solved )
Thanks John, that did it. __ Daniel Farmer Producer / Coldfusion Developer http://www.bernardclark.com/danfarmer.ca P: 613.284.1684 From: John Beynon [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: shouldn't be getting cfquery output ? Date: Tue, 16 Dec 2003 21:32:47 - Definitely debugging information, Try cfsetting showdebugoutput=no and see if it disappears, Jb. -Original Message- From: Dan Farmer [mailto:[EMAIL PROTECTED] Sent: 16 December 2003 21:17 To: CF-Talk Subject: shouldn't be getting cfquery output ? At the bottom of my page I'm getting the following. Queries getit (Records=1, Time=47ms) SQL = select * from order_users where id = 2 This shouldn't be appearing at all. None of my other templates have the query information appearing, why would this page have it. As far as I know debugging isn't turned on. If it was the query info would appear on my other pages. __ Daniel Farmer Producer / Coldfusion Developer http://www.bernardclark.com/danfarmer.ca P: 613.284.1684 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Blog App from Macromedia DevNet Resource Kit V5
Heidi, Lest anyone get the wrong idea, I wasn't squealing about you folks building sample apps/applets etc.Different class of stuff.Channel conflict is just a sore spot with me. Cheers, -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF PHP Same Server
No problems that I ever experienced.I'm running CFMX6.1, PHP, and Perl on IIS. -Novak -Original Message- From: Jim Gurfein [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 2:18 PM To: CF-Talk Subject: CF PHP Same Server Does anyone have experience with CF PHP on the same server? Any notes on tricks and issues would be appreciated. Sincerely yours, Jim Gurfein President, CEO RestaurantRow.com, Inc. http://www.restaurantrow.com 914.921.3200 ext 101 914.921.9190 fax _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Blog App from Macromedia DevNet Resource Kit V5
Some suggestions I have to get this back on topic. 1. Video Blogging 2. Audio Blogging 3. Moblogging 4. RDMS ability. -Original Message- From: Heidi Voltmer [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 5:22 PM To: CF-Talk Subject: RE: ColdFusion Blog App from Macromedia DevNet Resource Kit V5 Hi, These are sample applications that are distributed on the DevNet Resource Kits. They are just like the sample applications that are available on the Macromedia website except they are only available to anyone who buys the kits or anyone who is a DevNet subscriber. They are designed to be samples of what you can do with Macromedia products. Thanks, Heidi [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: SQL Less Then comparison and cfqueryparam
Original Message: From: Ian Skinner [EMAIL PROTECTED] SELECT * FROM aTable WHERE DateField = (SELECT Max(DateField) FROM aTable WHERE DateField cfqueryParam value=#url.date#...) This does not throw an error, but it also does not return any records when there is one that should be returned.I notice in the debug window that the SQL statement is truncated at the first left angle bracket ().I suspect it is being treated as an open tag character, but I'm not sure what to do about it if it is.lt; does not work in a SQL statement. There's no trick with using the less than sign with cfqueryparam.However, there are tricks to doing date comparisons that are different for different databases.I'd say look to see if your database has a date comparison function. Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Blog App from Macromedia DevNet Resource Kit V5
some of them are more than sample apps... some of the DRK stuff is useful within other apps.There have been APIs, image manipulation modules, development tools, etc.Lot's of good stuff - whatever you're after. ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -Original Message- From: Heidi Voltmer [mailto:[EMAIL PROTECTED] Sent: 16 December 2003 22:22 To: CF-Talk Subject: RE: ColdFusion Blog App from Macromedia DevNet Resource Kit V5 Hi, These are sample applications that are distributed on the DevNet Resource Kits. They are just like the sample applications that are available on the Macromedia website except they are only available to anyone who buys the kits or anyone who is a DevNet subscriber. They are designed to be samples of what you can do with Macromedia products. Thanks, Heidi -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 2:05 PM To: CF-Talk Subject: Re:ColdFusion Blog App from Macromedia DevNet Resource Kit V5 Irvin Gomez wrote: Perhaps a better investment of Macromedia's resources would be to create applications with a bigger potential user base Macromedia chopping down their developer base by starting to build end-user applications?As a developer I'd call that a pretty bad idea... Correction. A REALLY bad idea. If you want any of the things you describe, there are developers who will build them for you, or who sell them pre-built already.Cheap. -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com http://mysecretbase.com --- -- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:ColdFusion Blog App from Macromedia DevNet Resource Kit V5
Hey, Matt: thanks for the personal attack, but I must inform you that I don't need any cheap applications. My guess is that you were probably trying to sell some of the ones you produce (real cheap in your case - using the Milonic DHTML menu beast, for example). Aren't you chopping down some sort of base? In any case, all those applications in the DevNet subscription are bare bones applications that need further development time and effort before they are sold to most non-developer clients. They don't undermine anything. I wouldn't feel threatened by them, but it's your right to feel different, of course. irv Irvin Gomez wrote: Perhaps a better investment of Macromedia's resources would be to create applications with a bigger potential user base Macromedia chopping down their developer base by starting to build end-user applications?As a developer I'd call that a pretty bad idea... Correction.A REALLY bad idea. If you want any of the things you describe, there are developers who will build them for you, or who sell them pre-built already.Cheap. -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF PHP Same Server
Likewise... No probs here On 16/12/03 10:26 pm, cf-talk [EMAIL PROTECTED] wrote: No problems that I ever experienced.I'm running CFMX6.1, PHP, and Perl on IIS. -Novak -Original Message- From: Jim Gurfein [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 2:18 PM To: CF-Talk Subject: CF PHP Same Server Does anyone have experience with CF PHP on the same server? Any notes on tricks and issues would be appreciated. Sincerely yours, Jim Gurfein President, CEO RestaurantRow.com, Inc. http://www.restaurantrow.com 914.921.3200 ext 101 914.921.9190 fax _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF PHP Same Server
Thanks for letting me know... appreciate it! At 05:52 PM 12/16/2003, you wrote: Likewise... No probs here On 16/12/03 10:26 pm, cf-talk [EMAIL PROTECTED] wrote: No problems that I ever experienced.I'm running CFMX6.1, PHP, and Perl on IIS. -Novak -Original Message- From: Jim Gurfein [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 2:18 PM To: CF-Talk Subject: CF PHP Same Server Does anyone have experience with CF PHP on the same server? Any notes on tricks and issues would be appreciated. Sincerely yours, Jim Gurfein President, CEO RestaurantRow.com, Inc. http://www.restaurantrow.comhttp://www.restaurantrow.com 914.921.3200 ext 101 914.921.9190 fax _ -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:ColdFusion Blog App from Macromedia DevNet Resource Kit V5
Snot-nosed attacks don't belong here, so I apologize if what I said rubbed you wrong.Further, my point had nothing to do with anything I do or sell.It was about preserving the market for all of us.Yourself included. -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:ColdFusion Blog App from Macromedia DevNet Resource Kit V5
Issue dropped, as far as I'm concerned. Let's just go back to a heathy discussion. Snot-nosed attacks don't belong here, so I apologize if what I said rubbed you wrong.Further, my point had nothing to do with anything I do or sell.It was about preserving the market for all of us. Yourself included. -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Less Then comparison and cfqueryparam
Ian Skinner wrote: Is there some trick to doing a less then () comparison combined with a cfqueryparam tag? I've got a query something like this. SELECT * FROM aTable WHERE DateField = (SELECT Max(DateField) FROM aTable WHERE DateField cfqueryParam value=#url.date#...) I'm trying to select the previous record in aTable by date to the value in url.date, which corresponds to another record in aTable.. This does not throw an error, but it also does not return any records when there is one that should be returned.I notice in the debug window that the SQL statement is truncated at the first left angle bracket ().I suspect it is being treated as an open tag character, but I'm not sure what to do about it if it is.lt; does not work in a SQL statement. SELECT * FROM aTable WHERE DateField = (SELECT Max(DateField) FROM aTable WHERE cfqueryParam value=#url.date#... DateField ) Don't forget to file a bug if this works ;-) Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
mm site, wheres the bugs?
where on the macromedia site is the cfmx bug list? i get a reply from tim buntel @ mm saying that my dateDiff bug isnt one, and that it was fixed in 6.1 well im the one that submitted that bug, this is cleary not that bug, and im just going to make sure that it is the one, and again try to prove that its not the same one. thanks. tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF PHP Same Server
Well there is that one thing the affected that thing with the other thing. But other than that I have had no trouble with CF5.0, Active PERL and PHP. Rick -Original Message- From: Jim Gurfein [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 4:18 PM To: CF-Talk Subject: CF PHP Same Server Does anyone have experience with CF PHP on the same server? Any notes on tricks and issues would be appreciated. Sincerely yours, Jim Gurfein President, CEO RestaurantRow.com, Inc. http://www.restaurantrow.com http://www.restaurantrow.com 914.921.3200 ext 101 914.921.9190 fax _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
IIS remove and reinstall
IIS crashed, or at least I think it did as neither CF or ASP work. (I'm running IIS 5) It was suggested that I try uninstalling JRun by using wsconfig.exe.I've read and reread files such as the FAQ for ColdFusion MX connector configuration at http://www.macromedia.com/support/coldfusion/ts/documents/connector_install_ faq.htm One of the FAQs are: How do I know what version of the wsconfig.jar I currently have? What about the connectors themselves? It says You can check to make sure that ColdFusion MX, including the web server connectors, was successfully updated as follows: Run the following command line: (Windows shown) c:\cfusionmx\runtime\jre\bin\java -jar c:\cfusionmx\runtime\lib\wsconfig.jar -info The result should be: Macromedia JRun 4 (Build 58498). The result is: 'cfusionmx\runtime\jre\bin\java-jar' is not recognized as an internal or external command, operable program or batch file. I'm getting lost working on this.I don't know what to do. I think the JRun connector might be the issue as I have jrun files going up to the day it crashed. I guess I'm looking for some hand-holding cause I don't want to mess things up and have no idea what I'm doing. thanks for any help, Gilbert Midonnet [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: mm site, wheres the bugs?
DONT EVERYONE ANSWER AT ONCE :) i found it...anyway, if you care to know what it is...at least for mx61 http://www.macromedia.com/support/coldfusion/releasenotes/mx/mx61_fixed_ bugs.html tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 6:18 PM To: CF-Talk Subject: mm site, wheres the bugs? where on the macromedia site is the cfmx bug list? i get a reply from tim buntel @ mm saying that my dateDiff bug isnt one, and that it was fixed in 6.1 well im the one that submitted that bug, this is cleary not that bug, and im just going to make sure that it is the one, and again try to prove that its not the same one. thanks. tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: mm site, wheres the bugs?
Weegs, we didn't answer cuz we don't like you.:-) Take a hint bro. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 8:34 PM To: CF-Talk Subject: RE: mm site, wheres the bugs? DONT EVERYONE ANSWER AT ONCE :) i found it...anyway, if you care to know what it is...at least for mx61 http://www.macromedia.com/support/coldfusion/releasenotes/mx/mx61_fixed_ bugs.html tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 6:18 PM To: CF-Talk Subject: mm site, wheres the bugs? where on the macromedia site is the cfmx bug list? i get a reply from tim buntel @ mm saying that my dateDiff bug isnt one, and that it was fixed in 6.1 well im the one that submitted that bug, this is cleary not that bug, and im just going to make sure that it is the one, and again try to prove that its not the same one. thanks. tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]