Information générale
Titre:
Selecting dates in a Web form
HI.
I have a main form which stores two dates to session variables.(A from and to date)
(I convert them to strings as I was having difficulty just storing the dates as session variables)
When I use them in the called form, I invariably get a SQL exception error in my sql statement saying theres an error in converting date to strings..
Is there a 'correct way' to do this as most things I have tried with dates have taken hours of experimenting and seldom work.
A few specisic questions:
1. Can I strore a date in a session variable
2. How do I include these in a sql select
as in Select * from MyTable where DateFld >= sesFromDate and DateFld <= sesToDate
Any help appreciated.
Regards,
Gerard
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement