Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bouwob
  • Order by date
  1. bouwob

    failed to open stream: Permission denied

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

    failed to open stream: Permission denied

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

    max query

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

    Using xp_cmdshell to copy files

    robocopy would also be of use.
  5. bouwob

    max query

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

    help with query

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

    help with query

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

    xp_cmdshell permissions issues

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

    filtering a listbox

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

    filtering a listbox

    2.0
  11. bouwob

    filtering a listbox

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

    casting a string to base64

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

    Modifying data in a table

    select 'CA' + PatientID from PatientDemographics
  14. bouwob

    casting a string to base64

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

    casting a string to base64

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

    casting a string to base64

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

    gridview ordering

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

    &lt;asp:FileUpload questions

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

    Creating a browse button

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

    Mass SQL export

    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?

Part and Inventory Search

Back
Top