czajkcr
Posts: 3
|
| Posted: 06/04/2008, 2:35 PM |
|
Hi,
I have created a grid with a sql statement as the datasource. If I go into the visual query builder and click on show data the query is limited correctly, but when I run the query through the web app the grid shows all records. I don't know why it doesn't hold the limits when it is displayed with the web. It's driving me crazy. Here is my SQL statement.
SELECT Time_Intervals.Interval, Time_Intervals.Sort, Time_Intervals.Selected
FROM Time_Intervals
WHERE Time_Intervals.Selected=1
AND Time_Intervals.Interval NOT IN (select Inbound.Time from Inbound where Inbound.Date_Number =#06/09/2008#)
ORDER BY Time_Intervals.Sort
Any help would be greatly appreciated. Thanks.
|
 |
 |
wkempees
Posts: 1679
|
| Posted: 06/04/2008, 3:35 PM |
|
Are you by any chance using MSAccess in DesignMode and MySQL in Server mode?
SELECT Time_Intervals.Interval, Time_Intervals.Sort, Time_Intervals.Selected
FROM Time_Intervals
WHERE Time_Intervals.Selected=1
AND Time_Intervals.Interval NOT IN (select Inbound.Time from Inbound where Inbound.Date_Number = '06/09/2008')
ORDER BY Time_Intervals.Sort
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
czajkcr
Posts: 3
|
| Posted: 06/04/2008, 6:33 PM |
|
My connection in design mode and server mode is both ms access and through odbc.
|
|
|
|
|
