Welcome Guest Search | Active Topics | Members | Log In | Register

Parameter on SQL query WHERE clause Options · View
HaugachakaMan
Posted: Wednesday, June 20, 2012 1:44:40 AM
Rank: Newbie Coder
Groups: Member

Joined: 5/31/2012
Posts: 7
Points: 18
Location: Portugal - Lisbon
Hello

I'm trying to retrive data from the SQL filtering data. In a query it whould be something like this:
SELECT * FROM tale WHERE system = 'system' AND (time <= '2012-01-01 00:00:00' AND time >= '2012-02-01 00:00:00')

Currently I'm retriving the data like:
var adData:ArrayCollection = new ArrayCollection();
acData = ActiveRecords.table.findBySystem(system);

In this process I can't seen to put the clause in bold.
Does any one have any ideias on how to do this?

Thanks in advance, best regards
João Pedro de Almeida
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

YAFVision Theme Created by Jaben Cargman (Tiny Gecko)
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.
This page was generated in 0.075 seconds.