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

    Union query as recordsource for subform

    Hi, Yes - as I said at the beginning of my last post, the union query is quite simple, but the queries it selects from are not. So, for completeness, the union query is like this: select workid,datestart,dateend,countdays from workquery1 UNION select workid,datestart,dateend,countdays from...
  2. anorakgirl

    Union query as recordsource for subform

    well, the union itself is quite simple, but the queries it selects from are more complicated; for example: SELECT DISTINCTROW work.workid, "" & [Forms]![frmWork]![startdate] AS datestart, work.dateto AS dateend, DateDiff("d",[Forms]![frmWork]![startdate],[dateto])+1 AS countdays FROM work...
  3. anorakgirl

    Union query as recordsource for subform

    Hi, I have written a union query, which I am able to use as the record source for a form. However if I make this form into a subform on another form, even without linking child/master fields, I get the error: you can't use a pass-through query or a non fixed column query as a record source for...
  4. anorakgirl

    cf 4.5 on windows xp

    Hi, I am trying to install Coldfusion 4.5 on Windows XP, with IIS 5 (I need to use CF 4.5 as that is what the site runs on, so I need to stay at the same version) The problem is that CF will not start; I get a message about some memory which could not be written when I start the computer, and...
  5. anorakgirl

    sum on server with group by clause?

    Ah brilliant, I had no idea you could do that! (New to Crystal Reports and just finding my way around). Sorry, I didn't think the database type was relevant, MS SQL for info. Thanks again. ~ www.anorakgirl.co.uk ~
  6. anorakgirl

    sum on server with group by clause?

    Hi, I have a master table and two child tables. I want to show a sum from one child table and detail from the other. Say I have the following tables: select product.productid, product.name, product_option.description, sum(order_line.quantity) from product, product_option, order_line where...
  7. anorakgirl

    php text download line length

    Hi, Thanks for the tips - It looks like it was notepad that was wrapping the lines. I'd thought it occured with Excel too, but realised I'd been opening it directly to notepad, then saving it somewhere, so notepad had already scuppered it before it got to Excel. I'm using a different text...
  8. anorakgirl

    php text download line length

    Hi, I have some code which takes a query and outputs the results in tab delimited format, which i require for an import into a different program. However, one of the fields is quite a bit description field (up to 4000 chars). When i do the download, some of the really long lines are wrapped...
  9. anorakgirl

    Client Network Utility Shortcut?

    great thanks! explains why I couldn't find it in my SQL server directory :) ~ www.anorakgirl.co.uk ~
  10. anorakgirl

    Client Network Utility Shortcut?

    Hi, COuld someone right-click on their Client Network Utility shortcut (Start -> Programs -> Microsoft SQL Server -> Client Network Utility) and paste the path to the utility here - I seem to have deleted all my SQL Server shortcuts and I can't find it at all, despite clicking on loads of exe...
  11. anorakgirl

    Back and Forward Buttons to hack login

    I have a PHP site which uses sessions to handle security. To login, a user enters username and password, and submits a form. The next page checks username and password with the database and if correct adds login data to the session. Logout simply clears the session data. Each page checks for...
  12. anorakgirl

    regular expression help

    Hi, Thanks for the answer - I solved my problem a different way instead as it was hurting my head! The code I used is: $loop = true; while ($loop == true) { $n = strpos ($text_content, "<!--nosearch-->"); if ($n == false) { $loop = false; } else { $m = strpos ($text_content...
  13. anorakgirl

    regular expression help

    Hi, Thanks for the suggestion. I had tried that but the problem is, there is more than one no-index section in may page: <!--nosearch--> Some Html here <!--/nosearch--> Some Html I want to index <!--nosearch--> Some Html here <!--/nosearch--> The problem is, using .*, the regular expressions...
  14. anorakgirl

    regular expression help

    I have written a PHP 'search engine' which trawls through my site and pulls out the words (+ keywords, title etc) and puts them in a database. I want to flag certain parts of the page not to be included in the search - i.e. menu's which are repeated on each page. I have identified these in the...
  15. anorakgirl

    initial capitals

    doh its that easy! i did look in the PHP manual honest, must've had my eyes shut. thanks. ~ www.anorakgirl.co.uk ~
  16. anorakgirl

    initial capitals

    does anyone know if php has a function to turn a string to initial capitals? i can't find one, but i have some directories with names like my_directory_name, and i want to list them on the page as "My Directory Name". Thanks for any suggestions! ~ www.anorakgirl.co.uk ~
  17. anorakgirl

    list by first letter performance help?

    don't worry about the full query - i've tested the simplified version directly in the Query Analyser on my local computer (still 12 seconds). And (its a coldfusion app) I've written a little page to test the simplified query on the server too (12 seconds execution time for the query as reported...
  18. anorakgirl

    list by first letter performance help?

    hmm, time to have (yet another) word with the hosting company then... thanks ~ www.anorakgirl.co.uk ~
  19. anorakgirl

    list by first letter performance help?

    it takes about 12 seconds both on my laptop and the production server (it is a bit more complicated than that though, with a couple of joins and other where clauses). should it be faster than that then? i'm not used to MS SQL server, usually use PostgreSQL or MySQL. donutman, thanks. I might...
  20. anorakgirl

    list by first letter performance help?

    Hi, I have a table with just under 50,000 records in it. I've done an interface for browsing alphabetically, which basically builds the query: select * from mytable where myfield like 'A%' But its a bit slow (not surprisingly with that many records!) I'm trying to speed it up a bit. I tried...

Part and Inventory Search

Back
Top