Hi!
I'm having troubles in making a query with 2 dates in SQL Server 2005.
First, my table definition:
db2.define_table('tabla_datos',
Field('na', requires=IS_NOT_EMPTY()),
Field('fecha', 'datetime', requires=[IS_NOT_EMPTY(),
IS_DATETIME(format=T("%d/%m/%Y %H:%M:%S"), error_message='Debe ser
DD-MM-YYYY HH:MM:SS!')]),
Field('ta', db2.tipos_de_asunto),
Field('unidad', requires=IS_NOT_EMPTY()),
Field('operador'),
Field('carta', requires=IS_NOT_EMPTY()),
Field('importe', 'decimal(15,2)', requires=IS_NOT_EMPTY()),
Field('observaciones')
)
In my controller I receive from a form (via ajax) two dates for searching
in the database:
def busca_consulta():
num_asunto = request.post_vars.input_na
desde = request.post_vars.input_desde # User write a date using
the Web2py widget. Format: %d/%m/%Y (time is not necessary)
hasta = request.post_vars.input_al # User write a date
using the Web2py widget. Format: %d/%m%Y (time is not necessary)
rows= db2(((db2.tabla_datos.fecha>=desde) &
(db2.tabla_datos.fecha<=hasta)) & (db2.tabla_datos.na==num_asunto)).select()
but I get error, Is it necessary to convert the variables "desde" and
"hasta" to datetime? How can I convert them?
I've checked the SQL Server datetime format, the datetime is saved in the
records using the following format: %Y-%d-%m %H:%M:%S. I live in Mexico,
the format we use is: %d/%m/%Y %H:%M:%S
My english is not very good, I hope you can understand me.
Regards.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
