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

    Help with correct SQL syntax using CONVERT?

    In my database I have a birthdate field, type decimal. Example of a record would be 19721003, i.e. 10/03/1972. I am using the following syntax where $whatMonth = '10'. Ulitmately, I want to pull out all the records with a birthday in a specific month, then order them by day: SELECT lastname...
  2. Apollo6

    Sorting results of array a second time before output?

    I have a list of employees with birthdate as one of the fields. This field comes from the database as a string, i.e. 19721003 for 10/03/1972. The initial query pulls all employees. I then have the code working to pull just employees for a specific month. I do this by pulling out the month...
    • Apollo6
    • Thread
    • Replies: 10
    • Forum: PHP
  3. Apollo6

    How to create a single recordset/array from two results?

    I've got two databases, same schema structure, basically company A and company B. I can get the data I want from each individually but need to combine the results of identical queries then echo it out on the page, i.e an employee directory that list employees from both companies but all in one...
    • Apollo6
    • Thread
    • Replies: 14
    • Forum: PHP
  4. Apollo6

    Load variable with multiple values from listbox and use in query.

    MSAccess 2003 I have a form with two listboxes. The user moves items from listbox1 to listbox2(target). I want to move all the items from the target listbox into a variable and use that variable as criteria in a select query. The variable would need to have OR between the values due to the...
  5. Apollo6

    Displaying subreport grp totals on matching main report grp sectio

    Crystal Verson 8.5 Developer I have a main report that has a single grouping, Revenue Center. In this group's footer, I total/display charges. I have a subreport that also has the same layout except is pulls payments and totals/displays in the subreport's group footer. The two reports are...
  6. Apollo6

    How to get the client-side machine name?

    PHP - 4.3.1 Apache - 1.3.33 Server OS - W2003 Clients - W2000 and XP We have a Trouble Ticket application that our users submit tickets with. It sends an email to IT so we can resolve. I have modified the email to include the machine's IP address that the ticket was submitted from. However...
    • Apollo6
    • Thread
    • Replies: 2
    • Forum: PHP
  7. Apollo6

    Using DAO to copy/update a complete record from table?

    I am attempting to get a specific record from a table using DAO. Copy that record into a new dataset, modify that dataset and put back into the table as a new updated record. I am receiving a DataType Mismatch error when I try running through the For Loop when assigning the values to what will...
  8. Apollo6

    How to edit a DAO recordset and insert a new record into table?

    I am wanting to use DAO.RecordSet to pull a specific record. This I am able to do; slice and dice through the data for that record retrieved. What I want to do is modify a few elements(fields) in the recordset and insert the modified recordset back into the same table as a new record. I am...
  9. Apollo6

    Duplicate record with MySQL for a backend?

    I have a converted Access application where I converted the backend to MySQL and kept the frontend(Forms/Queries/etc) in Access. One of my forms has a create duplicate button which in the Access Only version, it created a duplicate record and then refreshed the form with the duplicate record...
  10. Apollo6

    How to display the results of a CrossTab query in a form?

    I have my crosstab working perfect. It contains drugs for row headings, visit dates for column headings, and comments about the drug on the date in the grid. I want to display that on an exist form. The problem I am running into is no matter what object I try to use, subform, listbox, combo...
  11. Apollo6

    Passing text value from Form1 to bound text in Form2?

    I have frmMain with txtPatientNumber. When I click a button, a new form opens to enter drug history. It contains a bound field, txtPatientNumber, as well as other bound fields that the user would enter data. I want it to automatically populate with the current patient number from frmMain to...
  12. Apollo6

    MYSQLDUMP not writing correct sql statement?

    I am dump the database nightly for backup purposes using mysqldump. It generates the file which contains the statements to build several tables and the insert statements to populate. However, there are two Create table statements that have invalid syntax. How can this be if MySQL is the one...
  13. Apollo6

    Question on locking records?

    I am using MSAccess 2000 to run against MySQL 4.0.12. What I need to have happen is when a user pulls up a record and begins updating it, another user on another workstation cannot access that same record. Where do I begin with this? Is it a simple setting in the .ini file or using...
  14. Apollo6

    Hide Duplicate question?

    I have a mileage report that a supervisor signs off on an employee's records for the month. If the same supervisor signs off on say, 10 records, I want to Hide Duplicates. Okay, no problem, set flag to YES. It prints the supervisor's name on the first record and hides it on the rest...
  15. Apollo6

    Disable checkbox depending on dropdown selection?

    I have a checkbox 'roundtrip' that when the page is first loaded, it is enabled. I have a dropdown, 'to_site', that populates with several locations including 'HOME' and 'OTHER'. What I want to happen is that when a user selects either 'HOME' or 'OTHER' from the dropdown, the checkbox is...
  16. Apollo6

    MSAccess FrontEnd/MySQL BackEnd and #Delete?

    Not sure if this should be posted here or in the MySQL forum but I'll try here first to see if anyone has had the same situation. I have converted a MSAccess(2000) database to MySQL. I am using MSAccess forms/queries/reports/modules and linking to the MySQL database via MySQL ODBC (v3.51)...
  17. Apollo6

    How to kill sessions?

    I thought I had a good grasp of sessions until... I have several scripts where I initialize a session and pass user_id, password along to different pages. My problem is that if the user never closes out the browser and a different user logs into the site, it pulls up the previous user's...
    • Apollo6
    • Thread
    • Replies: 4
    • Forum: PHP
  18. Apollo6

    How to insert spaces between two strings?

    I have a first name and middle initial. Both put into seperate variables. I know the length of each string. I have to concatenate them together into a string that is limited to 16 characters with the middle initial being in the last position (16 character). Example: strfirst = "Apollo"...
  19. Apollo6

    Incementing alpha characters in Excel?

    In cell "A1", I have "AAA". I want to populate down column "A" incrementing the original value as follows: A1 = AAA A2 = AAB A3 = AAC Once it reaches "AAZ" the next cell should be "ABA" as follows: A27 = ABA A28 = ABB A29 = ABC And so on... Ultimately, I am looking for an alpha 3-character...
  20. Apollo6

    How to call a script from the onClick event of a textbox?

    I have the following snippet of code which shows a little calendar icon and a textbox on the form. <td width="26" height="24" valign="top"><a href="javascript:show_calendar('form1.datebox');" onMouseOver="window.status='Select a date...';return true;" onMouseOut="window.status='';return...

Part and Inventory Search

Back
Top