Recent content by bouwob

allow_url_fopen is on. But we have had troubles with this in the past. Im thinking that my host might have some dort of proxy in place to not allow it. I can call the page and see the valix xml with no problems before and after deleting my history. I moved to a new host this weekend and I will...

Warning: simplexml_load_file(http://anothersite.com/shopping?call...seencoding=XML) [function.simplexml-load-file]: failed to open stream: Permission denied in /home/1/html/1.php on line 127 logic would say that I need to adjust directory permissions. But this will be kind of hard since I am...

that did it. It was the group by that was getting me the whole time. Thanks for the help and the heads up.

robocopy would also be of use.

I shoulnt have to ask this but my mind just doesnt want to give me an answer tonight. I have this data a b c 94070 9764 scacggwla 94070 26840 rmansdick 179741 16207 schedgllu 179741 28738 scherellu 221280 0 bbmigwels what I need returened is 94070 26840 rmansdick 179741 28738...

That worked. Why on earth does informix consider a distinct to mean everything in the select? This to me seems fairly ill-logical.

i have a set of data product, hour, sales col1,1,234 col1,1,345 col2,1,456 col2,1,345 col1,2,342 col1,2,6543 col2,2,23 col2,2,634 What I need col1, 1, 234, 345 what I am getting col1, 1, 234, 234 col1, 1, 345, 345 select distinct (hour), product, max(sales), min(sales) from table...

I am working on an email sender. The problem lies with the fact that it has to be limited to 1000 message every 10 minutes. Thinking about how to do this I decided I would create a SQL job that would call the spammer when needed. Here is the SQL declare @users table ( messageid int, userid...

Whats the point of this line then???? dvStuff.RowFilter

2.0

I am creating a windows form object that will allow me to filter on the original set. I have 2 datasets dsOriginal //the original data, used so I can pull information many times and not be forced to call the db over and over again dsNew //my filtered dataset my function so far...

rock on ESquared That solution is so much better than the round around going though sp_OE...... system functions. Thanks you so much for y9our help on this.

select 'CA' + PatientID from PatientDemographics

IS there an edit button?? I cant ever seem to find one. anyways new rewrite alter PROCEDURE StringToBase64(@String VARCHAR(4000), @Base64 VARCHAR(4000) OUTPUT) AS DECLARE @ByteArray INT, @OLEResult INT DECLARE @src varchar(255), @desc varchar(255) EXECUTE @OLEResult = sp_OACreate...

CREATE PROCEDURE StringToBase64(@String VARCHAR(4000), @Base64 VARCHAR(4000) OUTPUT) AS DECLARE @ByteArray INT, @OLEResult INT EXECUTE @OLEResult = sp_OACreate 'ScriptUtils.ByteArray', @ByteArray OUT IF @OLEResult <> 0 PRINT 'ScriptUtils.ByteArray problem' --Set the string. EXECUTE...