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.
