Recent content by crymedry

I think they decided to move over to the MAS 500 system, which will be running on SQL. Hopefully it will be easier to get it to work with that when I can run SQL queries and such to get weight and other information. Thanks for all the help! ~KrisK~

is that something that I need to purchase from sage or does it come with web engine? ~KrisK~

Silly Question .... what is BOI? ~KrisK~

Well that sucks. Do you know if it works well with MAS 500? Thanks for all the help! ~KrisK~

anyone? ~KrisK~

Hello All, Has anyone here had to use the UPS API in conjunction with the MAS 200 webengine for internet users who are placing orders online and need to calculate their shipping rates? If so, what did you find was the best strategy for doing this? Any help or comments would be greatly...

Are you talking about setting your call handling, cause I found that I have an issue with people in work groups or distrobution lists, it will not forward the line. Is there a different setting somewhere that I am not aware of?

Was there ever an answer to this question? I am having a similar issue and can't figure it out. I have just installed a new exchange server 2003 and am migrating from a third party pop provider to a new exchange server. I have setup mx records and everthing looks right. However, I can send...

Is there anyway I can use a response.write statement somewhere to debug this script? Thanks again!

Sorry, that was a typo from me just typing it out and not cut and paste, it is [MASTER]. Do you see any operators or punctuation missing?

K ... fixed the stupid mistakes .... now I have a "Too few parameters. Expected 1." error. Here is what I have: GPA = "SELECT SUM([CLOSE $]) as totclose, SUM([OPEN RES]) as totopen, SUM([ADJ FEE]) as totadj FROM [MASTE] WHERE [OFFICE]='"& location &"'" Thanks again for the help!!

I tried cutting that out, I also tried putting the OFFICE in square brackets, same error. The statement now looks like this: GPA = "SELECT SUM([COSE $]) as totclose, SUM([OPEN RES]) as totopen, SUM([ADJ FEE]) as totadj, FROM [MASTER} WHERE [OFFICE]='"& location &"'" The error that I get is...

Well I tried that and I get the same error. I don't want to group by the office cause I'm trying to get the totals for each specific office. The first page of this they select what office to view, and then this page is supposed to pull all the data together and add all of it up. any more ideas...

OK .... I realized that there is not a FROM statement in there. I have changed it to: GPA = "SELECT SUM([CLOSE $]) as totclose, SUM([OPEN RES]) as totopen, SUM([ADJ FEE]) as totadj FROM MASTER WHERE OFFICE='"& location &"'" Now I get the error that: The SELECT staement includes a reserved...

Ok ... I tried that, and now I am getting a: Syntax error (missing operator) in query expression 'WHERE OFFICE='CB'' the post data is being carried over ... should I do multiple sql statements? Is the fact that the WHERE comes after the SUM statements? Thanks again for the help.