Nothing major really. Initializing with an empty string will probably use slightly less memory. Also, if initialize as an empty string and you had some logic that made it so your cfquery was only conditionally executed, you could later use the IsQuery() function to determine if the cfquery was ever executed.
On Tuesday, June 24, 2014 5:59:27 PM UTC-4, Jason Allen wrote: > > Is there an advantage to either method? > > > On Tue, Jun 24, 2014 at 4:58 PM, Rawk <[email protected] <javascript:>> > wrote: > >> Sorry, I meant to say <cfset var redirectLookup = QueryNew("")> >> >> Alternatively, you can simply initialize it as an empty string and when >> you perform the query it will convert the variable to a query data type. >> >> <cfset var redirectLookup = ""> >> >> >> >> On Tuesday, June 24, 2014 5:22:33 PM UTC-4, Jason Allen wrote: >>> >>> <cfset var redirectLookup = QueryNew()> >>> >>> I'm getting an error with that line of code. >>> >>> It tells me I need arguments. >>> >>> The query in the example is the following >>> >>> SELECT redirectURL, redirectID, redirectStatus >>> FROM tbl_redirects >>> WHERE (redirectDomain = <cfqueryparam value="#arguments.domain#">) >>> and (redirectSubFolder = <cfqueryparam value="#arguments.subFolder#">) >>> >>> >>> So where I'm confused is whether or not an empty QueryNew() function >>> should be enough. Or do I need to expand it aka queryNew('redirectURL, >>> redirectID, redirectStatus', 'varchar, int, smallint') >>> >>> <cfset var redirectLookup = QueryNew()> >>> >>> <cfset var redirectLookup = QueryNew('redirectURL, redirectID, >>> redirectStatus', 'varchar, int, smallint')> >>> >>> >>> -- >> -- >> online documentation: http://openbd.org/manual/ >> http://groups.google.com/group/openbd?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "Open BlueDragon" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
