Alpha Video Training
Results 1 to 3 of 3

Thread: Preview works, Publish does not

  1. #1
    Member
    Real Name
    Roelof
    Join Date
    Jul 2008
    Location
    Seattle, WA
    Posts
    763

    Default Preview works, Publish does not

    Guys I have a grid with a search box. I search for a var and begin and end date.
    When I preview it works great, when I publish it and search just for the one var it works but if I put in the begin and end date it does not show me any records.
    I have checked permissions and that has no problems.

    I would really like some help with this, the sql var is a datetime.

  2. #2
    "Certified" Alphaholic peteconway's Avatar
    Real Name
    Peter Conway
    Join Date
    Oct 2005
    Location
    Melbourne, Australia
    Posts
    2,551

    Default Re: Preview works, Publish does not

    Dates are an issue when searching, I can't see where you are from. But dd/mm/yyyy mm/dd/yyyy all get processed however by default everything is USA based and how the grid is set up, and your server may have different settings. The safe way to check is is to let the search use use a data picker also remove the ending data to test.

    Also if you go to the last item in the properties panel (grid) you will see advanced, under that you will see date format on server does not match client, chek this box and test.

    It is an issue, have a go - if you get stuck let us know you dd/mm/yyyy or whatever format and I'll see if I can send you the code, but give it a go first.

  3. #3
    Member
    Real Name
    Roelof
    Join Date
    Jul 2008
    Location
    Seattle, WA
    Posts
    763

    Default Re: Preview works, Publish does not

    I am in WA, USA. But the funny part is that when I do a live preview, it works great. It gives me all of the records I need.

    As soon as I publish it stops working.

    On the published site I can select the person that I want the records for. If I do not add a date it gives me all of the correct records. As soon as I enter a date it stops working.

    So why does it work in preview 100% but as soon as I publish and try it it stops working.

Similar Threads

  1. Printing report works locally but on after Publish to a Host server
    By iviowa in forum Application Server Version 9 - Web/Browser Applications
    Replies: 6
    Last Post: 11-08-2008, 06:46 AM
  2. publish error
    By crimmelcp in forum Application Server Version 9 - Web/Browser Applications
    Replies: 1
    Last Post: 08-19-2008, 03:39 PM
  3. URL Calculation Works in Live Preview, Not in Browser
    By iandsdb in forum Application Server Version 8
    Replies: 8
    Last Post: 05-14-2008, 01:51 PM
  4. When I Publish to Server . . . .
    By John G in forum Web Application Server v7
    Replies: 4
    Last Post: 12-07-2007, 04:41 PM
  5. How to publish to another PC in the LAN? (2)
    By Steve Wood in forum Web Application Server v6
    Replies: 5
    Last Post: 09-03-2004, 01:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •