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 derfloh 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: williadn48
  • Content: Threads
  • Order by date
  1. williadn48

    First Records Operator Id Will Not Display

    I have a CR that reads results from a SQL Stored Procedure. When I look at the sp in query analyzer I see the first records as null and then the next set of operator records for Andrewsk99, but when I look at the CR I cannot see AndrewsK99 on the report, all I see is the results of AndrewsK99...
  2. williadn48

    Division Problem

    I need to divide volume by hours to get a productivity total. The number of scanned images (volume) is 8837. The hours for that total is 06:57. When CR does 8837/6:57, it is reporting 21 mins. Its not right. When I do the formula below on a calculator I get a number that is right. Here...
  3. williadn48

    CDate not working

    I am trying to update a field with itself plus another field in SQL Query Analyzer. Update ECMTTConversion set EntryDate = EntryDate + '' + Starttime go EntryDate has only a date in it. StartTime has only a time in it. I need to concatenate them into one field. I keep getting: String or...
  4. williadn48

    Seconds Conversion

    I am a real new newbie to CR. I want to make sure this is an accurate formula. START.... numberVar vol; numberVar secs; numberVar productivity; vol := Sum ({sp_get_Operator_Stats_ByDate_More_Than_One;1.Imgv_Imgs}, {sp_get_Operator_Stats_ByDate_More_Than_One;1.operatorid}); secs := Sum...
  5. williadn48

    Formula Function Call

    Is there a way to reuse one formula on several different fields by way of passing in that present fields data? I have about 20 fields on a report that need the same formula. Do I code it on all fields or can I call a function?
  6. williadn48

    How to Cast or Convert Seconds to Hours

    I exec a stored proc thru a CR. The stored proc returns a field called secondselapsed. How do I convert the secondselapsed to hours and display on the report?
  7. williadn48

    Why does the session variable not persist after a long time

    This code works fine after a few minutes. If I leave the web page up and running for a long time (there is a hidden timer in the background), some of the variables go missing causing an Out of Present Range error. The holdstarttime session variable gets populated with now() when I click a...
  8. williadn48

    Problem with Complex SQL 2k Query

    OK. I am a newbie. I was given this query and must make mods to it to get it to work. There are 2 halves. The first half queries for volume data. The second half queries for time data. Each query half used to read data from the same tables. Now the query needs to read data from a different...
  9. williadn48

    SQL To Loop thru Table and set a calc value on every record

    How do I loop thru a table and set a calculated value on every record? Do While Not EOF Read First Record set intField = DateDiff(Second,Date1Fld,Date2Fld) Next Record Loop Syntax please. Thanks.
  10. williadn48

    DTS Runs fine until the last record

    Why does my SQL DTS run fine and then crap out after the last record?
  11. williadn48

    Invalid Procedure Call Problem

    I am trying to import data from Access to SQL. Since I am a newbie at DTS Activex scripting, I think the syntax is not correct. ERROR: Invalid procedure call or argument: DTSSource on line 2. Function Main() DTSDestination("FStartTime") = Trim(DTSSource("Date")) + " " + Trim(DTSSource("Start...
  12. williadn48

    how to submit and redirect at the same time

    When the user clicks Stop I want to write to the database with a submit AND redirect to a different page. I have tried various combos of code and nothing is working. function fncStop(){ frmTIMETRACKING.hdnAction.value = 'Stop'...
  13. williadn48

    How to Submit and Redirect At the Same Time

    When the user clicks Stop I want to write to the database with a submit AND redirect to a different page. I have tried various combos of code and nothing is working. function fncStop(){ frmTIMETRACKING.hdnAction.value = 'Stop'...
  14. williadn48

    After Form Submit How Do I Enable Buttons

    I have the submit form working ok and I get the form back, but how do I force buttons to enable/disable and gray out fields? I need to write an initial starttime record to the db first and then continue processing or leave the form up on the screen for the user. The user will click stop...
  15. williadn48

    How to pause for validation before continue HELP!

    How do I write the following code in javascript: function DoMultipleActions(){ DoFormChecks(); If DoFormChecks = pass then keep going WriteStartTime(); else DoFormChecks() again end if ChangeBtns_frmFlds1(); StartTimer(); } My current code (below) will not...
  16. williadn48

    My Functions in One Function Are Ignored

    This doesn't work: ...onclick='DoMultipleActions()' function DoMultipleActions(){ WriteStartTime(); ChangeBtns_frmFlds1(); StartTimer(); } Well, the only function that works is the WriteStartTime function. function WriteStartTime() { frmTIMETRACKING.hdnAction.value = 'Start'...

Part and Inventory Search

Back
Top