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 Mike Lewis 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: thep1
  • Order by date
  1. thep1

    fetch data in wordpress page resulting in page not found

    thanks feherke
  2. thep1

    fetch data in wordpress page resulting in page not found

    thanks for that advise feherke. pretty scary stuff. now my question is what should be the approach i should take to accomplish this? i am not too familiar with php and MySQL stuff. is there some example you or someone can provide?
  3. thep1

    fetch data in wordpress page resulting in page not found

    found the solution. had to change the Permalinks to "Post name" and changed the code for these 2 lines <form method="get"> $results = $wpdb->get_results( "SELECT * FROM wp_ilabs_reportsearch where reportnumber= $_GET[FetchReport] " );
  4. thep1

    fetch data in wordpress page resulting in page not found

    hello, I created a template page in wordpress and want to get data from MySQL db table. when I pass the parameter in the search box I get Page NOT Found error. here is the code in my template page <?php /*Template Name: ReportSearch-5 */ get_header(); ?> <?php do_action(...
  5. thep1

    Create view to see if matching does not exist

    Thanks guys, I tried the one gmmastros suggested and got the result I was looking for.
  6. thep1

    Create view to see if matching does not exist

    I am trying to create a view that will look in 2 tables and if records are not in the other table then it will show those records. SELECT dbo.AspNetUsers.Id, dbo.AspNetUsers.Email, dbo.AspNetUsers.UserName FROM dbo.AspNetUsers INNER JOIN...
  7. thep1

    dynamic pivot data to display in gridview

    never mind got it to work. removed the 2 selects and now the data I want is displayed. SELECT @PivotColumns SELECT @SQLQuery
  8. thep1

    dynamic pivot data to display in gridview

    i have a stored procedure that i would like to have its data displayed in gridview but when i call he stored procedure its only showing me the header row only. here is the stored procedure --Declare necessary variables DECLARE @SQLQuery AS NVARCHAR(MAX) DECLARE @PivotColumns AS...
  9. thep1

    2 table rows data in single row (master row &amp; child rows)

    thanks gmmastros, I searched for it and came up with article that I was exactly looking for. Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server I used the dynamic Pivot method and was able to get the data display and create the stored procedure, but now I need to...
  10. thep1

    2 table rows data in single row (master row &amp; child rows)

    I am not sure how to do this but I have 2 tables Items and Itemdetails and I am looking to get the info in one row from both tables Items table ItemID Name ------ ---------- 80015 CLS SB 90001 Int Line 90586 Deep B44 Itemdetails table RefID Location QTY ------ --------- --- 80015 CA...
  11. thep1

    Forwarding calls to someone without a physical phone setup

    got it working. was telling internal user to call extension and didn't have Forward Internal Calls checked. Uhhh.. thanks all for your help.
  12. thep1

    Forwarding calls to someone without a physical phone setup

    malibu1979, I have analog trunk ports for this system. jmack23, going to try your suggestion with the Allow Analog Trunk to Trunk Connect that I currently see unchecked (disabled) so going to enable it when I can reboot the system. TouchToneTommy, that's what I have currently setup as a...
  13. thep1

    how to formate date in to mm/dd/yyyy

    Thanks Andrzejek… that works.
  14. thep1

    how to formate date in to mm/dd/yyyy

    I have field in DB that stores date in this format: 2018-07-02-00.00.00.000000 I would like have it format to 07/02/2018 tried this Exper1: Format([F7],"mm/dd/yyyy") but still shows in the above format.
  15. thep1

    incoming analog line appreance on one of the phone button

    I would like to know how or if I can program a button for an incoming analog(pots) phone number line in to Avaya phone. what I am trying to do is I have a one phone number (ex. 222-3333) connected to analog trunk port # (4) when someone calls that number I want it to light up in 5th button on...
  16. thep1

    Forwarding calls to someone without a physical phone setup

    thanks for clarifying that Pepp77. but when I dial that extension I get busy tone, soon as I dial extension on the phone i get Call: NUMBER BUSY
  17. thep1

    Forwarding calls to someone without a physical phone setup

    On one of my IP Office v9.1 I have user setup without a physical phone but want to do Forwarding to his mobile number when the extension is dialed. Do I need a license for this feature?
  18. thep1

    Avaya ipoffice vm pro message enable/disable from button on 9608 phone

    Hello, is there a way to turn on/off vm pro greeting from phone button. basically trying to get a button programed on reception phone to record and activate "not in office/emergy closed, ect" by a user which will play before auto attendent if its enable. this is for ip office 500v2 9.1.
  19. thep1

    cisco 1841 configur to allow only some ip or application in 2 lan

    Thanks for the info VinceWhirlwind as i figured its not possible. so in this case lets say i have PC on 192.168.17.30 and i only want that pc to communicate with a server on 10.10.255.10 what would i have to do? would i handle this using access list? and static routing?
  20. thep1

    cisco 1841 configur to allow only some ip or application in 2 lan

    Hi, I have a cisco 1841 with 2 FE ports I am going to connect it to 2 separate LAN's. Lan1 192.168.17.x Lan2 10.10.255.x not sure if this is possible but I want to allow only some type of files to be transmitted from Lan1 pc's to Lan2 server (ex .mov) is this something I can do on cisco...

Part and Inventory Search

Back
Top