Matthew Walker wrote:
> http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid
> =16005&forumid=4
>
> Great explanation thanks Jochem. Interested to hear about the dbms
> hashing the query and checking if the hash exists as a key to execution
> plans.
That was an example, differ
>
http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid
=16005&forumid=4
Great explanation thanks Jochem. Interested to hear about the dbms
hashing the query and checking if the hash exists as a key to execution
plans. Is there no risk of two queries being hashed to the same val
thanks, i just went ahead and tried it and it seemed fine. I just have that
becarefull of single quotes stuck in my head.
Dave
- Original Message -
From: "Dave Carabetta" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, June 01, 2003 1
Matthew Walker wrote:
>>When using cfqueryparam, you leave off the single quotes. The tag will
>>format the value in the appropriate way based on the cfsqltype attribute
>>set.
>
> Actually I don't think it decides whether or not to insert the quotes -- it
> uses another mechanism for passing the
> When using cfqueryparam, you leave off the single quotes. The tag will
> format the value in the appropriate way based on the cfsqltype attribute
> set.
Actually I don't think it decides whether or not to insert the quotes -- it
uses another mechanism for passing the value altogether. The values
> what do u do with single quote when adding query param to a sql statement?
>
> say when i want to do it when im filtering by session.username
> do i add the single quotes to the query param or can i leave them out?
>
>
>
>
> SELECT userID, username, fName, lName, phone, email, city, state, zip
thanks, i just didnt know what to do with the single quotes:)
- Original Message -
From: "Marius Milosav" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, May 31, 2003 10:05 PM
Subject: Re: quick query param question
> yo
m/vicodemo/login.cfm
- Original Message -
From: "Dave Lyons" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, May 31, 2003 10:00 PM
Subject: quick query param question
> what do u do with single quote when adding query param to a sql st
what do u do with single quote when adding query param to a sql statement?
say when i want to do it when im filtering by session.username
do i add the single quotes to the query param or can i leave them out?
SELECT userID, username, fName, lName, phone, email, city, state, zip
FROM user
WHERE
9 matches
Mail list logo
