Thread: Selecting between two dates

Hi

We have a config.exe file that pulls information out from a SQL table and extracts it into a csv file.

Basically each time you run this file it will extract all web orders from the previous extract.

Our server crashed yesterday and we want to amend this config file to extract orders from a specific time. Does anyone know the correct code to do this? Were currently manually adding over 800 orders.

Tried WSI but had no joy. It's just the date stamp that I need to add to this config.exe file.

Thanks

Dean

Did you try adding to the WHERE clause where OrderDate > '10/13/2009 9:23:00 AM' for example?

Ok so in WSI I am using the following

<AspDotNetStorefrontImport Verbose="false">
<Get Table="Orders" Name="NewOrders">
OrderDate > '11/02/2009 9:23:00 AM'
<XmlPackage>DumpOrder.xml.config</XmlPackage>
<OrderBy>OrderDate asc</OrderBy>
<Criteria IsNew="1"/>
</Get>
</AspDotNetStorefrontImport>

But always get the following error

Request timed out.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Request timed out.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[HttpException (0x80004005): Request timed out.]

Any ideas where I am going wrong?

Code:

OrderDate > '11/02/2009 9:23:00 AM'

should be

Code:

<OrderDate>11/02/2009 9:23:00 AM</OrderDate>

Thanks. I did notice that error after I posted. Still getting the same Timed Out message though.

Will keep continuing.