Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
bflophil #1
CFGRID QUERY USING A WHERE CLAUSE
All of the cfgrid query examples I see do not include a WHERE clause. I
would like to know if it is possible to include one and how do you pass in
an argument via the url.address. for example. Or possibly and alternative
method of passing a value to the query?
SELECT NAME, ADDRESS FROM USER_INFO
WHERE USER_ID = #URL.UID#
bflophil Guest
-
Simple WHERE clause in CFQUERY Has error executingdatabase query
Hello, I'm sort of new to CF, but have been doing this enough that this is very frustrating! I'm using the standalone version of ColdFusion 6.1 on... -
SQL Query - how to contruct a WHERE clause
I have a field in a table that contains a comma separated list that I want to be able to determine whether or not any of the items in the list are... -
Binding CFGrid and Query MX7
Hello- I was playing around with flash forms in MX7. I want to bind a quesry to a cfgrid. I looked at the demo on the MM site, and am trying to do... -
Query Optimizer Problem with Views in where Clause
Hi! I am using Sql 7 SP3. I have noticed strange Query plan when using views. Here is the case: Table1 has Col1, Col2, Col3 .... etc. Col1 is... -
Efficient query without using NOT IN clause
Hi all, I have got two tables:- a) students ======== std_id Numeric std_name Varchar(50) std_grade Varchar(10) -
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
