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

    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...
  5. 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...
  6. 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...
  7. 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...
  8. don2241

    sinqle quote prefix

    Hi, I am trying to have a sinqle quote as a prefix from a select statement. My data in the database might look like: 000123456 In my select statement I want to be able to have code that would output the above data like: '000123456 I have tried: chr(39)|| [field name] but that did not work...
  9. don2241

    UPDATE linking other tables

    Hi! I am trying to do a simple update function in mySql. NOTE. I am using version 3.0.9.4-beta I have 2 tables: Items and Sales_details I want to update a field called >Sales_value< in Sales_details table using value from Items called >Sell< times (*) >Sales_qty< from Sales_details table...
  10. don2241

    Report using an SQL statment

    Hi! I have been looking in Help file to find out how to use a Report to view/print using an SQL statment as my source but I did not find what I was looking for. Basically what I'm trying to do is instead of using a statment like this: DoCmd.OpenReport "myReport", acViewPreview I need to have...
  11. don2241

    Loop through columns on a access table

    Hi! Problem: I am trying to loop through columns on each row of a database table using VB-code in access Table format P_ID 1 2 3 4 5 ------------------------ item1 A B C D item2 A B item3 A B C item4 A B C D E item5 item6 A How do I loop through...
  12. don2241

    Keystroke counter

    Hi! I'm trying to have a counter that counts the number of keystrokes the user is making in a text field, in a seperate textbox i.e user press H textbox is showing 1 user press e textbox is showing 2 user press l textbox is showing 3 user press l textbox is...
  13. don2241

    Popup form

    I'm trying to do the simplest thing but I cannot get it to work. I have a click function that when its clicked have a popup form or a new form being displayed where I then will provide data to be stored in table. After consulting the popup help file in access I am trying this bit of code...
  14. don2241

    lookup value to display on a report

    Hi! Sorry about the question with the same name, I clicked on the wrong button. I have a report that displays data from a query. One of the columns displays a checkbox. I want to lookup a value in a different query and display a value IF THE CHECKBOX IS FALSE (not ticked) under the Managers...
  15. don2241

    Comparing two arrays

    Hi! I'm not to familiar with the VB syntax to be able to do what I want. I have two dynamic arrays of type string that contains a word in a cell. I want to compare each cell in one array to each cell in another array. If there is a match I'm going to do something. I've tried to write a...
  16. don2241

    Get character from a string

    Hi! I'm trying to capture characters in a string to build words Ex. This is a string example: Washer Tap Body Fiber 20mm Fulway I want to get Washer to be able to put into an array(0) and then Tap to put in the same array(1) and Body at array(2) position and so on... I'v been working on...
  17. don2241

    Take away spaces in a string

    Hi! How can I trim a string to take away spaces. For example: &quot;000 000 000 000&quot; I want it to look like &quot;000000000000&quot; The Trim function only takes away spaces in the begining and the end of the string. Thanks /M.
  18. don2241

    Finding numbers in a string

    Hi! If I have a string that looks something like this: abcd12345efgh How do I find the number values from the string. Keep in mind that the string is dynamic, next time the string could look like: &quot;sdfjl sl kd432424323sl flsj&quot; although the numbers are always together. I'm looking...
  19. don2241

    Passing multiply parameters to a function in a module

    Hi! I'm trying to pass many parameters to a function, this is a snipplet of my code: Dim prod as Integer Dim sub1 as Integer Dim sub2 as Integer prod = 1 sub1 = 2 sub2 = 3 'I get my error message on this line saying: &quot; = Expected&quot; myFunction (prod, sub1, sub2) And my code in my...

Part and Inventory Search

Back
Top