hey Greg,
Couple ways to do it:
a) you could talk directly to the CODB
<cfquery name="qGetObjects" datasource="#request.cfa.objectstore.dsn#">
SELECT objectid, label
FROM objects
WHERE typeid = '#theTypeIDYouWantToSearch#' AND
datetimecreated (or datetimeModified) Is greater than (or is less than)
(or is equal to) #createODBCDateTime(now())#
</cfquery>
or
b) <cfa_contentobjectfind
datasource="#request.cfa.objectstore.dsn#"
typeid="#sometypeid#"
dtcreatedafter="#somedate#"
dtcreatedbefore="#somedate#"
dtupdatedafter="#somedate#"
dtupdatedbefore="#somedate#"
r_stobjects="r_stObjects">
HTH
Aaron Johnson, MCSE, MCP+I
Macromedia Certified ColdFusion Developer
MINDSEYE, Inc.
<phn>617.350.0339
<mbl>617.461.3721
<fax>617.350.8884
<icq>66172567
[EMAIL PROTECTED]
> -----Original Message-----
> From: Greg Lee [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 11, 2001 9:20 AM
> To: Spectra-Talk
> Subject: Help with result sets
>
>
> Hi all, I am a spectra newbie and this is what I am trying to do:
> I want to be able to search a certain type and return all objects based
> within a date range.
>
> I do not want to search properties within multiple types, just a single
> type.
>
> What is the best way to do this?
> Thanks,
>
> Greg Lee
> Senior Consultant
> divine, Inc.
> 216-525-2090
> [EMAIL PROTECTED]
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
