date params

Article View: borland.public.vdbase.data.sql

Article #1137

Back to borland.public.vdbase.data.sql Previous Next

#1137

From: Warrick Clarke
Date: Fri, 17 Apr 1998 00:00

19 lines
918 bytes

I am have trouble trying to assign values to date params. I can't
intialize the param variable.
eg.
.
 q = new QUERY()
 q. sql = 'select * from "tracking.dbf" where stdydate < :cduedate'
 q. params["cduedate"]= '01/01/1996'        //?????
 q. active = true

.
i'd like to check for overdue entries, something like this eventually

form.query1.params["cduedate"] = dtoc(date() -30)
form.query1.requery()


Thanks
Warrick

Technical Details

Message-ID: <3536C482.94692E89@latrobe.edu.au>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,850e1b4212413335,start
X-Google-Attributes: gidff5a1,public
From: Warrick Clarke <w.clarke@latrobe.edu.au>
Subject: date params
Date: 1998/04/17
Message-ID: <3536C482.94692E89@latrobe.edu.au>
X-Deja-AN: 344871664
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql