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

  1. alohaaaron

    Two call routes, one phone?

    Thanks, that works great! Can I also set a distinctive ring pattern in case the receptionist is on a headset away from the desk and needs to identify which line the call is coming in on? I see there is an outside call sequence with different ring types, but there doesn't seem to be any...
  2. alohaaaron

    Two call routes, one phone?

    Hi, I have an IP Office 412 control unit and IP Office Manager 9.0 a) I'd like to have two incoming call routes going to the same extension which would be our receptionist. b) I'd also like to have the receptionist know which number the caller dialed when seen in Soft Console when answering the...
  3. alohaaaron

    DNS Intranet parent suffix issue

    I run nslookup on the internal dns server, set debug, and then type in cointranet and it always responds without errors.
  4. alohaaaron

    DNS Intranet parent suffix issue

    Hi we are having problems with our dns parent suffix taking the place of our intranet dns name. We have an active directory of ad.companyname.com. Our public website is www.companyname.com hosted by a 3rd party hosting site. Our intranet site is at 192.168.0.36 which is an iis virtual ip. An...
  5. alohaaaron

    Fixed header table problem

    Hi, I'm using supertables (an html table with a fixed header) from this site http://www.matts411.com/post/super_tables/ When I use the table with a php file pulling data from a server it works fine. I can scroll up and down and the header stays fixed. The page is refreshed when the table is...
  6. alohaaaron

    XML Expat getting attribute names?

    Resolved
  7. alohaaaron

    XML Expat getting attribute names?

    Hi, I'm able to parse out XML elements and get the values of the attributes but not the names. For example I get ContactPricing and Price and the values 20 and 28 but I can't get the "email" or "phone". $parser=xml_parser_create(); $element_attrs = array(); function...
  8. alohaaaron

    How do I receive an XML file through HTTP?

    Thanks. I have no control over what my vendor has installed on their platform. This includes no curl extension and no PHP 5.x I'll check out the xml_parse_into_struct
  9. alohaaaron

    How do I put an xml parsed file into a database?

    Thanks I think. 1. I don't have control over what my vendor has installed on their platform thus I am stuck with 4.x 2. They don't have the curl extension enabled 3. I am parsing the XML file, that wasn't my question. 4. Using regular expressions is an interesting idea but won't help in...
  10. alohaaaron

    How do I put an xml parsed file into a database?

    Hi, I don't have access to curl or open xml. I'm trying to put data into a database. In the fragment of code below it prints out the xml file correctly. Here is the XML File. $xml_data = "<?xml version=\"1.0\"?><member><Email>abc@home.com me</Email></member>"; How would I insert the email...
  11. alohaaaron

    How do I manipulate file_get_contents data?

    I don't have access to curl since the server I'm using has an old version of PHP
  12. alohaaaron

    How do I receive an XML file through HTTP?

    Thanks. The file xml file is sent by a 3rd party. Now I'm trying to put it into a database. I don't have access to simple xml or open xml. In the code below it prints out the xml file correctly. Here is the XML File. $xml_data = "<?xml version=\"1.0\"?><member><Email>abc@home.com...
  13. alohaaaron

    How do I receive an XML file through HTTP?

    Hi, I have PHP 4.0 so don't have simple XML. I"m trying to use file_get_contents to read in the XML and then read the file till the end using fopen and other file commands. Is this correct or does a file actually exist? Thanks! $xml = file_get_contents ('php://input') or...
  14. alohaaaron

    How do I manipulate file_get_contents data?

    Hi, I'm trying to get the ["HTTP_RAW_POST_DATA"] data after an HTTP POST from of an XML file using the commands below. Can I manipulate this data using $fp=fopen($xml,"r"); or maybe I can't because it's not a file? $xml = file_get_contents ('php://input') or die('file_get_contents...
  15. alohaaaron

    How do I read HTTP posted XML file with PHP?

    Hi, I'm trying to read in an HTTP Posted XML file into my database using PHP. I don't have Simple XML, only Expat and DOM because my host hasn't upgraded to PHP 5 yet. Thanks in advance, Aaron
  16. alohaaaron

    help combine two tables

    This almost works but depending on what I group by in t3 it throws the other values off below?? SELECT * FROM ( SELECT COUNT(DROP_DATE) AS 'Total Units Dropped' FROM inboundtracking d1 RIGHT JOIN marketing_data_nodupe d2 ON d1.DATE BETWEEN d2.DROP_DATE AND (DROP_DATE + INTERVAL 3 MONTH) AND...
  17. alohaaaron

    help combine two tables

    Hi, I have this query. That does a union two combine two tables. But instead of putting the 'closedloans' results next to the 'Total Units Dropped' and 'drop_date' it puts them in the rows below it. How to get them to line up on the same rows? Thanks! SELECT COUNT(DROP_DATE) AS 'Total Units...
  18. alohaaaron

    query returns unwanted duplicates

    Hi, I have two tables a marketing table and checkout_log table joined with a Left join. I want to display all records between the two tables but if there is a duplicate entry it should only display the duplicate entry that is >= curdate() (below there are multiple pk=7 fk=7 entries that indicate...
  19. alohaaaron

    help with sql join

    Hi, I have the query below with the data and query below. I want to select dates from Intable that are with a one month range of the Outtable dates and group them. That works fine But I also want to select values within the data ranges where valuein=valueout. Thanks in advance, Aaron The end...
  20. alohaaaron

    SQL Join + Subquery Problem

    Thanks. That helps a lot. I noticed you use the subquery to get the count of the totals. Instead of putting in a subquery could you have put that in the main outer Select portion query? I'm wondering it would work either way? Also finding the indate between the outdate works great but I also...

Part and Inventory Search

Back
Top