|
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.
|
|
|
|
|
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
|
|
|
|
|
Yes I have included but it does not work yet.
|
|
|
|
|
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.
Gg
|
|
|
|
|
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.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
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.
|
|
|
|
|
How to Transfer Value from One Page to another Page Using Hidden Fields.
I am using ASP.NET 1.1
Mkanchha
|
|
|
|
|
in terms of vb.net
Response.Redirect("MyForm.asp?hiddenvalue=" & HiddenField1.value)
Sherin Iranimose
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
You should pass the value from first page to another.
In ur code u are not doing that.
Sherin Iranimose
|
|
|
|
|
Use the following example.
<form id="frmworld" name ="frmworld" method=POST action = "https://select.worldpay.com/wcc/purchase" >
<input type="hidden" name="instId" id="instId" value="4343" runat="server">
<input type=hidden name="cartId" id ="cartId" value="4343" runat=server />
</form>
|
|
|
|
|
Hi,
I need to implement daemon functionality(which is available in java) in asp.net. Please let me know if anyone has any idea about it.
|
|
|
|
|
Go with
1. Standardized configuration.
2. Extensible metadata
3. Assemblies
4. .Net Remoting
Regards,
Satips.
|
|
|
|
|
Hello
How to implement URL Rewriting in ASP.NET 2.0 ? To be more specific, I need to implement URL Rewriting. I have done the same in VS2003. But when I did a conversion to VS2005, it's not working. I am facing problem to add the reference in web.config. Because ASP.NET 2.0 is not creating any assemblies. So how can I specify the HTTP module reference in ASP.NET 2.0 web.config  ???
|
|
|
|
|
can anyone help ... wht's the problem on get this error message when im trying to send email through my website?
System.Web.HttpException: Could not access 'CDO.Message' object. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException (0x80040213): The transport failed to connect to the server. --- End of inner exception stack trace --- at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters) at System.RuntimeType.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParameters) at System.Web.Mail.LateBoundAccessHelper.CallMethod(Object obj, String methodName, Object[] args) --- End of inner exception stack trace --- at System.Web.Mail.LateBoundAccessHelper.CallMethod(Object obj, String methodName, Object[] args) at System.Web.Mail.CdoSysHelper.Send(MailMessage message) at System.Web.Mail.SmtpMail.Send(MailMessage message) at WebStore.WebCustomControl1.sendMail(String fromEmail, String CompanyName, String CustName, String toEmail, String toEmailSubject, String toEmailMsg, String toEmailPassword)
|
|
|
|
|
This is usually permissions or a corruption/not-installed problem.
To check permissions, here are a few suggestions to try. While trying these suggestions, you may want to try the most liberal settings, until it works, and then tighten the settings down to make sure your server is secure.
Regards,
Satips.
|
|
|
|
|
Satips, thks for your reply.
This is usually permissions or a corruption/not-installed problem??
can u guide me more details??
the email sending is working properly when i try to send out in my local pc. but after uploading to hosting site. i get the error message that i post just now. Is it the coding problem or something tht the configuration or setting need on the hosting site??
|
|
|
|
|
If you are using "localhost" for the SmtpMail.SmtpServer property , you may want to try the following:
Open up IIS Admin. Locate the SMTP Server, and right-click select Properties. On the Security tab, add the ASPNET account as an Operator. Close the dialoag, and stop/start the SMTP Service. If this works, I don't know how to tell you to fix this problem. Sorry. However, I consider this a security breach, and would recommend you purchase a 3rd party product, and not use System.Web.Mail. Evidently there is something funky with your machine.
And Make sure all the settings are done and check it for the mail in the hosting service too.
Regards,
Satips.
|
|
|
|
|
When I run my program written by C# ASP.NET 2.0 first time then my logo disappear and then there is error is: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding , I have to click back button and re-login then the logo appear and the error disappear
In conclusion the error happen when I run my program in first time, How can I do to fix these bugs,
Thanks alot and best regard !
|
|
|
|
|
That means your program is taking too much time to execute the page. Anyway after deployment, when we call the page it will compile then serve the page. Try using precompiled website before deploying.
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
it seems to me that ur application taking more than 90sec...(In our .net environment no application is allowed to exicute more than 90 sec) if we want to allowe our application to be exicuted more than that period let's do this ----in the machine.config file there is an element called httpRuntime with in that there is one attribute executionTimeout=90 there u can prolong (i.e make it like 120 0r...)such that server won't send this kind of error provided ur appliation must exicuted before the mentioned time
|
|
|
|
|
I can't find machine.config, there is only web.config file, in this file I also can't find element called <b>httpRuntime</b>???
Can i solve this problem if I increase the <b>Connect Timeout</b> more (i.e like 60 or 90)
<add name="ASPNETDBConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="F:\Final Project\TestOnlineSystem\App_Data\ASPNETDB.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient"/>
<b>Thanks and best regart !</b> 
|
|
|
|
|
Here u can go to find the machine.config file--C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\CONFIG\Machine...observe carefullly u will find the element which is mentioned there...!
httpRuntime executionTimeout="90" maxRequestLength="4096" useFullyQualifiedRedirectUrl="false" minFreeThreads="8" minLocalRequestFreeThreads="4" appRequestQueueLimit="100"
regards---yuva
|
|
|
|
|
- I am Using VS 2005 so that I can't found path: C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\CONFIG\Machine.config, I only found path: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\Machine.config
- In this file I am only found so that it doesn't have properties as you said
- How can I do now, please help me
Thanks and best regard ! 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
