Article View: borland.public.vdbase.data.sql
Article #1138Re: date params
From: Tom Gleaton
Date: Fri, 17 Apr 1998 00:00
Date: Fri, 17 Apr 1998 00:00
18 lines
918 bytes
918 bytes
> Warrick Clarke wrote
> 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
q. params["cduedate"]= {01/01/1996} // Curly Brace around date
Or
q. params["cduedate"]= form.entryfield1.value
Tom Gleaton
County of Riverside, Riverside California
Technical Details
Message-ID:
<01bd6a18$9ebd3000$4d4c96d1@dict2>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<3536C482.94692E89@latrobe.edu.au>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,850e1b4212413335 X-Google-Attributes: gidff5a1,public From: "Tom Gleaton" <tgleaton@linkline.com> Subject: Re: date params Date: 1998/04/17 Message-ID: <01bd6a18$9ebd3000$4d4c96d1@dict2> X-Deja-AN: 345059854 References: <3536C482.94692E89@latrobe.edu.au> Organization: Another Netscape Collabra Server User Newsgroups: borland.public.vdbase.data.sql