Re: CFMail Sanity Check - Where's the Macromedia rep
Well, that's good to hear. I hope spamcop is included in that. Yes, and downgraded accordingly. Spamcop was once golden, then based on some rather draconian behavior (like blacklisting a domain merely mentioned in an email's text... The U.S. D.O.T. got listed for awhile on spamcop, for example, as a GEICO spam listed auto recalls from DOT.gov in its spammage)a lot of admins went from trusting them implicity to not at all.Based on the list traffic I subscribe to they seem to have cleaned up to the point where they're back on the 'useful' list, but nothing like their original sainted-mother status. Since I have moved exclusively to Bayesian filtering during this period blacklists are something I only read about. -good to know, thanks. But you see then the characteristics of cfmail DO contribute to a spam score, as missing headers - I think - are noted on many spam tests. Yes indeed.I suppose you could argue that this is part of why there is a cfmailparam tag... so that coders can write a proper email message... and it should not be so that people think cfmail alone will do the whole job.Blame MM for not getting the word out on that score. This is exactly what I was getting at above. Why in the world does CFMX not include them then??? Cuz its the job of cfmailparam, and its up to you to figure this out :-(See above.Bad karma. How can it be detected if CF places the header properly, and its a valid value? I mean that things like a fake but correct Outlook mailer ID are detected because there can be several checks and if they all don't match perfectly it is noted as forged, which is a death sentence. Yup.Duplicate headers are bad.Pretending to be Outlook is muy mas bad. If on the other hand you had a sender of [EMAIL PROTECTED] and the reply-to was [EMAIL PROTECTED] then yes, that would be a giant red flag. -yes, I have been doing that out of necessity. Can't tell how bad the effect is, but a few bounces. Maybe others are tossed. Others go through fine. But I need to change that. Ouch.As I'm sure you know you get a spanking for doing that.You may have a good reason but the environment of today says you can't go there. thx for the css tips.Always looking for the grail there. -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [Reply To] RE: Homesite+ snippets question
What WOULD be coool though is Internet Shared Snippets wouldnt it? MD On Mon, 5 Jul 2004 15:47:51 +1000, Seamus Campbell [EMAIL PROTECTED] wrote: Yes - I know that - but there seems to be no way to add a new snippets folder at the top level ie NOT under an already existing snippet folder Seamus You wrote Right click in the window. :-) Also, if you have other CF developers, the shared snippets feature is cool _ From: Seamus Campbell [mailto:[EMAIL PROTECTED] Sent: Monday, 5 July 2004 2:05 p.m. To: CF-Talk Subject: Homesite+ snippets question Hi I've just got Homesite+. I cannot see a way to add a new folder in the top level in snippets. I can only add a new folder within another folder. Help please - this is really annoying me Seamus Seamus CampbellBoldacious WebDesign http://www.boldacious.com[EMAIL PROTECTED] ph 02 6297 4883mob 0410 609 267 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [Reply To] RE: Homesite+ snippets question
On Monday 05 Jul 2004 06:47 am, Seamus Campbell wrote: Yes - I know that - but there seems to be no way to add a new snippets folder at the top level ie NOT under an already existing Go into the snippits dir and make one by hand ? As to shareable snippits - knock yourself out with the usualy CVS/rsync/cron'ed ftp solutions :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: [Reply To] RE: Homesite+ snippets question
You create a top-level folder by right clicking in a blank space in the window. Do you mean once you've got a top-level snippet folder you want to alter the order the folders are listed? Don't know how to do that. _ From: Seamus Campbell [mailto:[EMAIL PROTECTED] Sent: Monday, 5 July 2004 5:48 p.m. To: CF-Talk Subject: [Reply To] RE: Homesite+ snippets question Yes - I know that - but there seems to be no way to add a new snippets folder at the top level ie NOT under an already existing snippet folder Seamus You wrote Right click in the window. :-) Also, if you have other CF developers, the shared snippets feature is cool _ From: Seamus Campbell [mailto:[EMAIL PROTECTED] Sent: Monday, 5 July 2004 2:05 p.m. To: CF-Talk Subject: Homesite+ snippets question Hi I've just got Homesite+. I cannot see a way to add a new folder in the top level in snippets. I can only add a new folder within another folder. Help please - this is really annoying me Seamus Seamus CampbellBoldacious WebDesign http://www.boldacious.com[EMAIL PROTECTED] ph 02 6297 4883mob 0410 609 267 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Obtaining Browser Size
On Friday 02 Jul 2004 20:41 pm, Jim Davis wrote: Of course the function below will only work in browsers where Java is installed. Though you could use a gifAsDataPipe/PengoWorks Gateway/Neuromancer webservice to achive the same goal, needing only _javascript_ on the client. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [Reply To] RE: Homesite+ snippets question
I was thinking more along the lines of a website publishing them e.g. house of fusion? and webdav into them.. they get added, I as the creator can see it... once someone (hof?) published them, everybody else can see them too! Neato? MD On Mon, 05 Jul 2004 21:48:24 +1200, Matthew Walker [EMAIL PROTECTED] wrote: You create a top-level folder by right clicking in a blank space in the window. Do you mean once you've got a top-level snippet folder you want to alter the order the folders are listed? Don't know how to do that. _ From: Seamus Campbell [mailto:[EMAIL PROTECTED] Sent: Monday, 5 July 2004 5:48 p.m. To: CF-Talk Subject: [Reply To] RE: Homesite+ snippets question Yes - I know that - but there seems to be no way to add a new snippets folder at the top level ie NOT under an already existing snippet folder Seamus You wrote Right click in the window. :-) Also, if you have other CF developers, the shared snippets feature is cool _ From: Seamus Campbell [mailto:[EMAIL PROTECTED] Sent: Monday, 5 July 2004 2:05 p.m. To: CF-Talk Subject: Homesite+ snippets question Hi I've just got Homesite+. I cannot see a way to add a new folder in the top level in snippets. I can only add a new folder within another folder. Help please - this is really annoying me Seamus Seamus CampbellBoldacious WebDesign http://www.boldacious.com[EMAIL PROTECTED] ph 02 6297 4883mob 0410 609 267 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Dumping a CFHTTP call?
I'm working on a generic internal screen-scraper to export reports to Excel.In the process of building my call I generate a structure that stores the parameters and such and then parse it all out in the CFHTTP call. Is there a way that I can see exactly what is being passed via the CFHTTP call (like in a debug results) without modifying the page that is called? Thanks! -- UntiL Later! C. Hatton Humphrey [EMAIL PROTECTED] ... evolution wise whenever you create something your brain give you a little endorphine buzz... why do you think Einstein looked that way? - Robin Williams [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dumping a CFHTTP call?
cfdump var=#CFHTTP# ? On Mon, 5 Jul 2004 06:46:45 -0400, C. Hatton Humphrey [EMAIL PROTECTED] wrote: I'm working on a generic internal screen-scraper to export reports to Excel.In the process of building my call I generate a structure that stores the parameters and such and then parse it all out in the CFHTTP call. Is there a way that I can see exactly what is being passed via the CFHTTP call (like in a debug results) without modifying the page that is called? Thanks! -- UntiL Later! C. Hatton Humphrey [EMAIL PROTECTED] ... evolution wise whenever you create something your brain give you a little endorphine buzz... why do you think Einstein looked that way? - Robin Williams [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cflogin and cached credentials
While testing my first application using cflogin, I was able to do this sort of thing. Sequence 1. Log in with correct username and password. Log out with cflogout. Change password in database (not using a CF Application) Log in with old password. Log out with cflogout. Delete user record in database Log in with old username password. I read the archives in HouseofFusion and learned that: a.cflogin info is cached. b.the cflogin tag uses the cached info if it finds any, uses it and bypasses the cfloginuser tag. Does anyone know where this information is cached?More importantly, does anyone know how to maintain this cache so that it only contains current information. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Build JAVA request and response scopes in CF
Hi all,I am building an application in CF that uses a Java API (I do not have the source for the API)The problem I am facing, is that I can't call some of the API functions which use the request and response scope as parameteres ( for example a function existing in a SERVLET which is declared as : protected void FunctionName(HttpServletRequest request, HttpServletResponse response) ).This is done cause there is not something (to my knowledge of course) in CF that can represent the request and response scope the way Java does and for that, the function is not recognized and called properly. I tried to use Javacast() but I didnt know how to build the CFRequest and CFResponse variablesIs there any solution to this problem? Maybe someone has faced the same problem in the past and built a wrapper function that takes the URL and SESSION scope of CF and form it the way JAVA builds its request scope.Any help will be significant to me as I seem to be running out of ideas SCARY!Cheers!Stavros ___ Join Excite! - http://www.excite.com The most personalized portal on the Web! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Homesite+ snippets question
That is interesting.Does it work go to the file structure and create a new folder manually? Probably something like: C:\Program Files\Macromedia\HomeSite+\UserData\Snippets At 05:01 AM 7/5/2004, you wrote: Subject: Homesite+ snippets question From: Seamus Campbell [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 12:04:50 +1000 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=33690forumid=4#169310 Hi I've just got Homesite+. I cannot see a way to add a new folder in the top level in snippets. I can only add a new folder within another folder. Help please - this is really annoying me Seamus -- Jeffry Houser, Web Developer, Writer, Songwriter, Recording Engineer mailto:[EMAIL PROTECTED] -- AIM: Reboog711| Phone: 1-203-379-0773 -- My Books: http://www.instantcoldfusion.com Recording Music: http://www.fcfstudios.com Original Energetic Acoustic Rock: http://www.farcryfly.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
[Reply To] Re: Homesite+ snippets question
Yes that works fine. Thanks to all seamus You wrote That is interesting.Does it work go to the file structure and create a new folder manually? Probably something like: C:\Program Files\Macromedia\HomeSite+\UserData\Snippets At 05:01 AM 7/5/2004, you wrote: Subject: Homesite+ snippets question From: Seamus Campbell [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 12:04:50 +1000 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages hreadid=33690forumid=4#169310 Hi I've just got Homesite+. I cannot see a way to add a new folder in the top level in snippets. I can only add a new folder within another folder. Help please - this is really annoying me Seamus -- Jeffry Houser, Web Developer, Writer, Songwriter, Recording Engineer mailto:[EMAIL PROTECTED] -- AIM: Reboog711| Phone: 1-203-379-0773 -- My Books: http://www.instantcoldfusion.com Recording Music: http://www.fcfstudios.com Original Energetic Acoustic Rock: http://www.farcryfly.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Havent seen this error before...
I am now getting an odd error: Error Executing Database Query. Unknown Types value The error occurred in /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 Called from /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 41 : 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Havent seen this error before...
Whats the other code around that, as I notice you end with a comma but no more code is shown. Might help to scope your vars, so add something like CFSET VAR Cat = after the CFFUNCTION or ommit the name of the CFQUERY if its not going to return anything. Potentially pass the datasource in as an argument rather than trying to access the Application scope HTH Mike - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Mon,5 Jul 2004 08:55:50 -0400 Subject: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] I am now getting an odd error: Error Executing Database Query. Unknown Types value 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Havent seen this error before...
Sorry, HOF cut off some of the message (formatting from CFs error stuff) I am now getting an odd error: Error Executing Database Query. Unknown Types value The error occurred in /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 Called from /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 41 : 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, -- SQL update tblboutcat2 set txtBoutCat = (param 1) , blActive = (param 2) where intBoutCatID = (param 3) DATASOURCE[omitted] SQLSTATES1000 Anybody ever seen this one before? This function is nearly identical to one in another CFC that I currently have running which works perfectly (different table and fields). I've double checked that there are values to my 'instance' vars, that I have the sqltypes set correctly, etc. And I still can't figure it out. Help Cutter Quoting JediHomer [EMAIL PROTECTED]: Whats the other code around that, as I notice you end with a comma but no more code is shown. Might help to scope your vars, so add something like CFSET VAR Cat = after the CFFUNCTION or ommit the name of the CFQUERY if its not going to return anything. Potentially pass the datasource in as an argument rather than trying to access the Application scope HTH Mike - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Mon,5 Jul 2004 08:55:50 -0400 Subject: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] I am now getting an odd error: Error Executing Database Query. Unknown Types value 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
variables with cfquery
hello all, I am sending a file from flash to CF.The variables are getting there...so that is no problem.However, once they get there, then I am not sure how to put them into action.For example, I am sending many x and y values, and some IDs.So a basic query for sending flash variables to CF looks like this: assume I am sending these values from Flash to CF - xValue; yValue; myID; CFpage - cfquery ... UPDATE tableName SETx = #form.xValue#, y =#form.yValue# WHERE ID = #form.myID# /cfquery The problem is that I am sending several values and I don't know how many until run-time.I also have to create the variables and there values at run-time...so this is what I have: assume I am sending these values from Flash to CF - x1 = 10; y1 = 50; myID1 = 1045; x2 = 10; y2 = 50; myID = 2; ... CFpage - cfloop from=1 to=#form.numberOfValues# index=i cfset thisX = form.x#i# cfset thisY = form.y#i# cfset thisID = form.myID#i# cfquery ... UPDATE tableName SETx = #thisX#, y =#thisY# WHERE ID = #thisID# /cfquery /cfloop So I am asking how to create a dynamic variable...involving concatenation?Any help with this problem is greatly appreciated - Frank --- The Preceeding Email Has Been Scanned and Verified By QBOS Security Systems --- QBOS, Inc. 14275 Midway Rd.Suite 220 Addison, TX 75001 972.233.5066 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Havent seen this error before...
Looks like you are missing a set of single quotes in your value attribute. Instead of this, 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, try this: 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value='#instance.category#' null=#yesnoformat(not len(trim (instance.category)))#, [EMAIL PROTECTED] ets.com To 2004-07-05 09:50 CF-Talk [EMAIL PROTECTED] cc Please respond to Subject [EMAIL PROTECTED]Re: Havent seen this error sion.combefore... Sorry, HOF cut off some of the message (formatting from CFs error stuff) I am now getting an odd error: Error Executing Database Query. Unknown Types value The error occurred in /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 Called from /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 41 : 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, -- SQL update tblboutcat2 set txtBoutCat = (param 1) , blActive = (param 2) where intBoutCatID = (param 3) DATASOURCE[omitted] SQLSTATES1000 Anybody ever seen this one before? This function is nearly identical to one in another CFC that I currently have running which works perfectly (different table and fields). I've double checked that there are values to my 'instance' vars, that I have the sqltypes set correctly, etc. And I still can't figure it out. Help Cutter Quoting JediHomer [EMAIL PROTECTED]: Whats the other code around that, as I notice you end with a comma but no more code is shown. Might help to scope your vars, so add something like CFSET VAR Cat = after the CFFUNCTION or ommit the name of the CFQUERY if its not going to return anything. Potentially pass the datasource in as an argument rather than trying to access the Application scope HTH Mike - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Mon,5 Jul 2004 08:55:50 -0400 Subject: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] I am now getting an odd error: Error Executing Database Query. Unknown Types value 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype =cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Havent seen this error before...
Still some of the code missing... Is param1 a string with the type set to something like CF_SQL_VARCHAR or CF_SQL_LONGVARCHAR, then I assum param2 to be a 1 or a 0 with the type set to CF_SQL_BIT and finaly a numeric passed to param 3 with a type of CF_SQL_INTEGER ? You also seem to have a YesNoFormat() in the Null section of the CFQUERYPARAM, are the fields setup to allow for Null values? HTH Mike - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Mon,5 Jul 2004 09:50:09 -0400 Subject: Re: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] Sorry, HOF cut off some of the message (formatting from CFs error stuff) I am now getting an odd error: Error Executing Database Query. Unknown Types value The error occurred in /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 Called from /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 41 : 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, -- SQL update tblboutcat2 set txtBoutCat = (param 1) , blActive = (param 2) where intBoutCatID = (param 3) DATASOURCE[omitted] SQLSTATES1000 Anybody ever seen this one before? This function is nearly identical to one in another CFC that I currently have running which works perfectly (different table and fields). I've double checked that there are values to my 'instance' vars, that I have the sqltypes set correctly, etc. And I still can't figure it out. Help Cutter Quoting JediHomer [EMAIL PROTECTED]: Whats the other code around that, as I notice you end with a comma but no more code is shown. Might help to scope your vars, so add something like CFSET VAR Cat = after the CFFUNCTION or ommit the name of the CFQUERY if its not going to return anything. Potentially pass the datasource in as an argument rather than trying to access the Application scope HTH Mike - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Mon,5 Jul 2004 08:55:50 -0400 Subject: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] I am now getting an odd error: Error Executing Database Query. Unknown Types value 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: variables with cfquery
How are you sending the variables to CF? via LoadVariables() if so you could pass in an extra field that states how many fields you have created and then use that as the number of loops for CF to perform. You could also potentially use Flash Remoting (if flash version is not an issue and you are you MX+) and build up and object to pass to CF which then treats it as a structure HTH Mike - Original Message - From: Frank Dewey [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 09:03:07 -0500 Subject: variables with cfquery To: CF-Talk [EMAIL PROTECTED] hello all, I am sending a file from flash to CF.The variables are getting there...so that is no problem.However, once they get there, then I am not sure how to put them into action.For example, I am sending many x and y values, and some IDs.So a basic query for sending flash variables to CF looks like this: assume I am sending these values from Flash to CF - xValue; yValue; myID; CFpage - cfquery ... UPDATE tableName SETx = #form.xValue#, y =#form.yValue# WHERE ID = #form.myID# /cfquery The problem is that I am sending several values and I don't know how many until run-time.I also have to create the variables and there values at run-time...so this is what I have: assume I am sending these values from Flash to CF - x1 = 10; y1 = 50; myID1 = 1045; x2 = 10; y2 = 50; myID = 2; ... CFpage - cfloop from=1 to=#form.numberOfValues# index=i cfset thisX = form.x#i# cfset thisY = form.y#i# cfset thisID = form.myID#i# cfquery ... UPDATE tableName SETx = #thisX#, y =#thisY# WHERE ID = #thisID# /cfquery /cfloop So I am asking how to create a dynamic variable...involving concatenation?Any help with this problem is greatly appreciated - Frank --- The Preceeding Email Has Been Scanned and Verified By QBOS Security Systems --- QBOS, Inc. 14275 Midway Rd.Suite 220 Addison, TX 75001 972.233.5066 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Havent seen this error before...
I don't believe you need those single-quotes inside cfqueryparam. But show more code and I'm sure we'll be able to tell you what's wrong. Show us the whole query at least. Greg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:09 AM To: CF-Talk Subject: Re: Havent seen this error before... Looks like you are missing a set of single quotes in your value attribute. Instead of this, 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, try this: 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value='#instance.category#' null=#yesnoformat(not len(trim (instance.category)))#, [EMAIL PROTECTED] ets.com To 2004-07-05 09:50 CF-Talk [EMAIL PROTECTED] cc Please respond to Subject [EMAIL PROTECTED]Re: Havent seen this error sion.combefore... Sorry, HOF cut off some of the message (formatting from CFs error stuff) I am now getting an odd error: Error Executing Database Query. Unknown Types value The error occurred in /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 Called from /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 41 : 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, -- SQL update tblboutcat2 set txtBoutCat = (param 1) , blActive = (param 2) where intBoutCatID = (param 3) DATASOURCE[omitted] SQLSTATES1000 Anybody ever seen this one before? This function is nearly identical to one in another CFC that I currently have running which works perfectly (different table and fields). I've double checked that there are values to my 'instance' vars, that I have the sqltypes set correctly, etc. And I still can't figure it out. Help Cutter Quoting JediHomer [EMAIL PROTECTED]: Whats the other code around that, as I notice you end with a comma but no more code is shown. Might help to scope your vars, so add something like CFSET VAR Cat = after the CFFUNCTION or ommit the name of the CFQUERY if its not going to return anything. Potentially pass the datasource in as an argument rather than trying to access the Application scope HTH Mike - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Mon,5 Jul 2004 08:55:50 -0400 Subject: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] I am now getting an odd error: Error Executing Database Query. Unknown Types value 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype =cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Havent seen this error before...
Greg, I don't believe that is correct. The purpose of the single quotes is to identify character data. cfqueryparam makes them unnecessary by specifying the data type in advance.In this case using a datatype binding (cfqueryparam) means the single quotes would be superflous.the driver creates a query with a placeholder that says character data here - then whatever you pass in as the variable is bound to that type.Adding single quotes would only result having them suddenly appear in the database as a part of the string. There is a bug with a hot fix (fixed permanently in cfmx 6.1 I believe) that causes single quotes that included as a part of the param to be doubled up - but that's not the issue here either. -Mark -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 9:28 AM To: CF-Talk Subject: RE: Havent seen this error before... I don't believe you need those single-quotes inside cfqueryparam. But show more code and I'm sure we'll be able to tell you what's wrong. Show us the whole query at least. Greg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:09 AM To: CF-Talk Subject: Re: Havent seen this error before... Looks like you are missing a set of single quotes in your value attribute. Instead of this, 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, try this: 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value='#instance.category#' null=#yesnoformat(not len(trim (instance.category)))#, [EMAIL PROTECTED] ets.com To 2004-07-05 09:50 CF-Talk [EMAIL PROTECTED] cc Please respond to Subject [EMAIL PROTECTED]Re: Havent seen this error sion.combefore... Sorry, HOF cut off some of the message (formatting from CFs error stuff) I am now getting an odd error: Error Executing Database Query. Unknown Types value The error occurred in /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 Called from /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 41 : 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, -- SQL update tblboutcat2 set txtBoutCat = (param 1) , blActive = (param 2) where intBoutCatID = (param 3) DATASOURCE[omitted] SQLSTATES1000 Anybody ever seen this one before? This function is nearly identical to one in another CFC that I currently have running which works perfectly (different table and fields). I've double checked that there are values to my 'instance' vars, that I have the sqltypes set correctly, etc. And I still can't figure it out. Help Cutter Quoting JediHomer [EMAIL PROTECTED]: Whats the other code around that, as I notice you end with a comma but no more code is shown. Might help to scope your vars, so add something like CFSET VAR Cat = after the CFFUNCTION or ommit the name of the CFQUERY if its not going to return anything. Potentially pass the datasource in as an argument rather than trying to access the Application scope HTH Mike - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Mon,5 Jul 2004 08:55:50 -0400 Subject: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] I am now getting an odd error: Error Executing Database Query. Unknown Types value 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype =cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Havent seen this error before...
Dan, I would check the following. Is it an exact type match? For example, is the field a text field and you are using varchar?I would check to make sure that the field is nullable - since you are using the null attribute.And I would try other types if you can. -Mark -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 9:28 AM To: CF-Talk Subject: RE: Havent seen this error before... I don't believe you need those single-quotes inside cfqueryparam. But show more code and I'm sure we'll be able to tell you what's wrong. Show us the whole query at least. Greg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:09 AM To: CF-Talk Subject: Re: Havent seen this error before... Looks like you are missing a set of single quotes in your value attribute. Instead of this, 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, try this: 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value='#instance.category#' null=#yesnoformat(not len(trim (instance.category)))#, [EMAIL PROTECTED] ets.com To 2004-07-05 09:50 CF-Talk [EMAIL PROTECTED] cc Please respond to Subject [EMAIL PROTECTED]Re: Havent seen this error sion.combefore... Sorry, HOF cut off some of the message (formatting from CFs error stuff) I am now getting an odd error: Error Executing Database Query. Unknown Types value The error occurred in /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 Called from /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 41 : 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, -- SQL update tblboutcat2 set txtBoutCat = (param 1) , blActive = (param 2) where intBoutCatID = (param 3) DATASOURCE[omitted] SQLSTATES1000 Anybody ever seen this one before? This function is nearly identical to one in another CFC that I currently have running which works perfectly (different table and fields). I've double checked that there are values to my 'instance' vars, that I have the sqltypes set correctly, etc. And I still can't figure it out. Help Cutter Quoting JediHomer [EMAIL PROTECTED]: Whats the other code around that, as I notice you end with a comma but no more code is shown. Might help to scope your vars, so add something like CFSET VAR Cat = after the CFFUNCTION or ommit the name of the CFQUERY if its not going to return anything. Potentially pass the datasource in as an argument rather than trying to access the Application scope HTH Mike - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Mon,5 Jul 2004 08:55:50 -0400 Subject: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] I am now getting an odd error: Error Executing Database Query. Unknown Types value 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype =cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Manipulation Excel files
Hello All, I was wondering if someone could point me in the right direction.I need to be able to extract certain information from cells an excel file, update some cell, delete some rows in the file then import the file to my database.Can anybody point me to a resource that explains how to do this or if someone has some experience with this it would be greatly appreciated. Thank you, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Havent seen this error before...(Resolved)
Too early the morning after with not enough coffee:) Turns out that I was not using cf_sql_bit (which would have been the next line of the query) in my db, but instead the cf_sql_tinyint type (one area of MySQL I wish they would get with everybody else...) It's always the little things. Thanks for everyone's input. Cutter Quoting Mark A. Kruger - CFG [EMAIL PROTECTED]: Dan, I would check the following. Is it an exact type match? For example, is the field a text field and you are using varchar?I would check to make sure that the field is nullable - since you are using the null attribute.And I would try other types if you can. -Mark -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 9:28 AM To: CF-Talk Subject: RE: Havent seen this error before... I don't believe you need those single-quotes inside cfqueryparam. But show more code and I'm sure we'll be able to tell you what's wrong. Show us the whole query at least. Greg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:09 AM To: CF-Talk Subject: Re: Havent seen this error before... Looks like you are missing a set of single quotes in your value attribute. Instead of this, 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, try this: 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value='#instance.category#' null=#yesnoformat(not len(trim (instance.category)))#, [EMAIL PROTECTED] ets.com To 2004-07-05 09:50 CF-Talk [EMAIL PROTECTED] cc Please respond to Subject [EMAIL PROTECTED]Re: Havent seen this error sion.combefore... Sorry, HOF cut off some of the message (formatting from CFs error stuff) I am now getting an odd error: Error Executing Database Query. Unknown Types value The error occurred in /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 Called from /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 41 : 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, -- SQL update tblboutcat2 set txtBoutCat = (param 1) , blActive = (param 2) where intBoutCatID = (param 3) DATASOURCE[omitted] SQLSTATES1000 Anybody ever seen this one before? This function is nearly identical to one in another CFC that I currently have running which works perfectly (different table and fields). I've double checked that there are values to my 'instance' vars, that I have the sqltypes set correctly, etc. And I still can't figure it out. Help Cutter Quoting JediHomer [EMAIL PROTECTED]: Whats the other code around that, as I notice you end with a comma but no more code is shown. Might help to scope your vars, so add something like CFSET VAR Cat = after the CFFUNCTION or ommit the name of the CFQUERY if its not going to return anything. Potentially pass the datasource in as an argument rather than trying to access the Application scope HTH Mike - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Mon,5 Jul 2004 08:55:50 -0400 Subject: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] I am now getting an odd error: Error Executing Database Query. Unknown Types value 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype =cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Dumping a CFHTTP call?
Also there is a built in utility which will help you view the http response and request, See http://www.macromedia.com/support/coldfusion/ts/documents/tcpmonitor.htm For more details KOla -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 05 July 2004 12:05 To: CF-Talk Subject: Re: Dumping a CFHTTP call? cfdump var=#CFHTTP# ? On Mon, 5 Jul 2004 06:46:45 -0400, C. Hatton Humphrey [EMAIL PROTECTED] wrote: I'm working on a generic internal screen-scraper to export reports to Excel.In the process of building my call I generate a structure that stores the parameters and such and then parse it all out in the CFHTTP call. Is there a way that I can see exactly what is being passed via the CFHTTP call (like in a debug results) without modifying the page that is called? Thanks! -- UntiL Later! C. Hatton Humphrey [EMAIL PROTECTED] ... evolution wise whenever you create something your brain give you a little endorphine buzz... why do you think Einstein looked that way? - Robin Williams _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Build JAVA request and response scopes in CF
Stavros Coldfusion pages are JSP servlets so you can access the request and response objects using the pageContext which every coldfusion page has: tst = GetPageContext().getRequest(); See http://livedocs.macromedia.com/coldfusion/6/Developing_ColdFusion_MX_App lications_with_CFML/Java2.htm For more info. HTH Kola -Original Message- From: Stavros Tekes [mailto:[EMAIL PROTECTED] Sent: 05 July 2004 13:16 To: CF-Talk Subject: Build JAVA request and response scopes in CF Hi all,I am building an application in CF that uses a Java API (I do not have the source for the API)The problem I am facing, is that I can't call some of the API functions which use the request and response scope as parameteres ( for example a function existing in a SERVLET which is declared as : protected void FunctionName(HttpServletRequest request, HttpServletResponse response) ).This is done cause there is not something (to my knowledge of course) in CF that can represent the request and response scope the way Java does and for that, the function is not recognized and called properly. I tried to use Javacast() but I didnt know how to build the CFRequest and CFResponse variablesIs there any solution to this problem? Maybe someone has faced the same problem in the past and built a wrapper function that takes the URL and SESSION scope of CF and form it the way JAVA builds its request scope. Any help will be significant to me as I seem to be running out of ideas SCARY!Cheers!Stavros ___ Join Excite! - http://www.excite.com The most personalized portal on the Web! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Havent seen this error before...
Wow, I didn't understand what you just said Mark. But my understanding is that you don't need single quotes inside the cfqueryparam. Specifying the cfsqltype should take care of that for you right? Greg -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:44 AM To: CF-Talk Subject: RE: Havent seen this error before... Greg, I don't believe that is correct. The purpose of the single quotes is to identify character data. cfqueryparam makes them unnecessary by specifying the data type in advance.In this case using a datatype binding (cfqueryparam) means the single quotes would be superflous.the driver creates a query with a placeholder that says character data here - then whatever you pass in as the variable is bound to that type.Adding single quotes would only result having them suddenly appear in the database as a part of the string. There is a bug with a hot fix (fixed permanently in cfmx 6.1 I believe) that causes single quotes that included as a part of the param to be doubled up - but that's not the issue here either. -Mark -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 9:28 AM To: CF-Talk Subject: RE: Havent seen this error before... I don't believe you need those single-quotes inside cfqueryparam. But show more code and I'm sure we'll be able to tell you what's wrong. Show us the whole query at least. Greg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:09 AM To: CF-Talk Subject: Re: Havent seen this error before... Looks like you are missing a set of single quotes in your value attribute. Instead of this, 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, try this: 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value='#instance.category#' null=#yesnoformat(not len(trim (instance.category)))#, [EMAIL PROTECTED] ets.com To 2004-07-05 09:50 CF-Talk [EMAIL PROTECTED] cc Please respond to Subject [EMAIL PROTECTED]Re: Havent seen this error sion.combefore... Sorry, HOF cut off some of the message (formatting from CFs error stuff) I am now getting an odd error: Error Executing Database Query. Unknown Types value The error occurred in /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 Called from /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 41 : 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, -- SQL update tblboutcat2 set txtBoutCat = (param 1) , blActive = (param 2) where intBoutCatID = (param 3) DATASOURCE[omitted] SQLSTATES1000 Anybody ever seen this one before? This function is nearly identical to one in another CFC that I currently have running which works perfectly (different table and fields). I've double checked that there are values to my 'instance' vars, that I have the sqltypes set correctly, etc. And I still can't figure it out. Help Cutter Quoting JediHomer [EMAIL PROTECTED]: Whats the other code around that, as I notice you end with a comma but no more code is shown. Might help to scope your vars, so add something like CFSET VAR Cat = after the CFFUNCTION or ommit the name of the CFQUERY if its not going to return anything. Potentially pass the datasource in as an argument rather than trying to access the Application scope HTH Mike - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Mon,5 Jul 2004 08:55:50 -0400 Subject: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] I am now getting an odd error: Error Executing Database Query. Unknown Types value 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype =cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dumping a CFHTTP call?
Also there is a built in utility which will help you view the http response and request, See http://www.macromedia.com/support/coldfusion/ts/documents/tcpmonitor.htm Coool tool!Thanks for the link.I found the source of my problem and it ended up not being related to the actual HTTP call. Hatton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Alagad Image.cfc not working on MX6.1
On Sunday 04 Jul 2004 03:05 am, Ubqtous wrote: Back to square one. You could just install the relevant package... [EMAIL PROTECTED] ceo_platform]# locate libXp.so.6 /usr/X11R6/lib/libXp.so.6 /usr/X11R6/lib/libXp.so.6.2 [EMAIL PROTECTED] ceo_platform]# rpm -q --whatprovides /usr/X11R6/lib/libXp.so.6 XFree86-libs-4.1.0-29 -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Havent seen this error before...
You dont need it to specify that its a string i.e. set sfoo = 'im a sring' It should also escape single quotes embeded into the string, but there is a bug with a hotfix (which is what Mark was refering to I beleive) where if you use a string function within the CFQueryParam which contained a Single quote then it would be doubled up. I.e. CFSET sString = Homer's life is normal in comparison to mine CFQUERY ... UPDATE myTable SET TheTitle = CFQUERYPARAM VALUE=#sString# /CFQUERY Will update the value to be Homer's life is normal in comparison to mine whereas CFQUERY ... UPDATE myTable SET TheTitle = CFQUERYPARAM VALUE=#Left(Trim(sString), 100)# /CFQUERY Would actually enter Homer''s life is normal in comparison to mine into the database HTH Mike - Original Message - From: Greg Luce [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 11:24:48 -0400 Subject: RE: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] Wow, I didn't understand what you just said Mark. But my understanding is that you don't need single quotes inside the cfqueryparam. Specifying the cfsqltype should take care of that for you right? Greg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Havent seen this error before...
Your second example is just trimming the left 100 chars, that won't affect the single-quotes will it? -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 11:57 AM To: CF-Talk Subject: Re: Havent seen this error before... You dont need it to specify that its a string i.e. set sfoo = 'im a sring' It should also escape single quotes embeded into the string, but there is a bug with a hotfix (which is what Mark was refering to I beleive) where if you use a string function within the CFQueryParam which contained a Single quote then it would be doubled up. I.e. CFSET sString = Homer's life is normal in comparison to mine CFQUERY ... UPDATE myTable SET TheTitle = CFQUERYPARAM VALUE=#sString# /CFQUERY Will update the value to be Homer's life is normal in comparison to mine whereas CFQUERY ... UPDATE myTable SET TheTitle = CFQUERYPARAM VALUE=#Left(Trim(sString), 100)# /CFQUERY Would actually enter Homer''s life is normal in comparison to mine into the database HTH Mike - Original Message - From: Greg Luce [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 11:24:48 -0400 Subject: RE: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] Wow, I didn't understand what you just said Mark. But my understanding is that you don't need single quotes inside the cfqueryparam. Specifying the cfsqltype should take care of that for you right? Greg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
DateFormat
#DateFormat(NOW(),, d, )# the above format display the date Monday, July 5, 2004 I want to display like Monday, July 5th, 2004 thanks Asim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Havent seen this error before...(Resolved)
hehe... happens to me all the time. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:06 AM To: CF-Talk Subject: RE: Havent seen this error before...(Resolved) Too early the morning after with not enough coffee:) Turns out that I was not using cf_sql_bit (which would have been the next line of the query) in my db, but instead the cf_sql_tinyint type (one area of MySQL I wish they would get with everybody else...) It's always the little things. Thanks for everyone's input. Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Havent seen this error before...
Yep - right on! -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:25 AM To: CF-Talk Subject: RE: Havent seen this error before... Wow, I didn't understand what you just said Mark. But my understanding is that you don't need single quotes inside the cfqueryparam. Specifying the cfsqltype should take care of that for you right? Greg -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:44 AM To: CF-Talk Subject: RE: Havent seen this error before... Greg, I don't believe that is correct. The purpose of the single quotes is to identify character data. cfqueryparam makes them unnecessary by specifying the data type in advance.In this case using a datatype binding (cfqueryparam) means the single quotes would be superflous.the driver creates a query with a placeholder that says character data here - then whatever you pass in as the variable is bound to that type.Adding single quotes would only result having them suddenly appear in the database as a part of the string. There is a bug with a hot fix (fixed permanently in cfmx 6.1 I believe) that causes single quotes that included as a part of the param to be doubled up - but that's not the issue here either. -Mark -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 9:28 AM To: CF-Talk Subject: RE: Havent seen this error before... I don't believe you need those single-quotes inside cfqueryparam. But show more code and I'm sure we'll be able to tell you what's wrong. Show us the whole query at least. Greg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:09 AM To: CF-Talk Subject: Re: Havent seen this error before... Looks like you are missing a set of single quotes in your value attribute. Instead of this, 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, try this: 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value='#instance.category#' null=#yesnoformat(not len(trim (instance.category)))#, [EMAIL PROTECTED] ets.com To 2004-07-05 09:50 CF-Talk [EMAIL PROTECTED] cc Please respond to Subject [EMAIL PROTECTED]Re: Havent seen this error sion.combefore... Sorry, HOF cut off some of the message (formatting from CFs error stuff) I am now getting an odd error: Error Executing Database Query. Unknown Types value The error occurred in /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 Called from /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 41 : 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, -- SQL update tblboutcat2 set txtBoutCat = (param 1) , blActive = (param 2) where intBoutCatID = (param 3) DATASOURCE[omitted] SQLSTATES1000 Anybody ever seen this one before? This function is nearly identical to one in another CFC that I currently have running which works perfectly (different table and fields). I've double checked that there are values to my 'instance' vars, that I have the sqltypes set correctly, etc. And I still can't figure it out. Help Cutter Quoting JediHomer [EMAIL PROTECTED]: Whats the other code around that, as I notice you end with a comma but no more code is shown. Might help to scope your vars, so add something like CFSET VAR Cat = after the CFFUNCTION or ommit the name of the CFQUERY if its not going to return anything. Potentially pass the datasource in as an argument rather than trying to access the Application scope HTH Mike - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Mon,5 Jul 2004 08:55:50 -0400 Subject: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] I am now getting an odd error: Error Executing Database Query. Unknown Types value 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype =cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and
Re: DateFormat
I don't think there's a way to do that normally using the DateFormat() function, but this will work: CFSET variables.i = DateFormat(Now(), d) CFIF variables.i IS 1 CFOUTPUT#DateFormat(Now(), , d)#st,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF variables.i IS 2 CFOUTPUT#DateFormat(Now(), , d)#nd,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF variables.i IS 3 CFOUTPUT#DateFormat(Now(), , d)#rd,#DateFormat(Now(), )#/CFOUTPUT CFELSE CFOUTPUT#DateFormat(Now(), , d)#th,#DateFormat(Now(), )#/CFOUTPUT /CFIF -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] Asim Manzur wrote: #DateFormat(NOW(),, d, )# the above format display the date Monday, July 5, 2004 I want to display like Monday, July 5th, 2004 thanks Asim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Havent seen this error before...
It shouldnt but thats the bug, as its not just a variable but a string function being passed into the tag the single quote doesnt go into the database as a single quote but as 2 single quotes. So basically if you wanted to trim and make sure whats going into the DB is less than 100 chars you have to do this outside of the tag for it to behave as expected. HTH Mike - Original Message - From: Greg Luce [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 12:03:27 -0400 Subject: RE: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] Your second example is just trimming the left 100 chars, that won't affect the single-quotes will it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: DateFormat
works exactly what I want. Thanks alot. Asim I don't think there's a way to do that normally using the DateFormat() function, but this will work: CFSET variables.i = DateFormat(Now(), d) CFIF variables.i IS 1 CFOUTPUT#DateFormat(Now(), , d)#st,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF variables.i IS 2 CFOUTPUT#DateFormat(Now(), , d)#nd,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF variables.i IS 3 CFOUTPUT#DateFormat(Now(), , d)#rd,#DateFormat(Now(), )#/CFOUTPUT CFELSE CFOUTPUT#DateFormat(Now(), , d)#th,#DateFormat(Now(), )#/CFOUTPUT /CFIF -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] Asim Manzur wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: DateFormat
this gives 21th!. Might be better to set up struct or array. -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 12:23 To: CF-Talk Subject: Re: DateFormat I don't think there's a way to do that normally using the DateFormat() function, but this will work: CFSET variables.i = DateFormat(Now(), d) CFIF variables.i IS 1 CFOUTPUT#DateFormat(Now(), , d)#st,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF variables.i IS 2 CFOUTPUT#DateFormat(Now(), , d)#nd,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF variables.i IS 3 CFOUTPUT#DateFormat(Now(), , d)#rd,#DateFormat(Now(), )#/CFOUTPUT CFELSE CFOUTPUT#DateFormat(Now(), , d)#th,#DateFormat(Now(), )#/CFOUTPUT /CFIF -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] Asim Manzur wrote: #DateFormat(NOW(),, d, )# the above format display the date Monday, July 5, 2004 I want to display like Monday, July 5th, 2004 thanks Asim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: DateFormat
Asim don't forget 21, 22, 23 and 31 alsohave different suffixes too.Just add a few more CFELSE's or perhaps use a CFSWITCH and CFCASE for each of the possibilities. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Tuesday, 6 July 2004 2:31 AM To: CF-Talk Subject: Re: DateFormat works exactly what I want. Thanks alot. Asim I don't think there's a way to do that normally using the DateFormat() function, but this will work: CFSET variables.i = DateFormat(Now(), d) CFIF variables.i IS 1 CFOUTPUT#DateFormat(Now(), , d)#st,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF variables.i IS 2 CFOUTPUT#DateFormat(Now(), , d)#nd,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF variables.i IS 3 CFOUTPUT#DateFormat(Now(), , d)#rd,#DateFormat(Now(), )#/CFOUTPUT CFELSE CFOUTPUT#DateFormat(Now(), , d)#th,#DateFormat(Now(), )#/CFOUTPUT /CFIF -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Havent seen this error before...
Greg, no - it would not.What he's (probably) doing is staying away from a data truncation error - where the database chockes on a string that is too long for the field size definition.In this case perhaps his field definition has a size of 100 - doing a left(string,100) makes sure that the string is never too long. -Mark -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 11:03 AM To: CF-Talk Subject: RE: Havent seen this error before... Your second example is just trimming the left 100 chars, that won't affect the single-quotes will it? -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 11:57 AM To: CF-Talk Subject: Re: Havent seen this error before... You dont need it to specify that its a string i.e. set sfoo = 'im a sring' It should also escape single quotes embeded into the string, but there is a bug with a hotfix (which is what Mark was refering to I beleive) where if you use a string function within the CFQueryParam which contained a Single quote then it would be doubled up. I.e. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: DateFormat
Original Message: From: Jordan Michaels I don't think there's a way to do that normally using the DateFormat() function, but this will work: CFSET variables.i = DateFormat(Now(), d) CFIF variables.i IS 1 CFOUTPUT#DateFormat(Now(), , d)#st,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF variables.i IS 2 CFOUTPUT#DateFormat(Now(), , d)#nd,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF variables.i IS 3 CFOUTPUT#DateFormat(Now(), , d)#rd,#DateFormat(Now(), )#/CFOUTPUT CFELSE CFOUTPUT#DateFormat(Now(), , d)#th,#DateFormat(Now(), )#/CFOUTPUT /CFIF Actually, that won't quite do it. If I'm reading the code correctly, that will also generate July 21th, July 22th, July 23th, and July 31th. So, you'll need conditional code to also take those numbers into account. (Unfortunately, you can't just look at the last character in the numeric date, because 11, 12, and 13 work differently from 1, 2, and 3.) Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: DateFormat
lol. Yes it does. Okay, updated code: CFSET variables.i = DateFormat(Now(), d) CFIF Right(variables.i, 1) IS 1 CFOUTPUT#DateFormat(Now(), , d)#st,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF Right(variables.i, 1) IS 2 CFOUTPUT#DateFormat(Now(), , d)#nd,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF Right(variables.i, 1) IS 3 CFOUTPUT#DateFormat(Now(), , d)#rd,#DateFormat(Now(), )#/CFOUTPUT CFELSE CFOUTPUT#DateFormat(Now(), , d)#th,#DateFormat(Now(), )#/CFOUTPUT /CFIF Debugging is a good thing. ;) Warm regards, Jordan -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] Dave F wrote: this gives 21th!. Might be better to set up struct or array. -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 12:23 To: CF-Talk Subject: Re: DateFormat I don't think there's a way to do that normally using the DateFormat() function, but this will work: CFSET variables.i = DateFormat(Now(), d) CFIF variables.i IS 1 CFOUTPUT#DateFormat(Now(), , d)#st,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF variables.i IS 2 CFOUTPUT#DateFormat(Now(), , d)#nd,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF variables.i IS 3 CFOUTPUT#DateFormat(Now(), , d)#rd,#DateFormat(Now(), )#/CFOUTPUT CFELSE CFOUTPUT#DateFormat(Now(), , d)#th,#DateFormat(Now(), )#/CFOUTPUT /CFIF -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] Asim Manzur wrote: #DateFormat(NOW(),, d, )# the above format display the date Monday, July 5, 2004 I want to display like Monday, July 5th, 2004 thanks Asim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: DateFormat
Grr. Right again. Well... the idea is the same for all of them. I'll let Asim figure out the details. =) -Jordan Scott Brady wrote: Original Message: From: Jordan Michaels I don't think there's a way to do that normally using the DateFormat() function, but this will work: CFSET variables.i = DateFormat(Now(), d) CFIF variables.i IS 1 CFOUTPUT#DateFormat(Now(), , d)#st,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF variables.i IS 2 CFOUTPUT#DateFormat(Now(), , d)#nd,#DateFormat(Now(), )#/CFOUTPUT CFELSEIF variables.i IS 3 CFOUTPUT#DateFormat(Now(), , d)#rd,#DateFormat(Now(), )#/CFOUTPUT CFELSE CFOUTPUT#DateFormat(Now(), , d)#th,#DateFormat(Now(), )#/CFOUTPUT /CFIF Actually, that won't quite do it. If I'm reading the code correctly, that will also generate July 21th, July 22th, July 23th, and July 31th. So, you'll need conditional code to also take those numbers into account. (Unfortunately, you can't just look at the last character in the numeric date, because 11, 12, and 13 work differently from 1, 2, and 3.) Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Havent seen this error before...
Mike, Hey ... if your right that has to be a bug right? It must be because of the nested function.I use trim( ) all the time without issues.Your saying that trim( ) combined with Len( ) causes the inner function ref to be passed instead of the return value from both calls? -Mark -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 11:27 AM To: CF-Talk Subject: Re: Havent seen this error before... It shouldnt but thats the bug, as its not just a variable but a string function being passed into the tag the single quote doesnt go into the database as a single quote but as 2 single quotes. So basically if you wanted to trim and make sure whats going into the DB is less than 100 chars you have to do this outside of the tag for it to behave as expected. HTH Mike - Original Message - From: Greg Luce [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 12:03:27 -0400 Subject: RE: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] Your second example is just trimming the left 100 chars, that won't affect the single-quotes will it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: DateFormat
Asim Manzur wrote: #DateFormat(NOW(),, d, )# the above format display the date Monday, July 5, 2004 I want to display like Monday, July 5th, 2004 function NumSuffixFormat(n) { // format numbers with suffix: -st, -nd, -rd, -th // Written by Chris Tazewell [EMAIL PROTECTED] if (n EQ 1 OR (Len(n) GTE 2 AND Right(n, 1) EQ 1 AND Right(n, 2) NEQ 11)) { n = nst; } else if (n EQ 2 OR (Len(n) GTE 2 AND Right(n, 1) EQ 2 AND Right(n, 2) NEQ 12)) { n = nnd; } else if (n EQ 3 OR (Len(n) GTE 2 AND Right(n, 1) EQ 3 AND Right(n, 2) NEQ 13)) { n = nrd; } else { n = nth; } return n; } That should do the trick. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Day of Week in Access
I'm trying to extract rows from an Access database where the row's date_transaction field is a specific numeric day of the week (1-7). Here's my query: SELECT COUNT(t.transaction_id) AS numAttendees, t.date_transaction FROM practice_transactionTbl t, transaction_typeTbl tt WHERE t.transaction_type_id = tt.transaction_type_id AND DatePart(w,t.date_transaction) IN ( 3,5,7 ) GROUP BY t.date_transaction ORDER BY t.date_transaction ASC Within Access, that query runs fine.In ColdFusion MX (6.1), however, I get a DB error (Too few parameters). Does the JDBC driver not recognize the DatePart function for Access?If not, any ideas on how to get around it? Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Havent seen this error before...
I beleive it depends on the version of CF you are using, I know its definately in MX but there is a hotfix available and it may have been permanentaly fixed in 6.1, im not sure as I dont code that way any more due to that bug Info is here http://www.macromedia.com/support/coldfusion/ts/documents/quotes_hotfix.htm HTH Mike - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 11:50:23 -0500 Subject: RE: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] Mike, Hey ... if your right that has to be a bug right? It must be because of the nested function.I use trim( ) all the time without issues.Your saying that trim( ) combined with Len( ) causes the inner function ref to be passed instead of the return value from both calls? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Alagad Image.cfc not working on MX6.1
Thanks! I don't have any desktop GUI stuff installed on this MX server, which probably explains why I get the error. Here's hoping I can just install that one package, and not need the whole ball of XFree86/X11 wax. On Mon, 5 Jul 2004 16:50:20 +0100, Thomas Chiverton [EMAIL PROTECTED] wrote: You could just install the relevant package... [EMAIL PROTECTED] ceo_platform]# locate libXp.so.6 /usr/X11R6/lib/libXp.so.6 /usr/X11R6/lib/libXp.so.6.2 [EMAIL PROTECTED] ceo_platform]# rpm -q --whatprovides /usr/X11R6/lib/libXp.so.6 XFree86-libs-4.1.0-29 -- Ubqtous [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
(Admin) Archive issues
I'm fixing some things in the archive which includes previous/next functionality and such. If the archive isn't working for you at the moment, this is why. Sorry for the inconvenience. -- Michael Dinowitz House of Fusion http://www.houseoffusion.com Finding technical solutions to the problems you didn't know you had yet [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: variables with cfquery
Mike, Thanx for the help.I'm using MX2004 - LoadVars() and including that extra field.Unfortunatly I am not using Flash remoting...for some reason my boss doesn't want me to go that route?Everything seems like it should work alright...but the variables are not getting passed to flash. To shed a little light on what I'm doing, flash gets its data from a database.The records retrieved are then converted to movieClips in Flash so the user can drag the movie clips.When finished, the user clicks a 'save' button and the x and y fields are updated. All data is inserted into flash ok, after dragging movieClips around the user hits the save button: save_btn. { saveObject = new LoadVars(); saveObject.> _root.gotoAndStop(EPS_lbl); }; var step = 0; for (var mc in _root.list_mc) { if (typeof _root.list_mc[mc] == movieclip) { step++; var tmpName = String(mc); dragNum = tmpName.substr(8); //variable dragNum is the number appended at the end of each //instance name and it is used to access other information var tmpProcStepID = eval(container.processStepId_ + dragNum); //this is where I think the problem starts saveObject[procStepId + step] = tmpProcStepID; saveObject[x + step] = _root.list_mc[tmpName]._x saveObject[y + step] = _root.list_mc[tmpName]._y; } } //passing that variable for the number of loops CF should execute saveObject.numSteps = step; saveResults = unescape(saveObject); //this trace shows that saveObject is sending what it should trace(saveResults); saveObject.sendAndLoad(sample.cfm,saveObject,POST); //I'm using getURL to check that the correct data is being sent. //And none of the form fields that I am sending (via saveObject) show up getURL(sample.cfm,blah,POST); gotoAndStop(processing_lbl); } Thak you - Frank From: JediHomer [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 9:14 AM To: CF-Talk Subject: Re: variables with cfquery How are you sending the variables to CF? via LoadVariables() if so you could pass in an extra field that states how many fields you have created and then use that as the number of loops for CF to perform. You could also potentially use Flash Remoting (if flash version is not an issue and you are you MX+) and build up and object to pass to CF which then treats it as a structure HTH Mike - Original Message - From: Frank Dewey [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 09:03:07 -0500 Subject: variables with cfquery To: CF-Talk [EMAIL PROTECTED] hello all, I am sending a file from flash to CF.The variables are getting there...so that is no problem.However, once they get there, then I am not sure how to put them into action.For example, I am sending many x and y values, and some IDs.So a basic query for sending flash variables to CF looks like this: assume I am sending these values from Flash to CF - xValue; yValue; myID; CFpage - cfquery ... UPDATE tableName SETx = #form.xValue#, y =#form.yValue# WHERE ID = #form.myID# /cfquery The problem is that I am sending several values and I don't know how many until run-time.I also have to create the variables and there values at run-time...so this is what I have: assume I am sending these values from Flash to CF - x1 = 10; y1 = 50; myID1 = 1045; x2 = 10; y2 = 50; myID = 2; ... CFpage - cfloop from=1 to=#form.numberOfValues# index=i cfset thisX = form.x#i# cfset thisY = form.y#i# cfset thisID = form.myID#i# cfquery ... UPDATE tableName SETx = #thisX#, y =#thisY# WHERE ID = #thisID# /cfquery /cfloop So I am asking how to create a dynamic variable...involving concatenation?Any help with this problem is greatly appreciated - Frank --- The Preceeding Email Has Been Scanned and Verified By QBOS Security Systems --- QBOS, Inc. 14275 Midway Rd.Suite 220 Addison, TX 75001 972.233.5066 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: variables with cfquery
So when you do the LoadVars() then CF receives all the correct information but Flash is then expecting feedback/vars from CF? If so how are you formating the data as I beleive it should be CFContented to Plain Text and be ampersand delimited pairs i.e. firstname=jedilastname=homer HTH Mike - Original Message - From: Frank Dewey [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 12:54:33 -0500 Subject: RE: variables with cfquery To: CF-Talk [EMAIL PROTECTED] Mike, Thanx for the help.I'm using MX2004 - LoadVars() and including that extra field.Unfortunatly I am not using Flash remoting...for some reason my boss doesn't want me to go that route?Everything seems like it should work alright...but the variables are not getting passed to flash. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: variables with cfquery
I don't think that flash is expecting anything from CF...if it is, then it operates correctly without it.I did another project similar to this one that also made several calls to ColdFusion...flash sent data out, but never received any from CF. I misspoke on my last email.I said: ...but the variables are not getting passed to flash. What I meant was that CF is passing the variables to flash ok, but flash is not sending out the correct variables to CF. Thanx - Frank From: JediHomer [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 1:47 PM To: CF-Talk Subject: Re: variables with cfquery So when you do the LoadVars() then CF receives all the correct information but Flash is then expecting feedback/vars from CF? If so how are you formating the data as I beleive it should be CFContented to Plain Text and be ampersand delimited pairs i.e. firstname=jedilastname=homer HTH Mike - Original Message - From: Frank Dewey [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 12:54:33 -0500 Subject: RE: variables with cfquery To: CF-Talk [EMAIL PROTECTED] Mike, Thanx for the help.I'm using MX2004 - LoadVars() and including that extra field.Unfortunatly I am not using Flash remoting...for some reason my boss doesn't want me to go that route?Everything seems like it should work alright...but the variables are not getting passed to flash. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: variables with cfquery
Looking back at the code it could be the getURL that you call straight after it that *possibly* might be playing things up, getURL doesnt support the POST method, so try removing that... Potentially Dumb the function down for a test so that you know the loadVars is definately working at that point HTH - Original Message - From: Frank Dewey [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 15:09:04 -0500 Subject: RE: variables with cfquery To: CF-Talk [EMAIL PROTECTED] I don't think that flash is expecting anything from CF...if it is, then it operates correctly without it.I did another project similar to this one that also made several calls to ColdFusion...flash sent data out, but never received any from CF. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
[RESOLVED] re: Day of Week in Access
I found the answer to my problem. Basically, the Access Help files screwed me over yet again (when will I ever learn?).While the examples in the Help files have double quotes around the datepart type (w), using CF it needs to be single-quotes ('w'). Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: variables with cfquery
I'll definately try that...thanx Mike - frank From: JediHomer [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 3:39 PM To: CF-Talk Subject: Re: variables with cfquery Looking back at the code it could be the getURL that you call straight after it that *possibly* might be playing things up, getURL doesnt support the POST method, so try removing that... Potentially Dumb the function down for a test so that you know the loadVars is definately working at that point HTH - Original Message - From: Frank Dewey [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 15:09:04 -0500 Subject: RE: variables with cfquery To: CF-Talk [EMAIL PROTECTED] I don't think that flash is expecting anything from CF...if it is, then it operates correctly without it.I did another project similar to this one that also made several calls to ColdFusion...flash sent data out, but never received any from CF. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: DateFormat
On Mon, 05 Jul 2004 12:05:50 -0400, Asim Manzur [EMAIL PROTECTED] wrote: I want to display like Monday, July 5th, 2004 No one did the obvious: http://www.cflib.org/udf.cfm?ID=907 :) -- Kay Smoljak http://kay.smoljak.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Counting weekdays only
Does anyone have a way to remove weekends and count only weekdays between two dates? I am currently using CF 5 Terry Troxel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Counting weekdays only
Check the archives.There was a discussion on exactly this topic a month ago or so, including at least a couple implementations in UDF form. Cheers, barneyb -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 4:04 PM To: CF-Talk Subject: Counting weekdays only Does anyone have a way to remove weekends and count only weekdays between two dates? I am currently using CF 5 Terry Troxel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Counting weekdays only
UDF means CF MX correct. Need a solution for CF 5 Terry Troxel - Original Message - From: Barney Boisvert To: CF-Talk Sent: Monday, July 05, 2004 4:16 PM Subject: RE: Counting weekdays only Check the archives.There was a discussion on exactly this topic a month ago or so, including at least a couple implementations in UDF form. Cheers, barneyb -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 4:04 PM To: CF-Talk Subject: Counting weekdays only Does anyone have a way to remove weekends and count only weekdays between two dates? I am currently using CF 5 Terry Troxel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Counting weekdays only
CF5 supports UDFs in cfscript form. _ From: Terry Troxel [mailto:[EMAIL PROTECTED] Sent: Tuesday, 6 July 2004 12:04 p.m. To: CF-Talk Subject: Re: Counting weekdays only UDF means CF MX correct. Need a solution for CF 5 Terry Troxel - Original Message - From: Barney Boisvert To: CF-Talk Sent: Monday, July 05, 2004 4:16 PM Subject: RE: Counting weekdays only Check the archives.There was a discussion on exactly this topic a month ago or so, including at least a couple implementations in UDF form. Cheers, barneyb -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 4:04 PM To: CF-Talk Subject: Counting weekdays only Does anyone have a way to remove weekends and count only weekdays between two dates? I am currently using CF 5 Terry Troxel _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Counting weekdays only
UDF means CF MX correct. Need a solution for CF 5 CF5 supports functions generated within cfscript tags... MX simply provides more functionality. Hatton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Manipulation Excel files
This is a great little post on leveraging java libraries for Excel. Dave Ross' blog has a bunch of others that might also shed some light. Generating Excel spreadsheets from CFMX http://www.medlogs.com/dave/001848.html Where would you be without these little gems appearing daily on Fullasagoog (http://www.fullasagoog.com/)? -- geoff http://www.daemon.com.au/ - Original Message - From: Mickael [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 10:53:35 -0400 Subject: Manipulation Excel files To: CF-Talk [EMAIL PROTECTED] Hello All, I was wondering if someone could point me in the right direction.I need to be able to extract certain information from cells an excel file, update some cell, delete some rows in the file then import the file to my database.Can anybody point me to a resource that explains how to do this or if someone has some experience with this it would be greatly appreciated. Thank you Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Error trapping when a file is not found
In IIS, you can go into the Application Mappings and set an option to Check if the file exists.Is there a similar option in Apache? Todd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Alagad Image.cfc not working on MX6.1
Installing XFree86-libs did the trick. Thanks for your help! [EMAIL PROTECTED] root]# apt-get install XFree86-libs Reading Package Lists... Done Building Dependency Tree... Done The following extra packages will be installed: XFree86-Mesa-libGL XFree86-libs-data fontconfig freetype The following NEW packages will be installed: XFree86-Mesa-libGL XFree86-libs XFree86-libs-data fontconfig freetype On Mon, 5 Jul 2004 16:50:20 +0100, Thomas Chiverton [EMAIL PROTECTED] wrote: On Sunday 04 Jul 2004 03:05 am, Ubqtous wrote: Back to square one. You could just install the relevant package... [EMAIL PROTECTED] ceo_platform]# locate libXp.so.6 /usr/X11R6/lib/libXp.so.6 /usr/X11R6/lib/libXp.so.6.2 [EMAIL PROTECTED] ceo_platform]# rpm -q --whatprovides /usr/X11R6/lib/libXp.so.6 XFree86-libs-4.1.0-29 -- Ubqtous [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Manipulation Excel files
I have an open source CFX available at http://sourceforge.net/projects/openxcf named CFX_ExcelQuery that allows you to read and write XLS files as CF queries. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mickael Sent: Monday, July 05, 2004 10:54 AM To: CF-Talk Subject: Manipulation Excel files Hello All, I was wondering if someone could point me in the right direction.I need to be able to extract certain information from cells an excel file, update some cell, delete some rows in the file then import the file to my database.Can anybody point me to a resource that explains how to do this or if someone has some experience with this it would be greatly appreciated. Thank you, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Creating Excel workbooks
I've found this piece of code (on that pathetic online manual that Macromedia hosts): cfscript obj = CreateObject(Com, excel.application.9); obj.quit(); ReleaseCOMObject(obj); /cfscript but when I run it, the page never comes back... what could the problem be?alternatively, does anyone have a good reference for how to create pivot tables in Excel from a Cold Fusion page? thx - erick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
BrowserHawk
Check out browserhawk at www.cyscape.com..it offers a lot more than browser size, maybe worth considering? Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Obtaining Browser Size
sorry, I messed up...the post BrowserHawk should have been in this thread. Pity we can't edit these posts Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Creating Excel workbooks
Office Automation is not safe for server side use.You should avoid code similar to what you posted (anything that instantiates an office application). Office Web Components supports pivot tables.I have a small example in one presentation that talks about OWC but the example only covers using it to create chart. http://www.rewindlife.com/archives/000118.cfm You should be able to find information online if you don't mind examples in ASP or .NET--search google and msdn. Best regards, Sam -Original Message- From: erick calder [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:26 PM To: CF-Talk Subject: Creating Excel workbooks I've found this piece of code (on that pathetic online manual that Macromedia hosts): cfscript obj = CreateObject(Com, excel.application.9); obj.quit(); ReleaseCOMObject(obj); /cfscript but when I run it, the page never comes back... what could the problem be?alternatively, does anyone have a good reference for how to create pivot tables in Excel from a Cold Fusion page? thx - erick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Build JAVA request and response scopes in CF
Thanks Kola, that worked fine! Didnt know GetPageContext() supported all the methods and properties in CF like it does in Java Thanks for the help! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]