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!

Register Log in
  • Congratulations gkittelson 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. dscrugham

    Need to add bookmarks in Excel to PDF file?

    Working with: Excel 2003 Acrobat Distiller 8 Adobe Acrobat 8 Standard What I want to do is automate the creation of the PDF from Excel with bookmarks for each sheet in the workbook with VBA. I have a workbook with 100+ sheets. With the Excel book open, I can click on the 'Convert to Adobe...
  2. dscrugham

    [b]Need correct sql syntax for php script?[/b]

    Mirtheil- Your script does work but only if I hardcode the string value in the sql statement. If I put the variable in, it doesn't populate the table. I have never encountered this situation so I am scratching my head. Still working on it, I'll post back when/if I get it worked out. Thanks...
  3. dscrugham

    [b]Need correct sql syntax for php script?[/b]

    Thanks Mirtheil but when I try that I echo out the following for the $dir_query: SELECT lastname, firstname, ssn FROM soinc.upempl WHERE STATUS <> '3' AND SUPERVSR = 'JOHN SMITH' UNION SELECT lastname, firstname, ssn FROM topllc.upempl WHERE STATUS <> '3' AND SUPERVSR = 'JOHN SMITH' This is...
  4. dscrugham

    [b]Need correct sql syntax for php script?[/b]

    Pervasive 8.6 PHP v4.3.1 Apache v1.3.33 The following syntax works if I hardcode in the string value. However, if I use a variable, I get no results. I've tried using wildcards, i.e. %, both before and after the variable but get the same results. If I replace 'SOME NAME HERE' with...
  5. dscrugham

    When printing batch from AP module, printing hangs up?

    ettienne- Correct on the naming of the connect with Pervasive. These connections are automatically created when I use the Accpac Utility to verify the company database. AntonioPerera- On any of the workstations, including a brand new workstation that has never had Pervasive ODBC software or...
  6. dscrugham

    When printing batch from AP module, printing hangs up?

    Neither the server nor the workstation I'm testing from have antivirus installed... I dumped the database and reloaded, still have the same problem. I also installed a printer on the server, tried printing directly from the server, same problem... Scratching my head...
  7. dscrugham

    When printing batch from AP module, printing hangs up?

    Accpac v5.3A PervasiveSQL 8.6 OS MS Server 2003 CPU 2.4G RAM 2.0G When I attempt to print a batch from the AP module, the printing hangs for approx. 15 minutes. Meaning, I see the small print dialog box popup and it hangs on the screen. The strange thing about this is that once I print the...

Part and Inventory Search

Back
Top