Untitled Document
Page 3 of 3 FirstFirst 123
Results 21 to 26 of 26

Thread: Setting up SQL ODBC connection string

  1. #21
    Hi I finally got to test an order through ShipRush and found a snag in the writing back the tracking #. I did not see any error logs on this and the tracking is not with the order in GP. Is there any other way to test this?
    FIMS does not let us void orders either so we do not want to get charges lol I am hoping that if it does not ship it does not get charged.

  2. #22

    Join Date
    Apr 2004
    Posts
    17,018
    SYSOPS is offline
    I just reviewed the SQL you have for your update query. It's the same as the query to get order data. That won't work.
    It would need to be of this type of update query: update dbo.Orders set Freight = %SHIPPINGCHARGES% where OrderID = %RecordID%

    You won't be charged for FIMs unless you tender the package.

    HTH,
    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

  3. #23
    I am such an idiot
    Sorry
    Thanks

  4. #24
    Retested with the correct query from Devs but still not working
    Sent your suggestion to them as well

  5. #25

    Join Date
    Apr 2004
    Posts
    17,018
    SYSOPS is offline
    This is the error I'm seeing on this new postback:

    Incorrect syntax near the keyword 'ELSE'.
    Incorrect syntax near '0'.
    Incorrect syntax near '0'.

    HTH,
    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

  6. #26
    Same problem as select with the <> not saving in your system. New query in waiting to test

Tags for this Thread

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
  •