I have looked at this.. there is one small problem

one of the columns is a date so I am not sure how dbtype= query
handles it but the results seem a bit odd

<cfhttp url="" name="info" method="get" textqualifier="">

<cfquery name="qryOrders" dbtype="query">
SELECT *
FROM info
WHERE orderdate < <cfqueryparam cfsqltype="cf_sql_date"
value="#DateFormat(Now(), "dd/mm/yyyy")#">
</cfquery>

On Wed, 25 Aug 2004 06:35:57 -0700, Dick Applebaum <[EMAIL PROTECTED]> wrote:
> Have a look at cfhttp
>
> HTH
>
> Dick
>
> On Aug 25, 2004, at 5:56 AM, Mark Drew wrote:
>
> > Anybody have a UDF for this? I need it sharpish, I can write it myself
> >  but if someone else has done this.. whooho!
> >
> >  Much apreciated
> >
> >  --
> >  Mark Drew
> >  mailto:[EMAIL PROTECTED]
> >  blog:http://cybersonic.blogspot.com/
> >
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to