blackhat
Posts: 3
|
Posted: 02/23/2007, 6:17 AM |
|
Hi there,
I need to convert one text field in date field.
I use the builder interface in order to create an ASP application. On step 6 I choose some of the fields like ListBox. One field is a text field but contain a date. I know is my database design but I can't modify the database.
The solution is to convert this text field in date format.
Basic I need to display some records if they are between the first date and second date.
I can't receive the correct number of records because the foieds are text fields.
Question: There is a way to write custom SQL queries ?
I need to build the SQL query like this
Select * from table where CAST(textfiled AS DATETIME) >= '2/21/2007' and
CAST(textfield AS DATETIME) <= '2/22/2007'
In the Visual Query builder, in the where clause I can't do that because I got an error like the operation is not allowed when the object is closed in classes.asp
Has anybody some ideeas?
Is very important. Thanks for your answers and... for the patience to read all that!
_________________
Johnny be good! |
|
|
wkempees
Posts: 1679
|
Posted: 02/23/2007, 7:37 AM |
|
This thread locked, continued here http://forums.codecharge.com/posts.php?post_id=85094
_________________
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
|
|
|
|