An extremely disturbing CF bug
I have just run across a very strange bug, one that I have never seen before. http://www.clevelandmmug.org/index.cfm?dsp=Meetings Do a View Source... How is it possible that I can see my CF code in the View Source? I thought that was impossible. This server is running CFMX 6.1 on a Linux environment. Any ideas? -- Sincerely, Brian Meloche http://www.brianmeloche.com http://www.clevelandmmug.org (almost back up) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX6.1 host that also supports JSP and Servlets and/or Java Beans?
LOL! Amen to that! ;) -- Original Message -- From: Sean Corfield <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Sat, 9 Oct 2004 21:33:42 -0700 >On Sat, 09 Oct 2004 21:34:40 -0400, Orlando. Correa @ mail. ihs. gov >Orlando. Correa @ mail. ihs. gov <[EMAIL PROTECTED]> wrote: >> Thanks! I'll check them out. Have you seen any Windows platform hosts with the JSP offerings? o > >Why would you want to host on Windows? > >(Sorry, I tried really hard to resist asking but I just couldn't help myself :) >-- >Sean A Corfield -- http://www.corfield.org/ >Team Fusebox -- http://www.fusebox.org/ >Got Gmail? -- I have 2 invites > >"If you're not annoying somebody, you're not really alive." >-- Margaret Atwood > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX6.1 host that also supports JSP and Servlets and/or Java Beans?
On Sat, 09 Oct 2004 21:34:40 -0400, Orlando. Correa @ mail. ihs. gov Orlando. Correa @ mail. ihs. gov <[EMAIL PROTECTED]> wrote: > Thanks! I'll check them out. Have you seen any Windows platform hosts with the JSP offerings? o Why would you want to host on Windows? (Sorry, I tried really hard to resist asking but I just couldn't help myself :) -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Got Gmail? -- I have 2 invites "If you're not annoying somebody, you're not really alive." -- Margaret Atwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Why does this function not return a variable of Type Query
Yup, that's got it. Stupid error. Thanks.
-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 09, 2004 8:16 PM
To: CF-Talk
Subject: Re: Why does this function not return a variable of Type Query
On Sat, 9 Oct 2004 17:36:29 -0500, Andy Ousterhout <[EMAIL PROTECTED]>
wrote:
> Why does this:
>
>
> returnvariable="qryPostalCodes"/>
> #IsQuery("qryPostalCodes")#
>
Get rid of the quotes in the isQuery() function. You're asking the
function to check the string "qryPostalCodes" instead of a pointer to
the query object.
Regards,
Dave.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Why does this function not return a variable of Type Query
Does it have anything to do with the fact that you are setting the query
to the application scope, but not using the application scope in the
isQuery function?
--
Exciteworks, Inc
Expert Hosting for less!
*Ask for a free 30 day trial!*
http://exciteworks.com
Plans starting at -$12.95- including MS SQL Server!
Andy Ousterhout wrote:
> Sorry, just pulled the wrong component. I've got the same thing for
> state.
> Rename the call and repeat. Same problem.
> -Original Message-
> From: Josh [mailto:[EMAIL PROTECTED]
> Sent: Saturday, October 09, 2004 6:08 PM
> To: CF-Talk
> Subject: Re: Why does this function not return a variable of Type Query
>
> Well, the method you are calling is getPostalCodes and the name of the
> cffunction is getStates...seems like there is a mismatch in the code.
>
> Hope that helps.
>
> -Josh
>
> --
> Exciteworks, Inc
> Expert Hosting for less!
> *Ask for a free 30 day trial!*
> http://exciteworks.com
>
> Plans starting at -$12.95- including MS SQL Server!
>
> Andy Ousterhout wrote:
>
> > Why does this:
> >
> >
> method="getPostalCodes"
> > returnvariable="qryPostalCodes"/>
> > #IsQuery("qryPostalCodes")#
> >
> > Where:
> >
> >
> > returntype="query" displayname="Returns state list">
> >
> >
> >
> > datasource="#instance.settings.DSN#"
> > dbtype="ODBC" username="#instance.settings.DBRead.ID#"
> > password="#instance.settings.DBRead.PW#" >
> > SELECT State
> > FROM tabZipCodes
> > GROUP BY State
> >
> >
> >
> >
> > Return a NO indicating the data is not a query, but when it is
> dumped, it
> > looks like a query and acts like a query except it can't be used in a
> > statement.
> >
> > Andy
> >
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: CFMX6.1 host that also supports JSP and Servlets and/or Java Beans?
Thanks! I'll check them out. Have you seen any Windows platform hosts with the JSP offerings? o > http://www.smarterlinux.com/ > > On Thu, 07 Oct 2004 14:08:32 -0400, Orlando. Correa @ mail. ihs. gov > Orlando. Correa @ mail. ihs. gov <[EMAIL PROTECTED]> wrote: > > Does anyone know of a good CFMX6.1 host that also supports JSP and > Servlets and/or Java Beans? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Why does this function not return a variable of Type Query
On Sat, 9 Oct 2004 17:36:29 -0500, Andy Ousterhout <[EMAIL PROTECTED]> wrote:
> Why does this:
>
>
> returnvariable="qryPostalCodes"/>
> #IsQuery("qryPostalCodes")#
>
Get rid of the quotes in the isQuery() function. You're asking the
function to check the string "qryPostalCodes" instead of a pointer to
the query object.
Regards,
Dave.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: SQL stored procedure question
"I'd suggest sticking with cfquery for now. SQL Server is going to better (faster,more stable) than Access even if you don't use stored procedures for everything." I would have to disagree, MS SQL Server has its limitations in Programming Stored Procedures but the things you point out can easily be done is SP's. You are using cfQuery to dynamically build an SQL Command, the same can be done with SP's elegantly using 2 contructs. 1. Dynamic SQL Build 2. Parameter driven SQL Stored Procedures are a clean way of abstracting your data calls to the DB, especially in instances where you have to have wired calls for Multiple DB transactions. Now, it would be nice if SQL Server provided a set of Java API's to access Stored Procedures as Java Classes and accessible kinda like Prepared Statements work. cfQuery is just an easy dirty way of getting the job done, once you start getting to complex application development... cfQuery and SQL all over the application is Messy. Joe Eugene -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 3:50 PM To: CF-Talk Subject: RE: SQL stored procedure question Stored procedures don't work the way you are expecting them to work, and you are discovering. When you're using cfquery you can use cf variables and cf logic to build a sql statement, and when the statement is all built it goes to the sql server (or access, or whatever) and then it's run. That means you can do pretty much anything in the cfquery tag to build you sql statement, as long as the final output is valid sql. In effect, you're using cf to write a program in another language (sql), and then running it. This is one of the coolest features of cf because it is really powerful (as your original cfquery code proves). When you write a stored procedures the entire procedure must be valid sql *before* you apply any of the "if" logic and variables replacements. Variable names can only go where constants go, for example, so you could never have a variable that said "order by xyz" and just stick it on the end of a select. (There is a way around that, using exec, but it's a hassle.) sql is not a tremendously flexible language and some things are just not easy to do... your second query is a good example of something that's a real pain. I'd suggest sticking with cfquery for now. SQL Server is going to better (faster,more stable) than Access even if you don't use stored procedures for everything. Mark -Original Message- From: Pratte, Jeff [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 2:06 PM To: CF-Talk Subject: SQL stored procedure question OK, after hearing everybody say don't use Access and an converting my Check Request System to MS SQL Server. And I am trying to use Stored Procedures. However, I am finding it more difficult then I anticipated. For instance, I used to have a query like this: blockfactor="100"> select crID, SOffUser, SOffNote from qrySignoffRequest where SOffDecision = 'Open' and SOffUser = '#theUser#' order by #sort5# My stored procedure attempt was this: CREATE PROCEDURE SignOffCheckRequest_Getx_byDecision_SoffUser @SoffUser varchar(10), @Decision varchar(10), @Sort varchar(10) AS select crID, SOffUser, SOffNote from viewSignoffCheckRequest where SOffDecision = @Decision and SOffUser = @SoffUser Order by CASE WHEN @Sort = 'crID' THEN crID WHEN @Sort = 'crDate' THEN crDate WHEN @Sort = 'crVendor' THEN crVendor WHEN @Sort = 'crChkAmt' THEN crChkAmt WHEN @Sort = 'SOffUser' THEN SOffUser END GO It worked for every type of sort except one (crVendor) where it said that it was trying to convert an nvarchar to a float. What's that all about? Then we come to this query: username="abc" password="xyz"> select * from WEBMASTER.AP_COA where 1=1 "">and ldr_entity_id like '#searchCO#%' gt "">and ull_prime like '#searchPRIME#%' "">and ull_center like '#searchCTR#%' "">and ull_sbu like '#searchSBU#%' "">and ull_product like '#searchPROD#%' "">and ull_minor like '#searchMIN#%' searchCUSTOMER gt "">and ull_customer like '#searchCUSTOMER#%' gt "">and ull_misc1 like '#searchMISC1#%' gt "">and ull_misc2 like '#searchMISC2#%' How do I convert that to a stored procedure? I am about to give up! Thanks for you help, Jeff Notice. This message is intended only for use by the person or entity to which it is addressed.
RE: Why does this function not return a variable of Type Query
Sorry, just pulled the wrong component. I've got the same thing for state.
Rename the call and repeat. Same problem.
-Original Message-
From: Josh [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 09, 2004 6:08 PM
To: CF-Talk
Subject: Re: Why does this function not return a variable of Type Query
Well, the method you are calling is getPostalCodes and the name of the
cffunction is getStates...seems like there is a mismatch in the code.
Hope that helps.
-Josh
--
Exciteworks, Inc
Expert Hosting for less!
*Ask for a free 30 day trial!*
http://exciteworks.com
Plans starting at -$12.95- including MS SQL Server!
Andy Ousterhout wrote:
> Why does this:
>
>
> returnvariable="qryPostalCodes"/>
> #IsQuery("qryPostalCodes")#
>
> Where:
>
>
> returntype="query" displayname="Returns state list">
>
>
>
> datasource="#instance.settings.DSN#"
> dbtype="ODBC" username="#instance.settings.DBRead.ID#"
> password="#instance.settings.DBRead.PW#" >
> SELECT State
> FROM tabZipCodes
> GROUP BY State
>
>
>
>
> Return a NO indicating the data is not a query, but when it is dumped, it
> looks like a query and acts like a query except it can't be used in a
> statement.
>
> Andy
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Why does this function not return a variable of Type Query
Well, the method you are calling is getPostalCodes and the name of the
cffunction is getStates...seems like there is a mismatch in the code.
Hope that helps.
-Josh
--
Exciteworks, Inc
Expert Hosting for less!
*Ask for a free 30 day trial!*
http://exciteworks.com
Plans starting at -$12.95- including MS SQL Server!
Andy Ousterhout wrote:
> Why does this:
>
>
> returnvariable="qryPostalCodes"/>
> #IsQuery("qryPostalCodes")#
>
> Where:
>
>
> returntype="query" displayname="Returns state list">
>
>
>
> datasource="#instance.settings.DSN#"
> dbtype="ODBC" username="#instance.settings.DBRead.ID#"
> password="#instance.settings.DBRead.PW#" >
> SELECT State
> FROM tabZipCodes
> GROUP BY State
>
>
>
>
> Return a NO indicating the data is not a query, but when it is dumped, it
> looks like a query and acts like a query except it can't be used in a
> statement.
>
> Andy
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Why does this function not return a variable of Type Query
Why does this:
returnvariable="qryPostalCodes"/>
#IsQuery("qryPostalCodes")#
Where:
returntype="query" displayname="Returns state list">
dbtype="ODBC" username="#instance.settings.DBRead.ID#"
password="#instance.settings.DBRead.PW#" >
SELECT State
FROM tabZipCodes
GROUP BY State
Return a NO indicating the data is not a query, but when it is dumped, it
looks like a query and acts like a query except it can't be used in a
statement.
Andy
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Expert Coder List Needed
> I appologize for posting this message here, but I'm looking > for an expert Flash developers list. I can't seem to get to > flash coders at chattyfig.figleaf.com anymore. You can > contact me directly if you like. The list server was shut down this morning temporarily, because our building had the power shut off for yearly inspection. It'll be back up shortly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX 61 - J2EE Configuration
> >
> > jdbcDriver = CreateObject("java",
> > "macromedia.jdbc.sqlserver.SQLServerDriver");
> > writeoutput(jdbcDriver.getMajorVersion() & "." &
> > jdbcDriver.getMinorVersion());
>
> looks useful - can it be adapted to other driver types? To
> other database types I mean.
I haven't tested it, but I'd expect it to work with any of the DataDirect
drivers shipped with CFMX.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: CFMX 61 - J2EE Configuration
looks useful - can it be adapted to other driver types? To other
database types I mean.
On Fri, 8 Oct 2004 12:37:28 +0100, Greg Stewart <[EMAIL PROTECTED]> wrote:
> Here's a little snippet that I used to determine the version of drivers:
>
>
> jdbcDriver = CreateObject("java",
> "macromedia.jdbc.sqlserver.SQLServerDriver");
> writeoutput(jdbcDriver.getMajorVersion() & "." &
> jdbcDriver.getMinorVersion());
>
>
> Cheers
> G
>
> On Thu, 7 Oct 2004 15:43:27 -0400, Dave Carabetta <[EMAIL PROTECTED]>
> wrote:
> > On Thu, 7 Oct 2004 15:35:54 -0400, Adkins, Randy <[EMAIL PROTECTED]>
> wrote:
> > > In light of that, how can I determine the version of the DataDirect
> > > drivers
> > > that are being utilized?
> > >
> > > I would like to eliminate all possible avenues relating to performance
> > > issues
> > > we are experiencing on the server for JRUN to spike so much that we
> > > have to reboot the server.
> > >
> >
> > Drop this code into a cfm page, run it, and view your console/log file
> > to see the output of the driver version number:
> >
> >
> >
> >
> >
> >
> type="JAVA">
> >
> >
> >
> >
> > Regards,
> > Dave.
> >
> >
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Expert Coder List Needed
I appologize for posting this message here, but I'm looking for an expert Flash developers list. I can't seem to get to flash coders at chattyfig.figleaf.com anymore. You can contact me directly if you like. Thanks Orlando [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Access type mismatch killing me - and also this website
My last post clued me in. Somehow the weight column settings were changed on the one column. Who'd a thunk it? Ignore me. -Unless you can answer about the site login issue. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Access type mismatch killing me - and also this website
>> WHERE (Weight >= #w2#) To clarify further, weight in the db column has even numbers. I'm getting 0 records returned if w2 has a decimal. 35.1 SHOULD return the values corresponding to 36 (as the single row >=35.1), but returns nothing for some reason. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Errors on pushFile code block with search engine bots.
Does anyone know if this would work the same as this? I don't really understand the theory or background behind cfheader tags, and there's little documentation to go by. thanks, Nando On Sat, 9 Oct 2004 13:10:38 +0200, Nando <[EMAIL PROTECTED]> wrote: > Dave, > > I'd need something like this in robots.txt ... > > Disallow: *?*file=* > > Everything's dynamic, so i don't know the url's in advance. And i > don't think that would work somehow. But your post gave me an idea ... > maybe i could try to push a don't follow / don't index header up with > the other cfcontent tags and see what happens. Don't know the syntax > off-hand, but it might work. I have to check it out. Thanks. > > > > On Fri, 8 Oct 2004 08:22:01 -0400, Dave Watts <[EMAIL PROTECTED]> wrote: > > > Anyone have a take on this? An intelligent solution? Should i > > > be filtering the download process to exclude the search engines? > > > > You should use robots.txt to specify which URLs to exclude. > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > phone: 202-797-5496 > > fax: 202-797-5444 > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Hot fix and J2EE session cookies: MM Please read
Hi all. I've been so busy and whacked out by all these hurricanes lately that I unsubscribed for awhile. Now I need your help or at least get this message to MM. A hot fix just came out on 10/7 I believe. It will update the Server.ColdFusion.ProductVersion to: 6,1,0,83762 This hot fix just broke a BUNCH of shopping carts on Crystal Tech for me. I'm hoping they are working with MM on this, but sometimes it takes a few days to convince their support team that there is a problem with CF or their servers. To make this short and to the point as possible... A person using my shopping cart may typically move back and forth between secure and non-secure URLs like: http://www.cf-ezcart.com/etc. to https://www229.ssldomain.com/cf-ezcart/etc. If they begin checkout, abort checkout, etc. I ALWAYS pass the urltoken, which will contain the jsessionid when clicking "Check Out". This is in order to keep the session alive. Since CF does not set a jsessionid cookie if the jsessionid URL variable is passed, I have always set it manually using CFCOOKIE. This has never been a problem, until the hot fix. The bug in the hot fix is this: The internally generated JSESSIONID has $ symbols in it. When CF writes the cookie itself, it writes the value as raw data. When I duplicate it with CFCOOKIE when moving to the secure URL, it URL Encodes the data so the $ becomes %24. MX has always done this so this is not the problem in itself. The problem is that if I have an internal JSESSIONID of AB$C and a JSESSIONID cookie of AB%24C, my session is dying. Basically, CF is not decoding the cookie value before comparing it as it always have. This has REALLY caused me some grief. The only work around I have found so far is to set the cookies using _javascript_ as that allows me to set a raw value. Thanks for any insight into this is getting it passed on to someone who can get this fixed. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development & Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local & Int'l Phone/Fax: 386.789.0968 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Access type mismatch killing me - and also this website
Ok, this is killing me. Acess db query fails if w2 has a decimal place. Works if an integer. SELECT #ShipZonesCAUPS.Day3# AS d3, #ShipZonesCAUPS.Standard# AS st, weight FROM ShipCanUS WHERE (Weight >= #w2#) cfqueryparam shows a type mismatch using type float or numeric (not sure which is correct as the docs are so bad). Works with type integer. Thing is same query works fine on 2 other tables that are the same setup. All have type "number" columns. Any ideas? * BTW, how to edit your account here? All account links return to the same sign in page, showing you signed in. Using Firefox. Also, can the admin add some css for spacing between the lines on the list of threads? So scrunched together they're hard to read. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Errors on pushFile code block with search engine bots.
Dave, I'd need something like this in robots.txt ... Disallow: *?*file=* Everything's dynamic, so i don't know the url's in advance. And i don't think that would work somehow. But your post gave me an idea ... maybe i could try to push a don't follow / don't index header up with the other cfcontent tags and see what happens. Don't know the syntax off-hand, but it might work. I have to check it out. Thanks. On Fri, 8 Oct 2004 08:22:01 -0400, Dave Watts <[EMAIL PROTECTED]> wrote: > > Anyone have a take on this? An intelligent solution? Should i > > be filtering the download process to exclude the search engines? > > You should use robots.txt to specify which URLs to exclude. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
