Ask a Question related to Coldfusion Database Access, Design and Development.
-
Creasiamedia #1
CFPARAM Query syntax
Can anyone tell me the proper syntax to enter a query into a cfparam variable??
I would like to put the result of the query Recordset3 into the variable
NavName. <cfquery name='Recordset3' datasource='triac'> SELECT Category FROM
Navigation WHERE NavID = #URL.NavNum# </cfquery> <cfparam name='NavName'
default=#recordset3.category.navigation.NavID# type='Query'> Thanks so much!
Creasiamedia Guest
-
Query of Queries syntax issue
I have query 1 which has a list of names and query 2 which has ratings for the names. Every rating from query 2 has a name in query 1, but not... -
Query Syntax
HI, Can someone give me a few poitners on the most efficient uses of QUERY.... e.g if there are several query's on one page would it be best to... -
Variable Syntax Query
I'm building a button bank of 6 buttons whereby pressing one button releases the last button activated. Each button is it's own movie clip named... -
Can some help me with the syntax, ADo.net C# dataset query
hi every body i need help i have a dataset called ds, which contains a table called login_table, which contains three columns, namely (login,... -
SQL Syntax Query - sorry
Colin, Working simply with what you gave us (as opposed to what you might be doing in the end). Why not try: desc family Name ... -
Creasiamedia #2 Cfparam query syntax
Can anyone tell me the proper syntax to enter a query into a cfparam variable??
I would like to put the result of the query Recordset3 into the variable
NavName. <cfquery name='Recordset3' datasource='triac'> SELECT Category FROM
Navigation WHERE NavID = #URL.NavNum# </cfquery> <cfparam name='NavName'
default=#recordset3.category.navigation.NavID# type='Query'> Thanks so much!
Creasiamedia Guest
-
tphethean #3 Re: Cfparam query syntax
assuming the following: <cfquery name='qryName' datasource='mydatasource'>
SELECT column1, column2, column3 FROM tablename WHERE column1 = #your criteria#
</cfquery> you want the following syntax: <cfparam name='myparam1'
default='#qryName.column1#'> <cfparam name='myparam2'
default='#qryName.column3#'> etc Hope this helps.
tphethean Guest
-
zoeski80 #4 Re: CFPARAM Query syntax
You can do these to copy the whole query into a variable
<CFSET NavName = recordset3>
<CFSET NavName = Duplicate(recordset3)>
Should just be able to use that in CFPARAM like <cfparam name="NavName"
default="#recordset3#" type="Query"> but have never actually tried it .
Zoe
zoeski80 Guest
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
