|
|
|
как установить значение параметра для msaccess запроса с помощью JDBC?
|
|||
|---|---|---|---|
|
#18+
есть такой запрос с параметром пользуюсь jdbc PARAMETERS [:day_of_week] Short; SELECT t.train_id AS train_id, s.station_name AS station_, DateAdd("n",t.time_,tt.departure_time) AS time_ FROM [select w.train_id, sum(w.time) as time_ from trainroute as w, trainroute as ww where w.train_id = ww.train_id and w.day_of_week = ww.day_of_week and w.route_id <= ww.route_id and ww.station_id=38 and ww.day_of_week = :day_of_week group by w.train_id ]. AS t, timetable AS tt, station AS s WHERE (((t.train_id)=[tt].[train_id]) AND ((s.station_id)=38) AND ((tt.day_of_week)=:day_of_week)); как его запустить? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.03.2004, 11:11 |
|
||
|
|

start [/forum/topic.php?fid=45&msg=32458111&tid=1675791]: |
0ms |
get settings: |
11ms |
get forum list: |
11ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
38ms |
get topic data: |
9ms |
get forum data: |
2ms |
get page messages: |
30ms |
get tp. blocked users: |
1ms |
| others: | 253ms |
| total: | 359ms |

| 0 / 0 |
