Is there an advantage to either method?
On Tue, Jun 24, 2014 at 4:58 PM, Rawk <[email protected]> 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]. > 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.
