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

    reorganize data

    I have one table, PEOPLE, with names id nameLast nameFirst 000003 Sherwood Hugh 000004 Walter Wolfgang - 01 000005 McFadden Bruce - 01 000006 Power Des another table, TELE_LINK, with phone numbers and emails idPerson idTeleType useAreaCodeFormat numberOrAddress 000003 01 -1 2505463008 000003...
  2. ttuser4

    sql error?

    i have this sql in my vb6 program sSQL = "SELECT [LUMBER].[INV] AS INV_NUMBER, Sum([LUMBER].[VOLUME]) AS _VOLUME, Sum([LUMBER].[TOTAL]) AS _AMOUNT, [LUMBER].[CUST] AS CUSTOMER, LUMBERD.MIL, LUMBERD.COND, LUMBERD.SPEC, LUMBERD.USD, LUMBERD.NOTE From LUMBERD Where...
  3. ttuser4

    proper day format

    i have this query in vb6 program: sSQL = "SELECT Count([WDATE]) From WHOURS Where [EMPID]=" & EMPID & " AND (([WDATE] Between (" & STD & "-31) And (" & STD & "-1)));" debug.print sSQL looks like: SELECT Count([WDATE]) From WHOURS Where [EMPID]=154 AND (([WDATE] Between (7/01/12-31) And...
  4. ttuser4

    count days

    hi, i want to count how many days employees worked within last 30 days (if they qualify for statutory holiday) but my query gives me empty record set: SELECT Query3A.EMPID, Query3A.FULL_NAME, Count(Query3A.WDAYS) AS WDS FROM Query3A WHERE (((Query3A.WDAYS) Between (Now()-30) And Now())) GROUP...
  5. ttuser4

    trouble with apostrophe

    i am exporting data into a text file with this code: sSQL = "Select [EMPID], [WDATE], [WTYPE], [WHRS], [PCODE], [WRATE] From WHOURS WHERE PAYPER=" & rst.Fields(0).Value & ";" Set rs4 = New adodb.Recordset rs4.Open sSQL, objAccessConnection, adOpenKeyset, adLockPessimistic I =...
  6. ttuser4

    time keeping project

    hi, i want to make a simple time keeping project - it would calculate worked hours semi-monthly using the following rules: - first 8 hours Mo-Sa as regular time is less than 40 per week, if over 40 hours Saturday is overtime (if there is a statutary holiday 32 hours a week as regular time) - 9...
  7. ttuser4

    disable/enable items

    hi, i have two selects which i want disable/enable based on selected value of another select: <tr> <td><b>8. Motor:</b> </td> <td> <select size="1" name="motor" id="motor" onChange="calc2(this.form);"> <?php if($md=='lb'){ echo ' <option selected value="0"> </option>'; echo ' <option...
  8. ttuser4

    select event

    hi, i have this code: ... function calc2(form){ if(form.units[0].checked) { var span=parseFloat(form.span.value); var width=parseFloat(form.width.value); } else { var span=(parseFloat(form.span.value)*2.54)*10; var width=(parseFloat(form.width.value)*2.54)*10; } var...
  9. ttuser4

    &amp;action=delete

    hi, i have trouble with this code, where everything works except the '&action=delete', i just cannot find out what is the cause: </table> <?php include('../global/includes/_db_info.php'); if (isset($_GET['id_row']) && (isset($_GET['action']) && ($_GET['action']=='delete'))) {...
  10. ttuser4

    switch pics/hide section

    hi, i have these two functions: function valfrp(chk){ if (chk.checked == 1){ document.getElementById(frp1).style.display = 'none'; document.getElementById(frp1).style.display = 'block'; document.getElementById(frp1).style.display = 'none'; } } function valfrd(chk){ if...
  11. ttuser4

    gdi.dll invalid and user.dll invalid (install)

    i have used vs installer to package my application howerver i receive error : gdi.dll invalid and user.dll (invalid property sourcefile of gdi.dll is invalid ) when trying to build installation package for one vb6 project (http://www.freevbcode.com/ShowCode.asp?ID=1049). any idea what is the...
  12. ttuser4

    string to date

    Hi, I have database with 'timestmp' field varchar(45) containing PHP timestamp (for example - May 19, 2009, 12:58 pm). Is there any way to convert data type from varchar to timestamp without loosing existing data? Or can I run a query like: "SELECT * FROM projects WHERE DATE(TIMESTMP) IN...
  13. ttuser4

    sort/filter displayed data

    Hi, I have this existing code: <div id="body"><!-- InstanceBeginEditable name="body" --> <table width="750"> <tr> <td width="400"><h1>Online Enclosure Quote .beta</h1></td> <td width="*" align="left"> :: My Quotes Form :: v0.3b | 07/29/09</td> </tr> </table> <?php...
    • ttuser4
    • Thread
    • Replies: 5
    • Forum: PHP
  14. ttuser4

    help with insert query

    I tried to make a query which would insert new records into the table 'tblEmployeeTime' - fields 'EmployeeID', 'Date' (specified in query), 'Type'= OUT for all employees from table 'tblEmployees' whose 'Active' value is 'YES' 'tblEmployeeTime' fields: EmployeeID Date Type Hours PhaseCode...
  15. ttuser4

    multi currency/get exchange rate

    hi, i need to allow users to use different currencies (up to ten currencies) to calculate prices for their input. is there any way i can use data from websites like http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml or http://www.oanda.com/convert/classic?lang=en i don't need a link to such...
    • ttuser4
    • Thread
    • Replies: 9
    • Forum: PHP
  16. ttuser4

    populate select based on another select

    hi, i was asked to modify existing code - add two more selects (select02 and select 03) - and populate them based on previous one (subcat3) which populated dynamically from database. can you help me to make it work? here is my existing code: <script type="text/javascript"> function...
  17. ttuser4

    change input value based on selection tag

    I want to change input value based on selection but my code doesn't work. Can you please help me to fix it? <script type="text/javascript" defer="defer"> ... Function Rafter() { var dropdownIndex = document.getElementById('tb').selectedIndex; var dropdownValue =...
  18. ttuser4

    conversion to imperial units (fractions)

    hi, does anybody have a javascript code for conversion from metric to imperial system using fractions (like 51 3/16 etc)? I have one in vb6 one in php but I need one in javascript (i want to convert one desktop application into web).
  19. ttuser4

    sql delete

    hi, i want to delete records from one table (bays_jun18) where there are no associated records in the second table (loadup2). There are three fields - span, type, length - have to match, if they don't match then delete record. Error SQL query: DELETE bays_jun18. * FROM bays_jun18 p LEFT...
  20. ttuser4

    back button issue

    I have an in put form with number of text boxes and select tags and two select tags are populated using ajax. when user clicks submit he/she is redirected to output form with results (javascipt, php, mysql). the problem is with IE (FF works OK) when user clicks back button - he/she is able to...

Part and Inventory Search

Back
Top