Search results for query: *

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

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

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

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

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 ~

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

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

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

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

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

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

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

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

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

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

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 ~

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

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

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

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