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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tboston

    SQL JOIN Statement on AS400

    Thanks, that worked! You may or maynot have noticed but I was trying to run a Microsoft T-SQL query. Obviously, the syntax is different with ANSI-SQL. Do you have suggestions for reference material? Also when you say that I should run the concatenation when retreiving the data rather than...
  2. tboston

    SQL JOIN Statement on AS400

    I am trying to run the following SQL query on an AS400: update cdbtstd_aa16nt set cdbtstd_aa16nt.aa1qa = (aa1aqa + ' ' + aa1ara + ' ' + aa1asa) from istestlib_psr0104 inner join cdbtstd_aa16nt on cdbtstd_aa16nt.aaefa = istestlib_psr0104.aaefa and cdbtstd_aa16nt.aaama = istestlib_psr0104.aaama...
  3. tboston

    SQL JOIN Statement on AS400

    I'll try that...sorry for the mis-posting.
  4. tboston

    SQL JOIN Statement on AS400

    I am trying to run the following SQL query on an AS400: update cdbtstd_aa16nt set cdbtstd_aa16nt.aa1qa = (aa1aqa + ' ' + aa1ara + ' ' + aa1asa) from istestlib_psr0104 inner join cdbtstd_aa16nt on cdbtstd_aa16nt.aaefa = istestlib_psr0104.aaefa and cdbtstd_aa16nt.aaama = istestlib_psr0104.aaama...
  5. tboston

    FTP Batch file

    I am trying to accomplish basically the same thing. I have this script working by now i am having a problem with the length of the directory in the cd command. Here is the script i am trying to run: open lrs035r1.rr1.stilt.mo.us tboston tb0716 prompt type binary cd...
  6. tboston

    Error VFP or ASP??

    Hey M, Thanks for the suggestions. With your response i looked at all of the things you've mentioned and determined that the problem must be in the registration of the component. When going into the componenet services to view that particular component's methods folder contained within the...
  7. tboston

    Error VFP or ASP??

    I have an asp page that is using com objects creating in Visual Fox Pro. The ASP page is returning the following error: Microsoft Active Server Pages Error '80020009' User-interface operation not allowed at this time /ebatch/confirm.asp, line 65 The line of code that is being referenced is...
  8. tboston

    Trouble with ActivePDF

    do you mean like this? response.write (&quot;<OBJECT id=&quot;&quot;application/pdf&quot;&quot;>&quot;)
  9. tboston

    Retrieving a list of all permissions/shares/ID's in SQL2000

    Does anyone know if there is a quick way to obtain a list of all ID's, permissions, shares, etc that are in an existing database without having to look at each and every one in enterprise manager? TIA
  10. tboston

    Trouble with ActivePDF

    Yes, i believe that is exactly what is happening. Here is what we did in response to previous: if len(request(&quot;x&quot;)) > 0 then response.write x response.end else end if and then submit to the same page: <form name=submitpdf method=post action=create_public_letter.asp> <a href =&quot...
  11. tboston

    Trouble with ActivePDF

    Nope, i'm receiving the same results.
  12. tboston

    Trouble with ActivePDF

    I am using ActivePDF toolkit to generate a pdf document with form fields containing information obtained from a database. The code i have basically comes straight from their product documentation and looks like this: set toolkit = CreateObject(&quot;APToolkit.Object&quot;) r =...

Part and Inventory Search

Back
Top