Search results for query: *

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

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

I come from a background of using mysql and phpadmin. In phpadmin you have the ability to export your data in sql format including tables, SP's, functions, data, etc. Is there a way for me to do this in MS SQL server management studio? I can export the database but the only option it seems to...

I am using an asp.net user control. The control contains 2 divs that need to be shown/hidden. I cannot use getElementbyID since the dive name is auto generated for each control. This is the HTML in the user control <a href="#" onclick="hideFilter(this);return false;"...

I have a user control that requires a call to the database with veriables. <uc1:filter id="list" runat="server" DropDownName="Mylist" FilterStoredProc="<% string[] tmpData = Session["userInfo"].ToString().Split(','); Response.Write(string.Format("exec sp_GetMyList '{0}'", tmpData[2])); %>" >...

I have 3 tables that I need to pull sql for. I only need the data, not the table structures or rights. How do I get this information from only 3 tables and export it to a .sql file? tia

So I am using a function that was built based on this thread thread732-1352819 in my newest SP I am getting a data field that looks similer to this "1,56786789|2,787667976|3,658765666" every pipe is a row, every comma is a column. I have declared this tables in my SP declare @tempdat...

I have a service that does not restart successfully maybe once a month. When checking out the event viewer I see a message that looks like this Maximum application restarts exceeded for "perl.exe program.bat", max = 0 I have looked online but it has been of very little help. What exactly...

Error 7 Cannot implicitly convert type 'service.PL.Service1' to 'System.ServiceProcess.ServiceBase' ServiceBase[] serviceToRun; serviceToRun = new ServiceBase[] { new PL.Service1() }; now PL.Service1 is a webservice. How do I...

I have this url http://localhost:34509/HelpDox/Page.aspx?messageID=124 and then this chunk of code in the page_load event if (Request.Form.Get("messageID") != null) { this.lblMessageID.Text = Request.Form.Get("messageID").ToString()...

SELECT distinct (t.Domain), count(t.Domain) as TOTAL, sum(case when t.status = 'Succeeded' then 1 else 0 end) as SUCCEEDED FROM table1 t WHERE t.ID='SOMETHING' group by t.Domain, t.status Domain/total/Success AR 1 0 AR 1 1 BR 1 0 HOMEOFFICE 1 0 HOMEOFFICE 2 0 HOMEOFFICE 4 0 HOMEOFFICE 18 18...

I have the following query SELECT t.domain, t.status FROM T1 t WHERE t.ID='something' which gives me a result set that looks somewhat like this HOMEOFFICE Succeeded HOMEOFFICE Succeeded HOMEOFFICE Succeeded HOMEOFFICE Succeeded HOMEOFFICE Succeeded HOMEOFFICE Succeeded HOMEOFFICE Succeeded...

I need to run a query that accesses 2 different databases. This normaly would be a simple query with full name values but the databases happen to be on 2 different boxes. my first though was grab the data off of 1 then ship it to the other via code but I end up getting stack overload errors...