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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Hi!
How can I trim a string to take away spaces.
For example: "000 000 000 000" I want it to look like "000000000000"
The Trim function only takes away spaces in the begining and the end of the string.
Thanks
/M.
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: "sdfjl sl kd432424323sl flsj" although the numbers are always together.
I'm looking...
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: " = Expected"
myFunction (prod, sub1, sub2)
And my code in my...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.