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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by don2241

  1. don2241

    soap segmentation fault using wsdl file in PHP

    Hi, I have a simple test snippet below. When I run this in PHP 5.1.6 I get a Segmentation Fault error but when I run the exact same code in PHP 5.3.3 everything works fine. The error appears to happen on this line: $obj = $soap->retrievePrice($arr); If I do not want to upgrade the PHP...
    • don2241
    • Thread
    • Replies: 0
    • Forum: PHP
  2. don2241

    Calling a script from a stored procedure

    Hi, I was wondering if it is possible to call a script using a mysqli stored procedure similar to how you call a php script from a Linux command line like: php somescript.php Something like: CREATE PROCEDURE myproce BEGIN exec php somescript.php; END If not possible is there any other...
  3. don2241

    Problem with FreeTDS driver

    I recently updated our current FreeTDS to FreeTDS version 8.0 but existing PHP programs that is reading data from SQL Server 2000 database suddenly stopped working. The problem I found was in the SELECT statements for queries. For example consider this SQL: select a.id as first_id, b.id as...
  4. don2241

    Mysql trigger using parameters

    Don't worry about it ingresman, with monologs the information does not always come across the way you intended. Anyhow, I found out the problem. A simple one, it always is, you cannot use declare syntax in mysql triggers. /M
  5. don2241

    Mysql trigger using parameters

    Yes of course I tried, I would not be posting here if I did not. The error msg I get is: ********************** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@user integer; declare @id integer; at line 4...
  6. don2241

    Inner Join Problem

    Try to give your select colum a name $query = "SELECT DISTINCT program.program_name as name FROM program INNER JOIN schedule ON program.id = schedule.pid "; and then while ($row = mysql_fetch_assoc($result)); { echo $row['name']; }
  7. don2241

    Mysql trigger using parameters

    Hi Is it possible to use a trigger on a table to update a different table using parameters? TableA user | id | data | duration 10 1 aaa 200 TableB user | id | totDuration 10 1 null What I am trying to do is to have a trigger on TableA when an UPDATE takes place to update...
  8. don2241

    TD width IE problem

    I cannot be bothered trying to fix it. I just put a new table inside the <td> and that works fine. Do not need form tags for testing purpose and sample code for this post.
  9. don2241

    TD width IE problem

    IE6 and greater (IE7), the center tag is irrelevant can be removed and still have the same outcome. I have a table(s) which are dynamically build with data from a database. The second <tr> and the following <tr>'s will always consist of two <td>'s where the first <td> always going to be radio...
  10. don2241

    TD width IE problem

    Hi If I run this piece of code in Firefox it looks the way I want. How do I achieve the same result in Microsoft IE? I am referring to the width inside the <td> tags. Thank you <html> <center> <table border="1"> <tr><td colspan="2">test radio with some garbage text just for...
  11. don2241

    uniqueidentifier linking with subselect

    Hi Sorry I missed another join select x.id, x.cid, c.id from Customer c left outer join( select id, con.contactID as cid from Customer c join Contact con on con.custID=c.id group by c.id, con.custID )x on x.id=c.id Since my sub-select might return duplicates of the id column the x.id and...
  12. don2241

    uniqueidentifier linking with subselect

    Hi Is there a trick when linking using a sub-select where the [id] is of type uniqueidentifier. I will demonstrate with a simple query. This query should simply link to itself but I get null values in the first column, what am I doing wrong. select x.id, c.id from Customer c left outer...
  13. don2241

    Specify number of row for each group by

    The request for the sql has been terminated but thank you for the help and responses. Have fun
  14. don2241

    Specify number of row for each group by

    Hi Is it possible to have a sql that gets x amount of rows for each group by For example: Get the 3 latest prices that we charged customers for all items sold: Customer Item Price abc 123 5.00 abc 123 6.00 abc 123 7.00 cba 321 5.00 cba...
  15. don2241

    sinqle quote prefix

    Hi [field_name] is not numeric, it is a character field. This is the error message I get when using chr(): Warning: SQL error: [unixODBC][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0204 - CHR in *LIBL type *N not found., As far as I know we should have chr() function in our libary, or might...
See more

Part and Inventory Search

Back
Top