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!

Register Log in
  • Congratulations derfloh 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: *

  1. 10PoundBrown

    Creating a user with select/insert/update/delete only

    Hi all, I am faced with the need to create a postgres user that has only select/update/insert/delete priviledges but not be able to create users, databases, alter tables, create tables, so on and so on. Has anyone done this with postgres? When I check the help file for create user, the only...
  2. 10PoundBrown

    finding files by permission

    thanks guys, you RAWK!!
  3. 10PoundBrown

    finding files by permission

    I would love to be able to find certain files within a given directory that have a specific permision set. I tired this....but I failed (hence my post) ls -l | grep -rw------- Im sure it has something to do with special characters (-) Does anyone have any advice for me?
  4. 10PoundBrown

    Help please - cp and regex

    Thanks to all for their input. cp was dying because the list of pdf files was too great to it puked and died. This is the command I eventually came up with. find . -iname '*.pdf' -print0 | xargs -0 -n 1 cp --target-directory=temp_pdf_dir/ Thanks again to all that helped out. Your the best.
  5. 10PoundBrown

    Help please - cp and regex

    Hi all, I have a very large directory of files of differing types and I need to seperate them based on file type. For example, I need to copy all of the pdfs into a temp directory. I tried this but got an error unix-shell:# cp *.pdf temp_pdf_dir/ bash: /bin/cp: Argument list too long Can...
  6. 10PoundBrown

    Copy problem - reserved word!

    DERP!!! the answer came to me. I made the table name lower case and blammo, the thing worked. Spank my ass and call me charlie. Thanks anyway.
  7. 10PoundBrown

    Copy problem - reserved word!

    Ok, so my DBA labeled a column "ORDER" which is a SQL reserved work. Not smart. Unfortunately I cant take the time to drop the column, re-add at it with a new name and dump the data back in. This sucks. I am trying to save the MIS folks some heartache by using copy to dump a bunch...
  8. 10PoundBrown

    Mapping small Db with Visio

    Hi all and thanks for reading my post. I have an Oracle 9i Db running on a remote server (Linux) and I would like to create a visual map of the schema. Is this possible with Visio 2001?
  9. 10PoundBrown

    Date Duration Function - Excel

    TONY YOU ROCK!!! Thanks to all who helped me, you have made my morning that much better.
  10. 10PoundBrown

    Formatting with Carriage Returns -Oracle

    Hello all and thanks for reading my post. I have a table in my oracle db that is tracking user comments/notes for each record that is entered. The problem is, the notes are chock full of tabs, carriage returns, white space, commas and other punctuation. When I run a select statement on this...
  11. 10PoundBrown

    Date Duration Function - Excel

    Thanks to all, basically, if a start date is the 1st and the end date is the 10th (and for the sake of simplicity, lets assume that we are working 7 days a week) then the duration is 10 days because we work on the first but when I used the datedif function, it returns a value of 9. Thats my...
  12. 10PoundBrown

    Date Duration Function - Excel

    Hello all and thanks for reading my post. In the past I have used the DATEDIF function in excel to determine the delta of two dates. This delta is always one day less than the actual duration. This makes sense because a difference is not the same a duration :-) I was wondering if anyone new...
  13. 10PoundBrown

    Using DATEDIFF on multiple rows

    Tony, You Rock!!! Thanks for the reply, you helped me out!! 10-Pound
  14. 10PoundBrown

    Using DATEDIFF on multiple rows

    Ok, thanks for reading my post, Im a n00b and could use some help. I use the DATEDIFF function a lot two fine the delta between to dates. Example... A B C 1 start end delta 2 2-27-04 3-1-04 3 <---=DATEDIFF(A2,B2&quot;d&quot;) what I would love to do is populate...
  15. 10PoundBrown

    concatenating case statements

    WORD, yeah Im running my SQL straight into the backend so Im not touching any of the php code but thanks for the heads up.
  16. 10PoundBrown

    concatenating case statements

    Thanks for the heads up and advice swampboogie!!
  17. 10PoundBrown

    concatenating case statements

    wow, it appears all I have to do is post and the answer will come to me. when I end my case argument, I had as <column_name)>||', '|| which causes the sql to parse error, remove that and add the cat string and blammo, works fine for what I needed. Thanks.
  18. 10PoundBrown

    concatenating case statements

    Hi All, thanks for reading my post. I am using a Postgres 7.3 and I have a query that contains lots of empty values, not null really, white space (the php code isnt mine) Anyway, Im trying to format a report and I want to concatenate commas between my case statements like so select id||', '||...

Part and Inventory Search

Back
Top