I haven't used QueryNew very often, but I'm going to, so I did some playing
around.
Rawk, if you have input, I'd love to hear it.
Here's an example of what I just did:
<cfset var theQuery = QueryNew("")>
<cfquery name="theQuery" datasource="wsem">
SELECT * FROM carts
</cfquery>
Then I just used cfdump from the calling CFM file and it seems to work just
fine, the problem is that I'm not entirely sure about the scope, does it
change the existing var or destroy and recreate it, thus changing the scope?
On Tuesday, June 24, 2014 4:22:33 PM UTC-5, 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.
