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