gummio
Posts: 11
|
Posted: 04/16/2004, 2:57 AM |
|
Hi,
I have a SQL DataType and in SQL DataSource i have this SQL:
select b.Id_bill, b.bilnumer, (select Min(KmStada) from Bilar_Kilometrastada where Bill_ID = b.Id_bill and DagsStada between '{Fra1}' and '{Til1}') as MinKm,
(select Max(KmStada) from Bilar_Kilometrastada where Bill_ID = b.Id_bill
and DagsStada between '{Fra2}' and '{Til2}') as Maxkm
from Bilar_Listi b where b.Afskradur = 0
Order by b.Bilnumer
When i review the data in Data Source Window then i see all the data but when i run the page i get this error:
Wrong date value (0x800A0420)
'Default' can be specified only on 'Property' or 'Function' or 'Sub'
/Bilakerfi/Common.asp, line 1179
|
|
|
gummio
Posts: 11
|
Posted: 04/16/2004, 2:58 AM |
|
The field Fra1, Fra2, Til1, Til2 are Dates
|
|
|
peterr
Posts: 5971
|
Posted: 04/16/2004, 11:05 AM |
|
You may need to debug your SQL at run-time and see if it works with the parameters you used.
Please refer to http://docs.codecharge.com/studio/html/ProgrammingTechn...yingOutput.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|