densma
|
| Posted: 02/13/2004, 6:58 AM |
|
i created grid from grid and record builder on one page
and i created a search from search builder on another page and return is set to my grid page.
whenever i search it always return all values.. i mean all records
the search doesn't seem to filter.
anyone know wht might be issue here?
|
|
|
 |
densma
|
| Posted: 02/13/2004, 8:43 AM |
|
nevermind....
i think it working..don't know wht happened b/4 but wasn't filtering queries
|
|
|
|
densma
|
| Posted: 02/13/2004, 2:01 PM |
|
i cant figure this out.
i created a search and grid page.
i want to customise my search..
there's a date column in db and i can search.
i want to be able to search date range.. like from jan to feb
from the same column.
how do i go by doing that?
i know i can add a text box and datepick.. name one like date from and another.. date to
how can i get this to work pls
thanks
|
|
|
|
peterr
Posts: 5971
|
| Posted: 02/13/2004, 2:53 PM |
|
This may depend on your date format and the database you're using.
First, make sure that you specify the correct database in your Connection (Server) because MS Access and MS SQL handle dates differently.
Then make sure that your Where Parameters in the Grid are configured to use the correct Type (Date).
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
densma
|
| Posted: 02/17/2004, 6:57 AM |
|
im using sql2000 and smalldate format if that what you asked.
right now i have a search with specific date..
how can i make it search date range.. so that i can have like two
date to select
from and to
and this will pull data b/w the date range.
i don't know how to set this up in CCS.
|
|
|
|
DonB
|
| Posted: 02/17/2004, 2:38 PM |
|
Take the standard search form and add additional fields. The "companion"
form (grid or record control) will have it's datasource defined to include
the search forms fields as "URL" type parameters (they will look like
"s_somename"). You only have to add your new field(s) to the datasource to
make it work. Just follow the pattern you see in the standard form and you
will be fine.
You will want the query to have both "datefield >= s_date1" and datefield <=
s_date2" so that it restricts to the date range between the two values,
where "datefield" is the column in your database and "s_date1" and "s_date2"
are the search parameters
--
DonB
http://www.gotodon.com/ccbth
"densma" <densma@forum.codecharge> wrote in message
news:640322bc6978da@news.codecharge.com...
> im using sql2000 and smalldate format if that what you asked.
> right now i have a search with specific date..
> how can i make it search date range.. so that i can have like two
> date to select
> from and to
> and this will pull data b/w the date range.
> i don't know how to set this up in CCS.
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
densma
|
| Posted: 02/23/2004, 6:30 AM |
|
will be working on this today
i let you know how it goes
thanks
|
|
|
|
cobom
Posts: 55
|
| Posted: 02/24/2004, 9:27 AM |
|
I just reasked your original question - how did you figure it out?
http://forums.codecharge.com/posts.php?post_id=43533
Thanks
_________________
cmckinney@searay.com
Will program for a Sea Ray 680 SS ;} |
|
|
|
densma
|
| Posted: 03/25/2004, 12:10 PM |
|
DonB others i need help with this.
I Have trying to get this working. The main issue was that 'SUBMITEDDate' column is varchar not datetime and data looks like
"01/02/2004 01:12:30" noway i can use where b/w clause. i have successfully created a stored procedure to slove this..l cant convert datatype to datetypes b/c the datasource will not insert into datatime formate. solution is SP
here my SP
CREATE proc daterange
(@begindate datetime, @enddate datetime)
as
SELECT Submitter as RemedyID,
FIRSLAST+', '+LASTFRST as CLIENT,
MGR_FRST+', '+ MGR_LAST AS MANAGER,
Ticket_number
FROM dbo.raw_data, Web.dbo.CNS
WHERE (SUBMITEDDate BETWEEN @begindate AND @enddate) AND Type = 'N/A' AND (ID = Submitter)
...
IF I EXEC SP WORKS
exec daterange @begindate = '3/21/2004', @enddate = '3/22/2004'
go
How can i use CSS with these parameter @begindate, @enddate
using datepicker to exec SP and get results.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 03/25/2004, 8:03 PM |
|
densma,
Please contact our support at http://support.codecharge.com.
Thanks
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
