CFQuery Select and single quotes in string

I'm doing a look up like this: cfquery datasource=#DSN# name=GetResults SELECT Formation, Play, BallCarrier, YardsGained, Result FROM PlaysCalled WHERE (((PlaysCalled.Formation)=#Form.Formation#) AND ((PlaysCalled.Play)=#Form.Play#) AND ((PlaysCalled.BallCarrier)=#Form.BallCarrier#));

re: CFQuery Select and single quotes in string

Yes, and if this is form input, you should be using cfqueryparam anyway. Please see the news for Sony's latest data hack, which was simple web-based SQL injection. cfsqltype will need to match column datatype in each case. cfquery datasource=#DSN# name=GetResults SELECT Formation, Play,

Fuseguard processing time

I finally got around to getting an evaluation version of fuseGuard up and running on my dev server. Install was easy, so that was good. On my dev server, fuseguard is adding approx. 200 ms to each page load. Super simple pages with no form variable input went from 18-20ms to 190-200ms.. The

Re: CFQuery Select and single quotes in string

What DBMS are you using? MSSQL, MYSQL, Access (bleeackk!), other? MSSQL uses single quotes in the WHERE clause. However, if you use cfqueryparam for all of your where clause pieces, single quotes in your strings should pass through in the database request just fine. What is the data type of

Re: Fuseguard processing time

200ms is still a good page load time. I wish most of our customers had pages that load that quick :-) consider what it is doing, checking all scopes for injection, which is all string comparison (regex I presume), so that is heavy work. Pete did say it would add about 200ms, so I guess he was

Why would this code return this error?

Hi, all... I've been trying to set up some CF/AJAX/CFC functionality and when it wasn't working as expected, re-coded to track variables through the functionality. All the variables have been showing up fine in alerts throughout. However, now at this point in the code: cfargument name =

re: Why would this code return this error?

imagesList = arguments.images, which is a string. The parameter for ValueList() has to be a query.column name and the query has to be available in the scope of the call to ValueList(). From: Rick Faircloth r...@whitestonemedia.com Sent: Friday, June

Re: Why would this code return this error?

Yes, becasue according to your cfargument , the variable 'images' is a string, not a query. On Fri, Jun 10, 2011 at 3:09 PM, Rick Faircloth r...@whitestonemedia.com wrote: Hi, all... I've been trying to set up some CF/AJAX/CFC functionality and when it wasn't working as expected, re-coded

Re: Why would this code return this error?

ARGUMENTS.images (the value of imagesList) is a string and not a query valueList() is for making a list out of a column fomr a query string query error can not computer! ;-) HTH Cheers On Fri, 2011-06-10 at 15:09 -0400, Rick Faircloth wrote: Hi, all... I've been trying to set up some

RE: Why would this code return this error?

@ Bryan, Scott, and Jason: Oh, you guys are just smarty-pants! After 2 days of wrestling with this entire functionality, I had gotten it into an overly complicated state. This works just fine: cfargument name = images type = string required = yes / cfargument name =

RE: Why would this code return this error?

TGIF I bet Rick ;-) Cheers On Fri, 2011-06-10 at 15:24 -0400, Rick Faircloth wrote: @ Bryan, Scott, and Jason: Oh, you guys are just smarty-pants! After 2 days of wrestling with this entire functionality, I had gotten it into an overly complicated state. This works just fine:

RE: Why would this code return this error?

YGTR! :o) -Original Message- From: Bryan Stevenson [mailto:br...@electricedgesystems.com] Sent: Friday, June 10, 2011 3:59 PM To: cf-talk Subject: RE: Why would this code return this error? TGIF I bet Rick ;-) Cheers On Fri, 2011-06-10 at 15:24 -0400, Rick Faircloth wrote: @

Re: VPS Hosting

I'm using KickAssVPS and have been happy; support is good, but not always on-the-spot prompt, so keep that in mind if you need five 9's. I have my own CF9 license, so I went with the basic Entry VPS plan; you'll never shoehorn CF and a database on the VPS with a gig of RAM. Two gigs works fine,

Re: Homesite 5.5

Glad I'm not the only one who still prefers it over the newer stuff :) On Tue, May 17, 2011 at 10:20 AM, edmo...@sitecon.com edmo...@sitecon.com edmo...@sitecon.com wrote: Hello All, I have lost my media for Homesite 5.5. I still have serial numbers. Does anyone one by chance have the

Re: Homesite 5.5

Glad I'm not the only one who still prefers it over the newer stuff :) I use it everyday. I try other applications, but I always come back. J ~| Order the Adobe Coldfusion Anthology now!