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

    Thoughts about Phython

    I suspect anything can be decompiled. Python ticks the rest of your boxes.
  2. StoneDeCroze

    Help ! -- AttributeError: type object 'super' has no attribute 'len'

    Push and Pop ... Lists do this already or am I missing something?
  3. StoneDeCroze

    Python scheduler - Basic

    try the standard module sched.
  4. StoneDeCroze

    readline() and specifying line number

    Have you tried reading in the entire file? Not practical for massive files I know... f = file('filename', 'r').readlines() print f[linenumber] you can also iterate over the file line by line: for l in f: print l May use lots of memory if you have a BIG file - but it sure is quick.
  5. StoneDeCroze

    Identify a string pattern

    from time import strptime str = 'jdhgjkdfhgjsdhgklhsdljSF Jun 23 2006' try: MyDate = strptime(str[-11:], '%b %d %Y') ValidDate = 1 except: ValidDate = 0 if str[-14:-12]=='SF' and ValidDate: print 'string is of correct format' else: print 'string is NOT correct' Hope this works for you. Peter
  6. StoneDeCroze

    How to Extract Data from MYSQL in XML format

    I would like to use PHP to extract data from MYSQL and have it stored in XML format in much the same way as a dot net dataset stored data from a database. The reason being I want to use XSLT to format my data for display. Does anyone know if this is possible and if so could they point me in...
  7. StoneDeCroze

    INSERT Performance

    Hi All, I have two tables and I want to insert data from them into a third table. Question: Am I better to write two inserts statements e.g. INSERT INTO table3 (field1, field2) SELECT field1, field2 FROM table1 and INSERT INTO table3 (field1, field2) SELECT field1, field2 FROM table2 OR one...
  8. StoneDeCroze

    Which of these is faster?

    Hi Guys, Anyone know whis of these will be faster: @ASWN is a DECIMAL(18,6) @ID is an INT IF @ASWN > 0 UPDATE table SET field1=@ASWN WHERE ID=@ID or UPDATE table SET field1=@ASWN WHERE ID=@ID AND @ASWN > 0 Logically they are the same: The first results in the execution of one or two...
  9. StoneDeCroze

    Performance Boost (using tamp tables)

    Y'all prolly know this, but having just found out for myself I thought I'd share a performance snippet. I needed to create a running total - found the SQL for that okay - but the performance was pants, so with a bit of fiddling ... My Tip (works for me anyway). 1) SELECT the data into a temp...
  10. StoneDeCroze

    Client Data and Transaction DDL

    Hi all, For a purple star can anyone tell me if there is a public DTD for describing a Client's information including transaction history (cash and stocks)? I really don't want to go re-inventing the wheel. Kind regards Peter
  11. StoneDeCroze

    Permission to open view not table

    Hi Nigel, Thanks for your help - it did start me thinking. Anyway I have now found the problem or should I say "Microsoft design feature". http://support.microsoft.com/default.aspx?scid=kb;en-us;810474 My tag line is now: MS Patches and Service packs - they do more than fix bugs.
  12. StoneDeCroze

    Permission to open view not table

    We used to run SQL7. The tables were in one DB and there were views in another. I didn't grant any access to the DB with the tables in it and all was well with the world (and my security). We have moved to SQL2000 and if I employ the same scenario -the views no longer work. For the views to...
  13. StoneDeCroze

    Permission to open view not table

    Hi All, Is it possible to set up permissions so a user can open and see data in a view, but not open and see data in the underlying tables? I have tried denying access to the tables and granting to the views, but this doesn't work. The overall effect is denial. If it can be done, can someone...
  14. StoneDeCroze

    In VB - Format(value,"0000000") - how to do it in SQL?

    Quicker: RIGHT('000000'+@vTelNo, 7)
  15. StoneDeCroze

    Security on Win2k

    Win2k? Brain Haemorrhage. I mean SQL 2000. Sorry for the confusion, Peter
  16. StoneDeCroze

    Security on Win2k

    Hi All, I would like users to only be able to view data through views and NOT directly from the underlying tables as I want to filter out certain records. However, if I set denydatareader on the table the users are get Access Denied when they open the views (even if they have read permissions...
  17. StoneDeCroze

    How to Read CSV files with Python2.3

    Hi there, I worked on the basis that the file looked fixed width: f = file('d:\\tek.txt', 'r').readlines() for l in f: x, y, a, b = l[0:11], l[12:26], l[27:36], l[37:-1] print x, y, a, b I hope this helps (not altogether sure I have the right end of the problem).
  18. StoneDeCroze

    alterdatase to change sort order

    doh, sorry - mixed up myself there. Attach the SQL7 DB's to the 2000 server. Change the default DB collation (sp_dboption) then run the script to get the ALTER statements and then run the ALTER statements. It's 99% good - where it falls over is if you have a relationship between two tables...
  19. StoneDeCroze

    alterdatase to change sort order

    alter the collation on the tables 1st: ALTER TABLE [TableName] ALTER COLUMN [ColumnName] [varchar] (50) COLLATE Latin1_General_CI_AS Here's a script to generate all the alter statements: SELECT 'ALTER TABLE ['+TABLE_NAME+'] ALTER COLUMN ['+COLUMN_NAME+'] ['+DATA_TYPE+']...
  20. StoneDeCroze

    How to Read CSV files with Python2.3

    can you supply a couple of lines of the CSV? also how big is the CSV?

Part and Inventory Search

Back
Top