ASP.NET

13-May-07 19:53

Hi All,
There is a search technique in my page. It search record between two dates. I use Access DB. The problem is that it does not display the record on a date, although record exist on that date, my Query is as following.

Select cust_orders_det.VAT, cust_orders_det.TAX from cust_orders_det, cust_order where cust_orders_det.order_id = cust_order.order_id and cust_order.order_date >=#" & ViewState("startDate") & "# and cust_order.order_date <=#" & ViewState("endDate") & "#"

Pls help me. I can give u access of my page.

Sylvester george13-May-07 20:09

Sylvester george

13-May-07 20:09

Have you included timestamp with the Date ? if not , include the timestamp for from its 00:00:00 for To its 23:59:59

Regards,
Sylvester G
sylvester_g_m@yahoo.com

Khan.Bangash13-May-07 20:17

13-May-07 20:17

Yes I have included but it does not work yet.

GgAben13-May-07 21:55

GgAben

13-May-07 21:55

Hi I think the date field of the DB is date type. And the date in view state may be string type. Please make sure both are date type. If both are string type it will not return correct result, because it is using string sort not the date sort.

Christian Graus13-May-07 23:32

Christian Graus

13-May-07 23:32

Why the hashes in the string ? I've never seen that before.

Are you certain there are dates in those viewstate properties ? What if you run the SQL directly on your access DB ?

and, as someone said, your start date needs a time of 0:00:00 and your end date needs a time of 23:59:59, if it's going to return all records for the days specified, regardless of time.

Khan.Bangash13-May-07 23:55

13-May-07 23:55

How can i give start date 0:00:00 and end date 23:59:59. And that hashes are used for Date in Access. Also my query gives correct result. But gives problem if for example result is of Date 12/12/2007 and I want to search between 11/12/2007 and 13/12/2007.

Hidden Fields

Mkanchha13-May-07 19:07

Mkanchha

13-May-07 19:07

How to Transfer Value from One Page to another Page Using Hidden Fields.

I am using ASP.NET 1.1

Mkanchha

Sherin Iranimose13-May-07 19:18

Sherin Iranimose

13-May-07 19:18

in terms of vb.net
Response.Redirect("MyForm.asp?hiddenvalue=" & HiddenField1.value)

Sherin Iranimose

PSK_13-May-07 19:59

PSK_

13-May-07 19:59

1->If you are using Server.Transfer method then you can get it from Request.Form object by specifying the Hidden field name.

2-> You can user session variable to pass the value, set it before redirecting.

3-> Or you can pass it in query string.

Regards,
Prakash Kalakoti

Mkanchha13-May-07 20:52

Mkanchha

13-May-07 20:52

Thanks for Your Reply. But Still I am not getting the values.

BackendCode--First Form
Hidden1.Value =TxtName.Text
Server.Transfer("abc.aspx")

BackendCode--Second Form
dim Name as string
Name=Request.Form("Hidden1")

Please Tell Me where I made Mistake.

Mkanchha

Sherin Iranimose13-May-07 22:24

Sherin Iranimose

13-May-07 22:24

You should pass the value from first page to another.
In ur code u are not doing that.

Sherin Iranimose

Khan.Bangash13-May-07 20:06