Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Linkan

  1. Linkan

    An exception occurred: 'session(...).Export'

    That is is for the following. ' Do not prompt when exporting Yes there should not be any problems writing to disk, it has been checked.
  2. Linkan

    An exception occurred: 'session(...).Export'

    Hi, I have a web application that has been moved to a new server. The only difference is that is now running on a win 2003 server. I have ms sql 2000 and I am running crystal rep. dev. 8.5. I am generating a pdf file that I am saving on disk but I am also pulling it up to view from the web...
  3. Linkan

    Submit form

    Thanks I will try to do that /Linkan
  4. Linkan

    Submit form

    But they need to be able to come back later in the same session to submit again. /linkan
  5. Linkan

    Submit form

    Hi, How can i prevent my form from beeing submited more then once? I have a DB app and i would like to be able to prevent more then one submit. Thanks, Linkan
  6. Linkan

    My query wont work?

    Hi Terry, I will use that ABS function that is a great idea, thanks for your input. Much cleaner. /Linkan
  7. Linkan

    My query wont work?

    Thanks guys, great work, it works just fine now. The second option is more simple and I had some problems with the group function when I had the temp table. Thanks again! /Linkan
  8. Linkan

    My query wont work?

    I see what you are saying, don't know how I can do it then. I need to sort all my accounts and sum the ammount but when the account type is 2 I need to convert - to + and sum it as well. Thanks for all your help. /Linkan
  9. Linkan

    My query wont work?

    That did not help much. This is the message i get. Server: Msg 512, Level 16, State 1, Line 2 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. /Linkan
  10. Linkan

    My query wont work?

    Thanks for your input but it did not help. /Linkan
  11. Linkan

    My query wont work?

    Hi, I am trying to set up a query that makes a value positive i is is a certain transaction. Trying to set it up in a sproc but I just don't seem to make it work. What am I doing wrong here? Thanks, Linkan DECLARE @lngType int SELECT @lngType = (SELECT lngType FROM vLinkanTestView) IF @lngType...
  12. Linkan

    Nestled query question?

    Thanks Rudy! Great job, it works perfect :) Regards, Linkan
  13. Linkan

    Nestled query question?

    Hi i am trying to make a nestled query to get the total sum of my accounts. My question is how to make a query to handle this? I have two tables. tbAccount lngAccountID strName 1 A1 2 A2 3 A3 4 A4 Now I want to SUM...
  14. Linkan

    Page after report, can I do this?

    Thanks for you help, it got me going :) Good work! Jonas
  15. Linkan

    Page after report, can I do this?

    Hi! The last section where I have data is the Report footer but under this I have a page footer. Thanks. Jonas

Part and Inventory Search

Back
Top