Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 4 of 4

Thread: Searching Forums

  1. 12-12-2011, 08:29 AM #1
    scott_rider is offline Junior Member
    Join Date
    Sep 2011
    Posts
    9

    Default Searching Forums

    A forum search for SQL fails to return anything.
  2. 12-12-2011, 09:36 AM #2
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    Try this one.



    TTFN

    BFG
    Blog - Random Blurb from BFG 9000
    Twitter - @BFG9000
  3. 12-12-2011, 10:35 AM #3
    scott_rider is offline Junior Member
    Join Date
    Sep 2011
    Posts
    9

    Default

    Thanks! I ran into a problem executing:

    <Query Name="Query493" RowName="row"><SQL>select OrderNumber from Orders where TransactionState='CAPTURED' and CapturedOn IS NOT NULL</SQL></Query>

    It threw the error "Exception=Incorrect syntax near '<'. Incorrect syntax near '<'." I saw that there is a 128 character limit so I shortened the supplied example but it didn't run. Is there anything wrong with the statement above?
  4. 12-13-2011, 01:20 AM #4
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    Obviously there's nothing wrong with the SQL itself, so the error must be generated from the package you're trying to run it in. Can we see more? Especailly since you say:

    I saw that there is a 128 character limit so I shortened the supplied example but it didn't run.
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!