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 Chriss Miller 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: *

  • Users: foxbox
  • Content: Threads
  • Order by date
  1. foxbox

    Printing PDF (over WAN) results in huge files

    Our users work on a central MS Terminal Server system. They open relative small PDF files on the TS. But printing such a file results in a huge data transfer over the WAN to the local printer. Is it possible to prevent this? We used to have Canon multi functional printers (with this problem)...
  2. foxbox

    Move table/records to another database

    I have a table with 100.000.000 records, where 'only' 25.000.000 are needed. I don't want to delete those 75.000.000 records, i want them removed from my production environment database into an 'archive-database'. Every quarter or so i will move reocrds from production to archive. So i only need...
  3. foxbox

    My update does not fire a trigger

    I created a simple ON Update trigger on MyTable. When i open MyTable and change a field, the trigger works fine (basically it is make a copy of the altered row in another table). But when i do an UPDATE MyTable SET ... the trigger is NOT working. In some situations that may be good behavior, but...
  4. foxbox

    Excel: Disable/ change special format

    i give an Excel cell a custom format 0000. After clicking OK, i do again "Format cell..." Now it is set to "Special" Codigo Portugal! Oke, the effect is the same, but it looks strange. Is it possible to edit the special formats? or better: disable them?
  5. foxbox

    Create appoitment with MS-SQL trigger

    I'm trying to create MS Exchange appointment via a trigger. The following ASP code is working A-oke: strApptURL = "http://" & strExchSvrName & "/exchange/test/Calendar/testappointment.eml" strApptRequest = "<?xml version=""1.0""?>" & _ "<g:propertyupdate " & strXMLNSInfo & _...
  6. foxbox

    sp_OAMethod send

    I'm trying to create MS Exchange appointment via a trigger. The following ASP code is working A-oke: strApptURL = "http://" & strExchSvrName & "/exchange/test/Calendar/testappointment.eml" strApptRequest = "<?xml version=""1.0""?>" & _ "<g:propertyupdate " & strXMLNSInfo & _...
  7. foxbox

    Connect to SQLCE

    I want to fill a MS SQL Mobile (SDF) database with records from a DBF file. So i hoped this is working: oConnSDF=Createobject("ADODB.Connection") oConnSDF.open("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=myfile.sdf;") USE SOURCE DO WHILE NOT EOF() cSQL = "INSERT INTO...
  8. foxbox

    Uniqueidentifier

    I need to INSERT records in a MS SQL 2005 table with an uniqueidentifier field.Is it possible to create the full SQL statement in the VFP program? Or should i write a SP in the database that accepts the values from my program and uses the NEWID() function? Other ideas?
  9. foxbox

    Start Job with SP fails

    With MSSQL2K i started DTS jobs via a stored procedure. SP's i could start from ASP webpages, and all went very well. The first clash with SQL 2005 was the move from DTS to SSIS. I have now DTSX structured files, and my current approach is to run these with a Job (Type=SSIS package, source file...
  10. foxbox

    SQL Server monitoring tools(s)

    At the moment i have 3 SQL servers in HQ: MS Business Solutions Axapta, Business Objects and Intranet + supporting web-apps. Later this year we will migrate our DOS (!) logistic system to something running on MS SQL. So we will install a SQL server on every plant/location (15). There is no ICT...
  11. foxbox

    Multiple SELECTS with the same data

    I have a form with 5 different fields that require the user to enter a valid name-code. [The valid codes are stored in a SQL database (about 150)]. I do not want to build 5 <SELECT>'s with 5x150 <OPTION> lists. Of course it is possible to enter 5 codes first, and do the validation after...
  12. foxbox

    Use OPTION description

    <select name=field> <option value=1>Apple <option value=2>Banana <option value=3>Ananas </select> in a script i can use document.form.field.value in order to get the selected value (eg 1). But how can i get the selected DESCRIPTION (eg Apple). . . After selecting a value i want another field...
  13. foxbox

    Check object name existence

    My ASP program creates a random number of INPUT fields (i do not know the number in advance). The fields have a sequential name, like &quot;F1&quot;, &quot;F2&quot;, &quot;F3&quot;, etc. After SUBMIT every field with a value must be processed. So my program must check document.form.f1.value up...
  14. foxbox

    Bypass F5/refresh message

    After pressing F5 (Refresh) IE is presenting me the question 'The page cannot be refreshed without resending the information....' I have to press the Retry-button (or Enter) in order to get my refreshed page. I always want to refresh. How can i bypass this question? (I do not look for an...
  15. foxbox

    F5/refresh without confirmation

    After pressing F5 (Refresh) IE is presenting me the question 'The page cannot be refreshed without resending the information....' I have to press the Retry-button (or Enter) in order to get mu refresh. I always want to refresh. How can i bypass this question? (I do not look for an automatical...
  16. foxbox

    How to pass a parameter with plus sign

    In A.ASP i show the user a list of records from a MS-SQL7 database TY. The user may select 1 record for update. This is done in program B.ASP TY has one primary key field: tycode. Examples of codes are: 1x, 2x, 2-, 2+, 4x, 4-, 4+, etc. When a user clicks on a link like this: <a...

Part and Inventory Search

Back
Top