Search results for query: *

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...

I recently came across a problem where I need to return data in base64 format. I would like to do this on the SQL end so I do not have to update the large number of WebPages that use a bind to a data grid. I have been scouring the web for 2 days now and have yet to find anything of use. Has...

I have a generic gridview that is used in many reports. For it to work I bind a datatable to the gridview. The problem I am having is that the columns that hold numbers sort by string instead of int. I cannot chage the control itself since many different reports with many different types of...

I cant seem to find this information anywhere. 1. How to I specify what directory should open when the browse button is hit? Does it work with remote servers? 2. How do I specify what files show up in the browse dialog. If I only want text files, how do I make it so the browse dialog only...

I needed a way to have a browse button bring back remote folder path information. That led me to try using an “input (file)” control, but I just want the path information and not have a file uploaded. Whatever folder or file they choose, I need to shoot the path information to a web service. So...

This allows me to script a single table or SP, but does not allow me to get everything at once. I have about 35 tables and over 100 SP's that will need to come out this way and it will take most of the day to do it 1 by 1. Is there any better solution for getting everything at once?